The URL can be used to link to this page

Home My WebLink About07-2013 Departmental Financial ReportPeriod Ending: Issued By: July 31, 2013 Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents 2 - 2 Narrative 3 - 8 Summaries 9-30 General Fund 31 -62 Special Revenue Funds 63-75 Debt Service /Capital Project Funds 76-103 Enterprise Funds 104-108 Internal Service Funds 109-110 Trust Funds 111 -130 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff Kathryn Roos South Bend Common Council Controller Mark Neal Deputy City Controller John Murphy City Finance Director Rahman Johnson Financial Specialist Senior Cecil Eastman Department Heads Fiscal Officers Narrative, July 2013 Description of Monthly Departmental Financial Report Beginning with the March 2013 fiscal period, the City of South Bend has developed the attached Monthly Departmental Financial Report. The purpose of the report is to provide current year financial information for each City fund and individual departments within the General Fund in a condensed format. Information is provided for revenue, expenditures, encumbrances, cash balances and staffing levels. Also included in this report are text boxes that allow departmental fiscal officers to provide an explanation of significant expenditure and staffing variances and spending on major capital projects. Departmental fiscal officers are asked to complete the monthly financial reports ( "blue sheets ") for their funds and General Fund departments no later than the 20th of the month following the reporting period. The staff of the Department of Administration & Finance is then asked to summarize the information and publish 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 including the Monthly Financial Report, Controller's Cash Report, Gateway City and Town Annual Report (CTAR), and 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 July 31, 2013, total revenue was $156,763,388, 52% of estimated revenue. As of July 31, 2012 total revenue received was $162,438,364. Property taxes received in June were less than anticipated and July's receipts of over $15.6 million were less than the expected $16.8 million monthly average. Individual elements of revenue are received at various times of the year (based on State and other distribution schedules) and it is the job of all City fiscal staff to monitor revenue for timely collection. The University of Notre Dame's contribution of $275K and Parks revenue running at higher summer levels were offset by interest income that was significantly lower than expected in a number of funds. As of July 31, 2013, total expenditures were $157,814,494 and outstanding encumbrances were $38,613,021, a total of $196,427,515 which represents 55% of the amended expenditure budget, less than the expected level of 58% after seven months' activity. If encumbrances were excluded, expenditures were 44% of the amended expenditure budget at the end of the period. Encumbrances represent placeholders for future expenditures anticipated through the rest of the fiscal year but have not yet been incurred. By comparison, total expenditures were $163,049,180 as of July 31, 2012. In July, $1.46 million in semi - annual bond payments made by the City and higher Parks expenditures during their busiest season were offset by generally less- than - anticipated expenditures elsewhere. 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. Page 2 City of South Bend Monthly Department Financial Report REVENUE SUMMARY July 31, 2013 City Funds 1,148,035 73,197 541,437 515,521 606,598 47% General Fund 63,932,287 2,966,001 35,296,655 35,870,591 28,635,632 55% Special Revenue 5,257,701 585,350 3,026,085 2,821,432 2,231,616 58% 102 Rainy Day 52,000 1,509 20,050 30,232 31,950 39% 201 Parks & Recreation 12,362,329 650,471 6,758,774 7,009,206 5,603,555 55% 202 Motor Vehicle Highway 8,691,971 1,606,089 6,573,726 4,772,703 2,118,245 76% 203 Recreation Nonreverting 1,636,943 142,844 729,443 725,348 907,500 45% 209 Studebaker - Oliver Reverting Grants 5,000 190 2,520 3,976 2,480 50% 210 Economic Development State Grants 1,624,187 175 165,075 201,102 1,459,112 10% 211 Community & Economic Development Admn. 2,341,808 575,020 1,637,764 1,320,296 704,044 70% 212 Community & Economic Development 8,800,305 112,624 2,628,509 2,442,734 6,171,796 30% 216 Police State Seizures 35,900 25 9,275 14,506 26,625 26% 217 Gift, Donation, Bequest 17,011 12 11,419 17,213 5,592 67% 218 Police Curfew Violations 1,025 140 314 267 711 31% 220 Law Enforcement Continuing Education 347,000 20,228 117,541 180,543 229,459 34% 227 Loss Recovery 3,829,857 3,799,307 3,814,973 15,796 14,884 100% 249 Public Safety LOIT 5,900,386 491,431 4,002,936 4,248,738 1,897,450 68% 251 Local Roads & Streets 1,061,143 92,567 638,133 665,471 423,010 60% 252 Excess Welfare Distribution 0 0 3 5,109 -3 0% 258 Human Rights Federal Grant 237,250 127 45,134 87,188 192,116 19% 271 Eastrace Waterway 100 3 33 79 67 33% 273 Morris PAC / Palais Royale Marketing 8,100 785 4,663 1,186 3,437 58% 280 Police Block Grants 185,300 1 9 660 185,291 0% 281 Economic Develop. Commission - Revenue Bonds 100 5 63 95 37 63% 289 HAZMAT 3,000 3 16,744 9 - 13,744 558% 291 Indiana River Rescue 31,500 578 42,963 26,273 - 11,463 136% 292 Police Grants 110,000 38,532 38,532 97,000 71,468 35% 294 Regional Police Academy 28,500 14 19,732 12,458 8,768 69% 295 COPS MORE Grant 41,600 819 6,705 22,314 34,895 16% 299 Police Federal Drug Enforcement 102,000 64 70,988 50,120 31,012 70% 404 County Option Income Tax 8,732,872 696,926 4,918,728 5,998,986 3,814,144 56% 408 Economic Development Income Tax 8,732,012 683,245 5,217,727 6,041,415 3,514,285 60% 410 Urban Development Action Grant 70,104 188 3,289 4,051 66,815 5% 655 Project Releaf 431,700 36,198 253,541 252,616 178,160 59% 705 Police K -9 Unit 2,000 1 6 8 1,994 0% Special Revenue Total 65,423,003 8,950,121 37,749,312 34,247,699 27,673,691 58% City Debt Service 313 Football Hall of Fame Debt Service 1,257,789 5,956 769,174 722,286 488,615 61% City Debt Service Total 1,257,789 5,956 769,174 722,286 488,615 61% Capital Project 288 Emergency Medical Services Capital Improv. 3,730,084 230,331 1,686,181 1,532,640 2,043,903 45% 377 Professional Sports Development 687,801 36,362 377,089 837,271 310,712 55% 401 Coveleski Stadium Capital 500 5 62 271 438 12% 403 Zoo Endowment 2,900 9 114 13,143 2,786 4% 405 Park Nonreverting Capital 203,500 5,925 17,311 16,559 186,189 9% 406 Cumulative Capital Development 614,325 3,966 302,432 332,782 311,893 49% 407 Cumulative Capital Improvement 434,090 150,001 279,193 132,331 154,897 64% 412 Major Moves Construction 528,662 1,283 255,687 73,893 272,975 48% 416 Morris Performing Arts Center Capital 101,500 4,063 65,685 60,471 35,815 65% 434 Community Revitalization Enhancement District 651,000 38 379 713 650,621 0% 450 Palais Royale Historic Preservation 16,125 2,733 8,258 7,100 7,867 51% 677 Football Hall of Fame Capital 4,500 127 1,711 110,207 2,789 38% Capital Project Total 6,974,987 434,841 2,994,103 3,117,382 3,980,884 43% Enterprise 600 Consolidated Building Department 1,148,035 73,197 541,437 515,521 606,598 47% 601 Parking Garages 1,146,812 116,634 589,764 589,071 557,048 51% 610 Solid Waste Operations 5,257,701 585,350 3,026,085 2,821,432 2,231,616 58% 611 Solid Waste Capital 784,261 315,937 830,457 135,206 - 46,196 106% 620 Water Works Operations 14,687,748 1,211,136 8,210,571 8,312,224 6,477,177 56% Page 3 City of South Bend Monthly Department Financial Report REVENUE SUMMARY July 31, 2013 City Funs Enterp 622 Water Works Capital 14,000 702 9,630 963,838 4,370 69% 623 Water Works Bond Capital 18,000 813 12,489 8,347,301 5,511 69% 624 Water Works Customer Deposit 6,100 252 3,269 4,904 2,831 54% 625 Water Works Sinking 2,108,381 171,124 1,197,535 944,211 910,846 57% 626 Water Works Bond Reserve 313,509 17,714 165,047 756,750 148,462 53% 629 Water Works Reserve Operations & Maintenance 52,801 356 49,996 128,376 2,805 95% 640 Sewer Repair Insurance 549,200 45,561 321,489 319,638 227,711 59% 641 Sewage Works Operations 33,131,547 2,695,827 18,186,198 18,251,305 14,945,349 55% 642 Sewage Works Capital 4,560,000 1,296 19,483 1,947,584 4,540,517 0% 643 Sewage Works Reserve Operations & Maint. 127,098 577 207,709 11,129 - 80,611 163% 645 Sewer Bond 2004/2006 0 0 0 0 0 0% 647 Sewer Bond 2007 0 1 36 171 -36 0% 649 Sewage Sinking 8,234,756 774,947 5,585,553 4,806,237 2,649,203 68% 650 Clay Sewage 0 0 2 2 -2 0% 651 Sewage Bond 2007B 0 1 65 515 -65 0% 653 Sewage Debt Service Reserve 1,805,314 0 14,096 304,540 1,791,218 1% 658 Sewer Bond 2010 0 5 206 3,975 -206 0% 659 Sewer Bond 2011 60,000 1,518 21,633 69,673 38,367 36% 661 Sewer Bond 2012 60,000 4,011 42,119 0 17,881 70% 663 Sewer Bond 2013 21,200,000 0 0 0 21,200,000 0% 664 2013A Cost of Issuance Fund 0 2 85,742 0 - 85,742 0% 670 Century Center 2,935,706 162,697 2,149,037 2,077,711 786,669 73% 671 Century Center Capital 100,500 0 100,135 1,444,293 365 100% Enterprise Total 98,301,469 6,179,657 41,369,782 52,755,607 56,931,687 42% Internal Service 222 Central Services 7,922,703 612,324 4,369,277 4,046,491 3,553,426 55% 226 Liability Insurance 3,033,076 250,040 1,756,268 1,734,125 1,276,808 58% 278 Take Home Vehicle Police 129,400 9,399 72,061 74,446 57,339 56% 711 Self- Funded Employee Benefits 12,188,900 1,002,172 7,231,204 6,565,364 4,957,696 59% 713 Unemployment Compensation 341,450 16,029 172,684 160,453 168,766 51% Internal Service Total 23,615,529 1,889,963 13,601,495 12,580,878 10,014,034 58% Trust& Agency 701 Firefighters Pension 5,040,279 0 2,519,281 2,619,159 2,520,998 50% 702 Police Pension 5,873,697 19 2,936,170 3,373,007 2,937,527 50% Trust & Agency Total 10,913,976 19 5,455,451 5,992,166 5,458,525 50% City Funds Total 270,419,040 20,426,559 137,235,971 145,286,609 133,183,069 51% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIFRevenue - Airport 13,940,252 82,267 9,814,134 6,424,214 4,126,118 70% 420 Tax Incremental Financing (TIF) - Downtown 4,663,254 35,446 2,214,515 3,354,607 2,448,739 47% 422 TIF - West Washington 444,000 81 265,628 228,262 178,372 60% 425 Redevelopment Retail & Leighton Plaza 156,905 10,322 96,725 74,666 60,180 62% 426 TIF - Central Medical Service Area 1,730,000 624 621,618 888,218 1,108,382 36% 429 TIF - Northeast Development 823,000 420 437,157 696,439 385,843 53% 430 TIF - Southside Development #1 1,840,000 945 1,393,716 2,752,130 446,284 76% 431 TIF - Southside Development #2 0 0 0 2,329 0 0% 432 TIF - Southside Development #3 1,346,000 971 672,230 19,991 673,770 50% 435 TIF - Douglas Road 321,000 25 164,438 265,275 156,562 51% 436 TIF - Northeast Residential 2,460,000 449 1,346,179 1,258,499 1,113,821 55% Tax Increment Financing Total 27,724,411 131,550 17,026,340 15,964,630 10,698,071 61% Redevelopment 433 Redevelopment General 150 5 73 120 77 49% 439 Certified Technology Park 1,448,074 397 1,450,593 2,429 -2,519 100% 454 Airport Urban Enterprise Zone 1,000 66 876 38,143 124 88% 619 Blackthorn Golf Course Operations 1,747,379 226,188 1,041,428 1,128,340 705,951 60% Redevelopment Total 3,196,603 226,656 2,492,970 1,169,032 703,633 78% Debt Service Page 4 City of South Bend Monthly Department Financial Report REVENUE SUMMARY July 31, 2013 Redevelc Debt S 314 Redevelopment Bond - Central Development 0 0 0 2,910 0 0% 315 Redevelopment Bond - Airport Taxable 5,000 182 2,423 4,117 2,577 48% 317 Coveleski Debt Service Reserve 3,500 88 1,171 1,769 2,329 33% 319 Redevelopment Bond - Blackthorn Golf 50 0 464 3,468 -414 928% 328 Redevelopment Bond - Palais Royale 6,000 304 4,049 5,829 1,951 67% Debt Service Total 14,550 574 8,107 18,093 6,443 56% Redevelopment Commission Controlled Funds Total _A 30,935,564 1 358,780 19,527,417_ 17,151,755 11,408,147 _ 63% Grand Total 301,354,604 20,785,339 1569763,388 16294389364 14495919216 52% Page 5 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY July 31, 2013 City Funds General Fund 101 -0101 Mayor's Office 694,229 53,396 364,708 380,752 274 329,248 53% 101 - 0104311 Call Center 320,102 22,094 137,008 0 1,695 181,400 43% 101 -0201 City Clerk 365,170 25,395 182,783 180,003 14,166 168,221 54% 101 -0301 Common Council 515,397 26,512 223,088 228,286 189 292,120 43% 101 -0401 Administration & Finance 1,877,728 136,610 1,026,167 871,089 49,558 802,004 57% 101 -0404 Morris Performing Arts Center 1,033,800 80,811 542,447 521,136 53,447 437,906 58% 101 -0405 Palais Royale 492,830 37,204 227,481 189,456 56,920 208,428 58% 101 -0501 Legal Department 1,028,466 71,415 464,507 458,668 8,000 555,959 46% 101 -0600 Energy Office 0 0 54,256 297,364 0 - 54,256 0% 101 -0602 Engineering 1,393,561 116,507 743,443 972,048 43,773 606,345 56% 101 -0607 Traffic & Lighting 111,815 0 109,536 462,796 0 2,279 98% 101 -0801 Police Department 23,795,376 1,733,157 12,598,920 14,084,869 126,458 11,069,998 53% 101 -0802 Communications Center 2,326,560 159,503 1,162,374 1,133,925 0 1,164,186 50% 101 -0805 Public Safety LOIT - Police 3,968,567 282,288 2,284,755 1,786,737 0 1,683,812 58% 101 -0901 Fire Department 20,567,695 1,441,160 11,469,301 11,882,692 221,591 8,876,803 57% 101 -0905 Public Safety LOIT - Fire 3,133,190 466,683 2,033,279 1,378,321 0 1,099,911 65% 101 -1008 Human Rights 346,237 27,355 179,964 150,345 8,994 157,279 55% 101 -1201 Code Enforcement 2,186,969 145,251 890,471 846,118 290,540 1,005,958 54% 101 -1203 Code Hearing Officer 40,000 7,500 19,978 23,578 7,500 12,522 69% 101 -1204 Junk Vehicle 65,829 -1,874 28,203 37,304 2,857 34,769 47% 101 -1205 Unsafe Building 107,684 2,360 17,107 54,354 28,525 62,052 42% 101 -1207 Animal Control 596,111 51,246 329,727 296,794 22,265 244,119 59% General Fund Total 64,967,316 4,884,574 35,089,502 36,236,637 936,753 28,941,062 55% Special Revenue 102 Rainy Day 0 0 0 0 0 0 0% 201 Parks & Recreation 12,892,463 1,075,566 6,986,670 6,918,269 526,210 5,379,583 58% 202 Motor Vehicle Highway 9,066,496 588,107 3,807,998 3,731,114 1,331,748 3,926,750 57% 203 Recreation Nonreverting 1,560,777 168,231 520,878 609,110 98,567 941,332 40% 209 Studebaker - Oliver Reverting Grants 1,000,000 0 0 162,602 0 1,000,000 0% 210 Economic Development State Grants 1,260,777 18,003 102,639 115,332 0 1,158,138 8% 211 Community& Economic Development Admn. 2,354,331 166,317 1,250,819 1,184,521 16,805 1,086,707 54% 212 Community & Economic Development 8,957,256 211,115 2,738,756 2,499,551 2,433,441 3,785,059 58% 216 Police State Seizures 45,900 0 10,500 6,197 950 34,450 25% 217 Gift, Donation, Bequest 0 1,310 1,310 3,007 0 -1,310 0% 218 Police Curfew Violations 1,000 0 0 0 0 1,000 0% 220 Law Enforcement Continuing Education 478,131 11,575 189,289 205,654 105,037 183,805 62% 227 Loss Recovery 526,185 27,550 64,938 148,532 74,294 386,953 26% 249 Public Safety LOIT 7,101,757 1,775,439 5,344,501 3,984,642 0 1,757,256 75% 251 Local Roads & Streets 1,235,924 138,450 481,184 288,002 450,974 303,766 75% 252 Excess Welfare Distribution 0 0 0 1,630,070 0 0 0% 258 Human Rights Federal Grant 228,930 20,799 107,420 96,034 11,154 110,356 52% 271 Eastrace Waterway 346 0 0 8,009 346 0 100% 273 Morris PAC / Palais Royale Marketing 10,149 1,342 5,391 0 0 4,759 53% 280 Police Block Grants 185,000 0 0 124,539 0 185,000 0% 281 Economic Develop. Commission - Revenue Bonds 27,102 0 0 0 0 27,102 0% 289 HAZMAT 3,000 0 3,237 0 0 -237 108% 291 Indiana River Rescue 51,666 9,757 76,828 13,521 5,421 - 30,583 159% 292 Police Grants 110,000 0 36,911 0 0 73,089 34% 294 Regional Police Academy 28,500 130 17,252 8,467 0 11,248 61% 295 COPS MORE Grant 41,980 1,114 8,108 30,849 612 33,260 21% 299 Police Federal Drug Enforcement 188,573 0 99,342 62,467 8,475 80,756 57% 404 County Option Income Tax 9,258,915 933,477 6,083,987 6,346,702 419,538 2,755,390 70% 408 Economic Development Income Tax 8,933,379 2,914,570 6,749,278 5,341,442 490,938 1,693,163 81% 410 Urban Development Action Grant 268,146 0 0 200,451 0 268,146 0% 655 Project Releaf 432,065 13,645 289,132 255,126 365 142,568 67% 705 Police K -9 Unit 2,000 0 0 0 0 2,000 0% Special Revenue Total 66,250,748 8,076,498 34,976,369 33,974,211 5,974,875 25,299,504 62% City Debt Service 313 Football Hall of Fame Debt Service 1,268,000 634,500 1,268,000 1,329,715 0 0 100% City Debt Service Total 1,268,000 634,500 1,268,000 1,329,715 0 0 100% Capital Project 288 Emergency Medical Services Capital Improv. 4,581,267 322,486 2,801,098 574,052 2,268,021 - 487,852 111% 377 Professional Sports Development 876,671 388,123 876,470 1,161,747 0 201 100% 401 Coveleski Stadium Capital 3,540 0 0 38,447 3,540 0 100% 403 Zoo Endowment 0 0 0 0 0 0 0% 405 Park Nonreverting Capital 217,316 7,275 72,449 105,851 26,048 118,820 45% 406 Cumulative Capital Development 911,220 42 353,092 231,042 0 558,129 39% 407 Cumulative Capital Improvement 367,575 182,700 367,575 402,277 0 0 100% 412 Major Moves Construction 3,395,846 123,222 1,015,738 584,601 1,397,548 982,559 71% 416 Morris Performing Arts Center Capital 72,666 10,691 30,429 163,986 21,783 20,454 72% Page 6 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY July 31, 2013 City Funds Capital Prc 434 Community Revitalization Enhancement District 873,949 0 36,975 878,554 0 836,975 4% 450 Palais Royale Historic Preservation 0 0 0 0 0 0 0% 677 Football Hall of Fame Capital 179,322 13,587 39,018 260,832 0 140,304 22% Capital Project Total 11,479,372 1,048,126 5,592,843 4,401,391 3,716,941 2,169,589 81% Enterprise 668,815 41,972 177,842 395,094 165,723 325,250 51% 600 Consolidated Building Department 1,148,152 77,953 563,731 501,722 15,720 568,701 50% 601 Parking Garages 1,129,839 97,234 571,622 677,273 192,873 365,344 68% 610 Solid Waste Operations 5,565,984 786,291 3,619,382 2,940,145 539,542 1,407,060 75% 611 Solid Waste Capital 784,061 188,809 513,511 139,299 52,750 217,800 72% 620 Water Works Operations 14,795,947 1,247,338 7,607,533 7,583,514 323,700 6,864,714 54% 622 Water Works Capital 1,216,792 31,788 238,977 871,524 401,270 576,545 53% 623 Water Works Bond Capital 4,826,536 295,145 1,480,329 1,417,339 3,770,873 - 424,666 109% 624 Water Works Customer Deposit 4,000 252 3,309 4,904 0 691 83% 625 Water Works Sinking 2,108,381 471 410,514 353,925 0 1,697,867 19% 626 Water Works Bond Reserve 0 0 0 0 0 0 0% 629 Water Works Reserve Operations & Maintenance 7,500 356 4,695 6,950 0 2,805 63% 640 Sewer Repair Insurance 555,844 27,995 216,103 178,383 13,852 325,889 41% 641 Sewage Works Operations 34,982,238 2,272,137 16,710,954 16,427,418 2,385,388 15,885,896 55% 642 Sewage Works Capital 11,774,073 322,960 2,026,694 2,817,811 7,102,840 2,644,539 78% 643 Sewage Works Reserve Operations & Maint. 18,000 577 7,413 70,632 0 10,587 41% 645 Sewer Bond 2004/2006 0 0 0 0 0 0 0% 647 Sewer Bond 2007 19,017 0 13,616 44,986 5,401 1 100% 649 Sewage Sinking 8,723,149 300 2,663,015 1,783,238 0 6,060,134 31% 650 Clay Sewage 0 0 0 0 0 0 0% 651 Sewage Bond 2007B 39,512 0 35,983 185,183 0 3,529 91% 653 Sewage Debt Service Reserve 0 0 2,438,087 0 0 - 2,438,087 0% 658 Sewer Bond 2010 112,089 0 99,796 1,733,560 11,148 1,145 99% 659 Sewer Bond 2011 10,696,720 14,334 1,560,622 1,951,906 573,080 8,563,018 20% 661 Sewer Bond 2012 19,160,000 978,383 1,576,365 0 3,709,176 13,874,459 28% 663 Sewer Bond 2013 2,100,000 0 0 0 0 2,100,000 0% 664 2013A Cost of Issuance Fund 0 0 81,064 0 0 - 81,064 0% 670 Century Center 2,935,707 57,773 1,460,148 2,740,167 0 1,475,559 50% 671 Century Center Capital 0 0 0 155,825 0 0 0% Enterprise Total 122,703,541 6,400,098 43,903,464 42,585,703 19,097,613 59,702,464 51% Internal Service 222 Central Services 7,979,429 610,818 4,296,065 3,966,341 1,987,261 1,696,103 79% 226 Liability Insurance 2,915,927 682,723 1,711,153 1,414,363 1,987 1,202,788 59% 278 Take Home Vehicle Police 103,700 63,700 63,700 4,085 0 40,000 61% 711 Self- Funded Employee Benefits 13,348,829 1,228,463 7,540,058 7,126,237 2,161 5,806,610 57% 713 Unemployment Compensation 267,247 1,536 40,469 133,693 0 226,778 15% Internal Service Total 24,615,132 2,587,240 13,651,444 12,644,718 1,991,409 8,972,280 64% Trust & Agency 701 Firefighters Pension 5,900,028 447,416 3,204,259 3,333,679 0 2,695,769 54% 702 Police Pension 6,929,133 536,439 3,793,051 3,866,194 0 3,136,082 55% Trust & Agency Total 12,829,161 983,855 6,997,310 7,199,873 0 5,831,851 55% City Funds Total Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIFRevenue - Airport 25,244,592 1,594,315 7,083,653 12,227,446 1,117,509 17,043,430 32% 420 Tax Incremental Financing (TIF) - Downtown 5,302,102 53,090 1,757,072 5,685,033 595,551 2,949,479 44% 422 TIF - West Washington 668,815 41,972 177,842 395,094 165,723 325,250 51% 425 Redevelopment Retail & Leighton Plaza 151,185 7,647 61,502 81,291 0 89,683 41% 426 TIF - Central Medical Service Area 4,770,544 127,064 756,087 462,775 1,499,773 2,514,684 47% 429 TIF - Northeast Development 2,388,995 2,736 33,901 26,633 19,300 2,335,794 2% 430 TIF - Southside Development #1 6,122,885 709,340 1,406,191 1,697,094 3,487,142 1,229,552 80% 431 TIF - Southside Development #2 0 0 0 1,401,397 0 0 0% 432 TIF - Southside Development #3 501,268 143,950 490,005 149,809 0 11,263 98% 435 TIF - Douglas Road 454,782 0 95,488 109,353 4,500 354,794 22% 436 TIF - Northeast Residential 3,229,957 1,453,324 3,022,532 309,587 0 207,425 94% Tax Increment Financing Total 48,835,125 4,133,438 14,884,273 22,545,512 6,889,498 27,061,354 45% Redevelopment 433 Redevelopment General 6,787 0 854 3,033 5,933 0 100% 439 Certified Technology Park 0 0 0 0 0 0 0% 454 Airport Urban Enterprise Zone 0 0 0 0 0 0 0% 619 Blackthorn Golf Course Operations 1,997,706 234,559 1,117,500 1,289,564 0 880,206 56% Redevelopment Total 2,004,493 234,559 1,118,354 1,292,597 5,933 880,206 56% Debt Service 314 Redevelopment Bond - Central Development 0 0 0 825,410 0 0 0% Page 7 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY July 31, 2013 Redevelop Debt Servi 315 Redevelopment Bond - Airport Taxable 5,000 182 2,423 4,117 0 2,577 48% 317 Coveleski Debt Service Reserve 0 0 0 0 0 0 0% 319 Redevelopment Bond - Blackthorn Golf 326,050 0 326,464 3,468 0 -414 100% 328 Redevelopment Bond - Palais Royale 6,000 304 4,049 5,829 0 1,951 67% Debt Service Total 337,050 486 332,936 838,824 0 4,114 99% Redevelopment Commission Controlled Funds Total 111L. 51,176,668 4,368,483 16,335,563 24,676,933 6,895,431 27,945,674 45°/ Total 355,289,938 28,983,372 157,814,494 163,049,180 38,613,021 158,862,423 55% Page 8 2013 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Fund /Department Number 101 -0101 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 689,612 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 326,175 53% - Property Taxes /Non -Dept Revenue 689,612 53,144 363,437 Local Income Taxes - - - Other Taxes (95) 0% Grants /Intergovernmental 0% - - Charges for Services 1,136 60 95 Interest Earnings 560 - - Bond Proceeds - - - Donations 4,017 151 1,136 Other Income 600 40 40 Transfers In - - - Total Revenue 694,229 53,396 364,708 Expenditures 0% 380,752 274 Personnel 588,684 46,215 299,371 Supplies 35,167 3,367 26,732 Services 70,378 3,813 38,604 Debt Service - - - Capital Transfers Out - - - Total Expenditures 694,229 53,396 364,708 Net - - - Cash Balance Staffing Full Time 7.00 7.00 7.00 Part-Time /Season al/Tem porary - - - Total 7.00 7.00 7.00 377,247 326,175 53% - - 0% 0% 0% (95) 0% - 0% - - 0% 1,136 2,881 28% 2,369 560 7% - - 0% 380,752 329,521 53% 330,801 289,313 51% 15,171 - 8,435 76% 34,781 274 31,500 55% - - - 0% 0% 0% 380,752 274 329,248 53% - (274) 274 rxpiam aignmcam Kevenue, cxpenonure ano acarnng %,nangesivanances aeiow: Personnel costs below budget as position of Communications Director was filled in April, 2013. Promotional expenditures in the first quarter included items encumbered at December 31, 2013. The allocation to the print shop was increased for 2013. Salaries in 2012 were higher than 2013 because 2012 salaries included compensatory time payouts to former Mayor's office employees. Chief of Staff Mike Schmuhl resigned in June, 2013 and Kathryn Roos became the new Chief of Staff. rncam apenaing on t apnai r-rojecis neiow: Page 9 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center Fund /Department Number 101 -0104 Month I July Date Updated 1 8/16/2013 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 /Non -Dept Revenue 22,094 137,008 (137,008) 0% Local Income Taxes - - 0% Other Taxes 0% Grants /Intergovernmental - 0% Charges for Services 320,102 320,102 0% Interest Earnings - - 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 320,102 22,094 137,008 183,094 43% Expenditures Personnel 269,102 18,740 131,456 - 137,646 49% Supplies 2,500 51 1,591 1,295 (385) 115% Services 28,500 3,304 3,961 400 24,139 15% Debt Service - - - - - 0% Capital 20,000 20,000 0% Transfers Out - - - - 0% Total Expenditures 320,102 22,094 137,008 1,695T 181,400 43% Net - - (1,695)1 1,695 Cash Balance Staffing Full Time 4.50 4.50 4.50 Part-Time /Season al/Tem porary - - - Total 4.50 4.50 4.50 rxpiam aignmcam mevenue, cxpenonure ano ararnng ,- nangesivanances aeiow: New department for 2013. Supplies account includes start up supply costs. Advertising and promotional costs below budget. Will invoice other departments for services rendered starting in August 2013 and monthly thereafter. A draft AJ to allocate costs has been prepared. Explain Significant Spending on Capital Projects Below: No capital costs expended to date. The budget for $20,000 is for office furniture and telephone equipment. Page 10 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Fund /Department Number 101 -0201 Month I July Date Updated 1 8/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 365,170 25,395 182,783 180,003 182,387 50% 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 365,170 25,395 182,783 180,003 182,387 50% Expenditures Personnel 280,655 20,925 155,301 147,883 - 125,354 55% Supplies 7,988 24 2,371 1,815 54 5,563 30% Services 62,936 4,446 25,111 23,591 14,112 23,712 62% Debt Service - - - - - - 0% Capital 13,591 6,644 13,591 0% Transfers Out - - - 70 - 0% Total Expenditures 365,170 25,395 182,783 180,003 14,166T 168,221 54% Net - - - - (14,166)1 14,166 Cash Balance Staffing Full Time 5.00 5.00 5.00 Part-Time /Season al/Tem porary - - - Total 5.00 5.00 5.00 r xpiam aigmricam rtevenue, r- xpenanure ano starring ,- nangesivanances rseiow: No significant changes at this time. nincam apenaing on t apnai rrojects neiow: nt changes at this time. Page 11 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Common Council Fund /Department Number 101 -0301 Month I July Date Updated 1 8/21/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 507,097 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 289,276 43% - Property Taxes /Non -Dept Revenue 507,097 25,809 217,821 Local Income Taxes - - - Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 4,853 3,033 63% Interest Earnings - 0% - Bond Proceeds - - - Donations 8,300 703 5,267 Other Income - - - Transfers In - - - Total Revenue 515,397 26,512 223,088 Expenditures - 0% 228,286 189T___ 89 Personnel 289,758 13,932 103,998 Supplies 11,512 438 5,384 Services 183,838 12,143 107,416 Debt Service - - - Capital 30,289 6,289 Transfers Out - - - Total Expenditures 515,397 26,512 223,088 Net - - - Cash Balance Staffing Full Time 9.00 9.00 9.00 Part-Time /Season al/Tem porary - - - Total 9.00 9.00 9.00 223,433 289,276 43% - - 0% 0% 0% 0% 0% 0% 4,853 3,033 63% - - 0% - - 0% 228,286 292,309 43% 100,035 - 185,760 36% 3,351 189 5,938 48% 117,332 - 76,422 58% - - 0% 5,559 24,000 21% 2,009 - 0% 228,286 189T___ 89 292,120 43% - (1891l 189 r=xpiam aigmricant mevenue, cxpenonure ano starring ,- nangesivanances rseiow: Technically there are nine (9) Council Members. One member has declined to receive a salary, therefore he /she is not budgeted. $43,000 paid to WNIT for public access channel. Paid $65,000 in 2012. rxpiam oignincam openaing on t apnai rrojects t5eiow: In 2012, Council budgeted $8,400 for purchase of I -Pads and related equipment. The money ($6,289) was encumbered in 2012, but spent In 2013, another $14,000 was budgeted for related equipment along with $10,000 for the council committee room renovations. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name I Administration & Finance IMonth I July Fund /Department Number 1 101 -0401 1 Date Updated 1 8/16/2013 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 /Non -Dept Revenue 1,877,678 136,610 1,025,760 871,089 851,918 55% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 50 406 (356) 813% Transfers In - - - - - 0% Total Revenue 1,877,728 136,610 1,026,167 871,089 851,561 55% Expenditures Personnel 1,635,638 120,525 849,601 775,211 - 786,037 52% Supplies 50,301 3,468 20,901 16,233 7,338 22,062 56% Services 187,316 12,617 155,665 79,645 42,220 (10,569) 106% Debt Service 4,473 - - - - 4,473 0% Capital - - 0% Transfers Out - - - - - 0% Total Expenditures 1,877,728 136,610 1,026,167 871,089 49,558T 802,004 57% Net - - - - (49,558)1 49,558 Cash Balance Stathng Full Time 20.00 20.00 20.00 Part-Time /Season al/Tem porary 1.51 1.51 1.51 Total 21.51 21.51 21.51 rxpiam aignmcam Kevenue, r-xpenaicure ano ararnng ,- nangesivanances aeiow: Higher professional services expended so far in 2013 included amounts for temporary help, 311 call center consulting and AECOM economic impact study. Higher personnel costs for temporary and interns in 2013 than in 2012. Higher education & training costs than anticipated so far in 2013. A mid -year budget transfer from personnel to services account is in process for Council consideration on August 26, 2013. A new Talent Manager in Human Resources was hired in June, 2013. The department is fully staffed now in 2013 and was not fully staffed in 2012. Explain Significant Spending on Capital Projects Below: None Page 13 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Fund /Department Number 101 -0404 Month I July Date Updated 1 8/9/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 151,800 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 166,574 -10% - Property Taxes /Non -Dept Revenue 151,800 55,857 (14,774) Local Income Taxes - - 0% Other Taxes 323,383 63% - Grants /Intergovernmental - - - Charges for Services 876,000 24,615 552,617 Interest Earnings - - - Bond Proceeds 0% 521,136 491,353 Donations - - - Other Income 6,000 338 4,604 Transfers In - - - Total Revenue 1,033,800 80,811 542,447 Expenditures 0% 521.136 53.447 Personnel 652,134 48,620 366,966 Supplies 30,346 1,636 12,346 Services 351,320 30,555 163,135 Debt Service - - - Capital Transfers Out - - - Total Expenditures 1,033,800 80,811 542,447 Net - - - Cash Balance Staffing Full Time 12.00 12.00 12.00 Part-Time /Season al/Tem porary 4.00 4.00 4.00 Total 16.00 16.00 16.00 33,044 166,574 -10% - - 0% 0% 0% 483,495 323,383 63% - - 0% 0% 0% 4,596 1,396 77% - - 0% 521,136 491,353 52% 354,336 2,000 283,168 57% 13,276 7,534 10,466 66% 153,523 43,913 144,272 59% - - - 0% 0% 0% 521.136 53.447 1 437.906 1 58% r=xpiam aigmricam rtevenue, r- xpenanure ano starring ,- nangesivanances oeiow: Thank you Wicked! The acclaimed Broadway musical Wicked played at the Morris Performing Arts Center in the spring and resulted in large attendance and activity in the downtown (May 2013). The summer months are traditionaly slow. am oignincam openaing on t apnai rrojects neiow: 1 416 is used to support renovating, remodeling, or, othe Center. Not all of the expenses are Capital expenses. and / or service to the patrons at Page 14 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Fund /Department Number 101 -0405 Month I July Date Updated 1 8/9/2013 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 /Non -Dept Revenue 182,849 (11,328) 55,677 40,240 127,173 30% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 291,981 46,000 162,482 140,362 129,499 56% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 18,000 2,532 9,323 8,855 8,677 52% Transfers In - - - - - 0% Total Revenue 492,830 37,204 227,481 189,456 265,349 46% Expenditures Personnel 226,174 16,052 119,012 106,533 600 106,563 53% Supplies 15,730 168 7,862 4,129 3,923 3,945 75% Services 220,526 20,984 100,608 78,374 52,397 67,521 69% Debt Service - - - - - - 0% Capital 30,400 - 30,400 0% Transfers Out - - - 420 - 0% Total Expenditures 492,830 37,204 227,481 189,456 56,920T--- 6,920 208,428 58% Net - - - - (56,920)1 56,920 Cash Balance Staffing Full Time 2.00 2.00 2.00 Part-Time /Season al/Tem porary 1.00 1.00 1.00 Total 3.00 3.00 3.00 r=xpiam aignmcam rtevenue, cxpenonure ano atarnng ,- nangesivanances rseiow: More knots were tied and we were blessed with many bridal receptions compared to the same period last year. rncam apenaing on t apnai rrojects t5eiow: )lects were completed in July. Page 15 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Fund /Department Number 101 -0501 Month I July, 2013 Date Updated 1 8/20/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 956,116 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 492,715 48% - Property Taxes /Non -Dept Revenue 956,116 71,397 463,401 Local Income Taxes - - - Other Taxes 0% 515 Grants /Intergovernmental 40% - - Charges for Services - - - Interest Earnings 2,000 0% 790 Bond Proceeds - 458,668 - Donations - - - Other Income 70,350 18 316 Transfers In - - - Total Revenue 1,028,466 71,415 464,507 Expenditures 0% Personnel 959,774 65,668 423,137 Supplies 8,684 940 4,350 Services 51,992 4,807 29,066 Debt Service 2,000 1,938 Capital 6,016 - 6,016 Transfers Out - - - Total Expenditures 1,028,466 71,415 464,507 Net - - - Cash Balance Staffing Full Time 9.60 10.00 10.00 Part-Time /Season al/Tem porary - 2.00 4.00 Total 9.60 12.00 14.00 rxpiam aigmncant Kevenue, r-xpenaicure ano ararnng ,- nangesivanances aeiow: Fully staffed with the hire of two part-time Deputy City Attorneys. rncam apenaing on t apnai r-rojecis neiow: 424,288 492,715 48% - - 0% 0% 0% 0% 515 1,210 40% - - 0% - - 0% 33,865 70,034 0% - - 0% 458,668 563,959 45% 428,037 - 536,637 44% 3,105 3,041 1,293 85% 25,594 4,959 17,967 65% - - 62 97% - - 100% 1.932 0% Page 16 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Energy Office Fund /Department Number 101 -0600 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Local Income Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue (54,256) Property Taxes /Non -Dept Revenue 54,256 Local Income Taxes 0% Other Taxes Grants /Intergovernmental Charges for Services 0% Interest Earnings Bond Proceeds Donations 0% Other Income Transfers In Total Revenue 54,256 Expenditures Personnel - Supplies - Services 54,256 Debt Service - Capital 0% Transfers Out - Total Expenditures 54,256 (54,256) 0% Net - Cash Balance 192,725 Staffing 0% Full Time Part-Time /Season al/Tem porary 297,364 Total 0% 297,364 (54,256) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 297,364 54,256 0% - 0% - 0% 104,639 (54,256) 0% - 0% 192,725 0% - 0% 297,364 (54,256) 0% rxpiam aigmricanr mevenue, cxpenonure ano ararrmg %,nangesivanances aeiow: The Energy Office was moved to Central Services fund 222 for 2012. The amount of $54,256 was paid in 2013 to reimburse Fund 222 for grant proceeds deposited in the General Fund but expended in the Central Services Fund, as requested by the State Board of Accounts. An additional appropriation of $54,256 was include on the 2013 mid -year listing which will be considered by the Common Council on August 26, 2013. Explain Significant Spending on Capital Projects Below: No capital spending in this department for 2013. Page 17 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Engineering Fund /Department Number 101 -0602 Month I July Date Updated 1 8/14/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 1,357,461 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 618,353 54% - Property Taxes /Non -Dept Revenue 1,357,461 116,308 739,108 Local Income Taxes - - - Other Taxes 30,000 0% - Grants /Intergovernmental - Charges for Services 30,000 0% Interest Earnings - 71% - Bond Proceeds 0% 972,048 650,118 Donations - - - Other Income 6,100 199 4,335 Transfers In - - - Total Revenue 1,393,561 116,507 743,443 Expenditures - 0% 972,048 43,773 Personnel 637,072 53,997 350,131 Supplies 18,624 1,324 9,261 Services 725,865 59,877 382,079 Debt Service 12,000 1,310 1,973 Capital - - - Transfers Out - - - Total Expenditures 1,393,561 116,507 743,443 Net - - - Cash Balance Staffing Full Time 8.20 8.05 8.05 Part-Time /Season al/Tem porary 1.81 3.10 3.10 Total 10.01 11.15 11.15 r xpiam aignmcam rtevenue, r- xpenanure ano atarnng ,- nangesivanances rseiow: 3 Interns remaining in the department for the summer. PT people total 1.10 FTE's 897,539 618,353 54% - - 0% 0% 0% 51,776 30,000 0% - - 0% 0% 0% 22,734 1,765 71% - - 0% 972,048 650,118 53% 644,629 286,941 55% 8,690 1,802 7,560 59% 289,307 38,688 305,099 58% - 3,283 6,744 44% 8,549 - - 0% 20,874 - - 0% 972,048 43,773 606,345 56% - (43.773)1 43.773 rxpiam oignincam openaing on t apnai rrojects neiow: The lease /purchase of one Ricoh plotter /scanner is on the Board of Public Works agenda for approval on $648.00 quarterly for five years and has been included in the 2013 budget. cost Page 18 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Traffic & Lighting Fund /Department Number 101 -0607 Month I July 2013 Date Updated 1 8/19/2013 Current Current Current Prior 111,815 (100) 109,186 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 2,629 98% Property Taxes /Non -Dept Revenue 111,815 (100) 109,186 Local Income Taxes - - - Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations (350) - - Other Income - 100 350 Transfers In - - - Total Revenue 111,815 109,536 Expenditures 1,974 98% Personnel - 82% Supplies 110,147 108,173 Services 1,668 1,363 Debt Service - 0% Capital 2,279 98% Transfers Out - - Total Expenditures 111,815 109,536 Net - Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Fund is winding down. Will be de- activated after encumbrances have been exhausted. rncanr apenaing on t apnai r-rojecrs neiow: 438,748 2,629 98% - - 0% 0% 0% 0% 0% 0% 0% 24,047 (350) 0% - - 0% 462,796 2,279 98% 74,820 - 0% 324,201 1,974 98% 55,958 305 82% - 0% 7,816 0% 0% 462,796 2,279 98% - rnt Page 19 Form 3 Page 20 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Department jMonth I July Fund /Department Number 101 -0801 1 Date Updated 8/13/2013 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 /Non -Dept Revenue 23,434,876 1,700,843 12,397,281 12,859,362 11,037,595 53% Local Income Taxes - - - - - 0% Other Taxes - 0% Grants /Intergovernmental 1,022,206 0% Charges for Services - 0% Interest Earnings 0% Bond Proceeds 0% Donations 7,500 - - - 7,500 0% Other Income 353,000 32,314 201,639 203,300 151,361 57% Transfers In - - - - - 0% Total Revenue 23,795,376 1,733,157 12,598,920 14,084,869 11,196,456 53% Expenditures Personnel 20,376,883 1,466,756 10,903,761 11,600,694 9,473,122 54% Supplies 467,988 40,249 270,708 753,708 63,008 134,272 71% Services 2,617,924 226,152 1,380,453 1,605,281 53,450 1,184,021 55% Debt Service 24,185 - 15,602 15,151 - 8,583 65% Capital 308,396 28,396 94,824 10,000 270,000 12% Transfers Out - - - 15,211 - - 0% Total Expenditures 23,795,376 1,733,157 12,598,920 14,084,869 126,458 11,069,998 53% Net - - - (126,458)1 126,458 Cash Balance Staffing Full Time 250.00 243.00 243.00 Part-Time /Season al/Tem porary 43.00 16.00 16.00 Total 293.00 259.00 259.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The decrease in revenue compared to 2012 for the Grants /Intergovernmental account is that 2012 was the final year of the COPS Hiring Recovery Program funding. The decrease in Personnel Expenditures in 2013 compared to 2013 is due to the transfer of an additional ten officer's salary to the LOIT fund. This decrease is partially ofset by the 2.5% increase in salary for the department. There is a corresponding increase in the LOIT fund. Supplies of $270,708 are down from the 2012 expenditure level due to an accounting change. Police gas costs of $511,514 for 2013 are recorded in Fund 404. Explain Significant Spending on Capital Projects Below: The $28,396 of capital is the purchase of a Police SUV for the Police Chief. Page 20 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Fund /Department Number 101 -0802 Month I July Date Updated 1 8/13/2013 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 /Non -Dept Revenue 2,326,560 159,503 1,162,374 1,133,925 1,164,186 50% 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,326,560 159,503 1,162,374 1,133,925 1,164,186 50% Expenditures Personnel 2,298,012 157,726 1,148,317 1,119,743 1,149,695 50% Supplies 4,029 - 1,246 2,168 2,783 31% Services 24,519 1,777 12,811 12,014 11,708 52% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 2,326,560 159,503 1,162,374 1,133,925 1,164,186 50% Net - - - - Cash Balance Staffing Full Time 38.00 34.00 34.00 Part-Time /Season al/Tem porary - - - Total 38.00 34.00 34.00 rxpiam aignmcam mevenue, cxpenonure ano acarnng i,nangesivanances aeiow: Expenditures and staffing levels for the Communications Department are on track with budget. rncam apenaing on t apnai r-rojecis neiow: Page 21 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Public Safety LOIT - Police Fund /Department Number 101 -0805 Month I July Date Updated 1 8/13/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue (709,854) (709,854) (451,011) 709,854 0% Local Income Taxes - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 3,968,567 992,142 2,994,609 2,237,748 973,958 75% Total Revenue 3,968,567 282,288 2,284,755 1,786,737 1,683,812 58% Expenditures Personnel 3,968,567 282,288 2,179,598 1,737,006 1,788,969 55% Supplies - - - - - 0% Services 0% Debt Service 0% Capital 0% Transfers Out - - 105,157 49,731 105,157 0% Total Expenditures 3,968,567 282,288 2,284,755 1,786,737 1,683,812 58% Net Cash Balance Staffing Full Time 47.00 46.00 46.00 Part-Time /Season al/Tem porary - - - Total 47.00 46.00 46.00 rxpiam aigmricanr Kevenue, cxpenonure ano ararring ,- nangesivanances aeiow: The increase in Personnel expenditures in 2013 compared to 2012 is due to the the transfer of 10 additional officers to the LOT from the General fund in 2013. There are now 47 officers budgeted in the Loit compared to 37 in 2012. The 2.5% increase in salaries also contributed to the increase in expenditures over 2012. rncanr apenaing on t apnai r-rojecrs neiow: Page 22 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Fund /Department Number 101 -0901 Month I July Date Updated 1 8/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 18,951,695 1,405,342 10,582,040 11,631,505 8,369,655 56% Local Income Taxes - - 0% Other Taxes - - 0% Grants /Intergovernmental 155,000 155,000 0% Charges for Services 455,000 35,689 348,989 244,844 106,011 77% Interest Earnings - - 0% Bond Proceeds 0% Donations 0% Other Income 6,000 129 38,272 6,343 (32,272) 638% Transfers In 1,000,000 500,000 500,000 50% Total Revenue 20,567,695 1,441,160 11,469,301 11,882,692 9,098,394 56% Expenditures Personnel 18,549,180 1,280,979 10,432,053 10,726,259 93,531 8,023,596 57% Supplies 398,387 30,450 221,005 315,641 43,465 133,917 66% Services 1,620,128 129,731 816,243 836,088 84,595 719,290 56% Debt Service - - 0% Capital - - 4,704 - 0% Transfers Out - - - - - 0% Total Expenditures 20,567,695 1,441,160 11,469,301 11,882,692 221,591 8,876,803 57% Net - - - - (221,591)1 591 Cash Balance Staffing Full Time 218.00 208.00 208.00 Part-Time /Season al/Tem porary 1.00 - - Total 219.00 208.00 208.00 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances oeiow: Currently running recruit class of 8 to fill 10 positions opening throughout 2012 and 2013. Recruit Class decreased by 1. Remaining class due to graduate in August. Expecting retirement of 3 -4 individuals throughout 2013 and expect another recruit class to begin in February 2014. Two firefighters pending separation, one for legal reasons and one approved LOA /sabatical to receive training. One permanent part time hired for EMS billing. Office now fully staffed. Augmenting with Temp staffing to continue reducing call backlog for EMS billing. Explain Significant Spending on Capital Projects Below: Capital projects run through fund 288 Page 23 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Public Safety LOIT - Fire Fund /Department Number 101 -0905 Month I July Date Updated 1 8/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue (316,614) (316,613) (368,573) 316,613 0% Local Income Taxes - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 3,133,190 783,297 2,349,892 1,746,894 783,298 75% Total Revenue 3,133,190 466,683 2,033,279 1,378,321 1,099,911 65% Expenditures Personnel 3,133,190 466,683 1,577,856 1,266,543 1,555,334 50% Supplies - - - - - 0% Services 0% Debt Service 0% Capital 0% Transfers Out - 455,423 111,778 455,423 0% Total Expenditures 3,133,190 466,683 2,033,279 1,378,321 1,099,911 65% Net - Cash Balance Staffing Full Time 39.00 Part-Time /Season al/Tem porary - Total 39.00 rxpiam oigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances oeiow: PSLOIT funds 39 First Class Firefighter positions. No changes in staffing at this level. These are members of the fire department, but their salaries and benefits are paid through this account to demonstrate directly the Fire Department positions that are made possible by the Public Safety Local Option Income Tax. Explain Significant Spending on Capital Projects Below: No capital expenditures through this account Page 24 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Fund /Department Number 101 -1008 Month I July Date Updated 1 8/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 346,237 27,355 179,722 150,345 166,515 52% 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 (242) 0% Transfers In - - - - - 0% Total Revenue 346,237 27,355 179,964 150,345 166,273 52% Expenditures Personnel 256,834 18,777 139,703 134,188 - 117,131 54% Supplies 3,861 196 1,733 2,416 400 1,728 55% Services 37,542 1,422 10,689 13,097 8,594 18,259 51% Debt Service 45,000 6,960 27,839 - - 17,161 62% Capital 3,000 - - - 3,000 0% Transfers Out - - - 644 - 0% Total Expenditures 346,237 27,355 179,964 150,345 8,994T 157,279 55% Net - - - - (8,994)1 8,994 Cash Balance Staffing Full Time 4.00 4.00 4.00 Part-Time /Season al/Tem porary - - - Total 4.00 4.00 4.00 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: Late last year (December 2012), the Human Rights moved into a new building. Thus, office space was only paid for one month. The services category is much higher because of rent paid this year. Expenditures are consistent with normal operating costs. rncanr apenaing on t apnai r-rojecrs neiow: Page 25 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Code Enforcement Fund /Department Number 101 -1201 Month I July Date Updated 1 8/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,186,669 145,215 887,699 845,772 1,298,970 41% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 300 36 2,772 346 (2,472) 924% Transfers In - - - - - 0% Total Revenue 2,186,969 145,251 890,471 846,118 1,296,498 41% Expenditures Personnel 929,883 73,710 542,939 511,712 12,566 374,377 60% Supplies 79,757 6,583 56,882 48,775 1,286 21,588 73% Services 965,130 64,409 276,550 256,853 218,847 469,734 51% Debt Service 2,199 550 1,099 - 1,099 0 100% Capital 158,000 - - - 56,742 101,258 36% Transfers Out 52,000 - 13,000 28,779 - 39,000 25% Total Expenditures 2,186,969 145,251 890,471 846,118 290,540 1,005,958 54% Net - - (290,540) 290,540 Cash Balance Staffing Full Time 16.50 17.00 17.00 Part-Time /Season al/Tem porary 0.50 1.00 1.00 Total 17.00 18.00 18.00 r xpiam aigmricam rtevenue, r- xpenanure ano atarrmg -nangesivariances rseiow: Dir of Code Enforcement and Director of Admin Services were supposed split salaries between Code and Animal Control, but that wasn't happening. Other income of $2,300 was insurance proceeds from an auto accident. Transfers out are to Solid Waste for landfill fees. The encumbrance in Personnel is for D. Skwarcan's salary for the remainder of 2013; she's a contracted employee through PeopleLink. Services appear lower now because no invoices for Illegal Dumping have been received yet from Solid Waste; budgeted $306,000. rncam apenaing on t apnai rrojects neiow: iered $56,742 for two pickup trucks to be delivered in summer. Page 26 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Code Hearing Officer Fund /Department Number 101 -1203 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 40,000 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 20,022 50% - Property Taxes /Non -Dept Revenue 40,000 7,500 19,978 Local Income Taxes - - - Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% 23,578 20,022 Donations - - 0% Other Income - 0% 23,578 7,500 Transfers In - - - Total Revenue 40,000 7,500 19,978 Expenditures 0% 23.578 7.500 Personnel - - - Supplies - - - Services 40,000 7,500 19,978 Debt Service - - - Capital Transfers Out - - - Total Expenditures 40,000 7,500 19,978 Net - - Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total 23,578 20,022 50% - - 0% 0% 0% 0% 0% 0% 0% 0% 0% 23,578 20,022 50% - - 0% - - - 0% 23,578 7,500 12,522 69% - - - 0% 0% 0% 23.578 7.500 12.522 6 9% 7 r=xpiam aigmricam rtevenue, r- xpenanure ano starring ,- nangesivanances rseiow: Sole expenditure is monthly billing for Hearing Officer. Expenses area little higher than expected. Engel's rate is higher than Gammage's was. Legal Dept is looking into it. rncam apenaing on t apnai rrojects neiow: >enditures for this department. Page 27 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Junk Vehicle Fund /Department Number 101 -1204 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 29,829 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 4,097 86% - Property Taxes /Non -Dept Revenue 29,829 (1,874) 25,732 Local Income Taxes - - Other Taxes 33,529 7% - Grants /Intergovernmental - - Charges for Services 36,000 2,471 Interest Earnings - 0% - Bond Proceeds 0% 37,304 37,626 Donations 28,311 - 30,459 44% Other Income 204 81% 5,671 2,525 Transfers In - - - - Total Revenue 65,829 1,874 28,203 Expenditures 0% Personnel 54,065 18 23,606 Supplies 1,082 7 546 Services 10,682 (1,899) 4,051 Debt Service - - Capital Transfers Out - - Total Expenditures 65,829 (1,874) 28,203 Net - - Cash Balance Staffing Full Time 1.00 Part-Time /Season al/Tem porary - Total 1.00 23,828 4,097 86% - - 0% 0% 0% 13,476 33,529 7% - - 0% 0% 0% 0% 0% 37,304 37,626 43% 28,311 - 30,459 44% 488 332 204 81% 5,671 2,525 4,106 62% - - - 0% 2,834 0% - 0% rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Single employee resigned June 2013, transferred to Police. We expect an arrangement where he will continue to tow vehicles and we will pay the Police Dept. Details still pending. July: credit of $2,300 posted to Services from Central Svcs for Parts, Fuel, & Labor. rncanr apenaing on t apnai r-rojecrs neiow: penditures. Page 28 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Unsafe Building Fund /Department Number 101 -1205 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 4,684 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 205,684 - 4291% Property Taxes /Non -Dept Revenue 4,684 (8,932) (201,000) Local Income Taxes - 0% Other Taxes 27,322 45% - Grants /Intergovernmental - - - Charges for Services 50,000 6,242 22,678 Interest Earnings - - - Bond Proceeds 0% 54,354 90,577 Donations - - - Other Income 53,000 5,050 195,429 Transfers In - - - Total Revenue 107,684 2,360 17,107 Expenditures 0% 54,354 28,525 Personnel - - - Supplies - - - Services 107,684 2,360 17,107 Debt Service - - - Capital Transfers Out - - - Total Expenditures 107,684 2,360 17,107 Net - - - Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total (172,152) 205,684 - 4291% - 0% 0% 0% 7,374 27,322 45% - - 0% 0% 0% 219,133 (142,429) 369% - - 0% 54,354 90,577 16% - - 0% - - - 0% 54,354 28,525 62,052 42% - - - 0% 0% 0% 54,354 28,525 62,052 42% - (28.525)1 28.525 r=xpiam aigmricam rtevenue, r- xpenanure ano starring i,nangesivanances rseiow: Service expenditures are primarily board -ups which haven't been called for as much as anticipated. Revenue from fines & forfeitures includes $91,531 from 2012 Property Taxes collected. June revenue includes semi - annual tax payment of $68,797. rncam apenaing on t apnai rrojects neiow: rchases have been made. Page 29 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Animal Control Fund /Department Number 101 -1207 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 542,611 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 243,261 55% - Property Taxes /Non -Dept Revenue 542,611 20,956 299,350 Local Income Taxes - - - Other Taxes 22,109 58% - Grants /Intergovernmental - - - Charges for Services 52,400 30,291 30,291 Interest Earnings - - - Bond Proceeds - 296,794 - Donations 100 203,105 16 Other Income 1,000 65% 70 Transfers In - - - Total Revenue 596,111 51,246 329,727 Expenditures - 0% 296.794 22.265 Personnel 436,947 33,935 233,842 Supplies 66,364 6,569 40,429 Services 91,340 10,743 55,252 Debt Service 1,200 - 204 Capital 260 - Transfers Out - - - Total Expenditures 596,111 51,246 329,727 Net - - - Cash Balance Staffing Full Time 8.50 6.00 6.00 Part-Time /Season al/Tem porary 0.40 1.00 1.00 Total 8.90 7.00 7.00 266,535 243,261 55% - - 0% 0% 0% 30,072 22,109 58% - - 0% - - 0% 187 84 16% - 930 7% - - 0% 296,794 266,384 55% 214,452 - 203,105 54% 33,515 2,420 23,515 65% 48,014 19,438 16,651 82% - 408 588 51% - - 260 0% 812 - - 0% 296.794 22.265 244.119 1 59% rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Director of Admin Services was supposed to have salary split between Code and Animal Control, but 100% has gone to Code. New Shelter Manager began work 8 July. Staff temporarily reduced by 2 Officers in late July. Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted. $260 budget appears in error; will be corrected as part of mid -year budget transfers. Page 30 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Rainy Da Fund /Department Number 102 Month I July Date Updated 1 8/14/2013 Current Current Current Prior Local Income Taxes Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue Property Taxes Local Income Taxes Other Taxes Grants /Intergovernmental Charges for Services - - - Interest Earnings 52,000 1,509 20,050 Bond Proceeds - - - Donations Other Income Transfers In - - - Total Revenue 52,000 1,509 20,050 Expenditures Personnel - - - Supplies Services Debt Service Capital Transfers Out Total Expenditures - - - Net 52,000 1,509 20,050 Cash Balance 8,608,230 Staffing Full Time - Part-Time /Season al/Tem porary Total 0% 0% 0% 0% 0% 30,232 31,950 39% - 0% - 0% 0% - 0% 30,232 31,950 39% - - 0% 0% 0% 0% 0% 0% 0% 30.232 31.950 8,576.174 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: No significant changes at this time. No expenditures are budgeted in this fund. The establishment of a Rainy Day Fund is looked upon favorably by bond rating agencies and is one of the factors restulting in South Bend's good AA bond rating with Standard & Poor's. rncanr apenaing on t apnai r-rojecrs neiow: Page 31 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation Fund /Department Number 201 Month I July Date Updated 1 8/19/2013 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 7,800,000 3,943,985 4,295,900 3,856,015 51% Local Income Taxes - - - - 0% Other Taxes 533,081 309,952 308,977 223,129 58% Grants /Intergovernmental 696,009 58,001 406,005 359,681 290,004 58% Charges for Services 3,223,789 588,670 2,076,103 1,998,202 1,147,686 64% Interest Earnings 10,000 726 8,292 9,615 1,708 83% Bond Proceeds - - 0% Donations - - 0% Other Income 99,450 3,074 14,437 36,831 85,013 15% Transfers In - - - - 0% Total Revenue 12,362,329 650,471 6,758,774 7,009,206 5,603,555 55% Expenditures Personnel 7,991,934 708,555 4,315,981 4,271,063 3,279 3,672,674 54% Supplies 1,556,880 178,437 1,087,699 1,070,824 310,760 158,421 90% Services 2,072,505 188,574 1,288,166 1,055,736 118,369 665,970 68% Debt Service 289,406 - 144,703 100,042 - 144,703 50% Capital 801,238 - 150,121 300,281 93,802 557,315 30% Transfers Out 180,500 - 120,323 180,500 0% Total Expenditures 12,892,463 1,075,566 6,986,670 6,918,269 526,210 5,379,583 58% Net (530,134) (425,095) (227,896) 90,937 (526,210)1 223,972 Cash Balance 4,670,111 4,720,172 Staffing Full Time 117.00 111.00 111.00 Part-Time /Season al/Tem porary 76.00 142.00 69.73 Total 193.00 253.00 180.73 rxpiam aigmricanr Kevenue, cxpenonure ano ararring i,nangesivanances aeiow: Golf revenue down from last year because 2012 started early and 2013 has been bad due to weather. Staffing is at peak due to summer programming and maintenance seasonal employees. rncanr apenaing on t apnai rrojecrs neiow: Page 32 Form 3 Page 33 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month I July 2013 Fund /Department Number 202 1 Date Updated 8/19/2013 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 4,749,789 205,441 2,601,760 2,820,852 2,148,029 55% Grants /Intergovernmental - - 0% Charges for Services 197,000 48,988 326,142 210,087 (129,142) 166% Interest Earnings 7,000 704 6,524 4,392 476 93% Bond Proceeds - - 0% Donations - - 0% Other Income 111,300 956 12,418 23,085 98,882 11% Transfers In 3,626,882 1,350,000 3,626,882 1,714,287 - 100% Total Revenue 8,691,971 1,606,089 6,573,726 4,772,703 2,118,245 76% Expenditures Personnel 3,845,935 266,658 2,010,094 1,676,213 1,835,841 52% Supplies 3,058,845 182,230 845,380 1,158,040 1,231,852 981,613 68% Services 1,686,176 91,554 828,309 754,476 99,896 757,971 55% Debt Service 198,800 - 53,309 145,491 27% Capital 276,740 47,665 70,905 142,384 205,835 26% Transfers Out - - 0% Total Expenditures 9,066,496 588,107 3,807,998 3,731,114 1,331,748 3,926,750 57% Net (374,525) 1,017,982 2,765,728 1,041,589 (1,331,748) (1,808,505) Cash Balance 5,033,416 2,455,804 Staffing Full Time 59.00 58.00 58.00 Part-Time /Season al/Tem porary 6.16 6.19 6.19 Total 65.16 64.19 64.19 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. Staffing changes: Replaced vacancies - General Laborer, Superintendent III - add 1.6 FTE Explain Significant Spending on Capital Projects Below: Page 33 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Recreation Nonrevertin Fund /Department Number 203 Month I JULY Date Updated 1 8/16/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 989,593 39% Grants /Intergovernmental - - - Charges for Services 1,632,943 133,224 643,350 Interest Earnings 4,000 150 1,772 Bond Proceeds - - Donations - 426,358 - Other Income 82,992 9,470 84,320 Transfers In - - - Total Revenue 1,636,943 142,844 729,443 Expenditures 10,375 0% 98.567 Personnel 668,209 65,702 241,851 Supplies 288,211 42,223 118,116 Services 485,357 49,931 150,537 Debt Service - - - Capital 119,000 - - Transfers Out - 10,375 10,375 Total Expenditures 1,560,777 168,231 520,878 Net 76,166 (25,388) 208,565 Cash Balance 879,697 Staffing Full Time 1.00 1.00 1.00 Part-Time /Season al/Tem porary 25.70 22.50 17.44 Total 26.70 23.50 18.44 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: This fund accounts for programs and events that are self funded through user fees. rncanr apenaing on t apnai rrojecrs neiow: 704,652 2,330 18,366 277,574 109,764 172,474 34,038 15,260 609,110 116,238 725.190 Page 34 Form 3 0% 0% 0% 0% 989,593 39% 2,228 44% - 0% 0% (84,320) 0% - 0% 907,500 45% - 426,358 36% 87,103 82,992 71% 11,464 323,356 33% - - 0% 119,000 0% 10,375 0% 98.567 1 32 40% Page 34 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Studebaker - Oliver Reverting Grants Fund /Department Number 209 Month I July Date Updated 1 8/13/2013 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 5,000 190 2,520 3,976 2,480 50% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 5,000 190 2,520 3,976 2,480 50% Expenditures Personnel - - - - - 0% Supplies - 0% Services 1,838 0% Debt Service - 160,764 0% Capital 1,000,000 - 1,000,000 0% Transfers Out - - - 0% Total Expenditures 1,000,000 - - 162,602 1,000,000 0% Net (995,000) 190 2,520 (158,626) (997,520) Cash Balance 1,082,196 1,078,166 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: 2012 debt service expense to reimburse for final Section 108 #7 payment. n oignincanr openaing on t apnai r-rojecrs neiow: to be used for environmental clean up as needed. If not used this year, use next year. Page 35 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Fund /Department Number 210 Month I July Date Updated 1 8/13/2013 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 161,829 175 44,200 58,616 117,629 27% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 1,462,358 120,875 142,486 1,341,483 8% Transfers In - - - - - 0% Total Revenue 1,624,187 175 165,075 201,102 1,459,112 10% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 1,260,777 18,003 102,639 115,332 1,158,138 8% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 1,260,777 18,003 102,639 115,332 1,158,138 8% Net 363,410 (17,828) 62,436 85,770 300,974 Cash Balance 980,892 990,817 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: No significant issues. rncam apenaing on t apnai rrojects neiow: Page 36 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development Admn. Fund /Department Number 211 Month I July Date Updated 1 8/13/2013 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 421,787 68,722 139,636 31,192 282,151 33% Charges for Services - - - - - 0% Interest Earnings 2,200 110 1,707 2,053 493 78% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 200,300 76,808 208,282 141,691 (7,982) 104% Transfers In 1,717,521 429,380 1,288,139 1,145,360 429,382 75% Total Revenue 2,341,808 575,020 1,637,764 1,320,296 704,044 70% Expenditures Personnel 1,938,047 131,230 1,025,984 948,586 - 912,063 53% Supplies 32,861 8,018 20,492 10,639 5,951 6,418 80% Services 378,703 27,069 199,623 83,462 10,854 168,226 56% Debt Service - - - - - - 0% Capital 4,720 4,720 - 100% Transfers Out - - - 141,834 0% Total Expenditures 2,354,331 166,317 1,250,819 1,184,521 16,805 1,086,707 54% Net (12,523) 408,703 386,945 135,775 (16,805) (382,663) Cash Balance 970,781 651,911 Staffing Full Time 25.60 23.60 23.60 Part-Time /Season al/Tem porary 1.00 1.00 1.00 Total 26.60 24.60 24.60 r xpiam aignmcam rtevenue, r= xpenanure ano atatnng %,nangesivanances rseiow: Have drawn our staff contracts (other income) faster than last year. Admin cost shows in services in 2013, but was in transfers out in 2012. rncam apenaing on t apnai rrojects neiow: ditures relate to purchase of whiteboard for conference room move to Page 37 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development Fund /Department Number 212 Month I July Date Updated 1 8/13/2013 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 8,148,705 104,588 2,448,281 2,166,847 5,700,424 30% Charges for Services - - - - - 0% Interest Earnings 2,000 389 1,588 1,791 412 79% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 649,600 7,647 178,640 274,096 470,960 28% Transfers In - - - - - 0% Total Revenue 8,800,305 112,624 2,628,509 2,442,734 6,171,796 30% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Grants 8,957,256 211,115 2,738,756 2,499,551 2,433,441 3,785,059 58% Transfers Out - - - - - - 0% Total Expenditures 8,957,256 211,115 2,738,756 2,499,551 2,433,441 3,785,059 58% Cash Balance 402,937 Staffing Full Time - Part-Time /Seasonal/Tem porary Total 165 txpiam aignincam Kevenue, txpenanure ana atatrmg cnangesnrariances 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. n capnai Page 38 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Fund /Department Number 216 Month I July Date Updated 1 8/14/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes - - Grants /Intergovernmental 35,000 8,939 Charges for Services - - - Interest Earnings 300 25 336 Bond Proceeds - - - Donations - 0% Other Income 600 0% Transfers In - - - Total Revenue 35,900 25 9,275 Expenditures 10,000 0% Personnel - - - Supplies 10,000 - Services 22,500 500 Debt Service - - Capital 13,400 10,000 Transfers Out - - Total Expenditures 45,900 - 10,500 Net (10,000) 25 (1,225) Cash Balance 143,701 Staffing Full Time - Part-Time /Season al/Tem porary Total 135.017 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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: The $10,000 Capital purchase was the VMWare Center Server and Switch for Police Communications. Page 39 Form 3 0% 0% 0% 14,048 26,061 26% - - 0% 458 (36) 112% - - 0% - 0% 600 0% - - 0% 14,506 26,625 26% - - 0% - - 10,000 0% 6,197 950 21,050 6% - - - 0% 3,400 75% 0% 6.197 950 34.450 25% 135.017 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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: The $10,000 Capital purchase was the VMWare Center Server and Switch for Police Communications. Page 39 Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month July Fund /Department Number 217 1 Date Updated 8/14/2013 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 200 12 150 201 50 75% Bond Proceeds - - - - - 0% Donations 16,811 11,269 17,012 5,542 67% Other Income - - - - 0% Transfers In - - - - - 0% Total Revenue 17,011 12 11,419 17,213 5,592 67% Expenditures Personnel - - - - - 0% Supplies - - 3,007 0% Services 1,310 1,310 - (1,310) 0% Debt Service - - 0% Capital 0% Transfers Out - - 0% Total Expenditures 1,310 1,310 3,007 i (1,310) 0% Net 17,011 (1,298) 10,109 14,205 6,902 Cash Balance 73,342 60,835 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: In July, spring taxes ($1,310.22) were charged to the services account in error. Correction made in August. 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). Donations received during June, 2013 were $9,810 and included $7,311 from Well Fargo Bank for code demolitions and property taxes on certain properties. This amount has been included on the 2013 mid -year appropriation ordinance for consideration by the Common Council on August 26, 2013. Explain Significant Spending on Capital Projects Below: None Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Fund /Department Number 218 Month I July Date Updated 1 8/16/2013 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 1,000 138 288 230 712 29% Interest Earnings 25 2 26 37 (1) 104% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,025 140 314 267 711 31% Expenditures Personnel - - - - - 0% Supplies 500 500 0% Services 500 500 0% Debt Service - - 0% Capital 0% Transfers Out 0% Total Expenditures 1,000 1,000 0% Net 25 140 314 267 (289) Cash Balance 11,198 10,682 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aignmcam Kevenue, r-xpenaicure ano marring %,nangesivanances oeiow: This fund was established to collect Curfew and Prositiuition fines. Expenditures are used for Police enforcement and training. rncam apenaing on t apnai r-rojecis neiow: Page 41 Form 3 Page 42 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education IMonth I July Fund /Department Number 220 1 Date Updated 8/14/2013 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 108,000 - 6,964 74,468 101,036 6% Charges for Services 180,000 19,344 103,697 87,080 76,303 58% Interest Earnings 3,000 176 2,429 3,734 571 81% Bond Proceeds - - - - - 0% Donations 2,000 - 1,965 1,780 35 98% Other Income 54,000 708 2,486 13,481 51,514 5% Transfers In - - - - - 0% Total Revenue 347,000 20,228 117,541 180,543 229,459 34% Expenditures Personnel - - - - - - 0% Supplies 58,512 5,695 32,973 16,751 90,057 (64,518) 210% Services 117,500 5,880 33,197 40,461 2,180 82,123 30% Debt Service 2,000 - - - - 2,000 0% Capital 300,119 123,119 148,442 12,800 164,200 45% Transfers Out - - - - - - 0% Total Expenditures 478,131 11,575 189,289 205,654 105,037 183,805 62% Net (131,131) 8,653 (71,748) (25,111) (105,037)1 45,654 Cash Balance 1,015,456 1,016,127 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Grant revenue results from reimbursement of expenditures specified in the grant plus fees for accident reports, gun permits and false alarm and loud noise fines. Grant revenue is dependent on the timing of the expenditure and does not flow ratably over the course of the year. Grant Revenue for 2013 is down from 2012 as a result of timing on the reimbursement of grants and fewer grants available in 2013. Charges for sevices are up over the prior year due to an icrease in the number of gun permits issued and the timing of the receipt of Court fines. In 2013, Court fines of $13,588 have been received while 2012, Court fines of 15,400 were not received until August. Gun permits year to date are $22,495 in 2013 compared to $15,368 year to date in 2012. Other Income for 2013 compared to 2012 is down to the timing of reciept of annual rent reimbursement for the ATF office in 2012. Explain Significant Spending on Capital Projects Below: The $123,119 of Capital is the result of $100,000 which is a portion of the purchase of the armor vechicle and $23,119 is the purchase of Dell VM /Ware Center Server. Page 42 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Fund /Department Number 227 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 15,796 Grants /Intergovernmental 40% - - Charges for Services - - - Interest Earnings 25,000 759 10,115 Bond Proceeds - - - Donations - - - Other Income 3,804,857 3,798,548 3,804,857 Transfers In - - - Total Revenue 3,829,857 3,799,307 3,814,973 Expenditures - 0% 148.532 74.294 Personnel - - - Supplies 208,000 - - Services 316,033 27,550 64,938 Debt Service - - - Capital 2,152 Transfers Out - - - Total Expenditures 526,185 27,550 64,938 Net 3,303,672 3,771,757 3,750,034 Cash Balance 8,091,595 Staffing Full Time - Part-Time /Season al/Tem porary Total 919 r xpiam aigmricam rtevenue, r= xpenanure ano starring ,- nangesivanances rseiow: Encumbrances include $20K for SB Ethanol Real Estate (neighborhood association taking over pumps), $57,417 to Weaver Boos Consultants for groundwater sampling. Budget for capital are Park & Rec items that should be removed. On 3 Jul the City received a settlement of $3.87 million for litigation from the Oliver brownfield. The Budget balances have been adjusted in July to reflect this activity. The budgeted interest income will also be adjusted accordingly. rxpiam oignincam openaing on t apnai rrojects neiow: No signficant capital projects planned for 2013. There is $2,152 encumbered to reclassed out of Capital. Page 43 Form 3 0% 0% 0% 0% 0% 15,796 14,885 40% - - 0% - 0% (0) 100% - - 0% 15,796 14,884 100% - - 0% - - 208,000 0% 1,601 74,294 176,801 44% - - - 0% 146,931 2,152 0% - - - 0% 148.532 74.294 1 386.953 1 26% 919 r xpiam aigmricam rtevenue, r= xpenanure ano starring ,- nangesivanances rseiow: Encumbrances include $20K for SB Ethanol Real Estate (neighborhood association taking over pumps), $57,417 to Weaver Boos Consultants for groundwater sampling. Budget for capital are Park & Rec items that should be removed. On 3 Jul the City received a settlement of $3.87 million for litigation from the Oliver brownfield. The Budget balances have been adjusted in July to reflect this activity. The budgeted interest income will also be adjusted accordingly. rxpiam oignincam openaing on t apnai rrojects neiow: No signficant capital projects planned for 2013. There is $2,152 encumbered to reclassed out of Capital. Page 43 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Public Safety LOIT IMonth I July Fund /Department Number 249 1 Date Updated 8/16/2013 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 5,892,386 491,032 3,437,225 4,082,128 2,455,161 58% Other Taxes - - - - - 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 8,000 399 5,131 5,100 2,869 64% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In - - 560,580 161,509 560,580 0% Total Revenue 5,900,386 491,431 4,002,936 4,248,738 1,897,450 68% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 7,101,757 1,775,439 5,344,501 3,984,642 1,757,256 75% Total Expenditures 7,101,757 1,775,439 5,344,501 3,984,642 1,757,256 75% Net (1,201,371) (1,284,008) (1,341,565) 264,096 140,194 Cash Balance 1,648,375 1,941,238 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Monies in Fund 249 are transferred quarterly to the General Fund to fund police and fire personnel. A quarterly reconciliaton is prepared and any unspent money is 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. Fund 249 is budgeted to spend over $1.0 million dollars more than it takes in as revenue during 2013 to support public safety personnel costs. The third quarter transfer was made during July 2013. The second quarter accounting summary and reconciliation was prepared on July 5, 2013. This resulted in a return of $338,839.38 (recorded as a transfer in during June) for monies unspent by the police and fire departments in the General Fund. During July, the fire department posted a journal entry to reclassify costs to their public safety LOIT department in the General Fund to correct an accounting error. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Page 44 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Fund /Department Number 251 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 1,052,643 92,229 633,873 660,444 418,771 60% Charges for Services - - - - - 0% Interest Earnings 8,500 338 4,260 5,027 4,240 50% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,061,143 92,567 638,133 665,471 423,010 60% Expenditures Personnel - - - - - - 0% Supplies 400,000 137,020 139,589 - 260,411 100% Services 77,500 - 7,500 67,550 70,000 100% Debt Service - - - - - 0% Capital 758,424 1,430 334,095 220,452 120,563 303,766 60% Transfers Out - - - - - - 0% Total Expenditures 1,235,924 138,450 481,184 288,002 450,974T 303,766 75% Net (174,781) (45,883) 156,948 377,469 (450,974)1 119,245 Cash Balance 1,871,246 1,603,473 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, cxpenonure ano ararring i,nangesivanances aeiow: The 2013 budget includes $400,000 for paving that will be spent during the summer months. PO 210585 to Walsh & Kelly for the material was encumbered in May. First significant purchases for material in July for $137K. Revenue is provided by state - shared gasoline taxes, which are remitted monthly, -- $90K per month. Explain Significant Spending on Capital Projects Below: Made final payment to INDOT for Riverside Trail Phase II - $33,453 Page 45 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Fund /Department Number 252 Month I July Date Updated 1 8/14/2013 Current Current Current Prior 0% 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 3 5,109 (3) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 0 3 5,109 3 0% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 1,630,070 0% Transfers Out - 0% Total Expenditures 1,630,070 0% Net 0 3 (1,624,961) (3) Cash Balance 1,149 647,471 Staffing Full Time - Part-Time /Season al/Tem porary Total r=xpiam aigmricam rtevenue, r= xpenanure ano atarring i,nangesivanances oeiow: 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 in during 2014. am oignincam openaing on t apnai rrojects neiow: year, portable radios were purchased for the Police Del no Page 46 Form 3 Page 47 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant JMonth I July Fund /Department Number 258 1 Date Updated 8/14/2013 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 199,000 30,450 52,950 168,550 15% Charges for Services - - - - - 0% Interest Earnings 2,100 127 1,135 1,600 965 54% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 36,150 13,550 32,638 22,601 37% Transfers In - - - - - 0% Total Revenue 237,250 127 45,134 87,188 192,116 19% Expenditures Personnel 105,514 8,142 61,578 57,283 - 43,936 58% Supplies 4,668 - 1,111 1,718 811 2,746 41% Services 117,248 12,353 44,427 37,033 10,343 62,479 47% Debt Service - - - - - - 0% Capital 1,500 304 304 1,196 20% Transfers Out - - - - - - 0% Total Expenditures 228,930 20,799 107,420 96,034 11,154 1 110,356 1 52% Net 8,320 (20,672) (62,286) (8,846) (11,154)1 81,760 Cash Balance 423,878 460,919 Staffing Full Time 2.00 2.00 2.00 Part-Time /Season al/Tem porary - - - 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 higher in prior year due to timing of receipts. This same time last year, the Human Rights received grant money in the amount of $20,000 to continue to promote awareness of fair housing and fair employment. Expenditures are higher this year with the addition of the new grant money. Explain Significant Spending on Capital Projects Below: A drop down projector and large screen TV has been budgete in capital for the conference room in the new Human Rights building. Page 47 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Fund /Department Number 271 Month I JULY Date Updated 1 8/16/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 100 3 33 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 100 3 33 Expenditures (0) 100% Personnel - - - Supplies 346 0% Services - 0% Debt Service 0% Capital (0) 100% Transfers Out - Total Expenditures 346 - - Net (246) 3 33 Cash Balance 14,354 Staffing Full Time - Part-Time /Season al/Tem porary Total E rxpiam aigmncam Kevenue, r-xpenonure ano ararnng ,- nangesivanances aeiow: 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. rncam apenaing on t apnai r-rojecis neiow: Page 48 Form 3 0% 0% 0% 0% 0% 79 67 33% - - 0% 0% 0% 0% 79 67 33% - - - 0% 8,009 346 (0) 100% - - - 0% 0% 0% 0% 8,009 346 (0) 100% 7.9301 (3461 67 rxpiam aigmncam Kevenue, r-xpenonure ano ararnng ,- nangesivanances aeiow: 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. rncam apenaing on t apnai r-rojecis neiow: Page 48 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month I July Fund /Department Number 273 1 Date Updated 8/13/2013 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 8,000 780 4,598 1,100 3,402 57% Interest Earnings 100 5 65 86 35 65% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 8,100 785 4,663 1,186 3,437 58% Expenditures Personnel - - - - - 0% Supplies - - - - 0% Services 10,149 1,342 5,391 4,759 53% Debt Service - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 10,149 1,342 5,391 - 4,759 53% Net (2,049) (557) (728) 1,186 (1,321) Cash Balance 28,035 24,910 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Morris Performance Arts Center and Palais Royale Marketing Fund was established as a separate non - reverting fund to receive monies from the solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marqee sponsorships; and to accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale. The funds in this account at the end of the fiscal year shall not revert to the general fund. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund Page 49 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Fund /Department Number 280 Month I July Date Updated 1 8/14/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes - 0% Grants /Intergovernmental 185,000 0% Charges for Services - - - Interest Earnings 300 1 9 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 185,300 1 9 Expenditures 45,000 0% Personnel - - - Supplies 45,000 0% Services 40,000 0% Debt Service - 0% Capital 100,000 0% Transfers Out - Total Expenditures 185,000 - - Net 300 1 9 Cash Balance 3,813 Staffing Full Time - Part-Time /Season al/Tem porary Total 783 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Revenue and Expenditures for 2013 will depend on completion of grant related acitivty for remaining open grants. rncanr apenaing on t apnai r-rojecrs neiow: Page 50 Form 3 0% 0% 0% 185,000 0% - - 0% 438 291 3% - - 0% - 0% 222 0% - 0% 660 185,291 0% - - 0% 45,000 0% 40,000 0% - - 0% 124,539 100,000 0% - - 0% 124,539 185,000 0% 123.8791 291 783 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Revenue and Expenditures for 2013 will depend on completion of grant related acitivty for remaining open grants. rncanr apenaing on t apnai r-rojecrs neiow: Page 50 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Fund /Department Number 281 Month I July Date Updated 1 8/13/2013 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 100 5 63 95 37 63% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 100 5 63 95 37 63% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 27,102 27,102 0% Total Expenditures 27,102 - - - 27,102 0% Net (27,002) 5 63 95 (27,065) Cash Balance 27,098 26,997 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Fund to be used only for the expenses of EDC revenue bonds rncanr apenaing on t apnai r-rojecrs neiow: Page 51 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Fund /Department Number 289 Month I July Date Updated 1 8/20/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental - - Charges for Services 3,000 - 16,722 Interest Earnings - 3 22 Bond Proceeds - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 3,000 3 16,744 Expenditures 0% Personnel - - - Supplies 0% Services (237) 108% Debt Service - - Capital 3,000 3,237 Transfers Out - - Total Expenditures 3,000 - 3,237 Net - 3 13,507 Cash Balance 16,186 Staffing Full Time - Part-Time /Season al/Tem porary Total r xpiam aigmricam rtevenue, cxpenonure ano starring ,- nangesivanances rseiow: Charges for Service for HAZ -MAT responses. By ordinance the South Bend Fire Department charges business for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund, responses are made by firefighters of the South Bend Fire Department. rxpiam oignincam openaing on t apnai rrojects neiow: No major capital expenditures are planned through this fund. Major purchases are funded thrc minimal fees collected in this fund are used to replace equipment and gear used in responses. Page 52 Form 3 0% 0% 0% 0% - (13,722) 557% 9 (22) 0% - - 0% 0% 0% 0% 9 13,744 558% - 0% 0% 0% 0% (237) 108% - 0% - (237) 108% 9 (13.507) r xpiam aigmricam rtevenue, cxpenonure ano starring ,- nangesivanances rseiow: Charges for Service for HAZ -MAT responses. By ordinance the South Bend Fire Department charges business for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund, responses are made by firefighters of the South Bend Fire Department. rxpiam oignincam openaing on t apnai rrojects neiow: No major capital expenditures are planned through this fund. Major purchases are funded thrc minimal fees collected in this fund are used to replace equipment and gear used in responses. Page 52 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue Fund /Department Number 291 Month I July Date Updated 1 8/20/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes (11,400) 136% 273 Grants /Intergovernmental - - - Charges for Services 31,300 560 42,700 Interest Earnings 200 18 263 Bond Proceeds - - - Donations - 493 75% Other Income (9,194) 134% 4,296 4,782 Transfers In - - - Total Revenue 31,500 578 42,963 Expenditures - 0% 13,521 5,421 Personnel 2,000 1,507 1,507 Supplies 26,666 8,250 35,221 Services 20,700 12,640 Debt Service - - - Capital 2,300 27,460 Transfers Out - - - Total Expenditures 51,666 9,757 76,828 Net (20,166) (9,179) (33,865) Cash Balance 85,555 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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. Explain Significant Spending on Capital Projects Below: Purchased a new tow vehicle for Indiana River Rescue School Trailer at a cost of $27,460. Fund also maintains and replaces boats, motors and equipment as needed. Page 53 Form 3 0% 0% 0% 0% 26,000 (11,400) 136% 273 (63) 132% - - 0% 0% 0% 0% 26,273 11,463 136% - 493 75% 7,176 639 (9,194) 134% 4,296 4,782 3,278 84% - - - 0% 2,049 (25,160) 1194% - - - 0% 13,521 5,421 (30,583) 159% 12.752 (5.4211 19.120 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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. Explain Significant Spending on Capital Projects Below: Purchased a new tow vehicle for Indiana River Rescue School Trailer at a cost of $27,460. Fund also maintains and replaces boats, motors and equipment as needed. Page 53 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Fund /Department Number 292 Month I July Date Updated 1 8/14/2013 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 110,000 38,532 38,532 97,000 71,468 35% Charges for Services - - - - - 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 110,000 38,532 38,532 97,000 71,468 35% Expenditures Personnel - - - - - 0% Supplies - 36,911 (36,911) 0% Services 10,000 - 10,000 0% Debt Service - - 0% Capital 100,000 100,000 0% Transfers Out - - - 0% Total Expenditures 110,000 - 36,911 - 73,089 34% Net 38,532 1,621 97,000 (1,621) Cash Balance 99,746 98,125 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Change in cash balance is due to the timing of receipts for grant expenditures. The $36,911 Supplies amount is for the purchase of computer software and maintenance for police car communication. Funding from a Federal Grant was received in July. rncanr apenaing on t apnai r-rojecrs neiow: Page 54 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Fund /Department Number 294 Month I July Date Updated 1 8/21/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 6,455 75% 288 Grants /Intergovernmental - - - Charges for Services 26,000 - 19,545 Interest Earnings - 14 187 Bond Proceeds 0% - - Donations - - 0% Other Income 2,500 5% 8,311 Transfers In - - - Total Revenue 28,500 14 19,732 Expenditures 0% 8,467 Personnel - - - Supplies 1,500 71 71 Services 27,000 59 17,181 Debt Service - - - Capital Transfers Out - - - Total Expenditures 28,500 130 17,252 Net - (116) 2,480 Cash Balance 76,296 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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. Increase in Revenue over 2012 is due to additional tuition received for attendance at instruction offered at the SBPD Academy. The increase in expenditures in 2013 over 2012 was due to the cost of offering a course for officers that will be assigned to train new officers. rncanr apenaing on t apnai r-rojecrs neiow: Page 55 Form 3 0% 0% 0% 0% 12,170 6,455 75% 288 (187) 0% - - 0% - 0% 2,500 0% - - 0% 12,458 8,768 69% - - 0% 156 1,429 5% 8,311 9,819 64% - - 0% 0% 0% 8,467 11,248 61% 3.991 12.4801 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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. Increase in Revenue over 2012 is due to additional tuition received for attendance at instruction offered at the SBPD Academy. The increase in expenditures in 2013 over 2012 was due to the cost of offering a course for officers that will be assigned to train new officers. rncanr apenaing on t apnai r-rojecrs neiow: Page 55 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Fund /Department Number 295 Month I July Date Updated 1 8/14/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% - Local Income Taxes 15,000 0% Other Taxes 0% 356 Grants /Intergovernmental 71% - - Charges for Services - - - Interest Earnings 350 19 249 Bond Proceeds - - - Donations 3,250 - - Other Income 38,000 800 6,456 Transfers In - - - Total Revenue 41,600 819 6,705 Expenditures - 0% 30.849 612 Personnel - - - Supplies 14,030 148 2,073 Services 16,875 966 6,035 Debt Service 500 - - Capital 10,575 Transfers Out - - - Total Expenditures 41,980 1,114 8,108 Net (380) (295) (1,403) Cash Balance 105,887 Staffing Full Time - Part-Time /Season al/Tem porary Total 97 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: 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. rncanr apenaing on t apnai r-rojecrs neiow: 1 Page 56 Form 3 0% 0% - 0% 15,000 0% - 0% 356 101 71% - - 0% 100 3,250 0% 6,858 31,544 17% - - 0% 22,314 34,895 16% - - - 0% 3,184 612 11,345 19% 7,665 - 10,840 36% - 500 0% 20,000 10,575 0% - 0% 30.849 612 1 33.260 I 21 97 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: 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. rncanr apenaing on t apnai r-rojecrs neiow: 1 Page 56 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Fund /Department Number 299 Month I July Date Updated 1 8/14/2013 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 100,000 47,406 49,273 52,594 47% Charges for Services - - - - - 0% Interest Earnings 1,000 64 564 527 436 56% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 1,000 23,018 320 (22,018) 2302% Transfers In - - - - - 0% Total Revenue 102,000 64 70,988 50,120 31,012 70% Expenditures Personnel - - - - - - 0% Supplies 60,867 23,867 28,794 8,475 28,525 53% Services 45,000 9,530 22,981 - 35,470 21% Debt Service - - - - 0% Capital 82,706 65,945 10,692 16,761 80% Transfers Out - - - - - 0% Total Expenditures 188,573 - 99,342 62,467 8,475 80,756 57% Net (86,573) 64 (28,354) (12,347) (8,475) (49,744) Cash Balance 306,987 298,912 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This fund was established to receive the Police Department share of money acquired in drug enforcement activity. The $23,018 of Other Income is grant reimbursement for the purchase of the bomb suit acquired by the police department. Expenditures are to be used to fund drug enforcement and training. Explain Significant Spending on Capital Projects Below: The $65,945 of capital includes $62,706 which is the balance of the $162,706 purchase of the SWAT vechicle. Page 57 Form 3 Page 58 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax IMonth I July Fund /Department Number 404 1 Date Updated 8/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - 0% Local Income Taxes 7,846,940 653,912 4,577,381 5,407,167 3,269,559 58% Other Taxes - - - - - 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 80,000 2,500 34,343 49,005 45,657 43% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 805,932 40,514 307,004 542,815 498,928 38% Transfers In - - - - - 0% Total Revenue 8,732,872 696,926 4,918,728 5,998,986 3,814,144 56% Expenditures Personnel - - - - - 0% Supplies 1,140,918 32,631 656,637 16,256 7,242 477,039 58% Services 4,129,385 233,048 2,566,068 2,032,655 299,435 1,263,881 69% Debt Service 2,178,168 657,862 1,936,128 1,958,784 - 242,040 89% Capital 1,133,562 9,936 248,271 1,582,279 112,860 772,431 32% Transfers Out 676,882 - 676,882 756,728 - - 100% Total Expenditures 9,258,915 933,477 6,083,987 6,346,702 419,538 2,755,390 70% Net (526,043) (236,551) (1,165,259) (347,715) (419,538)1 1,058,754 Cash Balance 14,161,744 13,859,729 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Significant revenue increase in 2013, due to the City receiving approximately $136,000 more per month in COIT distribution than in the prior year. The 2013 amended budget is negative because it includes $680,993 in encumbrances at 12/31/12 for projects that were in process. Supplies category shows huge variance (approx. $615,000) as a result of gasoline being budgeted in this fund for 2013. This was not in place in the prior year. For 2013, COIT distribtutions from the County are $653,911.59 per month and are paid through June 30, 2013. The amount shown as Transfers Out of $676,882 is for the curb and sidewalk program. The amount is transferred to the MVH fund 202. Explain Significant Spending on Capital Projects Below: At this same time in June, there was roughly $1.3 million more spent in 2012. Projects include the Northside Trail and the Greenhouse Conservatory which have since been completed. Page 58 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax IMonth I July Fund /Department Number 408 1 Date Updated 1 8/16/2013 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 8,177,352 681,446 4,770,122 5,600,191 3,407,230 58% Other Taxes - - - - - 0% Grants /Intergovernmental - - 0% Charges for Services - - 300 - (300) 0% Interest Earnings 50,000 1,799 22,980 32,064 27,020 46% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 504,660 424,325 409,160 80,335 84% Transfers In - - - - - 0% Total Revenue 8,732,012 683,245 5,217,727 6,041,415 3,514,285 60% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 3,472,389 175,528 1,722,139 651,712 486,467 1,263,783 64% Debt Service 1,039,000 959,663 1,039,000 1,901,453 - - 100% Capital 4,471 - - 22,918 4,471 (0) 100% Transfers Out 4,417,519 1,779,380 3,988,139 2,765,360 - 429,380 90% Total Expenditures 8,933,379 2,914,570 6,749,278 5,341,442 490,938 1,693,163 81% Net (201,367) (2,231,325) (1,531,551) 699,973 (490,938)1 1,821,122 Cash Balance 8,452.860 9,080.233 atti ng Full Time Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, cxpenonure ano ararrmg %,nangesivanances aeiow: Included in the 2013 Transfers Out budget is a $2,700,000 transfer to the MVH Fund 202 for costs of the Street Department. A total of $1,350,000 (50 %) was transferred in April, 2013 and $1,350,000 during July, 2013. This fund also pays debt service for the CEDIT and Morris Performing Arts Center bonds and these bond payments are due in February and July. The 2013 amended budget is negative because in includes $302,741 in encumbrances carried over from 2012 for projects in process at 12/31/12. EDIT tax revenue is received monthly from St. Joseph County as certified by the DLGF. A target penalty fee in the amount of $354,660 was received from TJX Corporation (AJ Wright) in April, 2013. EDIT revenue during 2012 includes $743,906.84 received from the State of Indiana due to a 2011 accounting error. EDIT revenue from the State is $681,445.98 per month and is paid through July, 2013. A total of $1,288,139 has been transferred to the DCI Administration Fund 211. This represents three quarterly payments. All debt service payments have been made for 2013. Explain Significant Spending on Capital Projects Below: Capital spending in 2012 in the amount of $22,918 was for the CSO Trunk Sewer project before the project was discontinued. Page 59 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Fund /Department Number 410 Month I July Date Updated 1 8/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 142 0% 830 Grants /Intergovernmental - - - Charges for Services 142 - - Interest Earnings 1,405 5 65 Bond Proceeds - - - Donations - - - Other Income 68,557 183 3,224 Transfers In - - - Total Revenue 70,104 188 3,289 Expenditures - 0% 200,451 Personnel - - - Supplies 196.4001 (201.331) Services - Debt Service 268,146 Capital - Transfers Out - Total Expenditures 268,146 - - Net (198,042) 188 3,289 Cash Balance 27,043 Staffing Full Time - Part-Time /Season al/Tem porary Total 135 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: The 2013 amended budget is negative because it includes $268,146 in principal payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. rncanr apenaing on t apnai r-rojecrs neiow: Page 60 Form 3 0% 0% 0% 0% - 142 0% 830 1,340 5% - - 0% - - 0% 3,221 65,333 5% - - 0% 4,051 66,815 5% - - 0% 0% 0% 200,451 268,146 0% - - 0% - - 0% 200,451 268,146 0% 196.4001 (201.331) 135 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: The 2013 amended budget is negative because it includes $268,146 in principal payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. rncanr apenaing on t apnai r-rojecrs neiow: Page 60 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Fund /Department Number 655 Month I July 2013 Date Updated 1 8/19/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 177,418 59% 3,060 Grants /Intergovernmental - - - Charges for Services 429,000 36,061 251,582 Interest Earnings 2,700 137 1,958 Bond Proceeds - 252,616 178,160 Donations 173 - - Other Income 6,720 10% 14,953 Transfers In - - - Total Revenue 431,700 36,198 253,541 Expenditures - 100% 255.126 365 Personnel 64,378 28 1,118 Supplies 7,432 347 Services 67,756 1,998 14,429 Debt Service 42,499 11,619 23,238 Capital - Transfers Out 250,000 250,000 Total Expenditures 432,065 13,645 289,132 Net (365) 22,554 (35,591) Cash Balance 825,817 Staffing Full Time - Part-Time /Season al/Tem porary 2.16 Total 2.16 173 rxpiam aigmucam Kevenue, r-xpenaicure ano ararnng ,- nangesivanances aeiow: Program runs from approximately first week in November until the middle of December. Personnel will be hired, supplies will be bought at that time. Any personnel expenditures between now and then will be for unemployment compensation charges. rncam apenaing on t apnai rrojecis neiow: Page 61 Form 3 0% 0% 0% 0% 249,557 177,418 59% 3,060 742 73% - 0% - 0% 0% - 0% 252,616 178,160 59% 173 63,260 2% 365 6,720 10% 14,953 53,327 21% 19,261 55% - 0% 240,000 - 100% 255.126 365 1 142.568 1 67% 173 rxpiam aigmucam Kevenue, r-xpenaicure ano ararnng ,- nangesivanances aeiow: Program runs from approximately first week in November until the middle of December. Personnel will be hired, supplies will be bought at that time. Any personnel expenditures between now and then will be for unemployment compensation charges. rncam apenaing on t apnai rrojecis neiow: Page 61 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Fund /Department Number 705 Month I July Date Updated 1 8/14/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 10 1 5 Bond Proceeds - - - Donations 1,990 - Other Income - 1 Transfers In - - - Total Revenue 2,000 1 6 Expenditures - 0% Personnel - - - Supplies - 0% Services 2,000 0% Debt Service - 0% Capital 2,000 0% Transfers Out - Total Expenditures 2,000 - Net - 1 6 Cash Balance 1,936 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmucam mevenue, cxpenonure ano acarrmg i,nangesivanances aeiow: Fund is for receiving donations for the care of the K -9 units as well as the acquisition of new dogs. No activity yet in 2013. rncam apenaing on t apnai r-rojecis neiow: Page 62 Form 3 0% 0% 0% 0% 0% 8 5 50% - - 0% 1,990 0% (1) 0% - - 0% 8 1,994 0% - - 0% - 0% 2,000 0% - 0% 0% 0% - 2,000 0% 8 (61 rxpiam aigmucam mevenue, cxpenonure ano acarrmg i,nangesivanances aeiow: Fund is for receiving donations for the care of the K -9 units as well as the acquisition of new dogs. No activity yet in 2013. rncam apenaing on t apnai r-rojecis neiow: Page 62 Form 3 Page 63 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service IMonth I July Fund /Department Number 313 1 Date Updated 8/13/2013 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 1,118,460 693,822 622,017 424,638 62% Local Income Taxes - - - - 0% Other Taxes 67,861 - 33,662 40,096 34,199 50% Grants /Intergovernmental 71,468 5,956 41,690 54,273 29,778 58% Charges for Services - - - - - 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 5,900 0% Transfers In - - - - 0% Total Revenue 1,257,789 5,956 769,174 722,286 488,615 61% Expenditures Personnel - - - - - 0% Supplies 0% Services - - - - 0% Debt Service 1,268,000 634,500 1,268,000 1,329,715 100% Capital - - - - 0% Transfers Out - - - - 0% Total Expenditures 1,268,000 634,500 1,268,000 1,329,715 100% Net (10,211) (628,544) (498,826) (607,429) 488,615 Cash Balance 78,546 (8,809) Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund is used to collect a separate property tax levy (distributions received in June and December) and is used to pay debt service on the former College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will typically have a negative cash balance until the property tax distributions are received. PILOT taxes paid by the utilities are received monthly in this fund. Property taxes received in the amount of $693,822.13 during June, 2013 eliminated the negative cash balance in this fund. The property tax collections of $693,822.13 represented 51.73% of the levy amount and 62.03% of the 2013 budgeted revenue amount. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. Both debt service payments have been made for 2013. Explain Significant Spending on Capital Projects Below: None Page 63 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Im rov. Fund /Department Number 288 Month I July Date Updated 1 8/20/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 898,084 0% Other Taxes - 59% 21,286 Grants /Intergovernmental 898,084 - - Charges for Services 2,796,000 229,422 1,652,277 Interest Earnings 20,000 909 12,583 Bond Proceeds - - - Donations - - - Other Income 16,000 191% 21,322 Transfers In - - - Total Revenue 3,730,084 230,331 1,686,181 Expenditures 500,000 50% 574.052 2.268.021 Personnel - - - Supplies 103,539 19,681 143,897 Services 1,045,768 272,343 1,267,635 Debt Service 1,270,596 - Capital 1,161,364 30,462 889,566 Transfers Out 1,000,000 - 500,000 Total Expenditures 4,581,267 322,486 2,801,098 Net (851,183) (92,155) (1,114,917) Cash Balance 4,416,170 Staffing Full Time - Part-Time /Season al/Tem porary Total 588 (2.268.02111 2.531.755 r=xpiam aigmricam rtevenue, r= xpenanure ano atarring i,nangesivanances oeiow: 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. in oignincam openaing on t apnai rrojects neiow: ary PO for new SCBA purchase of $730,095 awainting 80% grant pay out. Page 64 Form 3 0% 0% 0% 898,084 0% 1,484,283 1,143,723 59% 21,286 7,417 63% - - 0% - 0% 27,070 (5,322) 133% - - 0% 1,532,640 2,043,903 45% - - 0% 37,871 53,496 (93,854) 191% 108,582 2,168,434 (2,390,301) 329% - 1,270,596 0% 427,599 46,091 225,707 81% - - 500,000 50% 574.052 2.268.021 1487.8521 111° 588 (2.268.02111 2.531.755 r=xpiam aigmricam rtevenue, r= xpenanure ano atarring i,nangesivanances oeiow: 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. in oignincam openaing on t apnai rrojects neiow: ary PO for new SCBA purchase of $730,095 awainting 80% grant pay out. Page 64 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development IMonth I July Fund /Department Number 377 1 Date Updated 8/13/2013 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 - - 326,101 - 0% Grants /Intergovernmental 600,000 297,215 419,408 302,785 50% Charges for Services - - - - - 0% Interest Earnings 6,500 157 2,023 3,739 4,477 31% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 81,301 36,205 77,851 88,023 3,450 96% Transfers In - - - - - 0% Total Revenue 687,801 36,362 377,089 837,271 310,712 55% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 776,671 388,123 776,470 776,408 201 100% Capital - - - - - 0% Transfers Out 100,000 - 100,000 385,339 - 100% Total Expenditures 876,671 388,123 876,470 1,161,747 201 100% Net (188,870) (351,761) (499,381) (324,476) 310,511 Cash Balance 541,442 777,945 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Effective January 1, 2013, this fund no longer collects hotel /motel tax allocations from St. Joseph County for payment to the Hall of Fame. This fund is currenty used for debt the 2010 Coveleski Stadium bonds (payments due in January and July) and a $100,000 capital transfer to Century Center (paid in January, 2013). 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. Both debt service payments have been made for 2013. Explain Significant Spending on Capital Projects Below: A $100,000 transfer is made annually to the Century Center Capital Fund 671. Page 65 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Fund /Department Number 401 Month I JULY Date Updated 1 8/16/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 500 5 62 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 500 5 62 Expenditures (0) 100% Personnel - - - Supplies 2,002 0% Services 1,538 0% Debt Service - 0% Capital (0) 100% Transfers Out - Total Expenditures 3,540 - - 44.418 Net (3,040) 5 62 Cash Balance 26,821 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aignmcam Kevenue, r-xpenaiture ano acarnng i,nangesivanances aeiow: Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. rncam apenaing on t apnai r-rojecis neiow: Page 66 Form 3 0% 0% 0% 0% 0% 271 438 12% - - 0% 0% 0% 0% 271 438 12% - - - 0% 4,985 2,002 (0) 100% 33,462 1,538 - 100% - - 0% 0% - - 0% 38,447 3,540 (0) 100% 38,176) (3,540)1 438 44.418 rxpiam aignmcam Kevenue, r-xpenaiture ano acarnng i,nangesivanances aeiow: Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. rncam apenaing on t apnai r-rojecis neiow: Page 66 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Fund /Department Number 403 Month I JULY Date Updated 1 8/16/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 200 9 114 Bond Proceeds - - - Donations 2,700 0% Other Income - 0% Transfers In - - - Total Revenue 2,900 9 114 Expenditures 0% Personnel - - - Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out Total Expenditures - - - 48.778 Net 2,900 9 114 Cash Balance 48,960 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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. rncanr apenaing on t apnai r-rojecrs neiow: Page 67 Form 3 0% 0% 0% 0% 0% 143 86 57% - - 0% 13,000 2,700 0% - - 0% - - 0% 13,143 2,786 4% - - 0% 0% 0% 0% 0% 0% 0% 13,143 2,786 48.778 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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. rncanr apenaing on t apnai r-rojecrs neiow: Page 67 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Fund /Department Number 405 Month I JULY Date Updated 1 8/16/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes (11) 100% 1,353 Grants /Intergovernmental - - - Charges for Services 3,000 858 3,011 Interest Earnings 2,200 67 995 Bond Proceeds - - - Donations - - - - Other Income - 5,000 13,305 Transfers In 198,300 - - Total Revenue 203,500 5,925 17,311 Expenditures - 0% 105,851 26,048 Personnel - - - Supplies 13,816 7,339 60,046 Services - 20 20 Debt Service - - - Capital 203,500 (85) 12,382 Transfers Out - - - Total Expenditures 217,316 7,275 72,449 Net (13,816) (1,350) (55,137) Cash Balance 437,248 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam oigmricanr mevenue, cxpenonure ano ararrmg i,nangesivanances aeiow: The cash balance includes $60,300 that is restricted to expenditures in voorde Park. 377.738 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. Page 68 Form 3 0% 0% 0% 0% 2,443 (11) 100% 1,353 1,205 45% - - 0% - 0% 12,764 (13,305) 0% - 198,300 0% 16,559 186,189 9% - - - 0% 30,236 9,999 (56,230) 507% 11,929 4,850 (4,870) 0% - - - 0% 63,686 11,198 179,919 12% - - - 0% 105,851 26,048 118,820 45% (89.292) (26.048)1 67.369 377.738 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. Page 68 Form 3 Page 69 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development IMonth I July Fund /Department Number 406 1 Date Updated 8/16/2013 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 530,000 253,553 284,256 276,447 48% Local Income Taxes - - - - 0% Other Taxes 34,271 19,926 20,445 14,345 58% Grants /Intergovernmental - - - - 0% Charges for Services - - - - - 0% Interest Earnings 4,000 129 1,876 2,550 2,124 47% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 46,054 - 212 - 45,842 0% Transfers In - 3,838 26,865 25,531 26,865 0% Total Revenue 614,325 3,966 302,432 332,782 311,893 49% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 504 42 294 371 210 58% Debt Service 874,716 - 352,798 217,072 521,919 40% Capital 36,000 - 13,600 36,000 0% Transfers Out - - - - - 0% Total Expenditures 911,220 42 353,092 231,042 558,129 39% Net (296,895) 3,924 (50,659) 101,740 (246,236) Cash Balance 785,110 923,970 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund receives revenue from a property tax levy and distibutions 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. Property tax revenue in the amount of $253,553 was received on June 18, 2013. This amount represents 51.73% of the tax levy and 47.84% of the 2013 revenue budget. 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: The 2013 budget includes $36,000 for three street crime (SOS) vehicles and various leased vehicles. Page 69 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement IMonth I July Fund /Department Number 407 1 Date Updated 8/16/2013 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 408,990 150,000 279,108 126,415 129,882 68% Charges for Services - - - - - 0% Interest Earnings 100 1 85 15 15 85% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 25,000 5,900 25,000 0% Transfers In - - - - - 0% Total Revenue 434,090 150,001 279,193 132,331 154,897 64% Expenditures Personnel - - - - - 0% Supplies 0% Services - - - - 0% Debt Service 367,575 182,700 367,575 402,277 100% Capital - - - - 0% Transfers Out - - - - 0% Total Expenditures 367,575 182,700 367,575 402,277 100% Net 66,515 (32,699) (88,382) (269,946) 154,897 Cash Balance 9,339 (219,187) Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Revenue is this fund includes $150,000 in hotel /motel taxes and $258,990 in cigarette taxes from other units of government. The hotel /motel tax distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December. In 2013, this fund is used to pay 75% of the 2011 Century Center Refunding bonds (paid 100% in 2012). 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. Cigarette tax revenue in the amount of $129,108.07 was received on June 10, 2013, which is approximately 50% of the 2013 budgeted revenue amount. The hotel /motel tax amount of $150,000 was received on July 24, 2013. Both debt service payments have been made for 2013. Explain Significant Spending on Capital Projects Below: None Page 70 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction IMonth I July Fund /Department Number 412 1 Date Updated 8/16/2013 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 54,000 1,283 18,356 32,451 35,644 34% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 474,662 237,331 41,442 237,331 50% Transfers In - - - - - 0% Total Revenue 528,662 1,283 255,687 73,893 272,975 48% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 3,395,846 123,222 1,015,738 584,601 1,397,548 982,559 71% Transfers Out - - - - - - 0% Total Expenditures 3,395,846 123,222 1,015,738 584,601 1,397,548 982,559 71% Net (2,867,184) (121,939) (760,052) (510,708) (1,397,548) (709,584) Cash Balance 7,136,645 8,813,647 Staffing Full Time - Part-Time /Season al/Tem porary 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 $941,728 (Douglas Road) and $5,068,653 (Eddy Street /Triangle) at April 30, 2013. Explain Significant Spending on Capital Projects Below: DLZ for Olive /Sample Overpass: 279,189 DLZ for 2 -way streets feasibility: 110,018 HRP for Triangle neighborhood: 53,196 INDOT US 31 Utility Relocation $573,335 in June Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Fund /Department Number 416 Month I July Date Updated 1 8/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 35,255 65% 1,466 Grants /Intergovernmental - - - Charges for Services 100,000 3,986 64,745 Interest Earnings 1,500 77 940 Bond Proceeds - - - Donations - - - 0% Other Income 15,444 39% 9,436 4,265 Transfers In - - - Total Revenue 101,500 4,063 65,685 Expenditures - 0% 163.986 21.783 Personnel - - - Supplies 25,500 1,413 2,656 Services 20,970 - 11,945 Debt Service - - - Capital 26,196 9,278 15,828 Transfers Out - - - Total Expenditures 72,666 10,691 30,429 Net 28,834 (6,628) 35,256 Cash Balance 431,524 Staffing Full Time N/A N/A N/A Part-Time /Season al/Tem porary N/A N/A N/A Total r=xpiam aigmncam rtevenue, r= xpenanure ano atarnng ,- nangesivanances rseiow: Summer months are "slow" months. 377 rxpiam oignincam openaing on t apnai rrojects t5eiow: During 2012, Fund 416 was used to pay for major upgrades throughout the building: replaced all of the windows floor) and Rotunda / Mezzanine (second floor), remodelled Restrooms at the Bistro level. 1 Page 72 Form 3 0% 0% 0% 0% 59,005 35,255 65% 1,466 560 63% - - 0% 0% 0% 0% 60,471 35,815 65% - - - 0% 6,274 7,400 15,444 39% 9,436 4,265 4,760 77% - - - 0% 148,276 10,118 250 99% - - - 0% 163.986 21.783 1 20.454 1 72% 377 rxpiam oignincam openaing on t apnai rrojects t5eiow: During 2012, Fund 416 was used to pay for major upgrades throughout the building: replaced all of the windows floor) and Rotunda / Mezzanine (second floor), remodelled Restrooms at the Bistro level. 1 Page 72 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Fund /Department Number 434 Month I July Date Updated 1 8/13/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes - 0% Other Taxes 650,000 0% Grants /Intergovernmental - 0% Charges for Services - - - Interest Earnings 1,000 38 379 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 651,000 38 379 Expenditures 0% Personnel - - - Supplies 836,975 4% Services - - Debt Service 873,949 36,975 Capital - - Transfers Out - - Total Expenditures 873,949 - 36,975 Net (222,949) 38 (36,596) Cash Balance 186,991 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr mevenue, r-xpenairure ano ararrmg i,nangesivanances aeiow: Variance relates to change in interest cost on amortization schedule. Revenue not expected until October or November. Principal payment made in August. rncanr apenaing on t apnai r-rojecrs neiow: Page 73 Form 3 0% 0% 650,000 0% - 0% - - 0% 713 621 38% - - 0% 0% 0% 0% 713 650,621 0% - - 0% 0% 0% 878,554 836,975 4% - - 0% - - 0% 878,554 836,975 4% R77_Rd11 /1 Rf'i35d1 rxpiam aigmricanr mevenue, r-xpenairure ano ararrmg i,nangesivanances aeiow: Variance relates to change in interest cost on amortization schedule. Revenue not expected until October or November. Principal payment made in August. rncanr apenaing on t apnai r-rojecrs neiow: Page 73 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Fund /Department Number 450 Month I July Date Updated 1 8/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 177 Grants /Intergovernmental 112% - - Charges for Services - - - Interest Earnings 125 11 140 Bond Proceeds - - - Donations - - - Other Income 16,000 2,722 8,118 Transfers In - - - Total Revenue 16,125 2,733 8,258 Expenditures 0% Personnel - - - Supplies 7.100 7.867 Services Debt Service Capital Transfers Out Total Expenditures Net 16,125 2,733 8,258 Cash Balance 66,562 Staffing Full Time N/A N/A N/A Part-Time /Season al/Tem porary N/A N/A N/A Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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 2013. rncanr apenaing on t apnai r-rojecrs neiow: endinq in this fund. Page 74 Form 3 0% 0% 0% 0% 0% 177 (15) 112% - - 0% - - 0% 6,924 7,882 51% - - 0% 7,100 7,867 51% - - 0% 0% 0% 0% 0% 0% 0% 7.100 7.867 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: 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 2013. rncanr apenaing on t apnai r-rojecrs neiow: endinq in this fund. Page 74 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Fund /Department Number 677 Month I July Date Updated 1 8/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 2,894 Grants /Intergovernmental 37% - - Charges for Services - - - Interest Earnings 4,500 127 1,669 Bond Proceeds - - - Donations - - - Other Income 11,876 21% 42 Transfers In - - - Total Revenue 4,500 127 1,711 Expenditures 0% 260,832 Personnel - - - Supplies 15,000 766 3,124 Services 164,322 12,821 35,894 Debt Service - - - Capital Transfers Out - - - Total Expenditures 179,322 13,587 39,018 Net (174,822) (13,460) (37,307) Cash Balance 681,780 Staffing Full Time - Part-Time /Season al/Tem porary Total r=xpiam aigmricam rtevenue, r= xpenanure ano starring ,- nangesivanances rseiow: The Hall of Fame Capital fund covers maintenance and utilitilies 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. rncam apenaing on t apnai rrojects neiow: penditures budgeted for 2013. Page 75 Form 3 0% 0% 0% 0% 0% 2,894 2,831 37% - - 0% - - 0% 107,313 (42) 0% - - 0% 110,207 2,789 38% - - 0% - 11,876 21% 260,832 128,428 22% - - 0% 0% 0% 260,832 140,304 22% 150.6251 (137.5151 r=xpiam aigmricam rtevenue, r= xpenanure ano starring ,- nangesivanances rseiow: The Hall of Fame Capital fund covers maintenance and utilitilies 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. rncam apenaing on t apnai rrojects neiow: penditures budgeted for 2013. Page 75 Form 3 Page 76 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Department jMonth I July Fund /Department Number 600 1 Date Updated 8/13/2013 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 1,147,035 73,164 539,880 507,315 607,155 47% Interest Earnings 1,000 33 468 189 532 47% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 1,089 8,017 (1,089) 0% Transfers In - - - - - 0% Total Revenue 1,148,035 73,197 541,437 515,521 606,598 47% Expenditures Personnel 957,635 67,303 496,130 442,182 10,771 450,734 53% Supplies 28,079 1,923 16,981 13,967 4,466 6,632 76% Services 105,031 5,822 40,461 29,939 483 64,087 39% Debt Service 14,707 2,905 10,159 4,350 - 4,548 69% Capital 42,700 - - - 42,700 0% Transfers Out - - - 11,284 - - 0% Total Expenditures 1,148,152 77,953 563,731 501,722 15,720 568,701 50% Net (117) (4,756) (22,294) 13,799 (15,720)1 37,897 Cash Balance 181,556 83,455 Staffing Full Time 15.00 14.00 14.00 Part-Time /Season al/Tem porary - - - Total 15.00 14.00 14.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: July's fees were lower than previous year's; and reflects 10.75% drop in permit fees. Explain Significant Spending on Capital Projects Below: The Capital Accounts are set up for a new copier for the office and Ipads with software to get the Inspectors computerized and eliminate paperwork. However, it will not be reflected in the Capital Accounts; but in leases and supplies accounts, which is shown in our increase in supplies and services. Page 76 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages Fund /Department Number 601 Month I July Date Updated 1 8/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 437,114 54% 2,995 Grants /Intergovernmental - - - Charges for Services 943,635 77,271 506,521 Interest Earnings 4,000 143 1,967 Bond Proceeds - - - Donations - - - Other Income 199,177 39,220 81,276 Transfers In - - - Total Revenue 1,146,812 116,634 589,764 Expenditures - 0% 677,273 192,873 Personnel - - - Supplies - - - Services 688,645 94,346 418,899 Debt Service - - - Capital 441,194 2,888 152,723 Transfers Out - - - Total Expenditures 1,129,839 97,234 571,622 Net 16,973 19,400 18,142 Cash Balance 873,586 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Last year's capital projects were:upgrade automation in garages. 2013 projects are: upgrade lighting; new signage; trash receptacles; and membrane in Leighton. 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. rncanr apenaing on t apnai rrojecrs neiow: ct underway. Page 77 Form 3 0% 0% 0% 0% 511,165 437,114 54% 2,995 2,033 49% - - 0% - - 0% 74,911 117,901 41% - - 0% 589,071 557,048 51% - - 0% - - 0% 377,883 269,746 61% - - - 0% 299,390 192,873 95,598 78% - - - 0% 677,273 192,873 365,344 68% (88.202) (192.8731 191.704 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Last year's capital projects were:upgrade automation in garages. 2013 projects are: upgrade lighting; new signage; trash receptacles; and membrane in Leighton. 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. rncanr apenaing on t apnai rrojecrs neiow: ct underway. Page 77 Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations IMonth I July Fund /Department Number 610 1 Date Updated 8/8/2013 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 4,815,830 406,398 2,831,442 2,791,428 1,984,388 59% Interest Earnings 6,000 132 2,823 4,004 3,177 47% Bond Proceeds - - - 0% Donations - - - 0% Other Income 435,871 178,820 191,820 26,000 244,051 44% Transfers In - - - - - 0% Total Revenue 5,257,701 585,350 3,026,085 2,821,432 2,231,616 58% Expenditures Personnel 1,661,801 143,608 980,205 877,602 1,637 679,959 59% Supplies 241,565 98,184 227,134 148,918 7,745 6,686 97% Services 2,878,557 228,599 1,581,804 1,778,625 530,160 766,593 73% Debt Service - - - - - - 0% Capital - - - - 0% Transfers Out 784,061 315,900 830,239 135,000 46,178 106% Total Expenditures 5,565,984 786,291 3,619,382 2,940,145 539,542 1,407,060 75% Net (308,283) (200,940) (593,297) (118,713) (539,542)1 824,556 Cash Balance 605,825 1,055,211 Staffing Full Time 28.10 26.10 27.10 Part-Time /Season al/Tem porary 7.00 7.00 7.00 Total 35.10 33.10 34.10 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Service revenue is on track with budget projections. Other Income is expected to reach budgeted levels by year end. Operating costs in some areas are running on the high side. Careful monitoring will be required during the last half of the year to avert budget shortfalls. A grant totaling $178,820 was received from IDEM in July 2013, to be used for 2 CNG- powered refuse trucks. Encumbrances for Services of $530,000 are comprised mainly of reserves for Green Tech Transfer & Recycling ($257,000) and the Solid Waste dept ($212,000). Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Fund /Department Number 611 Month I July Date Updated 1 7/30/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 109% - Charges for Services - - - Interest Earnings 200 37 218 Bond Proceeds - - - Donations 0% Other Income - - - Transfers In 784,061 315,900 830,239 Total Revenue 784,261 315,937 830,457 Expenditures - 0% 52.750 Personnel - - - Supplies Services - - - Debt Service 734,061 188,809 513,511 Capital 50,000 - - Transfers Out - - - Total Expenditures 784,061 188,809 513,511 Net 200 127,128 316,946 Cash Balance 317,054 Staffing Full Time - Part-Time /Season al/Tem porary Total 206 135,000 135,206 135,893 3,406 139,299 (4,092 11,728 7 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Debt Service payments increased in 2013 due to four new trucks, additional containers, and tag readers lease- purchased late in 2012. rncanr apenaing on t apnai rrojecrs neiow: Page 79 Form 3 0% 0% 0% 0% 0% (18) 109% - 0% 0% 0% 46,178 106% 46,196 106% 0% 0% 0% - 220,550 70% 52,750 (2,750) 106% - - 0% 52.750 1 217.800 1 72% 7 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Debt Service payments increased in 2013 due to four new trucks, additional containers, and tag readers lease- purchased late in 2012. rncanr apenaing on t apnai rrojecrs neiow: Page 79 Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations IMonth I July Fund /Department Number 620 1 Date Updated 8.14.13 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 14,526,748 1,208,876 8,109,693 8,139,140 6,417,055 56% Interest Earnings 9,000 299 3,715 6,286 5,285 41% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 135,500 1,182 88,295 119,602 47,205 65% Transfers In 16,500 779 8,868 47,196 7,632 54% Total Revenue 14,687,748 1,211,136 8,210,571 8,312,224 6,477,177 56% Expenditures Personnel 4,434,851 337,241 2,393,299 2,360,027 7,493 2,034,059 54% Supplies 1,107,134 89,824 531,779 450,791 77,552 497,803 55% Services 5,037,006 499,074 2,274,492 1,967,128 217,099 2,545,415 49% Debt Service 58,732 4,304 32,718 32,718 21,556 4,458 92% Capital - - - - - - 0% Transfers Out 4,158,224 316,895 2,375,245 2,772,850 - 1,782,979 57% Total Expenditures 14,795,947 1,247,338 7,607,533 7,583,514 323,700 6,864,714 54% Net (108,199) (36,202) 603,038 728,710 (323,700) (387,537) Cash Balance 2,274,915 2,232,127 Staffing Full Time 72.05 69.05 69.05 Part-Time /Season al/Tem porary 3.00 3.50 3.50 Total 75.05 72.55 72.55 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Current year to date operating revenues are 1 % below same time period in 2012. Supplies previously purchased in the capital fund have contributed to the category increase. Several service providers are engaged in performing basic system maintenance work as well as the continuation of the leak detection program. No operating transfers are required to fund capital improvement projects. Other Income is slightly higher than budgeted due to one -time revenues of $34,000 for the sale of used water meters in June. Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Fund /Department Number 622 Month I July Date Updated 1 8.14.13 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 4,223 Grants /Intergovernmental 69% - - Charges for Services - - - Interest Earnings 14,000 702 9,630 Bond Proceeds - - - Donations - - 0% Other Income 0% 28,700 6,000 Transfers In - - - Total Revenue 14,000 702 9,630 Expenditures - 0% Personnel - - - Supplies - - - Services 26,050 6,000 20,050 Debt Service - - - Capital 1,190,742 25,788 218,927 Transfers Out - - - Total Expenditures 1,216,792 31,788 238,977 Net (1,202,792) (31,086) (229,347) Cash Balance 3,915,971 Staffing Full Time - Part-Time /Season al/Tem porary Total 1 4 (401.27011 (572.17 rxpiam aigmricanr Kevenue, r-xpenairure ano aramng -nangesivariances aeiow: Prior year to date revenue reflects reimbursement monies ($585,516) from the 2012 revenue bond proceeds for previously purchased water meters. Current year reduction in spending is due to change in capitalization practice with most budgeted items being accounted for in the O & M Fund. The variance in the cash balance is caused by a $2,300,000 transfer in of surplus monies from the operating fund in Dec. 2012. rncanr apenaing on t apnai r-rojecrs neiow: Page 81 Form 3 0% 0% 0% 0% 0% 4,223 4,370 69% - - 0% - 0% 585,516 0% 374,099 0% 963,838 4,370 69% - - 0% - - 0% 28,700 6,000 100% - - 0% 842,824 395,270 576,545 52% - - - 0% 4 (401.27011 (572.17 rxpiam aigmricanr Kevenue, r-xpenairure ano aramng -nangesivariances aeiow: Prior year to date revenue reflects reimbursement monies ($585,516) from the 2012 revenue bond proceeds for previously purchased water meters. Current year reduction in spending is due to change in capitalization practice with most budgeted items being accounted for in the O & M Fund. The variance in the cash balance is caused by a $2,300,000 transfer in of surplus monies from the operating fund in Dec. 2012. rncanr apenaing on t apnai r-rojecrs neiow: Page 81 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Fund /Department Number 623 Month I July Date Updated 1 8.14.13 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 1,968 Grants /Intergovernmental 69% 8,345,333 - Charges for Services - - - Interest Earnings 18,000 813 12,489 Bond Proceeds - - - Donations - - - 0% Other Income (2,022,861) 0% - Transfers In - - - Total Revenue 18,000 813 12,489 Expenditures - 0% 1,417,339 3,770,873 Personnel - - - Supplies 6,929,962 (3,770,873)1 320,700 595,608 Services - - Debt Service - - Capital 4,826,536 (25,555) 884,721 Transfers Out - - - Total Expenditures 4,826,536 295,145 1,480,329 Net (4,808,536) (294,332) (1,467,840) Cash Balance 4,334,996 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr mevenue, r-xpenairure ano ararring i,nangesivanances aeiow: In period 7, a $320,700 meter supply expenditure was reclassified from capital. Water meter purchases for the year are expected to be in the range of $1,296,525. A Mid -Year Budget Transfer Request was submitted to establish a meter supply budget. Other transfer requests included were for the reallocation of budget dollars for the Pinhook WTP Efficiency Improvements Projec. An Additional Appropriation Request was also necessary to establish a budget for additional improvements awarded to the Pinhook Project. Explain Significant Spending on Capital Projects Below: The Pinhook Construction Project is 8.72% complete for services provided through 6.30.13. Page 82 Form 3 0% 0% 0% 0% 0% 1,968 5,511 69% 8,345,333 - 0% - 0% 0% - 0% 8,347,301 5,511 69% - - - 0% 1,427,253 (2,022,861) 0% - 0% - - 0% 1,417,339 2,343,620 1,598,195 67% - 0% 1,417,339 3,770,873 (424,666) 109% 6,929,962 (3,770,873)1 430,177 7,076.776 rxpiam aigmricanr mevenue, r-xpenairure ano ararring i,nangesivanances aeiow: In period 7, a $320,700 meter supply expenditure was reclassified from capital. Water meter purchases for the year are expected to be in the range of $1,296,525. A Mid -Year Budget Transfer Request was submitted to establish a meter supply budget. Other transfer requests included were for the reallocation of budget dollars for the Pinhook WTP Efficiency Improvements Projec. An Additional Appropriation Request was also necessary to establish a budget for additional improvements awarded to the Pinhook Project. Explain Significant Spending on Capital Projects Below: The Pinhook Construction Project is 8.72% complete for services provided through 6.30.13. Page 82 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Fund /Department Number 624 Month I July Date Updated 1 8.14.13 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 4,904 Grants /Intergovernmental 54% - - Charges for Services - - - Interest Earnings 6,100 252 3,269 Bond Proceeds - - - Donations - - 0% Other Income 0% Transfers In - - - Total Revenue 6,100 252 3,269 Expenditures 691 83% 4,904 Personnel - - - Supplies 2.140 Services Debt Service Capital - - - Transfers Out 4,000 252 3,309 Total Expenditures 4,000 252 3,309 Net 2,100 - (40) Cash Balance 1,446,456 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aignmcam Kevenue, r-xpenaicure ano ararnng ,- nangesivanances aeiow: Minimal change in customer meter deposit fund. rncam apenaing on t apnai r-rojecis rseiow: 1 Page 83 Form 3 0% 0% 0% 0% 0% 4,904 2,831 54% - - 0% 0% 0% 0% 4,904 2,831 54% - - 0% 0% 0% 0% 0% 4,904 691 83% 4,904 691 83% 2.140 1 Page 83 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Fund /Department Number 625 Month I July Date Updated 1 8.14.13 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 2,821 Grants /Intergovernmental 17% - - Charges for Services - - - Interest Earnings 5,000 171 864 Bond Proceeds - - - Donations - - 0% Other Income - - - Transfers In 2,103,381 170,953 1,196,671 Total Revenue 2,108,381 171,124 1,197,535 Expenditures 4,136 17% 353,925 Personnel - - - Supplies 590.286 1 1787.0211 Services - - - Debt Service 2,103,381 300 409,650 Capital - - - Transfers Out 5,000 171 864 Total Expenditures 2,108,381 471 410,514 Net 170,653 787,021 Cash Balance 791,657 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmncam Kevenue, r-xpenaicure ano acarnng -nangesivariances aeiow: The increase in the current year to date transfer in is predominantly due to an upcoming first principle installment due on the 2012 Revenue Bonds. rncam apenaing on t apnai r-rojecis neiow: Page 84 Form 3 0% 0% 0% 0% 0% 2,821 4,136 17% - - 0% 0% 0% 941,390 906,710 57% 944,211 910,846 57% - - 0% 0% 0% 351,104 1,693,731 19% - - 0% 2,821 4,136 17% 353,925 1,697,867 19% 590.286 1 1787.0211 rxpiam aigmncam Kevenue, r-xpenaicure ano acarnng -nangesivariances aeiow: The increase in the current year to date transfer in is predominantly due to an upcoming first principle installment due on the 2012 Revenue Bonds. rncam apenaing on t apnai r-rojecis neiow: Page 84 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Fund /Department Number 626 Month I July Date Updated 1 8.12.13 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 1,671 Grants /Intergovernmental 55% - - Charges for Services - - - Interest Earnings 5,700 252 3,137 Bond Proceeds - - - Donations - - - Other Income 0% Transfers In 307,809 17,462 161,910 Total Revenue 313,509 17,714 165,047 Expenditures 0% Personnel - - - Supplies 756,750 148,462 Services Debt Service Capital Transfers Out Total Expenditures - - - Net 313,509 17,714 165,047 Cash Balance 1,476,735 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmucam mevenue, cxpenonure ano ararnng ,- nangesivanances aeiow: The higher year to date cash balance is attributed to the additional debt service reserve requirement for the Revenue Bonds of 2012. rncam apenaing on t apnai r-rojecis neiow: Page 85 Form 3 0% 0% 0% 0% 0% 1,671 2,563 55% - - 0% - 0% 0% 755,079 145,899 53% 756,750 148,462 53% - - 0% 0% 0% 0% 0% 0% 0% 756,750 148,462 1,183.152 rxpiam aigmucam mevenue, cxpenonure ano ararnng ,- nangesivanances aeiow: The higher year to date cash balance is attributed to the additional debt service reserve requirement for the Revenue Bonds of 2012. rncam apenaing on t apnai r-rojecis neiow: Page 85 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Fund /Department Number 629 Month I July Date Updated 1 8.14.13 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of 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,500 356 4,695 6,950 2,805 63% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 45,301 - 45,301 121,426 - 100% Total Revenue 52,801 356 49,996 128,376 2,805 95% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 7,500 356 4,695 6,950 2,805 63% Total Expenditures 7,500 356 4,695 6,950 2,805 63% Net 45,301 - 45,301 121,426 Cash Balance 2,031,532 1,986,231 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Current year to date transfer in is to satisfy the 16.7% O& M Reserve Requirement for 2013. rncanr apenaing on t apnai r-rojecrs neiow: Page 86 Form 3 Page 87 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance jMonth I July 2013 Fund /Department Number 640 1 Date Updated 8/19/2013 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 548,000 45,344 318,709 316,187 229,291 58% Interest Earnings 1,200 217 2,781 3,451 (1,581) 232% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 549,200 45,561 321,489 319,638 227,711 59% Expenditures Personnel 117,515 8,743 64,149 39,783 53,366 55% Supplies 16,771 856 12,799 19,969 1,908 2,065 88% Services 393,083 18,396 124,937 118,631 11,944 256,202 35% Debt Service 28,475 14,218 14,257 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 555,844 27,995 216,103 178,383 13,852 325,889 41% Net (6,644) 17,566 105,386 141,254 (13,852) (98,179) Cash Balance 1,267,695 1,062,394 Staffing Full Time 1.30 1.30 1.30 Part-Time /Season al/Tem porary - - - Total 1.30 1.30 1.30 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Increase in year to date actual versus ytd 2012 is due to the approval of stand -by pay for sewer personnel who are on 24 hour rotating on -call status for after -hours sewer calls. Explain Significant Spending on Capital Projects Below: Page 87 Form 3 Page 88 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations JMonth I July Fund /Department Number 641 1 Date Updated 8/12/2013 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 33,083,547 2,688,744 18,136,445 18,124,566 14,947,102 55% Interest Earnings 12,000 881 9,853 10,901 2,147 82% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 18,000 5,624 28,962 45,206 (10,962) 161% Transfers In 18,000 577 10,937 70,632 7,063 61% Total Revenue 33,131,547 2,695,827 18,186,198 18,251,305 14,945,349 55% Expenditures Personnel 6,750,288 492,822 3,647,061 3,172,129 2,888 3,100,339 54% Supplies 2,117,515 130,918 944,359 930,679 487,584 685,572 68% Services 9,639,925 765,513 6,082,875 5,904,017 1,894,916 1,662,134 83% Debt Service 314,896 108,371 241,750 83,333 - 73,146 77% Capital - - - - - 0% Transfers Out 16,159,614 774,514 5,794,909 6,337,260 - 10,364,705 36% Total Expenditures 34,982,238 2,272,137 16,710,954 16,427,418 2,385,388 1 15,885,896 55% Net (1,850,691) 423,690 1,475,244 1,823,887 (2,385,388) (940,546) Cash Balance 5,720,371 4,384,177 Staffing Full Time 96.80 95.80 95.80 Part-Time /Season al/Tem porary 13.28 7.58 7.58 Total 110.08 103.38 103.38 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Service expenses are high because a number of Wastewater projects budgeted as Capital (Fund 642) spending no longer qualify under the new 2013 guidelines. A mid -year appropriation from fund 642 back to this fund will help reconcile some of this overage. Transfers out are well below budget because the funds don't need to be moved for those projects that no longer qualify as capital. Lower than expected PT /Seasonal help due to reduced usage at Sewer Dept and Organic resources. Explain Significant Spending on Capital Projects Below: Capital spending for Sewage Works is in Fund 642. Page 88 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Fund /Department Number 642 Month I July Date Updated 1 7/30/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 32,952 Grants /Intergovernmental 32% - - Charges for Services - - - Interest Earnings 60,000 1,296 19,483 Bond Proceeds - - - Donations - - 0% Other Income - 0% 255,386 Transfers In 4,500,000 - - Total Revenue 4,560,000 1,296 19,483 Expenditures - 0% 2,817,811 7,102,840 Personnel - - - Supplies - 1.895.978 - Services 335,200 79,814 Debt Service - - - Capital 11,438,873 322,960 1,946,880 Transfers Out - - - Total Expenditures 11,774,073 322,960 2,026,694 Net (7,214,073) (321,664) (2,007,211) Cash Balance 6,855,898 Staffing Full Time - Part-Time /Season al/Tem porary Total 8 r=xpiam aigmricant mevenue, r= xpenanure ano atarrmg i,nangesivanances rseiow: 2013 Budgeted transfers in for Capital spending will be minimal this year due to the revised thresholds for items to qualify as Capital. rx iam ai nincam openaing on t a nai rro ects neiow: Year to date: Michigan St. Lift Station replacement $403K, Automation of DO Controls at WWTP $190K, Engineering work on upcoming projects $54K, Site improvement work at Organic Resources $31 K, Completion of Triangle Neighborhood infrastructure $41 K, Work on 27th St Lift Station $20K, Pumps at WWTP $75K, Primary Clarifier Rehab $79K, Manhole rehab $258K, and trenching safety equipment at Sewers $16K. Page 89 Form 3 0% 0% 0% 0% 0% 32,952 40,517 32% - - 0% 0% 0% 1,914,632 4,500,000 0% 1,947,584 4,540,517 0% - - 0% 0% 255,386 100% - - 0% 2,817,811 6,847,455 2,644,539 77% - - - 0% 2,817,811 7,102,840 2,644,539 78% (870.227) (7.102.84011 1.895.978 8 r=xpiam aigmricant mevenue, r= xpenanure ano atarrmg i,nangesivanances rseiow: 2013 Budgeted transfers in for Capital spending will be minimal this year due to the revised thresholds for items to qualify as Capital. rx iam ai nincam openaing on t a nai rro ects neiow: Year to date: Michigan St. Lift Station replacement $403K, Automation of DO Controls at WWTP $190K, Engineering work on upcoming projects $54K, Site improvement work at Organic Resources $31 K, Completion of Triangle Neighborhood infrastructure $41 K, Work on 27th St Lift Station $20K, Pumps at WWTP $75K, Primary Clarifier Rehab $79K, Manhole rehab $258K, and trenching safety equipment at Sewers $16K. Page 89 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Fund /Department Number 643 Month I July Date Updated 1 7/30/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 11,129 Grants /Intergovernmental 41% - - Charges for Services - - - Interest Earnings 18,000 577 7,413 Bond Proceeds - - - Donations - 0% Other Income - 0% - Transfers In 109,098 - 200,296 Total Revenue 127,098 577 207,709 Expenditures 10,587 41% 70,632 Personnel - - - Supplies 59.5031 1 191.1981 Services Debt Service Capital - - - Transfers Out 18,000 577 7,413 Total Expenditures 18,000 577 7,413 Net 109,098 - 200,296 Cash Balance 3,292,600 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Amount transferred in from Fund 641 was to bring O &M reserve account balance equal to two months budgeted O &M expense. 'Budgeted" transfers in will be adjusted with the mid -year transfers & appropriations. rncanr apenaing on t apnai r-rojecrs neiow: Page 90 Form 3 0% 0% 0% 0% 0% 11,129 10,587 41% - - 0% 0% 0% - 91,198 184% 11,129 80,611 163% - 0% 0% 0% 0% - 0% 70,632 10,587 41% 70,632 10,587 41% 59.5031 1 191.1981 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Amount transferred in from Fund 641 was to bring O &M reserve account balance equal to two months budgeted O &M expense. 'Budgeted" transfers in will be adjusted with the mid -year transfers & appropriations. rncanr apenaing on t apnai r-rojecrs neiow: Page 90 Form 3 Page 91 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2004/2006 IMonth I July Fund /Department Number 645 Date Updated 7/30/2013 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 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 0% Net Cash Balance 12 12 Staffing Full Time Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Bond is spent. The $12.43 cash balance in the fund needs to be transferred elsewhere so this fund number can be closed out. Explain Significant Spending on Capital Projects Below: Page 91 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Fund /Department Number 647 Month I July Date Updated 1 7/30/2013 Current Current Current Prior Local Income Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue Property Taxes Local Income Taxes 0% Other Taxes Grants /Intergovernmental Charges for Services - - Interest Earnings 1 36 Bond Proceeds - - Donations 0% Other Income - Transfers In - - Total Revenue 1 36 Expenditures Personnel - - Supplies - - Services 19,017 13,616 Debt Service - - Capital 0% Transfers Out - - Total Expenditures 19,017 - 13,616 1 100% Net (19,017) 1 (13,580) Cash Balance 5,461 Staffing 0% Full Time - Part-Time /Season al/Tem porary 5.401 Total 100% rxpiam aigmncam Kevenue, r-xpenaicure ano ararnng ,- nangesivanances aeiow: Bond is fully encumbered and should be closed out before the end of 2013. rncam apenaing on t apnai r-rojecis neiow: 171 171 6,715 38,271 a Page 92 Form 3 0% 0% 0% 0% 0% (36) 0% - 0% 0% 0% 0% 36 0% - 0% - - 0% 5,401 1 100% - - 0% 0% 5.401 1 100% Page 92 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Fund /Department Number 649 Month I July Date Updated 1 7/30/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 8,025 Grants /Intergovernmental 59% - - Charges for Services - - - Interest Earnings 8,500 433 5,035 Bond Proceeds - - - Donations - - 0% Other Income - - - Transfers In 8,226,256 774,514 5,580,517 Total Revenue 8,234,756 774,947 5,585,553 Expenditures - 0% 1,783,238 Personnel - - - Supplies 3,022,999 (3,410,930) Services - - - Debt Service 8,723,149 300 2,663,015 Capital - - - Transfers Out - - - Total Expenditures 8,723,149 300 2,663,015 Net (488,393) 774,647 2,922,537 Cash Balance 3,758,583 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Monthly transfers in are mandatory, per bond covenants. 2013 Debt Service is higher than 2012 mainly due to costs associated with the refunding of the 2004 Bond and 1998 SRF Loans, and the first interest payment due on the 2012 Bond. rncanr apenaing on t apnai r-rojecrs neiow: Page 93 Form 3 0% 0% 0% 0% 0% 8,025 3,465 59% - - 0% 0% 0% 4,798,213 2,645,739 68% 4,806,237 2,649,203 68% - - 0% 0% 0% 1,783,238 6,060,134 31% - - 0% - - 0% 1,783,238 6,060,134 31% 3,022,999 (3,410,930) 3,715.057 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Monthly transfers in are mandatory, per bond covenants. 2013 Debt Service is higher than 2012 mainly due to costs associated with the refunding of the 2004 Bond and 1998 SRF Loans, and the first interest payment due on the 2012 Bond. rncanr apenaing on t apnai r-rojecrs neiow: Page 93 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Clay Sewage Fund /Department Number 650 Month I July Date Updated 1 7/30/2013 Current Current Current Prior 0% 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 2 2 (2) 0% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 2 2 2 0% Expenditures Personnel - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - 0% Net 2 2 (2) Cash Balance 698 695 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg i,nangesivanances aeiow: Fund has been dormant for a number of years. Cash balance to be transferred to Fund 641 to fully close this fund. rncanr apenaing on t apnai r-rojecrs neiow: Page 94 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Bond 2007B Fund /Department Number 651 Month I July Date Updated 1 7/30/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services (65) - - Interest Earnings - 1 65 Bond Proceeds - - Donations 0% Other Income 0% Transfers In 65 - - Total Revenue - 1 65 Expenditures - 0% Personnel 0 - - Supplies - - Services 4,582 4,582 Debt Service - - Capital 34,930 31,402 Transfers Out - - Total Expenditures 39,512 - 35,983 Net (39,512) 1 (35,918) Cash Balance 3,639 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmncam mevenue, r-xpenaicure ano ararnng i,nangesivanances aeiow: Bond balance of $3,600 expected to be spent or encumbered before year end. rncam apenaing on t apnai r-rolecis neiow: Page 95 Form 3 0% 0% 0% 0% 0% 515 (65) 0% - - 0% 0% 0% 0% 515 65 0% - - 0% - - 0% 32,874 0 100% - - 0% 152,309 3,528 90% - - 0% 185,183 3,529 91% 1 R4 667) /3.59d1 Page 95 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Fund /Department Number 653 Month I July Date Updated 1 7/30/2013 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 60,000 30,124 60,000 0% Bond Proceeds - - - 0% Donations 0% Other Income 0% Transfers In 1,745,314 14,096 274,415 1,731,218 1% Total Revenue 1,805,314 14,096 304,540 1,791,218 1% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 2,434,563 (2,434,563) 0% Capital - 0% Transfers Out 3,524 3,524 0% Total Expenditures - 2,438,087 - (2,438,087) 0% Net 1,805,314 (2,423,992) 304,540 4,229,306 Cash Balance 7,286,825 8,048,610 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr mevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Debt Reserve, which is now held in a separate bank, is fully funded for existing debt. Interest earnings do not show up in Naviline; they are not budgeted for 2014. The debt service pay -out was part of the re- funding of the 2004 Bond and 1998 SRF Loan. A mid -year budget adjustment will be requested to cover this unanticipated activity. rncanr apenaing on t apnai r-rojecrs neiow: Page 96 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Fund /Department Number 658 Month I July Date Updated 1 7/30/2013 Current Current Current Prior Local Income Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue Property Taxes Local Income Taxes 0% Other Taxes Grants /Intergovernmental Charges for Services - - Interest Earnings 5 206 Bond Proceeds - - Donations 0% Other Income - Transfers In - - Total Revenue 5 206 Expenditures Personnel - - Supplies - - Services 112,089 99,796 Debt Service - - Capital 0% Transfers Out - - Total Expenditures 112,089 - 99,796 1,145 99% Net (112,089) 5 (99,590) Cash Balance 12,614 Staffing 0% Full Time - Part-Time /Season al/Tem porary 1,733,560 11,148 Total 99% rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg i,nangesivanances aeiow: Bond has been almost fully encumbered. It is scheduled to be spent by the end of the year. rncanr apenaing on t apnai r-rojecrs neiow: Page 97 Form 3 0% 0% 0% 0% 0% 3,975 (206) 0% - - 0% 0% 0% 0% 3,975 206 0% - - 0% - - - 0% 300,522 11,148 1,145 99% 12,009 - - 0% 1,421,029 0% - 0% 1,733,560 11,148 1,145 99% 1.729.5841 (11.148) (1.3511 Page 97 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 Fund /Department Number 659 Month I July Date Updated 1 7/30/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 69,673 Grants /Intergovernmental 36% - - Charges for Services - - - Interest Earnings 60,000 1,518 21,633 Bond Proceeds - - - Donations - - 0% Other Income - 0% 439 23,268 Transfers In - - - Total Revenue 60,000 1,518 21,633 Expenditures - 0% 1.951.906 573.080 Personnel - - - Supplies - - - Services 425,228 5,585 234,675 Debt Service - - - Capital 10,271,492 8,749 1,325,946 Transfers Out - - - Total Expenditures 10,696,720 14,334 1,560,622 Net (10,636,720) (12,816) (1,538,989) Cash Balance 8,627,521 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: 17 rxpiam oignincam openaing on t apnai rrojects neiow: Year to date, East Bank Sewer Sep, Phase 2 $608K, East Bank Sewer Sep, Phase 3 $532K, LaSalle School area Sewer Sep, Phase 3 $92K, East Bank Sewer Sep, Phase 4 $84K, and Southwood Sewer Sep $143K. Page 98 Form 3 0% 0% 0% 0% 0% 69,673 38,367 36% - - 0% 0% 0% 0% 69,673 38,367 36% - - 0% - - - 0% 439 23,268 167,285 61% - - - 0% 1,951,466 549,812 8,395,733 18% - - - 0% 1.951.906 573.080 1 8.563.018 1 20% 17 rxpiam oignincam openaing on t apnai rrojects neiow: Year to date, East Bank Sewer Sep, Phase 2 $608K, East Bank Sewer Sep, Phase 3 $532K, LaSalle School area Sewer Sep, Phase 3 $92K, East Bank Sewer Sep, Phase 4 $84K, and Southwood Sewer Sep $143K. Page 98 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Fund /Department Number 661 Month I July Date Updated 1 7/30/2013 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 60,000 4,011 42,119 17,881 70% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 60,000 4,011 42,119 17,881 70% Expenditures Personnel - - - - 0% Supplies - 0% Services 104,981 (104,981) 0% Debt Service - - - - - 0% Capital 19,160,000 978,383 1,471,384 3,709,176 13,979,440 27% Transfers Out - - - - - 0% Total Expenditures 19,160,000 978,383 1,576,365 3,709,176T--- ,709,176 13,874,459 28% Net (19,100,000) (974,372) (1,534,246) (3,709,176)1 (13,856,578) Cash Balance 21,712,642 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aignmcam mevenue, cxpenonure ano ararnng ,- nangesivanances aeiow: Bond closed in late December 2012. Explain Significant Spending on Capital Projects Below: Year to date: East Bank Sewer Separation Phase 4 $700K, Diamond Ave. Phase III Sewer Sep. $771 K. Page 99 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2013 Fund /Department Number 663 Month I July Date Updated 1 7/30/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 21,200,000 21,200,000 0% Donations - - 0% Other Income 0% Transfers In 0% Total Revenue 21,200,000 21,200,000 0% Expenditures Personnel - - 0% Supplies - - 0% Services 400,000 400,000 0% Debt Service - - 0% Capital - - 0% Transfers Out 1,700,000 1,700,000 0% Total Expenditures 2,100,000 2,100,000 0% Net 19,100,000 19,100,000 Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: No activity yet. Bond should close in late November or December, 2013. rncanr apenaing on t apnai r-rojecrs neiow: Page 100 Form 3 Page 101 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund JMonth I July Fund /Department Number 664 Date Updated 7/30/2013 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 2 2 (2) 0% Bond Proceeds - 85,740 (85,740) 0% Donations - 0% Other Income 0% Transfers In - - 0% Total Revenue 2 85,742 85,742 0% Expenditures Personnel - - 0% Supplies 0% Services - 0% Debt Service 81,064 (81,064) 0% Capital - 0% Transfers Out - 0% Total Expenditures - 81,064 i (81,064) 0% Net 2 4,678 (4,678) Cash Balance 4,678 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Year to date revenue shown came from the re- funding of the 2004 Sewer bond and 1998 SRF Loan to pay issuance costs related to the bond re- funding. Mid year budget transfers will be done to adjust budget amounts to reflect actual account activity. Explain Significant Spending on Capital Projects Below: Page 101 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Century Center Fund /Department Number 670 Month I July Date Updated 1 8/21/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% - Property Taxes 0% 1,313,436 Local Income Taxes - - Other Taxes 1,313,436 53% 1,313,436 Grants /Intergovernmental - - - Charges for Services 1,476,332 159,262 784,973 Interest Earnings 360 - 228 Bond Proceeds - 2,077,711 - Donations - - - Other Income 145,578 3,435 50,400 Transfers In - - - Total Revenue 2,935,706 162,697 2,149,037 Expenditures - 0% 2,740,167 Personnel 1,650,627 614 862,743 Supplies 54,875 20,249 21,185 Services 899,905 36,910 576,221 Debt Service 1,300 - - Capital 329,000 Transfers Out - - Total Expenditures 2,935,707 57,773 1,460,148 Net (1) 104,924 688,889 Cash Balance 1,550,913 Staffing Full Time 24.00 - Part-Time /Season al/Tem porary 6.00 Total 30.00 1,269.941 rxpiam aigmncan[ Kevenue, r-xpenaicure ano acarnng i,nangesivanances oeiow: SMG will assume 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. rncam apenaing on t apnai r-rojecis neiow: Page 102 Form 3 0% - 0% 1,313,436 100% - 0% 707,546 691,359 53% 163 132 63% - - 0% - - 0% 56,567 95,178 35% - - 0% 2,077,711 786,669 73% 865,684 787,884 52% 29,903 33,690 39% 500,522 323,684 64% - 1,300 0% - 329,000 0% 1,344,057 - 0% 2,740,167 1,475,559 50% /RR9_d5fil /fiRR Rgnl 1,269.941 rxpiam aigmncan[ Kevenue, r-xpenaicure ano acarnng i,nangesivanances oeiow: SMG will assume 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. rncam apenaing on t apnai r-rojecis neiow: Page 102 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Fund /Department Number 671 Month I July Date Updated 1 8/21/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes - - Grants /Intergovernmental 100,000 100,000 Charges for Services - - Interest Earnings 500 135 Bond Proceeds - - Donations 0% Other Income 0% Transfers In - - Total Revenue 100,500 100,135 Expenditures 0% Personnel - - Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out Total Expenditures - - 1,288.468 Net 100,500 100,135 Cash Balance 1,375,012 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aignmcam Kevenue, r-xpenaicure ano acarnng %,nangesivanances aeiow: The Century Center Capital fund receives an annual transfer of PSDA tax money in the amount of $100,000 per year. The Century Center Board of Managers has not approved a 2013 capital budget in this fund. Explain Significant Spending on Capital Projects Below: The Century Center Board of Managers has not approved a capital budget in this fund for 2013. Page 103 Form 3 0% 0% - 0% 100,000 100% - 0% 236 365 27% - - 0% 0% - 0% 1,344,057 0% 1,444,293 365 100% - - 0% 0% 0% - 0% 155,825 0% - 0% 155,825 0% 1,288,468 365 1,288.468 rxpiam aignmcam Kevenue, r-xpenaicure ano acarnng %,nangesivanances aeiow: The Century Center Capital fund receives an annual transfer of PSDA tax money in the amount of $100,000 per year. The Century Center Board of Managers has not approved a 2013 capital budget in this fund. Explain Significant Spending on Capital Projects Below: The Century Center Board of Managers has not approved a capital budget in this fund for 2013. Page 103 Form 3 Page 104 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Central Services IMonth I July Fund /Department Number 222 1 Date Updated 8/15/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 7,891,203 606,206 4,275,427 4,004,206 3,615,776 54% Interest Earnings 1,500 190 2,345 3,307 (845) 156% Bond Proceeds - - 0% Donations - 18,750 0% Other Income 30,000 5,928 91,505 20,228 (61,505) 305% Transfers In - - - - - 0% Total Revenue 7,922,703 612,324 4,369,277 4,046,491 3,553,426 55% Expenditures Personnel 2,813,983 192,527 1,450,539 1,398,612 1,363,444 52% Supplies 165,665 35,452 113,278 78,399 86,433 (34,046) 121% Services 4,746,899 381,426 2,702,979 2,370,462 1,853,642 190,278 96% Debt Service 3700 6,275 1,414 4,452 4,242 1,834 (11) 100% Capital 246,607 24,817 114,627 45,352 176,438 28% Transfers Out - - 0% Total Expenditures 7,979,429 610,818 4,296,065 3,966,341 1,987,261 1,696,103 79% Net (56,726) 1,506 73,212 80,150 (1,987,261)1 1,857,323 Cash Balance 1,103,931 1,082,690 Staffing Full Time 44.00 43.00 43.00 Part-Time /Season al/Tem porary 1.00 1.00 1.00 Total 45.00 44.00 44.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Supplies -- allocation for Printshop increases from $27 to $149. Accts 2312 & 2398 are not budgeted, tool acct 2320 was used for a capital purchase from 2013 that monies will have to be transferred midyear. Natural Gas utilities were higher TY vs. LY. The encumbrance amount is high due to blanket PO's issued to AEP and Nipsco for city -wide utility costs paid from this fund and charged back to departments. Revenue -- Energy Dept.- - reclass of revenue from 101 General Fund to Fund 222 -0616. Explain Significant Spending on Capital Projects Below: Page 104 Form 3 Page 105 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance jMonth I July Fund /Department Number 226 1 Date Updated 8/16/2013 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 2,988,576 249,048 1,743,336 1,703,022 1,245,240 58% Interest Earnings 26,000 992 12,637 16,596 13,363 49% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 18,500 295 14,507 18,205 2% Transfers In - - - - - 0% Total Revenue 3,033,076 250,040 1,756,268 1,734,125 1,276,808 58% Expenditures Personnel 179,100 13,368 93,311 92,099 85,789 52% Supplies 22,356 2,430 9,699 10,833 682 11,975 46% Services 2,689,771 644,490 1,584,855 1,311,431 1,305 1,103,611 59% Debt Service - - - - - - 0% Capital 24,700 22,435 23,288 1,412 94% Transfers Out - - - - - - 0% Total Expenditures 2,915,927 682,723 1,711,153 1,414,363 1,987 1,202,788 59% Net 117,149 (432,684) 45,116 319,762 (1,987)1 74,020 Cash Balance 5,290,527 4,771,117 Staffing Full Time 3.00 3.00 3.00 Part-Time /Season al/Tem porary - - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The larges component of the services category is for liability and property claims paid which are 67% of the 2013 budget at July 31, 2013 due to the settlement of some large claims. The City Legal Department evaluates claims and determines the proper amounts to be paid out. Revenue is derived from allocations to other City departments and these amounts are posted monthly to the accounts. The cost of operating the Safety & Risk department is 53% of the budget at July 31, 2013. Explain Significant Spending on Capital Projects Below: 2013 budgeted capital is for computeres and a new vehicle. Page 105 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Fund /Department Number 278 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 1,300 Grants /Intergovernmental 48% - - Charges for Services - - - Interest Earnings 2,000 79 969 Bond Proceeds - - - Donations - - - Other Income 127,400 9,320 71,093 Transfers In - - - Total Revenue 129,400 9,399 72,061 Expenditures 0% 4,085 Personnel - - - Supplies 63,700 63,700 63,700 Services 40,000 - - Debt Service - Capital Transfers Out - - - Total Expenditures 103,700 63,700 63,700 Net 25,700 (54,301) 8,361 Cash Balance 400,167 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This fund charges police officers for liability insurance and gasoline costs through payroll deduction. No expenditures for vehicle claims have been paid so far in 2013.The cash reserves in this fund have been increasing in recent years and are expected to increase during 2013. Claims have been minimal in this fund since it was created. Gasoline charges of $63,700.00 were deducted by Central Services during July 2013 to cover take home vehicle gasoline for fiscal 2013. This fund is classified as an Internal Service Fund for financial reporting. rncanr apenaing on t apnai r-rojecrs neiow: Page 106 Form 3 0% 0% 0% 0% 0% 1,300 1,031 48% - - 0% - - 0% 73,147 56,307 56% - - 0% 74,446 57,339 56% - - 0% - - 100% 4,085 40,000 0% - - 0% 0% 0% 4,085 40,000 61% 70.362 17.339 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This fund charges police officers for liability insurance and gasoline costs through payroll deduction. No expenditures for vehicle claims have been paid so far in 2013.The cash reserves in this fund have been increasing in recent years and are expected to increase during 2013. Claims have been minimal in this fund since it was created. Gasoline charges of $63,700.00 were deducted by Central Services during July 2013 to cover take home vehicle gasoline for fiscal 2013. This fund is classified as an Internal Service Fund for financial reporting. rncanr apenaing on t apnai r-rojecrs neiow: Page 106 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits Fund /Department Number 711 Month I July Date Updated 1 8/16/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental - - - - - 0% Charges for Services 11,937,800 1,000,798 7,003,132 6,534,112 4,934,668 59% Interest Earnings 40,600 1,374 17,575 31,167 23,025 43% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 210,500 210,498 86 2 100% Transfers In - - - - - 0% Total Revenue 12,188,900 1,002,172 7,231,204 6,565,364 4,957,696 59% Expenditures Personnel - - - - - - 0% Supplies 24,444 630 5,038 7,152 1,868 17,538 28% Services 485,085 43,282 330,874 139,391 293 153,918 68% Insurance 12,839,300 1,184,551 7,204,145 6,874,253 5,635,155 56% Debt Service - - - - - - 0% Capital - 0% Transfers Out - - - 105,441 - - 0% Total Expenditures 13,348,829 1,228,463 7,540,058 7,126,237 2,161 5,806,610 57% Cash Balance 7,119,337 8,292,747 Staffing Full Time - Part-Time /Seasonal/Tem porary Total txpiam ai nincam rcevenue, expenanure ana biamng cnangesnrariances below: Medical claims paid so far are in line with the budget. Wellness costs have been broken out between supplies and contractual for 2013. Typically, a large amount of medical claims are paid in the last quarter of the year. Explain Significant Spending on Capital Projects Below: None Page 107 Form 3 Page 108 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation IMonth I July Fund /Department Number 713 1 Date Updated 8/16/2013 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 341,250 15,996 172,403 160,381 168,847 51% Interest Earnings 200 32 281 71 (81) 141% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 341,450 16,029 172,684 160,453 168,766 51% Expenditures Personnel 262,963 1,179 37,970 130,375 224,993 14% Supplies - - - - - 0% Services 4,284 357 2,499 3,318 1,785 58% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 267,247 1,536 40,469 133,693 226,778 15% Net 74,203 14,493 132,215 26,760 (58,012) Cash Balance 204,781 17,351 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund charges an allocation of 1 % of payroll to most departments to cover the cost of unemployment claims paid. The cost of claims paid has been low for 2013 and less than the allocation amount. Effective April 1, 2013, the allocation amount was reduced to .75% of payroll to reduce the costs paid by departments. For the 2014 budget, the rate charged to departments will be reduced to .50% due to favorable claims history and increasing cash reserves. At July 31, 2013, claims paid on behalf of former Parks & Recreation department employees was $30,465.25, or 80% of total claims paid. Due to continuing low claims paid, the rate to departments was reduced to .5% of payroll beginning in July, 2013. Cash reserves are increasing in this fund. Explain Significant Spending on Capital Projects Below: None Page 108 Form 3 Page 109 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension IMonth I July Fund /Department Number 701 1 Date Updated 8/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 5,035,292 2,517,646 2,616,693 2,517,646 50% Charges for Services - - - - 0% Interest Earnings 4,987 1,635 2,466 3,352 33% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 5,040,279 - 2,519,281 2,619,159 2,520,998 50% Expenditures Personnel 5,894,925 447,315 3,203,569 3,332,849 2,691,356 54% Supplies 200 - - 69 200 0% Services 4,903 101 690 642 4,213 14% Debt Service - - - - - 0% Capital - 0% Transfers Out - - - 119 0% Total Expenditures 5,900,028 447,416 3,204,259 3,333,679 2,695,769 54% Net (859,749) (447,416) (684,978) (714,520) (174,771) Cash Balance 662,887 1,002,042 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Fire Pension fund receives State of Indiana pension relief payments in June and September to reimburse the City for actual pension costs paid and reported in the previous year. Per an INPERS letter dated June 3, 2013, the state pension relief payments will be $2,517,646.17 each on July 1, 2013 and October 2, 2013. The projected cash balance in this fund is $819,988.57 at December 31, 2013, a projected decrease of $527,875.84 during the year. The pension relief payments do not cover retiree insurance premiums paid by the fund. Explain Significant Spending on Capital Projects Below: No capital expenditures are purchased through this account. Page 109 Form 3 Page 110 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Pension IMonth I July Fund /Department Number 702 1 Date Updated 8/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 5,863,697 2,931,849 3,365,810 2,931,848 50% Charges for Services - - - - 0% Interest Earnings 6,000 19 3,210 3,368 2,790 53% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 4,000 1,111 3,828 2,889 28% Transfers In - - - - - 0% Total Revenue 5,873,697 19 2,936,170 3,373,007 2,937,527 50% Expenditures Personnel 6,922,721 536,274 3,791,343 3,864,273 3,131,378 55% Supplies 1,100 - 642 663 458 58% Services 5,312 165 1,066 643 4,246 20% Debt Service - - - - - 0% Capital - 0% Transfers Out - - - 616 0% Total Expenditures 6,929,133 536,439 3,793,051 3,866,194 3,136,082 55% Net (1,055,436) (536,420) (856,881) (493,188) (198,555) Cash Balance 1,451,745 1,670,677 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The Police Pension fund receives pension relief distributions from the State of Indiana to reimurse the City for pension costs paid and reported in the previous fiscal year. Per an INPERS letter dated June 3, 2013, the state pension relief payments will be $2,931,848.71 each on July 1, 2013 and October 2, 2013. The projected cash balance in the fund is $1,544,07.43 at December 31, 2013, a decrease of $764,618.46 during the year. The pension relief payments do not cover retiree health insurance premiums paid by the fund. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Page 110 Form 3 Y Page 111 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF Revenue - Airport JMonth I July Fund /Department Number 324 1 Date Updated 8/13/2013 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 11,200,000 7,111,555 6,111,685 4,088,445 63% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 84,612 3,305 39,090 58,300 45,522 46% Bond Proceeds - - - - - 0% Donations 65,000 - 65,000 - 100% Other Income 2,309,640 78,780 2,320,102 246,644 (10,462) 100% Transfers In 281,000 182 278,387 7,585 2,613 99% Total Revenue 13,940,252 82,267 9,814,134 6,424,214 4,126,118 70% Expenditures Personnel - - - - 0% Supplies - - - - - 0% Services 5,921,251 123,829 1,058,038 3,343,583 767,641 4,095,572 31% Debt Service 3,476,441 588,000 2,133,058 2,695,543 - 1,343,383 61% Capital 15,846,900 882,486 3,892,557 6,188,320 349,868 11,604,475 27% Transfers Out - - - - - - 0% Total Expenditures 25,244,592 1,594,315 7,083,653 12,227,446 1,117,509 1 17,043,430 1 32% Net (11,304,340) (1,512,048) 2,730,481 (5,803,232) (1,117,509) (12,917,312) Cash Balance 20,951,853 16,525,008 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Revenue variance due to 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 2012 were: Ignition Park Infrastructure; Data Realty; final demolition of Underground Pipe & Valve; Mayflower Road Realignment & Improvements; the SB Animal Shelter reconstruction; Mayflower Trunk Sewer; continued acquisition in Ignition Park South and East; and the beginning expenditures of the Renaissance District. In 2013, the major projects thus far approved are: more acquisition in Ignition Park South and East; Bosch facility holding costs; and major expenditure on the Renaissance District project. Explain Significant Spending on Capital Projects Below: Capital projects thus far this year are: Renaissance District; and Ignition Park South & East acquisitions. Page 111 Form 3 Page 112 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown JMonth I July Fund /Department Number 420 1 Date Updated 8/13/2013 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 3,650,000 1,705,491 1,909,554 1,944,509 47% Local Income Taxes - - - - 0% Other Taxes 398,500 198,500 200,500 200,000 50% Grants /Intergovernmental - - - - 0% Charges for Services 34,000 1,914 18,121 27,878 15,879 53% Interest Earnings 59,993 4,304 38,677 15,637 21,316 64% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 520,761 28,924 249,677 369,799 271,084 48% Transfers In - 304 4,049 831,239 4,049 0% Total Revenue 4,663,254 35,446 2,214,515 3,354,607 2,448,739 47% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 619,152 49,529 275,734 623,887 207,290 136,128 78% Debt Service 2,880,922 - 1,440,376 1,444,853 - 1,440,546 50% Capital 1,802,028 3,561 40,962 3,616,293 388,261 1,372,805 24% Transfers Out - - - - - - 0% Total Expenditures 5,302,102 53,090 1,757,072 5,685,033 595,551 1 2,949,479 1 44% Net (638,848) (17,644) 457,443 (2,330,426) (595,551) (500,740) Cash Balance 3,296,800 2,162,775 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances 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. Major projects undertaken in 2012 were: Century Center Island Improvements; Coveleski Improvements; Sidewalk Improvements outside First Bank Bldg; Demo of Michiana Lock & Key; Restrooms @ Morris Civic;and the Veteran's Clinic. Projects thus far committed in 2013 are:Century Center West Entrance; Studebaker Plaza; and Wayne Street Garage Facade improvements. Revenue variances: sold more property in 2012; received funds from debt service reserve account in 2012. Explain Significant Spending on Capital Projects Below: Capital projects thus far committed in 2013 are:Century Center West Entrance; Studebaker Plaza; and Wayne Street Garage Facade improvements. Page 112 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Fund /Department Number 422 Month I July Date Updated 1 8/13/2013 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 440,000 264,690 225,083 175,310 60% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 4,000 81 938 3,179 3,062 23% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 444,000 81 265,628 228,262 178,372 60% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 11,496 1,678 5,982 891 8,927 22% Debt Service - - - - - - 0% Capital 657,319 41,972 176,164 389,112 164,832 316,323 52% Transfers Out - - - - - - 0% Total Expenditures 668,815 41,972 177,842 395,094 165,723T 325,250 51% Net (224,815) (41,891) 87,786 (166,832) (165,723) (146,878) Cash Balance 539,515 765,011 Staffing Full Time - Part-Time /Season al/Tem porary Total r xpiam aigmricam Kevenue, r- xpenanure ano starring ,- nangesivanances rseiow: TIF projects vary widely from year to year so little can be gained by comparing expenditures from year to year. Major projects for 2012 were: Hansel Center and the beginning of Rushton Square. Major projects committed thus far in 2013 are: Completion of Rushton Square and Williams Streetscape. rncam apenaing on t apnai rrojects neiow: committed thus far in 2013 are: Completion c Page 113 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Fund /Department Number 425 Month I July Date Updated 1 8/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 276 Grants /Intergovernmental 40% - - Charges for Services - - - Interest Earnings 500 16 202 Bond Proceeds - - - Donations - - - Other Income 156,405 10,306 96,523 Transfers In - - - Total Revenue 156,905 10,322 96,725 Expenditures - 0% 81,291 Personnel - - - Supplies - - - Services 144,159 7,647 61,502 Debt Service - - - Capital 7,026 Transfers Out - - - Total Expenditures 151,185 7,647 61,502 Net 5,720 2,675 35,223 Cash Balance 130,619 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg i,nangesivanances aeiow: Operations under outside contract with CB Richard Ellis so all expenses except capital are shown under Services line, to show consistently with Parking Garages and Blackthorn Golf Course. rncanr apenaing on t apnai rrojecrs neiow: Page 114 Form 3 0% 0% 0% 0% 0% 276 298 40% - - 0% - - 0% 74,390 59,882 62% - - 0% 74,666 60,180 62% - - 0% - - 0% 63,541 82,657 43% - - 0% 17,750 7,026 0% - - 0% 81,291 89,683 41% If; 695) 179.5031 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg i,nangesivanances aeiow: Operations under outside contract with CB Richard Ellis so all expenses except capital are shown under Services line, to show consistently with Parking Garages and Blackthorn Golf Course. rncanr apenaing on t apnai rrojecrs neiow: Page 114 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Fund /Department Number 426 Month I July Date Updated 1 8/13/2013 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 1,720,000 613,185 876,401 1,106,815 36% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 10,000 624 8,433 11,817 1,567 84% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,730,000 624 621,618 888,218 1,108,382 36% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 304,171 43,872 87,059 151,161 214,461 2,651 99% Debt Service - - - - - - 0% Capital 4,466,373 83,192 669,028 311,614 1,285,312 2,512,033 44% Transfers Out - - - - - - 0% Total Expenditures 4,770,544 127,064 756,087 462,775 1,499,773T--- ,499,773 2,514,684 47% Net (3,040,544) (126,440) (134,469) 425,443 (1,499,773) (1,406,302) Cash Balance 3,724,632 3,923,168 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: 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 2012 were: Memorial Campus Street Improvements; 400 Block N. Michigan Parking Lot; and Skyway Bridge /Building Improvements. Projects committed thus far in 2013: Completion of projects started in 2012. rncanr apenaing on t apnai r-rojecrs neiow: pitted thus far in 2013: Completion of projects started in Page 115 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Development Fund /Department Number 429 Month I July Date Updated 1 8/13/2013 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 820,000 431,979 693,352 388,021 53% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 3,000 420 5,178 3,087 (2,178) 173% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 823,000 420 437,157 696,439 385,843 53% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 80,105 2,736 33,901 26,633 19,300 26,904 66% Debt Service - - - - - - 0% Capital 2,308,890 2,308,890 0% Transfers Out - - 0% Total Expenditures 2,388,995 2,736 33,901 26,633 19,300T 2,335,794 2% Net (1,565,995) (2,316) 403,256 669,806 (19,300) (1,949,951) Cash Balance 2,622,879 1,571,882 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Major projects in 2012 were: Eddy Street Corridor study; Demolition relation to AEP Easement; and 5 points utility study. Commitments thus far in 2013 are:completion of the items begun in 2012. rncanr apenaing on t apnai r-rojecrs neiow: Page 116 Form 3 Page 117 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 JMonth I July Fund /Department Number 430 1 Date Updated 8/13/2013 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 1,820,000 1,381,537 1,337,317 438,463 76% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 20,000 945 12,179 13,416 7,821 61% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In - - - 1,401,397 - 0% Total Revenue 1,840,000 945 1,393,716 2,752,130 446,284 76% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 694,289 57,743 347,203 692,467 318,558 28,528 96% Debt Service - - - - - - 0% Capital 5,428,596 651,597 1,058,988 1,004,627 3,168,584 1,201,024 78% Transfers Out - - - - - - 0% Total Expenditures 6,122,885 709,340 1,406,191 1,697,094 3,487,142 1 1,229,552 1 80% Net (4,282,885) (708,395) (12,475) 1,055,036 (3,487,142) (783,268) Cash Balance 5,382,302 4,805,888 Staffing Full Time - Part-Time /Season al/Tem porary 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 2012 were: Erskine Plaza Ponds; Fellows Street Corridor; Acquisition for Ireland Road project; and continuation of acquisition and engineering for the Main /Lafayette Crossover project. Projects committed thus far in 2013 are: 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. Explain Significant Spending on Capital Projects Below: Projects committed thus far in 2013 are: 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. Page 117 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #2 Fund /Department Number 431 Revenue Property Taxes Local Income Taxes Other Taxes Grants /Intergovernmental Charges for Services Interest Earnings Bond Proceeds Donations Other Income Transfers In Total Revenue Expenditures Personnel Supplies Services Debt Service Capital Transfers Out Total Expenditures Net Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total Month I July Date Updated 1 8/13/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget rxpiam oignmcam mevenue, cxpenonure ano acarnng i,nangesivanances aeiow: This TIF fund is no longer used and should be closed. rncam apenaing on t apnai r-rojecis neiow: Page 118 Form 3 0% 0% 0% 0% 0% 2,329 0% - 0% 0% 0% - 0% 2,329 0% - 0% 0% 0% 0% - 0% 1,401,397 0% 1,401,397 0% 1.1199.06R) Page 118 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Fund /Department Number 432 Month I July Date Updated 1 8/13/2013 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 1,331,000 659,735 671,265 50% Local Income Taxes - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 15,000 971 12,495 19,991 2,505 83% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,346,000 971 672,230 19,991 673,770 50% Expenditures Personnel - - - - - 0% Supplies - - 0% Services 1,268 - 1,157 - 111 91% Debt Service 500,000 143,950 488,848 149,809 11,152 98% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 501,268 143,950 490,005 149,809 11,263 98% Net 844,732 (142,979) 182,225 (129,818) 662,507 Cash Balance 6,310,945 5,559,817 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricam Kevenue, r-xpenairure ano ararring %,nangesivanances aeiow: No tax revenue requested in 2011 (which would have been received in 2012). rncam apenaing on t apnai r-rojecrs neiow: Page 119 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Fund /Department Number 435 Month I July Date Updated 1 8/13/2013 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 320,000 164,168 264,862 155,832 51% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 1,000 25 270 413 730 27% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 321,000 25 164,438 265,275 156,562 51% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 4,782 257 14,123 4,500 25 99% Debt Service 190,461 95,231 95,230 - 95,230 50% Capital 259,539 - - 259,539 0% Transfers Out - - - - 0% Total Expenditures 454,782 - 95,488 109,353 4,500T 354,794 22% Net (133,782) 25 68,950 155,922 (4,500)1 (198,232) Cash Balance 229,876 348,595 Staffing Full Time - Part-Time /Season al/Tem porary Total r=xpiam aigmricam rtevenue, r- xpenanure ano starring i,nangesivanances rseiow: 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 Mishawak ($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 April 30, 2013, the amounts due Mishawaka and Major moves were $343,532 and $941,728, respectively. rncam apenaing on t apnai rrojects t5eiow: Iget of $259,539 is for road improvements. Page 120 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Residential Fund /Department Number 436 Month I July Date Updated 1 8/13/2013 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 2,450,000 1,340,028 1,252,275 1,109,972 55% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 10,000 449 6,151 6,224 3,849 62% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 2,460,000 449 1,346,179 1,258,499 1,113,821 55% Expenditures Personnel - - - - - 0% Supplies - - - - 0% Services 1,730 - 1,370 1,137 360 79% Debt Service 3,228,227 1,453,324 3,021,162 308,450 207,065 94% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 3,229,957 1,453,324 3,022,532 309,587 207,425 94% Net (769,957) (1,452,875) (1,676,353) 948,912 906,396 Cash Balance 1,824,958 2,823,215 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aignmcam Kevenue, r-xpenaicure ano acarrmg i,nangesivanances aeiow: 2012 Debt service came from savings on project, not from this fund. rncam apenaing on t apnai r-rojecis neiow: Page 121 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Fund /Department Number 433 Month I July Date Updated 1 8/13/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 150 5 73 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 150 5 73 Expenditures 0% Personnel - - - Supplies - - Services 6,787 854 Debt Service - - Capital 100% Transfers Out - - Total Expenditures 6,787 - 854 Net (6,637) 5 (781) Cash Balance 30,662 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmncan[ Kevenue, r-xpenaicure ano acarnng ,- nangesivanances aeiow: This fund's sole expenditure is for general legal fees for DCI based on an engagement letter rncam apenaing on t apnai r-rojecis neiow: 31 Page 122 Form 3 0% 0% 0% 0% 0% 120 77 49% - - 0% 0% 0% 0% 120 77 49% - - 0% - - 0% 3,033 5,933 100% - - 0% 0% - - 0% 3,033 5,933 100% 2.9131 (5.93311 77 31 Page 122 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Fund /Department Number 439 Month I July Date Updated 1 8/13/2013 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 Local Income Taxes Other Taxes - - Grants /Intergovernmental 1,446,074 1,446,074 Charges for Services - - Interest Earnings 2,000 397 4,519 Bond Proceeds - - - Donations Other Income Transfers In - - - Total Revenue 1,448,074 397 1,450,593 Expenditures Personnel - - - Supplies Services Debt Service Capital Transfers Out Total Expenditures - - - Net 1,448,074 397 1,450,593 Cash Balance 2,266,954 Staffing Full Time - Part-Time /Season al/Tem porary Total 81 0% 0% 0% 100% 0% 2,429 (2,519) 226% - 0% 0% 0% - 0% 2,429 2,519 100% - 0% 0% 0% 0% 0% 0% 0% 2d99 175191 rxpiam aigmricanr mevenue, cxpenonure ano ararring ,- nangesivanances aeiow: State money received in 2013 was for 2012. No funds received in 2012. In 2011, funds received in December. rncanr apenaing on t apnai r-rojecrs neiow: Page 123 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Fund /Department Number 454 Month I July Date Updated 1 8/13/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue Property Taxes 37,240 0% Local Income Taxes - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - - 0% Interest Earnings 1,000 66 876 903 124 88% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,000 66 876 38,143 124 88% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - - - 0% Net 1,000 66 876 38,143 124 Cash Balance 375,958 300,181 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: No significant issues. rncam apenaing on t apnai rrojects neiow: Page 124 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Golf Course Operations Fund /Department Number 619 Month I July Date Updated 1 8/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 705,951 58% - Grants /Intergovernmental - - - Charges for Services 1,696,879 226,188 990,928 Interest Earnings - - - Bond Proceeds 100% 1,128,340 705,951 Donations - - 0% Other Income - 0% - Transfers In 50,500 - 50,500 Total Revenue 1,747,379 226,188 1,041,428 Expenditures - 0% 1,289,564 Personnel - - - Supplies - - - Services 1,661,128 232,796 904,332 Debt Service 326,000 - 207,879 Capital 10,578 1,763 5,289 Transfers Out - - - Total Expenditures 1,997,706 234,559 1,117,500 Net (250,327) (8,371) (76,072) Cash Balance 181,464 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: The early spring weather in 2012 was phenomenal, but in 2013 spring has been very cold, thus affecting revenue sharply.Trimmed expenses to offset late start as appropriate. Paid off bond in early 2013, so debt service expense in 2013 will be much under 2012. Course operations under outside contract with Kitson & Partners 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 Page 125 Form 3 0% 0% 0% 0% 1,128,340 705,951 58% - - 0% 0% 0% 0% 100% 1,128,340 705,951 60% - - 0% - - 0% 958,775 756,796 54% 325,500 118,121 64% 5,289 5,289 50% - - 0% 1,289,564 880,206 56% (161.224) (174.2551 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: The early spring weather in 2012 was phenomenal, but in 2013 spring has been very cold, thus affecting revenue sharply.Trimmed expenses to offset late start as appropriate. Paid off bond in early 2013, so debt service expense in 2013 will be much under 2012. Course operations under outside contract with Kitson & Partners 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 Page 125 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Central Development Fund /Department Number 314 Revenue Property Taxes Local Income Taxes Other Taxes Grants /Intergovernmental Charges for Services Interest Earnings Bond Proceeds Donations Other Income Transfers In Total Revenue Expenditures Personnel Supplies Services Debt Service Capital Transfers Out Total Expenditures Net Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total Month I July Date Updated 1 8/13/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget rxpiam aigmricam Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This is an old debt service fund for a bond which has paid off and there is no longer any cash in it. Fund can be closed. rncam apenaing on t apnai r-rojecrs neiow: Page 126 Form 3 0% 0% 0% 0% 0% 0% 0% 0% 2,910 0% - 0% 2,910 0% - 0% 0% 0% 0% - 0% 825,410 0% 825,410 0% R?? snni rxpiam aigmricam Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This is an old debt service fund for a bond which has paid off and there is no longer any cash in it. Fund can be closed. rncam apenaing on t apnai r-rojecrs neiow: Page 126 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Fund /Department Number 315 Month I July Date Updated 1 8/13/2013 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 5,000 182 2,423 4,117 2,577 48% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 5,000 182 2,423 4,117 2,577 48% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 5,000 182 2,423 4,117 2,577 48% Total Expenditures 5,000 182 2,423 4,117 2,577 48% Net - Cash Balance 1,038,904 1,038,904 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: 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. rncanr apenaing on t apnai r-rojecrs neiow: Page 127 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Fund /Department Number 317 Month I July Date Updated 1 8/13/2013 Current Current Current Prior 0% 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 3,500 88 1,171 1,769 2,329 33% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 3,500 88 1,171 1,769 2,329 33% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - - - 0% Net 3,500 88 1,171 1,769 2,329 Cash Balance 502,919 501,046 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: Debt service reserve fund. The fund is at the proper level per the bond financial advisor, Crowe Horvath. No additional transfers -in are needed. Any interest variations due to City policy on investments and increase in cash available to earn interest. rncanr apenaing on t apnai rrojecrs neiow: Page 128 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Blackthorn Golf Fund /Department Number 319 Month I July Date Updated 1 8/13/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - Interest Earnings 50 464 Bond Proceeds - - Donations 0% Other Income 0% Transfers In - - Total Revenue 50 464 Expenditures 0% Personnel - - Supplies 0% Services 0% Debt Service (414). 100% Capital - - Transfers Out 326,050 326,464 Total Expenditures 326,050 326,464 Net (326,000) (326,000) Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Generally only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Please note however: the corresponding bond was paid off in early 2013 so debt service reserve is released and no cash remains in the fund. This fund can now be closed. rncanr apenaing on t apnai r-rojecrs neiow: Page 129 Form 3 0% 0% 0% 0% 0% 3,468 (414) 928% - - 0% 0% 0% 0% 3,468 414 928% - - 0% 0% 0% 0% 0% 3,468 (414). 100% 3,468 1 (414) 100% rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Generally only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Please note however: the corresponding bond was paid off in early 2013 so debt service reserve is released and no cash remains in the fund. This fund can now be closed. rncanr apenaing on t apnai r-rojecrs neiow: Page 129 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Fund /Department Number 328 Month I July Date Updated 1 8/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 5,829 Grants /Intergovernmental 67% - - Charges for Services - - - Interest Earnings 6,000 304 4,049 Bond Proceeds - - - Donations - - 0% Other Income 0% Transfers In - - - Total Revenue 6,000 304 4,049 Expenditures 1,951 67% 5,829 Personnel - - - Supplies Services Debt Service Capital - - - Transfers Out 6,000 304 4,049 Total Expenditures 6,000 304 4,049 Net - - - Cash Balance 1,735,840 Staffing Full Time - Part-Time /Season al/Tem porary Total 1 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: 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. rncanr apenaing on t apnai r-rojecrs neiow: Page 130 Form 3 0% 0% 0% 0% 0% 5,829 1,951 67% - - 0% 0% 0% 0% 5,829 1,951 67% - - 0% 0% 0% 0% 0% 5,829 1,951 67% 5,829 1,951 67% rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: 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. rncanr apenaing on t apnai r-rojecrs neiow: Page 130 Form 3