The URL can be used to link to this page

Home My WebLink About09-2014 Departmental Financial ReportPeriod Ending: Issued By: September 30, 2014 Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents 1 Narrative 2 Summaries 8 General Fund 21 Special Revenue Funds 54 Debt Service /Capital Project Funds 67 Enterprise Funds 93 Internal Service Funds 98 Trust Funds 101 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff Kathryn Roos Deputy Chief of Staff Brian Pawlowski South Bend Common Council Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Financial Specialist Senior Cecil Eastman Department Heads Fiscal Officers Narrative, September 2014 The Monthly Departmental Financial Report The City of South Bend has developed the attached Monthly Departmental Financial Report to provide current year financial information for each City fund, as well as individual departments within the General Fund, in a condensed format. Information is provided for revenue, expenditures, encumbrances, cash balances and staffing levels. Also included in this report are text boxes that allow departmental fiscal officers to provide an explanation of significant expenditure and staffing variances and spending on major capital projects. Departmental fiscal officers are asked to complete the monthly financial reports ( "blue sheets ") for their funds and General Fund departments no later than the 20th of the month following the reporting period. The staff of the Department of Administration & Finance then summarizes the information and publishes this consolidated report no later than 30 days after the end of the reporting period. The Monthly Departmental Financial Report supplements —but does not replace —other financial reports that the City prepares such as the Monthly Financial Report, Controller's Cash Report, the Department of Local Government Finance's Annual Financial Report (AFR), orthe Comprehensive Annual Financial Report (CAFR). Summary Trends & Observations As of September 30, 2014, total revenue was $182,091,776, 68% of estimated revenue. As of September, 2013 total revenue received was $190,271,365 within the same funds. Excluding property taxes which are received in June and December each year, remaining revenue sources are at 72% of estimates —less than the expected 75% at this point in the year. September's cash receipts of $16.5 million included $5.6 million in pension distributions from cigarette taxes for fire and police. As of September 30, 2014, total expenditures were $195,881,184 and outstanding encumbrances were $28,955,136, a total of $224,836,320 which represents 58% of the amended expenditure budget. Encumbrances are either holdovers from previous years or obligations for the remainder of the year. Encumbrances dropped by $4 million in September as more construction projects and vendors were paid after work performed. If encumbrances were excluded, expenditures were 51% of the amended expenditure budget at the end of the period. Total expenditures were $202,193,593 as of September 30, 2013. We hope that you find this Monthly Departmental Financial Report useful in understanding the finances of the City of South Bend a little bit better. If you have any questions regarding this report, please contact us at 574 - 235 -7702. City of South Bend Monthly Department .. REVENUE SUMMARY September 30, i Current Current Percent Fund Amended Month Current YTD Prior YTD Budget of Control Type Dept Name Budget _ Actual Actual Actual Balance Budget City Funds General Fund 54,612,436 991,063 33,303,454 38,052,541 21,308,982 61% Special Revenue 102 Rainy Day 52,000 4,887 23,888 24,564 28,112 46% 201 Parks & Recreation 10,899,509 307,009 6,694,898 7,677,274 4,204,611 61% 202 Motor Vehicle Highway 9,106,300 656,754 6,141,754 7,681,161 2,964,546 67% 203 Recreation Nonreverting 1,449,592 64,094 791,419 872,407 658,173 55% 209 Studebaker - Oliver Reverting Grants 335,000 614 3,003 3,088 331,997 1% 210 Economic Development State Grants 2,077,016 198 37,006 219,605 2,040,010 2% 211 Community & Economic Development Admn. 2,278,246 18,498 1,550,863 1,692,224 727,383 68% 212 Community & Economic Development 6,911,000 522,124 2,933,846 3,592,562 3,977,154 42% 216 Police State Seizures 35,900 4,873 28,760 19,075 7,140 80% 217 Gift, Donation, Bequest 178,403 131 171,435 11,458 6,968 96% 218 Police Curfew Violations 1,025 19 370 431 655 36% 220 Law Enforcement Continuing Education 211,000 18,376 154,973 150,380 56,027 73% 227 Loss Recovery 17,000 4,138 21,331 3,818,919 -4,331 125% 244 Emergency Phone System 215,000 0 215,000 0 0 100% 249 Public Safety LOIT 6,391,029 532,206 4,789,511 4,985,846 1,601,518 75% 251 Local Roads & Streets 1,121,801 84,739 784,872 737,672 336,929 70% 252 Excess Welfare Distribution 0 1 3 3 -3 0% 258 Human Rights Federal Grant 210,700 6,877 47,395 183,226 163,305 22% 271 Eastrace Waterway 100 3 31 41 69 31% 273 Morris PAC / Palais Royale Marketing 8,100 115 8,233 4,873 -133 102% 280 Police Block Grants 0 1 8 10 -8 0% 281 Economic Develop. Commission - Revenue Bonds 0 15 75 77 -75 0% 289 HAZMAT 10,000 23 24,115 16,753 - 14,115 241% 291 Indiana River Rescue 45,200 62 38,867 64,510 6,333 86% 292 Police Grants 0 10,204 76,920 38,532 - 76,920 0% 294 Regional Police Academy 22,000 417 18,491 20,272 3,509 84% 295 COPS MORE Grant 41,600 862 8,126 8,618 33,474 20% 299 Police Federal Drug Enforcement 77,000 4,428 43,921 159,253 33,079 57% 404 County Option Income Tax 9,270,187 772,112 6,915,201 6,317,628 2,354,986 75% 408 Economic Development Income Tax 9,346,481 738,497 6,992,283 6,585,217 2,354,198 75% 410 Urban Development Action Grant 110 16 76 3,569 34 69% 655 Project Releaf 431,700 36,973 329,889 326,628 101,811 76% 705 Police K -9 Unit 2,000 1 1,006 7 994 50% Special Revenue Total 60,744,999 3,789,269 38,847,570 45,215,882 21,897,429 64% City Debt Service 313 Football Hall of Fame Debt Service 649,990 7,140 358,725 781,085 291,265 55% City Debt Service Total 649,990 7,140 358,725 781,085 291,265 55% Capital Project 288 Emergency Medical Services Capital Improv. 2,661,000 130,770 1,952,699 2,232,994 708,301 73% 377 Professional Sports Development 678,228 59,230 516,056 443,015 162,172 76% 401 Coveleski Stadium Capital 500 13,541 13,601 77 - 13,101 2720% 403 Zoo Endowment 2,900 28 136 140 2,764 5% 405 Park Nonreverting Capital 195,700 410 20,768 18,601 174,932 11% 406 Cumulative Capital Development 520,794 4,228 291,867 310,519 228,927 56% 407 Cumulative Capital Improvement 434,150 25,046 298,719 304,213 135,431 69% 412 Major Moves Construction 581,798 250,217 534,957 300,883 46,841 92% 416 Morris Performing Arts Center Capital 101,500 282 51,410 65,911 50,090 51% 434 Community Revitalization Enhancement District 651,000 25 228 455 650,772 0% 450 Palais Royale Historic Preservation 16,125 2,344 7,363 11,592 8,762 46% 677 Football Hall of Fame Capital 2,500 345 1,760 2,071 740 70% Capital Project Total 5,846,195 486,467 3,689,564 39690,471 2,156,631 63% Enterprise 600 Consolidated Building Fund 3,812,560 128,505 2,137,015 723,972 1,675,545 56% 601 Parking Garages 1,040,400 78,652 785,811 747,704 254,589 76% 610 Solid Waste Operations 5,257,701 408,587 3,935,027 4,052,918 1,322,674 75% 611 Solid Waste Capital 836,202 94,000 744,058 830,594 92,144 89% City of South Bend Monthly Department Financial Report REVENUE SUMMARY September 30, 2014 City Fu Enterp 620 Water Works Operations 14,711,333 1,204,004 10,917,518 11,182,373 3,793,815 74% 622 Water Works Capital 10,000 1,994 9,773 11,626 227 98% 623 Water Works Bond Capital 5,000 164 1,566 14,745 3,434 31% 624 Water Works Customer Deposit 6,000 829 4,086 4,026 1,914 68% 625 Water Works Sinking 2,057,224 171,350 1,539,000 1,539,896 518,224 75% 626 Water Works Bond Reserve 90,073 8,938 80,890 200,736 9,183 90% 629 Water Works Reserve Operations & Maintenance 70,312 1,180 59,238 51,058 11,074 84% 640 Sewer Repair Insurance 549,200 49,475 439,898 414,484 109,302 80% 641 Sewage Works Operations 34,553,188 2,827,300 25,091,467 23,729,796 9,461,721 73% 642 Sewage Works Capital 3,566,580 2,890 4,014,386 191,173 - 447,806 113% 643 Sewage Works Reserve Operations & Maint. 238,715 1,937 139,389 209,436 99,326 58% 645 2006 Sewer Bond 0 0 0 0 0 0% 647 Sewer Bond 2007 0 0 3 39 -3 0% 649 Sewage Sinking 9,804,645 777,826 6,982,839 7,136,612 2,821,806 71% 650 Clay Sewage Gen Fund 0 0 0 2 0 0% 651 20078 Sewer Bond 0 0 0 67 0 0% 653 Sewage Debt Service Reserve 0 0 0 14,096 0 0% 658 Sewer Bond 2010 0 1 6 213 -6 0% 659 Sewer Bond 2011 25,000 2,706 18,157 26,144 6,843 73% 661 Sewer Bond 2012 45,000 10,083 49,652 53,532 -4,652 110% 663 Sewer Bond 2013 0 0 0 0 0 0% 664 2013A Cost of Issuance Fund 0 3 12 85,744 -12 0% 665 2014 Sewer Bond 0 0 0 0 0 0% 670 Century Center 4,564,898 231,218 3,182,076 2,376,875 1,382,822 70% 671 Century Center Capital 500 23 257 675,219 243 51% Enterprise Total 81,244,531 6,001,665 60,132,123 54,273,078 21,112,408 74% Internal Service 222 Central Services 7,847,374 597,081 5,484,190 5,491,776 2,363,184 70% 226 Liability Insurance 2,898,690 241,238 2,206,674 2,257,099 692,016 76% 278 Take Home Vehicle Police 123,160 9,721 95,393 95,960 27,767 77% 711 Self- Funded Employee Benefits 13,562,450 1,104,471 9,882,331 9,208,582 3,680,119 73% 713 Unemployment Compensation 102,864 8,658 77,449 204,783 25,415 75% Internal Service Total 24,534,538 1,961,170 17,746,037 17,258,200 6,788,501 72% Trust & Agency 701 Firefighters Pension 5,391,332 2,564,701 5,130,092 5,037,356 261,240 95% 702 Police Pension 6,310,000 3,060,434 6,118,217 5,868,875 191,783 97% 703 Police /Fire 1977 Pension 0 0 0 0 0 0% 730 City Cemetery 250 18 99 116 151 40% Trust & Agency Total 11,701,582 5,625,153 11,248,408 10,906,347 453,174 96% City Funds Total 239,334,271 18,861,925 165,325,880 170,177,604 74,008,391 69% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF Revenue - Airport 13,729,822 18,214 7,796,790 9,827,605 5,933,032 57% 420 Tax Incremental Financing (TIF) - Downtown 4,168,336 7,819 2,948,845 2,312,035 1,219,491 71% 422 TIF - West Washington 422,000 519 306,060 265,891 115,940 73% 425 Redevelopment Retail & Leighton Plaza 164,303 11,378 118,489 121,951 45,814 72% 426 TIF - Central Medical Service Area 640,000 1,108 466,728 623,564 173,272 73% 429 TIF - Northeast Development 827,000 2,163 817,099 438,533 9,901 99% 430 TIF - Southside Development #1 2,515,000 2,371 1,278,753 1,396,521 1,236,247 51% 435 TIF - Douglas Road 320,750 56 161,593 164,545 159,157 50% 436 TIF - Northeast Residential 2,394,000 345 1,385,604 1,347,449 1,008,396 58% Tax Increment Financing Total 25,181,211 43,973 15,279,961 16,498,094 9,901,250 61% Redevelopment 433 Redevelopment General 0 6 44 88 -44 0% 439 Certified Technology Park 1,462,000 2,088 10,208 1,451,781 1,451,792 1% 454 Airport Urban Enterprise Zone 1,500 213 1,043 1,073 457 70% 619 Blackthorn Operations 1,696,879 174,866 1,439,649 1,457,634 257,230 85% Redevelopment Total 3,160,379 177,173 1,450,944 2,910,576 1,709,435 46% Debt Service City of South Bend Monthly Department Financial Report REVENUE SUMMARY September 30, 2014 Redeve Debt S 315 Redevelopment Bond - Airport Taxable 5,000 588 2,877 2,968 2,123 58% 317 Coveleski Debt Service Reserve 1,800 286 1,396 1,435 404 78% 319 Blackthorn Redev Bond 0 0 0 464 0 0% 328 Redevelopment Bond - Palais Royale 6,000 982 4,807 4,960 1,193 80% 432 TIF - Southside Development #3 15,000 3,360 25,911 675,264 - 10,911 173% Debt Service Total 27,800 5,216 34,991 685,091 -7,191 126% Redevelopment Commission Controlled Funds Total 28,369,390 226,362 16,765,896 20,093,760 11,603,494 59% Grand Total 267,703,661 19,088,287 182,091,776 190,271,365 85,611,885 68% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY September 30, 2014 City Funds General Fund 101 -0101 Mayor's Office 711,711 54,333 512,375 476,151 1,516 197,820 72% 101 -0104 311 Call Center 488,908 33,274 326,528 184,939 6,239 156,141 68% 101 -0201 City Clerk 394,608 24,452 254,204 239,664 8,965 131,439 67% 101 -0301 Common Council 542,598 98,765 313,665 274,984 15,685 213,248 61% 101 -0401 Administration & Finance 2,091,944 141,182 1,518,184 1,375,155 16,654 557,106 73% 101 -0404 Morris Performing Arts Center 1,063,527 61,575 711,515 714,298 47,108 304,904 71% 101 -0405 Palais Royale 523,710 29,491 310,947 292,387 46,604 166,158 68% 101 -0501 Legal Department 1,025,635 71,744 730,253 652,367 4,882 290,500 72% 101 -0600 Energy Office 2013 0 0 0 54,256 0 0 0% 101 -0602 Engineering 1,126,302 71,783 801,012 966,103 26,877 298,413 74% 101 -0607 Traffic & Lighting 2013 0 0 0 109,536 0 0 0% 101 -0801 Police Department 24,725,204 2,090,448 17,629,828 16,817,099 296,316 6,799,060 73% 101 -0802 Communications Center 2,236,486 154,912 1,506,717 1,543,353 0 729,769 67% 101 -0805 Police LOIT 2013 0 0 0 2,975,158 0 0 0% 101 -0901 Fire Department 21,049,415 1,672,369 15,994,094 15,076,682 151,396 4,903,924 77% 101 -0905 Fire LOIT 2013 0 0 0 2,634,990 0 0 0% 101 -1008 Human Rights 367,262 30,278 257,243 230,166 9,070 100,949 73% 101 -1201 Code 2013 5,225 0 851 1,494,571 2,269 2,105 60% 101 -1203 Code Hearing 2013 0 0 0 28,478 0 0 0% 101 -1204 Junk Vehicle 2013 0 0 0 29,911 0 0 0% 101 -1205 Unsafe Building 2013 0 0 750 18,947 0 -750 0% 101 -1207 Animal Control 2013 2,254 70 250 431,891 1,547 457 80% General Fund Total 56,354,789 4,534,676 40,868,418 46,621,085 635,127 14,851,244 74% Special Revenue 102 Rainy Day 0 0 0 0 0 0 0% 201 Parks & Recreation 12,600,878 981,431 9,170,401 9,488,849 231,157 3,199,320 75% 202 Motor Vehicle Highway 10,008,877 996,672 6,116,135 5,203,992 1,302,024 2,590,719 74% 203 Recreation Nonreverting 1,479,064 69,038 720,455 711,955 91,508 667,101 55% 209 Studebaker - Oliver Reverting Grants 1,415,000 0 0 0 0 1,415,000 0% 210 Economic Development State Grants 2,117,886 18,003 54,008 444,423 0 2,063,878 3% 211 Community & Economic Development Admn. 2,404,884 167,330 1,679,500 1,640,029 14,534 710,850 70% 212 Community & Economic Development 6,910,783 429,506 2,984,923 3,372,304 3,798,236 127,624 98% 216 Police State Seizures 40,000 0 0 11,450 0 40,000 0% 217 Gift, Donation, Bequest 201,010 0 13,736 0 126,610 60,663 70% 218 Police Curfew Violations 1,000 0 0 0 0 1,000 0% 220 Law Enforcement Continuing Education 294,802 25,780 146,035 281,727 13,613 135,154 54% 227 Loss Recovery 6,615,805 479,103 1,169,719 100,162 1,199,878 4,246,208 36% 244 Emergency Phone System 215,000 11,577 147,690 0 0 67,310 69% 249 Public Safety LOIT 7,214,658 582,596 5,558,635 5,344,501 0 1,656,023 77% 251 Local Roads & Streets 1,124,520 125,773 425,986 778,599 295,508 403,026 64% 252 Excess Welfare Distribution 1,146 0 0 0 0 1,146 0% 258 Human Rights Federal Grant 224,001 24,159 146,148 137,158 6,580 71,273 68% 271 Eastrace Waterway 10,346 0 9,092 0 0 1,254 88% 273 Morris PAC / Palais Royale Marketing 18,000 0 9,191 6,251 3,643 5,166 71% 280 Police Block Grants 0 0 0 0 0 0 0% 281 Economic Develop. Commission - Revenue Bonds 0 0 0 0 0 0 0% 289 HAZMAT 10,000 0 0 3,238 0 10,000 0% 291 Indiana River Rescue 52,300 1,409 26,401 81,530 3,199 22,701 57% 292 Police Grants 228,060 37,702 175,761 36,911 0 52,299 77% 294 Regional Police Academy 23,750 3,960 16,506 19,211 0 7,244 69% 295 COPS MORE Grant 141,600 3,262 14,577 11,493 0 127,023 10% 299 Police Federal Drug Enforcement 166,499 43,006 93,666 117,633 32,195 40,638 76% 404 County Option Income Tax 11,165,785 693,900 6,563,138 7,073,943 1,243,363 3,359,284 70% 408 Economic Development Income Tax 10,289,984 127,260 6,883,165 6,973,900 342,754 3,064,065 70% 410 Urban Development Action Grant 0 0 0 0 0 0 0% 655 Project Releaf 430,114 7,288 76,572 297,039 8,300 345,242 20% 705 Police K -9 Unit 2,000 0 0 0 0 2,000 0% Special Revenue Total 75,407,752 4,828,754 42,201,441 42,136,298 8,713,102 24,493,209 68% City Debt Service City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY September 30, 2014 City Ft City Debt E 313 Football Hall of Fame Debt Service 1,268,116 0 1,270,500 1,268,000 0 -2,384 100% City Debt Service Total 1,268,116 0 1,270,500 1,268,000 0 -2,384 100% Capital Project 288 Emergency Medical Services Capital Improv. 6,287,299 500,249 4,674,457 4,712,981 550,352 1,062,490 83% 377 Professional Sports Development 865,746 0 865,545 876,470 0 201 100% 401 Coveleski Stadium Capital 3,540 0 0 0 0 3,540 0% 403 Zoo Endowment 0 0 0 0 0 0 0% 405 Park Nonreverting Capital 205,217 5,092 164,307 91,306 11,288 29,622 86% 406 Cumulative Capital Development 722,935 56,545 530,663 409,721 0 192,272 73% 407 Cumulative Capital Improvement 364,762 0 369,000 367,575 0 -4,238 101% 412 Major Moves Construction 5,823,729 574,923 1,825,005 1,070,980 2,709,249 1,289,476 78% 416 Morris Performing Arts Center Capital 53,200 0 14,819 38,184 2,382 35,999 32% 434 Community Revitalization Enhancement District 650,950 0 20,975 873,949 0 629,975 3% 450 Palais Royale Historic Preservation 10,000 0 0 0 0 10,000 0% 677 Football Hall of Fame Capital 188,567 7,156 58,904 49,203 13,094 116,569 38% Capital Project Total 15,175,945 1,143,965 8,523,674 8,490,368 3,286,364 3,365,907 78% Enterprise 600 Consolidated Building Fund 3,798,909 259,445 2,276,349 757,884 296,533 1,226,027 68% 601 Parking Garages 1,597,808 52,042 571,704 631,164 115,920 910,184 43% 610 Solid Waste Operations 5,609,963 555,415 4,552,160 4,494,965 331,791 726,013 87% 611 Solid Waste Capital 996,070 10,821 778,723 631,998 0 217,347 78% 620 Water Works Operations 14,842,004 1,080,717 10,642,917 9,989,848 284,674 3,914,413 74% 622 Water Works Capital 978,258 131,658 147,861 479,189 332,458 497,939 49% 623 Water Works Bond Capital 811,011 30,220 554,576 2,192,794 35,029 221,406 73% 624 Water Works Customer Deposit 6,000 829 4,046 4,066 0 1,954 67% 625 Water Works Sinking 2,057,224 540 386,330 411,319 0 1,670,894 19% 626 Water Works Bond Reserve 0 0 0 0 0 0 0% 629 Water Works Reserve Operations & Maintenance 8,500 1,180 5,731 5,757 0 2,769 67% 640 Sewer Repair Insurance 549,978 33,989 325,335 264,663 56,363 168,280 69% 641 Sewage Works Operations 35,556,194 2,508,493 25,209,834 21,397,558 1,328,593 9,017,766 75% 642 Sewage Works Capital 9,267,941 294,490 3,409,093 2,833,675 3,021,324 2,837,524 69% 643 Sewage Works Reserve Operations & Maint. 15,000 1,937 9,425 9,140 0 5,575 63% 645 2006 Sewer Bond 0 0 0 0 0 0 0% 647 Sewer Bond 2007 1,138 0 1,143 13,616 0 -5 100% 649 Sewage Sinking 9,802,031 400 1,675,452 2,663,315 0 8,126,579 17% 650 Clay Sewage Gen Fund 0 0 0 698 0 0 0% 651 2007B Sewer Bond 0 0 0 35,983 0 0 0% 653 Sewage Debt Service Reserve 0 0 0 2,438,087 0 0 0% 658 Sewer Bond 2010 0 0 924 108,728 1,296 -2,220 0% 659 Sewer Bond 2011 13,598,486 384,241 3,489,529 1,738,887 4,376,808 5,732,149 58% 661 Sewer Bond 2012 18,868,570 343,500 867,279 3,297,603 1,307,765 16,693,526 12% 663 Sewer Bond 2013 19,100,000 0 0 0 0 19,100,000 0% 664 2013A Cost of Issuance Fund 0 0 0 81,064 0 0 0% 665 2014 Sewer Bond 0 0 0 0 0 0 0% 670 Century Center 4,564,898 245,407 2,865,798 2,203,276 0 1,699,100 63% 671 Century Center Capital 393,547 0 339,363 0 0 54,184 86% Enterprise Total 142,423,530 5,935,325 58,113,573 56,685,278 11,488,552 72,821,404 49% Internal Service 222 Central Services 8,036,532 556,287 5,390,033 5,461,876 621,735 2,024,764 75% 226 Liability Insurance 2,897,200 134,780 1,984,012 2,070,188 7,195 905,993 69% 278 Take Home Vehicle Police 80,580 0 0 63,700 0 80,580 0% 711 Self- Funded Employee Benefits 14,483,463 1,116,966 11,015,322 9,673,940 39,889 3,428,252 76% 713 Unemployment Compensation 227,974 8,540 111,403 47,764 0 116,571 49% Internal Service Total 25,725,749 1,816,572 18,500,771 17,317,467 668,819 6,556,160 75% Trust & Agency 701 Firefighters Pension 5,874,445 488,688 4,113,568 4,096,878 0 1,760,877 70% 702 Police Pension 7,221,941 530,040 5,086,630 4,871,404 0 2,135,311 70% 730 City Cemetery 20,595 0 8,658 4,316 0 11,937 42% 703 Police /Fire 1977 Pension 0 0 0 0 0 0 0% Trust & Agency Total 13,116,981 1,018,728 9,208,856 8,972,598 0 3,908,125 70% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY September 30, 2014 Current Current Percent Fund Amended Month CurrentYTD PriorYTD Current Budget of Type Department Name Budget Actual Actual Actual Encumbrances Balance Budget City Funds City Funds Total 329,472,862 19,278,021 178,687,233 181,491,094 24,791,965 125,993,665' Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIFRevenue - Airport 27,286,693 585,473 5,885,329 7,985,423 2,478,379 18,922,985 31% 420 Tax Incremental Financing (TIF) - Downtown 5,829,261 25,663 3,121,914 3,074,419 416,284 2,291,063 61% 422 TIF - West Washington 657,534 0 679 299,961 8,831 648,024 1% 425 Redevelopment Retail & Leighton Plaza 149,425 5,317 95,791 82,779 0 53,634 64% 426 TIF - Central Medical Service Area 4,103,504 0 1,781,574 999,811 175,126 2,146,804 48% 429 TIF - Northeast Development 2,806,117 4,434 5,909 33,901 107,166 2,693,042 4% 430 TIF - Southside Development #1 6,487,957 11,920 565,833 2,694,763 973,186 4,948,938 24% 435 TIF - Douglas Road 399,823 0 395,621 190,718 4,200 2 100% 436 TIF - Northeast Residential 3,583,228 246,589 3,576,880 3,022,532 0 6,348 100% Tax Increment Financing Total 51,303,542 879,396 15,429,530 18,384,307 4,163,172 31,710,840 38% Redevelopment 433 Redevelopment General 20,000 0 15,703 4,126 0 4,297 79% 439 Certified Technology Park 3,600,000 0 0 0 0 3,600,000 0% 454 Airport Urban Enterprise Zone 0 0 0 0 0 0 0% 619 Blackthorn Operations 1,671,706 169,478 1,248,883 1,489,670 0 422,823 75% Redevelopment Total 5,291,706 169,478 1,264,586 1,493,796 0 4,027,120 24% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 588 2,877 2,968 0 2,123 58% 317 Coveleski Debt Service Reserve 0 0 0 0 0 0 0% 319 Blackthorn Redev Bond 0 0 0 326,464 0 0 0% 328 Redevelopment Bond - Palais Royale 6,000 982 4,807 4,960 0 1,193 80% 432 TIF - Southside Development #3 494,151 0 492,151 490,005 0 2,000 100% Debt Service Total 505,151 1,570 499,835 824,397 0 5,316 99% Redevelopment Commission Controlled Funds Total 57,100,399 1,050,444 17,193,951 20,702,499 4,163,172 35,743,276 Grand Total 386,573,261 20,328,465 195,881,184 202,193,593 28,955,136 161,736,941 58% 7 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Month September Fund /Department Number 101 -0101 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 711,111 54,323 512,285 474,472 - 198,826 72% Local Income Taxes - - - - - - 0% Other Taxes - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - 10 30 125 - (30) 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - 60 1,514 - (60) 0% Other Income 600 - - 40 - 600 0% Transfers In - - - - - - 0% Total Revenue 711,711 54,333 512,375 476,151 - 199,336 72% Expenditures Personnel 632,608 50,048 457,798 394,114 - 174,810 72% Supplies 19,889 1,932 16,009 32,440 164 3,716 81% Services 55,853 1,803 36,478 47,947 1,352 18,023 68% Debt Service 3,361 550 2,090 1,649 - 1,271 62% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 711,711 54,333 512,375 476,151 1,516 197,820 72% Net - - - - (1,516) 1,516 Cash Balance - - Staffing Full Time 7.00 7.00 7.00 Part -Time /Seasonal /Temporary - 1.00 1.00 Total 7.00 8.00 8.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Debt Service is paid quarterly; the first payment was made in January 2014. Payroll costs are slightly heavier because there were 3 payrolls paid last month. Explain Significant Spending on Capital Projects Below: There are no capital projects budgeted for 2014. Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center Month September Fund /Department Number 101 -0104 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 8,831 - (26,509) - - 35,340 -300% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 480,077 33,274 353,037 184,939 - 127,040 74% Transfers In - - - - - - 0% Total Revenue 488,908 33,274 326,528 184,939 - 162,380 67% Expenditures Personnel 422,705 31,339 297,968 177,755 - 124,737 70% Supplies 24,771 587 13,376 3,829 1,441 9,954 60% Services 41,432 1,349 15,184 3,356 4,798 21,450 48% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 488,908 33,274 326,528 184,939 6,239 156,141 68% Net - - - - (6,239) 6,239 Cash Balance - - Staffing Full Time 6.50 6.50 6.50 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 7.50 7.50 7.50 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The negative revenues indicated in the Property Taxes line, Current Year to Date Actual column indicate that this department is collecting more in revenues than it has expended - -this department is paying for itself. Part of the reason for the negative property tax revenue is also due to timing of recording charges to other departments. There were charges that occured in 2013, however, that were not recorded until January 2014, and thus showing a credit each month YTD. This should correct itself in 2015. Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted in 2014. Form 3 Form 3 10 2014 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Month September Fund /Department Number 101 -0201 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 394,608 24,452 254,204 239,664 - 140,404 64% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 394,608 24,452 254,204 239,664 - 140,404 64% Expenditures Personnel 312,763 22,646 216,646 206,426 - 96,117 69% Supplies 8,062 38 7,065 2,703 395 602 93% Services 60,383 1,767 30,493 30,534 8,570 21,320 65% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 394,608 24,452 254,204 239,664 8,965 131,439 67% Net - - - - (8,965) 8,965 Cash Balance - - Staffing Full Time 5.00 5.00 5.00 Part -Time /Seasonal /Temporary - - - Total 5.00 5.00 5.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Personnel costs appear higher than 2013 because there were 3 bi- weekly payroll checks issued in January. This phenomenon usually occurs twice per year; the occurence was in August. Prior to the end of January, the Chief Deputy City Clerk resigned. The position was filled by the Ordinance Officer. Explain Significant Spending on Capital Projects Below: No significant changes at this time. Form 3 10 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Common Council Month September Fund /Department Number 101 -0301 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 534,298 98,738 313,042 267,959 - 221,256 59% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 8,300 27 623 7,025 - 7,677 8% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 542,598 98,765 313,665 274,984 - 228,933 58% Expenditures Personnel 297,929 15,601 152,949 146,766 - 144,980 51% Supplies 14,785 212 518 12,615 800 13,467 9% Services 229,884 82,952 160,197 115,603 14,885 54,802 76% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 542,598 98,765 313,665 274,984 15,685 213,248 61% Net - - - - (15,685) 15,685 Cash Balance - - Staffing Full Time 9.00 9.00 9.00 Part -Time /Seasonal /Temporary - - - Total 9.00 9.00 9.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: There are nine (9) Council Members. One member has declined to receive a salary. There were 3 payroll checks issued in January compared to the usual 2 issued in January 2013. This also occured in August. Total expenditures are higher in 2014 due to legal expenses for unforseen circumstances. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 WA 2014 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Month September Fund /Department Number 101 -0401 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,091,894 140,580 1,516,754 1,374,748 - 575,140 73% 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 602 1,430 406 - (1,380) 2861% Transfers In - - - - - - 0% Total Revenue 2,091,944 141,182 1,518,184 1,375,155 - 573,760 73% Expenditures Personnel 1,789,551 132,591 1,297,846 1,142,109 - 491,705 73% Supplies 39,140 2,948 25,292 27,417 1,930 11,918 70% Services 259,453 5,642 193,118 205,629 13,438 52,897 80% Debt Service 3,800 - 1,928 - 1,286 586 85% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,091,944 141,182 1,518,184 1,375,155 16,654 557,106 73% Net - - - - (16,654) 16,654 Cash Balance - - Staffing Full Time 23.00 22.00 Part -Time /Seasonal /Temporary 2.00 3.00 Total 25.00 25.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Added 3 positions in 2014. New Benefits Manager, Help Desk and Database Administrator positions were approved in the 2014 budget. The Database Administrator position remains unfilled. A new Deputy City Controller began in April, 2014. Additional training costs are being incurred during 2014 for new and existing staff members. From recent discussions with the PCard Bank issuer we learned that all rebates are received in January of the year following the purchases. Therefore, income will be received in January 2015 for purchases made in 2014. This program is expected to begin within the next 2 months. Budgeted income was adjusted in August in light of this information. Explain Significant Spending on Capital Projects Below: None Form 3 WA Form 3 13 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Month September Fund /Department Number 101 -0404 Date Updated 10/7/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 181,527 (10,496) (12,688) 94,246 - 194,215 -7% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 876,000 72,044 719,003 615,259 - 156,997 82% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 27 5,200 4,793 - 800 87% Transfers In - - - - - - 0% Total Revenue 1,063,527 61,575 711,515 714,298 - 352,012 67% Expenditures Personnel 711,096 47,204 500,789 484,984 1,221 209,086 71% Supplies 32,657 1,082 14,114 15,626 6,760 11,784 64% Services 319,774 13,289 196,612 213,688 39,128 84,034 74% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,063,527 61,575 711,515 714,298 47,108 304,904 71% Net - - - - (47,108) 47,108 Cash Balance - - Staffing Full Time 12.00 11.00 Part -Time /Seasonal /Temporary 4.00 4.00 Total 16.00 15.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund 416 is used to support renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons at the Morris Performing Arts Center. Not all of the expenses are Capital expenses. Explain Significant Spending on Capital Projects Below: Form 3 13 Form 3 14 2014 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Month September Fund /Department Number 101 -0405 Date Updated 10/7/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 213,729 8,143 141,816 62,866 - 25,309 66% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 291,981 19,781 158,703 215,707 - 133,278 54% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 18,000 1,567 10,428 13,813 - 7,572 58% Transfers In - - - - - - 0% Total Revenue 523,710 29,491 310,947 292,387 - 166,158 59% Expenditures Personnel 251,265 17,944 175,331 156,682 459 75,475 70% Supplies 31,629 967 5,257 8,249 4,187 22,186 30% Services 225,816 10,580 130,359 127,456 41,958 53,498 76% Debt Service - - - - - - 0% Capital 15,000 - - - - 15,000 0% Transfers Out - - - - - - 0% Total Expenditures 523,710 29,491 310,947 292,387 46,604 166,158 68% Net - - - - (46,604) - Cash Balance - - Staffing Full Time 2.00 2.00 Part -Time /Seasonal /Temporary 1.00 1.00 Total 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: No Capital Projects Started. Form 3 14 Form 3 2014 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Month September Fund /Department Number 101 -0501 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 953,285 68,393 725,280 650,710 - 228,005 76% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 - 1,581 958 - 419 79% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 70,350 3,351 3,392 700 - 66,958 5% Transfers In - - - - - - 0% Total Revenue 1,025,635 71,744 730,253 652,367 - 295,382 71% Expenditures Personnel 977,419 68,819 698,702 599,603 - 278,717 71% Supplies 5,083 328 2,625 12,621 1,780 678 87% Services 39,883 2,597 27,973 37,887 2,784 9,126 77% Debt Service 3,250 - 953 2,255 318 1,979 39% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,025,635 71,744 730,253 652,367 4,882 290,500 72% Net - - - - (4,882) 4,882 Cash Balance - - Staffing Full Time 9.60 9.00 Part -Time /Seasonal /Temporary - 2.00 Total 9.60 11.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Other Income of $70,350 is reimbursement for legal expenses from TIF funds. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 iV 2014 City of South Bend Monthly Financial Report Fund /Department Name Engineering Month September Fund /Department Number 101 -0602 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 1,120,202 71,683 781,251 961,203 - 338,951 70% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,100 100 19,762 4,900 - (13,662) 324% Transfers In - - - - - - 0% Total Revenue 1,126,302 71,783 801,012 966,103 - 325,290 71% Expenditures Personnel 610,675 45,454 451,136 472,876 - 159,539 74% Supplies 18,929 751 14,510 12,349 1,720 2,698 86% Services 483,156 24,930 328,314 478,256 23,184 131,659 73% Debt Service 13,542 648 7,053 2,621 1,973 4,517 67% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,126,302 71,783 801,012 966,103 26,877 298,413 74% Net - - - - (26,877) 26,877 Cash Balance - - Staffing Full Time 6.90 6.65 Part -Time /Seasonal /Temporary 1.81 1.28 Total 8.71 7.93 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Other income included $18,356 received in May as reimbursement for costs in state projects. Explain Significant Spending on Capital Projects Below: Form 3 iV Form 3 17 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Department Month September Fund /Department Number 101 -0801 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 24,387,504 2,031,414 17,372,520 16,577,165 - 7,014,984 71% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - 24,316 - - (24,316) 0% Charges for Services - - 200 - - (200) 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 7,500 - - - - 7,500 0% Other Income 330,200 59,034 232,792 239,934 - 97,408 71% Transfers In - - - - - - 0% Total Revenue 24,725,204 2,090,448 17,629,828 16,817,099 - 7,095,376 71% Expenditures Personnel 20,335,704 1,655,722 14,870,221 14,549,066 - 5,465,483 73% Supplies 754,999 34,932 483,541 315,240 92,424 179,034 76% Services 3,321,343 399,342 2,192,563 1,908,795 203,892 924,888 72% Debt Service 8,000 452 18,345 15,602 - (10,345) 229% Capital 305,158 - 65,158 28,396 - 240,000 21% Transfers Out - - - - - - 0% Total Expenditures 24,725,204 2,090,448 17,629,828 16,817,099 296,316 6,799,060 73% Net - - - - (296,316) 296,316 Cash Balance - - Staffing Full Time 253.00 241.00 241.00 Part -Time /Seasonal /Temporary 57.00 31.00 31.00 Total 310.00 272.00 272.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund includes the expenditures for 213 of the 260 budgeted Police officers and 95 civilian staff. Fund 249 contains the funding for 47 of the 260 Police officers that are funded by the LOIT. The 2014 Personnel Expenditure exceeds the prior year amount due to the 2.5 % increase in Police salaries partially offset by resignations and retirements in 2014 compared to 2013. Personnel costs are not expected to exceed the 2014 annual budget. The Supplies, 76% of budget used, is the result of a number of 2013 purchases encumbered in the 2014 budget as the Supplies were not received /paid for in 2013. Supplies expenditures for the full year 2014 are expected to be within budget. Explain Significant Spending on Capital Projects Below: Capital expenditures budget for 2014 is the result of a 2013 encumberance to upgrade the video software for the interview room plus a budget transfer to provide for the conversion of police vehicles to compressed natural gas. The year to date capital expenditure was the cost of the video software for the interview room. Form 3 17 Form 3 18 2014 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Month September Fund /Department Number 101 -0802 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,236,486 154,912 1,506,717 1,543,353 - 729,769 67% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,236,486 154,912 1,506,717 1,543,353 - 729,769 67% Expenditures Personnel 2,210,667 153,744 1,497,441 1,525,589 - 713,226 68% Supplies 4,029 - 1,362 1,245 - 2,667 34% Services 21,790 1,168 7,914 16,519 - 13,876 36% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,236,486 154,912 1,506,717 1,543,353 - 729,769 67% Net - - - - - - Cash Balance - - Staffing Full Time 35.00 31.00 31.00 Part -Time /Seasonal /Temporary - - - Total 35.00 31.00 31.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund captures the cost of 35 of the 38 civilians and equipment to maintain the 911 communication center. The cost of three supervisors has been transferred to Fund 244 as their cost is recovered through the Emergency Telephone System funding. 2014 Personnel costs approximate 2013 due to the 2% salary increase which is partially offset by the 2014 transfer of three supervisiors to Fund 244. Explain Significant Spending on Capital Projects Below: Form 3 18 2014 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Month September Fund /Department Number 101 -0901 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 19,433,415 1,633,376 14,596,116 14,109,204 4,837,299 75% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 155,000 - - - - 155,000 0% Charges for Services 455,000 38,994 397,519 428,948 - 57,481 87% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 - 460 38,530 - 5,540 8% Transfers In 1,000,000 - 1,000,000 500,000 - - 100% Total Revenue 21,049,415 1,672,369 15,994,094 15,076,682 - 5,055,321 76% Expenditures Personnel 18,806,414 1,485,363 14,441,885 13,761,739 73,819 4,290,711 77% Supplies 602,477 44,189 290,118 272,868 26,173 286,186 52% Services 1,640,524 142,818 1,262,092 1,042,075 51,404 327,028 80% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 21,049,415 1,672,369 15,994,094 15,076,682 151,396 4,903,924 77% Net - - - - (151,396) 151,396 Cash Balance - - Staffing Full Time 219.00 217.00 217.00 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 220.00 218.00 218.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The South Bend Fire Department is budgeted to have 251 sworn firefighters and 6 civilian full time employees. 38 firefighters are paid directly through the Public Safety LOIT leaving this account the balance. We swore on 1 firefighter in the month of September. We hold a lengthy recruitment process every 2 years and hire individuals in groups of 6 -10 as needed while that list is in effect. We also employ civilian administrative staff that handle payroll, purchasing and billing for our ambulance service. Explain Significant Spending on Capital Projects Below: The Fire Department uses EMS Capital Fund 288 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through that fund. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Form 3 19 Form 3 20 2014 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Month September Fund /Department Number 101 -1008 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 367,262 30,278 257,243 229,924 - 110,019 70% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 242 - - 0% Transfers In - - - - - - 0% Total Revenue 367,262 30,278 257,243 230,166 - 110,019 70% Expenditures Personnel 272,252 21,038 203,907 185,389 - 68,345 75% Supplies 2,394 32 958 2,156 16 1,421 41% Services 78,426 9,208 52,378 42,621 9,055 16,993 78% Debt Service - - - - - - 0% Capital 14,190 - - - - 14,190 0% Transfers Out - - - - - - 0% Total Expenditures 367,262 30,278 257,243 230,166 9,070 100,949 73% Net - - - - (9,070) 9,070 Cash Balance - - Staffing Full Time 4.00 4.00 4.00 Part -Time /Seasonal /Temporary - - - Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Expenditures are consistent with normal operations. Explain Significant Spending on Capital Projects Below: Form 3 20 Form 3 21 2014 City of South Bend Monthly Financial Report Fund /Department Name Rainy Day Month September Fund /Department Number 102 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 52,000 4,887 23,888 24,564 - 28,112 46% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 52,000 4,887 23,888 24,564 - 28,112 46% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 52,000 4,887 23,888 24,564 - 28,112 Cash Balance 8,641,593 8,612,744 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: No significant changes at this time. No expenditures are budgeted in this fund. The establishment of a Rainy Day Fund is looked upon favorably by bond rating agencies and is one of the factors resulting in South Bend's good AA bond rating with Standard & Poor's. Explain Significant Spending on Capital Projects Below: N/A Form 3 21 Form 3 22 2014 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation Month September Fund /Department Number 201 1 Date Updated 10/8/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 7,350,000 - 4,021,603 3,943,985 - 3,328,397 55% Local Income Taxes - - - - - - 0% Other Taxes 596,878 - 324,443 309,952 - 272,435 54% Grants /Intergovernmental 729,437 60,782 547,042 522,007 - 182,395 75% Charges for Services 2,065,040 241,762 1,695,140 2,786,276 - 369,900 82% Interest Earnings 13,000 1,597 7,013 10,540 - 5,987 54% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 145,154 2,868 99,658 104,514 - 45,496 69% Transfers In - - - 0% Total Revenue 10,899,509 307,009 6,694,898 7,677,274 - 4,204,611 61% Expenditures Personnel 7,256,942 529,559 5,360,779 5,917,331 3,183 1,892,981 74% Supplies 1,621,319 133,687 988,087 1,399,850 162,447 470,785 71% Services 3,130,772 176,964 2,507,172 1,685,167 65,527 558,072 82% Debt Service 313,345 94,682 262,825 195,646 - 50,520 84% Capital 93,000 46,538 51,538 290,855 - 41,462 55% Transfers Out 185,500 - - - - 185,500 0% Total Expenditures 12,600,878 981,431 9,170,401 9,488,849 231,157 3,199,320 75% Net (1,701,369) (674,422) (2,475,503) (1,811,576) (231,157) 1,005,291 Cash Balance 1,785,854 3,075,469 Staffing Full Time 113.00 87.00 87.00 Part -Time /Seasonal /Temporary na 158.00 158.00 Total 113.00 245.00 245.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund 201 accounts for the annual operation of the Parks and Recreation Department. There are six divisions within the department, Administration, Maintenance, Golf, Recreation, Greenhouse, and Graffiti. For 2014, the Potawatomi Zoo will be operated by the Potawatomi Zoological Society.The Zoo revenues have been removed from the budget. However, because of the timing of the change, the original expenses are still included in the above budget in order to cover obligations resulting from the memorandum of understanding between the City and PZS. January had three pay dates, which resulted in the higher personnel costs. Expenses related to the Zoo transition also contributed to the higher than normal expenses in personnel and services categories and lower cash balance. Golf Revenues have been affected by the cold, wet spring and rainy summer weather. Part time staffing is individuals, not FTEs Explain Significant Spending on Capital Projects Below: Because of decreasing property tax revenues, the only capital expense for 2014 consists of the purchase of three pickup trucks and two commercial riding mowers. Form 3 22 Form 3 23 2014 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month September Fund /Department Number 202 Date Updated 10/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,633,418 634,595 4,343,669 3,650,436 - 1,289,749 77% Grants /Intergovernmental - - - 0% Charges for Services 240,000 15,291 261,734 381,289 - (21,734) 109% Interest Earnings 7,000 2,377 9,621 9,186 - (2,621) 137% Bond Proceeds - - - 0% Donations - - - 0% Other Income 9,300 4,491 43,439 13,368 - (34,139) 467% Transfers In 3,216,582 1,483,291 3,626,882 - 1,733,291 46% Total Revenue 9,106,300 656,754 6,141,754 7,681,161 - 2,964,546 67% Expenditures Personnel 4,124,220 274,220 2,858,364 2,643,569 1,265,856 69% Supplies 3,330,683 405,712 1,346,160 1,402,678 920,325 1,064,198 68% Services 1,967,329 316,423 1,614,013 1,033,213 381,699 (28,382) 101% Debt Service 408,395 318 163,568 53,627 244,827 40% Capital 178,250 134,030 70,905 44,220 75% Transfers Out - - - - - - 0% Total Expenditures 10,008,877 996,672 6,116,135 5,203,992 1,302,024 2,590,719 74% Net (902,577) (339,918) 25,619 2,477,169 (1,302,024) 373,828 Cash Balance 3,704,096 4,748,263 Staffing Full Time 58.01 56.01 Part -Time /Seasonal /Temporary 7.14 6.68 Total 65.15 62.69 - 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. We set up a new overtime account so that we can track Special Events overtime costs which will allow for better understanding of the overtime costs incurred for special events around the City. Additional appropriations were requested and approved in July 2014 for expenses incurred as stated above. These have been reflected in the budget column above. Explain Significant Spending on Capital Projects Below: Form 3 23 Form 3 24 2014 City of South Bend Monthly Financial Report Fund /Department Name Recreation Nonreverting Month September Fund /Department Number 203 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,400,592 38,831 729,182 780,303 - 671,410 52% Interest Earnings 4,000 496 2,349 2,225 - 1,651 59% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 45,000 24,768 59,888 89,879 - (14,888) 133% Transfers In - - - - - - 0% Total Revenue 1,449,592 64,094 791,419 872,407 - 658,173 55% Expenditures Personnel 613,627 29,023 368,164 344,107 - 245,463 60% Supplies 274,095 24,540 150,134 163,520 70,139 53,822 80% Services 492,342 15,475 202,157 193,952 21,368 268,816 45% Debt Service - - - - - - 0% Capital 99,000 - - - - 99,000 0% Transfers Out - - - 10,375 - - 0% Total Expenditures 1,479,064 69,038 720,455 711,955 91,508 667,101 55% Net (29,472) (4,943) 70,964 160,453 (91,508) (8,928) Cash Balance 849,213 831,584 Staffing Full Time 1.00 1.00 1.00 Part -Time /Seasonal /Temporary - 58.00 58.00 Total 1.00 59.00 59.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund accounts for programs and events that are self funded through user fees. Registration for spring program, classes and softball leagues began in February.Part time employees are individuals, not FTEs. Explain Significant Spending on Capital Projects Below: Form 3 24 2014 City of South Bend Monthly Financial Report Fund /Department Name Studebaker - Oliver Reverting Grants Month September Fund /Department Number 209 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 30,000 - - - - 30,000 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 614 3,003 3,088 - 1,997 60% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 300,000 - - - - 300,000 0% Transfers In - - - - - - 0% Total Revenue 335,000 614 3,003 3,088 - 331,997 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 30,000 - - - - 30,000 0% Debt Service - - - - - - 0% Capital 1,385,000 - - - - 1,385,000 0% Transfers Out - - - - - - 0% Total Expenditures 1,415,000 - - - - 1,415,000 0% Net (1,080,000) 614 3,003 3,088 Cash Balance 1,086,390 1,082,763 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: There is $300,000 budgeted in Revenue as an expected insurance payment in this fund. Explain Significant Spending on Capital Projects Below: Funds to be used for environmental clean up as needed. If not used this year, funds will be appropriated for use next year. Form 3 25 Form 3 26 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Month September Fund /Department Number 210 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 2,000,000 - - - - 2,000,000 0% Charges for Services - - - - - - 0% Interest Earnings 18,813 198 8,123 56,523 - 10,690 43% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 58,203 - 28,883 163,082 - 29,320 50% Transfers In - - - - - - 0% Total Revenue 2,077,016 198 37,006 219,605 - 2,040,010 2% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 117,886 18,003 54,008 444,423 - 63,878 46% Capital 2,000,000 - - - - 2,000,000 0% Transfers Out - - - - - - 0% Total Expenditures 2,117,886 18,003 54,008 444,423 - 2,063,878 3% Net (40,870) (17,805) (17,002) (224,818) - (23,868) Cash Balance 331,948 693,637 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: No significant issues. The IRF Loan was paid off early in 2013. Original maturity date was 07/30/2022. We received a grant from the IDGF in the amount of $2,000,000 to be used for Ignition Park Infrastructure. Explain Significant Spending on Capital Projects Below: Form 3 26 Form 3 27 2014 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development Admn. Month September Fund /Department Number 211 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 386,787 - 10,680 139,636 - 376,107 3% Charges for Services - - - - - - 0% Interest Earnings 2,200 533 2,578 2,154 - (378) 117% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 200,300 17,965 270,886 262,295 - (70,586) 135% Transfers In 1,688,959 - 1,266,719 1,288,139 - 422,240 75% Total Revenue 2,278,246 18,498 1,550,863 1,692,224 - 727,383 68% Expenditures Personnel 2,058,296 147,385 1,464,199 1,353,025 - 594,097 71% Supplies 43,735 1,245 26,891 25,883 1,611 15,233 65% Services 302,853 18,700 188,410 256,401 12,923 101,520 66% Debt Service - - - - - - 0% Capital - - - 4,720 - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,404,884 167,330 1,679,500 1,640,029 14,534 710,850 70% Net (126,638) (148,832) (128,637) 52,195 (14,534) 16,533 Cash Balance 778,678 636,032 Staffing Full Time 26.60 24.80 24.80 Part -Time /Seasonal /Temporary - - - Total 26.60 24.80 24.80 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Capital expenditures for 2013 relate to purchase of whiteboard for conference room and electrical work associated with move to 14th floor. Form 3 27 Form 3 28 2014 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development Month September Fund /Department Number 212 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 6,625,000 519,357 2,609,411 3,232,182 - 4,015,589 39% Charges for Services - - - - - - 0% Interest Earnings 2,000 192 1,531 1,775 - 469 77% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 284,000 2,575 322,904 358,605 - (38,904) 114% Transfers In - - - - - - 0% Total Revenue 6,911,000 522,124 2,933,846 3,592,562 - 3,977,154 42% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 6,910,783 429,506 2,984,923 3,372,304 3,798,236 127,624 98% Transfers Out - - - - - - 0% Total Expenditures 6,910,783 429,506 2,984,923 3,372,304 3,798,236 127,624 98% Net 217 92,618 (51,077) 220,258 (3,798,236) 3,849,530 Cash Balance 539,895 733,097 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund covers multiple federal grants. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on -going and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 28 Form 3 29 2014 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Month September Fund /Department Number 216 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 35,000 4,776 28,309 18,663 - 6,691 81% Charges for Services - - - - - - 0% Interest Earnings 300 97 451 412 - (151) 150% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - - - - 600 0% Transfers In - - 0% Total Revenue 35,900 4,873 28,760 19,075 - 7,140 80% Expenditures Personnel - - - - - - 0% Supplies - 0% Services 20,000 - - 1,450 20,000 0% Debt Service - - - - - 0% Capital 20,000 - - 10,000 - 20,000 0% Transfers Out - 0% Total Expenditures 40,000 - - 11,450 - 40,000 0% Net (4,100) 4,873 28,760 7,625 - (32,860) Cash Balance 187,427 152,550 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Revenue stream is not a steady flow. It is dependent upon the processing and release of funds from the State for seized assets in drug activities. Expenditures are to be used to support the Police Departments effort to combat drug activity. Explain Significant Spending on Capital Projects Below: Form 3 29 Form 3 30 2014 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month September Fund /Department Number 217 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 290 131 323 189 - (33) 111% Bond Proceeds - - - - - - 0% Donations 178,113 - 171,113 11,269 - 7,000 96% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 178,403 131 171,435 11,458 - 6,968 96% Expenditures Personnel - - - - - - 0% Supplies 22,100 - 13,736 - - 8,364 62% Services 178,910 - - - 126,610 52,300 71% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 201,010 - 13,736 - 126,610 60,663 70% Net (22,607) 131 157,699 11,458 (126,610) (53,696) Cash Balance 232,433 74,691 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Gift, Donation, and Bequest fund may be used by all City departments but the majority of the donations are for Animal Care and Control and Community Investment (i.e. bicycle signs). In July this account received a UEA grant for Code Enforcement of $150,000, to be used for demolitions. Explain Significant Spending on Capital Projects Below: None Form 3 30 Form 3 191 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Month September Fund /Department Number 218 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,000 12 338 400 - 662 34% Interest Earnings 25 7 32 31 - (7) 128% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,025 19 370 431 - 655 36% Expenditures Personnel - - - - - - 0% Supplies - - - - - 0% Services 1,000 - - - - 1,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,000 - - - - 1,000 0% Net 25 19 370 431 Cash Balance 11,918 11,316 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was established to collect curfew and prostitution fines. Expenditures are used for Police enforcement and training. Explain Significant Spending on Capital Projects Below: Form 3 191 Form 3 KYA 2014 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education Month September Fund /Department Number 220 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - 10,000 6,964 - (10,000) 0% Charges for Services 180,000 17,561 128,620 130,994 - 51,380 71% Interest Earnings 3,000 568 2,753 2,938 - 247 92% Bond Proceeds - - - - - - 0% Donations 2,000 - - 1,965 - 2,000 0% Other Income 26,000 247 13,600 7,519 - 12,400 52% Transfers In - - - - - - 0% Total Revenue 211,000 18,376 154,973 150,380 - 56,027 73% Expenditures Personnel - - - - - - 0% Supplies 40,855 7,631 29,689 123,231 13,613 (2,447) 106% Services 190,000 18,149 102,399 35,377 - 87,601 54% Debt Service - - - - - - 0% Capital 63,947 - 13,947 123,119 - 50,000 22% Transfers Out - - - - - - 0% Total Expenditures 294,802 25,780 146,035 281,727 13,613 135,154 54% Net (83,802) (7,404) 8,938 (131,347) (13,613) (79,127) Cash Balance 990,163 955,858 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established for the continuing education and supplies for police and is funded by fees from accident reports, gun permits, false alarm and loud noise fines. Other income includes the receipt of funds from the US Marshal Service for rent of SBPD facility. The increase in Services expenditures over 2013 is due to the planned increase in officer training courses. Supply costs in 2014 exceed the budget and a budget transfer will be prepared to cover this amount. The 2014 Capital purchase was the license renewal for forensic software. The $100,000 of Capital expended in 2013 was a portion of the purchase of the Police SWAT vehicle. Explain Significant Spending on Capital Projects Below: Form 3 KYA 2014 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Month September Fund /Department Number 227 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 17,000 4,138 21,331 14,061 - (4,331) 125% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 3,804,857 - - 0% Transfers In - - - - - - 0% Total Revenue 17,000 4,138 21,331 3,818,919 - (4,331) 125% Expenditures Personnel - - - - - - 0% Supplies 200,000 - - - - 200,000 0% Services 4,315,805 469,103 1,005,299 100,162 1,199,878 2,110,628 51% Debt Service - - - - - - 0% Capital 2,100,000 10,000 164,420 - - 1,935,580 8% Transfers Out - - - - - 0% Total Expenditures 6,615,805 479,103 1,169,719 100,162 1,199,878 4,246,208 36% Net (6,598,805) (474,965) (1,148,388) 3,718,757 (1,199,878) (4,250,539) Cash Balance 6,787,645 8,060,318 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used primarily to fund Smart Streets projects as well as the Vacant & Abandoned Housing intiative. Most of the $1.2 million encumbrance for Services is to demolition companies for V &A demolitions ($730,000) and Trucks R Us for hauling contaminated refuse from the Organic Resources site ($372,000). (The Organic Resources material has small pieces of plastic in it from being hauled in plastic bags, rendering it useless as organic compost.) Explain Significant Spending on Capital Projects Below: Budgeted capital expenditures include $150,000 for a well pump at West Calvert (in association with the ethanol plant) and $1.95 million for the Smart Streets initiative. The well pump has been installed but this account's reserve has yet to be used for the streets. Form 3 33 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month September Fund /Department Number 244 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 215,000 - 215,000 - - - 100% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 215,000 - 215,000 - - - 100% Expenditures Personnel 215,000 11,577 147,690 - - 67,310 69% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 215,000 11,577 147,690 - - 67,310 69% Net - (11,577) 67,310 - - (67,310) Cash Balance 67,310 - Staffing Full Time 3.00 3.00 3.00 Part -Time /Seasonal /Temporary - - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up per requirement by the State Board Of Accounts (SBOA) to cover the cost of 911 Police Communication personnel costs covered by a State Grant. This fund will be closed in 2015 with the advent of the county -wide PSAP system. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 34 Form 3 1917 2014 City of South Bend Monthly Financial Report Fund /Department Name Public Safety WIT Month September Fund /Department Number 249 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 6,380,029 531,669 4,785,022 4,419,289 - 1,595,007 75% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 11,000 537 4,489 5,977 - 6,511 41% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 560,580 - - 0% Total Revenue 6,391,029 532,206 4,789,511 4,985,846 - 1,601,518 75% Expenditures Personnel 7,214,658 582,596 5,558,635 - - 1,656,023 77% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - 5,344,501 - - 0% Total Expenditures 7,214,658 582,596 5,558,635 5,344,501 - 1,656,023 77% Net (823,629) (50,390) (769,125) (358,655) - (54,504) Cash Balance 1,263,070 2,631,285 Staffing Full Time - 85.00 85.00 Part -Time /Seasonal /Temporary - - - Total - 85.00 85.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Prior to 2014, monies in Fund 249 were transferred quarterly to the General Fund to fund police and fire personnel. A quarterly reconciliaton was prepared and any unspent money was transferred back to Fund 249. For 2014, the City has been advised by the DLGF and SBOA that it should budget personnel costs directly from Fund 249. In 2014 the Fund includes the salary and benefit costs for 47 police officers and 38 firefighters. As of Sep 2014 the police expenditures are in line with budget but firefighters are over by $188,000. Explain Significant Spending on Capital Projects Below: None. No capital equipment is purchased from this fund. Form 3 1917 Form 3 K3.; 2014 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month September Fund /Department Number 251 Date Updated 10/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,080,000 83,416 744,998 732,439 - 335,002 69% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 8,000 1,323 6,072 5,233 - 1,928 76% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 33,801 - 33,801 - - (0) 100% Transfers In - - - - - - 0% Total Revenue 1,121,801 84,739 784,872 737,672 - 336,929 70% Expenditures Personnel - - - - - - 0% Supplies 472,663 108,952 342,382 397,338 7,618 122,663 74% Services 7,500 - - 7,500 - 7,500 0% Debt Service - - - - - - 0% Capital 644,357 16,821 83,604 373,762 287,890 272,863 58% Transfers Out - - - - - - 0% Total Expenditures 1,124,520 125,773 425,986 778,599 295,508 403,026 64% Net (2,719) (41,034) 358,886 (40,927) (295,508) (66,097) Cash Balance 2,300,261 1,673,370 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Supplies are always street paving materials to be used throughout the year. $33,801 received in April as project reimbursement for Edison & Gordon. Explain Significant Spending on Capital Projects Below: 2014 Budget: Boland Multi -Use Path: $250,000 New traffic devices: $167,000 Other projects: $325,000 $265K encumbered in Capital is for the Boland Drive Multi -Use Trail. $20,000 of the remaining encumbrance may go away; related to AEP work already performed in Triangle area. Form 3 K3.; Form 3 37 2014 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Month September Fund /Department Number 252 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 1 3 3 - (3) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 3 3 - (3) 0% Expenditures Personnel - - - - - - 0% Supplies 1,146 - - - - 1,146 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,146 - - - - 1,146 0% Net (1,146) 1 3 3 - (1,149) Cash Balance 1,153 1,149 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: In 2009, the City received a one -time $2.9 million distribution for this fund. In 2012, the City spent approximately $2.1 million for portable radios for the both the Police and Fire departments. Money in this fund may only be used for public safety purposes. The final fund balance will be spent during 2014. Explain Significant Spending on Capital Projects Below: Form 3 37 Form 3 38 2014 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant Month September Fund /Department Number 258 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 187,000 6,666 36,666 143,317 - 150,334 20% Charges for Services - - - - - - 0% Interest Earnings 2,000 211 1,181 1,310 - 819 59% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 21,700 - 9,548 38,600 - 12,152 44% Transfers In - - - - - - 0% Total Revenue 210,700 6,877 47,395 183,226 - 163,305 22% Expenditures Personnel 112,901 8,538 84,203 81,454 - 28,698 75% Supplies 4,550 149 1,350 1,229 427 2,773 39% Services 105,050 15,472 60,595 54,170 6,154 38,301 64% Debt Service - - - - - - 0% Capital 1,500 - - 304 - 1,500 0% Transfers Out - - - - - - 0% Total Expenditures 224,001 24,159 146,148 137,158 6,580 71,273 68% Net (13,301) (17,282) (98,753) 46,068 (6,580) 92,032 Cash Balance 368,022 532,233 Staffing Full Time 2.00 2.00 2.00 Part -Time /Seasonal /Temporary - - - Total 2.00 2.00 2.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Human Rights Federal Grant Fund contains separate departments for EEOC and HUD grants. Prior year cash balance is higher at this time due to receipts of grants. In September 2013, revenue received was approximately $111,000 more than September 2014. Explain Significant Spending on Capital Projects Below: A drop down projector and large screen TV has been budgeted in capital for the conference room in the new Human Rights building. Form 3 38 Form 3 39 2014 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Month September Fund /Department Number 271 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 100 3 31 41 - 69 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 100 3 31 41 - 69 31% Expenditures Personnel - - - - - - 0% Supplies 10,346 - 9,092 - - 1,254 88% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,346 - 9,092 - - 1,254 88% Net (10,246) 3 (9,060) 41 - (1,186) Cash Balance 5,312 14,364 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In past years there have been no races. Explain Significant Spending on Capital Projects Below: Form 3 39 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month September Fund /Department Number 273 Date Updated 10/7/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 8,000 100 8,160 4,793 - (160) 102% Interest Earnings 100 15 73 80 - 27 73% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 8,100 115 8,233 4,873 - (133) 102% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 18,000 - 9,191 6,251 3,643 5,166 71% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 18,000 - 9,191 6,251 3,643 5,166 71% Net (9,900) 115 (958) (1,378) (3,643) (5,299) Cash Balance 27,027 27,384 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Morris Performing Arts Center and Palais Royale Marketing Fund was established as a separate non - reverting fund to receive monies from solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marqee sponsorships; and to accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale. The funds in this account at the end of the fiscal year shall not revert to the general fund. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund Form 3 40 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Month September Fund /Department Number 280 Date Updated 10/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 1 8 10 - (8) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 8 10 - (8) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 8 10 - (8) Cash Balance 3,826 3,814 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Explain Significant Spending on Capital Projects Below: Form 3 41 Form 3 42 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Month September Fund /Department Number 281 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 15 75 77 - (75) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 15 75 77 - (75) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 15 75 77 - (75) Cash Balance 27,203 27,112 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Form 3 42 2014 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Month September Fund /Department Number 289 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 10,000 - 24,055 16,722 - (14,055) 241% Interest Earnings - 23 60 31 - (60) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 23 24,115 16,753 - (14,115) 241% Expenditures Personnel - - - - - - 0% Supplies 10,000 - - - 10,000 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - 3,238 - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,000 - - 3,238 - 10,000 0% Net - 23 24,115 13,515 - (24,115) Cash Balance 40,322 16,198 Staffing Full Time - - Part-Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Charges for Service for HAZ -MAT responses. By ordinance the South Bend Fire Department charges businesses for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund, responses are made by firefighters of the South Bend Fire Department. Received reimbursement for extended response to airplane crash. Explain Significant Spending on Capital Projects Below: No major capital expenditures are planned through this fund. Major purchases are funded through the Fire Department and EMS Capital and the minimal fees collected in this fund are used to replace equipment and gear used in responses. Form 3 43 Form 3 44 2014 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue Month September Fund /Department Number 291 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - 975 - - (975) 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 45,000 - 37,600 64,200 - 7,400 84% Interest Earnings 200 62 292 310 - (92) 146% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,200 62 38,867 64,510 - 6,333 86% Expenditures Personnel 2,500 - 628 1,508 - 1,872 25% Supplies 8,800 1,409 1,921 35,728 - 6,879 22% Services 41,000 0 23,852 16,834 3,199 13,950 66% Debt Service - - - - - - 0% Capital - - - 27,460 - - 0% Transfers Out - - - - - - 0% Total Expenditures 52,300 1,409 26,401 81,530 3,199 22,701 57% Net (7,100) (1,347) 12,466 (17,020) (3,199) (16,367) Cash Balance 108,183 102,403 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: No staffing associated with this fund. The fund collects tuition fees for students attending the Indiana River Rescue School. There are typically 2 -4 schools a year, each a week in duration. Expenditures are for the maintenance and repair of rescue equipment. Explain Significant Spending on Capital Projects Below: Form 3 44 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Month September Fund /Department Number 292 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - 10,204 76,920 38,532 - (76,920) 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 10,204 76,920 38,532 - (76,920) 0% Expenditures Personnel - - - - - - 0% Supplies - - - 36,911 - - 0% Services 138,060 - 138,059 - - 1 100% Debt Service - - - - - - 0% Capital 90,000 37,702 37,702 - - 52,298 42% Transfers Out - - - - - - 0% Total Expenditures 228,060 37,702 175,761 36,911 - 52,299 77% Net (228,060) (27,498) (98,841) 1,621 - (129,219) Cash Balance 105,668 99,745 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Of the $76,920 of grant money received in 2014, $13,753 is from a Federal grant to improve security at South Bend Schools. The South Bend Police Department is the Administrator of the grant. This funding plus cash received in December of 2013 has been disbursed to the South Bend School Corporation which spent the funds in accordance with the terms of the grant. The $138,059 Services expenditure is the reimbursement made to the South Bend School Corp for their expenditures under the Federal grant noted previously. Explain Significant Spending on Capital Projects Below: Form 3 45 2014 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Month September Fund /Department Number 294 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 20,000 375 18,275 20,045 - 1,725 91% Interest Earnings - 42 216 227 - (216) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In - - - - - - 0% Total Revenue 22,000 417 18,491 20,272 - 3,509 84% Expenditures Personnel - - - - - - 0% Supplies 1,750 60 691 71 - 1,059 39% Services 22,000 3,900 15,815 19,140 - 6,185 72% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 3,960 16,506 19,211 - 7,244 69% Net (1,750) (3,543) 1,985 1,061 - (3,735) Cash Balance 70,070 74,877 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to fund the cost of course material and instructors at the South Bend Police Academy. The enforcement courses are offered to other police departments who pay a fee to attend the training. Revenue received is 91 % of the estimated annual budget as many of the police departments outside of South Bend have paid their annual cost to participate in the instruction. Explain Significant Spending on Capital Projects Below: Form 3 46 Form 3 47 2014 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Month September Fund /Department Number 295 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 350 62 310 304 - 40 89% Bond Proceeds - - - - - - 0% Donations 3,250 - - 250 - 3,250 0% Other Income 38,000 800 7,816 8,064 - 30,184 21% Transfers In - - - - - - 0% Total Revenue 41,600 862 8,126 8,618 - 33,474 20% Expenditures Personnel - - - - - - 0% Supplies 15,000 2,699 6,365 3,482 - 8,635 42% Services 16,000 563 8,212 8,011 - 7,788 51% Debt Service - - - - - - 0% Capital 110,600 - - - - 110,600 0% Transfers Out - - - - - - 0% Total Expenditures 141,600 3,262 14,577 11,493 - 127,023 10% Net (100,000) (2,400) (6,451) (2,875) - (93,549) Cash Balance 106,893 104,414 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds received from the grants along with impound towing fees. Explain Significant Spending on Capital Projects Below: Form 3 47 Form 3 48 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Month September Fund /Department Number 299 Date Updated 10/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 75,000 4,344 35,543 125,761 - 39,457 47% Charges for Services - - - - - 0% Interest Earnings 1,000 84 742 699 - 258 74% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 1,000 - 7,636 32,793 - (6,636) 764% Transfers In - - - - - - 0% Total Revenue 77,000 4,428 43,921 159,253 - 33,079 57% Expenditures Personnel - - - - - - 0% Supplies 56,499 3,196 26,995 41,233 17,994 11,510 80% Services 40,000 760 25,994 10,455 14,201 (195) 100% Debt Service - - - - - 0% Capital 70,000 39,050 40,677 65,945 - 29,323 58% Transfers Out - - - - - - 0% Total Expenditures 166,499 43,006 93,666 117,633 32,195 40,638 76% Net (89,499) (38,578) (49,745) 41,620 (32,195) (7,559) Cash Balance 335,413 376,961 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to receive the Police Department share of money acquired in drug enforcement activity. Expenditures are to be used to fund drug enforcement and training. Spending in excess of budget reflects increased spending on enforcement tools and services which will be covered by budget transfers. Other Revenue in 2013 reflects Federal Grant reimbursement for the purchase of a bomb suit. Explain Significant Spending on Capital Projects Below: The $62,706 expenditure in 2013, was a portion of the purchase of a Swat vehicle. The $39,050 capital purchase in September is the purchase of three Police vehicles. Form 3 48 2014 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax Month September Fund /Department Number 404 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 8,645,811 720,484 6,484,358 5,885,204 - 2,161,453 75% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 75,000 8,210 40,296 41,762 - 34,704 54% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 549,376 43,418 390,547 390,662 - 158,829 71% Transfers In - - - - - - 0% Total Revenue 9,270,187 772,112 6,915,201 6,317,628 - 2,354,986 75% Expenditures Personnel - - - - - - 0% Supplies 1,294,540 87,865 913,556 842,475 6,561 374,423 71% Services 5,166,602 424,358 2,997,838 3,290,385 344,580 1,824,184 65% Debt Service 2,245,628 100,000 1,985,469 2,010,575 - 260,159 88% Capital 1,359,015 81,678 116,275 253,626 892,222 350,517 74% Transfers Out 1,100,000 - 550,000 676,882 - 550,000 50% Total Expenditures 11,165,785 693,900 6,563,138 7,073,943 1,243,363 3,359,284 70% Net (1,895,598) 78,212 352,063 (756,315) (1,243,363) (1,004,298) Cash Balance 15,257,698 14,570,687 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Significant revenue increase in 2014, due to the City receiving approximately $67,000 more per month in COIT distribution than in the prior year. The 2014 amended budget balance is negative because it includes $220,263 in encumbrances at 12/31/13 for projects that were in process. For 2014, COIT distributions from the County are $720,484.22 per month and are paid through December 31, 2014. The amount shown as Transfers Out of $1,100,000 is for the curb and sidewalk program. This is a significant increase (63 %) from last year as the program has been well received by the citizens of South Bend. The amount is transferred to the MVH fund 202. Explain Significant Spending on Capital Projects Below: This year, $297,500 has been budgeted for IT upgrades such as mobile 311 application and fiber enhancements to the County City building, Central Services and the Water Works Olive St. Station. An additional $972,500 was appropriated in May 2014 to pay Transpo for the City's portion of the new CNG fueling station. Form 3 49 Form 3 50 2014 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax Month September Fund /Department Number 408 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 8,796,821 733,068 6,597,616 6,133,014 - 2,199,205 75% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 - 354,660 354,960 - 150,000 70% Interest Earnings 45,000 5,429 28,060 27,577 - 16,940 62% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 11,948 69,665 - (11,948) 0% Transfers In - - - - - - 0% Total Revenue 9,346,481 738,497 6,992,283 6,585,217 - 2,354,198 75% Expenditures Personnel 500,335 32,455 298,128 - - 202,207 60% Supplies - - - - - - 0% Services 1,726,765 94,032 1,120,263 1,071,547 342,754 263,747 85% Debt Service 1,925,783 - 1,925,520 1,914,214 - 263 100% Capital 275,000 772 185,964 - - 89,036 68% Transfers Out 5,862,101 - 3,353,290 3,988,139 - 2,508,811 57% Total Expenditures 10,289,984 127,260 6,883,165 6,973,900 342,754 3,064,065 70% Net (943,503) 611,238 109,119 (388,684) (342,754) (709,867) Cash Balance 10,951,247 9,595,727 Staffing Full Time 9.00 7.00 Part -Time /Seasonal /Temporary 0.50 0.50 Total 9.50 7.50 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 2014 Budget includes 10 people (9 FT, 1 PT) from Code Enforcement as a result of the 2014 Budget as advertised and a consequential limitation in Fund 600. Transfers Out include $1.69 million to DCI, $1.87 million to MVH, and $2.3 million to the Building Dept fund for Code Enforcement operations. Explain Significant Spending on Capital Projects Below: $275,000 has been budgeted for the Potawatomi Zoological Society. Form 3 50 Form 3 61 2014 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Month September Fund /Department Number 410 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 110 16 76 80 - 34 69% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 3,489 - - 0% Transfers In - - - - - - 0% Total Revenue 110 16 76 3,569 - 34 69% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 110 16 76 3,569 - 34 Cash Balance 27,664 27,321 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This budget usually includes payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. No new payments from the BDC are expected until 2015. Explain Significant Spending on Capital Projects Below: Form 3 61 Form 3 M 2014 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Month September Fund /Department Number 655 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 429,000 36,325 327,018 324,234 - 101,982 76% Interest Earnings 2,700 649 2,871 2,394 - (171) 106% Bond Proceeds - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 36,973 329,889 326,628 - 101,811 76% Expenditures Personnel 64,378 25 1,531 1,173 - 62,847 2% Supplies 8,369 - - 347 8,300 69 99% Services 34,583 7,263 27,342 22,280 - 7,241 79% Debt Service 72,784 - 47,699 23,238 - 25,085 66% Capital - - - - - - 0% Transfers Out 250,000 - - 250,000 - 250,000 0% Total Expenditures 430,114 7,288 76,572 297,039 8,300 345,242 20% Net 1,586 29,685 253,316 29,590 (8,300) (243,430) Cash Balance 1,192,228 889,224 Staffing Full Time - - Part -Time /Seasonal /Temporary 2.16 Total 2.16 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Program is planned to begin on October 27th and (weather permitting) run through the first week in December. The $250,000 transfer is to MVH to cover their costs in this process. Explain Significant Spending on Capital Projects Below: Form 3 M Form 3 53 2014 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Month September Fund /Department Number 705 Date Updated 10/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10 1 6 6 - 4 60% Bond Proceeds - - - - - - 0% Donations 1,990 - 1,000 - - 990 50% Other Income - - - 1 - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 1 1,006 7 - 994 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,000 - - - - 2,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,000 - - - - 2,000 0% Net - 1 1,006 7 - (1,006) Cash Balance 2,319 1,937 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds. Explain Significant Spending on Capital Projects Below: Form 3 53 2014 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service Month September Fund /Department Number 313 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 497,000 - 271,788 693,822 - 225,212 55% Local Income Taxes - - - - - - 0% Other Taxes 67,350 - 22,679 33,662 - 44,671 34% Grants /Intergovernmental 85,640 7,140 64,258 53,601 - 21,382 75% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 649,990 7,140 358,725 781,085 - 291,265 55% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 1,268,116 - 1,270,500 1,268,000 - (2,384) 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,268,116 - 1,270,500 1,268,000 - (2,384) 100% Net (618,126) 7,140 (911,775) (486,915) - 293,649 Cash Balance (195,439) 90,458 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to collect a separate property tax levy (distributions received in June and December) and is used to pay debt service on the former College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will typically have a negative cash balance until the property tax distributions are received. PILOT taxes paid by the utilities are received monthly in this fund. Property taxes were received in the amount of $271,788 during June, 2014 The property tax collections represented 54.69% of the 2014 budgeted revenue amount. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. The February and July debt service payments have been made for 2014. The fund will receive additional property taxes and license excise tax revenue during December, 2014. Explain Significant Spending on Capital Projects Below: None Form 3 54 Form 3 6101 2014 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Improv.7 I Month September Fund /Department Number 288 1 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 2,623,000 128,768 1,932,335 2,201,300 - 690,665 74% Interest Earnings 10,000 1,903 13,047 14,770 - (3,047) 130% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 28,000 100 7,316 16,925 - 20,684 26% Transfers In - - - - - - 0% Total Revenue 2,661,000 130,770 1,952,699 2,232,994 - 708,301 73% Expenditures Personnel - - - - - - 0% Supplies 300,000 14,186 151,553 197,085 9,910 138,537 54% Services 416,952 33,745 255,804 2,626,811 16,005 145,142 65% Debt Service 351,106 318 247,497 40,667 2,046 101,563 71% Capital 4,219,241 452,000 3,019,603 1,348,419 522,390 677,248 84% Transfers Out 1,000,000 - 1,000,000 500,000 - - 100% Total Expenditures 6,287,299 500,249 4,674,457 4,712,981 550,352 1,062,490 83% Net (3,626,299) (369,478) (2,721,758) (2,479,987) (550,352) (354,189) Cash Balance 2,837,656 3,077,017 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The revenues in this account are generated through user fees for the South Bend Fire Department EMS division. These funds are used for capital purchases such as fire apparatus, ambulances and major construction projects. There are no employees associated with this fund. Incurring project expenses for construction of Fire Training Facility and Fire Station 5 which will be reimbursed through bond. Operated costs are incurred through the General Fund (101 -0901) and so a transfer of $1,000,000 is processed to cover those expenditures. Explain Significant Spending on Capital Projects Below: Continued construction of Fire Training Facility. Form 3 6101 2014 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month September Fund /Department Number 377 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 600,000 58,993 447,704 362,795 - 152,296 75% Charges for Services - - - - - - 0% Interest Earnings 4,000 237 1,642 2,369 - 2,358 41% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 74,228 - 66,710 77,851 - 7,518 90% Transfers In - - - - - - 0% Total Revenue 678,228 59,230 516,056 443,015 - 162,172 76% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 865,746 - 865,545 776,470 - 201 100% Capital - - - - - - 0% Transfers Out - - - 100,000 - - 0% Total Expenditures 865,746 - 865,545 876,470 - 201 100% Net (187,518) 59,230 (349,489) (433,455) - 161,971 Cash Balance 492,567 607,368 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Effective January 1, 2013, this fund no longer collects hotel /motel tax allocations from St. Joseph County for payment to the Hall of Fame. This fund is currenty used for debt, and a $100,000 capital transfer to Century Center. PSDA tax revenue is generally received from the State on a monthly basis. PSDA tax is a special tax received from the State of Indiana based on the sales tax, income tax and local income taxes collected in the PSDA area (which includes Coveleski Stadium, Century Center, Morris Performing Arts Center and Studebaker National Museum). Coveleski Stadium generates the majority of PSDA revenue. The January debt service payments have been made for 2014. The final debt service payment on the 2010 Coveleski Stadium bonds was paid January 15, 2013. The outsanding principal balance on the bonds is $2,850,263 at July 31, 2014. Explain Significant Spending on Capital Projects Below: Form 3 MR' Form 3 57 2014 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month September Fund /Department Number 401 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 15 74 77 - 426 15% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - 13,526 13,526 - - (13,526) 0% Transfers In - - - - - - 0% Total Revenue 500 13,541 13,601 77 - (13,101) 2720% Expenditures Personnel - - - - - - 0% Supplies 2,002 - - - - 2,002 0% Services 1,538 - - - - 1,538 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,540 - - - - 3,540 0% Net (3,040) 13,541 13,601 77 - (16,641) Cash Balance 40,451 26,835 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fd 401 accounts for capital spending on Coveleski Stadium. Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. Explain Significant Spending on Capital Projects Below: Form 3 57 2014 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Month September Fund /Department Number 403 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 200 28 136 140 - 64 68% Bond Proceeds - - - - - - 0% Donations 2,700 - - - - 2,700 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,900 28 136 140 - 2,764 5% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 2,900 28 136 140 - 2,764 Cash Balance 49,158 48,986 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to account for donations dedicated to Potawatomi Zoo. In the past few years several endowments that were funding this fund were liquidated resulting in a drop in revenues to this fund. Explain Significant Spending on Capital Projects Below: Form 3 58 Form 3 59 2014 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Month September Fund /Department Number 405 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 3,000 198 7,481 4,005 - (4,481) 249% Interest Earnings 2,200 212 1,144 1,191 - 1,056 52% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 12,144 13,405 - (12,144) 0% Transfers In 190,500 - - - - 190,500 0% Total Revenue 195,700 410 20,768 18,601 - 174,932 11% Expenditures Personnel - - - - - - 0% Supplies 58,417 5,080 50,075 66,535 9,293 (951) 102% Services 40,000 12 19,232 40 1,995 18,774 53% Debt Service - - - - - - 0% Capital 106,800 - 95,000 24,731 - 11,800 89% Transfers Out - - - - - - 0% Total Expenditures 205,217 5,092 164,307 91,306 11,288 29,622 86% Net (9,517) (4,682) (143,539) (72,705) (11,288) 145,310 Cash Balance 429,352 419,681 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This is a nonreverting capital fund that accounts for revenues collected and expenses for specific purposes or locations. These locations are Potawatomi and Rum Village Picnic Areas, the East Race, Golf Courses, Forestry, Howard Park Ice Rink, and, until 2014, Potawatomi Zoo. The cash balance includes $60,300 that is restricted to expenditures in Voorde Park. Explain Significant Spending on Capital Projects Below: This fund is for expending nonreverting revenue collected from the Zoo, golf courses, East Race Waterway, picnic sites and forestry revenue. Form 3 59 2014 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development Month September Fund /Department Number 406 1 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 430,000 - 235,215 253,553 - 194,785 55% Local Income Taxes - - - - - - 0% Other Taxes 87,294 3,891 53,995 54,467 - 33,299 62% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 3,500 337 1,804 2,287 - 1,696 52% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 854 212 - (854) 0% Transfers In - - - - - - 0% Total Revenue 520,794 4,228 291,867 310,519 - 228,927 56% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 378 - - 0% Debt Service 722,935 56,545 530,663 409,343 - 192,272 73% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 722,935 56,545 530,663 409,721 - 192,272 73% Net (202,141) (52,317) (238,796) (99,202) - 36,655 Cash Balance 547,003 736,568 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund receives revenue from a property tax levy and distributions are received from St. Joseph County in June and December. Expenditures are for debt service payments on capital leases and the due dates vary per lease. The fund is used to finance police vehicles and related equipment. The fund also receives PILOT payments from the Water Works and Wastewater utilities on a monthly basis. For the 2014 budget, this fund will be used to pay existing police capital lease payments but will not include a capital lease for 2014. This payment will be moved to the COIT Fund No. 404 Explain Significant Spending on Capital Projects Below: There is no capital expenditure budgeted for 2014. Form 3 60 2014 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement Month September Fund /Department Number 407 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 409,000 - 273,553 279,108 - 135,447 67% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 46 166 105 - (16) 110% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 25,000 25,000 25,000 - - 100% Transfers In - - - - - - 0% Total Revenue 434,150 25,046 298,719 304,213 - 135,431 69% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 364,762 - 369,000 367,575 - (4,238) 101% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 364,762 - 369,000 367,575 - (4,238) 101% Net 69,388 25,046 (70,281) (63,362) - 139,669 Cash Balance 106,443 34,358 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Revenue in this fund includes $150,000 in hotel /motel taxes and $258,990 in cigarette taxes from other units of government. The hotel /motel tax distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December. In 2014, this fund is used to pay 75% of the 2011 Century Center Refunding bonds as it was in 2013. Payments on the Century Center bond are due in February and July. Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year. Explain Significant Spending on Capital Projects Below: None Form 3 61 2014 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction Month September Fund /Department Number 412 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - 0% Interest Earnings 25,000 3,628 19,265 22,110 - 5,735 77% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 556,798 246,589 515,692 278,773 - 41,106 93% Transfers In - - - - - - 0% Total Revenue 581,798 250,217 534,957 300,883 - 46,841 92% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 5,823,729 574,923 1,825,005 1,070,980 2,709,249 1,289,476 78% Transfers Out - - - - - - 0% Total Expenditures 5,823,729 574,923 1,825,005 1,070,980 2,709,249 1,289,476 78% Net (5,241,931) (324,706) (1,290,047) (770,096) (2,709,249) (1,242,635) Cash Balance 5,853,851 7,126,600 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Initial funding for the Major Moves fund in the amount of $12,823,151 was received from the State of Indiana on September 15, 2006. The money was derived from the State lease of the 1 -80 tollroad to a private company. This fund has been used in the past to provide seed money for economic development projects at Douglas Road, Eddy Street Commons, and the Triangle Development near Notre Dame. The amounts advanced for these projects are being repaid by the respective tax increment financing (TIF) funds as per formal amortization schedules. The amounts outstanding were $886,677 (Fund 435 - Douglas Road) and $4,740,818 (Fund 436 - Eddy Street/Triangle) at 30 September 2014. These revenue streams are scheduled to cease in 2030. Encumbrances are for projects such as the Marion St. Roundabout, Olive - Sample Overpass, and Two -Way Conversion for Main and St. Joseph Streets. Explain Significant Spending on Capital Projects Below: The 2014 Budget includes $5.6 million for the Smart Streets initiative, as well as a prior -year encumbrance of $173,020 for utility relocation on the US 31 project south of town. Of the $2.7 million encumbered as of 30 September, $435,000 remains for DLZ for the Olive - Sample overpass project, $700,000 for Selge Construction for Jefferson Blvd Streetscapes, $608,000 to Lawson- Fisher Associates for development of the Marion St. roundabout, $207,000 to CHA Consulting for Corridors development, and $206,000 to American Structurepoint for 2 -way street conversion activities. Form 3 62 Form 3 63 2014 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Month September Fund /Department Number 416 Date Updated 10/7/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 100,000 - 50,080 64,745 - 49,920 50% Interest Earnings 1,500 282 1,330 1,166 - 170 89% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 101,500 282 51,410 65,911 - 50,090 51% Expenditures Personnel - - - - - - 0% Supplies 14,700 - 6,054 10,411 - 8,646 41% Services 38,500 - 8,765 11,945 2,382 27,353 29% Debt Service - - - - - - 0% Capital - - - 15,828 - - 0% Transfers Out - - - - - - 0% Total Expenditures 53,200 - 14,819 38,184 2,382 35,999 32% Net 48,300 282 36,591 27,728 (2,382) 14,091 Cash Balance 493,401 423,995 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established for the purpose of renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons of the Morris Performing Arts Center. There is no staffing for this fund. Funds in this account are received from a per ticket surcharge included on every sold ticket. Explain Significant Spending on Capital Projects Below: There are no Capital projects budgeted for this year. Form 3 63 2014 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Month September Fund /Department Number 434 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 650,000 - - - - 650,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,000 25 228 455 - 772 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 651,000 25 228 455 - 650,772 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 650,950 - 20,975 873,949 - 629,975 3% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 650,950 - 20,975 873,949 - 629,975 3% Net 50 25 (20,747) (873,494) - 20,797 Cash Balance (11,209) (649,908) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: CREED is derived from State sale taxes generated within the CREED district (within Studebaker /Oliver area) up to a maximum $1 M annually through 2015.The distribution is made once a year in October and amount fluctuates significantly (note historical revenues). Fund did not have sufficient revenue last year to make full debt payment so COIT had to make $415,000 of the payment. Anticipating revenue will again be short in 2014 to make full payments, but possibly 2015 funding will allow us to reimburse COIT at least a portion of its funding. Explain Significant Spending on Capital Projects Below: Form 3 64 Form 3 65 2014 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Month September Fund /Department Number 450 Date Updated 10/7/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 16,000 2,311 7,208 11,417 - 8,792 45% Interest Earnings 125 33 156 175 - (31) 125% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,125 2,344 7,363 11,592 - 8,762 46% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,000 - - - - 10,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 10,000 - - - - 10,000 0% Net 6,125 2,344 7,363 11,592 - (1,238) Cash Balance 60,759 69,896 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. No capital projects are planned for 2014. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund. Form 3 65 Form 3 66 2014 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Month September Fund /Department Number 677 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 345 1,760 2,029 - 740 70% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 42 - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 345 1,760 2,071 - 740 70% Expenditures Personnel - - - - - - 0% Supplies 15,000 - 419 3,124 - 14,581 3% Services 173,567 7,156 58,485 46,079 13,094 101,988 41% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,567 7,156 58,904 49,203 13,094 116,569 38% Net (186,067) (6,811) (57,144) (47,132) (13,094) (115,829) Cash Balance 601,263 671,955 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Hall of Fame Capital fund covers maintenance and utilities expense on the building incurred by the City, including costs of the building after the Hall of Fame ceased operations in South Bend at the end of 2012. The $8,908 of the encumbrance is for Otis Elevator for maintenance. Explain Significant Spending on Capital Projects Below: No Capital expenditures budgeted for 2014. Form 3 66 Form 3 67 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund Month September Fund /Department Number 600 Date Updated 10/13/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,503,000 127,986 974,937 721,124 - 528,063 65% Interest Earnings 1,000 124 1,077 560 - (77) 108% Bond Proceeds - - - - - - 0% Donations - 277 5,572 - - (5,572) 0% Other Income 2,000 118 2,150 2,287 - (150) 107% Transfers In 2,306,560 - 1,153,280 - - 1,153,280 50% Total Revenue 3,812,560 128,505 2,137,015 723,972 - 1,675,545 56% Expenditures Personnel 2,012,791 141,189 1,377,406 660,015 2,640 632,745 69% Supplies 205,215 12,117 107,798 30,640 9,164 88,254 57% Services 1,366,633 103,133 775,607 54,895 283,591 307,434 78% Debt Service 21,800 3,007 15,539 12,334 1,137 5,124 76% Capital 192,470 - - - - 192,470 0% Transfers Out - - - - - - 0% Total Expenditures 3,798,909 259,445 2,276,349 757,884 296,533 1,226,027 68% Net 13,651 (130,940) (139,335) (33,913) (296,533) 449,518 Cash Balance 13,247 169,937 Staffing Full Time 30.00 34.00 Part -Time /Seasonal /Temporary - 2.00 Total 30.00 36.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund now comprises the Consolidated Building Department, most of Code Enforcement and Animal Control. Code and Animal Control are managed together but are run separately from the Building Department per Council's wishes. There are 9 additional positions for Code Enforcement that are paid from the EDIT fund (408) as it was not possible to increase the expenditures of this fund to accommodate them as a result of an advertising limitation. The $2.3 million transfer is from the General Fund to cover Code and Animal Control activities which, unlike the Consolidated Building Department, are not enterprises by nature. Explain Significant Spending on Capital Projects Below: Capital includes 5 vehicles for Code Enforcement and 1 for the Building Department. Form 3 67 Form 3 68 2014 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages Month September Fund /Department Number 601 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 900,500 72,179 658,822 643,527 - 241,678 73% Interest Earnings 4,000 603 2,685 2,431 - 1,315 67% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 135,900 5,870 124,304 101,746 - 11,596 91% Transfers In - - - - - - 0% Total Revenue 1,040,400 78,652 785,811 747,704 - 254,589 76% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 676,679 51,928 503,503 473,531 17,000 156,176 77% Debt Service - - - - - - 0% Capital 921,129 114 68,201 157,633 98,920 754,008 18% Transfers Out - - - - - - 0% Total Expenditures 1,597,808 52,042 571,704 631,164 115,920 910,184 43% Net (557,408) 26,610 214,107 116,540 (115,920) (655,595) Cash Balance 1,098,296 971,985 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 2013 projects were: upgrade lighting; new signage; and trash receptacles. 2014 projects currently include: elevator repairs; painting; and storm water drain repairs. Additional capital needs are being identified for possible 2014 appropriation. Operations under outside contract with Downtown South Bend, Inc. so all expenses except capital are shown under Services line to show consistently with Redevelopment Retail and Blackthorn Golf Course. Explain Significant Spending on Capital Projects Below: Form 3 68 Form 3 69 2014 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations Month September Fund /Department Number 610 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 4,815,830 407,927 3,711,805 3,652,671 - 1,104,025 77% Interest Earnings 6,000 232 2,944 2,543 - 3,056 49% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 435,871 427 220,278 396,876 - 215,593 51% Transfers In - - - 828 - - 0% Total Revenue 5,257,701 408,587 3,935,027 4,052,918 - 1,322,674 75% Expenditures Personnel 1,502,054 125,709 1,280,371 1,291,153 980 220,703 85% Supplies 394,595 96,133 362,959 284,183 6,218 25,418 94% Services 2,877,312 239,574 2,164,913 2,089,391 324,593 387,806 87% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 836,002 94,000 743,916 830,239 - 92,086 89% Total Expenditures 5,609,963 555,415 4,552,160 4,494,965 331,791 726,013 87% Net (352,262) (146,829) (617,132) (442,047) (331,791) 596,661 Cash Balance 182,995 738,468 Staffing Full Time 24.20 22.20 Part -Time /Seasonal /Temporary 8.00 8.00 Total 32.20 30.20 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund charges City residents a small monthly fee to pick up and dispose of their trash at area landfills and recycling centers. The operations of Solid Waste are totally funded by these user fees. A much needed purchase of trash totes for distribution to City residents is the main reason operating supplies are running at 94% of budget year to date. Large encumbrances for landfill tipping fees and recycling services, along with higher than expected vehicle repair and maintenance costs, are contributing to the Services budget already at 87% used. Explain Significant Spending on Capital Projects Below: Form 3 69 2014 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Month September Fund /Department Number 611 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 200 0 142 355 - 58 71% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 836,002 94,000 743,916 830,239 92,086 89% Total Revenue 836,202 94,000 744,058 830,594 - 92,144 89% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 736,002 10,821 607,541 603,950 - 128,461 83% Capital 260,068 - 171,182 28,048 88,886 66% Transfers Out - - - - - - 0% Total Expenditures 996,070 10,821 778,723 631,998 - 217,347 78% Net (159,868) 83,179 (34,665) 198,596 - (125,204) Cash Balance 83,776 198,704 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to pay for capital items, such as trash trucks, used in the day to day operations of Solid Waste. Other than a small amount of interest income, the sole source of revenue for this fund comes from dollars transferred in from the Solid Waste Operations Fund #610. These transfers are done on an as needed basis. Explain Significant Spending on Capital Projects Below: Year to date capital spending has been for retrofitting trash trucks with on -board RFID tag reader computer systems. Form 3 70 Form 3 71 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations Month September Fund /Department Number 620 Date Updated 10.9.14 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 14,589,253 1,195,844 10,770,659 11,073,731 - 3,818,594 74% Interest Earnings 9,000 1,683 8,699 4,807 - 301 97% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 93,580 1,725 124,471 92,693 - (30,891) 133% Transfers In 19,500 4,752 13,689 11,142 - 5,811 70% Total Revenue 14,711,333 1,204,004 10,917,518 11,182,373 - 3,793,815 74% Expenditures Personnel 4,594,374 322,341 3,308,806 3,167,565 2,418 1,283,150 72% Supplies 1,624,686 76,420 1,017,128 625,764 80,500 527,059 68% Services 4,638,911 332,152 3,324,581 3,153,393 201,756 1,112,573 76% Debt Service 6,555 560 3,882 2,592 - 2,673 59% Capital - - - - - - 0% Transfers Out 3,977,478 349,244 2,988,520 3,040,534 - 988,958 75% Total Expenditures 14,842,004 1,080,717 10,642,917 9,989,848 284,674 3,914,413 74% Net (130,671) 123,286 274,600 1,192,525 (284,674) (120,597) Cash Balance 3,729,249 2,798,382 Staffing Full Time 70.20 66.70 Part -Time /Seasonal /Temporary 3.00 5.00 Total 73.20 71.70 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to account for all revenue and operational expense of the water utility. This fund provides the monies for debt service obligations, reserve requirements and revenue funded capital improvements through transfer of monies to other funds within the utility operations. Year to date service revenues moved downward by 2.7% compared to 2013. Other income revenue has increased due to scrap water meter sales. Meter supplies and construction /maintenance material purchases are greater this year. The predominant rise in services is mostly in the customer accounts expense. Increases are in the areas of credit card settlements and 311 Call Center costs. Explain Significant Spending on Capital Projects Below: Form 3 71 Form 3 72 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Month September Fund /Department Number 622 Date Updated 10.9.14 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10,000 1,994 9,773 11,626 - 227 98% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 1,994 9,773 11,626 - 227 98% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,600 - 3,600 22,450 - - 100% Debt Service - - - - - - 0% Capital 974,658 131,658 144,261 456,739 332,458 497,939 49% Transfers Out - - - - - - 0% Total Expenditures 978,258 131,658 147,861 479,189 332,458 497,939 49% Net (968,258) (129,664) (138,089) (467,564) (332,458) (497,712) Cash Balance 3,393,637 3,677,754 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used for acquiring, constructing, and improving fixed assets. Explain Significant Spending on Capital Projects Below: YTD Spending: North Station Roof Restoration $98,047 Hybrid Vechicle $23,769 SCADA Hardware /Software $22,445 YTD Encumbrance: North Station Roof Restoration $ 232,464 Trucks (2) $67,463 Laptopw /Orion Meter Reading Software $13,441 SCADA Hardware /Software $19,090 Form 3 72 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Month September Fund /Department Number 623 Date Updated 10.9.14 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 164 1,566 14,745 3,434 31% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 164 1,566 14,745 - 3,434 31% Expenditures Personnel - - 0% Supplies 209,422 30,220 137,762 1,245,043 24,679 46,981 78% Services 74,076 - 42,103 - 10,350 21,623 71% Debt Service - - - - - - 0% Capital 527,513 - 374,711 947,751 - 152,802 71% Transfers Out - - - - - 0% Total Expenditures 811,011 30,220 554,576 2,192,794 35,029 221,406 73% Net (806,011) (30,056) (553,010) (2,178,049) (35,029) (217,972) Cash Balance 259,620 3,624,787 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The purpose of this fund is to segragate the use of bond proceeds that are applied to the acquisition, construction and installation of certain additions, extension and improvements. Revenue bonds were issued in June 2012 with an aggregrate principal of $8,300,000. Interest earnings year to date is minimal due to a lesser amount of cash on hand. Explain Significant Spending on Capital Projects Below: YTD Spending: Water Meters $121,496 Pinhook WT Efficiency Improv Project $433,080 YTD Encumbrance: Water Meters $5,592 Boland Park PRV $29,437 Form 3 73 Form 3 74 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Month September Fund /Department Number 624 Date Updated 10.9.14 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - 4,026 - - 0% Interest Earnings 6,000 829 4,046 - - 1,954 67% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - 40 - - (40) 0% Total Revenue 6,000 829 4,086 4,026 - 1,914 68% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 829 4,046 4,066 - 1,954 67% Total Expenditures 6,000 829 4,046 4,066 - 1,954 67% Net - - 40 (40) - (40) Cash Balance 1,472,546 1,446,643 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to retain security deposits collected from customers when establishing new service. Upon termination of service, these deposits are released and credited against final bills. Explain Significant Spending on Capital Projects Below: Form 3 74 Form 3 75 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Month September Fund /Department Number 625 Date Updated 10.9.14 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 540 1,710 1,319 - 3,290 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 2,052,224 170,810 1,537,290 1,538,577 - 514,934 75% Total Revenue 2,057,224 171,350 1,539,000 1,539,896 - 518,224 75% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 2,052,224 - 384,620 410,000 - 1,667,604 19% Capital - - - - - - 0% Transfers Out 5,000 540 1,710 1,319 - 3,290 34% Total Expenditures 2,057,224 540 386,330 411,319 - 1,670,894 19% Net - 170,810 1,152,670 1,128,577 - (1,152,670) Cash Balance 1,158,007 1,133,213 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. The source of monies for debt repayment are transfers from the water utility operating fund 620. Biannual installments are disbursed at the end of June and December. Explain Significant Spending on Capital Projects Below: Form 3 75 Form 3 76 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Month September Fund /Department Number 626 Date Updated 10.09.14 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,500 908 4,348 3,902 - 1,152 79% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income - - - 0% Transfers In 84,573 8,030 76,542 196,834 - 8,031 91% Total Revenue 90,073 8,938 80,890 200,736 - 9,183 90% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 90,073 8,938 80,890 200,736 - 9,183 Cash Balance 1,646,566 1,512,424 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to ensure compliance with certain debt service bond covenants. Balance in fund is determined by debt service financing arrangements at bond issuance. All reserve maximum requirement amounts will be fully satisfied by the end of October this year. Explain Significant Spending on Capital Projects Below: Form 3 76 Form 3 77 2014 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Month September Fund /Department Number 629 Date Updated 10.09.14 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 8,500 1,180 5,731 5,757 - 2,769 67% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 61,812 - 53,507 45,301 - 8,305 87% Total Revenue 70,312 1,180 59,238 51,058 - 11,074 84% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 1,180 5,731 5,757 - 2,769 67% Total Expenditures 8,500 1,180 5,731 5,757 - 2,769 67% Net 61,812 - 53,507 45,301 - 8,305 Cash Balance 2,085,039 2,031,532 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to hold cash reserves to serve as fiscal protection against the risk of revenue shortfalls, emergencies and other economic risks that may impact the Water Utility's ability to meet financial commitments. Additional money was transferred in during the month of February to satisfy 100% of the 2014 requirement. Explain Significant Spending on Capital Projects Below: Form 3 77 Form 3 78 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Month September Fund /Department Number 640 Date Updated 10/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 548,000 48,651 435,949 411,039 - 112,051 80% Interest Earnings 1,200 824 3,949 3,446 - (2,749) 329% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 549,200 49,475 439,898 414,484 - 109,302 80% Expenditures Personnel 177,387 13,495 127,018 85,520 50,369 72% Supplies 17,115 150 11,624 14,774 3,120 2,371 86% Services 327,041 20,344 172,476 150,152 53,243 101,322 69% Debt Service 28,435 14,218 14,218 14,217 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 549,978 33,989 325,335 264,663 56,363 168,280 69% Net (778) 15,486 114,563 149,821 (56,363) (58,978) Cash Balance 1,476,963 1,310,310 Staffing Full Time 2.10 2.10 - Part -Time /Seasonal /Temporary - - - Total 2.10 2.10 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Increase in salaries due to new allocation of portion of Sewer Manager and Sewer Concrete Job Leader salaries. Explain Significant Spending on Capital Projects Below: Form 3 78 Form 3 79 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations Month September Fund /Department Number 641 Date Updated 10/15/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,460,188 2,812,413 24,989,770 23,649,613 - 9,470,418 73% Interest Earnings 18,000 3,596 15,711 12,840 - 2,289 87% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,000 9,354 76,561 53,981 - (16,561) 128% Transfers In 15,000 1,937 9,425 13,362 - 5,575 63% Total Revenue 34,553,188 2,827,300 25,091,467 23,729,796 - 9,461,721 73% Expenditures Personnel 6,776,379 485,205 5,033,730 4,806,362 749 1,741,900 74% Supplies 2,419,100 203,498 1,179,732 1,196,936 255,803 983,565 59% Services 12,452,029 1,044,057 7,593,648 7,808,352 1,072,041 3,786,340 70% Debt Service 359,746 814 298,489 241,971 - 61,257 83% Capital - - - - - - 0% Transfers Out 13,548,940 774,919 11,104,235 7,343,937 - 2,444,705 82% Total Expenditures 35,556,194 2,508,493 25,209,834 21,397,558 1,328,593 9,017,766 75% Net (1,003,006) 318,807 (118,367) 2,332,238 (1,328,593) 443,955 Cash Balance 7,051,981 6,552,173 Staffing Full Time 95.04 94.04 Part -Time /Seasonal /Temporary 7.00 7.00 Total 102.04 101.04 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Service revenue is running slightly below budget estimates as the approved rate increase was below the estimated amount. Debt service payments are made in accordance with City amortization schedules. Transfers out are done as needed to fund capital purchases in Fund 642 and to fund scheduled debt service payments. Explain Significant Spending on Capital Projects Below: Form 3 79 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Month September Fund /Department Number 642 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 39,000 2,890 14,386 23,079 - 24,614 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 168,094 - - 0% Transfers In 3,527,580 - 4,000,000 - - (472,420) 113% Total Revenue 3,566,580 2,890 4,014,386 191,173 - (447,806) 113% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 133,264 21,401 76,937 144,432 56,327 0 100% Debt Service - - - - - - 0% Capital 9,134,677 273,089 3,332,156 2,689,242 2,964,997 2,837,524 69% Transfers Out - - - - - - 0% Total Expenditures 9,267,941 294,490 3,409,093 2,833,675 3,021,324 2,837,524 69% Net (5,701,361) (291,599) 605,293 (2,642,501) (3,021,324) (3,285,330) Cash Balance 4,649,859 6,220,608 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund is used to purchase capital equipment and fund major renovations /restorations for the Wastewater and Sewer Departments. The primary source of income is from Sewage Works Operating Fund #641, which transfers funds here as needed. Projects budgeted this year include Sewer Relining and Manhole Rehab. work throughout the City, replacing the Eastgate area Lift Station, and rebuilding /replacing the dewatering presses at the Wastewater Plant. Explain Significant Spending on Capital Projects Below: Year to Date totals include WWTP Primary Clarifier rehab $1,368,902, Sage /Poppy Rd Lift Station $289,919, Ferric Chloride Feed Facility $341,029; Sewer Dept. tandem axle dump trucks $323,802, Jet Rodder /Vacuum machine $309,680; Manhole Rehab. work $131,735, Sewer lining work $262,157, CNG station upgrade $90,000, Wastewater tri -axle roll -off truck $171,693. Form 3 80 Form 3 I.1 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Month September Fund /Department Number 643 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 1,937 9,425 9,140 - 5,575 63% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 223,715 - 129,964 200,296 - 93,751 58% Total Revenue 238,715 1,937 139,389 209,436 - 99,326 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 1,937 9,425 9,140 - 5,575 63% Total Expenditures 15,000 1,937 9,425 9,140 - 5,575 63% Net 223,715 - 129,964 200,296 - 93,751 Cash Balance 3,422,564 3,292,600 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The sole purpose of this fund is to hold the equivalent of two months of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. Any transfers to this fund are done to adjust the balance as needed to stay in compliance. Explain Significant Spending on Capital Projects Below: Form 3 I.1 Form 3 E:A 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Month September Fund /Department Number 647 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - 3 39 (3) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - 3 39 - (3) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,138 - 1,143 13,616 - (5) 100% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,138 - 1,143 13,616 - (5)1 100% Net (1,138) - (1,141) (13,577) - 3 Cash Balance 0 5,464 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Bond, issued in 2007, is now fully spent. Explain Significant Spending on Capital Projects Below: Form 3 E:A Form 3 83 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Month September Fund /Department Number 649 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 7,000 2,907 8,568 7,067 - (1,568) 122% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,797,645 774,919 6,974,271 7,129,545 - 2,823,374 71% Total Revenue 9,804,645 777,826 6,982,839 7,136,612 - 2,821,806 71% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,000 400 3,200 1,400 - (200) 107% Debt Service 9,799,031 - 1,672,252 2,661,915 - 8,126,779 17% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,802,031 400 1,675,452 2,663,315 - 8,126,579 17% Net 2,614 777,426 5,307,387 4,473,297 - (5,304,773) Cash Balance 6,090,194 5,309,342 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to pay all debt service obligations for Wastewater and Sewers (Sewage Works). Mandatory transfers in from Operating Fund 641 are done in specified amounts each month to satisfy bond covenants. Explain Significant Spending on Capital Projects Below: Form 3 83 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Month September Fund /Department Number 653 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 14,096 - - 0% Total Revenue - - - 14,096 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - 2,434,563 - - 0% Capital - - - - - - 0% Transfers Out - - - 3,524 - - 0% Total Expenditures - - - 2,438,087 - - 0% Net - - - (2,423,992) - - Cash Balance 7,286,828 7,286,828 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Debt Reserve fund is held in a separate account with Bank of NY Mellon Trust. A reconcilliation of that account is done monthly. The account was fully funded for existing debt in 2013. Explain Significant Spending on Capital Projects Below: Form 3 84 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Month September Fund /Department Number 658 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 1 6 213 - (6) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 6 213 - (6) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - 924 108,728 - (924) 0% Debt Service - - - - - - 0% Capital - - - - 1,296 (1,296) 0% Transfers Out - - - - - - 0% Total Expenditures - - 924 108,728 1,296 (2,220) 0% Net - 1 (918) (108,515) (1,296) 2,214 Cash Balance 1,297 3,688 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The small balance in this fund has been encumbered, and is expected to be spent this year. Explain Significant Spending on Capital Projects Below: Form 3 1.1001 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 Month September Fund /Department Number 659 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 25,000 2,706 18,157 26,144 - 6,843 73% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 2,706 18,157 26,144 - 6,843 73% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 705,491 600 2,584 255,445 3,000 699,907 1% Debt Service - - - - - - 0% Capital 12,892,995 383,641 3,486,945 1,483,442 4,373,808 5,032,242 61% Transfers Out - - - - - - 0% Total Expenditures 13,598,486 384,241 3,489,529 1,738,887 4,376,808 5,732,149 58% Net (13,573,486) (381,535) (3,471,372) (1,712,743) (4,376,808) (5,725,305) Cash Balance 4,377,127 8,453,767 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Sewage Works Revenue Bond closed in October of 2011. A number of projects have been funded from this bond; the more significant ones are listed below. Explain Significant Spending on Capital Projects Below: From issue late in 2011, this bond has funded numerous projects including Diamond Ave. Trunk Sewer, Phase II $3.7 million, East Bank Sewer Separation, Phase II $2.8 million, East Bank Sewer Separation, Phase III $2.3 million, LaSalle School area Sewer Separation, $1.7 million, East Bank Sewer Separation, Phase III $545,000, Southwood Sewer Separation, $229,000, Diamond Ave. Trunk Sewer, Phase III $248,000, St. Joseph River CSO Stabilization $171,000, and Wastewater Treatment Plant Digester Upgrade $3,697,539. Form 3 Mt Form 3 87 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Month September Fund /Department Number 661 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 45,000 10,083 49,652 53,532 - (4,652) 110% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 45,000 10,083 49,652 53,532 - (4,652) 110% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,870,000 343,500 867,279 104,981 - 4,002,721 18% Debt Service - - - - - - 0% Capital 13,998,570 - - 3,192,622 1,307,765 12,690,805 9% Transfers Out - - - - - - 0% Total Expenditures 18,868,570 343,500 867,279 3,297,603 1,307,765 16,693,526 12% Net (18,823,570) (333,417) (817,628) (3,244,071) (1,307,765) (16,698,178) Cash Balance 17,481,399 20,002,816 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Projects funded from this Bond in 2013 and 2014 year -to -date include: East Bank Sewer Separation -Phase 4 $2.6 million, Diamond Ave. Sewer Separation -Phase 3, $2.6 million, Prairie Avenue Sewer Separation $377,600, and Southwood Sewer Separation $316,568. Form 3 87 Form 3 88 2014 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2013 Month September Fund /Department Number 663 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 910,000 - - - - 910,000 0% Debt Service - - - - - - 0% Capital 18,190,000 - - - - 18,190,000 0% Transfers Out - - - - - - 0% Total Expenditures 19,100,000 - - - - 19,100,000 0% Net (19,100,000) - - - - (19,100,000) Cash Balance - - Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: A budget was set up in this fund in anticipation of the issuance of a Sewer Bond in 2013. However, a bond was not issued, therefore no activity is expected in this fund. Explain Significant Spending on Capital Projects Below: Form 3 88 2014 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund Month September Fund /Department Number 664 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 3 12 4 - (12) 0% Bond Proceeds - - - 85,740 - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 3 12 85,744 - (12) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 81,064 - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - 81,064 - - 0% Net - 3 12 4,680 - (12) Cash Balance 4,480 4,680 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up to pay the issue costs related to the re- funding of the 2004 Sewer bond and 1998 SRF Loan. Most of those costs were paid in 2013. Explain Significant Spending on Capital Projects Below: Form 3 89 2014 City of South Bend Monthly Financial Report Fund /Department Name 2014 Sewer Bond Month September Fund /Department Number 665 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - - - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up in anticipation of a possible Sewer Bond issue in late 2014. Explain Significant Spending on Capital Projects Below: Form 3 1*10" Form 3 F!Y 2014 City of South Bend Monthly Financial Report Fund /Department Name Century Center Month September Fund /Department Number 670 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,313,436 - 1,313,450 1,313,436 - (14) 100% Grants /Intergovernmental - - - - - - 0% Charges for Services 3,236,462 229,048 1,825,474 1,008,088 - 1,410,988 56% Interest Earnings - - - 228 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 15,000 2,170 43,152 55,123 - (28,152) 288% Transfers In - - - - - - 0% Total Revenue 4,564,898 231,218 3,182,076 2,376,875 - 1,382,822 70% Expenditures Personnel 2,450,875 147,298 1,583,877 1,342,714 - 866,998 65% Supplies 476,400 12,645 370,712 129,472 - 105,688 78% Services 1,222,594 85,464 911,209 731,090 - 311,385 75% Debt Service - - - - - - 0% Capital 415,029 - - - - 415,029 0% Transfers Out - - - - - - 0% Total Expenditures 4,564,898 245,407 2,865,798 2,203,276 - 1,699,100 63% Net - (14,189) 316,278 173,599 - (316,278) Cash Balance 1,046,086 1,240,251 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: SMG has assumed management of Century Center effective July 1, 2013. One of their contractual duties is to reduce the operating deficit in the fund. Covered by hotel /motel tax revenue which is received twice per year. The second installment was received in July 2014. Capital expenitures were made for a new freight elevator in prior months and were reimbursed in August 2014 through the Century Center Capital Fund. Other income includes charges to large conferences for electric charges. Explain Significant Spending on Capital Projects Below: Form 3 F!Y 2014 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Month September Fund /Department Number 671 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - 100,000 - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 23 257 219 - 243 51% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 575,000 - - 0% Transfers In - - - - - - 0% Total Revenue 500 23 257 675,219 - 243 51% Expenditures Personnel - - - - - - 0% Supplies 54,184 - - - - 54,184 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 339,363 - 339,363 - - - 100% Transfers Out - - - - - - 0% Total Expenditures 393,547 - 339,363 - - 54,184 86% Net (393,047) 23 (339,106) 675,219 - (53,941) Cash Balance 1,418,591 1,950,097 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Century Center Board of Managers has not approved a 2014 capital budget in this fund. An appropriation to cover the cost of the new freight elevator originally paid out of Fund 670 was approved in July 2014. A transfer was done in August to move the cost from Fund 670 to Fund 671. SMG contributed a one time amount of $575,000 to cover capital expenses in August 2013. Explain Significant Spending on Capital Projects Below: New Freight Elevator installed in 2014. Form 3 MA 2014 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month September Fund /Department Number 222 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 7,796,184 589,655 5,354,561 5,378,718 - 2,441,623 69% Interest Earnings 3,000 663 3,193 2,830 - (193) 106% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 48,190 6,763 126,436 110,227 - (78,246) 262% Transfers In - - - - - - 0% Total Revenue 7,847,374 597,081 5,484,190 5,491,776 - 2,363,184 70% Expenditures Personnel 2,828,264 204,268 1,980,989 1,915,077 847,275 70% Supplies 177,649 (6,179) 110,996 119,909 21,566 45,086 75% Services 4,852,122 356,784 3,291,762 3,352,851 565,438 994,921 79% Debt Service 6,497 1,414 6,285 5,310 210 2 100% Capital 172,000 - - 68,728 34,520 137,480 20% Transfers Out - - - - - - 0% Total Expenditures 8,036,532 556,287 5,390,033 5,461,876 621,735 2,024,764 75% Net (189,158) 40,794 94,157 29,900 (621,735) 338,420 Cash Balance 1,515,433 1,083,350 Staffing Full Time 42.00 42.00 42.00 Part -Time /Seasonal /Temporary 2.00 2.00 2.00 Total 44.00 44.00 44.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Central Services Division consists of six cost centers that provide a variety of services to other city departments, along with several local county, state and federal agencies. On the Revenue side we received checks for $39,980 from Energizing Indiana. On the expense side,the services acct is at 80% because we encumbered the rental costs on the Printshop equipment for the year, monies were also encumbered for the utilities. The supply acct. goes up and down, depending on vehicle repairs. In Sept we had 1,326 repairs. Year to Date repairs are 12,226. Average Fuel prices for the first 9 months are $3.02 for Unleaded and $3.31 for Diesel. Budgeted amount per gallon is $3.45. In September we inspected all Taxi Cabs and licensed Taxi Drivers bringing in a revenue of $10,100. Explain Significant Spending on Capital Projects Below: We amended our budget to add the following Capital Projects: Upgrade the Sample St Garage to meet the requirements for Compressed Natural Gas vehicle repairs. Purchase of two in- ground hoists for the Sample St Garage. The purchase of a vehicle diagnostic scanner tool. Radio tower inspection repairs throughout the City. Form 3 F!IN Form 3 ME 2014 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance Month September Fund /Department Number 226 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 2,859,690 238,310 2,144,789 2,239,797 - 714,901 75% Interest Earnings 22,000 2,928 14,218 15,443 - 7,782 65% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 - 47,667 1,859 - (30,667) 280% Transfers In - - - - - - 0% Total Revenue 2,898,690 241,238 2,206,674 2,257,099 - 692,016 76% Expenditures Personnel 189,417 14,015 137,069 124,818 - 52,348 72% Supplies 21,143 988 10,498 12,500 - 10,645 50% Services 2,676,640 119,777 1,836,446 1,908,877 7,195 832,999 69% Debt Service - - - - - - 0% Capital 10,000 - - 23,994 - 10,000 0% Transfers Out - - - - - - 0% Total Expenditures 2,897,200 134,780 1,984,012 2,070,188 7,195 905,993 69% Net 1,490 106,458 222,661 186,911 (7,195) (213,976) Cash Balance 5,408,159 5,432,323 Staffing Full Time 3.00 3.00 3.00 Part -Time /Seasonal /Temporary - - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund handles operations relating to business insurance and claims: property, liability, workers compensation, etc. and the operation of the safety and risk department. We expect to finish the year within budget. Explain Significant Spending on Capital Projects Below: Form 3 ME Form 3 1:17 2014 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Month September Fund /Department Number 278 Date Updated 10/14/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 60,580 4,710 47,070 47,400 - 13,510 78% Interest Earnings 2,000 301 1,361 1,187 - 639 68% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,580 4,710 46,963 47,373 - 13,617 78% Transfers In - - - - - - 0% Total Revenue 123,160 9,721 95,393 95,960 - 27,767 77% Expenditures Personnel - - - - - - 0% Supplies 60,580 - - 63,700 - 60,580 0% Services 20,000 - - - - 20,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 80,580 - - 63,700 - 80,580 0% Net 42,580 9,721 95,393 32,260 - (52,813) Cash Balance 548,346 424,066 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund charges police officers for liability insurance and gasoline costs for take home police vehicles. No expenditures for vehicle claims have been paid so far in 2014.The cash reserves in this fund have been increasing in recent years and are expected to increase during 2014. Claims have been minimal in this fund since it was created. This fund is classified as an Internal Service Fund for financial reporting. No liability claims were paid during 2013. Explain Significant Spending on Capital Projects Below: None Form 3 1:17 2014 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits Month September Fund /Department Number 711 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 13,385,150 1,066,610 9,661,141 8,976,578 - 3,724,009 72% Interest Earnings 32,000 2,777 15,128 21,506 - 16,872 47% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 145,300 35,084 206,062 210,498 - (60,762) 142% Transfers In - - - - - - 0% Total Revenue 13,562,450 1,104,471 9,882,331 9,208,582 - 3,680,119 73% Expenditures Personnel 4,326 - - - - 4,326 0% Supplies 38,675 2,957 32,676 9,177 2,334 3,665 91% Services 760,062 45,979 475,913 394,265 13,000 271,149 64% Insurance 13,680,400 1,068,029 10,506,733 9,270,497 24,555 3,149,112 77% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 14,483,463 1,116,966 11,015,322 9,673,940 39,889 3,428,252 76% Net (921,013) (12,495) (1,132,991) (465,358) (39,889) 251,867 Cash Balance 4,528,456 6,962,833 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund handles expenses relating to insurance and claims relating to employees: medical, dental, life, flex spending, etc. For the last several years expenses have significantly exceeded revenues (charges to City Departments and employees) so our cash balance has been eroding. We budgeted a $1 million loss this year and it will likely be more than that. Our insurance advisor is projecting medical claims to reach 107% of budget; if this occurs, this would be an additional $780,000 loss. We've already lost over $1,000,000 this year. This is not sustainable in the long -term and we need to address this situation. For the 2015 Budget, we increased employer and employee contributions significantly, which should help. We are also working with our insurance advisor on some other options. Explain Significant Spending on Capital Projects Below: None Form 3 Mt 2014 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Month September Fund /Department Number 713 Date Updated 10/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 102,364 8,530 76,773 204,395 - 25,591 75% Interest Earnings 500 128 676 388 - (176) 135% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 102,864 8,658 77,449 204,783 - 25,415 75% Expenditures Personnel 220,750 7,938 105,985 44,551 - 114,765 48% Supplies - - - - - - 0% Services 7,224 602 5,418 3,213 - 1,806 75% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 227,974 8,540 111,403 47,764 - 116,571 49% Net (125,110) 118 (33,954) 157,019 - (91,156) Cash Balance 226,076 229,586 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund charges an allocation of 0.5% of payroll to most departments to cover the cost of unemployment claims paid. For the 2014 budget, the rate charged to departments has been reduced to 0.25% due to favorable claims history and increasing cash reserves. Budgeted charges for services were adjusted in July 2014 to reflect the change in charges to the departments. At December 31, 2013, claims paid on behalf of former Parks & Recreation department employees were $31,307, or 11% of total claims paid. The Unemployment Compensation Fund is classified as an Internal Service Fund for financial reporting. Claims continue to be lower than anticipated. Explain Significant Spending on Capital Projects Below: None Form 3 MA Form 3 14. 2014 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension Month Sept Fund /Department Number 701 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,386,832 2,564,549 5,129,098 5,035,292 - 257,734 95% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,500 152 994 2,064 - 3,506 22% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,391,332 2,564,701 5,130,092 5,037,356 - 261,240 95% Expenditures Personnel 5,869,495 488,603 4,112,977 4,095,951 - 1,756,518 70% Supplies 200 - - - - 200 0% Services 4,750 85 591 927 - 4,159 12% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,874,445 488,688 4,113,568 4,096,878 - 1,760,877 70% Net (483,113) 2,076,013 1,016,524 940,478 Cash Balance 1,954,623 2,288,344 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Fire Pension fund receives State of Indiana pension relief payments in June and September to reimburse the City for actual pension costs paid and reported in the previous year. For 2014, the payments are expected to be $2,564,549 by 1 July and again by 1 October, totaling $5,129,098. Explain Significant Spending on Capital Projects Below: No capital expenditures are purchased through this account. Form 3 14. Form 3 1*9 2014 City of South Bend Monthly Financial Report Fund /Department Name Police Pension Month September Fund /Department Number 702 Date Updated 10/3/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 6,300,000 3,055,932 6,111,865 5,863,697 - 188,135 97% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - 881 - - 0% Interest Earnings 6,000 380 2,230 4,066 - 3,770 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,000 4,122 4,122 230 - (122) 103% Transfers In - - - - - - 0% Total Revenue 6,310,000 3,060,434 6,118,217 5,868,875 - 191,783 97% Expenditures Personnel 7,216,441 529,941 5,085,862 4,869,368 - 2,130,579 70% Supplies 1,100 - 151 642 - 949 14% Services 4,400 99 617 1,394 - 3,783 14% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 7,221,941 530,040 5,086,630 4,871,404 - 2,135,311 70% Net (911,941) 2,530,394 1,031,587 997,471 Cash Balance 2,740,245 3,306,098 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Police Pension fund receives pension relief distributions from the State of Indiana to reimburse the City for pension costs paid and reported in the previous fiscal year. For 2014, the payments are expected to be $3,055,933 by 1 July and again by 1 October, totaling $6,111,865. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Form 3 1*9 2014 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Month September Fund /Department Number 730 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 250 18 99 116 - 151 40% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 250 18 99 116 - 151 40% Expenditures Personnel - - - - - - 0% Supplies - - - 4,316 - - 0% Services 10,595 - 8,658 - 1,937 82% Debt Service - - - - - - 0% Capital 10,000 - - - - 10,000 0% Transfers Out - - - - - - 0% Total Expenditures 20,595 - 8,658 4,316 - 11,937 42% Net (20,345) 18 (8,558) (4,199) - (11,787) Cash Balance 28,376 36,913 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is designated for expenses specifically for the City Cemetery. Revenues were originally derived from the sale of cemetery plots and burial expenses.There are few sites available for sale and most plots are occupied, resulting in little burial activty. Explain Significant Spending on Capital Projects Below: Spending this year will concentrate on repairing headstones and completing the GIS survey of the cemetery and its occupants. Form 3 K1101 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF Revenue - Airport Month September Fund /Department Number 324 1 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 13,400,000 - 7,521,012 7,111,555 - 5,878,988 56% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 115,612 15,863 68,018 50,253 - 47,594 59% Bond Proceeds 101,267 - 101,267 - - - 100% Donations - - - 65,000 - - 0% Other Income 107,943 1,763 103,616 2,321,865 - 4,327 96% Transfers In 5,000 588 2,877 278,932 - 2,123 58% Total Revenue 13,729,822 18,214 7,796,790 9,827,605 - 5,933,032 57% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 7,087,163 583,973 3,172,592 1,201,471 2,444,144 1,470,427 79% Debt Service 3,536,127 1,500 2,665,453 2,812,121 - 870,674 75% Capital 16,663,403 - 47,284 3,971,831 34,235 16,581,884 0% Transfers Out - - - - - - 0% Total Expenditures 27,286,693 585,473 5,885,329 7,985,423 2,478,379 18,922,985 31% Net (13,556,871) (567,259) 1,911,461 1,842,182 (2,478,379) (12,989,953) Cash Balance 26,931,592 20,063,554 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 2013 Revenue from one time payment from AJ Wright of $2 M received in April along with Blackthorn debt service paid off in 2013 and reserve amount returned to this fund. While one can find usefulness in reviewing revenue trends in TIF funds from one year to the next, because projects change wildly from one year to the next, it is less meaningful to examine year to date expenditures against the prior year to date. Major projects carried out in 2013 were: Ignition Park Infrastructure; Data Realty; the SB Animal Shelter reconstruction; continued acquisition in Ignition Park South and East; purchase of Scientific Equipment in Ignition Park; acquisition in the LaSalle Square Area; the Renaissance District Phase I and the beginnings of Phase II; the beginnings of expenditures on the Studebaker /Oliver Project; and Bosch holding costs. In 2014, the major projects thus far approved are: Continuation of projects approved for 2013; and the addition of the Kolata contract. Explain Significant Spending on Capital Projects Below: Capital projects thus far this year are: Renaissance District Phase II; major expenditures in the Certified Tech Park; the Studebaker /Oliver project; and continued Ignition Park South & East acquisitions. Form 3 word Form 3 102 2014 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown Month September Fund /Department Number 420 1 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 3,400,000 - 2,485,266 1,705,491 - 914,734 73% Local Income Taxes - - - - - - 0% Other Taxes 401,000 - 200,000 198,500 - 201,000 50% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,000 2,928 28,526 24,809 - 5,474 84% Interest Earnings 49,645 1,382 30,387 44,071 - 19,258 61% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 277,691 2,527 199,859 334,204 - 77,832 72% Transfers In 6,000 982 4,807 4,960 - 1,193 80% Total Revenue 4,168,336 7,819 2,948,845 2,312,035 - 1,219,491 71% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 596,950 25,479 333,310 350,084 168,528 95,112 84% Debt Service 2,972,966 - 2,772,964 2,680,921 - 200,002 93% Capital 2,259,345 184 15,640 43,414 247,756 1,995,949 12% Transfers Out - - - - - - 0% Total Expenditures 5,829,261 25,663 3,121,914 3,074,419 416,284 2,291,063 61% Net (1,660,925) (17,844) (173,069) (762,384) (416,284) (1,071,572) Cash Balance 2,431,404 2,075,496 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF funds are used to fund projects which vary widely from year to year, so no real trend is expected from one year to the next. Explain Significant Spending on Capital Projects Below: Capital projectes committed to in 2014 include: Finishing Century Center West Entrance; Studebaker Plaza; Hill & Colfax Mixed Use Development; and Lasalle Hotel. Capital projects taken on in 2013 were:Century Center West Entrance; Studebaker Plaza; and Wayne Street Garage Facade improvements. Form 3 102 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Month September Fund /Department Number 422 1 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 420,000 - 304,152 264,690 - 115,848 72% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 519 1,908 1,201 - 92 95% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 422,000 519 306,060 265,891 - 115,940 73% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 10,319 - 679 2,038 531 9,109 12% Debt Service - - - - - - 0% Capital 647,215 - - 297,923 8,300 638,915 1% Transfers Out - - - - - - 0% Total Expenditures 657,534 - 679 299,961 8,831 648,024 1% Net (235,534) 519 305,381 (34,070) (8,831) (532,084) Cash Balance 918,344 417,659 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year so little can be gained by comparing expenditures from year to year. Major projects for 2013 were: Completion of Rushton Square and William Streetscape. Major Projects committed thus far in 2014 are: Completion of Rushton Square. Explain Significant Spending on Capital Projects Below: Major projects committed thus far in 2014 are: Completion of Rushton Square. Form 3 103 Form 3 104 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Month September Fund /Department Number 425 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 51 248 249 - 252 50% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 163,803 11,327 118,241 121,702 - 45,562 72% Transfers In - - - - - - 0% Total Revenue 164,303 11,378 118,489 121,951 - 45,814 72% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 128,373 5,317 79,255 76,470 - 49,118 62% Debt Service - - - - - - 0% Capital 21,052 - 16,536 6,309 - 4,516 79% Transfers Out - - - - - - 0% Total Expenditures 149,425 5,317 95,791 82,779 - 53,634 64% Net 14,878 6,061 22,698 39,172 - (7,820) Cash Balance 155,764 134,567 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Operations under outside contract with Bradley Co. so all expenses except capital are shown under Services line, to show consistently with Parking Garages and Blackthorn Golf Course. Explain Significant Spending on Capital Projects Below: Form 3 104 Form 3 KIM 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Month September Fund /Department Number 426 1 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 625,000 - 459,659 613,185 - 165,341 74% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 1,108 7,069 10,379 - 7,931 47% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 640,000 1,108 466,728 623,564 - 173,272 73% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,721,310 - 1,543,685 94,684 175,126 2,499 100% Debt Service - - - - - - 0% Capital 2,382,194 - 237,889 905,127 - 2,144,305 10% Transfers Out - - - - - 0% Total Expenditures 4,103,504 - 1,781,574 999,811 175,126 2,146,804 48% Net (3,463,504) 1,108 (1,314,846) (376,247) (175,126) (1,973,532) Cash Balance 1,917,567 3,482,854 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Major projects in 2013 were the continuation of: Memorial Campus Street Improvements; 400 Block N. Michigan Parking Lot; and Skyway Bridge /Building Improvements. Projects committed thus far in 2014: Completion of projects worked on in 2013 and 2 -Way Streets. Explain Significant Spending on Capital Projects Below: Projects committed thus far in 2014: Completion of projects worked on in 2013 and 2 -Way Streets. Form 3 KIM Form 3 `[IN 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Development Month September Fund /Department Number 429 1 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 820,000 - 808,184 431,979 - 11,816 99% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 7,000 2,163 8,915 6,554 - (1,915) 127% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 827,000 2,163 817,099 438,533 - 9,901 99% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 142,827 4,434 5,909 33,901 107,166 29,752 79% Debt Service - - - - - - 0% Capital 2,663,290 - - - - 2,663,290 0% Transfers Out - - - - - - 0% Total Expenditures 2,806,117 4,434 5,909 33,901 107,166 2,693,042 4% Net (1,979,117) (2,271) 811,190 404,632 (107,166) (2,683,141) Cash Balance 3,819,980 2,624,254 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Major projects in 2013 were: Demolition in relation to AEP Easement; Hill Street Improvements and 5 points utility study. Commitments thus far in 2014 are: 5 points utility improvement /move and infrastructure; and completion of Hill Street Improvements. The Capital budget was increased by $450,000 on 6 Mar 2014. Explain Significant Spending on Capital Projects Below: Form 3 `[IN 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 Month September Fund /Department Number 430 1 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,500,000 - 1,268,946 1,381,537 - 1,231,054 51% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 2,371 9,807 14,984 - 5,193 65% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,515,000 2,371 1,278,753 1,396,521 - 1,236,247 51% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 811,834 510 158,016 433,436 81,822 571,996 30% Debt Service - - - - - - 0% Capital 5,676,123 11,410 407,817 2,261,326 891,364 4,376,942 23% Transfers Out - - - - - - 0% Total Expenditures 6,487,957 11,920 565,833 2,694,763 973,186 4,948,938 24% Net (3,972,957) (9,549) 712,920 (1,298,242) (973,186) (3,712,691) Cash Balance 4,152,569 4,096,535 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from one year to the next so expenditure comparison will not yield reliable trend review. Major Projects for 2013 were: completion of the Fellows Street Corridor project; additional work on the Ireland Street project; and the final acquisition and engineering along with construction of the Main /Lafayette Crossover project. Projects committed thus far in 2014 are: completion of the Fellows Street Corridor Project; Ireland & Miami Area Improvements; Main /Lafayette Crossover Project and Walter Street Sidewalks. Explain Significant Spending on Capital Projects Below: Form 3 107 Form 3 `[IN 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Month September Fund /Department Number 435 1 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 320,000 - 160,947 164,168 - 159,053 50% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 750 56 646 377 - 104 86% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 320,750 56 161,593 164,545 - 159,157 50% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,360 - 160 257 4,200 - 100% Debt Service 395,463 - 395,461 190,461 - 2 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 399,823 - 395,621 190,718 4,200 2 100% Net (79,073) 56 (234,028) (26,173) (4,200) 159,155 Cash Balance 60,572 134,752 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Douglas Road TIF was established to develop the road and area near Brown Mackie College near the South Bend - Mishawaka border. The fund borrowed money from the City of Mishawaka ($1,086,550) and Major Moves Fund 412 ($1,000,000) to finance initial construction. The fund uses TIF tax revenue to repay the loans. At July 31, 2014, the amounts due Mishawaka and Major moves were $47,003 and $847,644, respectively. Explain Significant Spending on Capital Projects Below: Projects for 2014 include: the Douglas Road Turn Lane. Form 3 `[IN Form 3 ` OR] 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Residential Month September Fund /Department Number 436 Date Updated 9/10/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,392,000 - 1,382,498 1,340,028 - 1,009,502 58% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 345 3,106 7,421 - (1,106) 155% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,394,000 345 1,385,604 1,347,449 - 1,008,396 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 6,346 - - 1,370 - 6,346 0% Debt Service 3,362,308 246,589 3,362,307 3,021,162 - 1 100% Capital 214,574 - 214,573 - - 1 100% Transfers Out - - - - - - 0% Total Expenditures 3,583,228 246,589 3,576,880 3,022,532 - 6,348 100% Net (1,189,228) (246,244) (2,191,276) (1,675,083) - 1,002,048 Cash Balance 362,803 1,826,228 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Major projects for 2014 include a City contribution to the 2nd Eddy Street Commons Ammendment. The $214,573 Capital Expenditure was to Kite Realty Eddy St. Garage LLC and the budget was adjusted on 6 Mar 2014 to cover it. Explain Significant Spending on Capital Projects Below: Form 3 ` OR] Form 3 N101 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Month September Fund /Department Number 433 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 6 44 88 - (44) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 6 44 88 - (44) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 20,000 - 15,703 4,126 - 4,297 79% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 20,000 - 15,703 4,126 - 4,297 79% Net (20,000) 6 (15,659) (4,038) - (4,341) Cash Balance 10,089 27,406 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund's sole expenditure is for general legal fees for DCI based on an engagement letter Explain Significant Spending on Capital Projects Below: Form 3 N101 Form 3 ME 2014 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Month September Fund /Department Number 439 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 1,450,000 - - 1,446,074 - 1,450,000 0% Charges for Services - - - - - - 0% Interest Earnings 12,000 2,088 10,208 5,707 - 1,792 85% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,462,000 2,088 10,208 1,451,781 - 1,451,792 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 3,600,000 - - - - 3,600,000 0% Transfers Out - - - - - - 0% Total Expenditures 3,600,000 - - - - 3,600,000 0% Net (2,138,000) 2,088 10,208 1,451,781 - (2,148,208) Cash Balance 3,692,804 2,268,143 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The 1.45M in Revenue represents the final draw from the State. Capital funds are to be expended in Ignition Park and Innovation Park. Explain Significant Spending on Capital Projects Below: Form 3 ME Form 3 112 2014 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Month September Fund /Department Number 454 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,500 213 1,043 1,073 - 457 70% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 213 1,043 1,073 - 457 70% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 213 1,043 1,073 - 457 Cash Balance 377,415 376,155 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: No significant issues. Explain Significant Spending on Capital Projects Below: Form 3 112 Form 3 113 2014 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations Month September Fund /Department Number 619 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,696,879 174,866 1,439,649 1,407,134 - 257,230 85% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - 50,500 - - 0% Total Revenue 1,696,879 174,866 1,439,649 1,457,634 - 257,230 85% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,661,128 167,715 1,238,304 1,272,975 - 422,824 75% Debt Service - - - 207,879 - - 0% Capital 10,578 1,763 10,579 8,816 - (1) 100% Transfers Out - - - - - - 0% Total Expenditures 1,671,706 169,478 1,248,883 1,489,670 - 422,823 75% Net 25,173 5,388 190,766 (32,036) - (165,593) Cash Balance 276,234 225,208 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Bond was Paid off in early 2013, so debt service expense in 2014 will be much under 2013. Course operations under outside contract with Billy Casper Golf so all expenses except capital are shown under Services to show consistently with Parking Garages and Redevelopment Retail. Explain Significant Spending on Capital Projects Below: Equipment payments Form 3 113 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Month September Fund /Department Number 315 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 588 2,877 2,968 - 2,123 58% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 588 2,877 2,968 - 2,123 58% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 588 2,877 2,968 - 2,123 58% Total Expenditures 5,000 588 2,877 2,968 - 2,123 58% Net - - - - - - Cash Balance 1,038,904 1,038,904 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Explain Significant Spending on Capital Projects Below: Form 3 114 2014 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Month September Fund /Department Number 317 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,800 286 1,396 1,435 - 404 78% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,800 286 1,396 1,435 - 404 78% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,800 286 1,396 1,435 - 404 Cash Balance 504,868 503,183 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Debt service reserve fund. The fund is at the proper level per the bond financial advisor, Crowe Horwath. No additional transfers -in are needed. Any interest variations due to City policy on investments and increase in cash available to earn interest. Explain Significant Spending on Capital Projects Below: Form 3 r&7 2014 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Month September Fund /Department Number 328 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 982 4,807 4,960 - 1,193 80% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 982 4,807 4,960 - 1,193 80% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 982 4,807 4,960 - 1,193 80% Total Expenditures 6,000 982 4,807 4,960 - 1,193 80% Net - - - - - - Cash Balance 1,735,840 1,735,840 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 420). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Explain Significant Spending on Capital Projects Below: Form 3 Mr.] Form 3 117 2014 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Month September Fund /Department Number 432 Date Updated 10/9/2014 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - 9,175 659,735 - (9,175) 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 3,360 16,736 15,529 - (1,736) 112% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,000 3,360 25,911 675,264 - (10,911) 173% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 656 - 656 1,157 - - 100% Debt Service 493,495 - 491,495 488,848 - 2,000 100% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 494,151 - 492,151 490,005 - 2,000 100% Net (479,151) 3,360 (466,240) 185,259 - (12,911) Cash Balance 6,502,446 6,313,979 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to payoff debt. We will not be requesting additional funds from the TIF. The first opportunity to pay off the bond will be February, 2017. The plan is to payoff the bond at that time along with the prepayment penalty. In June we received $9,175 in the tax distribution we were not expecting to receive. This amount represents collection of delinquent taxes from previous years. Explain Significant Spending on Capital Projects Below: Form 3 117