The URL can be used to link to this page

Home My WebLink About10-2013 Departmental Financial ReportPeriod Ending: Issued By: October 31, 2013 Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents 2 - 2 Narrative 3 - 7 Summaries 8-29 General Fund 30-61 Special Revenue Funds 62-74 Debt Service /Capital Project Funds 75-102 Enterprise Funds 103-107 Internal Service Funds 108-110 Trust Funds 111 -130 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff Kathryn Roos South Bend Common Council Controller Mark Neal Deputy City Controller John Murphy City Finance Director Rahman Johnson Financial Specialist Senior Cecil Eastman Department Heads Fiscal Officers Narrative, October 2013 Description of Monthly Departmental Financial Report Beginning with the March 2013 fiscal period, the City of South Bend has developed the attached Monthly Departmental Financial Report. The purpose of the report is to provide current year financial information for each City fund and individual departments within the General Fund in a condensed format. Information is provided for revenue, expenditures, encumbrances, cash balances and staffing levels. Also included in this report are text boxes that allow departmental fiscal officers to provide an explanation of significant expenditure and staffing variances and spending on major capital projects. Departmental fiscal officers are asked to complete the monthly financial reports ( "blue sheets ") for their funds and General Fund departments no later than the 20th of the month following the reporting period. The staff of the Department of Administration & Finance is then asked to summarize the information and publish this consolidated report no later than 30 days after the end of the reporting period. The Monthly Departmental Financial Report supplements (but does not replace) other financial reports that the City prepares including the Monthly Financial Report, Controller's Cash Report, Gateway City and Town Annual Report (CTAR), and Comprehensive Annual Financial Report (CAFR). Summary Trends & Observations One of the purposes of this report is to focus the reader's attention on current year revenue and expenditure trends in individual funds and General Fund departments. Please refer to the attached pages for this information. As of-October 31, 2013, total revenue was $205,678,247, 68% of estimated revenue. As of October 31, 2012 total revenue received was $215,103,712. Property taxes received in June were less than anticipated and October's non - property tax receipts of nearly $12.0 million were less than the expected monthly average. Individual elements of revenue are received at various times of the year (based on State and other distribution schedules) and it is the job of all City fiscal staff to monitor revenue for timely collection. As of October 31, 2013, total expenditures were $224,567,705 and outstanding encumbrances were $36,196,297, a total of $260,764,002 which represents 71% of the amended expenditure budget, less than the expected level of 83% after ten months' activity. If encumbrances were excluded, expenditures were 61% of the amended expenditure budget at the end of the period. Encumbrances represent placeholders for future expenditures anticipated through the rest of the fiscal year but have not yet been incurred. By comparison, total expenditures were $231,590,532 as of October 31, 2012. In October the City spent over $2.9 million for capital projects, most notably $818,000 for sewer rehabilitation projects and $418,000 for the Main - Lafayette connector. We hope that you find this Monthly Departmental Financial Report useful in understanding the finances of the City of South Bend a little bit better. If you have any questions regarding this report, please contact us at 574 - 235 -7702. City of South Bend Monthly Department Financial Report REVENUE SUMMARY October 31, 2013 Fund MR Control Type Dept Name City Funds General Fund 63,932,287 3,037,986 41,090,526 42,171,693 22,841,761 64% Special Revenue 102 Rainy Day 52,000 1,764 26,328 37,620 25,672 51% 201 Parks & Recreation 12,362,329 258,222 7,935,495 8,273,777 4,426,834 64% 202 Motor Vehicle Highway 8,691,971 425,233 8,106,394 6,577,536 585,577 93% 203 Recreation Nonreverting 1,636,943 40,764 913,171 964,191 723,772 56% 209 Studebaker - Oliver Reverting Grants 5,000 222 3,310 4,905 1,690 66% 210 Economic Development State Grants 1,624,187 205 219,809 219,966 1,404,378 14% 211 Community & Economic Development Admn. 2,341,808 16,446 1,708,670 2,076,421 633,138 73% 212 Community & Economic Development 8,800,305 264,199 3,856,761 3,793,348 4,943,544 44% 216 Police State Seizures 35,900 605 19,681 23,549 16,219 55% 217 Gift, Donation, Bequest 17,011 15 11,474 18,128 5,537 67% 218 Police Curfew Violations 1,025 87 519 360 506 51% 220 Law Enforcement Continuing Education 347,000 22,480 172,859 251,239 174,141 50% 227 Loss Recovery 3,829,857 1,651 3,820,570 19,552 9,287 100% 249 Public Safety LOIT 5,900,386 510,948 5,496,795 5,778,816 403,591 93% 251 Local Roads & Streets 1,061,143 91,177 828,849 851,845 232,294 78% 252 Excess Welfare Distribution 0 0 4 5,406 -4 0% 258 Human Rights Federal Grant 237,250 -7,764 175,462 162,186 61,788 74% 271 Eastrace Waterway 100 4 41 87 59 41% 273 Morris PAC / Palais Royale Marketing 8,100 860 5,732 1,952 2,368 71% 280 Police Block Grants 185,300 1 12 679 185,288 0% 281 Economic Develop. Commission - Revenue Bonds 100 6 83 119 17 83% 289 HAZMAT 3,000 3 16,756 11 - 13,756 559% 291 Indiana River Rescue 31,500 1,521 66,031 64,845 - 34,531 210% 292 Police Grants 110,000 0 38,532 97,000 71,468 35% 294 Regional Police Academy 28,500 15 20,288 13,781 8,212 71% 295 COPS MORE Grant 41,600 1,101 9,720 27,158 31,880 23% 299 Police Federal Drug Enforcement 102,000 13,302 172,555 80,671 - 70,555 169% 404 County Option Income Tax 8,732,872 748,269 7,065,897 8,053,173 1,666,975 81% 408 Economic Development Income Tax 8,732,012 683,317 7,268,533 8,131,183 1,463,479 83% 410 Urban Development Action Grant 70,104 131 3,699 5,822 66,405 5% 655 Project Releaf 431,700 36,516 363,144 360,900 68,556 84% 705 Police K -9 Unit 2,000 0 7 10 1,993 0% Special Revenue Total 65,423,003 3,111,302 48,327,181 45,896,236 17,095,822 74% City Debt Service 313 Football Hall of Fame Debt Service 1,257,789 5,956 787,041 745,546 470,748 63% City Debt Service Total 1,257,789 5,956 787,041 745,546 470,748 63% Capital Project 288 Emergency Medical Services Capital Improv. 2,987,084 328,619 2,561,613 2,005,728 425,471 86% 377 Professional Sports Development 687,801 83,807 526,823 1,141,935 160,978 77% 401 Coveleski Stadium Capital 500 6 82 310 418 16% 403 Zoo Endowment 2,900 10 150 13,185 2,750 5% 405 Park Nonreverting Capital 203,500 114 18,715 17,786 184,785 9% 406 Cumulative Capital Development 614,325 3,994 314,514 344,517 299,811 51% 407 Cumulative Capital Improvement 434,090 4 304,217 307,331 129,873 70% 412 Major Moves Construction 528,662 1,461 302,344 122,942 226,318 57% 416 Morris Performing Arts Center Capital 101,500 3,509 69,420 65,306 32,080 68% 434 Community Revitalization Enhancement District 651,000 -36 418 1,035 650,582 0% 450 Palais Royale Historic Preservation 16,125 1,687 13,279 11,198 2,846 82% 677 Football Hall of Fame Capital 4,500 139 2,210 118,804 2,290 49% Capital Project Total 6,231,987 423,313 4,113,785 4,150,076 2,118,202 66% Enterprise 600 Consolidated Building Department 1,148,035 92,457 816,429 828,837 331,606 71% 601 Parking Garages 1,058,939 81,038 828,742 805,451 230,197 78% 610 Solid Waste Operations 5,257,701 478,231 4,531,149 4,039,655 726,552 86% 611 Solid Waste Capital 784,261 43 830,637 259,454 - 46,376 106% 620 Water Works Operations 14,687,748 1,734,219 12,916,592 13,415,160 1,771,156 88% City of South Bend Monthly Department Financial Report REVENUE SUMMARY October 31, 2013 City Fu Enterp 622 Water Works Capital 14,000 754 12,379 1,301,565 1,621 88% 623 Water Works Bond Capital 18,000 746 15,490 8,374,019 2,510 86% 624 Water Works Customer Deposit 6,100 297 4,323 6,107 1,777 71% 625 Water Works Sinking 2,108,381 171,183 1,711,079 1,366,207 397,302 81% 626 Water Works Bond Reserve 313,509 17,766 218,503 833,826 95,006 70% 629 Water Works Reserve Operations & Maintenance 52,801 416 51,474 130,087 1,327 97% 640 Sewer Repair Insurance 549,200 45,708 460,193 457,804 89,007 84% 641 Sewage Works Operations 33,131,547 2,764,814 26,494,611 26,258,103 6,636,936 80% 642 Sewage Works Capital 4,560,000 1,290 192,463 4,490,734 4,367,537 4% 643 Sewage Works Reserve Operations & Maint. 127,098 675 210,110 13,793 - 83,012 165% 645 Sewer Bond 2004/2006 0 0 0 0 0 0% 647 Sewer Bond 2007 0 1 40 191 -40 0% 649 Sewage Sinking 8,234,756 775,544 7,912,155 6,866,278 322,601 96% 650 Clay Sewage 0 0 2 3 -2 0% 651 Sewage Bond 2007B 0 0 68 554 -68 0% 653 Sewage Debt Service Reserve 1,805,314 0 14,096 377,505 1,791,218 1% 658 Sewer Bond 2010 0 1 214 4,248 -214 0% 659 Sewer Bond 2011 60,000 1,737 27,881 84,432 32,119 46% 661 Sewer Bond 2012 60,000 4,257 57,789 0 2,211 96% 663 Sewer Bond 2013 21,200,000 0 0 0 21,200,000 0% 664 2013A Cost of Issuance Fund 85,741 1 85,745 0 -4 100% 670 Century Center 3,766,205 356,946 2,733,821 2,379,465 1,032,384 73% 671 Century Center Capital 675,500 33 675,252 1,444,380 248 100% Enterprise Total 99,704,836 6,528,158 60,801,238 73,737,857 38,903,598 61% Internal Service 222 Central Services 7,922,703 651,023 6,142,799 5,714,984 1,779,904 78% 226 Liability Insurance 3,033,076 250,130 2,507,228 2,476,178 525,848 83% 278 Take Home Vehicle Police 129,400 9,626 105,585 108,761 23,815 82% 711 Self- Funded Employee Benefits 12,188,900 983,500 10,192,082 9,270,357 1,996,818 84% 713 Unemployment Compensation 341,450 16,041 220,824 229,196 120,626 65% Internal Service Total 23,615,529 1,910,319 19,168,518 17,799,476 4,447,011 81% Trust & Agency 701 Firefighters Pension 5,040,279 135 5,037,490 5,238,522 2,789 100% 702 Police Pension 5,873,697 4,915 5,873,790 6,748,925 -93 100% 730 City Cemetery 250 8 124 180 126 50% Trust & Agency Total 10,914,226 5,057 10,911,404 11,987,628 2,822 100% City Funds Total 271,079,657 15,022,091 185,199,693 196,488,512 85,879,964 68% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF Revenue - Airport 13,940,252 26,747 9,854,352 7,035,200 4,085,900 71% 420 Tax Incremental Financing (TIF) - Downtown 4,663,254 253,613 2,565,647 3,661,745 2,097,607 55% 422 TIF - West Washington 444,000 86 265,978 228,811 178,022 60% 425 Redevelopment Retail & Leighton Plaza 156,905 10,903 132,855 103,024 24,050 85% 426 TIF - Central Medical Service Area 1,730,000 728 624,292 891,493 1,105,708 36% 429 TIF - Northeast Development 823,000 538 439,070 697,793 383,930 53% 430 TIF - Southside Development #1 1,840,000 923 1,397,444 2,760,441 442,556 76% 431 TIF - Southside Development #2 0 0 0 2,329 0 0% 432 TIF - Southside Development #3 1,346,000 1,178 676,442 24,807 669,558 50% 435 TIF - Douglas Road 321,000 28 164,572 265,508 156,428 51% 436 TIF - Northeast Residential 2,460,000 374 1,347,823 1,261,017 1,112,177 55% Tax Increment Financing Total 27,724,411 295,118 17,468,475 16,932,168 10,255,936 63% Redevelopment 433 Redevelopment General 150 6 94 147 56 63% 439 Certified Technology Park 1,448,074 465 1,452,246 3,132 -4,172 100% 454 Airport Urban Enterprise Zone 1,000 77 1,150 38,402 -150 115% 619 Blackthorn Golf Course Operations 1,747,379 88,457 1,546,091 1,619,561 201,288 88% Redevelopment Total 3,196,603 89,005 2,999,581 1,661,242 197,022 94% City of South Bend Monthly Department Financial Report REVENUE SUMMARY October 31, 2013 Redevelopment Commission Controlled Funds Debt Service 314 Redevelopment Bond - Central Development 315 Redevelopment Bond - Airport Taxable 317 Coveleski Debt Service Reserve 319 Redevelopment Bond - Blackthorn Golf 328 Redevelopment Bond - Palais Royale Debt Service Total Redevelopment Commission Controlled Funds Total 0 0 0 3,009 0 0% 5,000 213 3,181 5,012 1,819 64% 3,500 103 1,538 2,200 1,962 44% 50 0 464 4,245 -414 928% 6,000 356 5,315 7,324 685 89% 14,550 672 10,498 21,790 4,052 72% 30,935,564 384,795 20,478,554 18,615,200 10,457,010 66% Grand Total 302,015,221 15,406,886 205,678,247 215,103,712 96,336,974 68% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY October 31, 2013 Control Type Department City Funds General Fund 101 -0101 Mayor's Office 694,229 43,975 520,126 532,622 2,677 171,426 75% 101 -0104 311 Call Center 320,102 33,698 218,637 0 1,165 100,300 69% 101 -0201 City Clerk 365,170 33,715 273,378 258,676 12,712 79,080 78% 101 -0301 Common Council 515,397 21,523 296,507 302,271 0 218,890 58% 101 -0401 Administration & Finance 1,877,728 137,802 1,512,957 1,300,238 32,193 332,578 82% 101 -0404 Morris Performing Arts Center 1,033,800 68,373 782,671 766,854 47,970 203,159 80% 101 -0405 Palais Royale 492,830 45,178 337,565 278,731 43,151 112,114 77% 101 -0501 Legal Department 1,028,466 80,899 733,266 657,373 1,254 293,946 71 101 -0600 Energy Office 54,256 0 54,256 472,239 0 0 100% 101 -0602 Engineering 1,393,561 99,154 1,065,256 1,383,079 100,749 227,556 84% 101 -0607 Traffic & Lighting 111,815 0 109,536 571,239 0 2,279 98% 101 -0801 Police Department 23,795,376 1,759,291 18,576,387 20,463,943 408,796 4,810,193 80% 101 -0802 Communications Center 2,326,560 184,697 1,728,051 1,656,109 570 597,939 74% 101 -0805 Public Safety LOIT - Police 3,968,567 299,933 3,275,090 2,614,021 0 693,477 83 101 -0901 Fire Department 20,607,695 1,548,765 16,625,447 17,244,854 125,421 3,856,830 81 101 -0905 Public Safety LOIT - Fire 3,133,190 243,763 2,878,753 1,991,075 0 254,437 92 101 -1008 Human Rights 346,237 38,295 268,461 219,893 4,840 72,936 79% 101 -1201 Code Enforcement 2,270,969 215,694 1,710,265 1,317,750 164,559 396,145 83% 101 -1203 Code Hearing Officer 40,000 4,600 33,078 31,665 7,200 -278 101 101 -1204 Junk Vehicle 65,829 528 30,439 52,700 1,495 33,894 49% 101 -1205 Unsafe Building 53,684 1,815 20,762 63,869 24,870 8,052 85% 101 -1207 Animal Control 596,111 41,580 473,472 443,551 4,354 118,285 80% General Fund Total 65,091,572 4,903,279 51,524,362 52,622,753 983,978 12,583,236 81 Special Revenue 102 Rainy Day 0 0 0 0 0 0 0 201 Parks & Recreation 12,927,463 906,909 10,395,758 10,212,726 296,028 2,235,677 83 202 Motor Vehicle Highway 9,176,496 781,070 5,985,061 5,726,982 663,557 2,527,877 72 203 Recreation Nonreverting 1,560,777 71,217 783,172 888,264 74,495 703,110 55% 209 Studebaker - Oliver Reverting Grants 1,000,000 0 0 162,602 0 1,000,000 0% 210 Economic Development State Grants 1,260,777 11,478 455,900 189,062 0 804,877 36% 211 Community& Economic Development Admn. 2,354,331 172,300 1,812,330 1,709,071 21,869 520,132 78% 212 Community & Economic Development 8,957,256 412,436 3,784,740 3,490,767 3,400,960 1,771,556 80 216 Police State Seizures 45,900 0 11,450 8,480 0 34,450 25% 217 Gift, Donation, Bequest 10,752 0 0 3,164 1,310 9,442 12 218 Police Curfew Violations 1,000 0 0 0 0 1,000 0% 220 Law Enforcement Continuing Education 478,131 909 282,636 218,995 20,383 175,112 63% 227 Loss Recovery 526,185 20,357 120,518 162,397 83,836 321,831 39% 249 Public Safety LOIT 7,101,757 2,060,536 7,405,038 5,358,400 0 - 303,281 104% 251 Local Roads & Streets 1,235,924 113 778,712 458,909 153,879 303,333 75% 252 Excess Welfare Distribution 0 0 0 2,276,693 0 0 0% 258 Human Rights Federal Grant 228,930 22,887 160,045 141,388 4,819 64,066 72 271 Eastrace Waterway 346 0 0 8,009 346 0 100% 273 Morris PAC / Palais Royale Marketing 10,149 886 7,137 0 754 2,258 78 280 Police Block Grants 185,000 0 0 124,539 0 185,000 0 281 Economic Develop. Commission- Revenue Bonds 27,102 0 0 0 0 27,102 0% 289 HAZMAT 3,500 0 3,237 0 1,990 263 149% 291 Indiana River Rescue 92,126 5,170 86,698 14,770 2,182 3,246 96% 292 Police Grants 110,000 0 36,911 0 19,450 53,639 51 294 Regional Police Academy 28,500 6,591 25,802 12,969 0 2,698 91 295 COPS MORE Grant 41,980 988 12,481 36,332 360 29,139 31 299 Police Federal Drug Enforcement 188,573 1,113 118,745 79,779 10,404 59,424 68% 404 County Option Income Tax 9,443,417 445,795 7,519,738 7,619,454 237,185 1,686,494 82 408 Economic Development Income Tax 8,993,379 150,185 7,124,085 7,734,407 397,197 1,472,097 84% 410 Urban Development Action Grant 268,146 0 0 200,451 0 268,146 0% 655 Project Releaf 432,065 4,757 301,795 278,144 6,946 123,324 71 705 Police K -9 Unit 2,000 0 0 356 0 2,000 0 Special Revenue Total 66,691,962 5,075,696 47,211,989 47,117,110 5,397,951 14,084,011 79 City Debt Service 313 Football Hall of Fame Debt Service 1,268,000 0 1,268,000 1,330,465 0 0 100% City Debt Service Total 1,268,000 0 1,268,000 1,330,465 0 0 100 Capital Project 288 Emergency Medical Services Capital Improv. 11,078,163 296,545 5,009,524 1,732,046 4,631,252 2,627,983 87% 377 Professional Sports Development 876,671 0 876,470 1,284,035 0 201 100% 401 Coveleski Stadium Capital 3,540 0 0 56,162 3,540 0 100% 403 Zoo Endowment 0 0 0 0 0 0 0 405 Park Nonreverting Capital 217,316 31,835 123,141 172,493 24,287 69,888 68% 406 Cumulative Capital Development 911,220 42 409,763 293,511 0 501,457 45% 407 Cumulative Capital Improvement 367,575 0 367,575 402,277 0 0 100 412 Major Moves Construction 3,395,846 63,704 1,134,683 584,601 1,162,080 1,099,082 68% 416 Morris Performing Arts Center Capital 72,666 0 38,184 164,611 17,605 16,877 77 434 Community Revitalization Enhancement District 873,949 0 873,949 878,554 0 0 100 450 Palais Royale Historic Preservation 0 0 0 0 0 0 0 677 Football Hall of Fame Capital 179,322 3,146 52,348 273,059 0 126,974 29% Capital Project Total 17,976,268 395,271 8,885,636 5,841,349 5,838,765 4,442,463 82 Enterprise 600 Consolidated Building Department 1,148,152 76,475 834,359 744,518 24,710 289,083 75% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY October 31, 2013 Control Type Department Name Budget Actual Actual Actual Encumbrances Balance Budget City Funds Enterprise 601 Parking Garages 1,129,839 93,964 725,127 921,813 247,208 157,504 86% 610 Solid Waste Operations 5,647,984 377,426 4,872,391 4,298,412 296,234 479,359 92 611 Solid Waste Capital 964,061 0 631,998 229,737 24,702 307,361 68% 620 Water Works Operations 14,795,947 1,139,290 11,129,138 11,082,079 349,150 3,317,659 78% 622 Water Works Capital 1,216,792 67,500 546,690 999,070 107,194 562,908 54% 623 Water Works Bond Capital 5,566,203 686,979 2,879,773 2,369,390 2,371,429 315,001 94% 624 Water Works Customer Deposit 4,000 297 4,363 6,107 0 -363 109% 625 Water Works Sinking 2,108,381 230 411,549 354,529 0 1,696,832 20% 626 Water Works Bond Reserve 0 0 0 0 0 0 0% 629 Water Works Reserve Operations & Maintenance 7,500 416 6,173 8,661 0 1,327 82 640 Sewer Repair Insurance 555,844 26,666 291,329 226,979 11,403 253,111 54% 641 Sewage Works Operations 35,318,740 2,529,776 23,927,334 24,633,244 1,685,219 9,706,188 73% 642 Sewage Works Capital 11,499,571 871,539 3,705,214 4,506,229 5,693,258 2,101,100 82% 643 Sewage Works Reserve Operations & Maint. 18,000 675 9,814 73,296 0 8,186 55% 645 Sewer Bond 2004/2006 0 12 12 0 0 -12 0 647 Sewer Bond 2007 19,017 63 13,679 44,986 5,401 -63 100 649 Sewage Sinking 9,804,044 400 2,663,715 1,783,938 0 7,140,329 27% 650 Clay Sewage 0 0 698 0 0 -698 0 651 Sewage Bond 2007B 39,512 2 35,985 189,122 3,639 -112 100% 653 Sewage Debt Service Reserve 2,438,088 0 2,438,087 0 0 1 100 658 Sewer Bond 2010 112,089 7 108,736 1,874,528 3,681 -327 100% 659 Sewer Bond 2011 10,696,720 58,282 1,797,170 7,374,525 6,036,027 2,863,523 73% 661 Sewer Bond 2012 19,160,000 280,441 3,578,044 0 2,303,403 13,278,553 31 663 Sewer Bond 2013 2,100,000 0 0 0 0 2,100,000 0% 664 2013A Cost of Issuance Fund 81,065 0 81,064 0 0 1 100 670 Century Center 3,547,459 508,130 2,711,407 3,323,210 0 836,053 76% 671 Century Center Capital 246,770 30,637 30,637 169,545 0 216,133 12 Enterprise Total 128,225,778 6,749,208 63,434,487 65,213,920 19,162,656 45,628,635 64% Internal Service 222 Central Services 7,979,429 624,656 6,086,532 5,623,434 878,135 1,014,762 87% 226 Liability Insurance 2,915,927 116,768 2,186,956 1,838,489 1,987 726,984 75% 278 Take Home Vehicle Police 103,700 0 63,700 75,642 0 40,000 61 711 Self- Funded Employee Benefits 13,348,829 1,652,769 11,326,708 10,393,865 1,887 2,020,234 85% 713 Unemployment Compensation 267,247 1,958 49,721 178,912 0 217,526 19% Internal Service Total 24,615,132 2,396,151 19,713,618 18,110,341 882,009 4,019,506 84 Trust & Agency 701 Firefighters Pension 5,900,028 443,600 4,540,476 4,710,044 0 1,359,552 77% 702 Police Pension 6,929,133 530,727 5,402,131 5,505,158 0 1,527,002 78% 730 City Cemetery 15,000 0 4,316 0 11,895 -1,211 108% Trust &Agency Total 12,844,161 974,327 9,946,923 10,215,202 11,895 2,885,343 78% City Funds Total 316,712,873 20,493,932 201,985,015 200,451,'x` 32,277,254 83,643,193 74% Redevelopment Commission Controlled Funds Tax Increment Financing 324 TIF Revenue - Airport 25,244,592 352,477 8,337,900 14,702,028 778,938 16,127,754 36 420 Tax Incremental Financing (TIF) - Downtown 5,302,102 361,709 3,436,127 6,369,351 396,015 1,469,960 72 422 TIF - West Washington 668,815 6,258 306,219 802,594 36,152 326,444 51 425 Redevelopment Retail & Leighton Plaza 151,185 8,691 91,470 96,540 0 59,715 61 426 TIF- Central Medical Service Area 4,770,544 380,064 1,379,875 1,190,636 880,664 2,510,005 47% 429 TIF - Northeast Development 2,388,995 19,795 53,696 28,203 5,500 2,329,799 2 430 TIF - Southside Development #1 6,122,885 454,940 3,149,703 2,085,935 1,814,613 1,158,569 81% 431 TIF - Southside Development #2 0 0 0 1,401,397 0 0 0 432 TIF - Southside Development #3 501,268 0 490,005 149,809 0 11,263 98 435 TIF - Douglas Road 454,782 0 190,718 316,983 4,500 259,564 43 436 TIF - Northeast Residential 3,229,957 195,888 3,218,420 309,587 0 11,537 100 Tax Increment Financing Total 48,835,125 1,779,822 20,654,133 27,453,063 3,916,382 24,264,610 50 Redevelopment 433 Redevelopment General 6,787 1,673 5,798 3,033 2,661 -1,672 125% 439 Certified Technology Park 0 0 0 0 0 0 0 454 Airport Urban Enterprise Zone 0 0 0 0 0 0 0 619 Blackthorn Golf Course Operations 1,997,706 98,129 1,587,799 2,187,206 0 409,907 79% Redevelopment Total 2,004,493 99,802 1,593,597 2,190,239 2,661 408,235 80% Debt Service 314 Redevelopment Bond - Central Development 0 0 0 825,509 0 0 0 315 Redevelopment Bond - Airport Taxable 5,000 213 3,181 5,012 0 1,819 64% 317 Coveleski Debt Service Reserve 0 0 0 0 0 0 0 319 Redevelopment Bond - Blackthorn Golf 326,050 0 326,464 658,245 0 -414 100 328 Redevelopment Bond - Palais Royale 6,000 356 5,315 7,324 0 685 89 Debt Service Total 337,050 569 334,960 1,496,090 0 2,090 99% Redevelopment Commission Controlled Funds Total 51,176,668 1,880,193 22,582,690 31,139,392 3,919,043 24,674,935 Grand Total 367,889,541 22,374,125 224,567,705 231,590,532 36,196,297 108,318,128 71 2013 City of South Bend Monthly Financial Report Fund /Department Name I Mayor's Office IMonth I October Fund /Department Number 1 101 -0101 1 Date Updated 1 11/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 689,612 43,624 518,096 524,135 171,516 75% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 200 325 (325) 0% Interest Earnings - - - 0% Bond Proceeds - - - - - 0% Donations 4,017 151 1,665 1,666 2,352 41% Other Income 600 - 40 6,821 560 7% Transfers In - - - - - 0% Total Revenue 694,229 43,975 520,126 532,622 174,103 75% Expenditures Personnel 588,684 38,603 432,717 461,562 - 155,967 74% Supplies 35,167 3,027 35,467 22,073 119 (419) 101% Services 68,728 1,796 49,743 48,988 2,559 16,426 76% Debt Service 1,650 550 2,199 - - (549) 133% Capital - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 694,229 43,975 520,126 532,622 2,677 171,426 75% Net - - - (2,677)1 2,677 Cash Balance Stathng Full Time 7.00 6.00 6.00 Part-Time /Season al/Tem porary - - - Total 7.00 6.00 6.00 rxpiam aignmcam Kevenue, cxpenonure ano acarnng %,nangesivanances aeiow: Personnel costs below budget as position of Communications Director was filled in April, 2013. Promotional expenditures in the first quarter included items encumbered at December 31, 2013. The allocation to the print shop was increased for 2013. Salaries in 2012 were higher than 2013 because 2012 salaries included compensatory time payouts to former Mayor's office employees. Chief of Staff Mike Schmuhl resigned in June, 2013 and Kathryn Roos became the new Chief of Staff. The Deputy Chief of Staff position is currently unfilled but has been advertised. Explain Significant Spending on Capital Projects Below: None Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center Fund /Department Number 101 -0104 Month I October Date Updated 1 11/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 320,102 33,698 218,637 101,465 68% Interest Earnings - - - - 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 320,102 33,698 218,637 101,465 68% Expenditures Personnel 269,102 31,670 209,424 - 59,678 78% Supplies 12,500 2,028 5,857 765 5,878 53% Services 38,500 - 3,356 400 34,744 10% Debt Service - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 320,102 33,698 218,637 1,165T 100,300 69% Net - - - (1,165)1 1,165 Cash Balance Staffing Full Time 4.50 5.00 5.00 Part-Time /Season al/Tem porary - - - Total 4.50 5.00 5.00 r xpiam aignmcam mevenue, cxpenonure ano atarnng ,- nangesivanances rseiow: New department for 2013. Supplies account includes start up supply costs. Advertising and promotional costs below budget. Posted an AJ in September for January through September costs. Will post an AJ every month thereafter to recover costs from user departments. Department is to breakeven each month, with amounts charged equal to expenditures. Certain accounting and administrative oversight is provided by Administration & Finance and this is being switched to the Mayor's office. gnincam apenaing on t apnai rrojects neiow: costs expended to date. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Fund /Department Number 101 -0201 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 365,170 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 91,792 75% - Property Taxes /Non -Dept Revenue 365,170 33,715 273,378 Local Income Taxes - - - Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% 258,676 91,792 Donations 215,862 - 53,304 81% Other Income 8,921 58% 32,423 9,782 Transfers In - - - Total Revenue 365,170 33,715 273,378 Expenditures - 0% 258,676 12,712T--- 2,712 Personnel 280,655 20,925 227,351 Supplies 21,488 6,934 9,637 Services 60,337 3,907 34,441 Debt Service 2,599 1,948 1,948 Capital 91 - - Transfers Out - - - Total Expenditures 365,170 33,715 273,378 Net - - - Cash Balance Staffing Full Time 5.00 5.00 5.00 Part-Time /Season al/Tem porary - - - Total 5.00 5.00 5.00 r xpiam aigmricam rtevenue, r- xpenanure ano starring ,- nangesivanances rseiow: No significant changes at this time. nincam apenaing on t apnai rrojects neiow: nt changes at this time. 258,676 91,792 75% - - 0% 0% 0% 0% 0% 0% 0% 0% 0% 258,676 91,792 75% 215,862 - 53,304 81% 3,646 2,930 8,921 58% 32,423 9,782 16,114 73% - - 651 75% 6,644 91 0% 100 - 0% 258,676 12,712T--- 2,712 79,080 78% 112.7121 12.712 Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Common Council IMonth I October Fund /Department Number 101 -0301 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 507,097 21,496 289,455 295,005 217,642 57% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 8,300 27 7,052 7,266 1,248 85% Other Income - - - - - 0% Transfers In - - - - - 0% Total Revenue 515,397 21,523 296,507 302,271 218,890 58% Expenditures Personnel 289,758 14,352 161,118 146,493 128,640 56% Supplies 11,512 376 12,991 4,897 (1,479) 113% Services 183,838 6,795 122,399 142,452 61,439 67% Debt Service - - - - - 0% Capital 30,289 5,559 30,289 0% Transfers Out - - - 2,870 - 0% Total Expenditures 515,397 21,523 296,507 302,271 218,890 58% Net - - - - Cash Balance Staffing Full Time 9.00 9.00 9.00 Part-Time /Season al/Tem porary - - - Total 9.00 9.00 9.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: There are nine (9) Council Members. One member has declined to receive a salary. Explain Significant Spending on Capital Projects Below: In 2012, Council budgeted $8,400 for purchase of I -Pads and related equipment. The money ($6,289) was encumbered in 2012, but spent in 2013. In 2013, another $14,000 was budgeted for related equipment along with $10,000 for the council committee room renovations. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name I Administration & Finance IMonth I October Fund /Department Number 1 101 -0401 1 Date Updated 1 11/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 1,877,678 134,123 1,508,872 1,291,690 368,806 80% 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 3,679 4,085 8,548 (4,035) 8171% Transfers In - - - - - 0% Total Revenue 1,877,728 137,802 1,512,957 1,300,238 364,771 81% Expenditures Personnel 1,555,638 118,295 1,260,404 1,134,328 - 295,234 81% Supplies 50,301 2,478 29,895 24,422 11,262 9,144 82% Services 267,316 15,743 221,372 136,308 20,932 25,012 91% Debt Service 4,473 1,286 1,286 - - 3,187 29% Capital - - - - - 0% Transfers Out - - - 5,180 - 0% Total Expenditures 1,877,728 137,802 1,512,957 1,300,238 32,193T 332,578 82% Net - - - (32,193)1 32,193 Cash Balance Stathng Full Time 21.00 20.00 20.00 Part-Time /Season al/Tem porary 1.51 1.00 1.00 Total 22.51 21.00 21.00 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Higher professional services expended so far in 2013 included amounts for temporary help, 311 call center consulting and AECOM economic impact study. Higher personnel costs for temporary and interns in 2013 than in 2012. Higher education & training costs than anticipated so far in 2013. A mid -year budget transfer from personnel to services account was posted on August 26, 2013. A new Talent Manager in Human Resources was hired in June, 2013. A new part-time Diversity Compliance officer was hired. The Director of Human Resources position is unfilled but has been advertised and interviews will be conducted before the end of the year. Explain Significant Spending on Capital Projects Below: None Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Fund /Department Number 101 -0404 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 151,800 42,326 136,572 152,311 15,228 90% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 876,000 26,017 641,276 609,416 234,724 73% Interest Earnings - - - - - 0% Bond Proceeds 0% Donations 0% Other Income 6,000 29 4,823 5,127 1,177 80% Transfers In - - - - - 0% Total Revenue 1,033,800 68,373 782,671 766,854 251,129 76% Expenditures Personnel 652,134 49,112 534,096 517,444 800 117,238 82% Supplies 30,346 1,100 16,726 16,270 6,874 6,746 78% Services 351,320 18,160 231,849 230,190 40,296 79,175 77% Debt Service - - - - - - 0% Capital - 0% Transfers Out - - - 2,950 0% Total Expenditures 1,033,800 68,373 782,671 766,854 47,970T--- 7,970 203,159 80% Net - (0) (0) 0 (47,970)1 47,970 Cash Balance Staffing Full Time 12.00 12.00 12.00 Part-Time /Season al/Tem porary 4.00 4.00 4.00 Total 16.00 16.00 16.00 r=xpiam aigmricam rtevenue, r- xpenanure ano starring ,- nangesivanances oeiow: Thank you Wicked! The acclaimed Broadway musical Wicked played at the Morris Performing Arts Center in the spring and resulted in large attendance and activity in the downtown (May 2013). In the month of October 2013, we had a total of six (6) theatrical events in the Morris Performing Arts Center. am oignincam openaing on t apnai rrojects neiow: 1 416 is used to support renovating, remodeling, or, othe Center. Not all of the expenses are Capital expenses. and / or service to the patrons at Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Fund /Department Number 101 -0405 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 182,849 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 62,349 42% - Property Taxes /Non -Dept Revenue 182,849 14,483 77,349 Local Income Taxes - - - Other Taxes 47,910 84% - Grants /Intergovernmental - - - Charges for Services 291,981 28,364 244,071 Interest Earnings - - - Bond Proceeds 0% 278,731 112,114 Donations - - - Other Income 18,000 2,332 16,145 Transfers In - - - Total Revenue 492,830 45,178 337,565 Expenditures 0% 278,731 43,151 Personnel 226,174 15,648 172,330 Supplies 21,130 323 8,572 Services 245,526 29,207 156,663 Debt Service - - - Capital Transfers Out - - - Total Expenditures 492,830 45,178 337,565 Net - - - Cash Balance Staffing Full Time 2.00 2.00 2.00 Part-Time /Season al/Tem porary 1.00 1.00 1.00 Total 3.00 3.00 3.00 59,847 62,349 42% - - 0% 0% 0% 204,583 47,910 84% - - 0% 0% 0% 14,300 1,855 90% - - 0% 278,731 112,114 68% 154,010 240 53,604 76% 5,261 3,738 8,820 58% 113,804 39,174 49,689 80% - - - 0% 5,056 0% 600 0% 278,731 43,151 112,114 77% - (43.151) r=xpiam aignmcam rtevenue, cxpenonure ano atarnng ,- nangesivanances rseiow: More knots were tied and we were blessed with many bridal receptions compared to the same period last year. rncam apenaing on t apnai rrojects neiow: )lects were budgeted. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Fund /Department Number 101 -0501 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 956,116 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 224,623 77% - Property Taxes /Non -Dept Revenue 956,116 80,783 731,493 Local Income Taxes - - - Other Taxes 0% 720 Grants /Intergovernmental 53% - - Charges for Services - - - Interest Earnings 2,000 104 1,062 Bond Proceeds - - - Donations - - - Other Income 70,350 12 712 Transfers In - - - Total Revenue 1,028,466 80,899 733,266 Expenditures - 0% 657.373 1.254 Personnel 959,774 72,933 672,536 Supplies 8,684 934 13,555 Services 51,992 7,033 44,920 Debt Service 2,000 - 2,255 Capital 6,016 - Transfers Out - - - Total Expenditures 1,028,466 80,899 733,266 Net - Cash Balance Staffing Full Time 9.60 10.00 10.00 Part-Time /Season al/Tem porary - 4.00 4.00 Total 9.60 14.00 14.00 587,565 224,623 77% - - 0% 0% 0% 0% 720 939 53% - - 0% - - 0% 69,088 69,638 1 % - - 0% 657,373 295,200 71% 613,821 - 287,238 70% 5,723 761 (5,631) 165% 35,070 493 6,579 87% - - (255) 113% - 6,016 0% 2,760 - - 0% 657.373 1.254 293.946 1 71% r=xpiam aigmncam rtevenue, r- xpenanure ano atarnng ,- nangesivanances rseiow: Supplies are over - budget due to computer purchases which are no longer considered capital but were budgeted as such. rncam apenaing on t apnai rrojects neiow: 1 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Energy Office Fund /Department Number 101 -0600 Month I October Date Updated 1 11/19/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 54,256 54,256 472,239 100% 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 54,256 54,256 472,239 100% Expenditures Personnel - - - 0% Supplies - - - 0% Services 54,256 54,256 149,064 100% Debt Service - - - 0% Capital 323,175 0% Transfers Out - - - 0% Total Expenditures 54,256 54,256 472,239 100% Net - - Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total rxpiam aigmricanr mevenue, cxpenonure ano ararrmg %,nangesivanances aeiow: The Energy Office was moved to Central Services fund 222 for 2012. The amount of $54,256 was paid in 2013 to reimburse Fund 222 for grant proceeds deposited in the General Fund but expended in the Central Services Fund, as requested by the State Board of Accounts. An additional appropriation of $54,256 was included on the 2013 mid -year listing which was approved by the Common Council on August 26, 2013. Explain Significant Spending on Capital Projects Below: No capital spending in this department for 2013. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Engineering Fund /Department Number 101 -0602 Month I October Date Updated 1 11/12/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 1,357,461 99,100 1,060,302 1,307,340 297,159 78% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 30,000 51,776 30,000 0% Interest Earnings - - - 0% Bond Proceeds 0% Donations 0% Other Income 6,100 54 4,954 23,963 1,146 81% Transfers In - - - - - 0% Total Revenue 1,393,561 99,154 1,065,256 1,383,079 328,305 76% Expenditures Personnel 637,072 48,214 521,090 937,949 5,435 110,546 83% Supplies 18,624 1,933 14,283 12,897 2,689 1,652 91% Services 725,865 48,344 526,600 394,014 90,651 108,613 85% Debt Service 12,000 662 3,283 - 1,973 6,744 44% Capital - - - 8,399 - - 0% Transfers Out - - - 29,820 - 0% Total Expenditures 1,393,561 99,154 1,065,256 1,383,079 100,749T--- 00,749 227,556 84% Net - - - - (100,749)1 100,749 Cash Balance Staffing Full Time 8.20 8.05 8.05 Part-Time /Season al/Tem porary 1.81 1.60 1.60 Total 10.01 9.65 9.65 r xpiam aigmricant rtevenue, r- xpenanure ano starring ,- nangesivanances aeiow: Largest portions of $90,651 encumbrance for Services is Cardno /JFNew VISA for $16,462 (Prof Serv), and ESRI for the annual maintenance contract $50,000 (Year 2 in R &M /Computer Equip) rxpiam oignincam openaing on t apnai rrojects neiow: The lease /purchase of one Ricoh plotter /scanner is on the Board of Public Works agenda for approval on $648.00 quarterly for five years and has been included in the 2013 budget. cost Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Traffic & Lighting Fund /Department Number 101 -0607 Month I October Date Updated 1 11/20/2013 Current Current Current Prior 111,815 109,186 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 2,629 98% Property Taxes /Non -Dept Revenue 111,815 109,186 Local Income Taxes - - Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations (350) - Other Income - 350 Transfers In - - Total Revenue 111,815 109,536 Expenditures 1,974 98% Personnel - 82% Supplies 110,147 108,173 Services 1,668 1,363 Debt Service - 0% Capital 2,279 98% Transfers Out - - Total Expenditures 111,815 109,536 Net - Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Fund is winding down. Will be de- activated after encumbrances have been exhausted. rncanr apenaing on t apnai r-rojecrs neiow: 541,253 2,629 98% - - 0% 0% 0% 0% 0% 0% 0% 29,986 (350) 0% - - 0% 571,239 2,279 98% 105,704 - 0% 389,587 1,974 98% 68,132 305 82% - 0% 7,816 0% 0% 571,239 2,279 98% - rnt Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Department jMonth I October Fund /Department Number 101 -0801 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 23,434,876 1,706,040 18,283,201 19,146,945 5,151,675 78% Local Income Taxes - - - - - 0% Other Taxes - 0% Grants /Intergovernmental 1,022,206 0% Charges for Services - 0% Interest Earnings 0% Bond Proceeds 0% Donations 7,500 - - - 7,500 0% Other Income 353,000 53,251 293,186 294,792 59,814 83% Transfers In - - - - - 0% Total Revenue 23,795,376 1,759,291 18,576,387 20,463,943 5,218,989 78% Expenditures Personnel 20,376,883 1,509,349 16,058,416 16,942,449 - 4,318,467 79% Supplies 467,988 22,454 337,693 978,188 88,327 41,968 91% Services 2,617,924 227,488 2,136,280 2,411,601 282,654 198,990 92% Debt Service 24,185 - 15,602 15,151 - 8,583 65% Capital 308,396 28,396 94,824 37,815 242,185 21% Transfers Out - - - 21,730 - - 0% Total Expenditures 23,795,376 1,759,291 18,576,387 20,463,943 408,796 4,810,193 80% Net - - - (408,796)1 408,796 Cash Balance Staffing Full Time 250.00 243.00 243.00 Part-Time /Season al/Tem porary 43.00 31.00 31.00 Total 293.00 274.00 274.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The decrease in revenue compared to 2012 for the Grants /Intergovernmental account is that 2012 was the final year of the COPS Hiring Recovery Program funding. The decrease in Personnel Expenditures in 2013 compared to 2013 is due to the transfer of an additional ten officer's salary to the LOIT fund. This decrease is partially ofset by the 2.5% increase in salary for the department. There is a corresponding increase in the LOIT fund. Supplies of $337,693 are down from the 2012 expenditure level due to an accounting change. Police gas cost of $670,224 for 2013 is recorded in Fund 404. Explain Significant Spending on Capital Projects Below: The $28,396 of capital is the purchase of a Police SUV for the Police Chief. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Fund /Department Number 101 -0802 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 2,326,560 184,697 1,728,051 1,656,109 598,509 74% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 2,326,560 184,697 1,728,051 1,656,109 598,509 74% Expenditures Personnel 2,298,012 182,920 1,708,509 1,634,816 589,503 74% Supplies 4,029 - 1,246 2,358 - 2,783 31% Services 24,519 1,777 18,296 18,935 570 5,653 77% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 2,326,560 184,697 1,728,051 1,656,109 570 597,939 74% Net - - - - (570)1 570 Cash Balance Staffing Full Time 38.00 34.00 34.00 Part-Time /Season al/Tem porary - - - Total 38.00 34.00 34.00 rxpiam aignmcam mevenue, cxpenonure ano acarnng ,- nangesivanances aeiow: Expenditures and staffing levels for the Communications Department are on track with budget. rncam apenaing on t apnai r-rojecis neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Public Safety LOIT - Police Fund /Department Number 101 -0805 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue (692,209) (711,661) (415,187) 711,661 0% Local Income Taxes - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 3,968,567 992,142 3,986,751 3,029,208 18,184 100% Total Revenue 3,968,567 299,933 3,275,090 2,614,021 693,477 83% Expenditures Personnel 3,968,567 280,482 3,150,482 2,564,290 818,085 79% Supplies - - - - - 0% Services 0% Debt Service 0% Capital 0% Transfers Out - 19,451 124,608 49,731 124,608 0% Total Expenditures 3,968,567 299,933 3,275,090 2,614,021 693,477 83% Net - - - Cash Balance Staffing Full Time 47.00 46.00 46.00 Part-Time /Season al/Tem porary - - - Total 47.00 46.00 46.00 rxpiam aigmricanr Kevenue, cxpenonure ano ararring ,- nangesivanances aeiow: The increase in Personnel expenditures in 2013 compared to 2012 is due to the the transfer of 10 additional officers to the LOT from the General fund in 2013. There are now 47 officers budgeted in the Loit compared to 37 in 2012. The 2.5% increase in salaries also contributed to the increase in expenditures over 2012. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Fund /Department Number 101 -0901 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 18,991,695 1,506,721 15,615,926 15,871,958 3,375,769 82% Local Income Taxes - - - - 0% Other Taxes - - 0% Grants /Intergovernmental 155,000 - - 155,000 0% Charges for Services 455,000 41,915 470,862 343,519 (15,862) 103% Interest Earnings - - - 0% Bond Proceeds 0% Donations - - - 0% Other Income 6,000 129 38,659 29,376 (32,659) 644% Transfers In 1,000,000 - 500,000 1,000,000 500,000 50% Total Revenue 20,607,695 1,548,765 16,625,447 17,244,854 3,982,248 81% Expenditures Personnel 18,549,180 1,389,562 15,151,301 15,621,150 45,748 3,352,131 82% Supplies 398,387 28,686 301,554 443,701 27,237 69,596 83% Services 1,652,040 130,516 1,172,592 1,173,283 52,436 427,012 74% Debt Service - - - - 0% Capital - - - - - 0% Transfers Out 8,088 - - 6,720 - 8,088 0% Total Expenditures 20,607,695 1,548,765 16,625,447 17,244,854 125,421 1 3,856,827 81% Net - - - (125,421)1 125,421 Cash Balance Staffing Full Time 218.00 216.00 216.00 Part-Time /Season al/Tem porary 1.00 - - Total 219.00 216.00 216.00 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Graduated a recruit class of 8 to fill 10 positions opening throughout 2012 and 2013. Recruit Class decreased by 1. Expecting retirement of 3 -4 individuals throughout 2013 and expect another recruit class to begin in February 2014. Two firefighters pending separation, one for legal reasons and one approved LOA/sabatical to receive training. Augmenting with Temp staffing to continue reducing call backlog for EMS billing. Explain Significant Spending on Capital Projects Below: Capital projects run through fund 288 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Public Safety LOIT - Fire Fund /Department Number 101 -0905 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue (824,631) (539,534) (338,117) 539,534 0% Local Income Taxes - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 3,133,190 1,068,394 3,418,287 2,329,192 285,097 109% Total Revenue 3,133,190 243,763 2,878,753 1,991,075 254,437 92% Expenditures Personnel 3,133,190 243,763 2,423,330 1,865,370 709,860 77% Supplies - - - - - 0% Services 0% Debt Service 0% Capital 0% Transfers Out - 455,423 125,705 455,423 0% Total Expenditures 3,133,190 243,763 2,878,753 1,991,075 254,437 92% Net - - - Cash Balance Staffing Full Time 39.00 Part-Time /Season al/Tem porary - Total 39.00 rxpiam oigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances oeiow: PSLOIT funds 39 First Class Firefighter positions. No changes in staffing at this level. These are members of the fire department, but their salaries and benefits are paid through this account to demonstrate directly the Fire Department positions that are made possible by the Public Safety Local Option Income Tax. Explain Significant Spending on Capital Projects Below: No capital expenditures through this account Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Fund /Department Number 101 -1008 Month I October Date Updated 1 11/13/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 346,237 38,295 268,219 219,893 78,018 77% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 242 (242) 0% Transfers In - - - - - 0% Total Revenue 346,237 38,295 268,461 219,893 77,776 78% Expenditures Personnel 256,834 18,779 204,168 196,288 52,666 79% Supplies 3,861 799 2,955 2,971 - 906 77% Services 82,542 18,717 61,338 19,714 4,840 16,364 80% Debt Service - - - - - - 0% Capital 3,000 - 3,000 0% Transfers Out - - - 920 - - 0% Total Expenditures 346,237 38,295 268,461 219,893 4,840 72,936 79% Net - - - (4,840)1 4,840 Cash Balance Staffing Full Time 4.00 4.00 4.00 Part-Time /Season al/Tem porary - - - Total 4.00 4.00 4.00 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: Late last year (December 2012), the Human Rights moved into a new building. Thus, office space was only paid for one month. The services category is much higher because of rent paid this year. Expenditures are consistent with normal operating costs. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Code Enforcement IMonth I October Fund /Department Number 101 -1201 1 Date Updated 1 11/12/2013 Revenue Property Taxes /Non -Dept Revenue Local Income Taxes Other Taxes Grants /Intergovernmental Charges for Services Interest Earnings Bond Proceeds Donations Other Income Transfers In Total Revenue Expenditures Personnel Supplies Services Debt Service Capital Transfers Out Total Expenditures Net Cash Balance Current Current Current Prior 6,867 197,935 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget 2,270,669 215,690 1,707,441 1,317,389 563,228 75% - - - - - 0% 0% 0% 0% 0% 0% 0% 300 4 2,824 361 (2,524) 941% - - - - - 00 2.270.969 215.694 1.710.265 1.317.750 560.704 1 75% 983,883 69,385 779,081 751,895 6,867 197,935 80% 89,757 6,606 79,264 70,459 2,020 8,472 91% 985,130 139,153 765,788 456,759 155,122 64,220 93% 2,199 550 1,649 - 550 0 100% 158,000 - 71,482 - - 86,518 45% 52,000 - 13,000 38,637 - 39,000 25% 270,969 215,694 1,710,265 1,317,750 164,559 396,145 83% - - - (164.55911 164.559 athng Full Time 16.50 16.00 16.00 Part-Time /Season al/Tem porary 0.50 1.00 1.00 Total 17.00 17.00 17.00 r xpiam aigmricam rtevenue, r- xpenanure ano starring ,- nangesivanances rseiow: Dir of Code Enforcement and Director of Admin Services were supposed split salaries between Code and Animal Control, but that wasn't happening. Other income of $2,300 was insurance proceeds from an auto accident. Transfers out are to Solid Waste for landfill fees. The encumbrance in Personnel is for D. Skwarcan's salary for the remainder of 2013; she's a contracted employee through PeopleLink. Inter -City services- -Site Mowing, Graffiti Removal and Illegal Dumping -- billed Code for $116,337 in October. Encumbrances for Site Mowing and Graffiti Removal (Parks) and Illegal Dumping (Solid Waste) are $127,184 as of 31 Oct. rxpiam oignincam openaing on t apnai rrojects neiow: Capital expenditure of $71,482 is for two pickup trucks and a hybrid car. The 2013 Budget also included $90,000 for a single -axle dump truck that purchase has been indefinitely postponed in order to use funds from this account to cover shortfalls in other parts of the department. The actual remainder in the account is $86,518 as of 31 October. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Code Hearing Officer Fund /Department Number 101 -1203 Month I October Date Updated 1 11/12/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 40,000 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 6,922 83% - Property Taxes /Non -Dept Revenue 40,000 4,600 33,078 Local Income Taxes - - - Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% 31,665 6,922 Donations - - 0% Other Income - 0% 31,665 7,200 Transfers In - - - Total Revenue 40,000 4,600 33,078 Expenditures 0% 31.665 7.200 Personnel - - - Supplies - - - Services 40,000 4,600 33,078 Debt Service - - - Capital Transfers Out - - - Total Expenditures 40,000 4,600 33,078 Net - - - Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total 31,665 6,922 83% - - 0% 0% 0% 0% 0% 0% 0% 0% 0% 31,665 6,922 83% - - 0% - - - 0% 31,665 7,200 (278) 101% - - - 0% 0% 0% 31.665 7.200 1 (278) 1 101% 7 r=xpiam aigmricam rtevenue, cxpenonure ano starring ,- nangesivanances rseiow: Sole expenditure is monthly billing for Hearing Officer. Expenses are a little higher than expected. Engel's rate of $500 per hearing day has been approved by the Legal Dept. Hoppenheimer is new backup officer. The department has exceeded its annual budget due to more code hearings than originally scheduled. rncam apenaing on t apnai rrojects t5eiow: >enditures for this department. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Junk Vehicle Fund /Department Number 101 -1204 Month I October Date Updated 1 11/13/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue 29,829 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 5,871 80% - Property Taxes /Non -Dept Revenue 29,829 378 23,958 Local Income Taxes - - - Other Taxes 29,519 18% - Grants /Intergovernmental - - - Charges for Services 36,000 150 6,481 Interest Earnings - - - Bond Proceeds 0% 52,700 35,390 Donations 41,330 - 30,406 44% Other Income 348 68% 7,764 1,385 Transfers In - - - Total Revenue 65,829 528 30,439 Expenditures 0% 52,700 1,495 Personnel 54,065 18 23,659 Supplies 1,082 11 624 Services 10,682 500 6,156 Debt Service - - - Capital Transfers Out - - - Total Expenditures 65,829 528 30,439 Net - Cash Balance Staffing Full Time 1.00 Part-Time /Season al/Tem porary - Total 1.00 32,723 5,871 80% - - 0% 0% 0% 19,977 29,519 18% - - 0% 0% 0% 0% 0% 52,700 35,390 46% 41,330 - 30,406 44% 772 110 348 68% 7,764 1,385 3,141 71% - - - 0% 2,834 0% - 0% 52,700 1,495 33,894 49% - (1.49511 1.495 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Single employee resigned June 2013, transferred to Police. We expect an arrangement where he will continue to tow vehicles and we will pay the Police Dept. Details still pending. July: credit of $2,300 posted to Services from Central Svcs for Parts, Fuel, & Labor. Only Personnel cost is AJ for Unemployment Insurance Allocation. rncanr apenaing on t apnai r-rojecrs neiow: penditures. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Unsafe Building Fund /Department Number 101 -1205 Month I October Date Updated 1 11/13/2013 Current Current Current Prior Property Taxes /Non -Dept Revenue (49,316) Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 175,003 455% Property Taxes /Non -Dept Revenue (49,316) (10,880) (224,319) Local Income Taxes 0% Other Taxes 8,398 83% - Grants /Intergovernmental - - - Charges for Services 50,000 9,345 41,602 Interest Earnings - - - Bond Proceeds 0% 63,869 32,922 Donations - - - Other Income 53,000 3,350 203,479 Transfers In - - - Total Revenue 53,684 1,815 20,762 Expenditures 0% Personnel - - - Supplies - - - Services 53,684 1,815 20,762 Debt Service - - - Capital Transfers Out - - - Total Expenditures 53,684 1,815 20,762 Net - - - Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total (169,992) 175,003 455% - 0% 0% 0% 8,329 8,398 83% - - 0% 0% 0% 225,533 (150,479) 384% - - 0% 63,869 32,922 39% - - 0% - - - 0% 63,869 24,870 8,052 85% - - - 0% 0% 0% r=xpiam aigmricam rtevenue, r- xpenanure ano starring ,- nangesivanances rseiow: Service expenditures are primarily board -ups which haven't been called for as much as anticipated. Revenue from fines & forfeitures includes $91,531 from 2012 Property Taxes collected and $68,797 from June's property tax collections. rncam apenaing on t apnai rrojects neiow: rchases have been made. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Animal Control IMonth I October Fund /Department Number 101 -1207 1 Date Updated 11/13/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 542,611 36,546 430,268 402,984 112,343 79% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 52,400 4,326 39,805 39,947 12,595 76% Interest Earnings - - - - - 0% Bond Proceeds - - - - 0% Donations 100 517 2,943 210 (2,843) 2943% Other Income 1,000 191 456 410 544 46% Transfers In - - - - - 0% Total Revenue 596,111 41,580 473,472 443,551 122,639 79% Expenditures Personnel 436,947 30,139 340,235 314,336 - 96,712 78% Supplies 66,364 4,786 52,232 51,301 795 13,337 80% Services 91,340 6,451 80,393 69,703 3,356 7,591 92% Debt Service 1,200 204 612 - 204 385 68% Capital 260 - - 7,050 - 260 0% Transfers Out - - - 1,160 - - 0% Total Expenditures 596,111 41,580 473,472 443,551 4,354 118,285 80% Net - - - - (4,354)1 4,354 Cash Balance Staffing Full Time 8.50 8.00 8.00 Part-Time /Season al/Tem porary 0.40 1.00 1.00 Total 8.90 9.00 9.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Director of Admin Services was supposed to have salary split between Code and Animal Control, but 100% has gone to Code. New Shelter Manager began work 8 July. Vet Services account is over - budget but will be corrected at year -end budget transfers (money is available from Professional Services account). Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted. $260 budget appears in error; will be corrected as part of year -end budget transfers. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Rainy Da Fund /Department Number 102 Month I October Date Updated 1 11/14/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 52,000 1,764 26,328 37,620 25,672 51% Bond Proceeds - - - - 0% Donations - 0% Other Income 0% Transfers In - - - - 0% Total Revenue 52,000 1,764 26,328 37,620 25,672 51% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures 0% Net 52,000 1,764 26,328 37,620 25,672 Cash Balance 8,614,509 8,583,562 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: No significant changes at this time. No expenditures are budgeted in this fund. The establishment of a Rainy Day Fund is looked upon favorably by bond rating agencies and is one of the factors restulting in South Bend's good AA bond rating with Standard & Poor's. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation IMonth I October Fund /Department Number 201 1 Date Updated 11/11/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 7,800,000 3,943,985 4,295,900 3,856,015 51% Local Income Taxes - - - - 0% Other Taxes 533,081 309,952 308,977 223,129 58% Grants /Intergovernmental 696,009 58,001 580,008 513,830 116,001 83% Charges for Services 3,239,789 199,511 3,077,068 3,125,939 162,721 95% Interest Earnings 10,000 710 11,250 13,360 (1,250) 113% Bond Proceeds - - - - 0% Donations - - - 0% Other Income 83,450 13,233 15,771 70,217 16% Transfers In - - - - - 0% Total Revenue 12,362,329 258,222 7,935,495 8,273,777 4,426,834 64% Expenditures Personnel 7,941,934 581,708 6,499,039 6,378,848 2,643 1,440,252 82% Supplies 1,670,053 122,070 1,521,920 1,436,863 215,333 (67,200) 104% Services 2,331,375 158,470 1,843,637 1,540,383 78,019 409,719 82% Debt Service 289,406 44,661 240,307 194,724 - 49,099 83% Capital 504,195 - 290,855 490,017 33 213,307 58% Transfers Out 190,500 - - 171,890 - 190,500 0% Total Expenditures 12,927,463 906,909 10,395,758 10,212,726 296,028 2,235,677 83% Net (565,134) (648,687) (2,460,263) (1,938,949) (296,028)1 2,191,157 Cash Balance 2,422,937 2,685,031 Staffing Full Time 117.00 113.00 113.00 Part-Time /Season al/Tem porary 76.00 72.00 79.00 Total 193.00 185.00 192.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Golf revenue down from last year because 2012 started early and 2013 has been bad due to weather. Staffing is declining due to the end of summer programming and maintenance seasonal employees. Explain Significant Spending on Capital Projects Below: Three trucks were purchased during August. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month I October Fund /Department Number 202 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 4,749,789 416,476 4,066,912 3,569,464 682,877 86% Grants /Intergovernmental - - - - - 0% Charges for Services 197,000 6,772 376,645 216,427 (179,645) 191% Interest Earnings 7,000 985 10,172 6,145 (3,172) 145% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 111,300 1,000 25,783 91,658 85,517 23% Transfers In 3,626,882 - 3,626,882 2,693,842 - 100% Total Revenue 8,691,971 425,233 8,106,394 6,577,536 585,577 93% Expenditures Personnel 3,845,935 245,135 2,888,704 2,394,975 957,231 75% Supplies 3,124,845 427,405 1,830,083 2,170,559 550,939 743,823 76% Services 1,756,176 108,530 1,141,743 930,815 112,618 501,815 71% Debt Service 172,800 - 53,627 - 119,173 31% Capital 276,740 70,905 142,384 205,835 26% Transfers Out - - - 88,250 - 0% Total Expenditures 9,176,496 781,070 5,985,061 5,726,982 663,557 2,527,877 72% Net (484,525) (355,837) 2,121,332 850,553 (663,557) (1,942,300) Cash Balance 4,392,247 2,264,272 Staffing Full Time 59.00 56.00 56.00 Part-Time /Season al/Tem porary 6.16 6.19 6.19 Total 65.16 62.19 62.19 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Information included for Streets, Traffic & Lighting, and Curb & Sidewalk: Increase in personnel costs - in 2013 the Traffic & Lighting budget was moved from the General Fund (101 -0607) to MVH; additional salary and benefit allocations from Engineering Department. Staffing changes: Two full -time Equip Operators left, lost 2 FTEs, will be replaced. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Recreation Nonreverting jMonth I October Fund /Department Number 203 1 Date Updated 11/18/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 1,632,943 28,218 808,521 917,887 824,422 50% Interest Earnings 4,000 169 2,394 2,959 1,606 60% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 12,377 102,256 43,346 (102,256) 0% Transfers In - - - - - 0% Total Revenue 1,636,943 40,764 913,171 964,191 723,772 56% Expenditures Personnel 668,209 37,049 381,156 432,988 - 287,053 57% Supplies 288,211 25,806 189,326 169,041 63,261 35,624 88% Services 485,357 8,362 202,314 225,943 11,234 271,808 44% Debt Service - - - - - - 0% Capital 119,000 - 38,492 119,000 0% Transfers Out - - 10,375 21,800 10,375 0% Total Expenditures 1,560,777 71,217 783,172 888,264 74,495 703,110 55% Net 76,166 (30,453) 129,999 75,928 (74,495)1 20,662 Cash Balance 801,131 684,879 Staffing Full Time 1.00 1.00 1.00 Part-Time /Season al/Tem porary 25.70 22.50 17.44 Total 26.70 23.50 18.44 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund accounts for programs and events that are self funded through user fees. Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Studebaker - Oliver Reverting Grants Fund /Department Number 209 Month I October Date Updated 1 11/14/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 1,690 66% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 5,000 222 3,310 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 5,000 222 3,310 Expenditures MAR .11 Personnel - - - Supplies Services Debt Service - Capital 1,000,000 Transfers Out - Total Expenditures 1,000,000 - - Net (995,000) 222 3,310 Cash Balance 1,082,985 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: 2012 debt service expense to reimburse for final Section 108 #7 payment. n oignincanr openaing on t apnai r-rojecrs neiow: to be used for environmental clean up as needed. If not used this year, 4.905 905 1,838 160,764 162,602 (157,697 1,079.095 use next year. Form 3 0% 0% 0% 0% 0% 1,690 66% - 0% 0% 0% 0% 1,690 66% - 0% 0% 0% 0% 1,000,000 0% - 0% 1,000,000 0% MAR .11 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Fund /Department Number 210 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 63,826 Grants /Intergovernmental 35% - - Charges for Services - - - Interest Earnings 161,829 205 56,727 Bond Proceeds - - - Donations - - - Other Income 1,462,358 0% 163,082 Transfers In - - - Total Revenue 1,624,187 205 219,809 Expenditures - 0% 189,062 Personnel - - - Supplies 30,904 599,501 Services - - - Debt Service 1,260,777 11,478 455,900 Capital - - - Transfers Out - - - Total Expenditures 1,260,777 11,478 455,900 Net 363,410 (11,273) (236,091) Cash Balance 682,364 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: No significant issues. rncam apenaing on t apnai rrojects neiow: Form 3 0% 0% 0% 0% 0% 63,826 105,102 35% - - 0% - - 0% 156,140 1,299,276 11% - - 0% 219,966 1,404,378 14% - - 0% 0% 0% 189,062 804,877 36% - - 0% - - 0% 189,062 804,877 36% 30,904 599,501 935.951 Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development Admn. IMonth I October Fund /Department Number 211 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 421,787 139,636 324,599 282,151 33% Charges for Services - - - - - 0% Interest Earnings 2,200 147 2,300 2,579 (100) 105% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 200,300 16,299 278,595 222,097 (78,295) 139% Transfers In 1,717,521 - 1,288,139 1,527,146 429,382 75% Total Revenue 2,341,808 16,446 1,708,670 2,076,421 633,138 73% Expenditures Personnel 1,929,047 142,929 1,495,954 1,384,424 - 433,093 78% Supplies 36,561 2,190 28,074 15,914 1,978 6,509 82% Services 384,003 27,181 283,582 106,113 19,891 80,530 79% Debt Service - - - - - - 0% Capital 4,720 4,720 - 100% Transfers Out - - - 202,620 0% Total Expenditures 2,354,331 172,300 1,812,330 1,709,071 21,869 520,132 78% Net (12,523) (155,854) (103,660) 367,350 (21,869)1 113,006 Cash Balance 480,178 883,640 Staffing Full Time 25.60 25.60 25.60 Part-Time /Season al/Tem porary 1.00 1.00 1.00 Total 26.60 26.60 26.60 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Have drawn our staff contracts (other income) faster than last year. Admin cost shows in services in 2013, but was in transfers out in 2012. Explain Significant Spending on Capital Projects Below: Capital expenditures relate to purchase of whiteboard for conference room and electrical work associated with move to 14th floor. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Community & Economic Development jMonth I October Fund /Department Number 212 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 8,148,705 258,413 3,490,595 3,339,927 4,658,110 43% Charges for Services - - - - - 0% Interest Earnings 2,000 222 1,997 2,348 3 100% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 649,600 5,564 364,169 451,073 285,431 56% Transfers In - - - - - 0% Total Revenue 8,800,305 264,199 3,856,761 3,793,348 4,943,544 44% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Grants 8,957,256 412,436 3,784,740 3,490,767 3,400,960 1,771,556 80% Transfers Out - - - - - - 0% Total Expenditures 8,957,256 412,436 3,784,740 3,490,767 3,400,960 1,771,556 80% Net 156,951 148,237 72,021 302,581 3,400,960 3,171,988 Cash Balance 583,505 595,856 Staffing Full Time - Part-Time /Seasonal/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund covers multiple federal grants. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on -going and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Fund /Department Number 216 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 22,973 15,761 55% Other Taxes - - - Grants /Intergovernmental 35,000 575 19,239 Charges for Services - - - Interest Earnings 300 30 442 Bond Proceeds - - - Donations - - 0% Other Income 600 0% 8,480 Transfers In - - - Total Revenue 35,900 605 19,681 Expenditures - 0% 8,480 Personnel - - - Supplies 10,000 (18,231) - Services 22,500 1,450 Debt Service - - Capital 13,400 10,000 Transfers Out - - Total Expenditures 45,900 - 11,450 Net (10,000) 605 8,231 Cash Balance 153,155 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Revenue stream is not a steady flow. It is dependent upon the processing and release of funds from the State for seized assets in drug activities. Expenditures are to be used to support the Police Departments effort to combat drug activity. Explain Significant Spending on Capital Projects Below: The $10,000 Capital purchase was the VMWare Center Server and Switch for Police Communications. Form 3 0% 0% 0% 22,973 15,761 55% - - 0% 576 (142) 147% - - 0% - 0% 600 0% - - 0% 23,549 16,219 55% - - 0% - 10,000 0% 8,480 21,050 6% - - 0% 3,400 75% - - 0% 8,480 34,450 25% 15,069 (18,231) 141.777 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Revenue stream is not a steady flow. It is dependent upon the processing and release of funds from the State for seized assets in drug activities. Expenditures are to be used to support the Police Departments effort to combat drug activity. Explain Significant Spending on Capital Projects Below: The $10,000 Capital purchase was the VMWare Center Server and Switch for Police Communications. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month October Fund /Department Number 217 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 200 15 204 253 (4) 102% Bond Proceeds - - - - - 0% Donations 16,811 11,269 17,875 5,542 67% Other Income - - - - 0% Transfers In - - - - - 0% Total Revenue 17,011 15 11,474 18,128 5,537 67% Expenditures Personnel - - - - - 0% Supplies 3,441 3,164 - 3,441 0% Services 7,311 - 1,310 6,001 18% Debt Service - - - 0% Capital 0% Transfers Out 0% Total Expenditures 10,752 - - 3,164 1,310 9,442 12% Net 6,259 15 11,474 14,964 (1,310) (3,904) Cash Balance 74,707 61,594 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: In July, spring taxes ($1,310.22) were charged to the services account in error. Correction made in August. The Gift, Donation, and Bequest fund may be used by all City departments but the majority of the donations are for Animal Care and Control and Community Investment (i.e. bicycle signs). Donations received during June, 2013 were $9,810 and included $7,311 from Well Fargo Bank for code demolitions and property taxes on certain properties. This amount has been included on the 2013 mid -year appropriation ordinance for consideration by the Common Council on August 26, 2013. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations IMonth I October Fund /Department Number 218 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 1,000 85 485 318 515 49% Interest Earnings 25 2 34 43 (9) 136% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,025 87 519 360 506 51% Expenditures Personnel - - - - - 0% Supplies 500 500 0% Services 500 500 0% Debt Service - - 0% Capital 0% Transfers Out 0% Total Expenditures 1,000 - - 1,000 0% Net 25 87 519 360 (494) Cash Balance 11,403 10,776 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This fund was established to collect curfew and prostitution fines. Expenditures are used for Police enforcement and training. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education IMonth I October Fund /Department Number 220 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 108,000 - 6,964 74,468 101,036 6% Charges for Services 180,000 20,857 151,851 156,118 28,149 84% Interest Earnings 3,000 193 3,131 4,619 (131) 104% Bond Proceeds - - - - - 0% Donations 2,000 760 2,725 2,120 (725) 136% Other Income 54,000 670 8,188 13,914 45,812 15% Transfers In - - - - - 0% Total Revenue 347,000 22,480 172,859 251,239 174,141 50% Expenditures Personnel - - - - - - 0% Supplies 148,512 909 124,140 19,422 7,583 16,789 89% Services 119,500 - 35,377 47,705 - 84,123 30% Debt Service - - - - - 0% Capital 210,119 123,119 151,868 12,800 74,200 65% Transfers Out - - - - - - 0% Total Expenditures 478,131 909 282,636 218,995 20,383 175,112 63% Net (131,131) 21,571 (109,777) 32,244 (20,383) (971) Cash Balance 977,428 1,073,481 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Grant revenue results from reimbursement of expenditures specified in the grant plus fees for accident reports, gun permits and false alarm and loud noise fines. Grant revenue is dependent on the timing of the expenditure and does not flow ratably over the course of the year. Grant Revenue for 2013 is down from 2012 as a result of timing on the reimbursement of grants and fewer grants available in 2013. Other Income for 2013 compared to 2012 is down to the timing of reciept of annual rent reimbursement for the ATF office in 2012. The increase in Supplies over 2012 is due to $88,355 purchase of In Car Videos in 2013. This purchase will be reimbursed by a grant. Explain Significant Spending on Capital Projects Below: The $123,119 of Capital is the result of $100,000 which is a portion of the purchase of the armor vechicle and $23,119 is the purchase of Dell VM /Ware Center Server. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Fund /Department Number 227 Month I October Date Updated 1 11/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 19,552 Grants /Intergovernmental 63% - - Charges for Services - - - Interest Earnings 25,000 1,651 15,713 Bond Proceeds - - - Donations - - - Other Income 3,804,857 0% 3,804,857 Transfers In - - - - Total Revenue 3,829,857 1,651 3,820,570 Expenditures - 0% 162.397 83.836 Personnel - - - Supplies 208,000 - - Services 316,033 20,357 120,518 Debt Service - - - Capital 2,152 Transfers Out - - - Total Expenditures 526,185 20,357 120,518 Net 3,303,672 (18,705) 3,700,052 Cash Balance 8,041,613 Staffing Full Time - Part-Time /Season al/Tem porary Total 0 r xpiam aigmricam rtevenue, r= xpenanure ano starring ,- nangesivanances rseiow: Encumbrances include $20K for SB Ethanol Real Estate (neighborhood association taking over pumps), $57,417 to Weaver Boos Consultants for groundwater sampling. Budget for capital are Park & Rec items that should be removed. On 3 Jul the City received a settlement of $3.87 million for litigation from the Oliver brownfield. The Budget balances have been adjusted in July to reflect this activity. The budgeted interest income will also be adjusted accordingly. Largest expenditures to date are Weaver Boos for $31 K for groundwater testing at old Studebaker Museum site (Freeman- Spicer building site; $44K still encumbered) and SIB Ethanol Real Estate LLC for pumping ($14K spent, $12K still encumbered). rxpiam oignincam openaing on t apnai rrojects neiow: No signficant capital projects planned for 2013. There is $2,152 encumbered to reclassed out of Capital. Form 3 0% 0% 0% 0% 0% 19,552 9,287 63% - - 0% - 0% (0) 100% - - 0% 19,552 9,287 100% - - 0% - - 208,000 0% 1,601 83,836 111,679 65% - - - 0% 160,796 2,152 0% - - - 0% 162.397 83.836 1 321.831 1 39% 0 r xpiam aigmricam rtevenue, r= xpenanure ano starring ,- nangesivanances rseiow: Encumbrances include $20K for SB Ethanol Real Estate (neighborhood association taking over pumps), $57,417 to Weaver Boos Consultants for groundwater sampling. Budget for capital are Park & Rec items that should be removed. On 3 Jul the City received a settlement of $3.87 million for litigation from the Oliver brownfield. The Budget balances have been adjusted in July to reflect this activity. The budgeted interest income will also be adjusted accordingly. Largest expenditures to date are Weaver Boos for $31 K for groundwater testing at old Studebaker Museum site (Freeman- Spicer building site; $44K still encumbered) and SIB Ethanol Real Estate LLC for pumping ($14K spent, $12K still encumbered). rxpiam oignincam openaing on t apnai rrojects neiow: No signficant capital projects planned for 2013. There is $2,152 encumbered to reclassed out of Capital. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Public Safety LOIT jMonth I October Fund /Department Number 249 1 Date Updated 11/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - 0% Local Income Taxes 5,892,386 491,032 4,910,322 5,596,212 982,065 83% Other Taxes - - - - - 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 8,000 465 6,442 7,168 1,558 81% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In - 19,451 580,031 175,436 580,031 0% Total Revenue 5,900,386 510,948 5,496,795 5,778,816 403,591 93% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 7,101,757 2,060,536 7,405,038 5,358,400 303,281 104% Total Expenditures 7,101,757 2,060,536 7,405,038 5,358,400 (303,281) 104% Net (1,201,371) (1,549,588) (1,908,243) 420,416 706,872 Cash Balance 1,081,697 2,097,558 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Monies in Fund 249 are transferred quarterly to the General Fund to fund police and fire personnel. A quarterly reconciliaton is prepared and any unspent money is transferred back to Fund 249. For 2014, the City has been advised by the DLGF and SBOA that it should budget personnel costs directly from Fund 249. Fund 249 is budgeted to spend over $1.0 million dollars more than it takes in as revenue during 2013 to support public safety personnel costs. The fourth quarter transfer was made during October, 2013. The third quarter accounting summary and reconciliation was prepared on October 15, 2013. Expenditures are reported as over budget due to the quarterly settlement process whereby additional monies may be transferred to equal expenditures paid for police and fire personnel in the General Fund. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Fund /Department Number 251 Month I October Date Updated 1 11/13/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 1,052,643 90,834 823,273 845,434 229,370 78% Charges for Services - - - - - 0% Interest Earnings 8,500 343 5,576 6,411 2,924 66% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 1,061,143 91,177 828,849 851,845 232,294 78% Expenditures Personnel - - - - - - 0% Supplies 400,000 397,338 - 2,663 100% Services 77,500 7,500 96,500 70,000 100% Debt Service - - - - - 0% Capital 758,424 113 373,874 362,409 81,217 303,333 60% Transfers Out - - - - - - 0% Total Expenditures 1,235,924 113 778,712 458,909 153,879 303,333 75% Net (174,781) 91,065 50,138 392,936 (153,879) (71,039) Cash Balance 1,764,435 1,618,940 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, cxpenonure ano ararring ,- nangesivanances aeiow: The 2013 budget includes $400,000 for paving that will be spent during the summer months. PO 210585 to Walsh & Kelly for the material was encumbered in May. First significant purchases for material in July for $137K. Revenue is provided by state - shared gasoline taxes, which are remitted monthly, -- $90K per month. Lower receipts in Aug and Sep follow the same pattern as in previous years. The $70,000 encumbrance (from 2012) is for RW Armstrong and a traffic signal upgrade study. Engineering has decided not to proceed with the project so the PO will be cancelled in November. Explain Significant Spending on Capital Projects Below: Made final payment to INDOT for Riverside Trail Phase II - $33,453 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Fund /Department Number 252 Month I October Date Updated 1 11/14/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0 4 5,406 (4) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 0 4 5,406 4 0% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 2,276,693 0% Transfers Out - 0% Total Expenditures 2,276,693 0% Net 0 4 (2,271,287) (4) Cash Balance 1,149 1,145 Staffing Full Time - Part-Time /Season al/Tem porary Total r=xpiam aigmricam rtevenue, r= xpenanure ano starring ,- nangesivanances oeiow: In 2009, the City received a one -time $2.9 million distribution for this fund. In 2012, the City spent approximately $2.1 million for portable radios for the both the Police and Fire departments. Money in this fund may only be used for public safety purposes. The final fund balance will be spent during 2014. am oignincam openaing on t apnai rrojects neiow: year, portable radios were purchased for the Police Del no Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant JMonth I October Fund /Department Number 258 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 199,000 833 144,150 140,760 54,850 72% Charges for Services - - - - - 0% Interest Earnings 2,100 98 1,407 2,017 693 67% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 36,150 (8,695) 29,905 19,409 6,245 83% Transfers In - - - - 0% Total Revenue 237,250 7,764 175,462 162,186 61,788 74% Expenditures Personnel 105,514 8,142 89,596 85,180 - 15,918 85% Supplies 4,668 494 1,723 1,961 204 2,741 41% Services 117,248 14,251 68,422 52,517 4,615 44,211 62% Debt Service - - - - - - 0% Capital 1,500 304 1,729 1,196 20% Transfers Out - - - - - - 0% Total Expenditures 228,930 22,887 160,045 141,388 4,819 1 64,066 1 72% Net 8,320 (30,651) 15,417 20,797 (4,819) (2,278) Cash Balance 501,582 490,562 Staffing Full Time 2.00 2.00 2.00 Part-Time /Season al/Tem porary - - - Total 2.00 2.00 2.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The Human Rights Federal Grant Fund contains separate departments for EEOC and HUD grants. Revenue higher this year due to timing of receipts. This same time last year, the Human Rights received grant money in the amount of $20,000 to continue to promote awareness of fair housing and fair employment. Expenditures are higher this year with the addition of the new grant money. Explain Significant Spending on Capital Projects Below: A drop down projector and large screen TV has been budgete in capital for the conference room in the new Human Rights building. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Fund /Department Number 271 Month I October Date Updated 1 11/18/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 100 4 41 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 100 4 41 Expenditures (0) 100% Personnel - - - Supplies 346 0% Services - 0% Debt Service 0% Capital (0) 100% Transfers Out - Total Expenditures 346 - - Net (246) 4 41 Cash Balance 14,367 Staffing Full Time - Part-Time /Season al/Tem porary Total 14.315 rxpiam aigmncam Kevenue, r-xpenonure ano ararnng ,- nangesivanances aeiow: This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In past years there have been no races. rncam apenaing on t apnai r-rojecis neiow: Form 3 0% 0% 0% 0% 0% 87 59 41% - - 0% 0% 0% 0% 87 59 41% - - - 0% 8,009 346 (0) 100% - - - 0% 0% 0% 0% 8,009 346 (0) 100% 7.9221 (3461 59 14.315 rxpiam aigmncam Kevenue, r-xpenonure ano ararnng ,- nangesivanances aeiow: This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In past years there have been no races. rncam apenaing on t apnai r-rojecis neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month I October Fund /Department Number 273 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 8,000 854 5,647 1,844 2,353 71% Interest Earnings 100 6 85 108 15 85% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 8,100 860 5,732 1,952 2,368 71% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 10,149 886 7,137 754 2,258 78% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 10,149 886 7,137 - 754 2,258 78% Net (2,049) (26) (1,405) 1,952 (754)1 110 Cash Balance 27,358 25,676 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The Morris Performance Arts Center and Palais Royale Marketing Fund was established as a separate non - reverting fund to receive monies from the solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marqee sponsorships; and to accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale. The funds in this account at the end of the fiscal year shall not revert to the general fund. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Fund /Department Number 280 Month I October Date Updated 1 11/20/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes - 0% Grants /Intergovernmental 185,000 0% Charges for Services - - - Interest Earnings 300 1 12 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 185,300 1 12 Expenditures 45,000 0% Personnel - - - Supplies 45,000 0% Services 40,000 0% Debt Service - 0% Capital 100,000 0% Transfers Out - Total Expenditures 185,000 - - Net 300 1 12 Cash Balance 3,816 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Revenue and Expenditures for 2013 will depend on completion of grant related acitivty for remaining open grants. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 185,000 0% - - 0% 457 288 4% - - 0% - 0% 222 0% - 0% 679 185,288 0% - - 0% 45,000 0% 40,000 0% - - 0% 124,539 100,000 0% - - 0% 124,539 185,000 0% 123.8601 288 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Revenue and Expenditures for 2013 will depend on completion of grant related acitivty for remaining open grants. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Fund /Department Number 281 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 100 6 83 119 17 83% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 100 6 83 119 17 83% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 27,102 27,102 0% Total Expenditures 27,102 27,102 0% Net (27,002) 6 83 119 (27,085) Cash Balance 27,118 27,020 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Fund to be used only for the expenses of EDC revenue bonds. Fund to be closed during 2013. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name I HAZMAT JMonth I October Fund /Department Number 289 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 3,000 - 16,722 - (13,722) 557% Interest Earnings - 3 34 11 (34) 0% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 3,000 3 16,756 11 13,756 559% Expenditures Personnel - - - - - - 0% Supplies 1,990 (1,990) 0% Services - 0% Debt Service - - 0% Capital 3,500 3,237 263 92% Transfers Out - - - - 0% Total Expenditures 3,500 - 3,237 - 1,990 1 (1,727) 149% Net (500) 3 13,519 11 (1,990) (12,029) Cash Balance 16,201 2,681 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Charges for Service for HAZ -MAT responses. By ordinance the South Bend Fire Department charges business for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund, responses are made by firefighters of the South Bend Fire Department. Explain Significant Spending on Capital Projects Below: No major capital expenditures are planned through this fund. Major purchases are funded through the Fire Department and EMS Capital and the minimal fees collected in this fund are used to replace equipment and gear used in responses. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Indiana River Rescue Fund /Department Number 291 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes (34,400) 210% 345 Grants /Intergovernmental - - - Charges for Services 31,300 1,500 65,700 Interest Earnings 200 21 331 Bond Proceeds - - - Donations - 493 75% Other Income (705) 102% 4,625 1,882 Transfers In - - - Total Revenue 31,500 1,521 66,031 Expenditures 0% 14.770 2.182 Personnel 2,000 - 1,507 Supplies 35,666 344 36,071 Services 24,700 4,826 21,660 Debt Service - - - Capital 29,760 27,460 Transfers Out - - - Total Expenditures 92,126 5,170 86,698 Net (60,626) (3,649) (20,667) Cash Balance 98,753 Staffing Full Time - Part-Time /Season al/Tem porary Total 121 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: No staffing associated with this fund. The fund collects tuition fees for students attending the Indiana River Rescue School. There are typically 2 -4 schools a year, each a week in duration. Explain Significant Spending on Capital Projects Below: Purchased a new tow vehicle for Indiana River Rescue School Trailer at a cost of $27,460. Fund also maintains and replaces boats, motors and equipment as needed. Form 3 0% 0% 0% 0% 64,500 (34,400) 210% 345 (131) 166% - - 0% 0% 0% 0% 64,845 34,531 210% - 493 75% 8,096 300 (705) 102% 4,625 1,882 1,158 95% - - - 0% 2,049 2,300 92% 0% 14.770 2.182 3.246 96% 121 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: No staffing associated with this fund. The fund collects tuition fees for students attending the Indiana River Rescue School. There are typically 2 -4 schools a year, each a week in duration. Explain Significant Spending on Capital Projects Below: Purchased a new tow vehicle for Indiana River Rescue School Trailer at a cost of $27,460. Fund also maintains and replaces boats, motors and equipment as needed. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Fund /Department Number 292 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 110,000 38,532 97,000 71,468 35% Charges for Services - - - - 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 110,000 38,532 97,000 71,468 35% Expenditures Personnel - - - - 0% Supplies - 36,911 (36,911) 0% Services 10,000 - 10,000 0% Debt Service - - - 0% Capital 100,000 19,450 80,550 19% Transfers Out - - - - 0% Total Expenditures 110,000 36,911 19,450T 53,639 51% Net 1,621 97,000 (19,450)1 17,829 Cash Balance 99,746 98,125 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Change in cash balance is due to the timing of receipts for grant expenditures. The $36,911 Supplies amount is for the purchase of computer software and maintenance for police car communication. Funding from a Federal Grant was received in July. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Fund /Department Number 294 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 26,000 - 20,045 12,170 5,955 77% Interest Earnings - 15 243 358 (243) 0% Bond Proceeds - - - - 0% Donations - - - 0% Other Income 2,500 1,253 2,500 0% Transfers In - - - - - 0% Total Revenue 28,500 15 20,288 13,781 8,212 71% Expenditures Personnel - - - - - 0% Supplies 1,500 98 169 156 1,331 11% Services 27,000 6,493 25,633 12,812 1,367 95% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 28,500 6,591 25,802 12,969 2,698 91% Net - (6,576) (5,514) 812 5,514 Cash Balance 68,301 77,175 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This fund was established to fund the cost of course material and instructors at the South Bend Police Academy. The enforcement courses are offered to other police departments who pay a fee to attend the training. Increase in Revenue over 2012 is due to additional tuition received for attendance at instruction offered at the SBPD Academy. The increase in expenditures in 2013 over 2012 was due to the cost of offering a course for officers that will be assigned to train new officers. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Fund /Department Number 295 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% - Local Income Taxes 15,000 0% Other Taxes 0% 440 Grants /Intergovernmental 93% - - Charges for Services - - - Interest Earnings 350 21 326 Bond Proceeds - - - Donations 3,250 - 250 Other Income 38,000 1,080 9,144 Transfers In - - - Total Revenue 41,600 1,101 9,720 Expenditures - 0% 36,332 360 Personnel - - - Supplies 14,030 (162) 3,320 Services 16,875 1,150 9,161 Debt Service 500 - - Capital 10,575 Transfers Out - - - Total Expenditures 41,980 988 12,481 Net (380) 113 (2,761) Cash Balance 104,527 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds received from the grants along with impound towing fees. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% - 0% 15,000 0% - 0% 440 24 93% - - 0% 2,640 3,000 8% 9,078 28,856 24% - - 0% 27,158 31,880 23% - - - 0% 6,105 360 10,350 26% 10,227 - 7,714 54% - 500 0% 20,000 10,575 0% - - - 0% 36,332 360 29,139 31% (9,174) (360)1 2,741 96.723 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds received from the grants along with impound towing fees. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Fund /Department Number 299 Month I October Date Updated 1 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 100,000 13,224 138,986 59,707 (38,986) 139% Charges for Services - - - - - 0% Interest Earnings 1,000 78 776 767 224 78% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 1,000 32,793 20,197 (31,793) 3279% Transfers In - - - - 0% Total Revenue 102,000 13,302 172,555 80,671 70,555 169% Expenditures Personnel - - - - - - 0% Supplies 60,867 41,233 29,727 10,404 9,230 85% Services 45,000 10,454 24,481 - 34,546 23% Debt Service - - - - - 0% Capital 82,706 1,113 67,058 25,571 15,648 81% Transfers Out - - - - - 0% Total Expenditures 188,573 1,113 118,745 79,779 10,404T 59,424 68% Net (86,573) 12,189 53,810 892 (10,404) (129,979) Cash Balance 389,150 312,152 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This fund was established to receive the Police Department share of money acquired in drug enforcement activity. The $23,018 of Other Income is grant reimbursement for the purchase of the bomb suit acquired by the police department. Expenditures are to be used to fund drug enforcement and training. Explain Significant Spending on Capital Projects Below: The $67,058 of capital includes $62,706 which is the balance of the $162,706 purchase of the SWAT vechicle. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax JMonth I October Fund /Department Number 404 1 Date Updated 11/15/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - 0% Local Income Taxes 7,846,940 653,912 6,539,116 7,329,312 1,307,824 83% Other Taxes - - - - - 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 80,000 2,957 44,719 61,287 35,281 56% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 805,932 91,400 482,062 662,575 323,870 60% Transfers In - - - - - 0% Total Revenue 8,732,872 748,269 7,065,897 8,053,173 1,666,975 81% Expenditures Personnel - - - - - 0% Supplies 1,476,918 96,544 939,018 17,830 5,156 532,743 64% Services 4,277,887 345,739 3,636,123 2,874,730 124,523 517,240 88% Debt Service 2,178,168 3,513 2,014,088 2,075,244 - 164,080 92% Capital 833,562 - 253,626 1,777,177 107,505 472,431 43% Transfers Out 676,882 - 676,882 874,472 - - 100% Total Expenditures 9,443,417 445,795 7,519,738 7,619,454 237,185 1 1,686,494 82% N et (710,545) 302,473 (453,842) 433,720 (237,185) (19,518) Cash Balance 14,873,161 14,641,164 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Significant revenue increase in 2013, due to the City receiving approximately $136,000 more per month in COIT distribution than in the prior year. The 2013 amended budget is negative because it includes $680,993 in encumbrances at 12/31/12 for projects that were in process. Supplies category shows huge variance (approx. $921,188) as a result of gasoline being budgeted in this fund for 2013. This was not in place in the prior year. For 2013, COIT distribtutions from the County are $653,911.59 per month and are paid through September 30, 2013. The amount shown as Transfers Out of $676,882 is for the curb and sidewalk program. The amount is transferred to the MVH fund 202. Explain Significant Spending on Capital Projects Below: At this same time in October, there was roughly $1.5 million more spent in 2012. Projects include the Northside Trail and the Greenhouse Conservatory which have since been completed. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax IMonth I October Fund /Department Number 408 1 Date Updated 1 11/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - 0% Local Income Taxes 8,177,352 681,446 6,814,460 7,681,347 1,362,892 83% Other Taxes - - - - - 0% Grants /Intergovernmental - - 0% Charges for Services - - 300 - (300) 0% Interest Earnings 50,000 1,871 29,448 40,676 20,552 59% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 504,660 424,325 409,160 80,335 84% Transfers In - - - - - 0% Total Revenue 8,732,012 683,317 7,268,533 8,131,183 1,463,479 83% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 2,658,175 150,185 1,732,069 1,370,281 397,197 528,909 80% Debt Service 1,913,214 - 1,403,876 1,574,062 - 509,338 73% Capital 4,471 - 22,918 4,471 0% Transfers Out 4,417,519 - 3,988,139 4,767,146 - 429,380 90% Total Expenditures 8,993,379 150,185 7,124,085 7,734,407 397,197 1,472,097 84% Net (261,367) 533,132 144,448 396,776 (397,197) (8,618) Cash Balance 10,128.860 8,777.036 atti ng Full Time Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, cxpenonure ano ararrmg %,nangesivanances aeiow: Included in the 2013 Transfers Out budget is a $2,700,000 transfer to the MVH Fund 202 for costs of the Street Department. A total of $1,350,000 (50 %) was transferred in April, 2013 and $1,350,000 during July, 2013. This fund also pays debt service for the CEDIT and Morris Performing Arts Center bonds and these bond payments are due in February and July. The 2013 amended budget is negative because in includes $302,741 in encumbrances carried over from 2012 for projects in process at 12/31/12. EDIT tax revenue is received monthly from St. Joseph County as certified by the DLGF. A target penalty fee in the amount of $354,660 was received from TJX Corporation (AJ Wright) in April, 2013. EDIT revenue during 2012 includes $743,906.84 received from the State of Indiana due to a 2011 accounting error. EDIT revenue from the State is $681,445.98 per month and is paid through October, 2013. A total of $1,288,139 has been transferred to the DCI Administration Fund 211. This represents three quarterly payments. All debt service payments have been made for 2013. Explain Significant Spending on Capital Projects Below: Capital spending in 2012 in the amount of $22,918 was for the CSO Trunk Sewer project before the project was discontinued. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Fund /Department Number 410 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 142 0% 884 Grants /Intergovernmental - - - Charges for Services 142 - - Interest Earnings 1,405 6 85 Bond Proceeds - - - Donations - - - Other Income 68,557 125 3,614 Transfers In - - - Total Revenue 70,104 131 3,699 Expenditures - 0% 200,451 Personnel - - - Supplies 194.6291 1201.741) Services - Debt Service 268,146 Capital - Transfers Out - Total Expenditures 268,146 - - Net (198,042) 131 3,699 Cash Balance 27,452 Staffing Full Time - Part-Time /Season al/Tem porary Total 21.907 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: The 2013 amended budget is negative because it includes $268,146 in principal payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 0% - 142 0% 884 1,320 6% - - 0% - - 0% 4,938 64,943 5% - - 0% 5,822 66,405 5% - - 0% 0% 0% 200,451 268,146 0% - - 0% - - 0% 200,451 268,146 0% 194.6291 1201.741) 21.907 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg -nangesivariances aeiow: The 2013 amended budget is negative because it includes $268,146 in principal payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf IMonth I October Fund /Department Number 655 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 429,000 36,337 360,571 357,125 68,429 84% Interest Earnings 2,700 179 2,574 3,774 126 95% Bond Proceeds - - - 0% Donations - - 0% Other Income 0% Transfers In - - - 0% Total Revenue 431,700 36,516 363,144 360,900 68,556 84% Expenditures Personnel 64,378 28 1,201 247 63,177 2% Supplies 7,432 54 401 1,158 6,946 85 99% Services 67,756 4,675 26,955 29,559 40,801 40% Debt Service 42,499 23,238 19,261 55% Capital - - 0% Transfers Out 250,000 250,000 247,180 - 100% Total Expenditures 432,065 4,757 301,795 278,144 6,946 123,324 71% Net (365) 31,759 61,349 82,756 (6,946) (54,768) Cash Balance 922,835 850,766 Staffing Full Time - Part-Time /Season al/Tem porary 2.16 2.00 2.00 Total 2.16 2.00 2.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Program began on October 28, 2013 and will continue (weather permitting) through the end of the first week in December. Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Fund /Department Number 705 Month I October Date Updated 1 11/19/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 4 60% Grants /Intergovernmental 0% 1,990 Charges for Services - - - Interest Earnings 10 0 6 Bond Proceeds - - - Donations 1,990 - Other Income - 1 Transfers In - - - Total Revenue 2,000 0 7 Expenditures !71 Personnel - - - Supplies - Services 2,000 Debt Service - Capital Transfers Out - Total Expenditures 2,000 - - Net - 0 7 Cash Balance 1,937 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: rncam apenaing on t apnai rrojects neiow: 10 10 356 1.930 Form 3 0% 0% 0% 0% 0% 4 60% - 0% 1,990 0% (1) 0% - 0% 1,993 0% - 0% - 0% 2,000 0% - 0% 0% 0% 2,000 0% !71 Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service IMonth I October Fund /Department Number 313 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 1,118,460 693,822 622,017 424,638 62% Local Income Taxes - - - - 0% Other Taxes 67,861 - 33,662 40,096 34,199 50% Grants /Intergovernmental 71,468 5,956 59,557 77,533 11,911 83% Charges for Services - - - - - 0% Interest Earnings 0% Bond Proceeds 0% Donations 0% Other Income 5,900 0% Transfers In - - - - 0% Total Revenue 1,257,789 5,956 787,041 745,546 470,748 63% Expenditures Personnel - - - - - 0% Supplies 0% Services - - - 0% Debt Service 1,268,000 1,268,000 1,330,465 100% Capital - - - 0% Transfers Out - - - 0% Total Expenditures 1,268,000 1,268,000 1,330,465 100% Net (10,211) 5,956 (480,959) (584,919) 470,748 Cash Balance 96,414 13,701 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund is used to collect a separate property tax levy (distributions received in June and December) and is used to pay debt service on the former College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will typically have a negative cash balance until the property tax distributions are received. PILOT taxes paid by the utilities are received monthly in this fund. Property taxes received in the amount of $693,822.13 during June, 2013 eliminated the negative cash balance in this fund. The property tax collections of $693,822.13 represented 51.73% of the levy amount and 62.03% of the 2013 budgeted revenue amount. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. Both debt service payments have been made for 2013. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Im rov. JMonth I October Fund /Department Number 288 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 155,084 - - 155,084 0% Charges for Services 2,764,000 325,292 2,528,956 1,928,447 235,044 91% Interest Earnings 20,000 637 15,407 26,911 4,593 77% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 48,000 2,690 17,250 50,370 30,750 36% Transfers In - - - - - 0% Total Revenue 2,987,084 328,619 2,561,613 2,005,728 425,471 86% Expenditures Personnel - - - - - - 0% Supplies 193,539 197,083 46,120 12,573 (16,117) 108% Services 1,125,768 (2,618,260) 8,550 72,660 4,568,890 (3,451,672) 407% Debt Service 1,190,596 - 40,667 57,200 - 1,149,929 1% Capital 7,568,260 2,914,805 4,263,224 556,066 49,789 3,255,247 0% Transfers Out 1,000,000 - 500,000 1,000,000 - 500,000 50% Total Expenditures 11,078,163 296,545 5,009,524 1,732,046 4,631,252 1,437,387 87% Net (8,091,079) 32,074 (2,447,911) 273,682 (4,631,252) (1,011,916) Cash Balance 3,101,927 5,798,292 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The revenues in this account are generated through user fees for the South Bend Fire Department EMS division. These funds are used for capital purchases such as fire trucks, ambulances and major construction projects. There are no employees associated with this fund. Incurring project expenses for construction of Fire Training Facility and Fire Station 5 which will be reimbursed through bond. Explain Significant Spending on Capital Projects Below: Construction Bond approved to continue and complete Construction of a replacement fire Station 5 demolishing and rebuilding on it's existing site. Station placed back in service on September 30th. Fire Training Facility Construction Continues at High and Sample Streets. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development IMonth I October Fund /Department Number 377 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes - - - 448,389 - 0% Grants /Intergovernmental 600,000 83,683 446,478 601,012 153,522 74% Charges for Services - - - - - 0% Interest Earnings 6,500 124 2,494 4,511 4,006 38% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 81,301 77,851 88,023 3,450 96% Transfers In - - - - - 0% Total Revenue 687,801 83,807 526,823 1,141,935 160,978 77% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 776,671 776,470 776,408 201 100% Capital - - - - 0% Transfers Out 100,000 100,000 507,627 - 100% Total Expenditures 876,671 - 876,470 1,284,035 201 100% Net (188,870) 83,807 (349,647) (142,100) 160,777 Cash Balance 691,176 960,320 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Effective January 1, 2013, this fund no longer collects hotel /motel tax allocations from St. Joseph County for payment to the Hall of Fame. This fund is currenty used for debt the 2010 Coveleski Stadium bonds (payments due in January and July) and a $100,000 capital transfer to Century Center (paid in January, 2013). PSDA tax revenue is generally received from the State on a monthly basis. PSDA tax is a special tax received from the State of Indiana based on the sales tax, income tax and local income taxes collected in the PSDA area (which includes Coveleski Stadium, Century Center, Morris Performing Arts Center and Studebaker National Museum). Coveleski Stadium generates the majority of PSDA revenue. Both debt service payments have been made for 2013. The final debt service payment on the 2010 Coveleski Stadium bonds is January 15, 2013. The outsanding principal balance on the bonds is $3,520,000 at October 31, 2013. Explain Significant Spending on Capital Projects Below: A $100,000 transfer is made annually to the Century Center Capital Fund 671. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Fund /Department Number 401 Month I October Date Updated 1 11/18/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 500 6 82 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 500 6 82 Expenditures (0) 100% Personnel - - - Supplies 2,002 0% Services 1,538 0% Debt Service - 0% Capital (0) 100% Transfers Out - Total Expenditures 3,540 - - Net (3,040) 6 82 Cash Balance 26,840 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aignmcam Kevenue, r-xpenaiture ano acarnng i,nangesivanances aeiow: Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. rncam apenaing on t apnai r-rojecis neiow: 741 Form 3 0% 0% 0% 0% 0% 310 418 16% - - 0% 0% 0% 0% 310 418 16% - - - 0% 4,985 2,002 (0) 100% 33,462 1,538 - 100% - - 0% 17,715 0% - - 0% 56,162 3,540 (0) 100% 55.8531 (3.5401 418 rxpiam aignmcam Kevenue, r-xpenaiture ano acarnng i,nangesivanances aeiow: Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. rncam apenaing on t apnai r-rojecis neiow: 741 Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment jMonth I October Fund /Department Number 403 1 Date Updated 11/18/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 200 10 150 185 50 75% Bond Proceeds - - - - - 0% Donations 2,700 13,000 2,700 0% Other Income - - - 0% Transfers In - - - - - 0% Total Revenue 2,900 10 150 13,185 2,750 5% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - - - 0% Net 2,900 10 150 13,185 2,750 Cash Balance 48,996 48,820 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances 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 2013 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Fund /Department Number 405 Month I October Date Updated 1 11/18/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes (1,045) 135% 1,627 Grants /Intergovernmental - - - Charges for Services 3,000 40 4,045 Interest Earnings 2,200 74 1,264 Bond Proceeds - - - Donations - - - - Other Income - 839% 13,405 Transfers In 198,300 - - Total Revenue 203,500 114 18,715 Expenditures - 0% 172.493 24.287 Personnel - - - Supplies 13,816 25,325 91,860 Services - 6,510 6,550 Debt Service - - - Capital 203,500 24,731 Transfers Out - - - Total Expenditures 217,316 31,835 123,141 Net (13,816) (31,721) (104,426) Cash Balance 387,959 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam oigmricanr mevenue, cxpenonure ano ararrmg i,nangesivanances aeiow: The cash balance includes $60,300 that is restricted to expenditures in Voorde Park. a 1 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 0% 0% 0% 0% 3,117 (1,045) 135% 1,627 936 57% - - 0% - 0% 13,043 (13,405) 0% - 198,300 0% 17,786 184,785 9% - - - 0% 44,965 23,987 (102,031) 839% 12,735 300 (6,850) 0% - - - 0% 114,793 178,769 12% - - - 0% 172.493 24.287 1 69.888 1 68% a 1 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 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development IMonth I October Fund /Department Number 406 1 Date Updated 11/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 530,000 253,553 284,256 276,447 48% Local Income Taxes - - - - 0% Other Taxes 34,271 19,926 20,445 14,345 58% Grants /Intergovernmental - - - - 0% Charges for Services - - - - - 0% Interest Earnings 4,000 156 2,444 3,343 1,556 61% Bond Proceeds - - - - 0% Donations - - - - - 0% Other Income 46,054 3,838 38,590 36,473 7,464 84% Transfers In - - - - - 0% Total Revenue 614,325 3,994 314,514 344,517 299,811 51% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 504 42 420 530 84 83% Debt Service 874,716 - 409,343 273,617 465,373 47% Capital 36,000 - 19,364 36,000 0% Transfers Out - - - - - 0% Total Expenditures 911,220 42 409,763 293,511 501,457 45% Net (296,895) 3,952 (95,249) 51,006 (201,646) Cash Balance 740,520 873,236 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund receives revenue from a property tax levy and 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. Property tax revenue in the amount of $253,553 was received on June 18, 2013. This amount represents 51.73% of the tax levy and 47.84% of the 2013 revenue budget. For the 2014 budget, this fund will be used to pay existing police capital lease payments but will not include a capital lease for 2014. This payment will be moved to the COIT Fund No. 404. Explain Significant Spending on Capital Projects Below: The 2013 budget includes $36,000 for three street crime (SOS) vehicles and various leased vehicles. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement IMonth I October Fund /Department Number 407 1 Date Updated 11/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 150,000 150,000 150,000 - 100% Grants /Intergovernmental 258,990 129,108 126,415 129,882 50% Charges for Services - - - 25,000 - 0% Interest Earnings 100 4 109 15 (9) 109% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 25,000 25,000 5,900 100% Transfers In - - - - 0% Total Revenue 434,090 4 304,217 307,331 129,873 70% Expenditures Personnel - - - - - 0% Supplies 0% Services - - - 0% Debt Service 367,575 367,575 402,277 100% Capital - - - 0% Transfers Out - - - 0% Total Expenditures 367,575 - 367,575 402,277 100% Net 66,515 4 (63,358) (94,946) 129,873 Cash Balance 34,363 (44,187) Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Revenue is this fund includes $150,000 in hotel /motel taxes and $258,990 in cigarette taxes from other units of government. The hotel /motel tax distribution is usually received in July or August and the cigarette tax allocation is usually received in June and December. In 2013, this fund is used to pay 75% of the 2011 Century Center Refunding bonds (paid 100% in 2012). Payments on the Century Center bond are due in February and July. Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year. Cigarette tax revenue in the amount of $129,108.07 was received on June 10, 2013, which is approximately 50% of the 2013 budgeted revenue amount. The hotel /motel tax amount of $150,000 was received on July 24, 2013. Both debt service payments have been made for 2013. Explain Significant Spending on Capital Projects Below: None Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction JMonth I October Fund /Department Number 412 1 Date Updated 11/13/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 54,000 1,461 23,571 40,058 30,429 44% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 474,662 278,773 82,884 195,889 59% Transfers In - - - - - 0% Total Revenue 528,662 1,461 302,344 122,942 226,318 57% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 3,395,846 63,704 1,134,683 584,601 1,162,080 1,099,082 68% Transfers Out - - - - - - 0% Total Expenditures 3,395,846 63,704 1,134,683 584,601 1,162,080 1 1,099,082 1 68% Net (2,867,184) (62,243) (832,339) (461,659) (1,162,080) (872,764) Cash Balance 7,064,357 8,862,696 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Initial funding for the Major Moves fund in the amount of $12,823,151 was received from the State of Indiana on September 15, 2006. The money was derived from the State lease of the 1 -80 tollroad to a private company. This fund has been used in the past to provide seed money for economic development projects at Douglas Road, Eddy Street Commons, and the Triangle Development near Notre Dame. The amounts advanced for these projects are being repaid by the respective tax increment financing (TIF) funds as per formal amortization schedules. The amounts outstanding were $1,183,567 (Fund 435 - Douglas Road) and $7,253,926 (Fund 436 - Eddy Street /Triangle) at October 31, 2013. Explain Significant Spending on Capital Projects Below: DLZ for Olive /Sample Overpass: 377,122 DLZ for 2 -way streets feasibility: 130,963 HRP for Triangle neighborhood: 53,196 INDOT US 31 Utility Relocation $573,335 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Fund /Department Number 416 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 31,833 68% 1,791 Grants /Intergovernmental - - - Charges for Services 100,000 3,422 68,167 Interest Earnings 1,500 87 1,253 Bond Proceeds - - - Donations - - - 0% Other Income 11,868 53% 10,061 4,266 Transfers In - - - Total Revenue 101,500 3,509 69,420 Expenditures - 0% 164,611 17,605 Personnel - - - Supplies 25,500 15.202 10,411 Services 20,970 11,945 Debt Service - - Capital 26,196 15,828 Transfers Out - - Total Expenditures 72,666 - 38,184 Net 28,834 3,509 31,237 Cash Balance 427,504 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: 381 rxpiam oignincam openaing on t apnai rrojects neiow: During 2012, Fund 416 was used to pay for major upgrades throughout the building: replaced all of the windows floor) and Rotunda / Mezzanine (second floor), remodeled Restrooms at the Bistro level. Form 3 0% 0% 0% 0% 63,514 31,833 68% 1,791 247 84% - - 0% 0% 0% 0% 65,306 32,080 68% - - - 0% 6,274 3,221 11,868 53% 10,061 4,266 4,759 77% - - - 0% 148,276 10,118 250 99% - - - 0% 164,611 17,605 1 16,877 77% (99.305) (17.605) 15.202 381 rxpiam oignincam openaing on t apnai rrojects neiow: During 2012, Fund 416 was used to pay for major upgrades throughout the building: replaced all of the windows floor) and Rotunda / Mezzanine (second floor), remodeled Restrooms at the Bistro level. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Fund /Department Number 434 Month I October Date Updated 1 11/14/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes - 0% Other Taxes 650,000 0% Grants /Intergovernmental - 0% Charges for Services - - - Interest Earnings 1,000 (36) 418 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 651,000 36 418 Expenditures 0% Personnel - - - Supplies 100% Services - - Debt Service 873,949 873,949 Capital - - Transfers Out - - Total Expenditures 873,949 - 873,949 Net (222,949) (36) (873,531) Cash Balance (649,944) Staffing Full Time Part-Time /Season al/Tem porary Total rxpiam aigmricanr mevenue, r-xpenairure ano ararrmg ,- nangesivanances aeiow: Variance relates to change in interest cost on amortization schedule. Revenue not expected until October or November. Principal payment made in August. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 650,000 0% - 0% - - 0% 1,035 582 42% - - 0% 0% 0% 0% 1,035 650,582 0% - - 0% 0% - 0% 878,554 100% - 0% - 0% 878,554 100% R77.5191 Arm ;R2 rxpiam aigmricanr mevenue, r-xpenairure ano ararrmg ,- nangesivanances aeiow: Variance relates to change in interest cost on amortization schedule. Revenue not expected until October or November. Principal payment made in August. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Fund /Department Number 450 Month I October Date Updated 1 10/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 125 14 189 217 (64) 151% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 16,000 1,673 13,090 10,981 2,910 82% Transfers In - - - - - 0% Total Revenue 16,125 1,687 13,279 11,198 2,846 82% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 0% Total Expenditures - - - 0% Net 16,125 1,687 13,279 11,198 2,846 Cash Balance 71,583 57,389 Staffing Full Time N/A N/A N/A Part-Time /Season al/Tem porary N/A N/A N/A Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. Additional appropriation request of $21,000 for interior /exterior repair to be submitted in Nov 2013. rncanr apenaing on t apnai r-rojecrs neiow: ending in this fund. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Fund /Department Number 677 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 4,500 139 2,168 3,518 2,332 48% Bond Proceeds - - - - - 0% Donations - - - 0% Other Income 42 115,286 (42) 0% Transfers In - - - - - 0% Total Revenue 4,500 139 2,210 118,804 2,290 49% Expenditures Personnel - - - - - 0% Supplies 15,000 92 3,215 1,416 11,785 21% Services 164,322 3,054 49,133 271,643 115,189 30% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 179,322 3,146 52,348 273,059 126,974 29% Net (174,822) (3,007) (50,138) (154,255) (124,684) Cash Balance 668,948 720,197 Staffing Full Time - Part-Time /Season al/Tem porary Total r xpiam aigmricam rtevenue, r= xpenanure ano starring ,- nangesivanances rseiow: The Hall of Fame Capital fund covers maintenance and 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. rncam apenaing on t apnai rrojects neiow: penditures budgeted for 2013. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Department Fund /Department Number 600 Month I October Date Updated 1 11/13/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 333,491 71% 281 Grants /Intergovernmental - - - Charges for Services 1,147,035 92,419 813,544 Interest Earnings 1,000 38 598 Bond Proceeds - - - Donations 653,053 12,650 215,486 - Other Income 1,542 96% 2,287 Transfers In - - - Total Revenue 1,148,035 92,457 816,429 Expenditures - 0% 744,518 24,710 Personnel 957,635 69,484 729,499 Supplies 40,579 1,596 32,236 Services 105,031 5,395 60,290 Debt Service 16,707 12,334 Capital 28,200 - - Transfers Out - - - Total Expenditures 1,148,152 76,475 834,359 Net (117) 15,982 (17,930) Cash Balance 186,307 Staffing Full Time 15.00 14.00 14.00 Part-Time /Season al/Tem porary - - - Total 15.00 14.00 14.00 Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: 191 rxpiam oignincam openaing on t apnai rrofects neiow: The Capital Accounts are set up for a new copier for the office and Ipads with software to get the Inspectors computerized and eliminate par However, it will not be reflected in the Capital Accounts; but in leases and supplies accounts, which is shown in our increase in supplies and services. Form 3 0% 0% 0% 0% 817,033 333,491 71% 281 402 60% - - 0% - 0% 11,523 (2,287) 0% - - 0% 828,837 331,606 71% 653,053 12,650 215,486 77% 21,419 6,801 1,542 96% 63,522 5,259 39,482 62% 6,524 - 4,373 74% - 28,200 0% - - 0% 744,518 24,710 289,083 75% 84.319 (24.710)1 42.523 191 rxpiam oignincam openaing on t apnai rrofects neiow: The Capital Accounts are set up for a new copier for the office and Ipads with software to get the Inspectors computerized and eliminate par However, it will not be reflected in the Capital Accounts; but in leases and supplies accounts, which is shown in our increase in supplies and services. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages JMonth I October Fund /Department Number 601 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 943,905 70,130 713,657 704,943 230,248 76% Interest Earnings 4,000 190 2,621 3,694 1,379 66% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 111,034 10,718 112,464 96,814 (1,430) 101% Transfers In - - - - - 0% Total Revenue 1,058,939 81,038 828,742 805,451 230,197 78% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 688,645 83,826 557,356 518,496 2,227 129,062 81% Debt Service - - - - - - 0% Capital 441,194 10,138 167,771 403,317 244,981 28,442 94% Transfers Out - - - - - - 0% Total Expenditures 1,129,839 93,964 725,127 921,813 247,208 1 157,504 1 86% Net (70,900) (12,926) 103,615 (116,362) (247,208)1 72,693 Cash Balance 959,058 798,529 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Last year's capital projects were:upgrade automation in garages. 2013 projects are: upgrade lighting; new signage; trash receptacles; and membrane sealant updates. 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: Lighting project underway. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations JMonth I October Fund /Department Number 610 1 Date Updated 11/7/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 4,815,830 407,882 4,060,553 3,999,945 755,277 84% Interest Earnings 6,000 158 2,701 4,864 3,299 45% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 435,871 70,191 467,895 34,846 (32,024) 107% Transfers In - - - - - 0% Total Revenue 5,257,701 478,231 4,531,149 4,039,655 726,552 86% Expenditures Personnel 1,661,801 118,955 1,410,108 1,293,442 1,412 250,281 85% Supplies 337,565 20,000 304,182 217,935 1,231 32,152 90% Services 2,864,557 238,472 2,327,863 2,527,834 293,591 243,103 92% Debt Service - - - - - 0% Capital - - - - 0% Transfers Out 784,061 - 830,239 259,200 46,178 106% Total Expenditures 5,647,984 377,426 4,872,391 4,298,412 296,234 479,359 92% Net (390,283) 100,805 (341,242) (258,757) (296,234) 247,193 Cash Balance 858,737 925,125 Staffing Full Time 28.10 27.10 27.10 Part-Time /Season al/Tem porary 7.00 7.00 7.00 Total 35.10 34.10 34.10 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Revenues have remained flat, yet the major operating costs of payrolls & benefits, fuel, vehicle repairs, landfill tipping fees, and bad debt expenses, have steadily increased. A year -end appropriation has been requested. Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Fund /Department Number 611 Month I October Date Updated 1 11/7/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 200 43 398 Bond Proceeds - - - Donations 0% Other Income - - Transfers In 784,061 - 830,239 Total Revenue 784,261 43 830,637 Expenditures 0% Personnel - - Supplies 130,111 82% Services - - Debt Service 734,061 603,950 Capital 230,000 28,048 Transfers Out - - Total Expenditures 964,061 - 631,998 Net (179,800) 43 198,639 Cash Balance 198,748 Staffing Full Time - Part-Time /Season al/Tem porary Total 254 259 226,331 3,406 717 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Year to date transfers in were higher than originally expected to fund additional Capital purchases. Debt Service payments in 2013 are significantly higher than prior year due to four new trucks, additional containers, and tag readers lease- purchased late in 2012. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 0% 0% (198) 199% - 0% 0% 0% 46,178 106% 46,376 106% 0% 0% 0% - 130,111 82% 24,702 177,250 23% - - 0% rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Year to date transfers in were higher than originally expected to fund additional Capital purchases. Debt Service payments in 2013 are significantly higher than prior year due to four new trucks, additional containers, and tag readers lease- purchased late in 2012. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations IMonth I October Fund /Department Number 620 1 Date Updated 11.12.13 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 14,526,748 1,726,788 12,800,519 13,145,713 1,726,229 88% Interest Earnings 9,000 522 5,329 8,356 3,671 59% Bond Proceeds - - 0% Donations - - 0% Other Income 135,500 5,966 98,660 196,439 36,840 73% Transfers In 16,500 943 12,084 64,652 4,416 73% Total Revenue 14,687,748 1,734,219 12,916,592 13,415,160 1,771,156 88% Expenditures Personnel 4,434,851 311,715 3,479,283 3,431,877 4,201 951,367 79% Supplies 1,107,134 115,452 741,216 607,857 145,097 220,821 80% Services 5,037,006 390,924 3,505,583 2,921,570 191,245 1,340,178 73% Debt Service 58,732 4,304 45,628 47,357 8,607 4,497 92% Capital - - 0% Transfers Out 4,158,224 316,895 3,357,428 4,073,418 - 800,796 81% Total Expenditures 14,795,947 1,139,290 11,129,138 11,082,079 349,150 3,317,659 78% Net (108,199) 594,929 1,787,454 2,333,080 (349,150) (1,546,503) Cash Balance 3,227,346 3,793,930 Staffing Full Time 72.05 66.05 66.05 Part-Time /Season al/Tem porary 3.00 2.50 2.50 Total 75.05 68.55 68.55 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Current year to date services revenue is down by 2.6% compared to same time period in 2012. Prior year metered sales including irrigation was abnornal and was a result of the drought weather conditions. Other income in 2012 was greater due to an exceptional one time refund that was received. Increase in current year supplies is mostly due to items that no longer qualify as capital. Current year services increased overall mainly because of a water leak survey,services for meter installations, and general maintenance repairs. Also, various allocations previously accounted in transfers out is increasing the services category. Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Fund /Department Number 622 Month I October Date Updated 1 11.8.13 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 5,607 Grants /Intergovernmental 88% 638,359 - Charges for Services - - - Interest Earnings 14,000 754 12,379 Bond Proceeds - 1,301,565 1,621 Donations - 0% Other Income 0% 34,850 3,600 Transfers In - Total Revenue 14,000 754 12,379 Expenditures - 0% 999,070 107,194 Personnel - Supplies - (561.287) Services 26,050 - 22,450 Debt Service - Capital 1,190,742 67,500 524,240 Transfers Out - Total Expenditures 1,216,792 67,500 546,690 Net (1,202,792) (66,746) (534,311) Cash Balance 3,611,007 Staffing Full Time - Part-Time /Season al/Tem porary Total 1 r xpiam aignmcam mevenue, r= xpenanure ano atarnng ,- nangesivanances oeiow: Prior year to date revenue is reflective of bond proceeds received from the 2012 Revenue Bonds for previously purchased water meters. Also, the 2012 transfer in revenue is a combination of pay as you go capital transfers and surplus monies transferred in from the operating fund. The variance in cash balance is due to a $2,300,000 transfer in of surplus monies in December 2012. rncam apenaing on t apnai rrojects neiow: s-$84,472 Ireland Rd Tank Improvement -� Form 3 0% 0% 0% 0% 0% 5,607 1,621 88% 638,359 - 0% 0% 0% 657,599 0% 1,301,565 1,621 88% - 0% 0% 34,850 3,600 100% 0% 964,220 103,594 562,908 53% - 0% 999,070 107,194 562,908 54% 302.495 (107.194) (561.287) 1 r xpiam aignmcam mevenue, r= xpenanure ano atarnng ,- nangesivanances oeiow: Prior year to date revenue is reflective of bond proceeds received from the 2012 Revenue Bonds for previously purchased water meters. Also, the 2012 transfer in revenue is a combination of pay as you go capital transfers and surplus monies transferred in from the operating fund. The variance in cash balance is due to a $2,300,000 transfer in of surplus monies in December 2012. rncam apenaing on t apnai rrojects neiow: s-$84,472 Ireland Rd Tank Improvement -� Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Fund /Department Number 623 Month I October Date Updated 1 11.8.13 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 7,936 Grants /Intergovernmental 86% 8,345,333 - Charges for Services - - - Interest Earnings 18,000 746 15,490 Bond Proceeds - 8,374,019 2,510 Donations - 0% Other Income 2 100% 345,609 124,798 Transfers In - - - Total Revenue 18,000 746 15,490 Expenditures - 0% 2,369,390 2,371,429T Personnel - Supplies 2,022,863 356,929 1,601,972 Services 189,685 64,889 64,889 Debt Service - Capital 3,353,655 265,161 1,212,912 Transfers Out - Total Expenditures 5,566,203 686,979 2,879,773 Net (5,548,203) (686,233) (2,864,283) Cash Balance 2,938,554 Staffing Full Time - Part-Time /Season al/Tem porary Total 151 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Prior year revenue reflects issuance of Water Works Revenue Bonds of 2012 . Pay out costs for issuance totaled $345,609. Approved use of bond proceeds included 100% funding of the required debt service reserve. The reserve totaled $577,286 and it was transferred out to Fund 626. Current year expenditures are mainly for water meter supplies and for the Pinhook WTP Capital Improvement Project. Explain Significant Spending on Capital Projects Below: YTD Spent: PinhookWTP Project- $1,204,4452 Water Meters- $1,245,043 Vactor Truck- $361,047 Other- $69,238 Form 3 0% 0% 0% 0% 0% 7,936 2,510 86% 8,345,333 - 0% 0% 20,750 0% - 0% 8,374,019 2,510 86% - 0% 420,889 2 100% 345,609 124,798 (2) 100% - 0% 1,446,495 1,825,742 315,001 91% 577,286 - 0% 2,369,390 2,371,429T 315,001 94% 6.004.629 (2.371.4291 (312.491) 151 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Prior year revenue reflects issuance of Water Works Revenue Bonds of 2012 . Pay out costs for issuance totaled $345,609. Approved use of bond proceeds included 100% funding of the required debt service reserve. The reserve totaled $577,286 and it was transferred out to Fund 626. Current year expenditures are mainly for water meter supplies and for the Pinhook WTP Capital Improvement Project. Explain Significant Spending on Capital Projects Below: YTD Spent: PinhookWTP Project- $1,204,4452 Water Meters- $1,245,043 Vactor Truck- $361,047 Other- $69,238 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Fund /Department Number 624 Month I October Date Updated 1 11.12.13 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 6,107 Grants /Intergovernmental 71% - - Charges for Services - - - Interest Earnings 6,100 297 4,323 Bond Proceeds - - - Donations - - 0% Other Income 0% Transfers In - - - Total Revenue 6,100 297 4,323 Expenditures (363). 109% 6,107 Personnel - - - Supplies - 2.140 Services Debt Service Capital - - - Transfers Out 4,000 297 4,363 Total Expenditures 4,000 297 4,363 Net 2,100 - (40) Cash Balance 1,449,701 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg i,nangesivanances aeiow: No significant changes in the customer meter deposit fund. rncanr apenaing on t apnai r-rojecrs rseiow: 1,407.772 Form 3 0% 0% 0% 0% 0% 6,107 1,777 71% - - 0% 0% 0% 0% 6,107 1,777 71% - - 0% 0% 0% 0% 0% 6,107 (363). 109% 6,107 (363) 109% - 2.140 1,407.772 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Fund /Department Number 625 Month I October Date Updated 1 11.12.13 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 5,000 230 1,549 3,425 3,451 31% Bond Proceeds - - 0% Donations 0% Other Income 0% Transfers In 2,103,381 170,953 1,709,530 1,362,782 393,851 81% Total Revenue 2,108,381 171,183 1,711,079 1,366,207 397,302 81% Expenditures Personnel - - - - - 0% Supplies - - 0% Services - 0% Debt Service 2,103,381 - 410,000 351,104 1,693,381 19% Capital - - 0% Transfers Out 5,000 230 1,549 3,425 3,451 31% Total Expenditures 2,108,381 230 411,549 354,529 1,696,832 20% Net 170,953 1,299,530 1,011,678 (1,299,530) Cash Balance 1 1,304,166 1,021,072 Staffing Full Time - - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Transfer in revenue is greater in 2013 mostly because of the 2012 Revenue Bonds debt. This debt and the refunding of the 2002 Revenue Bonds in November last year contribute to current year elevation in debt service expenditures.. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Fund /Department Number 626 Month I October Date Updated 1 11.12.13 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 2,556 Grants /Intergovernmental 74% - Charges for Services - - - Interest Earnings 5,700 304 4,207 Bond Proceeds - 833,826 95,006 Donations - - 0% Other Income 0% Transfers In 307,809 17,462 214,296 Total Revenue 313,509 17,766 218,503 Expenditures 0% Personnel - - - Supplies R1414 a26 9s_nnF Services Debt Service Capital Transfers Out Total Expenditures - - - Net 313,509 17,766 218,503 Cash Balance 1,530,191 Staffing Full Time - Part-Time /Season al/Tem porary Total 1 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Waterworks Revenue Bonds of 2012 funded 100% of the required reserve at closing in June 2012. This reserve amount totals $577,286 and is included in the prior year transfer in revenue. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 0% 0% 2,556 1,493 74% - 0% 0% 0% 831,270 93,513 70% 833,826 95,006 70% - - 0% 0% 0% 0% 0% 0% 0% R1414 a26 9s_nnF rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Waterworks Revenue Bonds of 2012 funded 100% of the required reserve at closing in June 2012. This reserve amount totals $577,286 and is included in the prior year transfer in revenue. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Fund /Department Number 629 Month I October Date Updated 1 11.12.13 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 7,500 416 6,173 8,661 1,327 82% Bond Proceeds - - 0% Donations 0% Other Income 0% Transfers In 45,301 45,301 121,426 - 100% Total Revenue 52,801 416 51,474 130,087 1,327 97% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 7,500 416 6,173 8,661 1,327 82% Total Expenditures 7,500 416 6,173 8,661 1,327 82% Net 45,301 - 45,301 121,426 Cash Balance 2,031,532 1,986,231 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Transfer in revenue is for the purpose of satisfying and complying with the city's 16.7% O& M Cash Reserve Requirement. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance jMonth I October Fund /Department Number 640 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 548,000 45,443 456,481 453,420 91,519 83% Interest Earnings 1,200 266 3,711 4,384 (2,511) 309% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 549,200 45,708 460,193 457,804 89,007 84% Expenditures Personnel 117,515 8,743 94,263 58,161 23,252 80% Supplies 16,771 242 15,016 20,815 570 1,185 93% Services 393,083 17,681 167,833 148,003 10,833 214,417 45% Debt Service 28,475 14,218 14,257 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 555,844 26,666 291,329 226,979 11,403 253,111 54% Net (6,644) 19,042 168,863 230,825 (11,403) (164,104) Cash Balance 1,331,512 1,151,946 Staffing Full Time 1.30 1.30 1.30 Part-Time /Season al/Tem porary - - - Total 1.30 1.30 1.30 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Increase in year to date actual versus ytd 2012 is due to the approval of stand -by pay for sewer personnel who are on 24 hour rotating on -call status for after -hours sewer calls. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations JMonth I October Fund /Department Number 641 1 Date Updated 11/12/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 33,033,547 2,757,885 26,407,497 26,100,157 6,626,050 80% Interest Earnings 12,000 1,309 14,149 14,397 (2,149) 118% Bond Proceeds - - - - 0% Donations - - - - 0% Other Income 68,000 4,946 58,928 70,253 9,072 87% Transfers In 18,000 675 14,036 73,296 3,964 78% Total Revenue 33,131,547 2,764,814 26,494,611 26,258,103 6,636,936 80% Expenditures Personnel 6,751,188 469,927 5,276,289 4,610,409 1,759 1,473,140 78% Supplies 2,155,362 241,303 1,438,239 1,301,865 288,180 428,943 80% Services 12,719,733 1,043,922 8,852,274 8,285,667 1,394,602 2,472,857 81% Debt Service 314,896 110 242,081 83,333 678 72,138 77% Capital - - - - - - 0% Transfers Out 13,377,561 774,514 8,118,451 10,351,970 - 5,259,110 61% Total Expenditures 35,318,740 2,529,776 23,927,334 24,633,244 1,685,219 1 9,706,188 73% Net (2,187,193) 235,038 2,567,277 1,624,858 (1,685,219) (3,069,252) Cash Balance 6,824,335 4,110,852 Staffing Full Time 96.80 92.80 94.80 Part-Time /Season al/Tem porary 13.28 5.58 6.58 Total 110.08 98.38 101.38 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund is in very good shape overall. Some of the cash that has been accumulating in the fund for "pay as you go" capital spending may be transferred to Fund 642 before year end if needed for ongoing projects. Explain Significant Spending on Capital Projects Below: Capital spending for Sewage Works is in Fund 642. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Fund /Department Number 642 Month I October Date Updated 1 11/8/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 60,000 1,290 24,369 40,734 35,631 41% Bond Proceeds - - - - - 0% Donations - 0% Other Income - 168,094 - (168,094) 0% Transfers In 4,500,000 - - 4,450,000 4,500,000 0% Total Revenue 4,560,000 1,290 192,463 4,490,734 4,367,537 4% Expenditures Personnel - - - - - 0% Supplies - - - 0% Services 335,200 11,672 156,104 179,096 100% Debt Service - - - - - 0% Capital 11,164,371 859,867 3,549,109 4,506,229 5,514,162 2,101,100 81% Transfers Out - - - - - - 0% Total Expenditures 11,499,571 871,539 3,705,214 4,506,229 5,693,258 1 2,101,100 1 82% Net (6,939,571) (870,249) (3,512,751) (15,496) (5,693,258)1 2,266,437 Cash Balance 1 5,350,358 9,757,798 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: rx iam of nincam openaing on t a nai rro ects neiow: Year to date: Michigan St. Lift Station replacement $403,229, Automation of DO Controls at WWTP $468,983, Engineering work on upcoming projects $156,104, Completion of Triangle Neighborhood infrastructure $41,374, Primary Clarifier Rehab $684,052, Manhole rehab $794,656, and sewer lining $528,553. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Fund /Department Number 643 Month I October Date Updated 1 11/8/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 13,793 Grants /Intergovernmental 55% - - Charges for Services - - - Interest Earnings 18,000 675 9,814 Bond Proceeds - - - Donations - 0% Other Income - 0% - Transfers In 109,098 - 200,296 Total Revenue 127,098 675 210,110 Expenditures 8,186 55% 73,296 Personnel - - - Supplies 59.5031 1 191.1981 Services Debt Service Capital - - - Transfers Out 18,000 675 9,814 Total Expenditures 18,000 675 9,814 Net 109,098 - 200,296 Cash Balance 3,292,600 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr mevenue, r-xpenairure ano ararring -nangesivariances aeiow: The large amount transferred in from Fund 641 was to bring this reserve account balance equal to two months budgeted O &M expense. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 0% 0% 13,793 8,186 55% - - 0% 0% 0% - 91,198 184% 13,793 83,012 165% - 0% 0% 0% 0% - 0% 73,296 8,186 55% 73,296 8,186 55% 59.5031 1 191.1981 rxpiam aigmricanr mevenue, r-xpenairure ano ararring -nangesivariances aeiow: The large amount transferred in from Fund 641 was to bring this reserve account balance equal to two months budgeted O &M expense. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2004/2006 Fund /Department Number 645 Month I October Date Updated 1 11/8/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes Local Income Taxes Other Taxes Grants /Intergovernmental Charges for Services Interest Earnings Bond Proceeds Donations Other Income Transfers In Total Revenue Expenditures Personnel Supplies - - Services 12 12 Debt Service - - Capital Transfers Out - - Total Expenditures 12 12 Net (12) (12) Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total r=xpiam aigmricam rtevenue, r= xpenanure ano starring ,- nangesivanances rseiow: All funds in this bond have been spent. rncam apenaing on t apnai rrojects neiow: 12 Form 3 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% (12) 0% - 0% 0% 0% (12) 0% 12 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Fund /Department Number 647 Month I October Date Updated 1 11/8/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - Interest Earnings 1 40 Bond Proceeds - - Donations 0% Other Income 0% Transfers In - - Total Revenue 1 40 Expenditures - 0% Personnel - - Supplies - - - Services 19,017 63 13,679 Debt Service - - - Capital (63) 100% Transfers Out - - - Total Expenditures 19,017 63 13,679 Net (19,017) (62) (13,639) Cash Balance 5,402 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmncam Kevenue, r-xpenaicure ano ararnng ,- nangesivanances aeiow: Bond is fully encumbered and should be closed out by year end. rncam apenaing on t apnai r-rojecis neiow: 21.904 Form 3 0% 0% 0% 0% 0% 191 (40) 0% - - 0% 0% 0% 0% 191 40 0% - - 0% - - - 0% 6,715 5,401 (63) 100% - - - 0% 38,271 0% - 0% 44,986 5,401 (63) 100% 44.795) (5.40111 23 21.904 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Fund /Department Number 649 Month I October Date Updated 1 11/8/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 11,689 Grants /Intergovernmental 95% - - Charges for Services - - - Interest Earnings 8,500 1,029 8,096 Bond Proceeds - - - Donations - - 0% Other Income - - - Transfers In 8,226,256 774,514 7,904,060 Total Revenue 8,234,756 775,544 7,912,155 Expenditures - 0% 1,783,938 Personnel - - - Supplies 5.082.340 (6.817.7281 Services - - - Debt Service 9,804,044 400 2,663,715 Capital - - - Transfers Out - - - Total Expenditures 9,804,044 400 2,663,715 Net (1,569,288) 775,144 5,248,440 Cash Balance 6,084,486 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Monthly transfers in from Fund 641 are mandatory, per bond covenants. Year -to -date debt service payments have been interest only. Principal and interest payments will also be paid in December. 2013 debt service is higher than 2012 due to costs associated with refunding the 2004 Bond and 1998 SRF Loan, and the first interest payment made on the 2012 Bond. rncanr apenaing on t apnai rrojecrs neiow: Form 3 0% 0% 0% 0% 0% 11,689 404 95% - - 0% 0% 0% 6,854,589 322,197 96% 6,866,278 322,601 96% - - 0% 0% 0% 1,783,938 7,140,329 27% - - 0% - - 0% 1,783,938 7,140,329 27% 5.082.340 (6.817.7281 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Monthly transfers in from Fund 641 are mandatory, per bond covenants. Year -to -date debt service payments have been interest only. Principal and interest payments will also be paid in December. 2013 debt service is higher than 2012 due to costs associated with refunding the 2004 Bond and 1998 SRF Loan, and the first interest payment made on the 2012 Bond. rncanr apenaing on t apnai rrojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Clay Sewage Fund /Department Number 650 Month I October Date Updated 1 11/8/2013 Current Current Current Prior Local Income Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes Local Income Taxes 0% Other Taxes Grants /Intergovernmental Charges for Services - Interest Earnings 2 Bond Proceeds - Donations 0% Other Income - Transfers In - Total Revenue 2 Expenditures Personnel - Supplies 0% Services 2 Debt Service - Capital - Transfers Out 698 Total Expenditures 698 0% Net (696) Cash Balance Staffing 0% Full Time (698). Part-Time /Season al/Tem porary Total 0% rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg ,- nangesivanances aeiow: Fund has been dormant for a number of years. Cash balance was transferred to Fund 641 to fully close this fund. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 0% 0% 3 (2) 0% - - 0% 0% 0% 0% 3 2 0% - - 0% 0% 0% 0% 0% (698). 0% (698) 0% 3 1 696 696 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg ,- nangesivanances aeiow: Fund has been dormant for a number of years. Cash balance was transferred to Fund 641 to fully close this fund. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Bond 2007B Fund /Department Number 651 Month I October Date Updated 1 11/8/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services (68) - Interest Earnings - 68 Bond Proceeds - Donations 0% Other Income 0% Transfers In 68 - Total Revenue - 68 Expenditures - 0% Personnel (2) - Supplies - - - Services 4,582 2 4,584 Debt Service - - - Capital 34,930 31,402 Transfers Out - - - Total Expenditures 39,512 2 35,985 Net (39,512) (2) (35,918) Cash Balance 3,640 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg ,- nangesivanances aeiow: Fund has been fully encumbered. Year end budget adjustments will correct small negative balances. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 0% 0% 554 (68) 0% - - 0% 0% 0% 0% 554 68 0% - - 0% - - 0% 35,260 (2) 100% - - - 0% 153,863 3,639 (111) 100% - - - 0% 189,122 3,639 1 (112) 100% 188.569) (3.63911 45 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Fund /Department Number 653 Month I October Date Updated 1 11/8/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - 0% Interest Earnings 60,000 0% Bond Proceeds - 0% Donations 0% Other Income - - Transfers In 1,745,314 14,096 Total Revenue 1,805,314 14,096 Expenditures 0% Personnel - - Supplies 1 100% Services - - Debt Service 2,434,564 2,434,563 Capital - - Transfers Out 3,524 3,524 Total Expenditures 2,438,088 2,438,087 8,121.576 Net (632,774) (2,423,992) Cash Balance 7,286,825 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr mevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Debt Reserve, which is now held in a separate bank, is fully funded for existing debt. Interest earnings do not show up in Naviline; they are not budgeted for 2014. The debt service pay -out was part of the re- funding of the 2004 Bond and 1998 SRF Loan. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 0% 0% 30,124 60,000 0% - - 0% 0% 0% 347,381 1,731,218 1% 377,505 1,791,218 1% - - 0% 0% 0% 1 100% - 0% 0 100% - 1 100% 377,505 1, 791,218 8,121.576 rxpiam aigmricanr mevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Debt Reserve, which is now held in a separate bank, is fully funded for existing debt. Interest earnings do not show up in Naviline; they are not budgeted for 2014. The debt service pay -out was part of the re- funding of the 2004 Bond and 1998 SRF Loan. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Fund /Department Number 658 Month I October Date Updated 1 11/8/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - Interest Earnings 1 214 Bond Proceeds - - Donations 0% Other Income 0% Transfers In - - Total Revenue 1 214 Expenditures - 0% Personnel - - Supplies - - - Services 112,089 7 108,736 Debt Service - - - Capital (327) 100% Transfers Out - - - Total Expenditures 112,089 7 108,736 Net (112,089) (6) (108,521) Cash Balance 3,682 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: Bond is fully encumbered. rncam apenaing on t apnai rrojects neiow: fl Form 3 0% 0% 0% 0% 0% 4,248 (214) 0% - - 0% 0% 0% 0% 4,248 214 0% - - 0% - - - 0% 324,858 3,681 (327) 100% - - - 0% 1,537,662 0% 12,009 0% 1,874,528 3,681 (327) 100% 1.870.280) (3.68111 113 fl Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 jMonth I October Fund /Department Number 659 1 Date Updated 11/8/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 60,000 1,737 27,881 84,432 32,119 46% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 60,000 1,737 27,881 84,432 32,119 46% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 425,228 790 256,235 283,995 11,295 157,698 63% Debt Service - - - - - - 0% Capital 10,271,492 57,493 1,540,935 7,090,530 6,024,732 2,705,825 74% Transfers Out - - - - - - 0% Total Expenditures 10,696,720 58,282 1,797,170 7,374,525 6,036,027 2,863,523 73% Net (10,636,720) (56,545) (1,769,288) (7,290,093) (6,036,027) (2,831,405) Cash Balance 8,397,222 12,445,703 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Year to date: East Bank Sewer Separation -Phase 2 $607,869, East Bank Sewer Separation -Phase 3 $532,075, LaSalle School Area Sewer Separation $85,417, East Bank Sewer Separation -Phase 4 $169,054, Southwood Sewer Separation $148,135, CSO 25 /River Stabilization $85,814, and Diamond Ave. Sewer Separation -Phase 3 $187,331. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 jMonth I October Fund /Department Number 661 Date Updated 11/8/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 60,000 4,257 57,789 2,211 96% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 60,000 4,257 57,789 2,211 96% Expenditures Personnel - - - - 0% Supplies - - - 0% Services 104,981 104,981 0 100% Debt Service - - - - - 0% Capital 19,055,019 280,441 3,473,063 2,303,403 13,278,553 30% Transfers Out - - - - - 0% Total Expenditures 19,160,000 280,441 3,578,044 2,303,403 13,278,553 31% Net (19,100,000) (276,184) (3,520,255) (2,303,403) (13,276,342) Cash Balance 19,726,633 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Bond closed in late December 2012. Explain Significant Spending on Capital Projects Below: Year to date: East Bank Sewer Separation -Phase 4 $2,019,484, Diamond Ave. Sewer Separation -Phase 3, $1,453,579. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2013 Fund /Department Number 663 Month I October Date Updated 1 11/8/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 21,200,000 21,200,000 0% Donations - - 0% Other Income 0% Transfers In 0% Total Revenue 21,200,000 21,200,000 0% Expenditures Personnel - - 0% Supplies - - 0% Services 400,000 400,000 0% Debt Service - - 0% Capital - - 0% Transfers Out 1,700,000 1,700,000 0% Total Expenditures 2,100,000 2,100,000 0% Net 19,100,000 19,100,000 Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total rxpiam aignmcam Kevenue, r-xpenaicure ano acarnng %,nangesivanances aeiow: The City has decided to not issue a 2013 Sewer bond so no activity is expected in this fund. rncam apenaing on t apnai r-rojecis neiow: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund IMonth I October Fund /Department Number 664 Date Updated 11/8/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings - 1 5 (5) 0% Bond Proceeds 85,741 - 85,740 1 100% Donations - - - 0% Other Income 0% Transfers In 0% Total Revenue 85,741 1 85,745 4 100% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 81,065 81,064 1 100% Capital - - - 0% Transfers Out - - 0% Total Expenditures 81,065 - 81,064 1 100% Net 4,676 1 4,681 (5) Cash Balance 4,681 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Year to date revenue shown came from the re- funding of the 2004 Sewer bond and 1998 SRF Loan to pay issuance costs related to the bond re- funding. Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Century Center Fund /Department Number 670 Month I October Date Updated 1 11/19/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% - Property Taxes 0% 1,313,436 Local Income Taxes - - Other Taxes 1,313,436 59% 1,313,436 Grants /Intergovernmental - - - Charges for Services 2,306,831 346,547 1,354,635 Interest Earnings 360 2,851 3,079 Bond Proceeds - - - Donations - - - Other Income 145,578 7,547 62,671 Transfers In - - - Total Revenue 3,766,205 356,946 2,733,821 Expenditures - 0% 3,323,210 Personnel 2,006,397 159,547 1,502,262 Supplies 237,415 33,422 162,895 Services 973,347 95,069 822,153 Debt Service 1,300 605 4,610 Capital 329,000 219,487 219,487 Transfers Out - - - Total Expenditures 3,547,459 508,130 2,711,407 Net 218,746 (151,184) 22,414 Cash Balance 1,137,335 Staffing Full Time 24.00 - Part-Time /Season al/Tem porary 6.00 Total 30.00 1,01 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: SMG has assumed management of Century Center effective 1 July 2013. One of their contractual duties is to reduce the operating deficit in the fund. Covered by hotel /motel tax revenue. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% - 0% 1,313,436 100% - 0% 983,612 952,196 59% 213 (2,719) 855% - 0% - 0% 82,204 82,907 43% - - 0% 2,379,465 1,032,384 73% 1,221,629 504,135 75% 43,826 74,520 69% 710,038 151,194 84% 3,661 (3,310) 355% - 109,513 67% 1,344,057 - 0% 3,323,210 836,053 76% (943.746) 196.332 1,01 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: SMG has assumed management of Century Center effective 1 July 2013. One of their contractual duties is to reduce the operating deficit in the fund. Covered by hotel /motel tax revenue. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Fund /Department Number 671 Month I October Date Updated 1 11/19/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% - Local Income Taxes 100,000 100% Other Taxes - 0% - Grants /Intergovernmental 100,000 - 100,000 Charges for Services - - - Interest Earnings 500 33 252 Bond Proceeds - - - Donations - - 0% Other Income - 15% - Transfers In 575,000 - 575,000 Total Revenue 675,500 33 675,252 Expenditures - 0% 169,545 Personnel - - - Supplies 134,397 19,671 19,671 Services 11,000 10,965 10,965 Debt Service - - - Capital 101,373 Transfers Out - - - Total Expenditures 246,770 30,637 30,637 Net 428,730 (30,604) 644,616 Cash Balance 1,919,493 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: The Century Center Capital fund receives an annual transfer of PSDA tax money in the amount of $100,000 per year. The Century Center Board of Managers has not approved a 2013 capital budget in this fund. SMG made a capital contribution of $575,000 to this fund on 13 August 2013. Explain Significant Spending on Capital Projects Below: With the arrival of SMG this fund has now been budgeted through the mid -year budget appropriation. Form 3 0% 0% - 0% 100,000 100% - 0% 322 248 50% - - 0% 0% - 0% 1,344,057 100% 1,444,380 248 100% - - 0% 114,726 15% 35 100% - - 0% 169,545 101,373 0% - - 0% 169,545 216,133 12% 1,274,835 (215,886) 1,274.835 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: The Century Center Capital fund receives an annual transfer of PSDA tax money in the amount of $100,000 per year. The Century Center Board of Managers has not approved a 2013 capital budget in this fund. SMG made a capital contribution of $575,000 to this fund on 13 August 2013. Explain Significant Spending on Capital Projects Below: With the arrival of SMG this fund has now been budgeted through the mid -year budget appropriation. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Central Services jMonth I October Fund /Department Number 222 1 Date Updated 11/13/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 7,891,203 647,535 6,030,004 5,652,033 1,861,199 76% Interest Earnings 1,500 209 3,039 4,131 (1,539) 203% Bond Proceeds - 0% Donations - 18,750 0% Other Income 30,000 3,279 109,756 40,070 (79,756) 366% Transfers In - - - - - 0% Total Revenue 7,922,703 651,023 6,142,799 5,714,984 1,779,904 78% Expenditures Personnel 2,813,983 189,811 2,104,888 2,045,909 709,095 75% Supplies 230,305 20,950 140,860 95,028 81,465 7,980 97% Services 4,674,822 413,130 3,765,981 3,337,759 795,018 113,823 98% Debt Service 6,322 765 6,075 6,724 210 37 99% Capital 253,997 - 68,728 138,015 1,442 183,827 28% Transfers Out - - 0% Total Expenditures 7,979,429 624,656 6,086,532 5,623,434 878,135 1,014,762 87% Net (56,726) 26,367 56,267 91,550 (878,135)1 765,142 Cash Balance 1,000,670 1,077,257 Staffing Full Time 44.00 43.00 40.00 Part-Time /Season al/Tem porary 1.00 - - Total 45.00 43.00 40.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Supplies -- allocation for Printshop increases from $27 to $149. Accts 2312 & 2398 are not budgeted, tool acct .23 -20 was used for a capital purchase from 2013 that monies will have to be transferred midyear. Natural Gas utilities were higher TY vs. LY. The encumbrance amount is high due to blanket PO's issued to AEP and NIPSCO for city -wide utility costs paid from this fund and charged back to departments. Revenue -- Energy Dept. - reclass of revenue from 101 General Fund to Fund 222 -0616. Explain Significant Spending on Capital Projects Below: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance IMonth I October Fund /Department Number 226 1 Date Updated 11/18/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 2,988,576 249,048 2,488,845 2,433,732 499,731 83% Interest Earnings 26,000 1,082 16,525 20,652 9,475 64% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 18,500 1,859 21,794 16,641 10% Transfers In - - - - - 0% Total Revenue 3,033,076 250,130 2,507,228 2,476,178 525,848 83% Expenditures Personnel (1x) 179,100 13,204 138,022 136,119 - 41,078 77% Supplies (2x) 22,356 824 13,323 13,740 682 8,351 63% Services (3x except Debt Svc) 2,689,771 102,740 2,011,617 1,566,601 1,305 676,849 75% Debt Service (37.11 & 37.12) - - - - - - 0% Capital (4x) 24,700 23,994 - 706 97% Transfers Out 5x - - - 122,030 - 0% Total Expenditures 2,915,927 116,768 2,186,956 1,838,489 1,987-r-- ,987 726,984 75% Net 117,149 133,361 320,272 637,689 (1,987) (201,137) Cash Balance 5,565,684 5,089,045 Staffing Full Time 3.00 3.00 3.00 Part-Time /Season al/Tem porary - - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The largest component of the services category is for liability and property claims paid which are 95% of the 2013 budget at October 31, 2013 due to the settlement of some large claims. The City Legal Department evaluates claims and determines the proper amounts to be paid out. Revenue is derived from allocations to other City departments and these amounts are posted monthly to the accounts. Explain Significant Spending on Capital Projects Below: 2013 budgeted capital is for computers and a new vehicle. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Fund /Department Number 278 Month I October Date Updated 1 11/21/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 1,628 Grants /Intergovernmental 64% - - Charges for Services - - - Interest Earnings 2,000 86 1,273 Bond Proceeds - - - Donations - - - Other Income 127,400 9,540 104,312 Transfers In - - - Total Revenue 129,400 9,626 105,585 Expenditures 0% 75,642 Personnel - - - Supplies 63,700 (16,185) 63,700 Services 40,000 - Debt Service - Capital Transfers Out - - Total Expenditures 103,700 - 63,700 Net 25,700 9,626 41,885 Cash Balance 433,691 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This fund charges police officers for liability insurance and gasoline costs through payroll deduction. No expenditures for vehicle claims have been paid so far in 2013.The cash reserves in this fund have been increasing in recent years and are expected to increase during 2013. Claims have been minimal in this fund since it was created. Gasoline charges of $63,700.00 were deducted by Central Services during July 2013 to cover take home vehicle gasoline for fiscal 2013. This fund is classified as an Internal Service Fund for financial reporting. No liability claims have been paid so far during 2013. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 0% 0% 1,628 727 64% - - 0% - - 0% 107,132 23,088 82% - - 0% 108,761 23,815 82% - - 0% 65,000 - 100% 10,642 40,000 0% - - 0% 0% 0% 75,642 40,000 61% 33,119 (16,185) 372.564 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: This fund charges police officers for liability insurance and gasoline costs through payroll deduction. No expenditures for vehicle claims have been paid so far in 2013.The cash reserves in this fund have been increasing in recent years and are expected to increase during 2013. Claims have been minimal in this fund since it was created. Gasoline charges of $63,700.00 were deducted by Central Services during July 2013 to cover take home vehicle gasoline for fiscal 2013. This fund is classified as an Internal Service Fund for financial reporting. No liability claims have been paid so far during 2013. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits IMonth I October Fund /Department Number 711 1 Date Updated 11/18/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental - - - - - 0% Charges for Services 11,937,800 982,079 9,958,657 9,231,878 1,979,143 83% Interest Earnings 40,600 1,421 22,927 38,393 17,673 56% Bond Proceeds - - - - - 0% Donations - - 0% Other Income 210,500 210,498 86 2 100% Transfers In - - - - - 0% Total Revenue 12,188,900 983,500 10,192,082 9,270,357 1,996,818 84% Expenditures Personnel - - - - - - 0% Supplies 24,444 287 9,464 14,259 1,594 13,386 45% Services 487,085 50,363 444,629 190,364 293 42,163 91% Insurance 12,837,300 1,602,118 10,872,615 10,038,612 1,964,685 85% Debt Service - - - - - - 0% Capital - 0% Transfers Out - - - 150,630 - - 0% Total Expenditures 13,348,829 1,652,769 11,326,708 10,393,865 1,887 2,020,234 85% Net 1,159,929 669,269 1,134,627 1,123,508 1,887 23,415 Cash Balance 6,293,564 7,730,112 Staffing Full Time - Part-Time /Seasonal/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Medical claims paid so far are 85% of the budgeted amount through 83% of the year, which gives us the appearance of being on track. We've budgeted $833K each month and claim payments in 2013 have been running between $600K and $1 M each month. However, nearly $1.4 million in claims were paid in October. In addition, medical claim payments are typically somewhat higher in the last quarter of the year. At 11/15/2013, we've already spent $600K for claims in November. We likely will need an additional appropriation of $600 -800K this year. In addition, our cash balance is now $1.4 million less than it was at this time last year and it is expected to erode even further before the end of the year. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation IMonth I October Fund /Department Number 713 1 Date Updated 11/21/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 341,250 15,996 220,391 229,116 120,859 65% Interest Earnings 200 45 433 80 (233) 216% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 341,450 16,041 220,824 229,196 120,626 65% Expenditures Personnel 262,963 1,601 46,151 174,172 216,812 18% Supplies - - - - - 0% Services 4,284 357 3,570 4,740 714 83% Debt Service - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 267,247 1,958 49,721 178,912 217,526 19% Net 74,203 14,083 171,103 50,284 (96,900) Cash Balance 243,669 40,875 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This fund charges an allocation of 1 % of payroll to most departments to cover the cost of unemployment claims paid. The cost of claims paid has been low for 2013 and less than the allocation amount. Effective April 1, 2013, the allocation amount was reduced to .75% of payroll to reduce the costs paid by departments. For the 2014 budget, the rate charged to departments will be reduced to .50% due to favorable claims history and increasing cash reserves. At October 31, 2013, claims paid on behalf of former Parks & Recreation department employees was $31,308.25, or 68% of total claims paid. Due to continuing low claims paid, the rate to departments was reduced to .5% of payroll beginning in July, 2013. Cash reserves are increasing in this fund. The Unemployment Compensation Fund is classified as an Internal Service Fund for financial reporting. Explain Significant Spending on Capital Projects Below: None Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension IMonth I October Fund /Department Number 701 1 Date Updated 11/20/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 5,035,292 5,035,292 5,233,388 (0) 100% Charges for Services - - - - 0% Interest Earnings 4,987 135 2,198 3,412 2,789 44% Bond Proceeds - - - - - 0% Donations - 0% Other Income 1,723 0% Transfers In - - - - 0% Total Revenue 5,040,279 135 5,037,490 5,238,522 2,789 100% Expenditures Personnel 5,894,925 443,520 4,539,469 4,708,875 1,355,456 77% Supplies 200 - - 69 200 0% Services 4,903 80 1,007 931 3,896 21% Debt Service - - - - - 0% Capital - 0% Transfers Out - - - 170 0% Total Expenditures 5,900,028 443,600 4,540,476 4,710,044 1,359,552 77% Net (859,749) (443,466) 497,014 528,478 (1,356,763) Cash Balance 1,844,878 2,243,590 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Fire Pension fund receives State of Indiana pension relief payments in June and September to reimburse the City for actual pension costs paid and reported in the previous year. Per an INPERS letter dated June 3, 2013, the state pension relief payments will be $2,517,646.17 each on July 1, 2013 and October 2, 2013. The projected cash balance in this fund is $819,988.57 at December 31, 2013, a projected decrease of $527,875.84 during the year. The pension relief payments do not cover retiree insurance premiums paid by the fund. Explain Significant Spending on Capital Projects Below: No capital expenditures are purchased through this account. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Police Pension IMonth I October Fund /Department Number 702 1 Date Updated 11/18/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 5,863,697 5,863,697 6,731,621 (0) 100% Charges for Services - - - - 0% Interest Earnings 6,000 291 4,357 4,927 1,643 73% Bond Proceeds - - - - - 0% Donations - - - - 0% Other Income 4,000 4,624 5,736 12,378 (1,736) 143% Transfers In - - - - - 0% Total Revenue 5,873,697 4,915 5,873,790 6,748,925 93 100% Expenditures Personnel 6,922,721 530,563 5,399,931 5,502,558 1,522,790 78% Supplies 1,100 - 642 812 458 58% Services 5,312 164 1,558 908 3,754 29% Debt Service - - - - - 0% Capital - 0% Transfers Out - - - 880 0% Total Expenditures 6,929,133 530,727 5,402,131 5,505,158 1,527,002 78% N et (1,055,436) (525,812) 471,659 1,243,767 (1,527,095) Cash Balance 2,780,287 3,409,083 Staffing Full Time - Part-Time /Season al/Tem porary 1.00 1.00 1.00 Total 1.00 1.00 1.00 Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: The Police Pension fund receives pension relief distributions from the State of Indiana to reimurse the City for pension costs paid and reported in the previous fiscal year. Per an INPERS letter dated June 3, 2013, the state pension relief payments will be $2,931,848.71 each on July 1, 2013 and October 2, 2013. The projected cash balance in the fund is $1,544,07.43 at December 31, 2013, a decrease of $764,618.46 during the year. The pension relief payments do not cover retiree health insurance premiums paid by the fund. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Fund /Department Number 730 Month I October Date Updated 1 11/18/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 250 8 124 180 126 50% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 250 8 124 180 126 50% Expenditures Personnel - - - - - 0% Supplies 4,316 - (4,316) 0% Services - 11,895 (11,895) 0% Debt Service - - - 0% Capital 15,000 15,000 0% Transfers Out - - - 0% Total Expenditures 15,000 - 4,316 11,895T--- 1,895 (1,211) 108% Net (14,750) 8 (4,192) 180 (11,895)1 1,337 Cash Balance 36,920 41,090 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: rncam apenaing on t apnai rrojects neiow: Form 3 11 Y Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF Revenue - Airport JMonth I October Fund /Department Number 324 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 11,200,000 7,111,555 6,111,685 4,088,445 63% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 84,612 4,127 54,380 72,435 30,232 64% Bond Proceeds - - - - - 0% Donations 65,000 - 65,000 - 100% Other Income 2,309,640 22,407 2,344,272 187,823 (34,632) 101% Transfers In 281,000 213 279,145 663,257 1,855 99% Total Revenue 13,940,252 26,747 9,854,352 7,035,200 4,085,900 71% Expenditures Personnel - - - - 0% Supplies - - - - - 0% Services 5,931,269 176,869 1,378,340 3,597,950 676,422 3,876,507 35% Debt Service 3,476,441 - 2,812,121 2,833,043 - 664,320 81% Capital 15,836,882 175,608 4,147,439 8,271,035 102,516 11,586,927 27% Transfers Out - - - - - - 0% Total Expenditures 25,244,592 352,477 8,337,900 14,702,028 778,938 1 16,127,754 1 36% Net (11,304,340) (325,730) 1,516,452 (7,666,828) (778,938) (12,041,854) Cash Balance 19,737,824 14,335,412 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: Revenue variance due to one time payment from AJ Wright of $2 M received in April along with Blackthorn debt service paid off in 2013 and reserve amount returned to this fund. While one can find usefulness in reviewing revenue trends in TIF funds from one year to the next, because projects change wildly from one year to the next, it is less meaningful to examine year to date expenditures against the prior year to date. Major projects carried out in 2012 were: Ignition Park Infrastructure; Data Realty; final demolition of Underground Pipe & Valve; Mayflower Road Realignment & Improvements; the SB Animal Shelter reconstruction; Mayflower Trunk Sewer; continued acquisition in Ignition Park South and East; and the beginning expenditures of the Renaissance District. In 2013, the major projects thus far approved are: more acquisition in Ignition Park South and East; Bosch facility holding costs; and major expenditure on the Renaissance District project. Explain Significant Spending on Capital Projects Below: Capital projects thus far this year are: Renaissance District; and Ignition Park South & East acquisitions. Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown JMonth I October Fund /Department Number 420 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 3,650,000 1,705,491 1,909,554 1,944,509 47% Local Income Taxes - - - - 0% Other Taxes 398,500 200,000 398,500 398,000 100% Grants /Intergovernmental - - - - 0% Charges for Services 34,000 2,968 27,777 37,064 6,223 82% Interest Earnings 59,993 7,812 51,883 36,126 8,110 86% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 520,761 42,477 376,681 448,167 144,080 72% Transfers In - 356 5,315 832,834 5,315 0% Total Revenue 4,663,254 253,613 2,565,647 3,661,745 2,097,607 55% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 627,352 63,140 413,223 730,859 118,898 95,231 85% Debt Service 2,880,922 200,000 2,880,921 1,643,353 - 1 100% Capital 1,793,828 98,569 141,983 3,995,139 277,117 1,374,728 23% Transfers Out - - - - - - 0% Total Expenditures 5,302,102 361,709 3,436,127 6,369,351 396,015 1 1,469,960 1 72% Net (638,848) (108,096) (870,480) (2,707,606) (396,015)1 627,647 Cash Balance 1,967,400 1,193,408 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: TIF funds are used to fund projects which vary widely from year to year, so no real trend is expected from one year to the next. Major projects undertaken in 2012 were: Century Center Island Improvements; Coveleski Improvements; Sidewalk Improvements outside First Bank Bldg; Demo of Michiana Lock & Key; Restrooms @ Morris Civic;and the Veteran's Clinic. Projects thus far committed in 2013 are:Century Center West Entrance; Studebaker Plaza; and Wayne Street Garage Facade improvements. Revenue variances: sold more property in 2012; received funds from debt service reserve account in 2012. Explain Significant Spending on Capital Projects Below: Capital projects thus far committed in 2013 are:Century Center West Entrance; Studebaker Plaza; and Wayne Street Garage Facade improvements. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Fund /Department Number 422 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Property Taxes 440,000 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 175,310 60% - Property Taxes 440,000 264,690 Local Income Taxes - - Other Taxes 0% 3,728 Grants /Intergovernmental 32% - - Charges for Services - - - Interest Earnings 4,000 86 1,288 Bond Proceeds - - - Donations - - 0% Other Income - 0% 6,594 351 Transfers In - - - Total Revenue 444,000 86 265,978 Expenditures - 0% 802,594 36,152 Personnel - - - Supplies - - - Services 11,496 180 2,218 Debt Service - - - Capital 657,319 6,078 304,001 Transfers Out - - - Total Expenditures 668,815 6,258 306,219 Net (224,815) (6,172) (40,241) Cash Balance 411,488 Staffing Full Time - Part-Time /Season al/Tem porary Total 225,083 175,310 60% - - 0% 0% 0% 0% 3,728 2,712 32% - - 0% 0% 0% 0% 228,811 178,022 60% - - 0% - - - 0% 6,594 351 8,927 22% - - - 0% 796,000 35,801 317,517 52% - - - 0% 802,594 36,152 326,444 51% 573.7831 (36.152) (148.4221 r xpiam aigmricam Kevenue, r- xpenanure ano starring ,- nangesivanances rseiow: TIF projects vary widely from year to year so little can be gained by comparing expenditures from year to year. Major projects for 2012 were: Hansel Center and the beginning of Rushton Square. Major projects committed thus far in 2013 are: Completion of Rushton Square and William Streetscape. rncam apenaing on t apnai rrojects neiow: committed thus far in 2013 are: Completion c pe. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Fund /Department Number 425 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 500 18 267 341 233 53% Bond Proceeds - - - - - 0% Donations - - - - - 0% Other Income 156,405 10,885 132,588 102,683 23,817 85% Transfers In - - - - - 0% Total Revenue 156,905 10,903 132,855 103,024 24,050 85% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 144,159 8,691 85,161 78,790 58,998 59% Debt Service - - - - - 0% Capital 7,026 6,309 17,750 717 90% Transfers Out - - - - - 0% Total Expenditures 151,185 8,691 91,470 96,540 59,715 61% Net 5,720 2,212 41,385 6,484 (35,665) Cash Balance 136,780 105,961 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg i,nangesivanances aeiow: Operations under outside contract with CB Richard Ellis so all expenses except capital are shown under Services line, to show consistently with Parking Garages and Blackthorn Golf Course. rncanr apenaing on t apnai rrojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Fund /Department Number 426 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 1,720,000 613,185 876,401 1,106,815 36% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 10,000 728 11,107 15,092 (1,107) 111% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 1,730,000 728 624,292 891,493 1,105,708 36% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 304,171 21,330 116,014 169,852 185,506 2,651 99% Debt Service - - - - - - 0% Capital 4,466,373 358,734 1,263,861 1,020,784 695,158 2,507,354 44% Transfers Out - - - - - - 0% Total Expenditures 4,770,544 380,064 1,379,875 1,190,636 880,664T 2,510,005 47% Net (3,040,544) (379,336) (755,583) (299,143) (880,664) (1,404,297) Cash Balance 3,103,517 3,198,581 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Major projects in 2012 were: Memorial Campus Street Improvements; 400 Block N. Michigan Parking Lot; and Skyway Bridge /Building Improvements. Projects committed thus far in 2013: Completion of projects started in 2012. Explain Significant Spending on Capital Projects Below: Projects committed thus far in 2013: Completion of projects started in 2012. No new projects initiated in 2013. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Development Fund /Department Number 429 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 820,000 431,979 693,352 388,021 53% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 3,000 538 7,091 4,441 (4,091) 236% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In - - - - 0% Total Revenue 823,000 538 439,070 697,793 383,930 53% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 80,105 19,795 53,696 28,203 5,500 20,909 74% Debt Service - - - - - - 0% Capital 2,308,890 2,308,890 0% Transfers Out - - 0% Total Expenditures 2,388,995 19,795 53,696 28,203 5,500T 2,329,799 2% Net (1,565,995) (19,257) 385,374 669,590 (5,500) (1,945,869) Cash Balance 2,604,997 1,571,666 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Major projects in 2012 were: Eddy Street Corridor study; Demolition relation to AEP Easement; and 5 points utility study. Commitments thus far in 2013 are:completion of the items begun in 2012. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 JMonth I October Fund /Department Number 430 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 1,820,000 1,381,537 1,337,317 438,463 76% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 20,000 923 15,907 17,527 4,093 80% Bond Proceeds - - - - - 0% Donations - 0% Other Income 4,200 0% Transfers In - - - 1,401,397 0% Total Revenue 1,840,000 923 1,397,444 2,760,441 442,556 76% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 793,455 31,722 465,159 841,741 250,389 77,907 90% Debt Service - - - - - - 0% Capital 5,329,430 423,218 2,684,544 1,244,194 1,564,224 1,080,662 80% Transfers Out - - - - - - 0% Total Expenditures 6,122,885 454,940 3,149,703 2,085,935 1,814,613 1 1,158,569 1 81% Net (4,282,885) (454,017) (1,752,259) 674,506 (1,814,613) (716,013) Cash Balance 3,642,518 4,425,358 Staffing Full Time - Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from one year to the next so expenditure comparison will not yield reliable trend review. Major projects for 2012 were: Erskine Plaza Ponds; Fellows Street Corridor; Acquisition for Ireland Road project; and continuation of acquisition and engineering for the Main /Lafayette Crossover project. Projects committed thus far in 2013 are: completion of the Fellows Street Corridor project; additional work on the Ireland Street project; and the final acquisition and engineering along with construction of the Main /Lafayette Crossover project. Explain Significant Spending on Capital Projects Below: Projects committed thus far in 2013 are: completion of the Fellows Street Corridor project; additional work on the Ireland Street project; and the final acquisition and engineering along with construction of the Main /Lafayette Crossover project. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #2 Fund /Department Number 431 Revenue Property Taxes Local Income Taxes Other Taxes Grants /Intergovernmental Charges for Services Interest Earnings Bond Proceeds Donations Other Income Transfers In Total Revenue Expenditures Personnel Supplies Services Debt Service Capital Transfers Out Total Expenditures Net Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total Month I October Date Updated 1 11/14/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget rxpiam oignmcam mevenue, cxpenonure ano acarnng i,nangesivanances aeiow: This TIF fund is no longer used and should be closed. rncam apenaing on t apnai r-rojecis neiow: Form 3 0% 0% 0% 0% 0% 2,329 0% - 0% 0% 0% - 0% 2,329 0% - 0% 0% 0% 0% - 0% 1,401,397 0% 1,401,397 0% 1.1199.06R) Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Fund /Department Number 432 Month I October Date Updated 1 11/14/2013 Current Current Current Prior 1,331,000 659,735 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 671,265 50% Property Taxes 1,331,000 659,735 Local Income Taxes - - Other Taxes 0% Grants /Intergovernmental 0% Charges for Services - - - Interest Earnings 15,000 1,178 16,707 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 1,346,000 1,178 676,442 Expenditures 0% Personnel - - - Supplies - - Services 1,268 1,157 Debt Service 500,000 488,848 Capital - - Transfers Out - - Total Expenditures 501,268 - 490,005 Net 844,732 1,178 186,437 Cash Balance 6,315,158 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricam Kevenue, r-xpenairure ano ararring %,nangesivanances oeiow: No tax revenue requested in 2011 (which would have been received in 2012). rncam apenaing on t apnai r-rojecrs neiow: Form 3 671,265 50% - 0% 0% 0% 0% 24,807 (1,707) 111% - 0% 0% 0% - 0% 24,807 669,558 50% - - 0% 0% - 111 91% 149,809 11,152 98% - - 0% - - 0% 149,809 11,263 98% 125.0021 658.295 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Fund /Department Number 435 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 320,000 164,168 264,862 155,832 51% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 1,000 28 404 646 596 40% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 321,000 28 164,572 265,508 156,428 51% Expenditures Personnel - - - - - 0% Supplies - - - - - 0% Services 4,782 257 18,023 4,500 25 99% Debt Service 190,461 190,461 290,460 - - 100% Capital 259,539 - 8,500 259,539 0% Transfers Out - - - - 0% Total Expenditures 454,782 - 190,718 316,983 4,500T 259,564 43% Net (133,782) 28 (26,146) (51,475) (4,500) (103,136) Cash Balance 134,779 141,198 Staffing Full Time - Part-Time /Season al/Tem porary Total r=xpiam aigmricant rtevenue, r- xpenanure ano starring ,- nangesivanances rseiow: The Douglas Road TIF was established to develop the road and area near Brown Mackie College near the South Bend - Mishawaka border. The fund borrowed money from the City of 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 April 30, 2013, the amounts due Mishawaka and Major moves were $343,532 and $941,728, respectively. rncam apenaing on t apnai rrojects t5eiow: Iget of $259,539 is for road improvements. Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name TIF - Northeast Residential Fund /Department Number 436 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,450,000 1,340,028 1,252,275 1,109,972 55% Local Income Taxes - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 10,000 374 7,795 8,742 2,205 78% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 2,460,000 374 1,347,823 1,261,017 1,112,177 55% Expenditures Personnel - - - - - 0% Supplies - - - - 0% Services 1,730 - 1,370 1,137 360 79% Debt Service 3,228,227 195,888 3,217,050 308,450 11,177 100% Capital - - - - - 0% Transfers Out - - - - - 0% Total Expenditures 3,229,957 195,888 3,218,420 309,587 11,537 100% Net (769,957) (195,514) (1,870,597) 951,430 1,100,640 Cash Balance 1,630,714 2,825,732 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aignmcam Kevenue, r-xpenaicure ano acarrmg i,nangesivanances oeiow: 2012 Debt service came from savings on project, not from this fund. rncam apenaing on t apnai r-rojecis neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Fund /Department Number 433 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 147 Grants /Intergovernmental 63% - - Charges for Services - - - Interest Earnings 150 6 94 Bond Proceeds - - - Donations - - 0% Other Income - 0% 3,033 2,661 Transfers In - - - Total Revenue 150 6 94 Expenditures 0% 3,033 2,661 Personnel - - - Supplies - - - Services 6,787 1,673 5,798 Debt Service - - - Capital Transfers Out - - - Total Expenditures 6,787 1,673 5,798 Net (6,637) (1,667) (5,704) Cash Balance 25,739 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmncan[ Kevenue, r-xpenaicure ano acarnng ,- nangesivanances aeiow: This fund's sole expenditure is for general legal fees for DCI based on an engagement letter rncam apenaing on t apnai r-rojecis neiow: 31 Form 3 0% 0% 0% 0% 0% 147 56 63% - - 0% 0% 0% 0% 147 56 63% - - 0% - - - 0% 3,033 2,661 (1,672) 125% - - 0% 0% - - 0% 3,033 2,661 (1,672) 125% 2.8861 (2.6611 1.728 31 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Fund /Department Number 439 Month I October Date Updated 1 11/14/2013 Current Current Current Prior 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes - - Grants /Intergovernmental 1,446,074 1,446,074 Charges for Services - - Interest Earnings 2,000 465 6,172 Bond Proceeds - - - Donations 0% Other Income 0% Transfers In - - - Total Revenue 1,448,074 465 1,452,246 Expenditures 0% Personnel - - - Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out Total Expenditures - - - 815.923 Net 1,448,074 465 1,452,246 Cash Balance 2,268,608 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances oeiow: State money received in 2013 was for 2012. No funds received in 2012. In 2011, funds received in December. The 2013 CTP payment of $1.41 million was deposited on 14 Nov 2013. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 100% 0% 3,132 (4,172) 309% - 0% 0% 0% - 0% 3,132 4,172 100% - 0% 0% 0% 0% 0% 0% - 0% 3,132 (4,172) 815.923 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances oeiow: State money received in 2013 was for 2012. No funds received in 2012. In 2011, funds received in December. The 2013 CTP payment of $1.41 million was deposited on 14 Nov 2013. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Fund /Department Number 454 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Local Income Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - Local Income Taxes 0% Other Taxes Grants /Intergovernmental Charges for Services - - - Interest Earnings 1,000 77 1,150 Bond Proceeds - - - Donations 115% Other Income - Transfers In - - - Total Revenue 1,000 77 1,150 Expenditures Personnel - - - Supplies 0% Services 150 Debt Service - Capital 0% Transfers Out Total Expenditures - - 0% Net 1,000 77 1,150 Cash Balance 376,232 Staffing 0% Full Time - Part-Time /Season al/Tem porary Total 0% Explain Significant Revenue, Expenditure and Staffing Changes /Variances Below: No significant issues. rncam apenaing on t apnai rrojects neiow: 37,240 0% - 0% 0% 0% - 0% 1,162 (150) 115% - - 0% 0% 0% 0% 38,402 150 115% - - 0% 0% 0% 0% 0% 0% 0% 3R A02 !1 Sn\ Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Golf Course Operations Fund /Department Number 619 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 201,288 88% - Grants /Intergovernmental - - - Charges for Services 1,696,879 88,457 1,495,591 Interest Earnings - - - Bond Proceeds 100% 1,619,561 201,288 Donations - - 0% Other Income - 0% - Transfers In 50,500 - 50,500 Total Revenue 1,747,379 88,457 1,546,091 Expenditures - 0% 2,187,206 Personnel - - - Supplies - - - Services 1,661,128 98,129 1,371,104 Debt Service 326,000 - 207,879 Capital 10,578 8,816 Transfers Out - - - Total Expenditures 1,997,706 98,129 1,587,799 Net (250,327) (9,672) (41,708) Cash Balance 215,964 Staffing Full Time - Part-Time /Season al/Tem porary Total fl rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: The early spring weather in 2012 was phenomenal, but in 2013 spring has been very cold, thus affecting revenue sharply.Trimmed expenses to offset late start as appropriate. Paid off bond in early 2013, so debt service expense in 2013 will be much under 2012. Course operations under outside contract with Kitson & Partners so all expenses except capital are shown under Services to show consistently with Parking Garages and Redevelopment Retail. Explain Significant Spending on Capital Projects Below: Equipment payments Form 3 0% 0% 0% 0% 1,619,561 201,288 88% - - 0% 0% 0% 0% 100% 1,619,561 201,288 88% - - 0% - - 0% 1,530,417 290,024 83% 651,500 118,121 64% 5,289 1,762 83% - - 0% 2,187,206 409,907 79% 1567_RA51 17nR_F; fl rxpiam aigmricanr Kevenue, r-xpenairure ano ararring i,nangesivanances aeiow: The early spring weather in 2012 was phenomenal, but in 2013 spring has been very cold, thus affecting revenue sharply.Trimmed expenses to offset late start as appropriate. Paid off bond in early 2013, so debt service expense in 2013 will be much under 2012. Course operations under outside contract with Kitson & Partners so all expenses except capital are shown under Services to show consistently with Parking Garages and Redevelopment Retail. Explain Significant Spending on Capital Projects Below: Equipment payments Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Central Development IMonth I October Fund /Department Number 314 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations - 0% Other Income 3,009 0% Transfers In - 0% Total Revenue 3,009 0% Expenditures Personnel - 0% Supplies 0% Services 0% Debt Service 0% Capital - 0% Transfers Out 825,509 0% Total Expenditures 825,509 0% Net (822,500) Cash Balance Staffing Full Time Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This is an old debt service fund for a bond which has paid off and there is no longer any cash in it. Fund can be closed. Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Fund /Department Number 315 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 5,000 213 3,181 5,012 1,819 64% Bond Proceeds - - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 5,000 213 3,181 5,012 1,819 64% Expenditures Personnel - - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 5,000 213 3,181 5,012 1,819 64% Total Expenditures 5,000 213 3,181 5,012 1,819 64% Net - Cash Balance 1,038,904 1,038,904 Staffing Full Time - Part-Time /Season al/Tem porary Total rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Fund /Department Number 317 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Local Income Taxes Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes Local Income Taxes Other Taxes Grants /Intergovernmental Charges for Services - - - Interest Earnings 3,500 103 1,538 Bond Proceeds - - - Donations Other Income Transfers In - - - Total Revenue 3,500 103 1,538 Expenditures Personnel - - - Supplies Services Debt Service Capital Transfers Out Total Expenditures - - - Net 3,500 103 1,538 Cash Balance 503,286 Staffing Full Time - Part-Time /Season al/Tem porary Total 0% 0% 0% 0% 0% 2,200 1,962 44% - - 0% 0% 0% 0% 2,200 1,962 44% - - 0% 0% 0% 0% 0% 0% 0% 2.200 1.962 501 rxpiam aigmricanr Kevenue, r-xpenairure ano ararring ,- nangesivanances aeiow: Debt service reserve fund. The fund is at the proper level per the bond financial advisor, Crowe Horvath. No additional transfers -in are needed. Any interest variations due to City policy on investments and increase in cash available to earn interest. rncanr apenaing on t apnai rrojecrs neiow: Form 3 Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Blackthorn Golf IMonth I October Fund /Department Number 319 1 Date Updated 11/14/2013 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 0% Local Income Taxes 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 50 464 4,245 (414) 928% Bond Proceeds - - - - 0% Donations 0% Other Income 0% Transfers In 0% Total Revenue 50 464 4,245 414 928% Expenditures Personnel - - - - 0% Supplies 0% Services 0% Debt Service 0% Capital 0% Transfers Out 326,050 326,464 658,245 414 100% Total Expenditures 326,050 326,464 658,245 (414) 100% Net (326,000) (326,000) (654,000) Cash Balance 326,000 Staffing Full Time Part-Time /Season al/Tem porary Total Explain Significant Revenue, Expenditure and Staffing Changes/variances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Generally only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Please note however: the corresponding bond was paid off in early 2013 so debt service reserve is released and no cash remains in the fund. This fund can now be closed. Explain Significant Spending on Capital Projects Below: Form 3 2013 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Fund /Department Number 328 Month I October Date Updated 1 11/14/2013 Current Current Current Prior Property Taxes 0% Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue 0% Property Taxes 0% Local Income Taxes 0% Other Taxes 0% 7,324 Grants /Intergovernmental 89% - - Charges for Services - - - Interest Earnings 6,000 356 5,315 Bond Proceeds - - - Donations - - 0% Other Income 0% Transfers In - - - Total Revenue 6,000 356 5,315 Expenditures 685 89% 7,324 Personnel - - - Supplies Services Debt Service Capital - - - Transfers Out 6,000 356 5,315 Total Expenditures 6,000 356 5,315 Net - - - Cash Balance 1,735,840 Staffing Full Time - Part-Time /Season al/Tem porary Total 1 rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 420). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. rncanr apenaing on t apnai r-rojecrs neiow: Form 3 0% 0% 0% 0% 0% 7,324 685 89% - - 0% 0% 0% 0% 7,324 685 89% - - 0% 0% 0% 0% 0% 7,324 685 89% 7,324 685 89% rxpiam aigmricanr Kevenue, r-xpenairure ano ararrmg %,nangesivanances aeiow: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 420). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. rncanr apenaing on t apnai r-rojecrs neiow: Form 3