The URL can be used to link to this page

Home My WebLink About03-2015 Departmental Financial ReportPeriod Ending: March 31, 2015 Issued By: Administration /Finance City of South Bend Monthly Departmental Financial Report Page Contents Mayor Pete Buttigieg 1 Narrative 2 Summaries 8 General Fund 22 Special Revenue Funds 56 Debt Service /Capital Project Funds 68 Enterprise Funds 94 Internal Service Funds 100 Trust Funds 103 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff Kathryn Roos Deputy Chief of Staff Brian Pawlowski South Bend Common Council Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Financial Specialist Senior Cecil Eastman Department Heads Fiscal Officers March 2015 The Monthly Departmental Financial Report The City of South Bend has developed the attached Monthly Departmental Financial Report to provide current year financial information for each City fund, as well as individual departments within the General Fund, in a condensed format. Information is provided for revenue, expenditures, encumbrances, cash balances and staffing levels. Also included in this report are text boxes that allow departmental fiscal officers to provide an explanation of significant expenditure and staffing variances and spending on major capital projects. Departmental fiscal officers are asked to complete the monthly financial reports ( "blue sheets ") for their funds and General Fund departments no later than the 201h of the month following the reporting period. The staff of the Department of Administration & Finance then summarizes the data 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 As of March 31, 2015, total revenue for the year was $47,635,753, 17% of estimated revenue. As of March 31, 2014 total revenue received was $42,854,677 within the same funds. Property taxes are received in June and December each year and are budgeted at $69,690,508 for 2015, 25% of annual budgeted revenues. Local income tax (LOIT, COIT and EDIT) receipts are budgeted to be $24.3 million in 2015; $4.1 million of that total was received as of 31 March. On March 4, 2015 the City closed on its sale of Blackthorn Golf Course to a private company and received $1,472,130 in proceeds at that time. This amount represented the City's portion of the $1.655 million sale price. As of March 31, 2015, total expenditures were $72,792,625 and outstanding encumbrances were $37,902,959, a total of $110,695,584 which represents 29% of the amended expenditure budget. Encumbrances are either holdovers from previous years or obligations for the remainder of the year. If encumbrances were excluded, expenditures were 19% of the amended expenditure budget at the end of the period. Total expenditures were $68,467,276 as of March 31, 2014. In March the Dept of Community Investment purchased hydraulic brake press equipment for $1.4 million as part of an agreement to assist with Nello Corporation's expansion on the west side of South Bend. We hope that you find this Monthly Departmental Financial Report useful in better understanding the finances of the City of South Bend. 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 March 31, 2015 Fund L Type Dept Name City Funds General Fund 52,642,236 931,673 3,333,378 3,287,606 1,894,807 6% Special Revenue 5,676,065 667,161 1,040,620 680,154 4,635,445 18% 102 Rainy Day 34,680 3,064 12,582 8,557 22,098 36% 103 Excess Levy - 1 2 - (2) 0% 201 Parks & Recreation 11,030,715 122,614 419,345 353,476 10,611,370 4% 202 Motor Vehicle Highway 9,681,300 404,476 2,253,955 1,086,264 7,427,345 23% 203 Recreation Nonreverting 1,578,935 112,441 276,649 271,406 1,302,286 18% 209 Studebaker - Oliver Reverting Grants 574,000 16,720 21,291 1,076 552,709 4% 210 Economic Development State Grants 1,673,510 112 473 387 1,673,037 0% 211 Department of Community Investment (DCI) 2,631,625 17,090 535,048 487,851 2,096,577 20% 212 Dept of Community Investment Grants 4,100,000 240,618 462,515 379,257 3,637,485 11% 216 Police State Seizures 35,900 876 1,080 157 34,820 3% 217 Gift, Donation, Bequest 216,100 364 2,972 21,188 213,128 1% 218 Police Curfew Violations 1,025 17 30 136 995 3% 220 Law Enforcement Continuing Education 211,000 17,376 70,693 60,562 140,307 34% 227 Loss Recovery 34,200 21,727 30,941 7,876 3,259 90% 244 Emergency Phone System - - 19 215,000 (19) 0% 249 Public Safety LOIT 6,472,190 430 1,079,495 1,596,977 5,392,695 17% 251 Local Roads & Streets 1,593,300 98,666 276,603 271,804 1,316,697 17% 258 Human Rights Federal Grant 203,400 5,759 15,012 14,074 188,388 7% 271 Eastrace Waterway - 2 8 14 (8) 0% 273 Morris PAC / Palais Royale Marketing 18,000 1,372 1,652 3,901 16,348 9% 280 Police Block Grants - 1 6 4 (6) 0% 281 Economic Develop. Commission- Revenue Bonds - 10 40 27 (40) 0% 289 HAZMAT 10,000 10 13,838 16 (3,838) 138% 291 Indiana River Rescue 45,200 3,038 8,554 12,096 36,646 19% 292 Police Grants 90,000 - 55 66,716 89,945 0% 294 Regional Police Academy 22,000 1,101 19,740 17,326 2,260 90% 295 COPS MORE Grant 128,258 681 2,026 2,812 126,232 2% 299 Police Federal Drug Enforcement 77,000 31,713 33,612 245 43,388 44% 404 County Option Income Tax 9,883,971 50,726 1,630,555 2,306,752 8,253,416 16% 408 Economic Development Income Tax 9,526,537 3,568 1,694,979 2,576,060 7,831,558 18% 410 Urban Development Action Grant 438,313 98,495 98,525 27 339,788 22% 655 Project Releaf 431,700 36,757 110,548 109,581 321,152 26% 705 Police K -9 Unit 2,000 1 505 1,002 1,495 25% Special Revenue Total 60,744,859 1,289,827 9,073,348 9,872,628 51,671,511 15% City Debt Service 313 Football Hall of Fame Debt Service 1,274,056 4,256 12,810 21,419 1,261,246 1% City Debt Service Total 1,274,056 4,256 12,810 21,419 1,261,246 1% Capital Project 377 Professional Sports Development 671,761 63,547 299,888 215,399 371,873 45% 401 Coveleski Stadium Capital 15,100 14 59 27 15,041 0% 403 Zoo Endowment 200 17 72 49 128 36% 405 Park Nonreverting Capital 143,700 261 4,956 8,191 138,744 3% 406 Cumulative Capital Development 542,691 4,517 13,832 12,371 528,859 3% 407 Cumulative Capital Improvement 422,150 23 290 84 421,860 0% 412 Major Moves Construction 811,187 1,357 373,522 234,753 437,665 46% 416 Morris Performing Arts Center Capital 101,500 9,946 19,800 29,428 81,700 20% 434 Community Revitalization Enhancement District 650,000 24 79 81 649,921 0% 450 Palais Royale Historic Preservation 16,150 380 2,628 2,310 13,522 16% 677 Football Hall of Fame Capital 2,500 196 812 650 1,688 32% Capital Project Total 3,376,939 80,282 715,938 503,343 2,661,001 21% Enterprise 287 Emergency Medical Services Capital 750,000 13 396,740 - 353,260 53% 288 Emergency Medical Services Operating 5,676,065 667,161 1,040,620 680,154 4,635,445 18% 600 Consolidated Building Fund 4,154,113 198,727 1,034,221 839,020 3,119,892 25% 601 Parking Garages 1,108,726 89,875 236,157 319,447 872,569 21% 610 Solid Waste Operations 5,712,289 406,879 1,216,903 1,193,211 4,495,386 21% 611 Solid Waste Capital 753,011 10,001 200,034 310,504 552,977 27% City of South Bend Monthly Department Financial Report REVENUE SUMMARY March 31, 2015 620 Water Works Operations 14,760,483 1,051,666 3,176,211 3,312,949 11,584,273 22% 622 Water Works Capital 10,000 1,098 4,556 3,504 5,444 46% 623 Water Works Bond Capital - 62 283 829 (283) 0% 624 Water Works Customer Deposit 6,000 527 2,157 1,444 3,843 36% 625 Water Works Sinking 2,050,078 170,359 511,378 512,820 1,538,700 25% 626 Water Works Bond Reserve - 572 2,351 27,229 (2,351) 0% 629 Water Works Reserve Operations & Maintenance 162,749 775 153,298 55,534 9,451 94% 640 Sewer Repair Insurance 549,200 50,328 154,971 143,154 394,229 28% 641 Sewage Works Operations 35,334,467 2,826,101 8,401,964 7,973,337 26,932,503 24% 642 Sewage Works Capital 5,398,000 1,313 5,512 4,004,427 5,392,488 0% 643 Sewage Works Reserve Operations & Maint. 250,612 1,248 261,101 133,310 (10,489) 104% 647 Sewer Bond 2007 - - - 2 - 0% 649 Sewage Sinking 9,288,088 774,198 2,322,320 2,326,299 6,965,768 25% 658 Sewer Bond 2010 - - - 2 - 0% 659 Sewer Bond 2011 6,000 386 2,193 7,553 3,807 37% 661 Sewer Bond 2012 20,000 5,897 24,535 17,999 (4,535) 123% 664 2013A Cost of Issuance Fund - 2 7 4 (7) 0% 670 Century Center 4,532,562 203,146 1,019,635 1,099,295 3,512,927 22% 671 Century Center Capital 500 23 68 87 432 14% Enterprise Total 90,522,943 6,460,355 20,167,214 22,962,114 70,355,729 22% Internal Service 222 Central Services 8,121,097 709,666 2,054,157 2,079,462 6,066,940 25% 224 Central Services Capital 271,850 - - - 271,850 0% 226 Liability Insurance 1,260,227 103,815 311,266 753,925 948,961 25% 278 Take Home Vehicle Police 124,200 9,529 33,578 33,413 90,622 27% 711 Self- Funded Employee Benefits 16,223,345 1,217,884 3,692,829 2,936,386 12,530,516 23% 713 Unemployment Compensation 226,796 8,558 25,769 25,847 201,027 11% Internal Service Total 26,227,515 2,049,451 6,117,599 5,829,033 20,109,916 23% Trust& Agency 701 Firefighters Pension 5,211,592 54 872 711 5,210,720 0% 702 Police Pension 6,360,000 184 1,546 1,414 6,358,454 0% 730 City Cemetery 150 10 41 37 109 28% Trust & Agency Total 11,571,742 247 2,459 2,162 11,569,283 0% City Funds Total 246,360,290 10,816,092 39,422,747 42,478,304 159,523,492 16% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 20,324,106 6,479,376 6,562,954 24,493 13,761,152 32% 420 Tax Incremental Financing (TIF) - Downtown 4,344,202 (4,935) - 76,770 4,344,202 0% 422 TIF - West Washington 422,000 423 1,680 588 420,320 0% 425 Redevelopment Retail & Leighton Plaza 189,123 10,040 41,239 37,721 147,884 22% 426 TIF - Central Medical Service Area 632,000 (2,442) - 3,036 632,000 0% 429 River East Development Area (NE Dev TIF) 827,000 1,434,000 1,458,208 2,950 (631,208) 176% 430 TIF - Southside Development #1 2,410,000 1,590 6,758 3,317 2,403,242 0% 435 TIF - Douglas Road 320,750 23 232 278 320,518 0% 436 River East Residential (NE Res TIF) 2,604,000 5 1,571 1,666 2,602,429 0% Tax Increment Financing Total 32,073,181 75918,080 8,072,642 150,819 24,000,539 25% Redevelopment 433 Redevelopment General 252 4 15 22 237 6% 439 Certified Technology Park 4,404 1,780 7,309 3,657 (2,905) 166% 454 Airport Urban Enterprise Zone 1,500 134 550 374 950 37% 619 Blackthorn Operations 1,696,879 - 119,238 212,195 1,577,641 7% Redevelopment Total 1,703,035 1,918 127,112 216,248 1,575,923 7% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 368 1,511 1,031 3,489 30% 317 Coveleski Debt Service Reserve 1,800 179 735 500 1,065 41% 328 Redevelopment Bond - Palais Royale 6,000 615 2,525 1,723 3,475 42% 432 TIF - Southside Development #3 25,000 1,967 8,481 6,051 16,519 34% Debt Service Total 37,800 3,129 13,252 9,306 24,548 35% 3 City of South Bend Monthly Department Financial Report REVENUE SUMMARY March 31, 2015 Grand Total 280,174,306 18,739,219 47,635,753 42,854,677 185,124,502 17% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY March 31, 2015 Type Name Budget Actual Actual Actual Encumbrances Balance Budget dftep.rtment City Funds General Fund 101 -0101 Mayor's Office 741,267 48,451 181,465 178,552 181 559,621 25% 101 -0104 311 Call Center 486,733 43,995 135,480 109,227 1,690 349,563 28% 101 -0201 City Clerk 431,573 26,114 89,159 82,965 20,112 322,302 25% 101 -0301 Common Council 490,150 110,974 169,646 72,628 62,549 257,955 47% 101 -0302 WNIT Contract 43,000 - - - - 43,000 0% 101 -0401 Administration & Finance 2,008,924 139,737 461,538 461,625 40,120 1,507,266 25% 101 -0404 Morris Performing Arts Center 1,093,132 80,670 265,098 261,103 37,033 791,001 28% 101 -0405 Palais Royale 536,293 39,827 112,844 111,532 30,181 393,268 27% 101 -0501 Legal Department 1,018,599 64,724 237,032 260,301 15,323 762,269 25% 101 -0602 Engineering 1,058,933 89,919 242,520 230,888 102,632 713,781 33% 101 -0801 Police Department 25,633,064 1,990,424 6,426,566 6,089,052 295,880 18,910,618 26% 101 -0802 Communications Center 1,687,540 8 135,135 495,828 - 1,552,405 8% 101 -0901 Fire Department 17,774,474 1,505,644 5,246,462 5,201,981 251,433 12,276,579 31 101 -1008 Human Rights 373,179 19,693 101,912 82,595 10,508 260,759 30% 101 -1201 Code 2013 2,270 - - 1,980 2,269 1 100% 101 -0805 Police LOT 2013 - (8,761) - - - - 0% 101 -0905 Fire LOT 2013 411 - (411) 0% 101 -1207 Animal Control 2013 - - - 612 - - 0% General Fund Total 53,379,131 4,151,418 13,805,268 13,640,869 869,911 38,699,977 27% Special Revenue 201 Parks & Recreation 11,063,995 893,746 2,879,469 2,998,893 416,908 7,767,618 30% 202 Motor Vehicle Highway 10,485,386 866,852 2,704,804 2,444,318 242,296 7,538,286 28% 203 Recreation Nonreverting 1,549,469 66,785 171,640 170,766 115,479 1,262,350 19% 209 Studebaker - Oliver Reverting Grants 630,000 6,335 9,710 - 557,710 62,580 90 210 Economic Development State Grants 3,694,412 18,003 30,203 18,003 10,200 3,654,009 1 211 Department of Community Investment (DCI) 2,661,730 186,881 616,253 579,779 35,474 2,010,003 24% 212 Dept of Community Investment Grants 6,547,968 161,537 415,275 357,346 2,847,850 3,284,843 50 216 Police State Seizures 35,900 - - - - 35,900 0 217 Gift, Donation, Bequest 297,182 136 27,966 53,845 215,371 28% 218 Police Curfew Violations 1,000 - - - - 1,000 0% 220 Law Enforcement Continuing Education 362,478 27,290 72,294 54,768 24,122 266,062 27% 227 Loss Recovery 5,237,243 822,026 1,302,296 213,901 2,888,927 1,046,020 80% 244 Emergency Phone System - (21) - 60,389 - - 0% 249 Public Safety LOIT 7,246,551 549,323 1,796,725 1,840,232 - 5,449,826 25% 251 Local Roads & Streets 1,926,221 37,032 46,040 43,282 998,540 881,641 54% 258 Human Rights Federal Grant 247,357 26,033 57,262 40,287 17,785 172,310 30% 271 Eastrace Waterway 4,000 - - - 1,098 2,902 27% 273 Morris PAC / Palais Royale Marketing 18,974 96 4,610 2,358 16,520 13 289 HAZMAT 31,530 - 21,542 - - 9,988 68% 291 Indiana River Rescue 120,800 21,395 23,514 1,483 97,286 19% 292 Police Grants 105,145 - 15,297 138,059 89,848 15% 294 Regional Police Academy 23,750 242 12,639 663 - 11,111 53% 295 COPS MORE Grant 172,335 4,486 25,760 2,845 10,245 136,330 21 299 Police Federal Drug Enforcement 248,960 18,397 43,255 6,570 13,781 191,924 23% 404 County Option Income Tax 15,660,371 799,781 2,919,293 2,445,532 1,245,028 11,496,050 27% 408 Economic Development Income Tax 9,627,618 126,960 2,499,254 2,650,433 405,607 6,722,757 30% 410 Urban Development Action Grant 438,203 - - - - 438,203 0 655 Project Releaf 528,358 2,386 20,025 19,973 508,333 4 705 Police K -9 Unit 2,000 970 970 - 1,030 49% Special Revenue Total 78,968,936 4,636,577 15,711,581 14,092,132 9,887,252 53,370,103 32% City Debt Service 313 Football Hall of Fame Debt Service 1,266,820 - 636,000 634,500 - 630,820 50% City Debt Service Total 1,266,820 636,000 634,500 630,820 50% Capital Project 377 Professional Sports Development 854,803 481,573 383,673 373,230 56% 403 Zoo Endowment 49,000 - - 49,000 0 405 Park Nonreverting Capital 192,933 - 116,776 30,038 162,895 16 406 Cumulative Capital Development 542,691 56,546 169,196 169,196 - 373,495 31 407 Cumulative Capital Improvement 365,625 - 183,750 185,250 - 181,875 50% 412 Major Moves Construction 3,096,061 335,865 545,253 214,129 2,117,805 433,003 86% City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY March 31, 2015 416 Morris Performing Arts Center Capital 70,248 11,946 14,879 2,911 13,448 41,920 40 434 Community Revitalization Enhancement District 650,000 - 3,897 20,975 - 646,103 1 450 Palais Royale Historic Preservation 16,150 - - - 16,150 0% 677 Football Hall of Fame Capital 188,824 5,998 19,211 20,283 - 169,613 10 Capital Project Total 6,026,335 410,355 1,417,759 1,113,193 2,161,291 2,447,285 59% Enterprise 287 Emergency Medical Services Capital 750,000 - 35,728 - - 714,272 5 288 Emergency Medical Services Operating 6,855,366 210,228 490,484 1,089,288 287,290 6,077,592 11 600 Consolidated Building Fund 4,205,401 235,473 742,896 634,684 227,558 3,234,947 23 601 Parking Garages 1,806,712 64,293 266,924 174,914 145,688 1,394,100 23% 610 Solid Waste Operations 5,873,863 339,903 1,316,442 1,564,177 348,912 4,208,508 28% 611 Solid Waste Capital 752,811 11,054 234,946 389,673 - 517,865 31 620 Water Works Operations 15,844,471 1,174,812 3,488,646 3,366,276 719,147 11,636,677 27% 622 Water Works Capital 838,893 3,489 86,334 3,600 - 752,559 10% 623 Water Works Bond Capital 53,085 4,276 53,304 217,508 (219) 100% 624 Water Works Customer Deposit 6,000 527 1,302 1,444 4,698 22 625 Water Works Sinking 2,050,078 84 550 390 2,049,528 0 629 Water Works Reserve Operations & Maintenance 8,500 775 1,866 2,027 6,634 22 640 Sewer Repair Insurance 545,703 43,434 122,027 71,386 66,244 357,432 35 641 Sewage Works Operations 38,196,974 2,293,345 7,414,229 11,072,408 1,243,177 29,539,568 23% 642 Sewage Works Capital 9,071,710 402,228 488,448 1,817,302 3,237,392 5,345,870 41 643 Sewage Works Reserve Operations & Maint. 15,000 1,248 3,040 3,346 - 11,960 20 649 Sewage Sinking 9,282,109 - 1,850 1,350 - 9,280,259 0% 659 Sewer Bond 2011 3,711,838 246,856 892,692 686,071 708,427 2,110,719 43% 661 Sewer Bond 2012 16,624,275 234,187 522,432 506,441 3,223,072 12,878,771 23% 670 Century Center 4,532,562 289,305 881,249 1,065,765 - 3,651,313 19% 671 Century Center Capital 66,156 - 66,156 - - - 100 Enterprise Total 121,091,507 5,555,515 17,111,546 22,668,048 10,206,907 93,773,054 23% Internal Service 222 Central Services 8,300,242 691,937 1,993,337 1,971,490 2,484,317 3,822,588 54% 224 Central Services Capital 271,850 - - - - 271,850 0 226 Liability Insurance 3,056,791 132,053 649,845 805,469 71,621 2,335,325 24 278 Take Home Vehicle Police 71,100 - - - - 71,100 0 711 Self- Funded Employee Benefits 16,696,935 1,093,990 3,088,387 3,649,999 296,830 13,311,718 20% 713 Unemployment Compensation 226,796 9,024 24,318 38,190 13,200 189,278 17 Internal Service Total 28,623,714 1,927,005 5,755,886 6,465,148 2,865,969 20,001,859 30% Trust & Agency 701 Firefighters Pension 5,666,579 450,317 1,332,784 1,354,393 - 4,333,795 24% 702 Police Pension 6,832,235 559,034 1,620,158 1,832,078 5,212,077 24% 730 City Cemetery 20,000 - - - 20,000 0 Trust & Agency Total 12,518,814 1,009,351 2,952,942 3,186,471 9,565,872 24% City Funds Total 25,991, Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF) 47,710,597 1,736,337 5,697,767 2,327,678 9,669,849 32,342,981 32% 420 Tax Incremental Financing (TIF) - Downtown 4,537,169 4,081,705 4,088,473 1,382,068 - 448,696 90% 422 TIF- West Washington 760,900 7,650 22,950 319 7,650 730,300 4% 425 Redevelopment Retail & Leighton Plaza 154,716 17,748 34,372 31,584 - 120,344 22 426 TIF - Central Medical Service Area 2,476,033 2,294,533 2,294,533 169,224 - 181,500 93 429 River East Development Area (NE Dev TIF) 7,239,524 - 117,956 617 187,223 6,934,345 4 430 TIF - Southside Development #1 2,842,535 62,421 522,222 259,652 683,207 1,637,106 42 435 TIF - Douglas Road 345,389 - 169,620 95,391 4,200 171,569 50 436 River East Residential (NE Res TIF) 3,425,632 - 1,710,589 1,865,291 - 1,715,043 50 Tax Increment Financing Total 69,492,495 8,200,394 14,658,482 6,131,824 10,552,129 44,281,884 36% Redevelopment 433 Redevelopment General 6,000 - - 10,212 - 6,000 0 439 Certified Technology Park 5,000,000 198 198 - 1,359,500 3,640,302 27% 619 Blackthorn Operations 1,671,706 22,845 181,258 167,519 - 1,490,448 11% L City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY March 31, 2015 Redevelopment Total 6,677,706 23,043 181,456 177,731 1,359,500 5,136,750 23% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 368 912 1,031 - 4,088 18% 328 Redevelopment Bond - Palais Royale 6,000 615 1,524 1,723 4,476 25% 432 TIF - Southside Development #3 691,380 - 559,269 354,606 132,111 81% Debt Service Total 702,380 983 561,705 357,360 140,675 80% Redevelopment Commission Controlled Funds Total 76,872,581 8,224,4 11,911,629 49,559,309 Grand Total 378,747,838 25,914,639 72,792,625 68,467,276 37,902,959 268,048,279 29% 7 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name Mayor's Office Month March Fund /Department Number 101 -0101 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 740,667 48,436 181,415 178,139 - 559,252 24% Local Income Taxes - - - - - - 0% Other Taxes - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - 15 50 413 - (50) 0% Other Income 600 - - - - 600 0% Transfers In - - - - - - 0% Total Revenue 741,267 48,451 181,465 178,552 - 559,802 24% Expenditures Personnel 669,877 50,053 170,332 155,060 - 499,545 25% Supplies 12,413 1,657 3,215 4,967 167 9,031 27% Services 56,739 (3,809) 7,221 17,828 14 49,504 13% Debt Service 2,238 550 697 697 - 1,541 31% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 741,267 48,451 181,465 178,552 181 559,621 25% Net - - - - IlRlil 181 Cash Balance - - Staffing Full Time 7.00 7.00 7.00 Part -Time /Seasonal /Temporary 2.00 1.00 1.00 Total 9.00 8.00 8.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Expenditures higher in personnel due to three payrolls occurring in January. This month, a negative occurred in the "Services" category as hotel charges were reclassified to 311 expenditures. Explain Significant Spending on Capital Projects Below: There are no capital projects budgeted for 2015. Form 3 Form 3 2015 City of South Bend Monthly Financial Report Fund /Department Name 311 Call Center Month March Fund /Department Number 101 -0104 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 16,442 - - (26,509) - 16,442 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 470,291 43,995 135,480 135,736 - 334,811 29% Transfers In - - - - - - 0% Total Revenue 486,733 43,995 135,480 109,227 - 351,253 28% Expenditures Personnel 441,562 35,265 115,348 96,404 - 326,214 26% Supplies 6,125 706 1,352 9,316 - 4,773 22% Services 39,046 8,024 18,779 3,507 1,690 18,577 52% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 486,733 43,995 135,480 109,227 1,690 349,563 28% Net - - - - (1,690) 1,690 Cash Balance - - Staffing Full Time 6.50 6.50 6.50 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 7.50 7.50 7.50 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: We have budgeted the use of some Property Tax revenues in 2015 - indicating that the department needs to rely somewhat on property taxes in order to cover its budget for 2015. However, at this point, we have not had to utilize any of those funds. The department has paid for itself. Explain Significant Spending on Capital Projects Below: No capital expenditures budgeted in 2015. Form 3 Form 3 10 2015 City of South Bend Monthly Financial Report Fund /Department Name City Clerk Month March Fund /Department Number 101 -0201 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 431,573 26,114 89,159 82,965 - 342,414 21% 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 431,573 26,114 89,159 82,965 - 342,414 21% Expenditures Personnel 339,442 23,787 80,790 73,034 - 258,652 24% Supplies 7,740 568 712 2,291 1,000 6,028 22% Services 70,991 1,758 7,656 7,640 19,112 44,223 38% Debt Service - - - - - - 0% Capital 13,400 - - - - 13,400 0% Transfers Out - - - - - - 0% Total Expenditures 431,573 26,114 89,159 82,965 20,112 322,302 25% Net - - - - (20,112) 20,112 Cash Balance - - Staffing Full Time 5.00 5.00 5.00 Part -Time /Seasonal /Temporary - - - Total 5.00 5.00 5.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Expenditures are consistent with normal operating costs. Explain Significant Spending on Capital Projects Below: This year, a copier has been budgeted for capital expenditures. Form 3 10 2015 City of South Bend Monthly Financial Report Fund /Department Name Common Council Fund /Department Number 101 -0301 Month March Date Updated 4/13/2015 Current Current Current Prior 72,534 Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Bud et Property Taxes /Non -Dept Revenue 481,684 110,958 169,559 72,534 312,125 35% Local Income Taxes - - - - - 0% Other Taxes 0% Grants /Intergovernmental 0% Charges for Services 0% Interest Earnings 0% Bond Proceeds 0% Donations 8,466 15 86 95 8,380 1% Other Income - - - - - 0% Transfers In - - - - - 0% Total Revenue 490,150 110,974 169,646 72,628 320,504 35% Expenditures Personnel 243,742 16,159 54,919 52,335 - 188,823 23% Supplies 4,706 34 403 186 999 3,304 30% Services 241,702 94,781 114,324 20,107 61,550 65,828 73% Debt Service - - - - - - 0% Capital 0% Transfers Out 0% Total Expenditures 490,150 110,974 169,646 72,628 62,549 257,955 47% Net - - 62,549 62,549 Cash Balance Staffing Full Time 9.00 9.00 9.00 Part-Time /Seasonal/Temporary - - - Total 9.00 9.00 9.00 t:xpiam aignincam Kevenue, t:xpenanure ana warring tnangesnrariances tseiow: There are nine (9) Council Members. One member has declined to receive a salary. Expenditures higher than normal due to unforseen legal expenses. Explain Significant Spending on Capital Projects Below: Form 3 11 2015 City of South Bend Monthly Financial Report Fund /Department Name WNIT Contract Month March Fund /Department Number 101 -0302 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 43,000 - - - - 43,000 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 43,000 - - - - 43,000 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 43,000 - - - - 43,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 43,000 - - - - 43,000 0% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This annual expenditure was previously paid from the Council department (101 -0301) but was segregated upon the Council's request. Explain Significant Spending on Capital Projects Below: Form 3 iVA Form 3 13 2015 City of South Bend Monthly Financial Report Fund /Department Name Administration & Finance Month March Fund /Department Number 101 -0401 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 1,978,874 139,401 460,982 461,625 - 1,517,892 23% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 30,050 336 556 - - 29,494 2% Transfers In - - - - - - 0% Total Revenue 2,008,924 139,737 461,538 461,625 - 1,547,386 23% Expenditures Personnel 1,806,651 125,803 434,312 421,304 - 1,372,339 24% Supplies 28,109 3,984 7,626 5,129 7,657 12,826 54% Services 171,593 9,950 18,957 34,549 32,463 120,173 30% Debt Service 2,571 - 643 643 - 1,928 25% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,008,924 139,737 461,538 461,625 40,120 1,507,266 25% Net - - - - (40,120) 40,120 Cash Balance - - Staffing Full Time 22.00 22.00 Part -Time /Seasonal /Temporary - 1.00 Total 22.00 23.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Transferred Chief Technology Officer to COIT for 2015 budget and added new HR Generalist position. Overall spending appears consistent with expectations. Explain Significant Spending on Capital Projects Below: None Form 3 13 Form 3 14 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Month March Fund /Department Number 101 -0404 Date Updated 4/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 170,132 (47,755) 60,044 15,282 - 110,088 35% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 917,000 128,316 203,261 243,602 - 713,739 22% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 110 1,793 2,219 - 4,207 30% Transfers In - - - - - - 0% Total Revenue 1,093,132 80,670 265,098 261,103 - 828,034 24% Expenditures Personnel 749,285 55,202 187,615 174,342 3,663 558,007 26% Supplies 33,542 1,540 4,650 4,949 9,939 18,952 43% Services 310,305 23,929 72,833 81,812 23,431 214,041 31% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,093,132 80,670 265,098 261,103 37,033 791,001 28% Net - - - - (37,033) 37,033 Cash Balance - - Staffing Full Time 12.00 12.00 Part -Time /Seasonal /Temporary 4.00 4.00 Total 16.00 16.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Royal Box Leasing revenue is expected to be received in the month of December and not in March as in previous years. Explain Significant Spending on Capital Projects Below: There are no Capital Expenses budgeted for this year. This is an Operating Budget. By Ordinance, 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. There are no Capital Expenses / Projects budgeted this year. Form 3 14 Form 3 W1 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Month March Fund /Department Number 101 -0405 Date Updated 4/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 201,473 26,254 65,556 67,407 - 105,736 33% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 315,820 12,973 44,363 41,684 - 271,457 14% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 19,000 599 2,925 2,441 - 16,075 15% Transfers In - - - - - - 0% Total Revenue 536,293 39,827 112,844 111,532 - 393,268 21% Expenditures Personnel 263,505 18,824 63,510 59,467 1,377 198,618 25% Supplies 23,897 443 1,352 1,964 5,074 17,471 27% Services 234,891 20,560 47,982 50,101 23,168 163,741 30% Debt Service - - - - - - 0% Capital 14,000 - - - 562 13,438 4% Transfers Out - - - - - - 0% Total Expenditures 536,293 39,827 112,844 111,532 30,181 393,268 27% Net - - - - (30,181) - Cash Balance - - Staffing Full Time 2.00 2.00 2.00 Part -Time /Seasonal /Temporary 1.00 1.00 1.00 Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: AN Upgrades (screen, projector, computer). Curtain replacement project ($30,000.00) defer to 2016. Form 3 W1 Form 3 W" 2015 City of South Bend Monthly Financial Report Fund /Department Name Legal Department Month March Fund /Department Number 101 -0501 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 965,599 64,724 236,524 259,234 - 729,075 24% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 3,000 - - 1,049 - 3,000 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 50,000 - 508 18 - 49,492 1% Transfers In - - - - - - 0% Total Revenue 1,018,599 64,724 237,032 260,301 - 781,567 23% Expenditures Personnel 955,213 59,146 224,024 250,887 - 731,189 23% Supplies 6,832 1,811 2,811 1,153 - 4,021 41% Services 55,254 3,767 9,879 7,943 14,369 31,006 44% Debt Service 1,300 - 318 318 954 28 98% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,018,599 64,724 237,032 260,301 15,323 766,244 25% Net - - - - (15,323) 15,323 Cash Balance - - Staffing Full Time 11.60 11.60 Part -Time /Seasonal /Temporary - - Total 11.60 11.60 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Other Income of $50,000 is reimbursement for legal expenses from TIF funds which will be received in December 2015. Encumbrances are the reason the expenses appear higher for February 2015. The encumbrances relate to subscriptions paid monthly, debt sevices paid quarterly, and office supplies. Spending appears to be on track with budgeted figures. Explain Significant Spending on Capital Projects Below: Form 3 W" Form 3 17 2015 City of South Bend Monthly Financial Report Fund /Department Name Engineering Month March Fund /Department Number 101 -0602 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 981,906 89,694 242,295 230,773 - 739,611 25% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 77,027 225 225 115 - 76,802 0% Transfers In - - - - - - 0% Total Revenue 1,058,933 89,919 242,520 230,888 - 816,413 23% Expenditures Personnel 710,552 47,373 150,402 144,282 - 560,150 21% Supplies 29,262 11,446 15,649 4,242 22 13,591 54% Services 306,044 29,056 71,223 79,162 100,665 134,156 56% Debt Service 13,075 2,044 5,246 3,202 1,944 5,885 55% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,058,933 89,919 242,520 230,888 102,632 713,781 33% Net - - - - (102,632) 102,632 Cash Balance - - Staffing Full Time 7.90 6.50 Part -Time /Seasonal /Temporary 1.22 1.73 Total 9.12 8.23 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: $100,665 in encumbrance for Services include $72,500 for water system evaluation, $12,000 for a portion of street design for Bendix Dr., $7,600 for 13th floor renovation from 2014 and $9,000 for 2015 travel booked in 2014. Other income includes reimbursement from the River West (f /k /a Airport) TIF for 80% of the salary of a new engineer who is scheduled to begin near the end of May. Explain Significant Spending on Capital Projects Below: Form 3 17 Form 3 18 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Department Month March Fund /Department Number 101 -0801 Date Updated 4/9/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 25,095,364 1,952,058 6,370,224 6,010,748 - 18,725,140 25% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 200,000 25 25 40 - 199,975 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations 7,500 - 500 - - 7,000 7% Other Income 330,200 38,341 55,817 78,264 - 274,383 17% Transfers In - - - - - - 0% Total Revenue 25,633,064 1,990,424 6,426,566 6,089,052 - 19,206,498 25% Expenditures Personnel 22,989,224 1,682,335 5,699,810 5,076,763 - 17,289,414 25% Supplies 419,279 32,677 129,476 323,285 100,781 189,022 55% Services 2,201,409 274,976 595,564 655,463 195,099 1,410,746 36% Debt Service 23,152 436 1,716 962 - 21,436 7% Capital - - - 32,579 - - 0% Transfers Out - - - - - - 0% Total Expenditures 25,633,064 1,990,424 6,426,566 6,089,052 295,880 18,910,618 26% Net - - - - (295,880) 295,880 Cash Balance - - Staffing Full Time 263.00 258.00 258.00 Part -Time /Seasonal /Temporary 60.00 30.00 30.00 Total 323.00 288.00 288.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund includes the expenditures for 217 of the 260 budgeted Police officers and 106 civilian staff. Fund 249 contains the funding for 43 of the 260 Police officers that are funded by the LOIT. The 2015 Personnel Expenditure exceeds the prior year amount due to the increase in Police salaries and the transfer of eight Front Desk Staff from the Communications Budget to the Police Budget in 2015. Supllies and Services expenditures show 55% and 36% of the Budget as used through March. This is due to the 2014 encumberances reflected as a use in March. These categories are expected to be on budget for the year. Explain Significant Spending on Capital Projects Below: Form 3 18 2015 City of South Bend Monthly Financial Report Fund /Department Name Communications Center Month March Fund /Department Number 101 -0802 Date Updated 4/9/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 1,687,540 8 135,135 495,828 - 1,552,405 8% 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 1,687,540 8 135,135 495,828 - 1,552,405 8% Expenditures Personnel 143,972 8 135,135 493,827 - 8,837 94% Supplies - - - 60 - - 0% Services 1,543,568 - - 1,941 - 1,543,568 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,687,540 8 135,135 495,828 - 1,552,405 8% Net - - - - - - Cash Balance - - Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Prior to December 31, 2014, this fund captured the cost of 35 of the 38 civilians and equipment to maintain the 911 communication center. Effective January 1, 2015 the County PSAP has consolidated the 911 call centers and SBPD no longer maintains a call center. The Personnel costs in January are the 2014 salary costs for the Communications staff paid in 2015. There are no additional salaries to be paid. The Services budget of $1,543,568 is the annual amount that the County will charge SBPD as a participant in using the PSAP. Explain Significant Spending on Capital Projects Below: Form 3 19 2015 City of South Bend Monthly Financial Report Fund /Department Name Fire Department Month March Fund /Department Number 101 -0901 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 17,762,474 1,467,857 5,139,029 5,057,701 12,623,445 29% Local Income Taxes - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 6,000 36,788 103,487 143,820 - (97,487) 1725% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 6,000 999 3,946 460 - 2,054 66% Transfers In - - - - 0% Total Revenue 17,774,474 1,505,644 5,246,462 5,201,981 - 12,528,012 30% Expenditures Personnel 15,737,086 1,378,443 4,903,631 4,766,543 120,372 10,713,083 32% Supplies 320,618 15,061 36,759 86,418 26,950 256,909 20% Services 1,216,770 112,141 306,072 349,020 104,111 806,587 34% Debt Service - - - - - 0% Capital - - - - - - 0% Transfers Out 500,000 - - - - 500,000 0% Total Expenditures 17,774,474 1,505,644 5,246,462 5,201,981 251,433 12,276,579 31% Net - - - - (251,433) 251,433 Cash Balance - - Staffing Full Time 170.00 167.00 167.00 Part -Time /Seasonal /Temporary - - - Total 170.00 167.00 167.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The South Bend Fire Department is budgeted to have 251 sworn firefighters and 7 civilian full time employees. 37 firefighters are paid directly through the Public Safety LOIT. 47 Sworn Employee's and 4 civilian employee's costs are allocated to Fund 288 EMS Operations. We hold a lengthy recruitment process every 2 years and hire individuals in groups of 6 -10 as needed while that list is in effect. We also employ civilian administrative staff that handle payroll, purchasing and billing for our ambulance service. Explain Significant Spending on Capital Projects Below: The Fire Department uses EMS Capital Fund 287 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through that fund. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Form 3 20 Form 3 21 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Month March Fund /Department Number 101 -1008 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes /Non -Dept Revenue 373,179 19,693 101,912 82,595 - 271,267 27% 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 373,179 19,693 101,912 82,595 - 271,267 27% Expenditures Personnel 286,475 13,615 75,267 68,489 - 211,208 26% Supplies 2,010 40 174 508 400 1,436 29% Services 73,492 6,039 16,065 13,598 10,108 47,320 36% Debt Service - - - - - - 0% Capital 11,202 - 10,407 - - 795 93% Transfers Out - - - - - - 0% Total Expenditures 373,179 19,693 101,912 82,595 10,508 260,759 30% Net - - - - (10,508) 10,508 Cash Balance - - Staffing Full Time 4.00 4.00 4.00 Part -Time /Seasonal /Temporary - - - Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Expenditures higher in personnel than last year, as there were three pay payrolls in the month of January. Explain Significant Spending on Capital Projects Below: Human Rights had money encumbered from last year for a copier. Purchase was made in January. Form 3 21 Form 3 RIVA 2015 City of South Bend Monthly Financial Report Fund /Department Name Rainy Day Month March Fund /Department Number 102 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 34,680 3,064 12,582 8,557 - 22,098 36% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 34,680 3,064 12,582 8,557 - 22,098 36% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 34,680 3,064 12,582 8,557 - 22,098 Cash Balance 8,654,770 8,626,262 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 resulting in South Bend's good AA bond rating with Standard & Poor's. Explain Significant Spending on Capital Projects Below: N/A Form 3 RIVA 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Levy Month March Fund /Department Number 103 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 1 2 - - (2) 0% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 2 - - (2) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 2 - Cash Balance 3,650 - Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: A small excess of property tax was received in December 2014. Explain Significant Spending on Capital Projects Below: N/A Form 3 23 Form 3 24 2015 City of South Bend Monthly Financial Report Fund /Department Name Parks & Recreation Month March Fund /Department Number 201 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 7,340,000 - 7,340,000 0% Local Income Taxes - - 0% Other Taxes 626,039 - 626,039 0% Grants /Intergovernmental 884,836 73,736 221,209 182,347 - 663,627 25% Charges for Services 2,025,640 41,644 150,072 167,847 - 1,875,568 7% Interest Earnings 10,000 776 4,148 3,045 - 5,852 41% Bond Proceeds - - 0% Donations - - 0% Other Income 144,200 6,457 43,916 237 - 100,284 30% Transfers In - - - 0% Total Revenue 11,030,715 122,614 419,345 353,476 - 10,611,370 4% Expenditures Personnel 7,105,699 465,028 1,576,438 1,714,797 3,917 5,525,344 22% Supplies 1,109,836 172,214 259,980 251,045 314,484 535,372 52% Services 2,443,703 161,127 946,446 956,859 98,506 1,398,751 43% Debt Service 309,257 95,377 96,605 71,192 - 212,652 31% Capital 5,000 - 0% Transfers Out 95,500 - - - - 95,500 0% Total Expenditures 11,063,995 893,746 2,879,469 2,998,893 416,908 7,767,618 30% Net (33,280) (771,132) (2,460,124) (2,645,417) (416,908) 2,843,752 Cash Balance 1,040,167 1,611,113 Staffing Full Time 90.00 87.00 87.00 Part-Time /Seasonal /Temporary na 49.00 49.00 Total 90.00 136.00 136.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund 201 accounts for the annual operation of the Parks and Recreation Department. There are six divisions within the department: Administration, Maintenance, Golf, Recreation, Greenhouse, and Graffiti. In 2014 the Potawatomi Zoo began operation by the Potawatomi Zoological Society. Part time staffing is individuals, not FTEs. Property tax and other tax revenues are received in June and December of the year. Explain Significant Spending on Capital Projects Below: Because of decreasing property tax revenues, there is no capital budget in fund 201. A $5.6 million bond has been approved and funding is expected to be received in the second quarter of 2015. Form 3 24 Form 3 `�7 2015 City of South Bend Monthly Financial Report Fund /Department Name Motor Vehicle Highway Month March Fund /Department Number 202 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,697,000 392,866 1,354,973 996,237 - 4,342,027 24% Grants /Intergovernmental - - - 0% Charges for Services 265,000 10,230 53,252 77,955 - 211,748 20% Interest Earnings 7,000 1,380 5,727 3,342 - 1,273 82% Bond Proceeds - - - 0% Donations - - - 0% Other Income 9,300 1,753 8,731 - 7,547 19% Transfers In 3,703,000 838,250 - 2,864,750 23% Total Revenue 9,681,300 404,476 2,253,955 1,086,264 - 7,427,345 23% Expenditures Personnel 4,314,548 284,243 1,110,640 1,138,405 3,203,908 26% Supplies 2,631,854 305,681 814,589 568,207 139,655 1,677,610 36% Services 2,951,520 175,832 642,842 642,563 102,641 2,206,037 25% Debt Service 448,006 61,637 97,275 35,955 350,731 22% Capital 139,458 39,458 39,458 59,187 100,000 28% Transfers Out - - - - - - 0% Total Expenditures 10,485,386 866,852 2,704,804 2,444,318 242,296 7,538,286 28% Net (804,086) (462,376) (450,849) (1,358,053) (242,296) (110,942) Cash Balance 3,426,251 2,321,755 Staffing Full Time 52.65 47.85 Part -Time /Seasonal /Temporary 4.98 2.24 Total 57.63 50.09 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Information included for Streets, Traffic & Lighting, and Curb & Sidewalk. Explain Significant Spending on Capital Projects Below: Form 3 `�7 Form 3 ` ": Form 3 27 2015 City of South Bend Monthly Financial Report Fund /Department Name Studebaker - Oliver Reverting Grants Month March Fund /Department Number 209 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 570,000 16,335 19,710 - - 550,290 3% Charges for Services - - - - - - 0% Interest Earnings 4,000 385 1,581 1,076 - 2,419 40% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 574,000 16,720 21,291 1,076 - 552,709 4% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 630,000 6,335 9,710 - 557,710 62,580 90% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 630,000 6,335 9,710 - 557,710 62,580 90% Net (56,000) 10,385 11,581 1,076 (557,710) 490,129 Cash Balance 1,098,046 1,084,463 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The $570,000 represents a Brownfield Assessment Grant awarded by EPA for use in South Bend , Mishawaka and St. Joseph County. Explain Significant Spending on Capital Projects Below: Form 3 27 Form 3 28 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development State Grants Month March Fund /Department Number 210 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 1,600,000 - - - - 1,600,000 0% Charges for Services - - - - - - 0% Interest Earnings 13,544 112 473 387 - 13,071 3% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 59,966 - - - - 59,966 0% Transfers In - - - - - - 0% Total Revenue 1,673,510 112 473 387 - 1,673,037 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,622,400 - 12,200 - 10,200 1,600,000 1% Debt Service 72,012 18,003 18,003 18,003 - 54,009 25% Capital 2,000,000 - - - - 2,000,000 0% Transfers Out - - - - - - 0% Total Expenditures 3,694,412 18,003 30,203 18,003 10,200 3,654,009 1% Net (2,020,902) (17,891) (29,730) (17,616) (10,200) (1,980,972) Cash Balance 299,703 331,335 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: No significant issues. We received a grant from the IDGF in 2014 in the amount of $2,000,000 to be used for Ignition Park Infrastructure. $1,600,000 of this grant remains. An additional $ 2,000,000 state grant has been awarded for the ND Turbo Project. Explain Significant Spending on Capital Projects Below: Capital expenditures shown here are for the ND Turbo Project. Form 3 28 Form 3 29 2015 City of South Bend Monthly Financial Report Fund /Department Name Department of Community Investment DCI Month March Fund /Department Number 211 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 416,787 1,951 1,951 10,680 - 414,836 0% Charges for Services - - - - - - 0% Interest Earnings 2,200 384 1,558 950 - 642 71% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 245,000 14,755 39,629 53,981 - 205,371 16% Transfers In 1,967,638 - 491,910 422,240 - 1,475,728 25% Total Revenue 2,631,625 17,090 535,048 487,851 - 2,096,577 20% Expenditures Personnel 2,120,943 144,875 502,128 504,935 9,161 1,609,654 24% Supplies 35,753 8,521 12,431 5,995 4,563 18,759 48% Services 505,034 33,485 101,694 68,849 21,750 381,590 24% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,661,730 186,881 616,253 579,779 35,474 2,010,003 24% Net (30,105) (169,791) (81,205) (91,928) (35,474) 86,574 Cash Balance 993,012 815,386 Staffing Full Time 23.00 23.00 23.00 Part -Time /Seasonal /Temporary - - - Total 23.00 23.00 23.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund covers operations of the Department of Community Investment. Transfers In come from EDIT on a quarterly basis. Explain Significant Spending on Capital Projects Below: Form 3 29 Form 3 30 2015 City of South Bend Monthly Financial Report Fund /Department Name Dept of Community Investment Grants Month March Fund /Department Number 212 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 3,850,000 153,893 272,199 313,626 - 3,577,801 7% Charges for Services - - - - - - 0% Interest Earnings 2,000 106 780 665 - 1,220 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 248,000 86,619 189,536 64,966 - 58,464 76% Transfers In - - - - - - 0% Total Revenue 4,100,000 240,618 462,515 379,257 - 3,637,485 11% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Grants 6,547,968 161,537 415,275 357,346 2,847,850 3,284,843 50% Transfers Out - - - - - - 0% Total Expenditures 6,547,968 161,537 415,275 357,346 2,847,850 3,284,843 50% Net (2,447,968) 79,081 47,240 21,911 (2,847,850) 352,642 Cash Balance 837,625 612,219 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund covers multiple federal grants. There will likely be little predictable trend in revenue and expenditure from year to year because not all grants are on -going and the timing of funding varies widely. Explain Significant Spending on Capital Projects Below: Form 3 30 Form 3 191 2015 City of South Bend Monthly Financial Report Fund /Department Name Police State Seizures Month March Fund /Department Number 216 Date Updated 4/9/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 35,000 810 810 - - 34,190 2% Charges for Services - - - - - - 0% Interest Earnings 300 66 270 157 - 30 90% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 600 - - - - 600 0% Transfers In - - - 0% Total Revenue 35,900 876 1,080 157 - 34,820 3% Expenditures Personnel - - - - - - 0% Supplies - 0% Services 35,900 - - 35,900 0% Debt Service - - - - - 0% Capital - - - - - - 0% Transfers Out - 0% Total Expenditures 35,900 - - - - 35,900 0% Net - 876 1,080 157 - (1,080) Cash Balance 188,511 158,824 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Revenue stream is not a steady flow. It is dependent upon the processing and release of funds from the State for seized assets in drug activities. Expenditures are to be used to support the Police Department's effort to combat drug activity. Explain Significant Spending on Capital Projects Below: Form 3 191 Form 3 19YA 2015 City of South Bend Monthly Financial Report Fund /Department Name Gift, Donation, Bequest Month March Fund /Department Number 217 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 100 42 194 75 - (94) 194% Bond Proceeds - - - - - - 0% Donations 216,000 323 2,778 21,113 - 213,222 1% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 216,100 364 2,972 21,188 - 213,128 1% Expenditures Personnel - - - - - - 0% Supplies 1,552 - - - 1,552 0 100% Services 295,630 136 27,966 - 52,293 215,371 27% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 297,182 136 27,966 - 53,845 215,371 28% Net (81,082) 228 (24,994) 21,188 (53,845) (2,243) Cash Balance 112,944 95,922 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Gift, Donation, and Bequest fund may be used by all City departments but the majority of the donations are for Animal Care and Control and Community Investment (i.e. bicycle signs). In 2015 this account will be used to spend down the grant received in 2014 to pay for remediation and demolition of vacant and abandoned housing. Explain Significant Spending on Capital Projects Below: None Form 3 19YA Form 3 33 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Curfew Violations Month March Fund /Department Number 218 Date Updated 4/9/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,000 13 13 125 - 987 1% Interest Earnings 25 4 17 11 - 8 68% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,025 17 30 136 - 995 3% 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 17 30 136 Cash Balance 12,035 11,684 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 activities and training. Explain Significant Spending on Capital Projects Below: Form 3 33 Form 3 34 2015 City of South Bend Monthly Financial Report Fund /Department Name Law Enforcement Continuing Education Month March Fund /Department Number 220 Date Updated 4/9/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 180,000 15,171 61,605 48,470 - 118,395 34% Interest Earnings 3,000 343 1,404 985 - 1,596 47% Bond Proceeds - - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income 26,000 1,862 7,684 11,107 - 18,316 30% Transfers In - - - - - - 0% Total Revenue 211,000 17,376 70,693 60,562 - 140,307 34% Expenditures Personnel - - - - - - 0% Supplies 122,478 8,793 15,291 12,233 24,122 83,065 32% Services 190,000 18,497 57,003 28,588 - 132,997 30% Debt Service - - - - - - 0% Capital 50,000 - - 13,947 - 50,000 0% Transfers Out - - - - - - 0% Total Expenditures 362,478 27,290 72,294 54,768 24,122 266,062 27% Net (151,478) (9,914) (1,601) 5,794 (24,122) (125,755) Cash Balance 967,172 987,019 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established for the continuing education and supplies for police and is funded by fees from accident reports, gun permits, false alarm and loud noise fines. The increase in Services expenditures over 2014 is due to the timing of training in 2014. This account is expected to be on budget for the year. March expenditures includes a $7,490 purchase that was not paid until April, which has the effect of overstating the March reduction in cash. Explain Significant Spending on Capital Projects Below: Form 3 34 Form 3 1917 2015 City of South Bend Monthly Financial Report Fund /Department Name Loss Recovery Month March Fund /Department Number 227 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,200 1,977 8,441 7,876 - (4,241) 201% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 30,000 19,750 22,500 - - 7,500 75% Transfers In - - - - - - 0% Total Revenue 34,200 21,727 30,941 7,876 - 3,259 90% Expenditures Personnel - - - - - - 0% Supplies 67,500 - - - 67,500 - 100% Services 3,280,635 647,661 1,071,331 138,956 1,163,284 1,046,020 68% Debt Service - - - - - - 0% Capital 1,889,108 174,365 230,965 74,945 1,658,143 1 100% Transfers Out - - - - - 0% Total Expenditures 5,237,243 822,026 1,302,296 213,901 2,888,927 1,046,020 80% Net (5,203,043) (800,299) (1,271,355) (206,025) (2,888,927) (1,042,761) Cash Balance 4,592,538 7,730,008 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Of the $3.28 million budgeted for Services, $289K remains for trucking out contaminated material from Organic Resources. The remainder will be used to pay for the vacant and abandoned housing initiative. The Other Income is revenue from the Light Up South Bend program, where residents pay $250 of the cost toward installation of Lampposts in their front yards. A budget estimate of $30,000 for the year has been processed in March. Explain Significant Spending on Capital Projects Below: $1.889 million has been budgeted in 2015 for the Smart Streets initiative. Of the $1.66 million encumbered, over $1.5 million is currently reserved for the Lincolnway West Corridor. Form 3 1917 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Phone System Month March Fund /Department Number 244 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - 215,000 - - 0% Charges for Services - - - - - - 0% Interest Earnings - - 19 - - (19) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - 19 215,000 - (19) 0% Expenditures Personnel - (21) - 60,389 - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - (21) - 60,389 - - 0% Net - 21 19 154,611 - (19) Cash Balance 33,671 154,611 Staffing Full Time 3.00 - - Part -Time /Seasonal /Temporary - - - Total 3.00 - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up per requirement by the State Board Of Accounts (SBOA) to cover the cost of 911 Police Communication personnel costs covered by a State Grant. This fund will be closed in 2015 with the advent of the county -wide PSAP system. Explain Significant Spending on Capital Projects Below: None. No capital is purchased from this fund. Form 3 Ki: Form 3 37 2015 City of South Bend Monthly Financial Report Fund /Department Name Public Safety WIT Month March Fund /Department Number 249 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 6,466,190 - 1,077,698 1,595,007 - 5,388,492 17% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 430 1,797 1,969 - 4,203 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,472,190 430 1,079,495 1,596,977 - 5,392,695 17% Expenditures Personnel 7,246,551 549,323 1,796,725 1,840,232 - 5,449,826 25% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 7,246,551 549,323 1,796,725 1,840,232 - 5,449,826 25% Net (774,361) (548,894) (717,229) (243,256) - (57,132) Cash Balance 573,194 1,788,939 Staffing Full Time 80.00 Part -Time /Seasonal /Temporary - - Total 80.00 - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund will cover the costs of salaries and fringes for 43 police officers and 37 firefighters in 2015. Explain Significant Spending on Capital Projects Below: None. No capital equipment is purchased from this fund. Form 3 37 2015 City of South Bend Monthly Financial Report Fund /Department Name Local Roads & Streets Month March Fund /Department Number 251 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,000,000 97,752 272,986 269,797 - 727,014 27% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,300 915 3,618 2,007 - 1,682 68% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 588,000 - - - - 588,000 0% Transfers In - - - - - - 0% Total Revenue 1,593,300 98,666 276,603 271,804 - 1,316,697 17% Expenditures Personnel - - - - - - 0% Supplies 380,229 - - - 229 380,000 0% Services 157,500 11,000 11,000 - - 146,500 7% Debt Service - - - - - - 0% Capital 1,388,492 26,032 35,040 43,282 998,311 355,141 74% Transfers Out - - - - - - 0% Total Expenditures 1,926,221 37,032 46,040 43,282 998,540 881,641 54% Net (332,921) 61,634 230,563 228,522 (998,540) 435,055 Cash Balance 2,675,011 2,169,896 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund receives most of its revenue through the gas tax, budgeted at $1 million for 2015. It's used predominantly for street capital projects but $537,000 is used for material for street repairs and other maintenance items. Explain Significant Spending on Capital Projects Below: Projects in 2015 include the Safe Routes to School initiative for Coquillard and Harrison schools, Bendix Drive, and the Boland bicycle trail. The $1 million in encumbrance includes $290,000 for Bendix Dr. (Lathrop to Toll Road), $234,000 for Boland multi -use trail, $273,000 for Olive St. pavement design and $200,000 for Safe Routes to School ( Coquillard and Harrison schools), Form 3 38 Form 3 39 2015 City of South Bend Monthly Financial Report Fund /Department Name Excess Welfare Distribution Month March Fund /Department Number 252 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 0 0 0 - (0) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 0 0 0 - (0) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 0 0 0 - (0) Cash Balance 8 1,151 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: In 2009, the City received a one -time $2.9 million distribution for this fund. In 2012, the City spent approximately $2.1 million for portable radios for both the Police and Fire departments. Money in this fund may only be used for public safety purposes. This fund will be closed out in 2015. Explain Significant Spending on Capital Projects Below: Form 3 39 Form 3 40 2015 City of South Bend Monthly Financial Report Fund /Department Name Human Rights Federal Grant Month March Fund /Department Number 258 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 187,000 - 1,667 - - 185,333 1% Charges for Services - - - - - - 0% Interest Earnings 2,000 154 650 450 - 1,350 33% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 14,400 5,604 12,694 13,624 - 1,706 88% Transfers In - - - - - - 0% Total Revenue 203,400 5,759 15,012 14,074 - 188,388 7% Expenditures Personnel 123,657 17,679 30,567 28,954 - 93,090 25% Supplies 2,800 - 168 130 1,632 1,000 64% Services 120,900 8,354 26,527 11,204 16,153 78,220 35% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 247,357 26,033 57,262 40,287 17,785 172,310 30% Net (43,957) (20,275) (42,251) (26,214) (17,785) 16,079 Cash Balance 488,002 440,561 Staffing Full Time 2.00 2.00 2.00 Part -Time /Seasonal /Temporary 2.00 2.00 2.00 Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Human Rights Federal Grant Fund contains separate departments for EEOC and HUD grants. The Human Rights mission is to educate and promote fair housing as well as ensure that all citizens receive equal employment opportunity. Expenditures are higher than last year at this time. Higher spending occurred in the services category as a payment for services from 2014 was paid early this year. Explain Significant Spending on Capital Projects Below: No capital projects have been budgeted for this year. Form 3 40 2015 City of South Bend Monthly Financial Report Fund /Department Name Eastrace Waterway Month March Fund /Department Number 271 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 2 8 14 - (8) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 2 8 14 - (8) 0% Expenditures Personnel - - - - - - 0% Supplies 4,000 - - - 1,098 2,902 27% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,000 - - - 1,098 2,902 27% Net (4,000) 2 8 14 (1,098) (2,910) Cash Balance 5,320 14,387 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In recent years there have been no races. Explain Significant Spending on Capital Projects Below: Form 3 Cy 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris PAC / Palais Royale Marketing Month March Fund /Department Number 273 Date Updated 4/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 17,900 1,363 1,613 3,875 - 16,287 9% Interest Earnings 100 10 39 26 - 61 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 18,000 1,372 1,652 3,901 - 16,348 9% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 18,974 - 96 4,610 2,358 16,520 13% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 18,974 - 96 4,610 2,358 16,520 13% Net (974) 1,372 1,556 (709) (2,358) (172) Cash Balance 28,270 27,276 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Morris Performing Arts Center and Palais Royale Marketing Fund was established as a separate non - reverting fund to receive monies from solicitation of funds for commercial promotion sponsorships such as commercial ads on ticket envelopes and Morris Marqee sponsorships; and to accept donations to The Morris Performing Arts Center and Palais Royale. All sums so collected and deposited in this fund are to be used for the sole purpose of assisting with continued promotions of and within both the Morris Performing Arts Center and Palais Royale. The funds in this account at the end of the fiscal year shall not revert to the general fund. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund Form 3 E, VA 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Block Grants Month March Fund /Department Number 280 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 1 6 4 - (6) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 1 6 4 - (6) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 1 6 4 - (6) Cash Balance 3,834 3,821 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Justice Assistance Grant 2009 -SB -B9 -1280 was essentially completed last year. Explain Significant Spending on Capital Projects Below: Form 3 43 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Develop. Commission - Revenue Bonds Month March Fund /Department Number 281 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 10 40 27 - (40) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 10 40 27 - (40) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 10 40 27 - (40) Cash Balance 27,244 27,155 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fund to be used only for the expenses of EDC revenue bonds. These bonds have been paid off. Fund to be closed during 2015. Explain Significant Spending on Capital Projects Below: Form 3 44 Form 3 45 2015 City of South Bend Monthly Financial Report Fund /Department Name HAZMAT Month March Fund /Department Number 289 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 10,000 - 13,787 - - (3,787) 138% Interest Earnings - 10 51 16 - (51) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 10 13,838 16 - (3,838) 138% Expenditures Personnel - - - - - - 0% Supplies 31,530 - 21,542 - 9,988 68% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 31,530 - 21,542 - - 9,988 68% Net (21,530) 10 (7,704) 16 - (13,826) Cash Balance 31,925 16,223 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Charges for Service for HAZ -MAT responses. By ordinance the South Bend Fire Department charges businesses for Hazardous Materials Response. This typically happens once or twice a year. There are no employees associated with this fund, responses are made by firefighters of the South Bend Fire Department. Received reimbursement for extended response to airplane crash. Explain Significant Spending on Capital Projects Below: No major capital expenditures are planned through this fund. Major purchases are funded through the Fire Department and EMS Capital and the minimal fees collected in this fund are used to replace equipment and gear used in responses. Form 3 45 Form 3 El i: Form 3 47 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Grants Month March Fund /Department Number 292 Date Updated 4/9/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 90,000 - - 66,716 - 90,000 0% Charges for Services - - - - - - 0% Interest Earnings - - 55 - - (55) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 90,000 - 55 66,716 - 89,945 0% Expenditures Personnel - - - - - - 0% Supplies 14,186 - 14,790 - - (604) 104% Services 959 - 507 138,059 - 452 53% Debt Service - - - - - - 0% Capital 90,000 - - - - 90,000 0% Transfers Out - - - - - - 0% Total Expenditures 105,145 - 15,297 138,059 - 89,848 15% Net (15,145) - (15,242) (71,343) - 97 Cash Balance 80,167 133,166 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Fund was set up to track the revenue and expenditures related to specific Federal Grants. Expenditures have been outlined in the grant. Explain Significant Spending on Capital Projects Below: Form 3 47 Form 3 48 2015 City of South Bend Monthly Financial Report Fund /Department Name Regional Police Academy Month March Fund /Department Number 294 Date Updated 4/9/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 20,000 1,075 19,638 17,250 - 362 98% Interest Earnings - 26 102 76 - (102) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In - - - - - - 0% Total Revenue 22,000 1,101 19,740 17,326 - 2,260 90% Expenditures Personnel - - - - - - 0% Supplies 1,750 - - - - 1,750 0% Services 22,000 242 12,639 663 - 9,361 57% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 23,750 242 12,639 663 - 11,111 53% Net (1,750) 859 7,101 16,663 - (8,851) Cash Balance 75,383 84,748 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to fund the cost of course material and instructors at the South Bend Police Academy. The enforcement courses are offered to other police departments who pay a fee to attend the training. The Service expenditure in 2015 was the instructor cost for a Field Training Officer course offered by the Academy. Explain Significant Spending on Capital Projects Below: Form 3 48 Form 3 49 2015 City of South Bend Monthly Financial Report Fund /Department Name COPS MORE Grant Month March Fund /Department Number 295 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 86,658 - - - - 86,658 0% Charges for Services - - - - - - 0% Interest Earnings 350 31 146 112 - 204 42% Bond Proceeds - - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 38,000 650 1,880 2,700 - 36,120 5% Transfers In - - - - - - 0% Total Revenue 128,258 681 2,026 2,812 - 126,232 2% Expenditures Personnel - - - - - - 0% Supplies 45,735 3,358 24,275 30 10,245 11,215 75% Services 66,000 1,128 1,485 2,815 - 64,515 2% Debt Service - - - - - - 0% Capital 60,600 - - - - 60,600 0% Transfers Out - - - - - - 0% Total Expenditures 172,335 4,486 25,760 2,845 10,245 136,330 21% Net (44,077) (3,805) (23,734) (33) (10,245) (10,098) Cash Balance 82,500 113,310 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to track Federal Grants received for specific purposes outlined in each grant. The cash balance results from funds received from the grants along with impound towing fees. In January, $20,490 was expended in Supplies for dashboard cameras for Police vehicles which will be reimbursed by Federal Grant. Explain Significant Spending on Capital Projects Below: Form 3 49 Form 3 50 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Federal Drug Enforcement Month March Fund /Department Number 299 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 75,000 31,642 33,370 - - 41,630 44% Charges for Services - - - - - - 0% Interest Earnings 1,000 71 242 245 - 758 24% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 1,000 - - - - 1,000 0% Transfers In - - - - - - 0% Total Revenue 77,000 31,713 33,612 245 - 43,388 44% Expenditures Personnel - - - - - - 0% Supplies 54,759 14,949 28,431 1,480 8,206 18,122 67% Services 104,201 3,448 14,824 5,090 5,575 83,802 20% Debt Service - - - - - - 0% Capital 90,000 - - - - 90,000 0% Transfers Out - - - - - - 0% Total Expenditures 248,960 18,397 43,255 6,570 13,781 191,924 23% Net (171,960) 13,316 (9,643) (6,325) (13,781) (148,536) Cash Balance 335,899 378,836 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to receive the Police Department share of money acquired in drug enforcement activity. Expenditures are to be used to fund drug enforcement and training. Explain Significant Spending on Capital Projects Below: Form 3 50 2015 City of South Bend Monthly Financial Report Fund /Department Name County Option Income Tax Month March Fund /Department Number 404 Date Updated 4/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 8,859,912 - 1,476,652 2,161,453 - 7,383,260 17% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 58,000 5,144 21,716 14,331 - 36,284 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 966,059 45,582 132,187 130,968 - 833,872 14% Transfers In - - - - - - 0% Total Revenue 9,883,971 50,726 1,630,555 2,306,752 - 8,253,416 16% Expenditures Personnel 427,077 26,109 76,928 - - 350,149 18% Supplies 1,384,804 55,940 160,786 310,351 12,053 1,211,965 12% Services 8,159,164 497,983 1,305,850 1,035,149 367,478 6,485,836 21% Debt Service 2,487,504 219,749 975,404 1,100,032 - 1,512,100 39% Capital 1,701,822 - 25,325 - 865,498 811,000 52% Transfers Out 1,500,000 - 375,000 - - 1,125,000 25% Total Expenditures 15,660,371 799,781 2,919,293 2,445,532 1,245,028 11,496,050 27% Net (5,776,400) (749,055) (1,288,738) (138,780) (1,245,028) (3,242,634) Cash Balance 13,662,643 14,766,855 Staffing Full Time 4.00 2.00 2.00 Part -Time /Seasonal /Temporary - - - Total 4.00 2.00 2.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Transferred Chief Information Officer (fomerly Director of IT) and Chief Innovation Officer and (2) Business Analysts (new in 2015) to COIT. Budget increase of approximately $3.0 million in "Services" for education and travel due to IT related expenses to COIT to maintain IT professional who support the city. Increase also due to election expense as 2015 is a mayoral election year. This category also increased to include the SMART program and construction skill training and recruiting expenses. Other income in 2015 includes $438,203 in loan repayments from the UDAG Fund 410 for the 1st Source /Marriott loan based on BDC collections. Explain Significant Spending on Capital Projects Below: This year, $341,500 has been budgeted for IT upgrades such as fiber enhancements to the County City building, Central Services and the Water Works Olive St. Station. An additional $972,500 was appropriated in May 2014 to pay Transpo for the City's portion of the new CNG fueling station. An encumbered amount of $890,000 remaining has been carried forward to 2015. Lastly, approximately $470,000 has been budgeted for the corridors implementation. Form 3 61 Form 3 N% 2015 City of South Bend Monthly Financial Report Fund /Department Name Economic Development Income Tax Month March Fund /Department Number 408 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes 8,981,877 - 1,530,201 2,199,205 - 7,451,676 17% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 504,660 - 150,082 - - 354,578 30% Interest Earnings 40,000 3,568 14,696 10,247 - 25,304 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - 366,608 - - 0% Transfers In - - - - - - 0% Total Revenue 9,526,537 3,568 1,694,979 2,576,060 - 7,831,558 18% Expenditures Personnel - - - 110,301 - - 0% Supplies - - - - - - 0% Services 1,222,523 126,960 436,540 428,703 404,807 381,176 69% Debt Service 1,917,313 - 438,568 962,550 - 1,478,745 23% Capital 4,000 - 3,200 150,000 800 - 100% Transfers Out 6,483,782 - 1,620,946 998,879 - 4,862,836 25% Total Expenditures 9,627,618 126,960 2,499,254 2,650,433 405,607 6,722,757 30% Net (101,081) (123,392) (804,275) (74,373) (405,607) 1,108,801 Cash Balance 9,365,951 10,767,755 Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Encumbrances include $315k to DTSB for 2014 operations. In 2015, Code Enforecement personnel expense is fully paid out of Fund 600, therefore, no additional expenses will be incurred in 2015 related to Code in this fund. Transfers out relate to: Community Investment ($1,967,638), Streets ($1,853,000), Code Enforcement ($2,033,776) and Animal Care & Control ($629,368). Due to delays at the County, the March 2015 EDIT distribution was not received in March. It will be received on April 16th per County representation. Explain Significant Spending on Capital Projects Below: $275,000 has been budgeted for the Potawatomi Zoological Society. Form 3 N% Form 3 53 2015 City of South Bend Monthly Financial Report Fund /Department Name Urban Development Action Grant Month March Fund /Department Number 410 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 110 10 40 27 - 70 36% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 438,203 98,485 98,485 - - 339,718 22% Transfers In - - - - - - 0% Total Revenue 438,313 98,495 98,525 27 - 339,788 22% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 438,203 - - - - 438,203 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 438,203 - - - - 438,203 0% Net 110 98,495 98,525 27 - (98,415) Cash Balance 126,191 27,614 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This budget usually includes payments to the COIT Fund. These payments will not be made unless revenue generated in the fund (primarily from BDC collections) is actually received. New payments from the BDC are expected in 2015. Explain Significant Spending on Capital Projects Below: Form 3 53 Form 3 54 2015 City of South Bend Monthly Financial Report Fund /Department Name Project Releaf Month March Fund /Department Number 655 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 429,000 36,396 109,072 108,628 - 319,928 25% Interest Earnings 2,700 361 1,476 953 - 1,224 55% Bond Proceeds - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 431,700 36,757 110,548 109,581 - 321,152 26% Expenditures Personnel 64,081 12 1,427 1,383 - 62,654 2% Supplies 6,000 6,000 0% Services 36,058 2,374 6,978 6,971 - 29,080 19% Debt Service 72,219 11,619 11,619 - 60,600 16% Capital - - - - 0% Transfers Out 350,000 - 350,000 0% Total Expenditures 528,358 2,386 20,025 19,973 - 508,333 4% Net (96,658) 34,371 90,524 89,608 - (187,182) Cash Balance 1,072,212 1,029,708 Staffing Full Time - - Part -Time /Seasonal /Temporary 2.16 - - Total 2.16 - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fall ReLeaf scheduled for October 2015. Explain Significant Spending on Capital Projects Below: Form 3 54 Form 3 1.1.1 2015 City of South Bend Monthly Financial Report Fund /Department Name Police K -9 Unit Month March Fund /Department Number 705 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10 1 5 2 - 5 50% Bond Proceeds - - - - - - 0% Donations 1,990 - 500 1,000 - 1,490 25% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,000 1 505 1,002 - 1,495 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,000 970 970 - - 1,030 49% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 2,000 970 970 - - 1,030 49% Net - (969) (465) 1,002 - 465 Cash Balance 2,854 2,315 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds. Explain Significant Spending on Capital Projects Below: Form 3 1.1.1 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Debt Service Month March Fund /Department Number 313 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 1,177,620 - - - - 1,177,620 0% Local Income Taxes - - - - - - 0% Other Taxes 45,358 - - - - 45,358 0% Grants /Intergovernmental 51,078 4,256 12,769 21,419 - 38,309 25% Charges for Services - - - - - - 0% Interest Earnings - - 41 - - (41) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,274,056 4,256 12,810 21,419 - 1,261,246 1% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 1,266,820 - 636,000 634,500 - 630,820 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 1,266,820 - 636,000 634,500 - 630,820 50% Net 7,236 4,256 (623,190) (613,081) - 630,426 Cash Balance (549,067) 103,255 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to collect a separate property tax levy (distributions received in June and December) and is used to pay debt service on the former College Football Hall of Fame building (payments due in February and July). Because of the timing of revenue and expenditures this fund will typically have a negative cash balance until the property tax distributions are received. PILOT taxes paid by the utilities are received monthly in this fund. The Hall of Fame bond was refunded during 2011 resulting in lower debt service payments. The final payment is due February 1, 2018. On 15 April 2015 the Mayor announced a possible sale of the Hall of Fame to a private company. If the sale proceeds as planned, this fund will receive $240,000 per year for the next 5 years that will be used to offset debt service costs. Explain Significant Spending on Capital Projects Below: None Form 3 61t 2015 City of South Bend Monthly Financial Report Fund /Department Name Professional Sports Development Month March Fund /Department Number 377 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental 610,000 63,470 269,670 180,139 - 340,330 44% Charges for Services - - - - - - 0% Interest Earnings 1,100 77 695 652 - 405 63% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 60,661 - 29,523 34,608 - 31,138 49% Transfers In - - - - - - 0% Total Revenue 671,761 63,547 299,888 215,399 - 371,873 45% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 854,803 - 481,573 383,673 - 373,230 56% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 854,803 - 481,573 383,673 - 373,230 56% Net (183,042) 63,547 (181,685) (168,274) - (1,357) Cash Balance 414,407 673,783 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Effective January 1, 2013, this fund no longer collects hotel /motel tax allocations from St. Joseph County for payment to the Hall of Fame. This fund is currenty used for debt. 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 Four Winds Field, Century Center, Morris Performing Arts Center and Studebaker National Museum). Four Winds Field generates the majority of PSDA revenue. The January debt service payment has been made for 2015. The final debt service payment on the 2010 Coveleski Stadium bonds (Four Winds Field) was paid January 15, 2013. Explain Significant Spending on Capital Projects Below: Form 3 57 Form 3 58 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Stadium Capital Month March Fund /Department Number 401 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 15,000 - - - - 15,000 0% Interest Earnings 100 14 59 27 - 41 59% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - 0% Transfers In - - - - - - 0% Total Revenue 15,100 14 59 27 - 15,041 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 15,100 14 59 27 - 15,041 Cash Balance 40,509 26,877 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Fd 401 accounts for capital spending on Coveleski Stadium. Due to recent lease agreements, no capital revenues have been collected for this fund, limiting its budget. Explain Significant Spending on Capital Projects Below: Form 3 58 2015 City of South Bend Monthly Financial Report Fund /Department Name Zoo Endowment Month March Fund /Department Number 403 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 200 17 72 49 - 128 36% Bond Proceeds - - - - - - 0% Donations - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 200 17 72 49 - 128 36% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 49,000 - - - - 49,000 0% Transfers Out - - - - - - 0% Total Expenditures 49,000 - - - - 49,000 0% Net (48,800) 17 72 49 - (48,872) Cash Balance 49,233 49,071 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established to account for donations dedicated to Potawatomi Zoo. In the past few years several endowments that were funding this fund were liquidated resulting in a drop in revenues to this fund. Explain Significant Spending on Capital Projects Below: Form 3 59 2015 City of South Bend Monthly Financial Report Fund /Department Name Park Nonreverting Capital Month March Fund /Department Number 405 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,000 96 258 261 - 33,742 1% Interest Earnings 2,200 165 698 458 - 1,502 32% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 12,000 - 4,000 7,473 - 8,000 33% Transfers In 95,500 - - - - 95,500 0% Total Revenue 143,700 261 4,956 8,191 - 138,744 3% Expenditures Personnel - - - - - - 0% Supplies 67,273 - - 29,378 37,895 44% Services 50,660 - - 21,776 660 50,000 1% Debt Service - - - - - - 0% Capital 75,000 - - 95,000 - 75,000 0% Transfers Out - - - - - - 0% Total Expenditures 192,933 - - 116,776 30,038 162,895 16% Net (49,233) 261 4,956 (108,584) (30,038) (24,152) Cash Balance 526,120 464,307 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: This is a nonreverting capital fund that accounts for revenues collected and expenses for specific purposes or locations. These locations are Potawatomi and Rum Village Picnic Areas, the East Race, Golf Courses, Forestry, Howard Park Ice Rink, and, until 2014, Potawatomi Zoo. The cash balance includes $60,300 that is restricted to expenditures in Voorde Park. Explain Significant Spending on Capital Projects Below: This fund is for expending nonreverting revenue collected from the Zoo, golf courses, East Race Waterway, picnic sites and forestry revenue. Form 3 60 Form 3 61 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Development Month March Fund /Department Number 406 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 450,000 - - - - 450,000 0% Local Income Taxes - - - - - - 0% Other Taxes 90,191 4,349 13,048 11,673 - 77,143 14% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 168 784 698 - 1,716 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 542,691 4,517 13,832 12,371 - 528,859 3% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 542,691 56,546 169,196 169,196 - 373,495 31% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 542,691 56,546 169,196 169,196 - 373,495 31% Net - (52,029) (155,364) (156,825) - 155,364 Cash Balance 425,886 628,974 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund receives revenue from a property tax levy and distributions are received from St. Joseph County in June and December. Expenditures are for debt service payments on capital leases and the due dates vary per lease. The fund is used to finance police vehicles and related equipment. The fund also receives PILOT payments from the Water Works and Wastewater utilities on a monthly basis. No new leases were added in 2014 and old leases are being paid off. Explain Significant Spending on Capital Projects Below: Form 3 61 2015 City of South Bend Monthly Financial Report Fund /Department Name Cumulative Capital Improvement Month March Fund /Department Number 407 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 397,000 - - - - 397,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 23 290 84 - (140) 193% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In - - - - - - 0% Total Revenue 422,150 23 290 84 - 421,860 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 365,625 - 183,750 185,250 - 181,875 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 365,625 - 183,750 185,250 - 181,875 50% Net 56,525 23 (183,460) (185,166) - 239,985 Cash Balance 66,023 (8,443) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Revenue in this fund includes $150,000 in hotel /motel taxes and $247,000 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 2015, this fund is used to pay 75% of the 2011 Century Center Refunding bonds as it was in 2014. Payments on the Century Center bond are due in February and July. Because of timing of revenue and expenditures, this fund will often have a negative cash balance during the year. Explain Significant Spending on Capital Projects Below: None Form 3 62 2015 City of South Bend Monthly Financial Report Fund /Department Name Major Moves Construction Month March Fund /Department Number 412 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - 0% Interest Earnings 25,000 1,357 5,491 7,092 - 19,509 22% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 786,187 - 368,031 227,661 - 418,156 47% Transfers In - - - - - - 0% Total Revenue 811,187 1,357 373,522 234,753 - 437,665 46% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 3,096,061 335,865 545,253 214,129 2,117,805 433,003 86% Transfers Out - - - - - - 0% Total Expenditures 3,096,061 335,865 545,253 214,129 2,117,805 433,003 86% Net (2,284,874) (334,508) (171,730) 20,624 (2,117,805) 4,661 Cash Balance 3,469,932 7,164,522 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Initial funding for the Major Moves fund in the amount of $12,823,151 was received from the State of Indiana on September 15, 2006, derived from the State lease of the 1 -80 toll road 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. In February, this fund received the first of two semi - annual payments on these loans, totaling $368,031 in principal and interest. Balances due as of 28 February are $787,402 from Fund 435 (Douglas Rd.) and $4,588,506 from Fund 436 (River East Residential, f /k /a Northeast Residential) Explain Significant Spending on Capital Projects Below: The 2015 budget continues funding for the Smart Streets initiative and includes $950,000 for Smart Streets, $350,000 for the King /LWW roundabout, and $30,000 for Corridor alley improvements. The $2.1 million encumbered comprises $930,000 for the 2 -way conversion of Main and Michigan /St. Joseph streets from Chippewa to LaSalle (the former IN -933), $406,000 for the Marion St. roundabout, $185,000 for the Olive - Sample overpass, $152,000 for the Bartlett St. roundabout, and $95,000 for Lincolnway West /Western Ave. Corridor improvements. Form 3 63 Form 3 64 2015 City of South Bend Monthly Financial Report Fund /Department Name Morris Performing Arts Center Capital Month March Fund /Department Number 416 Date Updated 4/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 100,000 9,761 19,050 28,970 - 80,950 19% Interest Earnings 1,500 185 750 458 - 750 50% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 101,500 9,946 19,800 29,428 - 81,700 20% Expenditures Personnel - - - - - - 0% Supplies 21,210 - 1,268 2,911 9,958 9,985 53% Services 49,038 11,946 13,611 - 3,491 31,936 35% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 70,248 11,946 14,879 2,911 13,448 41,920 40% Net 31,252 (2,000) 4,921 26,517 (13,448) 39,779 Cash Balance 520,342 483,327 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was established for the purpose of renovating, remodeling, or, otherwise improving the facilities and / or service to the patrons of the Morris Performing Arts Center. There is no staffing for this fund. Funds in this account are received from a per ticket surcharge included on every sold ticket. Explain Significant Spending on Capital Projects Below: There are no Capital projects budgeted for this year. Form 3 64 Form 3 65 2015 City of South Bend Monthly Financial Report Fund /Department Name Community Revitalization Enhancement District Month March Fund /Department Number 434 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 650,000 - - - - 650,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 24 79 81 - (79) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 650,000 24 79 81 - 649,921 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 462,206 - - - - 462,206 0% Debt Service 187,794 - 3,897 20,975 - 183,897 2% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 650,000 - 3,897 20,975 - 646,103 1% Net - 24 (3,818) (20,894) - 3,818 Cash Balance 6,020 (11,356) Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: CRED is derived from State sale taxes generated within the CRED district (within Studebaker /Oliver area) up to a maximum $1 M annually through 2015.The distribution is made once a year in October and amount fluctuates significantly (note historical revenues). Explain Significant Spending on Capital Projects Below: Form 3 65 Form 3 66 2015 City of South Bend Monthly Financial Report Fund /Department Name Palais Royale Historic Preservation Month March Fund /Department Number 450 Date Updated 4/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 16,000 357 2,535 2,255 - 13,465 16% Interest Earnings 150 23 92 55 - 58 62% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 16,150 380 2,628 2,310 - 13,522 16% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 16,150 - - - - 16,150 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 16,150 - - - - 16,150 0% Net - 380 2,628 2,310 - (2,628) Cash Balance 65,789 55,705 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. Explain Significant Spending on Capital Projects Below: No Capital spending in this fund. Form 3 66 2015 City of South Bend Monthly Financial Report Fund /Department Name Football Hall of Fame Capital Month March Fund /Department Number 677 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,500 196 812 650 - 1,688 32% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,500 196 812 650 - 1,688 32% Expenditures Personnel - - - - - - 0% Supplies 15,000 - - 365 - 15,000 0% Services 173,824 5,998 19,211 19,918 - 154,613 11% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 188,824 5,998 19,211 20,283 - 169,613 10% Net (186,324) (5,802) (18,399) (19,633) - (167,925) Cash Balance 540,822 638,773 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Hall of Fame Capital fund covers maintenance and utilities expense on the building incurred by the City, including costs of the building after the Hall of Fame ceased operations in South Bend at the end of 2012. Explain Significant Spending on Capital Projects Below: No Capital expenditures budgeted for 2015. Form 3 67 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Capital Month March Fund /Department Number 287 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - 396,727 - (396,727) 0% Charges for Services - - - - - - 0% Interest Earnings - 13 13 - - (13) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 750,000 - - - - 750,000 0% Total Revenue 750,000 13 396,740 - - 353,260 53% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 750,000 - 35,728 - - 714,272 5% Transfers Out - - - - - - 0% Total Expenditures 750,000 - 35,728 - - 714,272 5% Net - 13 361,012 - - (361,012) Cash Balance 361,012 - 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 apparatus, ambulances and major construction projects. There are no employees associated with this fund. Explain Significant Spending on Capital Projects Below: Planned purchase of ambulance, support SUV, replacement cardiac monitors, fleet vehicle. Form 3 68 Form 3 69 2015 City of South Bend Monthly Financial Report Fund /Department Name Emergency Medical Services Operating Month March Fund /Department Number 288 Date Updated 4/14/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 5,131,565 664,830 1,030,403 668,191 - 4,101,162 20% Interest Earnings 18,000 1,036 4,229 5,283 - 13,771 23% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 24,500 1,295 5,988 6,680 - 18,512 24% Transfers In 502,000 - - - - 502,000 0% Total Revenue 5,676,065 667,161 1,040,620 680,154 - 4,635,445 18% Expenditures Personnel 4,840,253 157,381 157,381 - - 4,682,872 3% Supplies 292,000 15,417 61,010 13,724 105,682 125,308 57% Services 375,337 37,429 45,692 1,055,231 30,559 299,087 20% Debt Service 448,773 226,401 20,333 2,046 220,326 51% Capital 149,003 - - 149,003 - 100% Transfers Out 750,000 - - - 750,000 0% Total Expenditures 6,855,366 210,228 490,484 1,089,288 287,290 6,077,592 11% Net (1,179,301) 456,933 550,136 (409,134) (287,290) (1,442,148) Cash Balance 3,430,318 5,188,861 Staffing Full Time 51.00 51.00 51.00 Part -Time /Seasonal /Temporary - - - Total 51.00 51.00 51.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The revenues in this account are generated through user fees for the South Bend Fire Department EMS division, Training Bureau, and Inspections. This Fund captures personnel and operating expenses primarily for Emergency Medical Services division and reflects a portion of the cost associated with operating ambulances. Explain Significant Spending on Capital Projects Below: None Form 3 69 Form 3 70 2014 City of South Bend Monthly Financial Report Fund /Department Name Consolidated Building Fund Month March Fund /Department Number 600 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,488,902 195,481 362,375 261,642 - 1,126,527 24% Interest Earnings 1,000 291 1,078 330 - (78) 108% Bond Proceeds - - - - - - 0% Donations - 52 52 - - (52) 0% Other Income 1,067 2,903 4,930 408 - (3,863) 462% Transfers In 2,663,144 - 665,786 576,640 - 1,997,358 25% Total Revenue 4,154,113 198,727 1,034,221 839,020 - 3,119,892 25% Expenditures Personnel 2,454,138 172,828 584,509 473,757 2,160 1,867,469 24% Supplies 181,483 7,979 21,879 30,169 25,161 134,443 26% Services 1,538,733 49,995 128,693 125,161 199,326 1,210,714 21% Debt Service 31,047 4,670 7,816 5,596 911 22,320 28% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 4,205,401 235,473 742,896 634,684 227,558 3,234,947 23% Net (51,288) (36,745) 291,325 204,336 (227,558) (115,055) Cash Balance 1,026,094 357,419 Staffing Full Time 36.00 36.00 - Part -Time /Seasonal /Temporary 2.00 2.00 - Total 38.00 38.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund now comprises the Consolidated Building Department, Code Enforcement and Animal Control. Code and Animal Control are managed together but are run separately from the Building Department per Council's wishes. The $2.6 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: Form 3 70 2015 City of South Bend Monthly Financial Report Fund /Department Name Parking Garages Month March Fund /Department Number 601 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 973,926 83,412 217,000 233,504 - 756,926 22% Interest Earnings 4,000 369 1,558 885 - 2,442 39% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 130,800 6,094 17,599 85,058 - 113,201 13% Transfers In - - - - - - 0% Total Revenue 1,108,726 89,875 236,157 319,447 - 872,569 21% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,621,858 64,293 214,086 172,694 13,673 1,394,099 14% Debt Service - - - - - - 0% Capital 184,854 - 52,838 2,220 132,015 1 100% Transfers Out - - - - - - 0% Total Expenditures 1,806,712 64,293 266,924 174,914 145,688 1,394,100 23% Net (697,986) 25,582 (30,767) 144,533 (145,688) (521,531) Cash Balance 1,042,863 1,028,721 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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: 2015 projects include: Wayne Street Fagade, Elevator Repairs and Door Repairs. These projects were begun in 2014 and will be finished in 2015. Other major repairs to be undertaken in 2015 will come from the Garage Study completed in 2014. Form 3 71 Form 3 rP: 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Operations Month March Fund /Department Number 610 Date Updated 4/9/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 5,219,316 406,783 1,216,369 1,192,540 - 4,002,947 23% Interest Earnings 2,500 96 535 670 - 1,965 21% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 490,473 - - - - 490,473 0% Transfers In - - - - - - 0% Total Revenue 5,712,289 406,879 1,216,903 1,193,211 - 4,495,386 21% Expenditures Personnel 1,731,390 113,420 403,241 428,470 1,500 1,326,649 23% Supplies 371,208 15,795 50,311 131,719 45,059 275,839 26% Services 2,991,595 195,338 657,541 693,572 302,354 2,031,700 32% Debt Service 26,859 5,350 5,350 - - 21,509 20% Capital - - - - - - 0% Transfers Out 752,811 10,000 200,000 310,416 - 552,811 27% Total Expenditures 5,873,863 339,903 1,316,442 1,564,177 348,912 4,208,508 28% Net (161,574) 66,976 (99,539) (370,966) (348,912) 286,877 Cash Balance 329,657 449,136 Staffing Full Time 25.20 24.20 Part -Time /Seasonal /Temporary 8.00 2.00 Total 33.20 26.20 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Enterprise Fund charges City residents a small monthly fee to pick up and dispose of their trash at area landfills and recycling centers. The operations of Solid Waste are totally funded by these user fees, which have not seen a rate increase since 2009. A large encumbrance for landfill tipping fees is causing the percent of Services used year to date to appear high. Revenue continues to fall slightly below budgeted expectations. Explain Significant Spending on Capital Projects Below: Form 3 rP: 2015 City of South Bend Monthly Financial Report Fund /Department Name Solid Waste Capital Month March Fund /Department Number 611 Date Updated 4/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 200 1 34 88 - 166 17% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 752,811 10,000 200,000 310,416 - 552,811 27% Total Revenue 753,011 10,001 200,034 310,504 - 552,977 27% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 752,811 11,054 234,946 279,248 - 517,865 31% Capital - - - 110,425 - - 0% Transfers Out - - - - - - 0% Total Expenditures 752,811 11,054 234,946 389,673 - 517,865 31% Net 200 (1,053) (34,912) (79,169) - 35,112 Cash Balance 288 39,272 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to pay for capital items, such as trash trucks, used in the day to day operations of Solid Waste. Other than a small amount of interest income, the sole source of revenue for this fund comes from dollars transferred in from the Solid Waste Operations Fund #610. These transfers are done on an as needed basis. Explain Significant Spending on Capital Projects Below: Year to date spending has been for lease purchase payments on prior year equipment acquisitions. Form 3 73 Form 3 74 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Operations Month March Fund /Department Number 620 Date Updated 4.13.15 Current Current Current Prior Amended Month Year to Date Year to Date 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,638,403 1,045,268 3,161,675 3,257,140 - 11,476,728 22% Interest Earnings 9,000 1,405 5,987 3,166 - 3,013 67% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 93,580 3,607 4,830 48,781 - 88,750 5% Transfers In 19,500 1,385 3,719 3,862 - 15,781 19% Total Revenue 14,760,483 1,051,666 3,176,211 3,312,949 - 11,584,273 22% Expenditures Personnel 5,023,137 362,388 1,213,884 1,175,587 2,975 3,806,277 24% Supplies 1,516,896 138,823 207,579 182,460 326,070 983,247 35% Services 4,979,548 340,595 918,458 1,010,782 386,596 3,674,494 26% Debt Service 17,936 847 2,021 1,065 3,506 12,409 31% Capital - - - - - - 0% Transfers Out 4,306,954 332,159 1,146,705 996,381 - 3,160,249 27% Total Expenditures 15,844,471 1,174,812 3,488,646 3,366,276 719,147 11,636,677 27% Net (1,083,988) (123,146) (312,436) (53,326) (719,147) (52,405) Cash Balance 4,159,137 3,492,221 Staffing Full Time 70.20 66.70 Part -Time /Seasonal /Temporary 3.00 3.00 Total 73.20 69.70 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to account for all revenue and operational expense of the water utility. This fund provides the monies for debt service obligations, reserve requirements and revenue funded capital improvements through transfer of monies to other funds within the utility operations. Water pumpage and billed consumption for service revenues are less year to date compared to previous year. Other income sources were greater in 2013 because of scrap metal sales from retired water meters and from hydrant damage reimbursements. A significant portion of the supplies expense, including encumbrance, is water meters. Bond proceeds have funded meter purchases for the past three years. Explain Significant Spending on Capital Projects Below: Form 3 74 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Capital Month March Fund /Department Number 622 Date Updated 4.13.15 Current Current Current Prior Amended Month Year to Date Year to Date 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,098 4,556 3,504 - 5,444 46% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 10,000 1,098 4,556 3,504 - 5,444 46% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - 3,600 - - 0% Debt Service - - - - - - 0% Capital 838,893 3,489 86,334 - - 752,559 10% Transfers Out - - - - - - 0% Total Expenditures 838,893 3,489 86,334 3,600 - 752,559 10% Net (828,893) (2,391) (81,778) (96) - (747,115) Cash Balance 3,043,503 3,531,630 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used for acquiring, constructing, and improving fixed assets. Explain Significant Spending on Capital Projects Below: Chlorine Auto Emergency Shut Off System $15,382 Trucks (2) $67,463 plus Tommy Gate (1) $3,489 Form 3 75 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Capital Month March Fund /Department Number 623 Date Updated 4.10.15 Current Current Current Prior Amended Month Year to Date Year to Date 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 - 62 283 829 (283) 0% Bond Proceeds - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 62 283 829 - (283) 0% Expenditures Personnel - - 0% Supplies 50,914 4,276 50,914 17,780 - (0) 100% Services 2,171 - 2,171 0 100% Debt Service - - - - - - 0% Capital - - 219 199,728 - (219) 0% Transfers Out - - - - - 0% Total Expenditures 53,085 4,276 53,304 217,508 - (219) 100% Net (53,085) (4,214) (53,021) (216,678) - (64) Cash Balance 133,793 595,952 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The purpose of this fund is to segregate the use of bond proceeds that are applied to the acquisition, construction and installation of certain additions, extensions and improvements. Revenue bonds were issued in June 2012 with an aggregate principal of $8,300,000. A 2015 budget was not established for this fund based on assumptions of bond proceeds being 100% depleted by December 31, 2014. Intended use of remaining cash will go towards current encumbrance(s), Pinhook Project's final construction pay application and a small final meter order. Explain Significant Spending on Capital Projects Below: Water Meters $50,914 Pinhook WT Effic Improv Proj(EngFees) $219 Boland Park PRV $2,171 Form 3 76 Form 3 77 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Customer Deposit Month March Fund /Department Number 624 Date Updated 4.10.15 Current Current Current Prior Amended Month Year to Date Year to Date 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 527 2,157 1,444 - 3,843 36% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 527 2,157 1,444 - 3,843 36% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - 0% Transfers Out 6,000 527 1,302 1,444 - 4,698 22% Total Expenditures 6,000 527 1,302 1,444 - 4,698 22% Net - - 855 - Cash Balance 1,491,639 1,464,430 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to retain security deposits collected from customers when establishing new service. Upon termination of service, these deposits are released and credited against final bills. Explain Significant Spending on Capital Projects Below: Form 3 77 Form 3 78 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Sinking Month March Fund /Department Number 625 Date Updated 4.10.15 Current Current Current Prior Amended Month Year to Date Year to Date 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 84 553 390 - 4,447 11% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 2,045,078 170,275 510,825 512,430 - 1,534,253 25% Total Revenue 2,050,078 170,359 511,378 512,820 - 1,538,700 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 2,045,078 - - - - 2,045,078 0% Capital - - - - - 0% Transfers Out 5,000 84 550 390 - 4,450 11% Total Expenditures 2,050,078 84 550 390 - 2,049,528 0% Net - 170,275 510,828 512,430 - (510,828) Cash Balance 515,483 517,767 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. The source of monies for debt repayment are transfers from the water utility operating fund 620. Biannual installments are disbursed at the end of June and December. Explain Significant Spending on Capital Projects Below: Form 3 78 Form 3 79 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Bond Reserve Month March Fund /Department Number 626 Date Updated 4.10.15 Current Current Current Prior Amended Month Year to Date Year to Date 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 - 572 2,351 1,536 (2,351) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - 0% Transfers In - - - 25,692 - - 0% Total Revenue - 572 2,351 27,229 - (2,351) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 572 2,351 27,229 - (2,351) Cash Balance 1,649,028 1,592,905 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to ensure compliance with certain debt service bond covenants. Balance in fund is determined by debt service financing arrangements at bond issuance. Maximum reserve requirements have been fully satisfied. Explain Significant Spending on Capital Projects Below: Form 3 79 Form 3 80 2015 City of South Bend Monthly Financial Report Fund /Department Name Water Works Reserve Operations & Maintenance Month March Fund /Department Number 629 Date Updated 4.10.15 Current Current Current Prior Amended Month Year to Date Year to Date 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 775 3,070 2,027 - 5,430 36% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 154,249 - 150,228 53,507 - 4,021 97% Total Revenue 162,749 775 153,298 55,534 - 9,451 94% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 8,500 775 1,866 2,027 - 6,634 22% Total Expenditures 8,500 775 1,866 2,027 - 6,634 22% Net 154,249 - 151,431 53,507 - 2,818 Cash Balance 2,235,267 2,085,039 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to hold cash reserves to serve as fiscal protection against the risk of revenue shortfalls, emergencies and other economic risks that may impact the Water Utility's ability to meet financial commitments. Additional monies have been transferred in to comply with 2015's requirement. Explain Significant Spending on Capital Projects Below: Form 3 80 Form 3 81 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Repair Insurance Month March Fund /Department Number 640 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 548,000 49,781 152,762 141,779 - 395,238 28% Interest Earnings 1,200 548 2,209 1,375 - (1,009) 184% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 549,200 50,328 154,971 143,154 - 394,229 28% Expenditures Personnel 206,842 15,231 47,357 36,130 159,485 23% Supplies 28,603 1,192 3,653 1,420 24,950 13% Services 281,802 27,010 71,016 33,835 66,244 144,542 49% Debt Service 28,456 28,456 0% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 545,703 43,434 122,027 71,386 66,244 357,432 35% Net 3,497 6,895 32,944 71,768 (66,244) 36,797 Cash Balance 1,542,511 1,437,043 Staffing Full Time 2.20 1.85 - Part -Time /Seasonal /Temporary - - - Total 2.20 1.85 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Sewer Insurance program is funded by a monthly charge on city residents' sewer bills. The city is responsible for the main sewer line; from the main line to the house is the homeowner's responsibility. This program helps residents who have an issue with their lateral that cannot be resolved by a simple clean -out by a plumber, i.e., collapsed line, complete root infiltration, etc. that requires excavation work. The program is set up so that the homeowner pays a $500.00 deductible toward the cost of the repair and the city pays the rest. Explain Significant Spending on Capital Projects Below: Form 3 81 Form 3 82 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Operations Month March Fund /Department Number 641 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 35,209,467 2,821,111 8,377,809 7,946,196 - 26,831,658 24% Interest Earnings 22,000 3,377 15,316 6,079 - 6,684 70% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 88,000 1,613 8,839 17,717 - 79,161 10% Transfers In 15,000 - - 3,346 - 15,000 0% Total Revenue 35,334,467 2,826,101 8,401,964 7,973,337 - 26,932,503 24% Expenditures Personnel 7,402,560 537,856 1,866,242 1,844,627 - 5,536,318 25% Supplies 2,154,745 148,623 351,111 368,119 145,192 1,658,442 23% Services 13,178,782 807,927 2,461,222 2,272,131 1,097,985 9,619,575 27% Debt Service 585,187 25,403 158,959 132,809 - 426,228 27% Capital - - - - - 0% Transfers Out 14,875,700 773,536 2,576,695 6,454,721 - 12,299,005 17% Total Expenditures 38,196,974 2,293,345 7,414,229 11,072,408 1,243,177 29,539,568 23% Net (2,862,507) 532,756 987,735 (3,099,070) (1,243,177) (2,607,066) Cash Balance 10,132,344 4,267,769 Staffing Full Time 95.25 84.40 Part -Time /Seasonal /Temporary 6.62 2.00 Total 101.87 86.40 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This enterprise fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Debt service payments are made in accordance with City amortization schedules. Large encumbrances for services contribute to the percentage of budget used. Explain Significant Spending on Capital Projects Below: Capital spending for Sewage works is shown in Fund 642. Form 3 82 Form 3 83 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Capital Month March Fund /Department Number 642 Date Updated 4/6/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 39,000 1,313 5,512 4,427 - 33,488 14% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 5,359,000 - - 4,000,000 - 5,359,000 0% Total Revenue 5,398,000 1,313 5,512 4,004,427 - 5,392,488 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 36,043 2,957 14,858 32,158 21,185 0 100% Debt Service - - - - - - 0% Capital 9,035,667 399,271 473,590 1,785,144 3,216,207 5,345,870 41% Transfers Out - - - - - - 0% Total Expenditures 9,071,710 402,228 488,448 1,817,302 3,237,392 5,345,870 41% Net (3,673,710) (400,916) (482,936) 2,187,124 (3,237,392) 46,618 Cash Balance 3,268,786 6,231,690 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances 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 replacement of the Calvert St. /Ethanol Lift station, WWTP stand -by power, sewer slip lining and manhole rehab. Explain Significant Spending on Capital Projects Below: Year to Date totals spent include: Wastewater Treatment Plant Primary Clarifier rehab $431,874, Utility vehicle used at WWTP $13,131, Sewer Dept vehicle $43,443. Form 3 83 Form 3 84 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Works Reserve Operations & Maint. Month March Fund /Department Number 643 Date Updated 4/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 15,000 1,248 5,015 3,346 - 9,985 33% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 235,612 - 256,086 129,964 - (20,474) 109% Total Revenue 250,612 1,248 261,101 133,310 - (10,489) 104% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 15,000 1,248 3,040 3,346 - 11,960 20% Total Expenditures 15,000 1,248 3,040 3,346 - 11,960 20% Net 235,612 - 258,061 129,964 - (22,449) Cash Balance 3,678,649 3,422,564 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The sole purpose of this fund is to hold the equivalent of two months of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. A transfer to this fund was done in February to adjust the balance to stay in compliance. Explain Significant Spending on Capital Projects Below: Form 3 84 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2007 Month March Fund /Department Number 647 Date Updated 4/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - 2 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 2 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - 2 - - Cash Balance 0 1,142 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Bond, issued in 2007, is now fully spent. There is no 2015 budget. The $.14 cash balance needs to be removed. Explain Significant Spending on Capital Projects Below: Form 3 85 Form 3 86 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Sinking Month March Fund /Department Number 649 Date Updated 4/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 7,000 661 1,712 1,542 - 5,288 24% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 9,281,088 773,536 2,320,609 2,324,757 - 6,960,479 25% Total Revenue 9,288,088 774,198 2,322,320 2,326,299 - 6,965,768 25% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 2,500 - 1,850 1,350 - 650 74% Debt Service 9,279,609 - - - - 9,279,609 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 9,282,109 - 1,850 1,350 - 9,280,259 0% Net 5,979 774,198 2,320,470 2,324,949 - (2,314,491) Cash Balance 3,110,807 3,107,756 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is used to pay all debt service obligations for Wastewater and Sewers. Mandatory transfers in from Operating Fund 641 are done in specified amounts each month to satisfy bond covenants. Explain Significant Spending on Capital Projects Below: Form 3 86 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewage Debt Service Reserve Month March Fund /Department Number 653 Date Updated 4/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 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 7,286,832 7,286,828 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Debt Reserve fund is held in a separate account with Bank of NY Mellon Trust. The account was fully funded for existing debt in 2013. A reconcilliation of the account is done monthly. Explain Significant Spending on Capital Projects Below: Form 3 87 Form 3 88 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2010 Month March Fund /Department Number 658 Date Updated 4/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - 2 - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - - - 2 - - 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - - - 2 - - Cash Balance 2 2,218 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This 2010 bond has been fully spent. There is no 2015 budget. The $2.05 cash balance needs to be removed so the fund can be closed. Explain Significant Spending on Capital Projects Below: Form 3 88 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2011 Month March Fund /Department Number 659 Date Updated 4/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 386 2,193 7,553 - 3,807 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 386 2,193 7,553 - 3,807 37% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 323,670 3,281 7,198 300 10,472 306,001 5% Debt Service - - - - - - 0% Capital 3,388,168 243,575 885,495 685,771 697,955 1,804,719 47% Transfers Out - - - - - - 0% Total Expenditures 3,711,838 246,856 892,692 686,071 708,427 2,110,719 43% Net (3,705,838) (246,471) (890,500) (678,518) (708,427) (2,106,912) Cash Balance 708,886 7,169,981 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This Sewage Works Revenue Bond closed in October of 2011. A number of projects have been funded from this bond; the more significant ones are listed below. Explain Significant Spending on Capital Projects Below: From issue late in 2011, this bond has funded numerous projects including Diamond Ave. Trunk Sewer, Phase II $3.7 million, East Bank Sewer Separation, Phase II $2.8 million, East Bank Sewer Separation, Phase III $2.3 million, LaSalle School area Sewer Separation, $1.7 million, East Bank Sewer Separation, Phase III $545,000, Southwood Sewer Separation, $1,237,881, Diamond Ave. Trunk Sewer, Phase III $248,000, St. Joseph River CSO Stabilization $217,831, Secondary Clarifier Upgrade $367,788, Wastewater Treatment Plant Digester Upgrade $5,639,949. Form 3 89 2015 City of South Bend Monthly Financial Report Fund /Department Name Sewer Bond 2012 Month March Fund /Department Number 661 Date Updated 4/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 20,000 5,897 24,535 17,999 - (4,535) 123% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 20,000 5,897 24,535 17,999 - (4,535) 123% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,000,000 - - - - 1,000,000 0% Debt Service - - - - - - 0% Capital 15,624,275 234,187 522,432 506,441 3,223,072 11,878,771 24% Transfers Out - - - - - - 0% Total Expenditures 16,624,275 234,187 522,432 506,441 3,223,072 12,878,771 23% Net (16,604,275) (228,289) (497,897) (488,442) (3,223,072) (12,883,306) Cash Balance 16,321,367 17,810,585 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Projects funded from this Bond in 2013 and 2014 included: East Bank Sewer Separation -Phase 4 $2.6 million, Diamond Ave. Sewer Separation - Phase 3, $2.6 million, Prairie Avenue Sewer Separation $396,810, and Southwood Sewer Separation $898,773. Spending in 2015 has been for Prairie Ave. Sewer Separation $106,158, Fairfax Sewer $70,022, East Bank Sewer Separation -Phase 5 $209,234, Sewer Sensory Control Network $84,645, Southwood sewer Separation $8,442, Wastewater Treatment Plant Grit/Screening Improvements $41,861, and misc other $2,070. Form 3 1!I0: 2015 City of South Bend Monthly Financial Report Fund /Department Name 2013A Cost of Issuance Fund Month March Fund /Department Number 664 Date Updated 4/3/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 2 7 4 - (7) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue - 2 7 4 - (7) 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net - 2 7 4 - (7) Cash Balance 4,487 4,472 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund was set up to pay the issue costs related to the re- funding of the 2004 Sewer bond and 1998 SRF Loan. Those costs were paid in 2013. The remaining cash balance should be transferred an appropriate fund, so this fund can be closed out. Explain Significant Spending on Capital Projects Below: Form 3 Wi Form 3 1% 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Month March Fund /Department Number 670 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 1,313,436 - 656,725 656,725 - 656,711 50% Grants /Intergovernmental - - - - - - 0% Charges for Services 3,194,126 203,146 362,910 418,611 - 2,831,216 11% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 25,000 - - 23,959 - 25,000 0% Transfers In - - - - - - 0% Total Revenue 4,532,562 203,146 1,019,635 1,099,295 - 3,512,927 22% Expenditures Personnel 2,505,817 168,290 470,367 516,662 - 2,035,450 19% Supplies 496,646 37,774 88,278 87,988 - 408,368 18% Services 1,286,148 83,241 322,604 461,115 - 963,544 25% Debt Service - - - - - - 0% Capital 243,951 - - - - 243,951 0% Transfers Out - - - - - - 0% Total Expenditures 4,532,562 289,305 881,249 1,065,765 - 3,651,313 19% Net - (86,159) 138,386 33,530 - (138,386) Cash Balance 1,254,371 979,361 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: SMG has assumed management of Century Center effective July 1, 2013. One of their contractual duties is to reduce the operating deficit in the fund. Covered by hotel /motel tax revenue which is received twice per year. The first installment was received in February 2015. Other income includes charges to large conferences for electric costs. March 2015 was a very busy month; revenues reflect this. Due to wedding season coming up, revenues should pick up even more in April - August. Explain Significant Spending on Capital Projects Below: Form 3 1% 2015 City of South Bend Monthly Financial Report Fund /Department Name Century Center Capital Month March Fund /Department Number 671 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 500 23 68 87 - 432 14% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 500 23 68 87 - 432 14% Expenditures Personnel - - - - - - 0% Supplies 41,156 - 41,156 - - - 100% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 25,000 - 25,000 - - - 100% Transfers Out - - - - - - 0% Total Expenditures 66,156 - 66,156 - - - 100% Net (65,656) 23 (66,088) 87 - 432 Cash Balance 1,352,574 1,757,784 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Century Center Board of Managers has not approved a 2014 capital budget in this fund. SMG contributed a one time amount of $575,000 to cover capital expenses in August 2013. The remainder of these funds have been appropriated for spending during 2015. $25,000 was appropriated to help pay for the Wall of Fame in conjunction with the South Bend Alumni Association. Explain Significant Spending on Capital Projects Below: A Qualified Energy Conservation Bond is scheduled to be taken out in April 2015. Approximately $192,000 will be used as a down payment on the construction contract, thus reducing the amount necessary to be funded by bond issuance. The actual bond payments will be made with hotel/ motel funds through a new fund, Century Center Energy Conservation Debt Service, that will be seeded with a $150,000 transfer from this fund in April. Form 3 F!IN Form 3 ME 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Month March Fund /Department Number 222 Date Updated 4/7/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - 0% Charges for Services 8,069,157 706,747 2,023,318 1,992,049 - 6,045,839 25% Interest Earnings 3,400 427 1,916 1,115 - 1,484 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 48,540 2,491 28,923 86,297 - 19,617 60% Transfers In - - - - - - 0% Total Revenue 8,121,097 709,666 2,054,157 2,079,462 - 6,066,940 25% Expenditures Personnel 3,099,267 203,532 705,905 678,260 52 2,393,310 23% Supplies 167,428 30,028 21,032 7,865 3,183 143,212 14% Services 4,611,385 457,519 1,264,127 1,283,741 2,359,687 987,571 79% Debt Service 9,155 859 2,273 1,624 1,395 5,488 40% Capital 141,157 - - 120,000 21,157 85% Transfers Out 271,850 - - - - 271,850 0% Total Expenditures 8,300,242 691,937 1,993,337 1,971,490 2,484,317 3,822,588 54% Net (179,145) 17,728 60,820 107,972 (2,484,317) 2,244,352 Cash Balance 1,623,733 1,629,057 Staffing Full Time 42.00 38.00 38.00 Part -Time /Seasonal /Temporary 2.00 - - Total 44.00 38.00 38.00 Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Central Services Division consists of six cost centers that provide a variety of services to other city departments, along with several local county, state and federal agencies. The supply acct. goes up and down, depending on vehicle repairs. In March we had 1,195 vehicle repairs. Average Fuel prices for March is $1.71 for Unleaded and $2.15 for Diesel. Budgeted amount per gallon is $3.45. We saved $332,415 in the 1st Qtr compared to 2014 1 st Qtr fuel costs. Explain Significant Spending on Capital Projects Below: The capital expenses for 2015 were moved to a new Fund #224 for $271,850. We are transfering monies out of our cash reserve over to fund 224 to cover our 2015 capital expenses. We had $120,000 roll over from 2014 to 2015 for capital expenses to converting our garage so we can work on CNG vehicles. Form 3 ME 2015 City of South Bend Monthly Financial Report Fund /Department Name Central Services Capital Month March Fund /Department Number 224 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In 271,850 - - - - 271,850 0% Total Revenue 271,850 - - - - 271,850 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital 271,850 - - - - 271,850 0% Transfers Out - - - - - - 0% Total Expenditures 271,850 - - - - 271,850 0% Net - - - - - - Cash Balance - - Staffing Full Time - - Part -Time /Seasonal /Temporary - - Total - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a new fund for 2015. Revenues are a transfer from Central Services. Explain Significant Spending on Capital Projects Below: Capital projects for 2015 include a roof replacement for the Equipment Services building ($171,850), six (6) mobile comm lifts ($10,000 each) and an inground hoist ($40,000). Form 3 1:17 Form 3 Xt, 2015 City of South Bend Monthly Financial Report Fund /Department Name Liability Insurance Month March Fund /Department Number 226 Date Updated 4/12/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,222,727 101,897 303,088 711,777 - 919,640 25% Interest Earnings 20,500 1,918 8,179 5,100 - 12,321 40% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 17,000 - - 37,048 - 17,000 0% Transfers In - - - - - - 0% Total Revenue 1,260,227 103,815 311,266 753,925 - 948,961 25% Expenditures Personnel 212,170 24,689 67,351 46,795 - 144,819 32% Supplies 30,189 3,055 8,123 3,203 5,372 16,694 45% Services 2,814,432 104,309 574,371 755,472 66,249 2,173,812 23% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,056,791 132,053 649,845 805,469 71,621 2,335,325 24% Net (1,796,564) (28,238) (338,578) (51,544) (71,621) (1,386,364) Cash Balance 5,341,496 5,136,111 Staffing Full Time 3.00 2.00 Part -Time /Seasonal /Temporary - - Total 3.00 2.00 - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund handles operations relating to business insurance and claims: property, liability, workers compensation, etc. and the operation of the safety and risk department. Personnel expenses are overbudget due to an employee retirement and the resulting payout of vacation, etc. The position has not yet been filled so we are saving some money and expect to be within budget in the next month or two. Explain Significant Spending on Capital Projects Below: Form 3 Xt, 2015 City of South Bend Monthly Financial Report Fund /Department Name Take Home Vehicle Police Month March Fund /Department Number 278 Date Updated 4/16/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 61,100 4,670 16,410 16,530 - 44,690 27% Interest Earnings 2,000 189 758 460 - 1,242 38% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 61,100 4,670 16,410 16,423 - 44,690 27% Transfers In - - - - - - 0% Total Revenue 124,200 9,529 33,578 33,413 - 90,622 27% Expenditures Personnel - - - - - - 0% Supplies 61,100 - - - 61,100 0% Services 10,000 - - - - 10,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 71,100 - - - - 71,100 0% Net 53,100 9,529 33,578 33,413 - 19,522 Cash Balance 549,590 486,366 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 in 2015.The cash reserve in this fund has increased in recent years and is expected to increase during 2015. 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 2014. Explain Significant Spending on Capital Projects Below: None Form 3 IM Form 3 1*x1 2015 City of South Bend Monthly Financial Report Fund /Department Name Self- Funded Employee Benefits Month March Fund /Department Number 711 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 16,200,000 1,216,336 3,667,129 2,919,100 - 12,532,871 23% Interest Earnings 23,345 1,548 6,302 6,087 - 17,043 27% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 19,399 11,199 - (19,399) 0% Transfers In - - - - - - 0% Total Revenue 16,223,345 1,217,884 3,692,829 2,936,386 - 12,530,516 23% Expenditures Personnel 4,326 1 2 - - 4,324 0% Supplies 21,875 (1,399) 385 2,313 2,001 19,489 11% Services 844,520 56,427 205,399 162,120 251,230 387,891 54% Insurance 15,826,214 1,038,961 2,882,600 3,485,566 43,599 12,900,015 18% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 16,696,935 1,093,990 3,088,387 3,649,999 296,830 13,311,718 20% Net (473,590) 123,894 604,443 (713,613) (296,830) (781,202) Cash Balance 4,661,430 4,947,834 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund handles expenses relating to insurance and claims relating to employees: medical, dental, life, flex spending, etc. For the last several years expenses have significantly exceeded revenues (charges to City Departments and employees) so our cash balance has been eroding. This is not sustainable in the long -term and we need to address this situation. For the 2015 Budget, we increased employer and employee contributions significantly, which should help. We are also working with our insurance advisor on some other options. Explain Significant Spending on Capital Projects Below: None Form 3 1*x1 Form 3 1*111 2015 City of South Bend Monthly Financial Report Fund /Department Name Unemployment Compensation Month March Fund /Department Number 713 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 225,996 8,473 25,420 25,591 - 200,576 11% Interest Earnings 800 85 349 256 - 451 44% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 226,796 8,558 25,769 25,847 - 201,027 11% Expenditures Personnel 200,000 8,458 16,019 36,384 - 183,981 8% Supplies - - - - - - 0% Services 26,796 566 8,299 1,806 13,200 5,297 80% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 226,796 9,024 24,318 38,190 13,200 189,278 17% Net - (466) 1,451 (12,343) (13,200) 11,749 Cash Balance 242,622 247,687 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund charges an allocation of 0.5% of payroll to most departments to cover the cost of unemployment claims paid. Due to continued favorable claims, the fund will only charge departments at 0.25% unless the claims increase substantially. For the 2015 budget, all outplacement services will be paid through this account. These were paid through the General Fund in previous years, however, due to the nature of outplacement claims, the Unemployment Fund is a more appropriate place from which to pay the costs. The Unemployment Compensation Fund is classified as an Internal Service Fund for financial reporting. Claims continue to be lower than anticipated. Explain Significant Spending on Capital Projects Below: None Form 3 1*111 Form 3 `[1111 2015 City of South Bend Monthly Financial Report Fund /Department Name Firefighters Pension Month March Fund /Department Number 701 Date Updated 4/15/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 5,207,092 - - - - 5,207,092 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,500 54 872 711 - 3,628 19% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,211,592 54 872 711 - 5,210,720 0% Expenditures Personnel 5,661,579 450,317 1,332,582 1,354,153 - 4,328,997 24% Supplies 200 - - - - 200 0% Services 4,800 - 202 240 - 4,598 4% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 5,666,579 450,317 1,332,784 1,354,393 - 4,333,795 24% Net (454,987) (450,263) (1,331,913) (1,353,682) - 876,926 Cash Balance (692,785) (414,962) Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Fire Pension fund receives State of Indiana pension relief payments in June and September to reimburse the City for actual pension costs paid and reported in the previous year. For 2015, the payments are expected to be $2,603,546 by 1 July and again by 1 October, totaling $5,207,092. Explain Significant Spending on Capital Projects Below: No capital expenditures are purchased through this account. Form 3 `[1111 Form 3 `1121 2015 City of South Bend Monthly Financial Report Fund /Department Name Police Pension Month March Fund /Department Number 702 Date Updated 4/7/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes 6,350,000 - - - - 6,350,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 184 1,546 1,415 - 4,454 26% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 4,000 - - - - 4,000 0% Transfers In - - - - - - 0% Total Revenue 6,360,000 184 1,546 1,415 - 6,358,454 0% Expenditures Personnel 6,827,035 559,034 1,620,060 1,831,874 - 5,206,975 24% Supplies 800 - - - - 800 0% Services 4,400 - 98 204 - 4,302 2% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,832,235 559,034 1,620,158 1,832,078 - 5,212,077 24% Net (472,235) (558,850) (1,618,611) (1,830,663) - 1,146,376 Cash Balance (507,841) (122,007) Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Police Pension fund receives pension relief distributions from the State of Indiana to reimburse the City for pension costs paid and reported in the previous fiscal year. For 2014, the payments are expected to be $3,055,933 by 1 July and again by 1 October, totaling $6,111,865. Explain Significant Spending on Capital Projects Below: No capital expenditures are paid from this fund. Form 3 `1121 2015 City of South Bend Monthly Financial Report Fund /Department Name City Cemetery Month March Fund /Department Number 730 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 150 10 41 37 - 109 28% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 150 10 41 37 - 109 28% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 20,000 - - - 20,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 20,000 - - - - 20,000 0% Net (19,850) 10 41 37 - (19,891) Cash Balance 28,419 36,971 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund is designated for expenses specifically for the City Cemetery. Revenues were originally derived from the sale of cemetery plots and burial expenses.There are few sites available for sale and most plots are occupied, resulting in little burial activty. Explain Significant Spending on Capital Projects Below: Spending this year will concentrate on repairing headstones and completing the GIS survey of the cemetery and its occupants. Form 3 102 Form 3 103 2015 City of South Bend Monthly Financial Report Fund /Department Name River West Development Area Airport TIF Month March Fund /Department Number 324 1 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 16,433,274 - - - - 16,433,274 0% Local Income Taxes - - - - - - 0% Other Taxes 489,000 - - - - 489,000 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 17,000 7,392 10,176 - - 6,824 60% Interest Earnings 99,596 16,393 55,305 23,462 - 44,291 56% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 3,274,236 1,501,659 1,542,997 - - 1,731,239 47% Transfers In 11,000 4,953,932 4,954,476 1,031 - (4,943,476) 45041% Total Revenue 20,324,106 6,479,376 6,562,954 24,493 - 13,761,152 32% Expenditures Personnel - - - - - 0% Supplies - - - - - - 0% Services 7,493,230 326,539 796,072 1,059,598 1,745,070 4,952,088 34% Debt Service 6,474,483 - 3,353,271 1,262,971 - 3,121,212 52% Capital 33,742,884 1,409,798 1,548,424 5,109 7,924,779 24,269,681 28% Transfers Out - - - - - - 0% Total Expenditures 47,710,597 1,736,337 5,697,767 2,327,678 9,669,849 32,342,981 32% Net (27,386,491) 4,743,039 865,187 (2,303,185) (9,669,849) (18,581,829) Cash Balance 32,245,781 22,716,945 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. Due to changes in boundry, this area now includes the former Central Medical District (Fund 426) and a portion of South Bend Central Development Area (Fund 420). The budget for Transfers In will be adjusted in April business to reflect activity. Explain Significant Spending on Capital Projects Below: Major projects carried out in 2014 were: Renaissance District Phase II; the Studebaker /Oliver Project; and continued Ignition Park South & East acquisitions. In 2015, the major projects thus far approved are: the Bartlett Roundabout, Ignition Park infrastructure, LaSalle Hotel, ND /GE Turbo Project, Nello and Studebaker Envionmental. Form 3 103 Form 3 `1171 2015 City of South Bend Monthly Financial Report Fund /Department Name Tax Incremental Financing TIF) - Downtown Month March Fund /Department Number 420 1 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 3,500,000 - - - - 3,500,000 0% Local Income Taxes - - - - - - 0% Other Taxes 489,500 - - - - 489,500 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 34,000 (3,146) - 8,611 - 34,000 0% Interest Earnings 37,596 (880) - 8,729 - 37,596 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 277,106 - - 57,707 - 277,106 0% Transfers In 6,000 (909) - 1,723 - 6,000 0% Total Revenue 4,344,202 (4,935) - 76,770 - 4,344,202 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - (6,768) - 127,722 - - 0% Debt Service - - - 1,239,010 - - 0% Capital 448,696 - - 15,336 - 448,696 0% Transfers Out 4,088,473 4,088,473 4,088,473 - - - 100% Total Expenditures 4,537,169 4,081,705 4,088,473 1,382,068 - 448,696 90% Net (192,967) (4,086,640) (4,088,473) (1,305,298) - 3,895,506 Cash Balance - 1,299,176 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: In 2015 SBCDA is eliminated and all funds will be distributed between Fund 324 River West and Fund 429 River East. This is the result of the TIF realignment. Budget numbers will be adjusted in April. Explain Significant Spending on Capital Projects Below: Form 3 `1171 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - West Washington Month March Fund /Department Number 422 1 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 420,000 - - - - 420,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 2,000 423 1,680 588 - 320 84% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 422,000 423 1,680 588 - 420,320 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 30,600 7,650 22,950 319 7,650 - 100% Debt Service - - - - - - 0% Capital 730,300 - - - - 730,300 0% Transfers Out - - - - - - 0% Total Expenditures 760,900 7,650 22,950 319 7,650 730,300 4% Net (338,900) (7,227) (21,270) 269 (7,650) (309,980) Cash Balance 1,174,479 613,231 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year so little can be gained by comparing expenditures from year to year. Major Projects committed thus far in 2015 are: City Cemetary Project. Explain Significant Spending on Capital Projects Below: Major projects committed thus far in 2015 are: City Cemetery Project. Other TIF eligible development projects for this TIF area will be determined by department staff and the Mayor's office as the year progresses. Form 3 KIM Form 3 `IIII 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Retail & Leighton Plaza Month March Fund /Department Number 425 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings - 49 147 89 - (147) 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income 189,123 9,991 41,092 37,632 - 148,031 22% Transfers In - - - - - - 0% Total Revenue 189,123 10,040 41,239 37,721 - 147,884 22% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 154,716 17,748 34,372 25,499 - 120,344 22% Debt Service - - - - - - 0% Capital - - - 6,085 - - 0% Transfers Out - - - - - - 0% Total Expenditures 154,716 17,748 34,372 31,584 - 120,344 22% Net 34,407 (7,708) 6,867 6,137 - 27,540 Cash Balance 179,394 139,203 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Operations under outside contract with Bradley Co. so all expenses except capital are shown under Services line, to show consistently with Parking Garages and Blackthorn Golf Course. Explain Significant Spending on Capital Projects Below: Form 3 `IIII Form 3 `[1yA 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Central Medical Service Area Month March Fund /Department Number 426 1 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 625,000 - - - - 625,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 7,000 (2,442) - 3,036 - 7,000 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 632,000 (2,442) - 3,036 - 632,000 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 3,613 - - 2,452 - 3,613 0% Debt Service - - - - - - 0% Capital - - - 166,772 - - 0% Transfers Out 2,472,420 2,294,533 2,294,533 - 177,887 93% Total Expenditures 2,476,033 2,294,533 2,294,533 169,224 - 181,500 93% Net (1,844,033) (2,296,975) (2,294,533) (166,188) - 450,500 Cash Balance - 3,066,225 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: In 2015 Central Medical Service Area is eliminated and all funds will be distributed to Fund 324 River West. This is the result of the TIF realignment. Explain Significant Spending on Capital Projects Below: Form 3 `[1yA 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Development Area NE Dev TIF Month March Fund /Department Number 429 1 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 820,000 - - - - 820,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 7,000 3,035 7,886 2,950 - (886) 113% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - 19,357 - - (19,357) 0% Transfers In - 1,430,965 1,430,965 - - (1,430,965) 0% Total Revenue 827,000 1,434,000 1,458,208 2,950 - (631,208) 176% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 126,044 - 35,090 617 77,094 13,860 89% Debt Service - - - - - - 0% Capital 7,113,480 - 82,866 - 110,129 6,920,485 3% Transfers Out - - - - - - 0% Total Expenditures 7,239,524 - 117,956 617 187,223 6,934,345 4% Net (6,412,524) 1,434,000 1,340,252 2,333 (187,223) (7,565,553) Cash Balance 5,896,732 3,011,124 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and will not show much trend when reviewing expenditures with prior year. Due to changes in boundary, this area now includes a portion of South Bend Central Development Area (Fund 420). Explain Significant Spending on Capital Projects Below: Projects committed to in 2015 include: 5 Points Utility Study, Hill Street Improvements and the NW Corner of Hill & Colfax. Form 3 `[IN 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #1 Month March Fund /Department Number 430 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,400,000 - - - - 2,400,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 10,000 1,590 6,758 3,317 - 3,242 68% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,410,000 1,590 6,758 3,317 - 2,403,242 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 580,022 20,855 78,739 94,631 476,282 25,001 96% Debt Service - - - - - - 0% Capital 2,262,513 41,566 443,483 165,021 206,925 1,612,105 29% Transfers Out - - - - - - 0% Total Expenditures 2,842,535 62,421 522,222 259,652 683,207 1,637,106 42% Net (432,535) (60,831) (515,464) (256,335) (683,207) 766,136 Cash Balance 4,441,828 3,183,313 Staffing Full Time - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from one year to the next so expenditure comparison will not yield reliable trend review. Explain Significant Spending on Capital Projects Below: Projects committed to in 2014 were: completion of the Fellows Street Corridor Project; Ireland & Miami Area Improvements; Main /Lafayette Crossover Project and Walter Street Sidewalks. Projects committed to in 2015 include: Chippewa Improvements, Fellows Street Corridor, Ireland & Miami Area Improvements, Ireland Road Acquisition Services, Main - Lafayette Crossover Connector and MetroNet. Form 3 K11:1 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Douglas Road Month March Fund /Department Number 435 1 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 320,000 - - - - 320,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 750 23 232 278 - 518 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 320,750 23 232 278 - 320,518 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 4,200 - - 160 4,200 - 100% Debt Service 341,189 - 169,620 95,231 - 171,569 50% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 345,389 - 169,620 95,391 4,200 171,569 50% Net (24,639) 23 (169,388) (95,113) (4,200) 148,949 Cash Balance 52,042 199,487 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The Douglas Road TIF was established to develop the road and area near Brown Mackie College near the South Bend - Mishawaka border. The fund borrowed money from the City of Mishawaka ($1,086,550) and Major Moves Fund 412 ($1,000,000) to finance initial construction. The fund uses TIF tax revenue to repay the loans. During February, 2015 the amounts due Mishawaka were paid in full and the amount due to Major Moves was $787,402. Payments will now be accelerated on the Major Moves loan in order to pay it off early as well. Explain Significant Spending on Capital Projects Below: Projects for 2014 include: the Douglas Road Turn Lane. Form 3 `sle] Form 3 "`i 2015 City of South Bend Monthly Financial Report Fund /Department Name River East Residential NE Res TIF Month March Fund /Department Number 436 1 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes 2,599,000 - - - - 2,599,000 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 5 1,571 1,666 - 3,429 31% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 2,604,000 5 1,571 1,666 - 2,602,429 0% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service 3,425,632 - 1,710,589 1,650,718 - 1,715,043 50% Capital - - - 214,573 - - 0% Transfers Out - - - - - - 0% Total Expenditures 3,425,632 - 1,710,589 1,865,291 - 1,715,043 50% Net (821,632) 5 (1,709,018) (1,863,625) - 887,386 Cash Balance (3,515) 690,454 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: TIF projects vary widely from year to year and expenditures will not necessarily have any trend from one year to the next. Debt Service is related to the Eddy Street Commons Bonds Explain Significant Spending on Capital Projects Below: Form 3 "`i 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment General Month March Fund /Department Number 433 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 252 4 15 22 - 237 6% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 252 4 15 22 - 237 6% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 6,000 - - 10,212 - 6,000 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 6,000 - - 10,212 - 6,000 0% Net (5,748) 4 15 (10,190) - (5,763) Cash Balance 10,105 15,558 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This fund's sole expenditure is for general legal fees for DCI based on an engagement letter Explain Significant Spending on Capital Projects Below: Form 3 ISN Form 3 1§93 2015 City of South Bend Monthly Financial Report Fund /Department Name Certified Technology Park Month March Fund /Department Number 439 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 4,404 1,780 7,309 3,657 - (2,905) 166% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 4,404 1,780 7,309 3,657 - (2,905) 166% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - 198 198 - - (198) 0% Debt Service - - - - - - 0% Capital 5,000,000 - - - 1,359,500 3,640,500 27% Transfers Out - - - - - - 0% Total Expenditures 5,000,000 198 198 - 1,359,500 3,640,302 27% Net (4,995,596) 1,582 7,111 3,657 (1,359,500) (3,643,207) Cash Balance 5,027,672 3,686,252 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Capital funds are to be expended in Ignition Park and Innovation Park. Form 3 1§93 Form 3 ISO 2015 City of South Bend Monthly Financial Report Fund /Department Name Airport Urban Enterprise Zone Month March Fund /Department Number 454 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,500 134 550 374 - 950 37% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,500 134 550 374 - 950 37% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,500 134 550 374 - 950 Cash Balance 377,990 376,745 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: Form 3 ISO Form 3 IfiN 2015 City of South Bend Monthly Financial Report Fund /Department Name Blackthorn Operations Month March Fund /Department Number 619 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services 1,696,879 - 119,238 212,195 - 1,577,641 7% Interest Earnings - - - - - - 0% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,696,879 - 119,238 212,195 - 1,577,641 7% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 1,661,128 22,845 181,258 167,519 - 1,479,870 11% Debt Service - - - - - - 0% Capital 10,578 - - - - 10,578 0% Transfers Out - - - - - - 0% Total Expenditures 1,671,706 22,845 181,258 167,519 - 1,490,448 11% Net 25,173 (22,845) (62,020) 44,676 - 87,193 Cash Balance 19,911 131,700 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: 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. The course has been sold to a private owner. The sale was completed in February, 2015. Explain Significant Spending on Capital Projects Below: Equipment payments Form 3 IfiN 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Airport Taxable Month March Fund /Department Number 315 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 5,000 368 1,511 1,031 - 3,489 30% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 5,000 368 1,511 1,031 - 3,489 30% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 5,000 368 912 1,031 - 4,088 18% Total Expenditures 5,000 368 912 1,031 - 4,088 18% Net - - 599 - Cash Balance 1,038,904 1,038,904 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: This is a debt service fund which exists only to satisfy debt service reserve requirements of the outstanding bond. Only activity is interest income which is promptly transferred out to the corresponding TIF fund (in this case fund 324). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. Explain Significant Spending on Capital Projects Below: Form 3 `rill 2015 City of South Bend Monthly Financial Report Fund /Department Name Coveleski Debt Service Reserve Month March Fund /Department Number 317 Date Updated 4/10/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 1,800 179 735 500 - 1,065 41% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 1,800 179 735 500 - 1,065 41% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures - - - - - - 0% Net 1,800 179 735 500 - 1,065 Cash Balance 505,638 503,972 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Debt service reserve fund. The fund is at the proper level per the bond financial advisor, Crowe Horwath. No additional transfers -in are needed. Any interest variations due to City policy on investments and increase in cash available to earn interest. Explain Significant Spending on Capital Projects Below: Form 3 `SVA Form 3 `sM 2015 City of South Bend Monthly Financial Report Fund /Department Name Redevelopment Bond - Palais Royale Month March Fund /Department Number 328 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 6,000 615 2,525 1,723 - 3,475 42% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 6,000 615 2,525 1,723 - 3,475 42% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services - - - - - - 0% Debt Service - - - - - - 0% Capital - - - - - - 0% Transfers Out 6,000 615 1,524 1,723 - 4,476 25% Total Expenditures 6,000 615 1,524 1,723 - 4,476 25% Net - - 1,001 - Cash Balance 1,735,840 1,735,840 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: Explain Significant Spending on Capital Projects Below: Form 3 `sM Form 3 ISM 2015 City of South Bend Monthly Financial Report Fund /Department Name TIF - Southside Development #3 Month March Fund /Department Number 432 Date Updated 4/13/2015 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Revenue Property Taxes - - - - - - 0% Local Income Taxes - - - - - - 0% Other Taxes - - - - - - 0% Grants /Intergovernmental - - - - - - 0% Charges for Services - - - - - - 0% Interest Earnings 25,000 1,967 8,481 6,051 - 16,519 34% Bond Proceeds - - - - - - 0% Donations - - - - - - 0% Other Income - - - - - - 0% Transfers In - - - - - - 0% Total Revenue 25,000 1,967 8,481 6,051 - 16,519 34% Expenditures Personnel - - - - - - 0% Supplies - - - - - - 0% Services 203,000 - 201,724 656 - 1,276 99% Debt Service 488,380 - 357,545 353,950 - 130,835 73% Capital - - - - - - 0% Transfers Out - - - - - - 0% Total Expenditures 691,380 - 559,269 354,606 - 132,111 81% Net (666,380) 1,967 (550,788) (348,555) - (115,592) Cash Balance 5,952,067 6,620,132 Staffing Full Time - - - Part -Time /Seasonal /Temporary - - - Total - - - Explain Significant Revenue, Expenditure and Staffing ChangesNariances Below: The purpose of this fund is to payoff debt. We will not be requesting additional funds from the TIF. The first opportunity to pay off the bond will be February, 2017. The plan is to payoff the bond at that time along with the prepayment penalty. Explain Significant Spending on Capital Projects Below: Form 3 ISM