The URL can be used to link to this page

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