The URL can be used to link to this page

Home My WebLink About03-2016 Departmental Financial ReportPeriod Ending: Issued By: City of South Bend Monthly Departmental Financial Report Page Contents 2 Narrative 3 Summaries 7 General Fund 22 Special Revenue Funds 57 Debt Service/Capital Project Funds 69 Enterprise Funds 95 Internal Service Funds 102 Trust Funds 105 Redevelopmemt Commission Funds Distribution Mayor Pete Buttigieg Chief of Staff James Mueller South Bend Common Council Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Senior Budget Analyst Cecil Eastman Department Heads Fiscal Officers March 31, 2016 Administration/Finance March 2016 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 18th 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, 2016, total revenue for the year was $48,260,399, 18% of estimated revenue. As of March 31, 2015 total revenue received was $47,635,755 within the same funds. Property taxes are received in June and January each year and were budgeted at $71,976,981 for 2016. Local income tax (LOIT, COIT and EDIT) receipts are budgeted to be $25.8 million in 2016, to be received in monthly installments of $2.15 million. As of March 31, 2016, total expenditures were $69,059,863 and outstanding encumbrances were $53,544,877, a total of $122,604,740 which represents 34% 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 $72,792,623 as of March 31, 2015. New for 2016, the 311 Call Center has now been placed in its own internal service fund, (Fund 279) and now appears as its own line item within the Internal Service sections of the summary reports. 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. 2 City of South Bend Monthly Department Financial Report REVENUE SUMMARY March 31, 2016 Values Con Fund Type Dept Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget Balance Percent of Budget City Funds General Fund 53,852,368 927,103 3,049,273 3,333,377 1,404,439 6% Special Revenue 102 Rainy Day 40,000 4,825 22,398 12,582 17,602 56% 103 Excess Levy 20 1 7 2 13 37% 201 Parks & Recreation 11,179,799 250,295 469,975 419,345 10,709,824 4% 202 Motor Vehicle Highway 9,181,883 834,492 2,238,165 2,253,955 6,943,718 24% 203 Recreation Nonreverting 1,448,565 144,974 291,347 276,649 1,157,218 20% 209 Studebaker-Oliver Reverting Grants 587,250 27,904 34,638 21,291 552,612 6% 210 Economic Development State Grants 73,511 2,208 20,246 473 53,265 28% 211 Department of Community Investment (DCI)2,647,925 194,422 726,631 535,047 1,921,294 27% 212 Dept of Community Investment Grants 3,800,000 152,736 585,744 462,515 3,214,256 15% 216 Police State Seizures 36,000 119 15,613 1,080 20,387 43% 217 Gift, Donation, Bequest 185,800 354 500 2,972 185,300 0% 218 Police Curfew Violations 1,000 32 120 30 880 12% 219 Unsafe Building 985,240 47,700 445,894 - 539,346 45% 220 Law Enforcement Continuing Education 218,000 27,926 86,075 70,693 131,925 39% 227 Loss Recovery 1,410 300 2,562 30,941 (1,152) 182% 244 Emergency Phone System- --19 - 0% 249 Public Safety LOIT 6,797,160 566,326 1,699,376 1,079,495 5,097,784 25% 251 Local Roads & Streets 1,269,000 97,202 518,440 276,603 750,560 41% 258 Human Rights Federal Grant 165,040 6,077 131,578 15,011 33,462 80% 271 Eastrace Waterway 30 1 3 8 27 11% 273 Morris PAC / Palais Royale Marketing 18,250 2,912 4,223 1,652 14,027 23% 280 Police Block Grants- 2 10 6 (10) 0% 281 Economic Develop. Commission-Revenue Bonds 150 15 71 40 80 47% 289 HAZMAT 10,000 18 83 13,838 9,917 1% 291 Indiana River Rescue 45,200 9,956 26,945 8,554 18,255 60% 292 Police Grants- --55 - 0% 294 Regional Police Academy 22,500 1,146 16,641 19,740 5,859 74% 295 COPS MORE Grant 92,000 8,352 17,657 2,026 74,343 19% 299 Police Federal Drug Enforcement 162,000 115 324 33,612 161,676 0% 404 County Option Income Tax 10,370,484 838,012 2,673,428 1,630,555 7,697,056 26% 408 Economic Development Income Tax 10,159,262 1,159,172 2,928,147 1,694,979 7,231,115 29% 410 Urban Development Action Grant 169,827 269 1,604 98,526 168,223 1% 655 Project Releaf 437,290 37,150 112,040 110,548 325,250 26% 705 Police K-9 Unit 2,020 2 10 505 2,010 0% Special Revenue Total 60,106,616 4,415,016 13,070,496 9,073,345 47,036,120 22% City Debt Service 313 Football Hall of Fame Debt Service 1,383,212 9,343 28,029 12,810 1,355,183 2% City Debt Service Total 1,383,212 9,343 28,029 12,810 1,355,183 2% Capital Project 377 Professional Sports Development 709,718 64,832 286,125 299,888 423,593 40% 401 Coveleski Stadium Capital 15,200 40 207 59 14,993 1% 403 Zoo Endowment 200 27 127 72 73 64% 405 Park Nonreverting Capital 162,500 753 2,124 4,956 160,376 1% 406 Cumulative Capital Development 526,737 4,679 14,608 13,832 512,129 3% 407 Cumulative Capital Improvement 435,700 154 150,801 290 284,899 35% 412 Major Moves Construction 1,048,178 1,223 592,176 373,522 456,002 56% 416 Morris Performing Arts Center Capital 103,000 7,376 16,197 19,800 86,803 16% 434 Community Revitalization Enhancement District- 56 156 79 (156) 0% 450 Palais Royale Historic Preservation 17,450 341 2,613 2,628 14,837 15% 677 Football Hall of Fame Capital 2,000 271 1,288 812 713 64% Capital Project Total 3,020,683 79,752 1,066,422 715,938 1,954,261 35% Enterprise 287 Emergency Medical Services Capital 2,075,500 1,628 1,314,585 396,740 760,915 63% 288 Emergency Medical Services Operating 5,085,012 458,825 1,433,562 1,040,620 3,651,450 28% 600 Consolidated Building Fund 3,517,968 108,519 867,300 1,034,221 2,650,668 25% 601 Parking Garages 1,052,226 90,272 265,480 236,157 786,746 25% 610 Solid Waste Operations 5,596,749 443,628 1,309,415 1,216,903 4,287,334 23% 611 Solid Waste Capital 925,397 311,000 562,036 200,034 363,361 61% 620 Water Works Operations 14,604,116 1,121,884 3,294,987 3,176,211 11,309,129 23% 622 Water Works Capital 15,000 1,599 7,422 4,556 7,578 49% 623 Water Works Bond Capital- --283 - 0% 624 Water Works Customer Deposit 8,400 840 3,895 2,157 4,505 46% 625 Water Works Sinking 2,049,681 170,664 512,245 511,378 1,537,436 25% 626 Water W orks Bond Reserve 9,500 892 4,143 2,351 5,357 44% 629 Water Works Reserve Operations & Maintenance 175,166 1,287 233,261 153,298 (58,095) 133% 640 Sewer Repair Insurance 564,725 52,097 159,382 154,971 405,343 28% 641 Sewage Works Operations 36,711,600 3,160,061 9,157,085 8,401,964 27,554,515 25% 642 Sewage Works Capital 2,532,000 4,485 22,105 5,512 2,509,895 1% 643 Sewage Works Reserve Operations & Maint.552,997 2,265 906,418 261,101 (353,421) 164% 3 City of South Bend Monthly Department Financial Report REVENUE SUMMARY March 31, 2016 Values Con Fund Type Dept Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Budget Balance Percent of Budget 649 Sewage Sinking 9,274,391 761,964 2,286,075 2,322,320 6,988,316 25% 653 Sewage Debt Service Reserve- 612 637 - (637) 0% 659 Sewer Bond 2011 2,000 129 598 2,193 1,402 30% 661 Sewer Bond 2012 70,000 7,297 35,432 24,535 34,568 51% 664 2013A Cost of Issuance Fund- 3 12 7 (12) 0% 666 2015 Sewer Bond Issuance- 4 85 - (85) 0% 670 Century Center 3,983,787 225,335 1,412,428 1,019,635 2,571,359 35% 671 Century Center Capital 500 85 249 68 251 50% 672 Century Center Energy Conservation Debt Svc 237,132 4 12 - 237,120 0% Enterprise Total 89,043,847 6,925,378 23,788,851 20,167,216 65,254,996 27% Internal Service 222 Central Services 8,234,637 638,910 1,871,950 2,054,157 6,362,687 23% 224 Central Services Capital 130,519 94 476 - 130,043 0% 226 Liability Insurance 2,256,883 185,820 576,462 311,266 1,680,421 26% 278 Take Home Vehicle Police 64,400 9,243 28,440 33,578 35,960 44% 279 311 Call Center 499,358 39,960 117,939 - 381,419 24% 711 Self-Funded Employee Benefits 17,174,845 1,390,952 4,144,244 3,692,829 13,030,601 24% 713 Unemployment Compensation 107,282 1,311 3,593 25,770 103,689 3% Internal Service Total 28,467,924 2,266,291 6,743,104 6,117,600 21,724,820 24% Trust & Agency 701 Firefighters Pension 5,447,592 -1,061 872 5,446,531 0% 702 Police Pension 6,133,500 311 2,773 1,547 6,130,727 0% 730 City Cemetery 150 16 74 41 76 49% Trust & Agency Total 11,581,242 327 3,907 2,460 11,577,335 0% City Funds Total 247,455,892 14,623,210 47,750,083 39,422,747 150,307,153 19% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River W est Development Area (Airport TIF)18,885,314 92,026 193,687 6,562,954 18,691,627 1% 422 TIF - West Washington 424,000 836 3,865 1,680 420,135 1% 425 Redevelopment Retail & Leighton Plaza 172,003 13,574 35,726 41,239 136,277 21% 429 River East Development Area (NE Dev TIF)2,757,000 4,151 19,395 1,458,209 2,737,605 1% 430 TIF - Southside Development #1 2,433,000 3,363 15,537 6,758 2,417,463 1% 435 TIF - Douglas Road 320,750 28 317 232 320,433 0% 436 River East Residential (NE Res TIF)3,162,422 -213,108 1,571 2,949,314 7% Tax Increment Financing Total 28,154,489 113,977 481,636 8,072,644 27,672,853 2% Redevelopment 433 Redevelopment General 152 5 22 15 130 14% 439 Certified Technology Park 14,637 1,262 5,887 7,309 8,750 40% 454 Airport Urban Enterprise Zone 1,500 211 978 550 522 65% 619 Blackthorn Operations- --119,238 - 0% Redevelopment Total 16,289 1,478 6,887 127,112 9,402 42% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 576 2,674 1,511 2,326 53% 317 Coveleski Debt Service Reserve 1,800 282 1,309 735 491 73% 328 Redevelopment Bond - Palais Royale 6,000 962 4,467 2,525 1,533 74% 432 TIF - Southside Development #3 25,000 2,741 13,344 8,481 11,656 53% Debt Service Total 37,800 4,561 21,793 13,253 16,007 58% Redevelopment Commission Controlled Funds Total 28,208,578 120,016 510,316 8,213,008 27,698,262 2% Grand Total 275,664,470 14,743,226 48,260,399 47,635,755 178,005,415 18% 4 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY March 31, 2016 Co ntr ol Fund Type Department Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Current Encumbrances Budget Balance Percent of Budget City Funds General Fund 101-0101 Mayor's Office 749,883 50,030 160,918 181,466 133 588,832 21% 101-0104 311 Call Center 5,933 595 2,224 135,480 3,809 (100) 102% 101-0201 City Clerk 443,475 37,749 100,296 89,159 33,783 309,396 30% 101-0301 Common Council 522,735 33,221 134,744 169,646 87,326 300,665 42% 101-0302 WNIT Contract 43,000 - - - - 43,000 0% 101-0401 Administration & Finance 2,227,488 128,874 401,467 461,537 68,039 1,757,982 21% 101-0404 Morris Performing Arts Center 1,129,897 92,842 252,973 265,098 59,088 817,836 28% 101-0405 Palais Royale 498,438 38,176 123,487 112,844 54,299 320,652 36% 101-0501 Legal Department 1,036,772 78,779 230,967 237,031 16,015 789,790 24% 101-0602 Engineering 1,225,137 89,283 241,739 242,520 75,601 907,798 26% 101-0801 Police Department 26,399,474 1,935,877 5,612,127 6,426,566 156,407 20,630,940 22% 101-0802 Communications Center 1,479,012 369,753 369,753 135,136 1,109,259 - 100% 101-0901 Fire Department 18,185,989 1,437,795 4,194,034 5,246,462 295,558 13,696,397 25% 101-0905 Fire LOIT 2013- - - 411 - - 0% 101-1008 Human Rights 371,226 25,631 84,713 101,912 7,612 278,901 25% 101-1201 Code Enforcement 202,164 - 202,164 - - (0) 100% General Fund Total 54,520,623 4,318,604 12,111,606 13,805,269 1,966,928 40,442,089 26% Special Revenue 103 Excess Levy 3,688 - 3,648 - - 40 99% 201 Parks & Recreation 11,248,697 1,178,404 2,633,356 2,879,469 549,676 8,065,665 28% 202 Motor Vehicle Highway 10,977,409 896,714 2,384,624 2,704,804 384,079 8,208,706 25% 203 Recreation Nonreverting 1,459,754 69,287 161,893 171,640 142,412 1,155,449 21% 209 Studebaker-Oliver Reverting Grants 1,683,250 19,040 42,272 9,710 440,979 1,200,000 29% 210 Economic Development State Grants 1,935,497 31,790 1,494,282 30,203 416,011 25,204 99% 211 Department of Community Investment (DCI)2,687,313 177,764 554,921 616,253 48,450 2,083,941 22% 212 Dept of Community Investment Grants 7,356,963 172,309 544,667 415,275 3,123,914 3,688,382 50% 216 Police State Seizures 36,000 - - - - 36,000 0% 217 Gift, Donation, Bequest 362,500 - - 27,966 - 362,500 0% 218 Police Curfew Violations 1,000 - - - - 1,000 0% 219 Unsafe Building- 20,481 35,278 - 103,652 (138,930) 0% 220 Law Enforcement Continuing Education 743,508 13,572 66,300 72,294 15,687 661,521 11% 227 Loss Recovery 480,311 20,008 23,216 1,302,296 107,095 350,000 27% 249 Public Safety LOIT 6,600,626 513,715 1,527,993 1,796,725 - 5,072,633 23% 251 Local Roads & Streets 2,242,944 75,028 291,688 46,040 713,415 1,237,841 45% 258 Human Rights Federal Grant 221,838 11,302 36,562 57,261 12,008 173,268 22% 273 Morris PAC / Palais Royale Marketing 18,878 - - 96 2,457 16,422 13% 289 HAZMAT 10,000 - - 21,542 1,170 10,000 12% 291 Indiana River Rescue 95,300 3,610 6,121 23,515 - 89,179 6% 292 Police Grants 55,373 6,188 18,825 15,296 36,548 - 100% 294 Regional Police Academy 22,500 280 581 12,639 - 21,919 3% 295 COPS MORE Grant 102,245 1,923 6,669 25,760 14,995 80,581 21% 299 Police Federal Drug Enforcement 168,965 10,752 12,042 43,255 - 156,924 7% 404 County Option Income Tax 15,162,148 853,652 3,751,682 2,919,294 2,530,627 8,879,840 41% 408 Economic Development Income Tax 10,560,181 169,782 2,422,410 2,499,253 607,027 7,530,744 29% 410 Urban Development Action Grant 238,173 - 146,068 - - 92,106 61% 655 Project Releaf 528,358 2,937 20,160 20,025 - 508,198 4% 705 Police K-9 Unit 2,020 - - 970 - 2,020 0% Special Revenue Total 75,005,439 4,248,536 16,185,256 15,711,579 9,250,201 49,571,153 34% City Debt Service 313 Football Hall of Fame Debt Service 1,268,015 - 636,000 636,000 - 632,015 50% City Debt Service Total 1,268,015 - 636,000 636,000 - 632,015 50% Capital Project 377 Professional Sports Development 838,052 - 473,088 481,573 - 364,965 56% 401 Coveleski Stadium Capital- - 22,000 - - (22,000) 0% 405 Park Nonreverting Capital 268,333 1,948 1,948 - 43,909 222,476 17% 406 Cumulative Capital Development 526,737 56,546 169,196 169,196 - 357,541 32% 407 Cumulative Capital Improvement 365,907 - 184,125 183,750 - 181,782 50% 412 Major Moves Construction 2,385,033 38,870 351,475 545,253 791,732 1,241,826 48% 416 Morris Performing Arts Center Capital 78,923 2,467 12,931 14,879 5,293 60,698 23% 434 Community Revitalization Enhancement District- - - 3,897 - - 0% 677 Football Hall of Fame Capital 84,801 6,938 27,415 19,211 388 56,998 33% Capital Project Total 4,547,786 106,768 1,242,178 1,417,758 841,323 2,464,286 46% Enterprise 287 Emergency Medical Services Capital 2,247,611 152,919 152,919 35,728 210,692 1,884,000 16% 288 Emergency Medical Services Operating 6,115,643 374,778 1,327,177 490,484 95,598 4,692,868 23% 600 Consolidated Building Fund 4,450,974 276,911 858,924 742,896 277,786 3,314,263 26% 601 Parking Garages 1,393,469 111,888 229,526 266,924 604,555 559,389 60% 610 Solid Waste Operations 5,597,412 375,760 1,393,911 1,316,442 685,556 3,517,946 37% 611 Solid Waste Capital 925,197 11,143 262,258 234,946 922 662,017 28% 620 Water Works Operations 16,984,657 1,109,031 3,692,519 3,488,646 744,569 12,547,568 26% 622 Water Works Capital 821,797 - - 86,334 177,797 644,000 22% 5 City of South Bend Monthly Department Financial Report EXPENDITURE SUMMARY March 31, 2016 Co ntr ol Fund Type Department Name Current Amended Budget Current Month Actual Current YTD Actual Prior YTD Actual Current Encumbrances Budget Balance Percent of Budget City Enterp 623 Water Works Bond Capital- - - 53,304 - - 0% 624 Water Works Customer Deposit 8,400 840 1,927 1,302 - 6,473 23% 625 Water Works Sinking 2,049,681 159 724 550 - 2,048,957 0% 626 Water Works Bond Reserve 9,500 2,050 2,050 - - 7,450 22% 629 Water Works Reserve Operations & Maintenance 10,000 1,287 2,894 1,866 - 7,106 29% 640 Sewer Repair Insurance 549,413 51,533 108,604 122,027 49,453 391,356 29% 641 Sewage Works Operations 39,736,144 2,277,067 7,956,475 7,414,229 2,796,641 28,983,027 27% 642 Sewage Works Capital 7,631,946 150,821 839,251 488,448 4,201,289 2,591,405 66% 643 Sewage Works Reserve Operations & Maint.16,000 2,265 4,911 3,040 - 11,089 31% 649 Sewage Sinking 9,274,298 - 1,850 1,850 - 9,272,448 0% 659 Sewer Bond 2011 172,088 - - 892,692 172,088 0 100% 661 Sewer Bond 2012 20,187,062 445,588 1,707,327 522,432 11,258,241 6,879,888 64% 666 2015 Sewer Bond Issuance- - 2,500 - - (2,500) 0% 670 Century Center 3,972,438 316,542 956,640 881,249 - 3,015,798 24% 671 Century Center Capital- - - 66,156 - - 0% 672 Century Center Energy Conservation Debt Svc 237,132 - - - - 237,132 0% Enterprise Total 122,390,862 5,660,583 19,502,389 17,111,545 21,275,188 81,271,679 33% Internal Service 222 Central Services 8,289,479 646,405 1,821,890 1,993,337 2,525,593 3,941,996 52% 224 Central Services Capital 305,584 - 23,369 - 151,696 130,519 57% 226 Liability Insurance 3,120,348 101,220 435,308 649,845 91,603 2,593,437 17% 278 Take Home Vehicle Police 10,000 - 53 - - 9,947 1% 279 311 Call Center 499,357 40,140 118,119 - 5,425 375,813 25% 711 Self-Funded Employee Benefits 17,378,890 1,576,792 4,014,463 3,088,387 751,496 12,612,931 27% 713 Unemployment Compensation 113,882 5,252 14,567 24,318 22,000 77,315 32% Internal Service Total 29,717,540 2,369,808 6,427,769 5,755,887 3,547,814 19,741,957 34% Trust & Agency 701 Firefighters Pension 5,464,843 407,173 1,236,364 1,332,784 - 4,228,479 23% 702 Police Pension 6,797,398 651,745 1,696,646 1,620,158 - 5,100,752 25% 730 City Cemetery 20,000 - - - - 20,000 0% Trust & Agency Total 12,282,241 1,058,918 2,933,010 2,952,942 - 9,349,231 24% City Funds Total 299,732,506 17,763,218 59,038,209 57,390,981 36,881,453 203,472,408 32% Redevelopment Commission Controlled Funds Tax Increment Financing 324 River West Development Area (Airport TIF)31,502,077 1,749,039 7,267,599 5,697,767 7,955,087 16,279,391 48% 420 Tax Incremental Financing (TIF) - Downtown- - - 4,088,473 - - 0% 422 TIF - West Washington 1,403,366 3,461 6,827 22,950 310,339 1,086,200 23% 425 Redevelopment Retail & Leighton Plaza 160,406 6,656 15,986 34,372 - 144,420 10% 426 TIF - Central Medical Service Area- - - 2,294,533 - - 0% 429 River East Development Area (NE Dev TIF)8,335,159 12,236 97,847 117,956 4,023,568 4,213,744 49% 430 TIF - Southside Development #1 7,411,815 142,775 297,025 522,222 4,370,230 2,744,560 63% 435 TIF - Douglas Road 354,200 - 140,000 169,620 4,200 210,000 41% 436 River East Residential (NE Res TIF)3,430,000 - 1,684,089 1,710,589 - 1,745,911 49% Tax Increment Financing Total 52,597,023 1,914,167 9,509,373 14,658,482 16,663,424 26,424,225 50% Redevelopment 433 Redevelopment General 4,500 - - - - 4,500 0% 439 Certified Technology Park 2,692,913 142,913 142,913 198 - 2,550,000 5% 454 Airport Urban Enterprise Zone 50,000 - - - - 50,000 0% 619 Blackthorn Operations- - - 181,258 - - 0% Redevelopment Total 2,747,413 142,913 142,913 181,456 - 2,604,500 5% Debt Service 315 Redevelopment Bond - Airport Taxable 5,000 576 1,323 912 - 3,677 26% 328 Redevelopment Bond - Palais Royale 6,000 962 2,211 1,524 - 3,789 37% 432 TIF - Southside Development #3 490,503 - 365,835 559,269 - 124,668 75% Debt Service Total 501,503 1,538 369,369 561,705 - 132,135 74% Redevelopment Commission Controlled Funds Total 55,845,939 2,058,618 10,021,654 15,401,642 16,663,424 29,160,860 48% Grand Total 355,578,445 19,821,835 69,059,863 72,792,623 53,544,877 232,633,269 34% 6 Fund/Department Name Month March Fund/Department Number 101-0101 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 749,283 49,925 160,613 181,416 - 588,670 21% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - 50 - - 0% Other Income 600 105 305 - - 295 51% Transfers In- - - - - - 0% Total Revenue 749,883 50,030 160,918 181,466 - 588,965 21% Personnel 685,492 43,979 139,030 170,332 - 546,462 20% Supplies 3,662 40 722 3,216 119 2,821 23% Services 60,139 6,011 21,019 7,221 14 39,106 35% Debt Service 590 - 147 697 - 443 25% Capital- - - - - - 0% Transfers Out- - - - - - 0% 749,883 50,030 160,918 181,466 133 588,832 21% Net- - - - (133) 133 Cash Balance- - Full Time 7.00 6.00 6.00 Part-Time /Seasonal/Temporary 2.00 1.00 1.00 Total 9.00 7.00 7.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Mayor's Office There are no capital projects budgeted for 2016. Expenditures Revenue Total Expenditures Staffing Expenditures are in line with budgeted expectations for 2016. Last year at this time, three payrolls occurred in January. As a result, personnel services were higher last year. Currently, the Mayor's office is down one position as the position of Deputy Chief of Staff to the Mayor, is vacant. Form 37 Fund/Department Name Month March Fund/Department Number 101-0104 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 5,933 (1,629) - - - 5,933 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- 2,224 2,224 135,480 - (2,224) 0% Transfers In- - - - - - 0% Total Revenue 5,933 595 2,224 135,480 - 3,709 37% Personnel- - - 115,348 - - 0% Supplies 2,350 - 1,629 1,352 721 - 100% Services 3,583 595 595 18,779 3,088 (100) 103% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 5,933 595 2,224 135,480 3,809 (100) 102% Net- - - - (3,809) 3,809 Cash Balance- - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report 311 Call Center Expenditures Revenue Total Expenditures Staffing As of January 1, 2016, the 311 Call Center is now in its own internal service fund, Fund 279. The only budgeted items are remaining encumbrances from 2015--purchase orders that haven't been invoiced by the vendors yet. Form 38 Fund/Department Name Month March Fund/Department Number 101-0201 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 443,475 37,749 100,296 89,159 - 343,179 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- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 443,475 37,749 100,296 89,159 - 343,179 23% Personnel 332,855 23,595 77,603 80,791 - 255,252 23% Supplies 7,582 1,363 3,801 713 1,212 2,569 66% Services 103,038 12,791 18,892 7,655 32,571 51,575 50% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 443,475 37,749 100,296 89,159 33,783 309,396 30% Net- - - - (33,783) 33,783 Cash Balance- - 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 Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report City Clerk This year, no capital projects have been budgeted. Expenditures Revenue Total Expenditures Staffing Expenditures are consistent with normal operating costs. Form 39 Fund/Department Name Month March Fund/Department Number 101-0301 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 522,485 33,221 134,744 169,559 - 387,741 26% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations 250 - - 87 - 250 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 522,735 33,221 134,744 169,646 - 387,991 26% Personnel 279,671 24,603 66,735 54,918 30,856 182,080 35% Supplies 8,936 129 5,237 404 817 2,882 68% Services 234,128 8,488 62,771 114,324 55,653 115,703 51% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 522,735 33,221 134,744 169,646 87,326 300,665 42% Net- - - - (87,326) 87,326 Cash Balance- - Full Time 9.00 9.00 9.00 Part-Time /Seasonal/Temporary- - - Total 9.00 9.00 9.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Common Council Expenditures Revenue Total Expenditures Staffing There are nine (9) Council Members. Last year, expenditures higher than normal in the services category due to unforseen legal expenses. Form 310 Fund/Department Name Month March Fund/Department Number 101-0302 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget 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% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 43,000 - - - - 43,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 43,000 - - - - 43,000 0% Net- - - - - - Cash Balance- - Full Time- - Part-Time /Seasonal/Temporary- - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report WNIT Contract Expenditures Revenue Total Expenditures Staffing This annual expenditure was previously paid from the Council department (101-0301) but was segregated upon the Council's request. The invoice was received and paid in April. Form 311 Fund/Department Name Month March Fund/Department Number 101-0401 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 2,217,438 128,874 387,919 460,981 - 1,829,519 17% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 10,050 - 13,548 556 - (3,498) 135% Transfers In- - - - - - 0% Total Revenue 2,227,488 128,874 401,467 461,537 - 1,826,021 18% Personnel 1,978,924 110,803 363,787 434,312 - 1,615,137 18% Supplies 42,034 1,928 5,177 7,626 5,092 31,765 24% Services 201,358 15,517 31,233 18,957 62,948 107,177 47% Debt Service 5,172 626 1,269 643 - 3,903 25% Capital- - - - - - 0% Transfers Out- - - - - - 0% 2,227,488 128,874 401,467 461,537 68,039 1,757,982 21% Net- - - - (68,039) 68,039 Cash Balance- - Full Time 23.0 21.0 Part-Time /Seasonal/Temporary- 1.0 Total 23.0 22.0- Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Administration & Finance None Expenditures Revenue Total Expenditures Staffing Transferred Chief Technology Officer to COIT for 2015 budget and added new HR Generalist position. Overall spending appears consistent with expectations. Full time excludes 3 IT/Innovation employees who are paid from COIT. Encumbrances relate to an outstanding contract for diversity consulting which will take place in 2016. Form 312 Fund/Department Name Month March Fund/Department Number 101-0404 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 179,897 (72,437) 31,595 60,044 - 148,302 18% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 943,000 165,066 221,165 203,261 - 721,835 23% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 7,000 213 213 1,793 - 6,787 3% Transfers In- - - - - - 0% Total Revenue 1,129,897 92,842 252,973 265,098 - 876,924 22% Personnel 823,612 60,569 174,606 187,615 100 648,906 21% Supplies 22,698 1,155 2,347 4,650 9,533 10,818 52% Services 283,587 31,118 76,020 72,833 49,455 158,112 44% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,129,897 92,842 252,973 265,098 59,088 817,836 28% Net- - - - (59,088) 59,088 Cash Balance- - 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 Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Total Expenditures Staffing New Catering Contract in effect starting with February 2016 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. 2016 City of South Bend Monthly Financial Report Morris Performing Arts Center Revenue Expenditures Form 313 Fund/Department Name Month March Fund/Department Number 101-0405 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 174,426 28,140 97,663 65,556 - 22,464 56% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 301,572 9,436 24,429 44,363 - 277,143 8% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 22,440 600 1,395 2,925 - 21,045 6% Transfers In- - - - - - 0% Total Revenue 498,438 38,176 123,487 112,844 - 320,652 25% Personnel 244,557 20,676 62,037 63,510 - 182,520 25% Supplies 28,855 91 7,730 1,352 3,192 17,933 38% Services 225,026 17,409 53,720 47,982 51,107 120,199 47% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 498,438 38,176 123,487 112,844 54,299 320,652 36% Net- - - - (54,299) - Cash Balance- - Full Time 2.00 3.00 3.00 Part-Time /Seasonal/Temporary 1.00 - - Total 3.00 3.00 3.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Palais Royale No Capital expenditures budgeted for 2016. Expenditures Revenue Total Expenditures Staffing One Part-Time / Seasonal / Temporary position was eliminated and a full time employee was added (needed for the day to day operations). Form 314 Fund/Department Name Month March Fund/Department Number 101-0501 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 986,772 78,779 230,967 236,524 - 755,805 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 50,000 - - 508 - 50,000 0% Transfers In- - - - - - 0% Total Revenue 1,036,772 78,779 230,967 237,031 - 805,805 22% Personnel 984,630 73,319 219,703 224,024 - 764,927 22% Supplies 3,712 166 413 2,811 1,015 2,284 38% Services 47,158 5,294 10,534 9,879 15,000 21,625 54% Debt Service 1,272 - 318 318 - 954 25% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,036,772 78,779 230,967 237,031 16,015 789,790 24% Net- - - - (16,015) 16,015 Cash Balance- - Full Time 11.60 11.60 Part-Time /Seasonal/Temporary- - Total 11.60 11.60 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Legal Department Expenditures Revenue Total Expenditures Staffing The Other Income of $50,000 is reimbursement for legal expenses from TIF funds which was received in November 2015. Spending appears to be on track with budgeted figures. Form 315 Fund/Department Name Month March Fund/Department Number 101-0602 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 1,090,688 89,263 207,695 242,295 - 882,993 19% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 134,449 20 34,044 225 - 100,405 25% Transfers In- - - - - - 0% Total Revenue 1,225,137 89,283 241,739 242,520 - 983,398 20% Personnel 776,239 48,511 144,973 150,402 - 631,266 19% Supplies 66,447 9,455 27,853 15,649 14,044 24,550 63% Services 358,063 29,273 62,791 71,223 59,613 235,659 34% Debt Service 24,388 2,044 6,120 5,246 1,944 16,324 33% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,225,137 89,283 241,739 242,520 75,601 907,798 26% Net- - - - (75,601) 75,601 Cash Balance- - Full Time 7.93 7.39 Part-Time /Seasonal/Temporary 1.41 1.41 Total 9.34 8.80 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Engineering Expenditures Revenue Total Expenditures Staffing The Engineering Department oversees the design and execution of the City's construction projects. $14K in encumbrance for Supplies is for the continued remodeling of the Engineering offices. $60K in encumbrance for Services include $42K for updating the City construction standards and $10K for office remodeling. Other income includes reimbursement from the River West TIF for 80% of the salary of an engineer. Staffing is short by one position. Form 316 Fund/Department Name Month March Fund/Department Number 101-0801 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 26,061,774 1,931,774 5,505,991 6,370,224 - 20,555,783 21% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations 7,500 - - - - 7,500 0% Other Income 330,200 4,103 106,136 56,342 - 224,064 32% Transfers In- - - - - - 0% Total Revenue 26,399,474 1,935,877 5,612,127 6,426,566 - 20,787,347 21% Personnel 23,573,968 1,752,465 5,073,899 5,699,810 - 18,500,069 22% Supplies 346,456 16,127 52,869 129,476 69,010 224,577 35% Services 2,471,050 166,931 483,910 595,564 87,397 1,899,743 23% Debt Service 8,000 354 1,449 1,716 - 6,551 18% Capital- - - - - - 0% Transfers Out- - - - - - 0% 26,399,474 1,935,877 5,612,127 6,426,566 156,407 20,630,940 22% Net- - - - (156,407) 156,407 Cash Balance- - Full Time 268.00 260.00 Part-Time /Seasonal/Temporary 60.00 28.0 Total 328.00 288.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Department Expenditures Revenue Total Expenditures Staffing This fund includes the expenditures for 222 of the 260 budgeted Police officers and 46 full time civilian staff. Fund 249 contains the funding for 38 of the 260 Police officers that are funded by the LOIT. The 2016 Personnel Expenditures are less the prior year amount due to the the fact that there were three payrolls paid in January 2015 compared to two in January 2016. This decrease was offset by increases in Police salaries and transfer of five officer's salaries from the LOIT to the General Fund. Form 317 Fund/Department Name Month March Fund/Department Number 101-0802 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 1,479,012 369,753 369,753 135,136 - 1,109,259 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- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,479,012 369,753 369,753 135,136 - 1,109,259 25% Personnel- - - 135,136 - - 0% Supplies- - - - - - 0% Services 1,479,012 369,753 369,753 - 1,109,259 - 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,479,012 369,753 369,753 135,136 1,109,259 - 100% Net- - - - (1,109,259) 1,109,259 Cash Balance- - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Communications Center Expenditures Revenue Total Expenditures Staffing 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 2015 Personnel costs are the 2014 salary costs for the Communications staff paid in 2015. There are no additional salaries to be paid. The Services budget is the annual amount that the County will charge SBPD as a participant in using the PSAP. Form 318 Fund/Department Name Month March Fund/Department Number 101-0901 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 18,173,989 1,437,417 4,182,872 5,139,029 13,991,117 23% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 6,000 378 1,127 103,487 - 4,873 19% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 6,000 - 10,035 3,946 - (4,035) 167% Transfers In- - - - - - 0% Total Revenue 18,185,989 1,437,795 4,194,034 5,246,462 - 13,991,955 23% Personnel 16,320,838 1,259,260 3,735,181 4,903,631 123,206 12,462,451 24% Supplies 387,643 25,647 61,535 31,456 72,462 253,646 35% Services 1,477,508 152,888 397,318 311,375 99,890 980,300 34% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 18,185,989 1,437,795 4,194,034 5,246,462 295,558 13,696,397 25% Net- - - - (295,558) 295,558 Cash Balance- - Full Time 181.00 175.00 Part-Time /Seasonal/Temporary- - Total 181.00 175.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Fire Department The Fire Department uses EMS Operating Fund 288 to capture revenue gererated by ambulance calls. All capital projects relating to the Fire Department operations are run through that fund. For that reason, you will not see expenses related to purchasing fire apparatus, or capital improvements to buildings in the General Fund. Expenditures Revenue Total Expenditures Staffing The South Bend Fire Department is budgeted to have 250 sworn firefighters and 7 civilian full time employees. 32 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. Form 319 Fund/Department Name Month March Fund/Department Number 101-1008 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 371,226 25,631 84,713 101,912 - 286,513 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- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 371,226 25,631 84,713 101,912 - 286,513 23% Personnel 298,643 22,936 67,967 75,267 - 230,676 23% Supplies 1,546 - 239 173 500 807 48% Services 71,037 2,695 16,507 16,065 7,112 47,418 33% Debt Service- - - - - - 0% Capital- - - 10,407 - - 0% Transfers Out- - - - - - 0% 371,226 25,631 84,713 101,912 7,612 278,901 25% Net- - - - (7,612) 7,612 Cash Balance- - Full Time 4.00 4.00 4.00 Part-Time /Seasonal/Temporary- - - Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Human Rights Expenditures Revenue Total Expenditures Staffing Expenditures are consistent with normal operating costs. Form 320 Fund/Department Name Month March Fund/Department Number 101-1201 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes/Non-Dept Revenue 202,164 - 202,164 - - (0) 100% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 202,164 - 202,164 - - (0) 100% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 202,164 - 202,164 - - (0) 100% 202,164 - 202,164 - - (0) 100% Net- - - - - - Cash Balance- - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Code Enforcement Expenditures Revenue Total Expenditures Staffing This department is being used solely to track the General Fund transfer to the Unsafe Building fund (219). Form 321 Fund/Department Name Month March Fund/Department Number 102 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 40,000 4,825 22,398 12,582 - 17,602 56% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 40,000 4,825 22,398 12,582 - 17,602 56% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 40,000 4,825 22,398 12,582 - 17,602 Cash Balance 8,714,505 8,654,770 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Rainy Day N/A Expenditures Revenue Total Expenditures Staffing 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. Form 322 Fund/Department Name Month March Fund/Department Number 103 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 20 1 7 2 - 13 37% Bond Proceeds- - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 20 1 7 2 - 13 37% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 3,688 - 3,648 - - 40 99% 3,688 - 3,648 - - 40 99% Net(3,668) 1 (3,641) 2 - (27) Cash Balance 25 3,650 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Excess Levy N/A Expenditures Revenue Total Expenditures Staffing A small excess of property tax was received in December 2014. The balance will be rolled into the General Fund in 2016. Form 323 Fund/Department Name Month March Fund/Department Number 201 Date Updated 4/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 7,487,000 - - 7,487,000 0% Local Income Taxes- - - - - - 0% Other Taxes 1,581,265 77,189 231,567 221,209 - 1,349,698 15% Grants/Intergovernmental- - - - - - 0% Charges for Services 1,946,740 151,836 191,914 150,184 - 1,754,826 10% Interest Earnings 10,000 1,698 12,611 7,080 - (2,611) 126% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 154,794 19,572 33,882 40,872 - 120,912 22% Transfers In- - - - - - 0% Total Revenue 11,179,799 250,295 469,975 419,345 - 10,709,824 4% Personnel 7,222,560 483,742 1,481,947 1,576,438 8,212 5,732,401 21% Supplies 1,139,754 56,084 171,907 259,980 363,435 604,412 47% Services 2,572,061 542,564 863,488 946,446 177,946 1,530,627 40% Debt Service 178,822 96,015 116,014 96,605 82 62,726 65% Capital 50,000 - - - 50,000 0% Transfers Out 85,500 - - - 85,500 0% 11,248,697 1,178,404 2,633,356 2,879,469 549,676 8,065,665 28% Net(68,898) (928,110) (2,163,381) (2,460,124) (549,676) 2,644,159 Cash Balance 1,769,327 1,040,167 Full Time 90.00 88.00 88.00 Part-Time /Seasonal/Temporary na 99.00 99.00 Total 90.00 187.00 187.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Parks & Recreation Because of decreasing property tax revenues, there is nominal capital budget in fund 201. A $5.6 million bond has been approved and funding was received in the second quarter of 2015 and will largely be spent throughout 2016. Expenditures Revenue Total Expenditures Staffing 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. Form 324 Fund/Department Name Month March Fund/Department Number 202 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 5,100,000 818,054 1,326,910 1,354,973 3,773,090 26% Grants/Intergovernmental- - 0% Charges for Services 366,433 12,599 56,562 53,252 309,871 15% Interest Earnings 9,100 3,092 13,815 5,727 (4,715) 152% Bond Proceeds- - 0% Donations- - 0% Other Income 3,350 747 2,628 1,753 722 78% Transfers In 3,703,000 838,250 838,250 2,864,750 23% Total Revenue 9,181,883 834,492 2,238,165 2,253,955 - 6,943,718 24% Personnel 4,411,058 303,758 953,802 1,110,640 3,457,256 22% Supplies 2,628,660 346,948 652,938 814,589 202,664 1,773,058 33% Services 3,170,906 184,370 595,475 642,842 181,415 2,394,016 25% Debt Service 677,327 61,637 142,951 97,275 534,376 21% Capital 89,458 39,458 39,458 50,000 44% Transfers Out- - 0% 10,977,409 896,714 2,384,624 2,704,804 384,079 8,208,706 25% Net(1,795,526) (62,221) (146,459) (450,849) (384,079) (1,264,988) Cash Balance 5,039,491 3,426,251 Full Time 52.91 49.96 Part-Time /Seasonal/Temporary 3.14 2.22 Total 56.05 52.18 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Motor Vehicle Highway Expenditures Revenue Total Expenditures Staffing Information included for Streets, Traffic & Lighting, and Curb & Sidewalk. Form 325 Fund/Department Name Month March Fund/Department Number 203 Date Updated 4/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 1,432,565 144,505 289,175 266,618 - 1,143,390 20% Interest Earnings 6,000 469 2,145 1,192 - 3,855 36% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 10,000 - 26 8,839 - 9,974 0% Transfers In- - - - - - 0% Total Revenue 1,448,565 144,974 291,347 276,649 - 1,157,218 20% Personnel 655,619 30,494 84,570 96,006 - 571,049 13% Supplies 307,068 14,206 27,449 38,998 83,928 195,690 36% Services 497,067 24,587 49,874 33,086 35,484 411,710 17% Debt Service- - - - - - 0% Capital- - - - 23,000 (23,000) 0% Transfers Out- - 3,550 - - 0% 1,459,754 69,287 161,893 171,640 142,412 1,155,449 21% Net(11,189) 75,686 129,454 105,009 (142,412) 1,769 Cash Balance 952,095 919,377 Full Time 1.00 1.00 1.00 Part-Time /Seasonal/Temporary-32.00 32.00 Total 1.00 33.00 33.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Recreation Nonreverting Expenditures Revenue Total Expenditures Staffing This fund accounts for Parks and Recreation programs and events that are self funded through user fees. Registration for spring program, classes and softball leagues began in February.Part time employees are individuals, not FTEs. Form 326 Fund/Department Name Month March Fund/Department Number 209 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 483,250 27,294 31,794 19,710 - 451,456 7% Charges for Services- - - - - - 0% Interest Earnings 4,000 610 2,845 1,581 - 1,155 71% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 100,000 - - - - 100,000 0% Transfers In- - - - - - 0% Total Revenue 587,250 27,904 34,638 21,291 - 552,612 6% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,683,250 19,040 42,272 9,710 440,979 1,200,000 29% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,683,250 19,040 42,272 9,710 440,979 1,200,000 29% Net(1,096,000) 8,864 (7,633) 11,581 (440,979) (647,388) Cash Balance 1,099,568 1,098,046 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Studebaker-Oliver Reverting Grants Expenditures Revenue Total Expenditures Staffing Brownfield Assessment Grant awarded by EPA for use in South Bend , Mishawaka and St. Joseph County covers the outstanding encumbrance. Consultant work proceeding. Form 327 Fund/Department Name Month March Fund/Department Number 210 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 11,725 - 2,878 473 - 8,847 25% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 61,786 2,208 17,368 - - 44,418 28% Transfers In- - - - - - 0% Total Revenue 73,511 2,208 20,246 473 - 53,265 28% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 663,486 13,787 617,809 12,200 74,481 (28,804) 104% Debt Service 72,011 18,003 18,003 18,003 - 54,008 25% Capital 1,200,000 - 858,470 - 341,530 - 100% Transfers Out- - - - - - 0% 1,935,497 31,790 1,494,282 30,203 416,011 25,204 99% Net(1,861,986) (29,582) (1,474,035) (29,730) (416,011) 28,060 Cash Balance(1,299,892) 299,703 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Economic Development State Grants Capital expenditures shown here are for the ND Turbo Project. Expenditures Revenue Total Expenditures Staffing We received a grant from the State for BEP for the Vacant & Abondoned Initiative $1,600,000 of this grant remains. An additional $2,000,000 state grant has been awarded for the ND Turbo Project. We must spend money and then seek reimbursement from the State. Reimbursement requests have been submitted. The State review process is long and arduous. We know that at least $200,000 should be received in April, hoping that number will actually be much higher. Form 328 Fund/Department Name Month March Fund/Department Number 211 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 249,000 73,688 109,773 39,194 - 139,227 44% Grants/Intergovernmental 419,287 118,805 118,805 1,951 - 300,482 28% Charges for Services 2,000 - - 430 - 2,000 0% Interest Earnings 10,000 765 3,052 1,558 - 6,948 31% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- 1,164 2,592 5 - (2,592) 0% Transfers In 1,967,638 - 492,410 491,910 - 1,475,229 25% Total Revenue 2,647,925 194,422 726,631 535,047 - 1,921,294 27% Personnel 2,161,561 146,849 458,959 502,128 - 1,702,602 21% Supplies 25,318 2,170 4,537 12,431 4,013 16,768 34% Services 463,434 28,745 91,426 101,694 44,437 327,571 29% Debt Service- - - - - - 0% Capital 37,000 - - - - 37,000 0% Transfers Out- - - - - - 0% 2,687,313 177,764 554,921 616,253 48,450 2,083,941 22% Net(39,388) 16,658 171,710 (81,207) (48,450) (162,648) Cash Balance 1,297,455 993,012 Full Time 25.00 22.00 22.00 Part-Time /Seasonal/Temporary- - - Total 25.00 22.00 22.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Department of Community Investment (DCI) Expenditures Revenue Total Expenditures Staffing Fund covers operations of the Department of Community Investment. Transfers In come from EDIT on a quarterly basis. In December, Three positions currently unfilled. Form 329 Fund/Department Name Month March Fund/Department Number 212 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 3,028,252 151,610 579,662 272,199 - 2,448,590 19% Charges for Services 1,000 - 30 150 - 970 3% Interest Earnings 2,000 10 836 780 - 1,164 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 768,748 1,117 5,216 189,386 - 763,532 1% Transfers In- - - - - - 0% Total Revenue 3,800,000 152,736 585,744 462,515 - 3,214,256 15% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Grants 7,356,963 172,309 544,167 415,275 3,123,914 3,688,882 50% Transfers Out- - 500 - - (500) 0% 7,356,963 172,309 544,667 415,275 3,123,914 3,688,382 50% Net(3,556,963) (19,573) 41,077 47,240 (3,123,914) (474,126) Cash Balance 594,983 837,625 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Dept of Community Investment Grants Expenditures Revenue Total Expenditures Staffing This fund covers multiple federal grants--Community Development Block Grant; Emergency Solutions Grant; Shelter Plus Care; Neighborhood Stabiliation Project, etc.. 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. We can only draw revenue in response to funds expended so revenues will come in as funds are spent. The federal government does not allow us to hold too much cash. Expenditures in 2016, as in previous years, will be made by outside not-for-profits for eligible activities such as: Homeownership Assistance; Housing Acquisition/Rehab/Resale; Owner-Occupied Housing Rehab; Spot Blight Clearance; Technical Assistance; Public Services; Public Facility Improvements; Emergency Shelter Operations; Rapid Re-housing; Shelter Plus Supportive Services; and New Housing Construction. All services must either assist low/moderate income households or eliminate slum & blight and/or other requirements specific to the particular grants. The not-for-profits can generally apply for funding for 2017 in the summer of 2016. Form 330 Fund/Department Name Month March Fund/Department Number 216 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 35,000 - 15,083 810 - 19,917 43% Charges for Services- - - - - - 0% Interest Earnings 1,000 119 530 270 - 470 53% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - 0% Total Revenue 36,000 119 15,613 1,080 - 20,387 43% Personnel- - - - - - 0% Supplies- 0% Services 36,000 - - 36,000 0% Debt Service- - - - - 0% Capital- - - - - - 0% Transfers Out- 0% 36,000 - - - - 36,000 0% Net- 119 15,613 1,080 - (15,613) Cash Balance 215,350 188,511 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police State Seizures Expenditures Revenue Total Expenditures Staffing Revenue stream is not a steady flow. It is dependent upon the processing and release of funds from the State for seized assets in drug activities. Expenditures are to be used to support the Police Departments effort to combat drug activity. Form 331 Fund/Department Name Month March Fund/Department Number 217 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 800 36 167 194 - 633 21% Bond Proceeds- - - - - - 0% Donations 185,000 318 333 2,778 - 184,667 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 185,800 354 500 2,972 - 185,300 0% Personnel- - - - - - 0% Supplies 12,500 - - - - 12,500 0% Services 350,000 - - 27,966 - 350,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 362,500 - - 27,966 - 362,500 0% Net(176,700) 354 500 (24,994) - (177,200) Cash Balance 65,373 112,944 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Gift, Donation, Bequest None Expenditures Revenue Total Expenditures Staffing $350,000 has been budgeted from this fund to help fund public art projects throughout the City. The City wishes to serve as a conduit for this activity and hopes to receive $185,000 in private donations to help fund these projects. Form 332 Fund/Department Name Month March Fund/Department Number 218 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 900 25 88 13 - 812 10% Interest Earnings 100 7 32 17 - 68 32% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,000 32 120 30 - 880 12% Personnel- - - - - - 0% Supplies- - - - - 0% Services 1,000 - - - - 1,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,000 - - - - 1,000 0% Net- 32 120 30 - (120) Cash Balance 12,356 12,035 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Curfew Violations Expenditures Revenue Total Expenditures Staffing This fund was established to collect curfew and prostitution fines. Expenditures are used for Police activities and training. Form 333 Fund/Department Name Month March Fund/Department Number 219 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- 0% Local Income Taxes- 0% Other Taxes- 0% Grants/Intergovernmental- 0% Charges for Services 230,000 47,700 105,461 - 124,539 46% Interest Earnings- 0% Bond Proceeds- 0% Donations- 0% Other Income- 0% Transfers In 755,240 340,433 - 414,807 45% Total Revenue 985,240 47,700 445,894 - - 539,346 45% Personnel- 0% Supplies- 0% Services- 20,481 35,278 103,652 (138,930) 0% Debt Service- 0% Capital- 0% Transfers Out- 0% - 20,481 35,278 - 103,652 (138,930) 0% Net 985,240 27,218 410,616 - (103,652) 678,276 Cash Balance 411,141 - Full Time- Part-Time /Seasonal/Temporary- - Total- - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Unsafe Building Expenditures Revenue Total Expenditures Staffing Unsafe Building fund is a new fund established in 2016 to receive fines and fees related to the Unsafe building law to defray the costs and expenses incurred in board ups and other services related to the unsafe buildings law. This is a non-reverting fund. Budget expenditures will be approriated at March 2016 budget transfer. Neat Group(600-1209) will bill Unsafe building fund for their expenditures incurred for the first quarter in April 2016. Form 334 Fund/Department Name Month March Fund/Department Number 220 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 200,000 16,946 67,051 61,605 - 132,949 34% Interest Earnings 5,000 503 2,344 1,404 - 2,656 47% Bond Proceeds- - - - - - 0% Donations 2,000 - - - - 2,000 0% Other Income 11,000 10,477 16,680 7,684 - (5,680) 152% Transfers In- - - .- - 0% Total Revenue 218,000 27,926 86,075 70,693 - 131,925 39% Personnel- - - - - - 0% Supplies 285,508 1,500 1,908 15,291 15,687 267,913 6% Services 458,000 12,072 64,392 57,003 - 393,608 14% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 743,508 13,572 66,300 72,294 15,687 661,521 11% Net(525,508) 14,354 19,775 (1,601) (15,687) (529,596) Cash Balance 910,041 967,172 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Law Enforcement Continuing Education Expenditures Revenue Total Expenditures Staffing 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. Form 335 Fund/Department Name Month March Fund/Department Number 227 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,410 550 2,562 8,441 - (1,152) 182% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- (250) - 22,500 - - 0% Transfers In- - - - - - 0% Total Revenue 1,410 300 2,562 30,941 - (1,152) 182% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 422,302 20,008 20,016 1,071,331 52,286 350,000 17% Debt Service- - - - - - 0% Capital 58,009 - 3,200 230,965 54,809 - 100% Transfers Out- - - - - - 0% 480,311 20,008 23,216 1,302,296 107,095 350,000 27% Net(478,901) (19,708) (20,654) (1,271,355) (107,095) (351,152) Cash Balance 972,603 4,592,538 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Loss Recovery The capital encumbrances are for the Lincolnway West Corridors project, carried over from 2015. Expenditures Revenue Total Expenditures Staffing Services include $350,000 budgeted for Ignition Park land remediation and $70,000 for vacant & abandoned housing. The ($250) in Other Income is a correction of an error for the 2016 Lamp Post Program, "Light Up South Bend". The $52K encumbrance in Services is for the continuation of the vacant & abandoned housing program. Form 336 Fund/Department Name Month March Fund/Department Number 244 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 19 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 19 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- - - 19 - - Cash Balance 33,671 33,671 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Emergency Phone System Expenditures Revenue Total Expenditures Staffing This fund was closed in 2015 with the advent of the county-wide PSAP system. The cash balance will probably remain throughout 2016. Form 337 Fund/Department Name Month March Fund/Department Number 249 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes 6,791,160 565,930 1,697,790 1,077,698 - 5,093,370 25% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 6,000 396 1,586 1,797 - 4,414 26% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 6,797,160 566,326 1,699,376 1,079,495 - 5,097,784 25% Personnel 6,600,626 513,715 1,527,993 1,796,725 - 5,072,633 23% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,600,626 513,715 1,527,993 1,796,725 - 5,072,633 23% Net 196,534 52,611 171,383 (717,229) - 25,151 Cash Balance 813,318 573,194 Full Time 70.00 70.00 Part-Time /Seasonal/Temporary- - Total 70.00 70.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Public Safety LOIT None. No capital equipment is purchased from this fund. Expenditures Revenue Total Expenditures Staffing This fund covered the costs of salaries and fringes for 38 police officers and 32 firefighters in 2016. Form 338 Fund/Department Name Month March Fund/Department Number 251 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 1,068,000 95,156 268,789 272,986 - 799,211 25% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 9,000 1,646 7,306 3,618 - 1,694 81% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 192,000 400 242,345 - - (50,345) 126% Transfers In- - - - - - 0% Total Revenue 1,269,000 97,202 518,440 276,603 - 750,560 41% Personnel- - - - - - 0% Supplies 469,668 - - - - 469,668 0% Services 412,369 - 125,634 11,000 106,562 180,174 56% Debt Service- - - - - - 0% Capital 1,360,907 75,028 166,055 35,040 606,853 587,999 57% Transfers Out- - - - - - 0% 2,242,944 75,028 291,688 46,040 713,415 1,237,841 45% Net(973,944) 22,174 226,752 230,563 (713,415) (487,281) Cash Balance 2,954,126 2,675,011 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Local Roads & Streets Projects in 2016 include the Safe Routes to School initiative for Coquillard and Harrison schools, Bendix Drive, and the Boland bicycle trail. The $607K in encumbrance includes $102K for Bendix Dr. (Lathrop to Toll Road), $127K for the Boland Trail, $205K for Safe Routes to School (Coquillard, Harrison, Perley and Lincoln schools) and $160K for Olive St. at Sample design. Expenditures Revenue Total Expenditures Staffing This fund receives most of its revenue through the gas tax, budgeted at $1.068 million for 2016. Other Income is reimbursement from the Indiana Department of Transportation (INDOT) as they pay the City back for their share of certain construction projects. An adjustment to the revenue budget will be made in April to cover the shortfall illustrated here. The fund is used predominantly for street capital projects but $469,668 is used for material for street repairs and other maintenance items. The encumbrance for $106K in Services includes $93K for traffic signal upgrades placed at various intersections around the City and $13K for updates to the City construction standards. Form 339 Fund/Department Name Month March Fund/Department Number 252 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 0 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 0 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- - - 0 - - Cash Balance 8 8 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Excess Welfare Distribution Expenditures Revenue Total Expenditures Staffing 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 2016. Form 340 Fund/Department Name Month March Fund/Department Number 258 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 145,000 121,000 1,667 - 24,000 83% Charges for Services- - - - - - 0% Interest Earnings 2,000 252 975 650 - 1,025 49% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 18,040 5,825 9,603 12,694 - 8,437 53% Transfers In- - - - - - 0% Total Revenue 165,040 6,077 131,578 15,011 - 33,462 80% Personnel 122,817 9,371 28,063 30,566 - 94,754 23% Supplies 2,300 - 629 168 1,171 500 78% Services 96,721 1,931 7,870 26,527 10,837 78,014 19% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 221,838 11,302 36,562 57,261 12,008 173,268 22% Net(56,798) (5,225) 95,016 (42,250) (12,008) (139,806) Cash Balance 520,412 488,002 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 Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Human Rights Federal Grant No capital projects have been budgeted for this year. Expenditures Revenue Total Expenditures Staffing 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. Revenues higher at this time versus last year due to timing of receipt for grants. Form 341 Fund/Department Name Month March Fund/Department Number 271 Date Updated 4/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 30 1 3 8 - 27 11% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 30 1 3 8 - 27 11% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 30 1 3 8 - 27 Cash Balance 1,338 5,320 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Eastrace Waterway Expenditures Revenue Total Expenditures Staffing 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. Form 342 Fund/Department Name Month March Fund/Department Number 273 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 18,000 2,895 4,145 1,613 - 13,855 23% Interest Earnings 250 17 78 39 - 172 31% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 18,250 2,912 4,223 1,652 - 14,027 23% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 18,878 - - 96 2,457 16,422 13% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 18,878 - - 96 2,457 16,422 13% Net(628) 2,912 4,223 1,556 (2,457) (2,395) Cash Balance 34,575 28,270 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Morris PAC / Palais Royale Marketing No Capital spending in this fund Expenditures Revenue Total Expenditures Staffing 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. Form 343 Fund/Department Name Month March Fund/Department Number 280 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 2 10 6 - (10) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 2 10 6 - (10) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- 2 10 6 - (10) Cash Balance 3,860 3,834 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Block Grants Expenditures Revenue Total Expenditures Staffing Justice Assistance Grant 2009-SB-B9-1280 was essentially completed in 2014. Form 344 Fund/Department Name Month March Fund/Department Number 281 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 150 15 71 40 - 80 47% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 150 15 71 40 - 80 47% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 150 15 71 40 - 80 Cash Balance 27,432 27,244 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Economic Develop. Commission-Revenue Bonds Expenditures Revenue Total Expenditures Staffing Fund to be used only for the expenses of EDC revenue bonds. These bonds have been paid off. Fund to be closed during 2016. Form 345 Fund/Department Name Month March Fund/Department Number 289 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 10,000 - - 13,787 - 10,000 0% Interest Earnings- 18 83 51 - (83) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 10,000 18 83 13,838 - 9,917 1% Personnel- - - - - - 0% Supplies 10,000 - - 21,542 1,170 8,830 12% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 10,000 - - 21,542 1,170 8,830 12% Net- 18 83 (7,704) (1,170) 1,087 Cash Balance 32,145 31,925 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report HAZMAT 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. Expenditures Revenue Total Expenditures Staffing 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. Form 346 Fund/Department Name Month March Fund/Department Number 291 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 45,000 9,900 26,700 8,400 - 18,300 59% Interest Earnings 200 56 245 154 - (45) 123% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 45,200 9,956 26,945 8,554 - 18,255 60% Personnel 15,500 231 692 462 - 14,808 4% Supplies 10,800 53 847 167 - 9,953 8% Services 69,000 3,326 4,582 1,889 - 64,418 7% Debt Service- - - - - - 0% Capital- - - 20,997 - - 0% Transfers Out- - - - - - 0% 95,300 3,610 6,121 23,515 - 89,179 6% Net(50,100) 6,346 20,824 (14,961) - (70,924) Cash Balance 116,269 90,439 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Indiana River Rescue Expenditures Revenue Total Expenditures Staffing No staffing associated with this fund. The fund collects tuition fees for students attending the Indiana River Rescue School. There are typically 2-4 schools a year, each a week in duration. Expenditures are for the maintenance and repair of rescue equipment. Form 347 Fund/Department Name Month March Fund/Department Number 292 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 55 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 55 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 55,373 6,188 18,825 15,296 36,548 - 100% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 55,373 6,188 18,825 15,296 36,548 - 100% Net(55,373) (6,188) (18,825) (15,241) (36,548) - Cash Balance 102,370 80,167 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Grants Expenditures Revenue Total Expenditures Staffing This Fund was set up to track the revenue and expenditures related to specific Federal Grants. Expenditures have been outlined in the grant. Form 348 Fund/Department Name Month March Fund/Department Number 294 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 20,000 1,100 16,450 19,638 - 3,550 82% Interest Earnings 500 46 191 102 - 309 38% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 2,000 - - - - 2,000 0% Transfers In- - - - - - 0% Total Revenue 22,500 1,146 16,641 19,740 - 5,859 74% Personnel- - - - - - 0% Supplies 1,500 100 100 - - 1,400 7% Services 21,000 180 481 12,639 - 20,519 2% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 22,500 280 581 12,639 - 21,919 3% Net- 866 16,060 7,101 - (16,060) Cash Balance 86,278 75,383 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Regional Police Academy Expenditures Revenue Total Expenditures Staffing 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. Form 349 Fund/Department Name Month March Fund/Department Number 295 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 53,750 - 7,319 - - 46,431 14% Charges for Services- - - - - - 0% Interest Earnings 500 70 316 146 - 184 63% Bond Proceeds- - - - - - 0% Donations 3,250 - - - - 3,250 0% Other Income 34,500 8,282 10,022 1,880 - 24,478 29% Transfers In- - - - - - 0% Total Revenue 92,000 8,352 17,657 2,026 - 74,343 19% Personnel- - - - - - 0% Supplies 57,245 - - 24,275 14,255 42,990 25% Services 45,000 1,923 6,669 1,485 740 37,591 16% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 102,245 1,923 6,669 25,760 14,995 80,581 21% Net(10,245) 6,429 10,988 (23,734) (14,995) (6,238) Cash Balance 132,726 82,500 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report COPS MORE Grant Expenditures Revenue Total Expenditures Staffing 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. Form 350 Fund/Department Name Month March Fund/Department Number 299 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 160,000 - - 33,370 - 160,000 0% Charges for Services- - - - - - 0% Interest Earnings 1,000 115 324 242 - 676 32% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,000 - - - - 1,000 0% Transfers In- - - - - - 0% Total Revenue 162,000 115 324 33,612 - 161,676 0% Personnel- - - - - - 0% Supplies 61,965 6,965 6,965 28,431 - 55,000 11% Services 62,000 - 1,290 14,824 - 60,710 2% Debt Service- - - - - - 0% Capital 45,000 3,787 3,787 - - 41,213 8% Transfers Out- - - - - - 0% 168,965 10,752 12,042 43,255 - 156,923 7% Net(6,965) (10,637) (11,718) (9,643) - 4,753 Cash Balance 241,033 335,899 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Federal Drug Enforcement Expenditures Revenue Total Expenditures Staffing 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. Form 351 Fund/Department Name Month March Fund/Department Number 404 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes 9,454,023 787,835 2,363,505 1,476,652 - 7,090,518 25% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 95,000 6,070 30,067 21,716 - 64,933 32% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 821,461 44,107 279,856 132,187 - 541,605 34% Transfers In- - - - - - 0% Total Revenue 10,370,484 838,012 2,673,428 1,630,555 - 7,697,056 26% Personnel 419,439 46,409 110,446 76,928 - 308,993 26% Supplies 1,595,825 106,595 188,633 160,787 65,419 1,341,773 16% Services 8,478,544 478,831 1,720,378 1,305,851 2,209,021 4,549,145 46% Debt Service 2,588,970 221,816 1,348,041 975,404 - 1,240,929 52% Capital 579,370 - 9,183 25,325 256,187 314,000 46% Transfers Out 1,500,000 - 375,000 375,000 - 1,125,000 25% 15,162,148 853,652 3,751,682 2,919,294 2,530,627 8,879,840 41% Net(4,791,664) (15,640) (1,078,254) (1,288,739) (2,530,627) (1,182,784) Cash Balance 11,102,281 13,662,643 Full Time 4.00 4.00 4.00 Part-Time /Seasonal/Temporary- - - Total 4.00 4.00 4.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report County Option Income Tax This year, $39,000 has been budgeted for IT laserfische replacement. Other budgeted capital projects include facade grants of $200,000, bus shelters of $180,000, and the LWW Ambassador program for $150,000. An encumbered amount of $134,141 remaining was carried forward this year to pay Transpo for the City's portion of the new CNG fueling station. Expenditures Revenue Total Expenditures Staffing Overall decrease in spending in 2016 over 2015 due to the end of the Vacant & Abandoned Housing Program in 2015. This decreased expenditures by approximately $2.0 million. Also, 2015 includeded equipment expenses of approximately $900,000 which is not required in the 2016 budget. Other income in 2016 includes $238,172 in loan repayments from the UDAG Fund 410 for the 1st Source/Marriott loan based on BDC collections as well as charges to City departments for computer services. The curb and sidewalk program remains at the 2015 level of $1,500,000. Form 352 Fund/Department Name Month March Fund/Department Number 408 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes 9,594,602 799,550 2,398,651 1,530,201 - 7,195,951 25% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 504,660 354,660 504,660 150,000 - - 100% Interest Earnings 60,000 4,962 24,837 14,696 - 35,163 41% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 82 - - 0% Transfers In- - - - - - 0% Total Revenue 10,159,262 1,159,172 2,928,147 1,694,979 - 7,231,115 29% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 2,604,237 103,800 231,866 436,540 607,027 1,765,344 32% Debt Service 1,274,662 63,354 566,970 438,568 - 707,692 44% Capital 197,500 2,628 2,628 3,200 - 194,872 1% Transfers Out 6,483,782 - 1,620,946 1,620,946 - 4,862,837 25% 10,560,181 169,782 2,422,410 2,499,253 607,027 7,530,744 29% Net(400,919) 989,390 505,737 (804,274) (607,027) (299,630) Cash Balance 10,399,620 9,365,951 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Economic Development Income Tax $275,000 has been budgeted for the Potawatomi Zoological Society. Expenditures Revenue Total Expenditures Staffing In 2015, Code Enforcement 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). Services include DTSB management costs, Chamber grants, and others. Form 353 Fund/Department Name Month March Fund/Department Number 410 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 110 269 1,604 40 - (1,494) 1458% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 169,717 - - 98,485 - 169,717 0% Transfers In- - - - - - 0% Total Revenue 169,827 269 1,604 98,526 - 168,223 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 238,173 - 146,068 - - 92,106 61% Capital- - - - - - 0% Transfers Out- - - - - - 0% 238,173 - 146,068 - - 92,106 61% Net(68,346) 269 (144,464) 98,526 - 76,118 Cash Balance 485,937 126,191 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Urban Development Action Grant Expenditures Revenue Total Expenditures Staffing 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 were received in 2015 and are expected in 2016. Form 354 Fund/Department Name Month March Fund/Department Number 655 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 433,290 36,616 109,637 109,072 323,653 25% Interest Earnings 4,000 534 2,403 1,476 1,597 60% Bond Proceeds- - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 437,290 37,150 112,040 110,548 - 325,250 26% Personnel 56,649 1,427 56,649 0% Supplies 3,145 3,145 0% Services 46,344 2,937 8,541 6,978 37,803 18% Debt Service 72,220 11,619 11,619 60,601 16% Capital- 0% Transfers Out 350,000 350,000 0% 528,358 2,937 20,160 20,025 - 508,198 4% Net(91,068) 34,214 91,880 90,524 - (182,948) Cash Balance 1,016,561 1,072,212 Full Time- - Part-Time /Seasonal/Temporary 2.60 - Total 2.60 - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Project Releaf Expenditures Revenue Total Expenditures Staffing Fall ReLeaf scheduled for October 2016. Form 355 Fund/Department Name Month March Fund/Department Number 705 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 20 2 10 5 - 10 50% Bond Proceeds- - - - - - 0% Donations 2,000 - - 500 - 2,000 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,020 2 10 505 - 2,010 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 2,020 - - 970 - 2,020 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 2,020 - - 970 - 2,020 0% Net- 2 10 (465) - (10) Cash Balance 3,879 2,854 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police K-9 Unit Expenditures Revenue Total Expenditures Staffing This fund was set up to receive donations for the Police K9 unit and track expenditures of those funds. Form 356 Fund/Department Name Month March Fund/Department Number 313 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 1,200,000 - - - - 1,200,000 0% Local Income Taxes- - - - - - 0% Other Taxes 183,112 9,343 28,029 12,769 - 155,083 15% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 100 - 0 41 - 100 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,383,212 9,343 28,029 12,810 - 1,355,183 2% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 1,268,015 - 636,000 636,000 - 632,015 50% Capital- - - - - - 0% Transfers Out- - - - - - 0% 1,268,015 - 636,000 636,000 - 632,015 50% Net 115,197 9,343 (607,971) (623,190) - 723,168 Cash Balance(596,575) (549,067) Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Football Hall of Fame Debt Service None Expenditures Revenue Total Expenditures Staffing 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. Form 357 Fund/Department Name Month March Fund/Department Number 377 Date Updated 4/15/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 660,000 64,753 261,209 269,670 - 398,791 40% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,455 79 890 695 - 565 61% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 48,263 - 24,026 29,523 - 24,237 50% Transfers In- - - - - - 0% Total Revenue 709,718 64,832 286,125 299,888 - 423,593 40% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 838,052 - 473,088 481,573 - 364,965 56% Capital- - - - - - 0% Transfers Out- - - - - - 0% 838,052 - 473,088 481,573 - 364,965 56% Net(128,334) 64,832 (186,962) (181,685) - 58,628 Cash Balance 240,412 414,407 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Professional Sports Development Expenditures Revenue Total Expenditures Staffing 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 2016. The final debt service payment on the 2010 Coveleski Stadium bonds (Four Winds Field) was paid January 15, 2018. Form 358 Fund/Department Name Month March Fund/Department Number 401 Date Updated 4/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 15,000 - - - - 15,000 0% Interest Earnings 200 40 207 59 - (7) 103% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 15,200 40 207 59 - 14,993 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - 22,000 - - (22,000) 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - 22,000 - - (22,000) 0% Net 15,200 40 (21,793) 59 - 36,993 Cash Balance 60,761 40,509 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Coveleski Stadium Capital Expenditures Revenue Total Expenditures Staffing Fund 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. Form 359 Fund/Department Name Month March Fund/Department Number 403 Date Updated 4/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 200 27 127 72 - 73 64% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 200 27 127 72 - 73 64% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 200 27 127 72 - 73 Cash Balance 49,573 49,233 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Zoo Endowment Expenditures Revenue Total Expenditures Staffing 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. Form 360 Fund/Department Name Month March Fund/Department Number 405 Date Updated 4/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 34,000 526 1,014 258 - 32,986 3% Interest Earnings 4,000 227 1,110 698 - 2,890 28% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 24,000 - - 4,000 - 24,000 0% Transfers In 100,500 - - - - 100,500 0% Total Revenue 162,500 753 2,124 4,956 - 160,376 1% Personnel- - - - - - 0% Supplies 58,173 1,948 1,948 - 9,568 46,657 20% Services 55,160 - - - 11,160 44,000 20% Debt Service- - - - - - 0% Capital 155,000 - - - 23,181 131,819 15% Transfers Out- - - - - - 0% 268,333 1,948 1,948 - 43,909 222,476 17% Net(105,833) (1,195) 176 4,956 (43,909) (62,100) Cash Balance 469,900 526,120 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Park Nonreverting Capital This fund is for expending nonreverting revenue collected from the Zoo, golf courses, East Race Waterway, picnic sites and forestry revenue. Expenditures Revenue Total Expenditures Staffing 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. Form 361 Fund/Department Name Month March Fund/Department Number 406 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 433,000 - - - - 433,000 0% Local Income Taxes- - - - - - 0% Other Taxes 90,737 4,420 13,260 13,048 - 77,477 15% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 3,000 259 1,348 784 - 1,652 45% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 526,737 4,679 14,608 13,832 - 512,129 3% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 526,737 56,546 169,196 169,196 - 357,541 32% Capital- - - - - - 0% Transfers Out- - - - - - 0% 526,737 56,546 169,196 169,196 - 357,541 32% Net- (51,867) (154,588) (155,364) - 154,588 Cash Balance 417,372 425,886 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Cumulative Capital Development Expenditures Revenue Total Expenditures Staffing 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. Form 362 Fund/Department Name Month March Fund/Department Number 407 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 410,000 - 150,000 - - 260,000 37% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 700 154 801 290 - (101) 114% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 25,000 - - - - 25,000 0% Transfers In- - - - - - 0% Total Revenue 435,700 154 150,801 290 - 284,899 35% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 365,907 - 184,125 183,750 - 181,782 50% Capital- - - - - - 0% Transfers Out- - - - - - 0% 365,907 - 184,125 183,750 - 181,782 50% Net 69,793 154 (33,324) (183,460) - 103,117 Cash Balance 277,907 66,023 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Cumulative Capital Improvement None Expenditures Revenue Total Expenditures Staffing 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. Form 363 Fund/Department Name Month March Fund/Department Number 412 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 25,000 1,223 5,587 5,491 - 19,413 22% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,023,178 - 586,589 368,031 - 436,589 57% Transfers In- - - - - - 0% Total Revenue 1,048,178 1,223 592,176 373,522 - 456,002 56% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 750,000 - - - 200,000 550,000 27% Debt Service- - - - - - 0% Capital 1,635,033 38,870 351,475 545,253 591,732 691,826 58% Transfers Out- - - - - - 0% 2,385,033 38,870 351,475 545,253 791,732 1,241,826 48% Net(1,336,855) (37,646) 240,701 (171,730) (791,732) (785,824) Cash Balance 2,424,674 3,469,932 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Major Moves Construction The 2016 budget continues funding for the Smart Streets initiative and includes $592K for Smart Streets, $250K for the Boland Trail and $80K for Bendix Drive (both projects moved from the LRSA Fund 251). The $592K encumbered comprises $208K for the downtown portion of the 2-way conversion of Main and Michigan/St. Joseph streets from Chippewa to LaSalle (the former IN-933), $62K for the Marion St. roundabout, $44K for the Bartlett St. roundabout, $23K for the Western Ave. corridor sidewalks and striping, and $27K for the Olive-Sample overpass. There remains a $173K encumbrance for utility relocation for the US 31 construction on the south side of town; this encumbrance may be closed out soon. Due to an error recording a change order, this fund paid $65K in error toward the 2-way conversion. This amount will be recovered from the TIF Bond in April or May. Expenditures Revenue Total Expenditures Staffing 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 I-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 August the fund received the second of two semi-annual payments on these loans, totaling $418,156 in principal and interest. Balances due as of Feb 29 are $509,857 from Fund 435 (Douglas Rd.) and $4,075,057 from Fund 436 (River East Residential). In 2016 with the first of two annual loans to the Parking Garages Fund 601 will be paid, $750,000 each year. The second loan will be issued in 2017. Form 364 Fund/Department Name Month March Fund/Department Number 416 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 100,000 7,087 14,863 19,050 - 85,137 15% Interest Earnings 3,000 289 1,334 750 - 1,666 44% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 103,000 7,376 16,197 19,800 - 86,803 16% Personnel- - - - - - 0% Supplies 30,000 - 5,000 1,268 280 24,720 18% Services 48,923 2,467 7,931 13,611 5,013 35,979 26% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 78,923 2,467 12,931 14,879 5,293 60,698 23% Net 24,077 4,909 3,266 4,921 (5,293) 26,105 Cash Balance 519,992 520,342 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Morris Performing Arts Center Capital There are no Capital projects budgeted for this year. Expenditures Revenue Total Expenditures Staffing 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. Form 365 Fund/Department Name Month March Fund/Department Number 434 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 56 156 79 - (156) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 56 156 79 - (156) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - 3,897 - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 3,897 - - 0% Net- 56 156 (3,818) - (156) Cash Balance 2,560 6,020 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Community Revitalization Enhancement District Expenditures Revenue Total Expenditures Staffing CRED is derived from State sale taxes generated within the CRED district (within Studebaker/Oliver area) up to a maximum $1M annually through 2015.The distribution is made once a year in October and amount fluctuates significantly (note historical revenues). Fund did not have sufficient revenue last few years to make full debt payment so COIT had to make a portion of the payments. May close this fund soon. Form 366 Fund/Department Name Month March Fund/Department Number 450 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 17,000 298 2,415 2,535 - 14,585 14% Interest Earnings 450 43 197 92 - 253 44% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 17,450 341 2,613 2,628 - 14,837 15% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 17,450 341 2,613 2,628 - 14,837 Cash Balance 79,026 65,789 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Palais Royale Historic Preservation No Capital spending in this fund. Expenditures Revenue Total Expenditures Staffing This fund is established to help maintain the Palais Royale. Funding is through a portion of revenues received from functions held at the Palais. Form 367 Fund/Department Name Month March Fund/Department Number 677 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 2,000 271 1,288 812 - 713 64% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,000 271 1,288 812 - 713 64% Personnel- - - - - - 0% Supplies 1,000 - - - - 1,000 0% Services 83,801 6,938 27,415 19,211 388 55,998 33% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 84,801 6,938 27,415 19,211 388 56,998 33% Net(82,801) (6,668) (26,127) (18,398) (388) (56,286) Cash Balance 476,749 540,822 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Football Hall of Fame Capital Expenditures Revenue Total Expenditures Staffing 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. Deal struck to sell building in 2015---to close in early 2016. Our expenses should only be utilities until closing and a contingency for furnace units during first couple years under new ownership. Under the terms of a lease of the former Hall of Fame to a private developer, money will be received into this fund beginning in 2016 through 2020. Any cash balance remaining in the fund will then revert to the General Fund (101) to cover a portion of a $1.75 million inter-fund loan. Form 368 Fund/Department Name Month March Fund/Department Number 287 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental 2,075,000 - - 396,727 - 0% Charges for Services - - 1,307,757 - - 767,243 0% Interest Earnings 500 1,628 6,828 13 - (6,328) 1366% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,075,500 1,628 1,314,585 396,740 - 760,915 63% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 55,000 - - - - 55,000 0% Capital 2,192,611 152,919 152,919 35,728 210,692 1,829,000 17% Transfers Out- - - - - - 0% 2,247,611 152,919 152,919 35,728 210,692 1,884,000 16% Net(172,111) (151,291) 1,161,666 361,012 (210,692) (1,123,085) Cash Balance 3,830,498 361,012 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Emergency Medical Services Capital Planned purchase of ambulance, replacement cardiac monitors, fleet vehicle. Expenditures Revenue Total Expenditures Staffing 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. Form 369 - Fund/Department Name Month March Fund/Department Number 288 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 5,023,512 456,042 1,421,536 1,020,543 - 3,601,976 28% Interest Earnings 10,000 1,231 5,729 4,289 - 4,271 57% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 49,500 1,552 6,297 15,788 - 43,203 13% Transfers In 2,000 - - - - 2,000 0% Total Revenue 5,085,012 458,825 1,433,562 1,040,620 - 3,651,450 28% Personnel 4,983,238 341,384 969,276 157,381 - 4,013,962 19% Supplies 276,861 27,095 76,797 61,010 44,643 155,421 44% Services 408,451 6,299 55,203 45,692 48,909 304,339 25% Debt Service 447,093 - 225,901 226,401 2,046 219,146 51% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,115,643 374,778 1,327,177 490,484 95,598 4,692,868 23% Net(1,030,631) 84,047 106,385 550,136 (95,598) (1,041,418) Cash Balance 2,349,917 3,430,318 Full Time 51.00 51.00 Part-Time /Seasonal/Temporary- - Total 51.00 51.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Emergency Medical Services Operating None Expenditures Revenue Total Expenditures Staffing 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. Form 370 Fund/Department Name Month March Fund/Department Number 600 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 1,399,400 96,016 320,567 362,375 - 1,078,833 23% Interest Earnings 5,000 1,217 5,093 1,078 - (93) 102% Bond Proceeds- - - - - - 0% Donations- - - 52 - - 0% Other Income 3,500 11,285 14,124 4,930 - (10,624) 404% Transfers In 2,110,068 - 527,517 665,786 - 1,582,551 25% Total Revenue 3,517,968 108,519 867,300 1,034,221 - 2,650,668 25% Personnel 2,862,499 199,378 614,370 584,509 501 2,247,628 21% Supplies 160,417 10,938 22,999 21,879 11,412 126,007 21% Services 1,311,150 61,981 179,062 128,693 224,524 907,564 31% Debt Service 46,623 4,615 11,885 7,816 1,674 33,064 29% Capital 70,285 - 30,608 - 39,677 0 100% Transfers Out- - - - - - 0% 4,450,974 276,911 858,924 742,896 277,786 3,314,263 26% Net(933,006) (168,393) 8,376 291,325 (277,786) (663,596) Cash Balance 1,904,738 1,026,094 Full Time 38.00 37.00 Part-Time /Seasonal/Temporary 1.00 1.00 Total 39.00 38.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Consolidated Building Fund Expenditures Revenue Total Expenditures Staffing 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 EDIT Fund to cover Code and Animal Control activities which, unlike the Consolidated Building Department, are not enterprises by nature. Form 371 Fund/Department Name Month March Fund/Department Number 601 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 1,048,226 89,907 263,793 234,596 - 784,433 25% Interest Earnings 4,000 364 1,687 1,558 - 2,313 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 3 - - 0% Transfers In- - - - - - 0% Total Revenue 1,052,226 90,272 265,480 236,157 - 786,746 25% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,141,933 111,888 229,526 214,086 603,018 309,389 73% Debt Service 250,000 - - - - 250,000 0% Capital 1,536 - - 52,838 1,536 (0) 100% Transfers Out- - - - - - 0% 1,393,469 111,888 229,526 266,924 604,555 559,389 60% Net(341,243) (21,616) 35,954 (30,766) (604,555) 227,358 Cash Balance 676,571 1,042,863 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Parking Garages Encumbrances cover study to determine improvements to be made $1,500,000 from Major Moves and additional $587,000 from TIF will be spent on necessary improvements in 2016 and 2017. Expenditures Revenue Total Expenditures Staffing Operations under outside contract with Downtown South Bend, Inc. so all expenses except capital are shown under Services line. Form 372 Fund/Department Name Month March Fund/Department Number 610 Date Updated 4/8/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 5,592,249 443,270 1,281,647 1,216,369 - 4,310,602 23% Interest Earnings 2,500 94 678 535 - 1,822 27% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 2,000 265 27,090 - - (25,090) 1354% Transfers In- - - - - - 0% Total Revenue 5,596,749 443,628 1,309,415 1,216,903 - 4,287,334 23% Personnel 1,725,395 111,712 352,436 403,241 1,500 1,371,459 21% Supplies 249,261 14,507 38,254 50,311 7,956 203,050 19% Services 2,697,559 238,541 741,220 662,891 676,099 1,280,240 53% Debt Service- - - - 0% Capital- - - - 0% Transfers Out 925,197 11,000 262,000 200,000 663,197 28% 5,597,412 375,760 1,393,911 1,316,442 685,556 3,517,946 37% Net(663) 67,869 (84,495) (99,539) (685,556) 769,388 Cash Balance 235,205 329,657 Full Time 26.20 24.20 24.20 Part-Time /Seasonal/Temporary- - - Total 26.20 24.20 24.20 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Solid Waste Operations Expenditures Revenue Total Expenditures Staffing This Enterprise Fund charges City residents a monthly fee to pick up and dispose of their trash at area landfills and recycling centers. The operations of Solid Waste are funded by these user fees. A non-budgeted rebate on CNG fuel was received in February, causing the large budget variance shown. Transfers out to Fund 611 are made to pay debt service obligations. Large encumbrances for landfill tipping fees make service expenses appear high. Form 373 Fund/Department Name Month March Fund/Department Number 611 Date Updated 4/8/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- 300,000 300,000 - - (300,000) 0% Charges for Services- - - - - - 0% Interest Earnings 200 0 36 34 - 164 18% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 925,197 11,000 262,000 200,000 - 663,197 28% Total Revenue 925,397 311,000 562,036 200,034 - 363,361 61% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 925,197 11,143 262,258 234,946 922 662,017 28% Capital- - - - - - 0% Transfers Out- - - - - - 0% 925,197 11,143 262,258 234,946 922 662,017 28% Net 200 299,857 299,778 (34,912) (922) (298,656) Cash Balance 300,221 288 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Solid Waste Capital Expenditures Revenue Total Expenditures Staffing 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, revenue for this fund typically comes from dollars transferred in from the Solid Waste Operations Fund #610 on an as needed basis. A State grant for $300,000 was received this month to help defray the cost of the ongoing upgrade of trash trucks from diesel to compressed natural gas fueled units. Form 374 Fund/Department Name Month March Fund/Department Number 620 Date Updated 4.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 14,423,116 1,115,553 3,275,335 3,161,675 - 11,147,781 23% Interest Earnings 26,000 1,882 9,534 5,987 - 16,466 37% Bond Proceeds- - - - - 0% Donations- - - - - 0% Other Income 123,500 113 2,523 4,830 - 120,977 2% Transfers In 31,500 4,336 7,596 3,719 - 23,904 24% Total Revenue 14,604,116 1,121,884 3,294,987 3,176,211 - 11,309,129 23% Personnel 5,440,741 401,527 1,205,673 1,213,884 3,282 4,231,787 22% Supplies 1,655,677 84,925 245,562 207,579 130,029 1,280,086 23% Services 5,352,541 280,928 984,880 918,458 608,082 3,759,579 30% Debt Service 119,687 1,166 7,491 2,021 3,176 109,020 9% Capital- - - - - 0% Transfers Out 4,416,011 340,484 1,248,914 1,146,704 - 3,167,097 28% 16,984,657 1,109,031 3,692,519 3,488,646 744,569 12,547,568 26% Net(2,380,541) 12,853 (397,532) (312,435) (744,569) (1,238,440) Cash Balance 3,589,005 4,159,137 Full Time 72.30 72.05 Part-Time /Seasonal/Temporary 6.30 2.50 Total 78.60 74.55 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Operations Expenditures Revenue Total Expenditures Staffing 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. Encumbered expenditures include previous year rollover and current year value orders. Form 375 Fund/Department Name Month March Fund/Department Number 622 Date Updated 4.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 15,000 1,599 7,422 4,556 - 7,578 49% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 15,000 1,599 7,422 4,556 - 7,578 49% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital 821,797 - - 86,334 177,797 644,000 22% Transfers Out- - - - - - 0% 821,797 - - 86,334 177,797 644,000 22% Net(806,797) 1,599 7,422 (81,778) (177,797) (636,422) Cash Balance 2,887,830 3,043,503 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Capital Encumb: Meter Reading Mobile Management Software (1) $18,188, Interactive Voice Response(IVR) System Upgrade (1) $15,000, and 3 1/2 Tn Utility Truck (1) $144,609 Expenditures Revenue Total Expenditures Staffing This fund is used for acquiring, constructing, and improving fixed assets. Investment income is greater than anticipated. Form 376 Fund/Department Name Month March Fund/Department Number 623 Date Updated 4.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- - - 283 - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 283 - - 0% Personnel- - - - - - 0% Supplies- - - 50,914 - - 0% Services- - - 2,171 - - 0% Debt Service- - - - - 0% Capital- - - 219 - - 0% Transfers Out- - - - - 0% - - - 53,304 - - 0% Net- - - (53,021) - - Cash Balance- 133,793 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Bond Capital Expenditures Revenue Total Expenditures Staffing 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, extension and improvements. Revenue bonds were issued in June 2012 with an aggregate principal of $8,300,000. The cash proceeds were fully expended at July 14, 2015. Form 377 Fund/Department Name Month March Fund/Department Number 624 Date Updated 4.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 8,400 840 3,895 2,157 - 4,505 46% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 8,400 840 3,895 2,157 - 4,505 46% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - 0% Transfers Out 8,400 840 1,927 1,302 - 6,473 23% 8,400 840 1,927 1,302 - 6,473 23% Net- - 1,968 855 - (1,968) Cash Balance 1,521,631 1,491,639 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Customer Deposit Expenditures Revenue Total Expenditures Staffing 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. Investment earning income is greater than anticipated. Form 378 Fund/Department Name Month March Fund/Department Number 625 Date Updated 4.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 3,600 159 730 553 - 2,870 20% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 2,046,081 170,505 511,515 510,825 - 1,534,566 25% Total Revenue 2,049,681 170,664 512,245 511,378 - 1,537,436 25% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 2,046,081 - - - - 2,046,081 0% Capital- - - - - - 0% Transfers Out 3,600 159 724 550 - 2,876 20% 2,049,681 159 724 550 - 2,048,957 0% Net- 170,505 511,521 510,828 - (511,521) Cash Balance 515,926 515,483 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Sinking Expenditures Revenue Total Expenditures Staffing 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. June's payment includes 50% of the annual interest and December's payment comprises the rest of the interest and all of the principal. Form 379 Fund/Department Name Month March Fund/Department Number 626 Date Updated 4.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 9,500 892 4,143 2,351 5,357 44% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 9,500 892 4,143 2,351 - 5,357 44% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 9,500 2,050 2,050 - - 7,450 22% 9,500 2,050 2,050 - - 7,450 22% Net- (1,158) 2,092 2,351 - (2,092) Cash Balance 1,641,654 1,649,028 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Bond Reserve Expenditures Revenue Total Expenditures Staffing 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. The 2016 annual maximum reserve requirement is satisfied. Form 380 Fund/Department Name Month March Fund/Department Number 629 Date Updated 4.11.16 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 10,000 1,287 5,800 3,070 - 4,200 58% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - 0% Transfers In 165,166 - 227,461 150,228 - (62,295) 138% Total Revenue 175,166 1,287 233,261 153,298 - (58,095) 133% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 10,000 1,287 2,894 1,866 - 7,106 29% 10,000 1,287 2,894 1,866 - 7,106 29% Net 165,166 - 230,367 151,432 - (65,201) Cash Balance 2,462,728 2,235,267 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Water Works Reserve Operations & Maintenance Expenditures Revenue Total Expenditures Staffing 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. Investment earning income is greater than anticipated. The Cash Balance of this fund is required to be equivalent to two months' worth of operating expenditures in Fund 620, excluding transfers. A Budget Transfer Form B was submitted to adjust Transfers Revenue. Form 381 Fund/Department Name Month March Fund/Department Number 640 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 561,225 51,161 155,101 152,762 406,124 28% Interest Earnings 3,500 936 4,281 2,209 (781) 122% Bond Proceeds- - 0% Donations- - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 564,725 52,097 159,382 154,971 - 405,343 28% Personnel 188,900 11,693 35,358 47,357 153,542 19% Supplies 41,569 7,946 9,596 3,653 10,904 21,069 49% Services 290,487 31,894 63,650 71,016 38,549 188,288 35% Debt Service 28,457 - 28,457 0% Capital- - 0% Transfers Out- - - - - - 0% 549,413 51,533 108,604 122,027 49,453 391,356 29% Net 15,312 564 50,778 32,944 (49,453) 13,987 Cash Balance 1,729,237 1,542,511 Full Time 2.20 1.85 - Part-Time /Seasonal/Temporary- - - Total 2.20 1.85 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewer Repair Insurance Expenditures Revenue Total Expenditures Staffing 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 maximum $500.00 deductible toward the cost of the repair and the city pays the rest. Form 382 Fund/Department Name Month March Fund/Department Number 641 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 36,538,600 3,151,663 9,122,245 8,377,809 - 27,416,355 25% Interest Earnings 65,000 5,268 24,650 13,174 - 40,350 38% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 92,000 865 5,280 10,981 - 86,720 6% Transfers In 16,000 2,265 4,911 - 11,089 31% Total Revenue 36,711,600 3,160,061 9,157,085 8,401,964 - 27,554,515 25% Personnel 7,573,583 518,341 1,585,273 1,866,242 783 5,987,527 21% Supplies 2,292,608 121,334 346,098 351,111 259,692 1,686,818 26% Services 16,901,880 850,901 2,629,589 2,461,222 2,533,172 11,739,119 31% Debt Service 678,685 25,598 216,113 158,959 2,994 459,578 32% Capital- - - - - 0% Transfers Out 12,289,388 760,893 3,179,403 2,576,695 9,109,985 26% 39,736,144 2,277,067 7,956,475 7,414,229 2,796,641 28,983,027 27% Net(3,024,544) 882,994 1,200,610 987,735 (2,796,641) (1,428,513) Cash Balance 10,304,091 10,132,344 Full Time 93.24 91.01 91.01 Part-Time /Seasonal/Temporary 11.44 8.67 8.67 Total 104.68 99.68 99.68 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Works Operations Capital spending for Sewage works is shown in Fund 642. Expenditures Revenue Total Expenditures Staffing This enterprise fund utilizes monthly fees received from residents and businesses to properly treat, transport, and dispose of generated sewage. Large encumbrances for supplies and services contribute to the higher percentage of budget used. Debt service payments are made in accordance with City amortization schedules. Form 383 Fund/Department Name Month March Fund/Department Number 642 Date Updated 4/7/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 45,000 4,485 22,105 5,512 - 22,895 49% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 2,487,000 - - - - 2,487,000 0% Total Revenue 2,532,000 4,485 22,105 5,512 - 2,509,895 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 14,858 - - 0% Debt Service- - - - - - 0% Capital 7,631,946 150,821 839,251 473,590 4,201,289 2,591,405 66% Transfers Out- - - - - - 0% 7,631,946 150,821 839,251 488,448 4,201,289 2,591,405 66% Net(5,099,946) (146,336) (817,146) (482,936) (4,201,289) (81,510) Cash Balance 7,937,184 3,268,786 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Works Capital Year to Date totals spent include: Final payment on completed Eastgate Lift Station replacement $34,647, Wastewater utility vehicle and plant maintenance equipment $24,113, Wastewater Treatment Plant Primary Clarifier Rehab $232,757, Wastewater Treatment Plant Secondary Improvements $71,365 and Digesters #1 & #3 Clean and Rehab $476,368. Expenditures Revenue Total Expenditures Staffing 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. Form 384 Fund/Department Name Month March Fund/Department Number 643 Date Updated 4/1/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 16,000 2,265 9,693 5,015 - 6,307 61% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 536,997 - 896,725 256,086 - (359,728) 167% Total Revenue 552,997 2,265 906,418 261,101 - (353,421) 164% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 16,000 2,265 4,911 3,040 - 11,089 31% 16,000 2,265 4,911 3,040 - 11,089 31% Net 536,997 - 901,507 258,061 - (364,510) Cash Balance 4,575,374 3,678,649 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Works Reserve Operations & Maint. Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to hold the equivalent of two months of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. A transfer was done in February to adjust the balance to stay in compliance. Form 385 Fund/Department Name Month March Fund/Department Number 649 Date Updated 4/4/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 7,000 1,071 3,397 1,712 - 3,603 49% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 9,267,391 760,893 2,282,678 2,320,609 - 6,984,713 25% Total Revenue 9,274,391 761,964 2,286,075 2,322,320 - 6,988,316 25% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 8,000 - 1,850 1,850 - 6,150 23% Debt Service 9,266,298 - - - - 9,266,298 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 9,274,298 - 1,850 1,850 - 9,272,448 0% Net 93 761,964 2,284,225 2,320,470 - (2,284,132) Cash Balance 3,088,965 3,110,807 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Sinking Expenditures Revenue Total Expenditures Staffing 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. Form 386 Fund/Department Name Month March Fund/Department Number 653 Date Updated 4/8/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 612 637 - - (637) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 612 637 - - (637) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- 612 637 - - (637) Cash Balance 4,106,261 7,286,832 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewage Debt Service Reserve Expenditures Revenue Total Expenditures Staffing This Debt Reserve fund is held in a separate account at Bank of NY Mellon Trust. The account was fully funded for existing debt in 2013. Due to the re-funding of three older Sewer Bonds in 2015, the required reserve now has a lower cash balance. A reconcilliation of this account is done monthly. Form 387 Fund/Department Name Month March Fund/Department Number 659 Date Updated 4/5/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 2,000 129 598 2,193 - 1,402 30% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,000 129 598 2,193 - 1,402 30% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 9,606 - - 7,198 9,606 - 100% Debt Service- - - - - - 0% Capital 162,482 - - 885,495 162,482 0 100% Transfers Out- - - - - - 0% 172,088 - - 892,692 172,088 0 100% Net(170,088) 129 598 (890,500) (172,088) 1,402 Cash Balance 232,492 708,886 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewer Bond 2011 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,438,816, Diamond Ave. Trunk Sewer, Phase III $248,000, St. Joseph River CSO Stabilization $217,831, Secondary Clarifier Upgrade $494,141, Wastewater Treatment Plant Digester Upgrade $5,782,989. Expenditures Revenue Total Expenditures Staffing This Sewage Works Revenue Bond closed in October of 2011. The remaining cash balance has been fully encumbered and is expected to be spent in 2016. The significant projects this bond has funded are listed below. Form 388 Fund/Department Name Month March Fund/Department Number 661 Date Updated 4/6/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 70,000 7,297 35,432 24,535 - 34,568 51% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - 0% Total Revenue 70,000 7,297 35,432 24,535 - 34,568 51% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 850,000 - - - - 850,000 0% Debt Service- - - - - - 0% Capital 19,337,062 445,588 1,707,327 522,432 11,258,241 6,371,494 67% Transfers Out- - - - - - 0% 20,187,062 445,588 1,707,327 522,432 11,258,241 7,221,494 64% Net(20,117,062) (438,291) (1,671,895) (497,897) (11,258,241) (7,186,926) Cash Balance 12,579,754 16,321,367 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Sewer Bond 2012 Since issue through 2015, projects funded from this Bond include: East Bank Sewer Separation-Phase 4 $2.6 million, Diamond Ave. Sewer Separation Phase 3, $2.6 million, Prairie Avenue Sewer Separation-Phase I $600,445, Southwood Sewer Separation $919,608, Fairfax Sewer $70,022, East Bank Sewer Separation-Phase 5 $574,681, Sewer Sensory Control Network $193,609, Wastewater Treatment Plant Grit/Screening Improvements $151,732, Secondary Clarifier Modifications $1,698,807, CSO LTCP re-look $1,626,327, and misc other $2,070. Expenditures Revenue Total Expenditures Staffing Current year spending from this Bond has been for the CSO LTCP re-look $313,349, East Bank Sewer Separation-Phase 5 $18,484, WWTP Secondary Clarifier Modifications $1,360,412, and WWTP Grit/Screening Improvements $15,082. Form 389 Fund/Department Name Month March Fund/Department Number 664 Date Updated 4/1/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 3 12 7 - (12) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 3 12 7 - (12) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net- 3 12 7 - (12) Cash Balance 4,518 4,487 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report 2013A Cost of Issuance Fund Expenditures Revenue Total Expenditures Staffing 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 to an appropriate fund, so this fund can be closed out. Form 390 Fund/Department Name Month March Fund/Department Number 666 Date Updated 4/1/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Acutal Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 4 85 - - (85) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- 4 85 - - (85) 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - 2,500 - - (2,500) 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - 2,500 - - (2,500) 0% Net- 4 (2,415) - - 2,415 Cash Balance 6,675 - Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report 2015 Sewer Bond Issuance Expenditures Revenue Total Expenditures Staffing This fund was set up to pay the legal and financial accounrting costs associated with the refunding of the 2006, 2007, and 2007B Sewer bonds. Most of those expenses were paid in December, 2015. A second quarter appropriation will be requested to cover the expenses that were not paid until this year. Form 391 Fund/Department Name Month March Fund/Department Number 670 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget 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 2,664,721 224,590 748,411 398,528 - 1,916,310 28% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 5,630 745 7,292 (35,618) - (1,662) 130% Transfers In- - - - - - 0% Total Revenue 3,983,787 225,335 1,412,428 1,019,635 - 2,571,359 35% Personnel 2,249,773 168,790 497,427 470,367 - 1,752,346 22% Supplies 473,779 49,678 151,593 88,278 - 322,186 32% Services 1,154,774 98,075 307,621 322,605 - 847,154 27% Debt Service- - - - - - 0% Capital 14,722 - - - - 14,722 0% Transfers Out 79,390 - - - - 79,390 0% 3,972,438 316,542 956,640 881,249 - 3,015,798 24% Net 11,349 (91,207) 455,788 138,386 - (444,439) Cash Balance 1,678,323 1,254,371 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Century Center Expenditures Revenue Total Expenditures Staffing 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. Although charges for services are down, personnel expenditures are also down as they are controlling their costs. Also, charges for services will likely stay low as the Century Center is going to begin many energy savings construction projects which is putting many of their rooms out of inventory for months at a time. However, the energy savings and their efforts to become more "green" will likely help attract future business. Form 392 Fund/Department Name Month March Fund/Department Number 671 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 500 85 249 68 - 251 50% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 500 85 249 68 - 251 50% Personnel- - - - - - 0% Supplies- - - 41,156 - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - 25,000 - - 0% Transfers Out- - - - - - 0% - - - 66,156 - - 0% Net 500 85 249 (66,088) - 251 Cash Balance 1,002,321 1,352,574 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Century Center Capital A Qualified Energy Conservation Bond was taken out in May 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 was seeded with a $50,000 transfer from this fund in May. Expenditures Revenue Total Expenditures Staffing 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. $50,000 was transferred out to the new fund 672 for bond payments on the Energy Savings Contract. Form 393 Fund/Department Name Month March Fund/Department Number 672 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 157,742 4 12 - - 157,730 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 79,390 - - - - 79,390 0% Total Revenue 237,132 4 12 - - 237,120 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service 237,132 - - - - 237,132 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 237,132 - - - - 237,132 0% Net- 4 12 - - (12) Cash Balance 50,044 - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Century Center Energy Conservation Debt Svc Expenditures Revenue Total Expenditures Staffing A Qualified Energy Conservation Bond was taken out in May 2015. The $50,000 was transferred from the capital fund to set up the fund for future bond payments. Form 394 Fund/Department Name Month March Fund/Department Number 222 Date Updated 4/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - 0% Charges for Services 8,181,507 637,778 1,864,688 2,042,329 - 6,316,819 23% Interest Earnings 3,240 556 2,935 1,916 - 305 91% Bond Proceeds- - 0% Donations- - 0% Other Income 49,890 577 4,327 9,912 - 45,563 9% Transfers In- - - - - - 0% Total Revenue 8,234,637 638,910 1,871,950 2,054,157 - 6,362,687 23% Personnel 3,143,175 203,970 612,139 705,905 2,531,036 19% Supplies 190,636 41,645 41,197 21,032 6,170 143,270 25% Services 4,812,674 400,789 1,167,230 1,264,127 2,518,794 1,126,650 77% Debt Service 12,475 1,325 2,273 630 10,520 16% Capital- - - 0% Transfers Out 130,519 - - - 130,519 0% 8,289,479 646,405 1,821,890 1,993,337 2,525,593 3,941,996 52% Net(54,842) (7,495) 50,059 60,820 (2,525,593) 2,420,692 Cash Balance 1,443,639 1,623,733 Full Time 42.00 37.00 37.00 Part-Time /Seasonal/Temporary 3.00 3.00 3.00 Total 45.00 40.00 40.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Central Services Expenditures Revenue Total Expenditures Staffing 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. In Mar we had 1,485 vehicle repairs. Average Fuel prices for March is $1.49 for Unleaded and $1.60 for Diesel. Budgeted amount per gallon is $3.20. The Radio Shop's project was the AVL installation of all new radios without loss of service to all departments. Equipment Services continues to purchase new vehicles with compressed natural gas or hybrids. Sustainability Office had no major expenditures. Due to slow hiring of replacement FTE, a temporary employee is working 20hrs/week. Job should be filled by April. Form 395 Fund/Department Name Month March Fund/Department Number 224 Date Updated 4/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings- 94 476 - - (476) 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In 130,519 - - 130,519 0% Total Revenue 130,519 94 476 - - 130,043 0% Personnel- - - - - - 0% Supplies 20,000 - - - - 20,000 0% Services 60,019 - - - - 60,019 0% Debt Service- - - - - 0% Capital 225,565 - 23,369 - 151,696 50,500 78% Transfers Out- - - - - - 0% 305,584 - 23,369 - 151,696 130,519 57% Net(175,065) 94 (22,893) - (151,696) (476) Cash Balance 164,026 - Full Time- - Part-Time /Seasonal/Temporary- - Total- - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Central Services Capital Capital projects for 2015 including a roof replacement for the Equipment Services building ($150,433), & Scanner/software for Inventory/fleet system for $24,632 encumbrances were carried over to 2016. The 2016 Capital projects are: Radio tower repairs, new overhead door for garage, paving of lot, CNG compressor maintenance costs, inground hoists, new pressure washer. Expenditures Revenue Total Expenditures Staffing This is a new fund for 2015. Revenues are a transfer from Central Services. Form 396 Fund/Department Name Month March Fund/Department Number 226 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 2,223,483 183,301 551,892 303,088 - 1,671,591 25% Interest Earnings 20,500 2,519 11,691 8,179 - 8,809 57% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 12,900 - 12,878 - - 22 100% Transfers In- - - - - - 0% Total Revenue 2,256,883 185,820 576,462 311,266 - 1,680,421 26% Personnel 250,135 16,000 48,005 67,351 - 202,130 19% Supplies 30,734 1,515 2,901 8,123 7,305 20,528 33% Services 2,839,479 83,705 384,401 574,371 84,298 2,370,780 17% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 3,120,348 101,220 435,308 649,845 91,603 2,593,437 17% Net(863,465) 84,601 141,154 (338,578) (91,603) (913,016) Cash Balance 4,666,614 5,341,496 Full Time 3.00 3.00 Part-Time /Seasonal/Temporary- - Total 3.00 3.00 - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Liability Insurance No capital expenditures are budgeted in 2016. Expenditures Revenue Total Expenditures Staffing This internal service fund handles operations relating to business insurance and claims--property, liability, workers compensation, etc.--and the operation of the Safety and Risk Department. Revenues for this fund come from other City funds who pay a share proportionate to their expected expense. Personnel expenditures are for 2 Safety and Risk personnel and an attorney who processes claims for the City. The City has budgeted $1 million in 2016 for expected liability cliams, $530,000 for excess coverage premiums for property insurance, and $852,000 in expected workers compensation activities. Miscellaneous income is slightly over budget due to a higher than expected reimbursement from a worker's compensation claim. The revenue budget will be adjusted in March. Form 397 Fund/Department Name Month March Fund/Department Number 278 Date Updated 4/11/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- 4,440 13,390 16,410 - (13,390) 0% Interest Earnings 4,000 363 1,660 758 - 2,340 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 60,400 4,440 13,390 16,410 - 47,010 22% Transfers In- - - - - - 0% Total Revenue 64,400 9,243 28,440 33,578 - 35,960 44% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 10,000 - 53 - - 9,947 1% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 10,000 - 53 - - 9,947 1% Net 54,400 9,243 28,387 33,578 - 26,013 Cash Balance 669,859 549,590 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Take Home Vehicle Police None Expenditures Revenue Total Expenditures Staffing This fund charges police officers for liability insurance and gasoline costs for take home police vehicles. The cash reserve in this fund has increased in recent years and is expected to increase during 2016. Claims have been minimal in this fund since it was created. This fund is classified as an Internal Service Fund for financial reporting. Revenue for 2016 is less than 2015 due to the timing of biweekly payroll. The revenue is the amount deducted from officer pay for the vehicle take home program. In 2015 there were seven payrolls paid through the end of March compared to six in 2016. Form 398 Fund/Department Name Month March Fund/Department Number 279 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- 0% Local Income Taxes- 0% Other Taxes- 0% Grants/Intergovernmental- 0% Charges for Services 499,358 39,960 117,939 381,419 24% Interest Earnings- 0% Bond Proceeds- 0% Donations- 0% Other Income- 0% Transfers In- 0% Total Revenue 499,358 39,960 117,939 - - 381,419 24% Personnel 459,575 36,460 110,716 348,859 24% Supplies 5,300 575 1,174 620 3,507 34% Services 34,482 3,105 6,229 4,806 23,447 32% Debt Service- 0% Capital- 0% Transfers Out- 0% 499,357 40,140 118,119 - 5,425 375,813 25% Net 1 (180) (180) - (5,425) 5,606 Cash Balance 200 - Full Time 6.00 6.00 Part-Time /Seasonal/Temporary 2.00 2.00 Total 8.00 8.00 Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report 311 Call Center No capital spending planned for 2016. Expenditures Revenue Total Expenditures Staffing This internal service fund is new in 2016. Expenses in previous years were charged to the General Fund. The fund is used to track operational revenues and expenditures of the 311 Call Center. Revenues are charges for services to the City departments that are served by the Call Center. The Call Center is still growing, so revenues will increase as more departments are served. Expenditures are predominantly related to salaries and benefits for the Call Center employees. Form 399 Fund/Department Name Month March Fund/Department Number 711 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 17,151,500 1,388,267 4,131,557 3,667,129 - 13,019,943 24% Interest Earnings 23,345 2,686 11,932 6,302 - 11,413 51% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - 756 19,399 - (756) 0% Transfers In- - - - - - 0% Total Revenue 17,174,845 1,390,952 4,144,244 3,692,829 - 13,030,601 24% Personnel 4,316 - - 2 - 4,316 0% Supplies 17,875 3,491 4,397 385 9,273 4,205 76% Services 1,415,949 250,952 516,691 205,399 708,688 190,570 87% Insurance 15,940,750 1,322,349 3,493,375 2,882,600 33,535 12,413,840 22% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 17,378,890 1,576,792 4,014,463 3,088,387 751,496 12,612,931 27% Net(204,045) (185,840) 129,782 604,443 (751,496) 417,669 Cash Balance 4,498,880 4,661,430 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Self-Funded Employee Benefits None Expenditures Revenue Total Expenditures Staffing 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 has been helping, although we are falling short of our revenue targets. Fortunately, claims costs have been lower than expected. A new Employee Wellness Center was opened on January 18, 2016 which is set in place with the understanding that the City should see a drop in claims expenses over time. Form 3100 Fund/Department Name Month March Fund/Department Number 713 Date Updated 4/14/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 105,682 1,164 2,903 25,420 - 102,779 3% Interest Earnings 1,600 147 690 349 - 910 43% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 107,282 1,311 3,593 25,770 - 103,689 3% Personnel 80,000 4,645 8,346 16,019 - 71,654 10% Supplies- - - - - - 0% Services 33,882 607 6,221 8,299 22,000 5,661 83% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 113,882 5,252 14,567 24,318 22,000 77,315 32% Net(6,600) (3,941) (10,974) 1,451 (22,000) 26,374 Cash Balance 258,308 242,622 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Unemployment Compensation None Expenditures Revenue Total Expenditures Staffing This fund charges an allocation of 0.25% of payroll to most departments to cover the cost of unemployment claims paid. 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. Form 3101 Fund/Department Name Month March Fund/Department Number 701 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 5,443,092 - - - - 5,443,092 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 4,500 - 1,061 872 - 3,439 24% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 5,447,592 - 1,061 872 - 5,446,531 0% Personnel 5,457,693 404,048 1,232,966 1,332,582 - 4,224,727 23% Supplies 200 - - - - 200 0% Services 6,950 3,125 3,398 202 - 3,552 49% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 5,464,843 407,173 1,236,364 1,332,784 - 4,228,479 23% Net(17,251) (407,173) (1,235,304) (1,331,913) - 1,218,053 Cash Balance(763,000) (692,785) Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Firefighters Pension No capital expenditures are purchased through this account. Expenditures Revenue Total Expenditures Staffing 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. Form 3102 Fund/Department Name Month March Fund/Department Number 702 Date Updated 4/8/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes 6,125,000 - - - - 6,125,000 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 4,500 311 2,773 1,547 - 1,727 62% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 4,000 - - - - 4,000 0% Transfers In- - - - - - 0% Total Revenue 6,133,500 311 2,773 1,547 - 6,130,727 0% Personnel 6,789,198 648,648 1,693,355 1,620,060 - 5,095,843 25% Supplies 800 - - - - 800 0% Services 7,400 3,097 3,291 98 - 4,109 44% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 6,797,398 651,745 1,696,646 1,620,158 - 5,100,752 25% Net(663,898) (651,434) (1,693,873) (1,618,611) - 1,029,975 Cash Balance(536,452) (507,841) Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Police Pension No capital expenditures are paid from this fund. Expenditures Revenue Total Expenditures Staffing 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 2016, the payments are expected to be $3,062,500 by 1 July and again by 1 October, totaling $6,125,000. Form 3103 Fund/Department Name Month March Fund/Department Number 730 Date Updated 4/12/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 150 16 74 41 - 76 49% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 150 16 74 41 - 76 49% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 20,000 - - - 20,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 20,000 - - - - 20,000 0% Net(19,850) 16 74 41 - (19,924) Cash Balance 28,615 28,419 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report City Cemetery Spending this year will concentrate on repairing headstones and completing the GIS survey of the cemetery and its occupants. Expenditures Revenue Total Expenditures Staffing 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. Form 3104 Fund/Department Name Month March Fund/Department Number 324 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 16,723,300 - - - - 16,723,300 0% Local Income Taxes- - - - - - 0% Other Taxes 396,000 - - - - 396,000 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - 10,176 - - 0% Interest Earnings 62,706 16,843 82,737 55,305 - (20,031) 132% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 1,692,308 73,645 107,417 1,542,997 - 1,584,891 6% Transfers In 11,000 1,538 3,534 4,954,476 - 7,467 32% Total Revenue 18,885,314 92,026 193,687 6,562,954 - 18,691,627 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 4,420,801 39,786 109,185 803,700 1,039,589 3,272,027 26% Debt Service 6,217,896 - 2,616,949 3,345,642 - 3,600,947 42% Capital 20,863,380 1,709,252 4,541,465 1,548,424 6,915,499 9,406,416 55% Transfers Out- - - - - - 0% 31,502,077 1,749,039 7,267,599 5,697,767 7,955,087 16,279,391 48% Net(12,616,763) (1,657,012) (7,073,911) 865,188 (7,955,087) 2,412,236 Cash Balance 27,328,950 32,245,781 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report River West Development Area (Airport TIF) In 2015, the major projects were: the Ameriplex lease, Bartlett Roundabout, Ignition Park infrastructure and Multi-tenant building, LaSalle Hotel, ND/GE Turbo Project, Nello, Noble Energy, Western Avenue Improvements, Patel Hotel, and Studebaker Envionmental and Renaissance District. Thus far in 2016, major expenditures (other than debt service) include: $1.1M for Ignition Park Infrastructure; $365K for LaSalle Hotel; $200K for Safe Routes to School @ Harrison School; $830K for Advanced Center for Cancer Care;$225K for Lippert; $1.2 for Nello. Expenditures Revenue Total Expenditures Staffing Form 3105 Fund/Department Name Month March Fund/Department Number 420 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget 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% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - 4,088,473 - - 0% - - - 4,088,473 - - 0% Net- - - (4,088,473) - - Cash Balance- - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Tax Incremental Financing (TIF) - Downtown Expenditures Revenue Total Expenditures Staffing In 2015 SBCDA is eliminated and all funds were distributed between Fund 324 River West and Fund 429 River East. This is the result of the TIF realignment. Form 3106 Fund/Department Name Month March Fund/Department Number 422 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 420,000 - - - - 420,000 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 4,000 836 3,865 1,680 - 135 97% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 424,000 836 3,865 1,680 - 420,135 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 43,166 3,461 6,827 22,950 10,339 26,000 40% Debt Service- - - - - - 0% Capital 1,360,200 - - - 300,000 1,060,200 22% Transfers Out- - - - - - 0% 1,403,366 3,461 6,827 22,950 310,339 1,086,200 23% Net(979,366) (2,625) (2,962) (21,270) (310,339) (666,065) Cash Balance 1,503,862 1,174,479 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - West Washington Major projects committed thus far in 2016 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. Expenditures Revenue Total Expenditures Staffing Major Projects committed thus far in 2016 are: City Cemetery Project. Form 3107 Fund/Department Name Month March Fund/Department Number 425 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,006 92 425 147 - 581 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income 170,997 13,482 35,301 41,092 - 135,696 21% Transfers In- - - - - - 0% Total Revenue 172,003 13,574 35,726 41,239 - 136,277 21% Personnel- - - - - - 0% Supplies 8,742 688 1,148 1,764 - 7,594 13% Services 151,664 5,968 14,838 32,608 - 136,826 10% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 160,406 6,656 15,986 34,372 - 144,420 10% Net 11,597 6,918 19,740 6,867 - (8,143) Cash Balance 228,557 179,394 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Redevelopment Retail & Leighton Plaza Expenditures Revenue Total Expenditures Staffing Operations under outside contract with Bradley Co. Form 3108 Fund/Department Name Month March Fund/Department Number 426 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget 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% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - 2,294,533 - - 0% - - - 2,294,533 - - 0% Net- - - (2,294,533) - - Cash Balance- - Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - Central Medical Service Area Expenditures Revenue Total Expenditures Staffing In 2015 Central Medical Service Area is eliminated and all funds were distributed to Fund 324 River West. This is the result of the TIF realignment. Form 3109 Fund/Department Name Month March Fund/Department Number 429 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 2,750,000 - - - - 2,750,000 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 7,000 4,151 19,395 7,886 - (12,395) 277% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - 19,357 - - 0% Transfers In- - - 1,430,965 - - 0% Total Revenue 2,757,000 4,151 19,395 1,458,209 - 2,737,605 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 82,873 950 30,950 35,090 52,622 (699) 101% Debt Service- - - - - - 0% Capital 8,252,286 11,286 66,897 82,866 3,970,946 4,214,442 49% Transfers Out- - - - - - 0% 8,335,159 12,236 97,847 117,956 4,023,568 4,213,744 49% Net(5,578,159) (8,085) (78,453) 1,340,253 (4,023,568) (1,476,138) Cash Balance 7,482,679 5,896,732 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report River East Development Area (NE Dev TIF) Projects committed to in 2015 include: 5 Points Utility Study, Hill Street Improvements and the NW Corner of Hill & Colfax. Expenditures Revenue Total Expenditures Staffing Due to changes in boundary, this area now includes a portion of South Bend Central Development Area (Fund 420). Form 3110 Fund/Department Name Month March Fund/Department Number 430 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget 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 33,000 3,363 15,537 6,758 - 17,463 47% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 2,433,000 3,363 15,537 6,758 - 2,417,463 1% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 528,454 142,010 294,460 78,739 118,512 115,482 78% Debt Service- - - - - - 0% Capital 6,883,361 765 2,565 443,483 4,251,719 2,629,077 62% Transfers Out- - - - - - 0% 7,411,815 142,775 297,025 522,222 4,370,230 2,744,560 63% Net(4,978,815) (139,412) (281,488) (515,463) (4,370,230) (327,097) Cash Balance 5,827,126 4,441,828 Full Time- - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - Southside Development #1 Projects committed to in 2015 include: Chippewa Improvements, Fellows Street Corridor, Ireland & Miami Area Improvements, Ireland Road Acquisition Services, Main-Lafayette Crossover Connector and Safe Routes to School (Perley). The major project expected in 2016 is the construction of the Chippewa Roundabout. Expenditures Revenue Total Expenditures Staffing Form 3111 Fund/Department Name Month March Fund/Department Number 435 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 320,000 - - - - 320,000 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 750 28 317 232 - 433 42% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 320,750 28 317 232 - 320,433 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 13,012 - - - 4,200 8,812 32% Debt Service 341,188 - 140,000 169,620 - 201,188 41% Capital- - - - - - 0% Transfers Out- - - - - - 0% 354,200 - 140,000 169,620 4,200 210,000 41% Net(33,450) 28 (139,683) (169,388) (4,200) 110,433 Cash Balance 11,983 52,042 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - Douglas Road Expenditures Revenue Total Expenditures Staffing 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. Form 3112 Fund/Department Name Month March Fund/Department Number 436 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes 2,948,923 - - - - 2,948,923 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services 210,999 - 210,999 - - (0) 100% Interest Earnings 2,500 - 2,109 1,571 - 391 84% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 3,162,422 - 213,108 1,571 - 2,949,314 7% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 61,818 - - - - 61,818 0% Debt Service 3,368,182 - 1,684,089 1,710,589 - 1,684,093 50% Capital- - - - - - 0% Transfers Out- - - - - - 0% 3,430,000 - 1,684,089 1,710,589 - 1,745,911 49% Net(267,578) - (1,470,981) (1,709,018) - 1,203,403 Cash Balance 149,037 (3,515) Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report River East Residential (NE Res TIF) Expenditures Revenue Total Expenditures Staffing Debt Service is related to the Eddy Street Commons Project--payment on the ESC Bonds and reimbursement to Major Moves fund for project costs. Form 3113 Fund/Department Name Month March Fund/Department Number 433 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 152 5 22 15 - 130 14% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 152 5 22 15 - 130 14% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 4,500 - - - - 4,500 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 4,500 - - - - 4,500 0% Net(4,348) 5 22 15 - (4,370) Cash Balance 8,724 10,105 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Redevelopment General Expenditures Revenue Total Expenditures Staffing This fund's sole expenditure is for general legal fees for DCI based on an engagement letter Form 3114 Fund/Department Name Month March Fund/Department Number 439 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 14,637 1,262 5,887 7,309 - 8,750 40% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 14,637 1,262 5,887 7,309 - 8,750 40% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 198 - - 0% Debt Service- - - - - - 0% Capital 2,692,913 142,913 142,913 - - 2,550,000 5% Transfers Out- - - - - - 0% 2,692,913 142,913 142,913 198 - 2,550,000 5% Net(2,678,276) (141,651) (137,026) 7,112 - (2,541,250) Cash Balance 2,279,193 5,027,672 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Certified Technology Park Capital funds are to be expended in Ignition Park and Innovation Park. Expenditures Revenue Total Expenditures Staffing Form 3115 Fund/Department Name Month March Fund/Department Number 454 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,500 211 978 550 - 522 65% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,500 211 978 550 - 522 65% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 50,000 - - - - 50,000 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% 50,000 - - - - 50,000 0% Net(48,500) 211 978 550 - (49,478) Cash Balance 380,599 377,990 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Airport Urban Enterprise Zone Expenditures Revenue Total Expenditures Staffing No significant issues. Possible expenditure for job training in Urban Enterprise Zone. Form 3116 Fund/Department Name Month March Fund/Department Number 619 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - 119,238 - - 0% Interest Earnings- - - - - - 0% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue- - - 119,238 - - 0% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - 181,258 - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - 181,258 - - 0% Net- - - (62,020) - - Cash Balance- 19,911 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Blackthorn Operations Equipment payments Expenditures Revenue Total Expenditures Staffing The course has been sold to a private owner. The sale was completed in February 2015. Form 3117 Fund/Department Name Month March Fund/Department Number 315 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 5,000 576 2,674 1,511 - 2,326 53% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 5,000 576 2,674 1,511 - 2,326 53% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 5,000 576 1,323 912 - 3,677 26% 5,000 576 1,323 912 - 3,677 26% Net- - 1,351 599 - (1,351) Cash Balance 1,038,904 1,038,904 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Total Expenditures Staffing 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. 2016 City of South Bend Monthly Financial Report Redevelopment Bond - Airport Taxable Expenditures Revenue Form 3118 Fund/Department Name Month March Fund/Department Number 317 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 1,800 282 1,309 735 - 491 73% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 1,800 282 1,309 735 - 491 73% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out- - - - - - 0% - - - - - - 0% Net 1,800 282 1,309 735 - 491 Cash Balance 509,128 505,638 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report Coveleski Debt Service Reserve Expenditures Revenue Total Expenditures Staffing 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. Form 3119 Fund/Department Name Month March Fund/Department Number 328 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 6,000 962 4,467 2,525 - 1,533 74% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 6,000 962 4,467 2,525 - 1,533 74% Personnel- - - - - - 0% Supplies- - - - - - 0% Services- - - - - - 0% Debt Service- - - - - - 0% Capital- - - - - - 0% Transfers Out 6,000 962 2,211 1,524 - 3,789 37% 6,000 962 2,211 1,524 - 3,789 37% Net- - 2,257 1,002 - (2,257) Cash Balance 1,735,840 1,735,840 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: Total Expenditures Staffing 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 (324 - River West). Any variance in the trend of interest income will be due to changes in City prevailing interest rates City is able to secure. 2016 City of South Bend Monthly Financial Report Redevelopment Bond - Palais Royale Expenditures Revenue Form 3120 Fund/Department Name Month March Fund/Department Number 432 Date Updated 4/13/2016 Current Current Current Prior Amended Month Year to Date Year to Date Current Budget Percent of Budget Actual Actual Actual Encumbrances Balance Budget Property Taxes- - - - - - 0% Local Income Taxes- - - - - - 0% Other Taxes- - - - - - 0% Grants/Intergovernmental- - - - - - 0% Charges for Services- - - - - - 0% Interest Earnings 25,000 2,741 13,344 8,481 - 11,656 53% Bond Proceeds- - - - - - 0% Donations- - - - - - 0% Other Income- - - - - - 0% Transfers In- - - - - - 0% Total Revenue 25,000 2,741 13,344 8,481 - 11,656 53% Personnel- - - - - - 0% Supplies- - - - - - 0% Services 1,000 - - 201,724 - 1,000 0% Debt Service 489,503 - 365,835 357,545 - 123,668 75% Capital- - - - - - 0% Transfers Out- - - - - - 0% 490,503 - 365,835 559,269 - 124,668 75% Net(465,503) 2,741 (352,491) (550,789) - (113,012) Cash Balance 4,949,904 5,952,067 Full Time- - - Part-Time /Seasonal/Temporary- - - Total- - - Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: Explain Significant Spending on Capital Projects Below: 2016 City of South Bend Monthly Financial Report TIF - Southside Development #3 Expenditures Revenue Total Expenditures Staffing The purpose of this fund is to pay debt service. 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. $201,724 payment in 2015 is return of prior year taxes to St. Joseph County. Form 3121