Loading...
HomeMy WebLinkAbout2018 General Fund - Budget Summary & NaviLine Revenue DetailCity of South Bend, Indiana 2018 Budget Fund 101 - General Fund Fund Type General Fund Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Property Taxes 37,349,388 39,362,139 39,599,000 21,820,143 39,246,940 39,654,000 37,716,000 38,093,160 38,474,092 (352,060) -1% Other Taxes 4,267,822 4,287,027 4,229,000 1,843,873 4,229,000 5,710,300 5,746,964 5,184,994 5,251,295 - 0% Grants/Intergovernmental 649,515 331,625 - - 144,614 - - - - 144,614 - Licenses & Permits 152,245 189,840 218,121 163,945 230,510 212,616 214,232 215,858 217,496 12,389 6% Charges for Services 622,779 912,074 833,718 376,360 933,677 977,738 1,013,300 1,048,862 1,084,425 99,959 12% Fines, Forfeitures, and Fees 14,111 14,712 5,596 3,855 8,920 9,009 9,099 9,190 9,281 3,324 59% Interest Earnings 106,341 227,436 220,000 111,857 240,000 242,400 244,824 247,272 249,745 20,000 9% Donations 330,444 330,000 337,500 - 337,500 340,800 344,133 347,499 350,899 - 0% Other Income 10,226,972 10,815,999 13,748,081 6,362,540 14,222,014 14,438,543 14,653,916 14,872,640 15,100,778 473,933 3% Transfers In - 3,673 - - 413,714 417,851 422,030 426,250 430,513 413,714 - Total Revenue 53,719,617 56,474,525 59,191,016 30,682,573 60,006,889 62,003,257 60,364,498 60,445,725 61,168,524 815,873 1% Expenditures by Dept 101-0101 Mayor's Office 735,186 679,425 872,923 375,390 907,840 927,222 948,182 967,334 988,083 34,917 4% 101-0104 311 Call Center 464,074 3,810 - - - - - - - - - 101-0201 City Clerk 367,924 375,011 536,216 231,163 544,147 553,111 563,324 573,807 584,568 7,931 1% 101-0301 Common Council 443,552 481,078 571,148 224,138 614,969 629,051 645,508 658,353 673,596 43,821 8% 101-0302 WNIT Contract 43,000 43,000 43,000 43,000 43,000 43,000 43,000 - - - 0% 101-0401 Admin & Finance 1,813,202 1,988,015 2,476,351 1,216,850 2,619,796 2,670,658 2,728,859 2,786,087 2,848,646 143,445 6% 101-0404 Morris PAC 1,005,106 993,017 1,271,039 395,796 1,318,518 1,344,889 1,371,787 1,399,222 1,427,207 47,479 4% 101-0405 Palais Royale 432,526 427,468 530,200 123,415 539,364 559,532 570,178 556,036 567,111 9,164 2% 101-0501 Legal Dept 944,507 976,457 1,158,567 563,766 1,200,797 1,219,877 1,247,216 1,275,242 1,303,973 42,230 4% 101-0602 Engineering Dept 936,645 1,015,087 1,445,157 572,895 1,590,505 1,601,114 1,616,853 1,634,476 1,652,215 145,348 10% 101-0801 Police Dept 25,106,271 24,901,731 29,668,433 13,523,691 28,823,330 29,933,164 30,467,414 30,967,145 31,476,812 (845,103) -3% 101-0802 Communications Ctr 1,681,568 1,479,012 - - - - - - - - - 101-0901 Fire Dept 17,642,922 18,567,501 21,111,466 10,068,020 21,268,390 22,141,197 22,540,309 22,957,402 23,372,638 156,924 1% 101-1008 Human Rights 371,743 349,157 425,805 214,469 447,100 456,162 465,947 476,032 486,419 21,295 5% 101-1201 Code Enforcement - 202,504 - - - - - - - - - Total Expenditures 51,988,226 52,482,273 60,110,305 27,552,593 59,917,756 62,078,977 63,208,575 64,251,136 65,381,267 (192,549) 0% Expenditures by Type Personnel Salaries & Wages 32,773,335 32,038,277 33,377,962 15,832,324 34,689,543 35,381,845 36,087,992 36,808,263 37,542,939 1,311,581 4% Fringe Benefits 12,024,323 12,819,190 14,084,778 6,353,620 14,104,744 14,401,286 14,711,411 15,028,711 15,353,362 19,966 0% Total Personnel 44,797,658 44,857,467 47,462,740 22,185,945 48,794,287 49,783,131 50,799,404 51,836,974 52,896,301 1,331,547 3% Supplies 739,700 724,727 1,827,013 312,600 826,693 948,683 951,834 952,720 952,860 (1,000,320) -55% Services & Charges Professional Services 2,641,666 2,431,027 1,201,082 461,784 999,777 1,013,431 1,021,204 991,922 996,289 (201,305) -17% Printing & Advertising 130,935 125,953 348,243 31,574 313,662 316,828 321,195 325,765 330,641 (34,581) -10% Utilities 601,732 570,536 600,693 289,144 647,250 655,495 661,720 665,840 670,042 46,557 8% Education & Training 100,492 124,042 134,340 54,357 134,410 132,298 134,398 132,500 132,604 70 0% Travel 85,316 72,559 84,187 25,664 78,840 79,123 79,410 79,700 79,996 (5,347) -6% Repairs & Maintenance 1,717,018 1,631,005 1,896,816 903,173 1,423,649 1,447,743 1,459,145 1,467,660 1,476,347 (473,167) -25% Other Interfund Allocations 404,091 478,562 4,284,905 2,142,462 5,063,218 5,157,773 5,229,175 5,276,742 5,325,261 778,313 18% Debt Service Principal 21,193 28,425 105,010 87,848 451,761 448,336 447,626 438,626 433,916 346,751 330% Interest & Fees 4,039 4,075 10,649 7,383 1,978 810 371 92 40 (8,671) -81% Grants & Subsidies 21,139 3,525 40,000 1,200 40,000 40,800 41,208 41,208 41,208 - 0% Insurance 59,892 881,712 1,667,596 833,790 670,112 1,578,046 1,581,880 1,585,731 1,589,599 (997,484) -60% Transfers Out - 202,504 - - - - - - - - - Other Services & Charges 640,876 346,154 447,031 215,669 457,119 451,481 455,007 455,656 456,164 10,088 2% Total Services & Charges 6,428,389 6,900,079 10,820,552 5,054,049 10,281,776 11,322,163 11,432,338 11,461,441 11,532,106 (538,776) -5% Capital 22,479 - - - 15,000 25,000 25,000 - - 15,000 - Total Expenditures 51,988,226 52,482,273 60,110,305 27,552,593 59,917,756 62,078,977 63,208,575 64,251,136 65,381,267 (192,549) 0% Net Surplus / (Deficit) 1,731,391 3,992,252 (919,289) 3,129,980 89,133 (75,720) (2,844,077) (3,805,410) (4,212,743) Beginning Cash Balance 28,637,082 30,399,044 34,363,151 33,443,862 33,532,994 33,457,274 30,613,197 26,807,787 Cash Reserve Cash Adjustments 30,571 (28,145) - - - - - - Ending Cash Balance 30,399,044 34,363,151 33,443,862 33,532,994 33,457,274 30,613,197 26,807,787 22,595,044 Cash Reserves Target 12,997,057 15,744,683 21,038,607 20,971,215 21,727,642 22,123,001 22,487,898 22,883,443 Fund Purpose: 35% of Annual expenditures The General Fund is the primary operating fund for City operations including general government, public safety, certain culture and recreation expenses, and certain debt service obligations. The main source of revenue is property taxes. 1 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueGENERAL FUND101-0000-311.00-00 GENERAL PROPERTY TAX 37,349,388 39,362,139 39,188,000 39,599,000 21,820,143 21,820,143 39,246,940LEVEL TEXTTEXT AMT02 2018 PROPERTY TAX ESTIMATE PER UMBAUGH REPORT39,246,940AND BASED ON JUNE 2017 TAX COLLECTIONS THATWERE HIGHER THAN ANTICIPATED39,246,940------------ ------------ ------------ ------------ ------------ ------------ ------------*37,349,388 39,362,139 39,188,000 39,599,000 21,820,143 21,820,143 39,246,940101-0000-312.02-00 AUTO EXCISE2,564,703 2,652,855 2,600,000 2,600,000 1,341,923 1,341,923 2,600,000LEVEL TEXTTEXT AMT02 ESTIMATE BASED ON TRENDS2,600,0002,600,000101-0000-312.03-00 COMMERCIAL VEHICLE TAX758,554 675,904 675,000 675,000 320,412 320,412 675,000LEVEL TEXTTEXT AMT02 ESTIMATE BASED ON TRENDS675,000675,000------------ ------------ ------------ ------------ ------------ ------------ ------------*3,323,257 3,328,759 3,275,000 3,275,000 1,662,335 1,662,335 3,275,000101-0000-321.01-00 CARNIVALS & CIRCUSES00011511500101-0000-321.02-00 SELF-SERVE LAUNDRY2,048 1,920 1,800 1,817 1,817 1,812 1,800LEVEL TEXTTEXT AMT02 2018 ESTIMATE1,8001,800101-0000-321.03-00 MASSAGE ESTABLISHMENT2,370 1,635 1,600 1,600 1,440 1,435 1,400LEVEL TEXTTEXT AMT02 2018 ESTIMATE1,4001,400101-0000-321.03-10 MASSAGE TECHNICIAN1,488 1,478 1,300 1,685 1,685 1,600 1,300LEVEL TEXTTEXT AMT02 2018 ESTIMATE1,3001,300101-0000-321.05-00 RUBBISH/GARBAGE REMOVAL6,883 7,301 6,600 7,456 7,456 7,456 7,300LEVEL TEXTTEXT AMTFund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm2 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue02 2018 ESTIMATE7,3007,300101-0000-321.08-00 JUNK/ SCRAP DEALER3,050 3,310 3,100 3,100 2,555 2,300 3,100LEVEL TEXTTEXT AMT02 2018 ESTIMATE - CITY CLERK3,1003,100101-0000-321.09-00 PUBLIC PARKING FACILITY624781600704704704700LEVEL TEXTTEXT AMT02 2018 ESTIMATE700700101-0000-321.10-00 SECOND-HAND DEALERS4,456 4,027 3,000 3,175 3,175 2,928 3,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE3,0003,000101-0000-321.11-10 PEDDLERS/CANVASSERS2,325 1,010 1,000 1,000745525700LEVEL TEXTTEXT AMT02 2018 ESTIMATE700700101-0000-321.12-00 TRANSIENT MERCHANT985570600755755755700LEVEL TEXTTEXT AMT02 2018 ESTIMATE700700101-0000-321.13-00 PET SHOPS5802900159159159200LEVEL TEXTTEXT AMT02 2018 ESTIMATE200200101-0000-321.14-00 RESTAURANT39,628 40,355 38,000 40,071 40,698 39,753 40,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE40,00040,000101-0000-321.14-02 FOOD TRUCK LICENSE0 2,120 1,500 3,710 3,600 3,710 2,000LEVEL TEXTTEXT AMTFund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm3 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue02 2018 ESTIMATE2,0002,000101-0000-321.17-00 FOOD VENDING MACHINES3,085 5,584 5,000 5,615 5,615 5,615 5,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE5,0005,000101-0000-321.18-00 AUTOM. REPAIR & SERV. CTR 19,465 17,845 16,500 17,370 17,375 16,950 16,500LEVEL TEXTTEXT AMT02 2018 ESTIMATE16,50016,500101-0000-321.19-00 VEHICLE REMOVAL SERVICE935990900900785785780LEVEL TEXTTEXT AMT02 2018 ESTIMATE780780101-0000-321.20-00 FOOD VENDING VEHICLE647712800800433433400LEVEL TEXTTEXT AMT02 2018 ESTIMATE400400101-0000-321.21-00 HOTEL & MOTEL1,710 1,662 1,600 1,810 1,810 1,710 1,600LEVEL TEXTTEXT AMT02 2018 ESTIMATE1,6001,600101-0000-321.22-00 OPEN AIR BUSINESS2,755 1,550 1,500 1,778 1,783 1,768 1,500LEVEL TEXTTEXT AMT02 2018 ESTIMATE1,5001,500101-0000-321.23-00 PRECIOUS METALS DEALER568568600600568568600LEVEL TEXTTEXT AMT02 2018 ESTIMATE600600101-0000-321.24-00 CHARITABLE SOLICITATION660705500500260260300LEVEL TEXTTEXT AMTFund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm4 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue02 2018 ESTIMATE300300101-0000-321.25-00 ARBORIST/TREE SERVICE3,655 3,838 3,400 3,690 3,689 3,530 3,400LEVEL TEXTTEXT AMT02 2018 ESTIMATE3,4003,400101-0000-321.27-00 ADULT BUSINESS2,020 2,020 2,000 2,020 2,020 2,020 2,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE2,0002,000101-0000-321.29-00 TATTOO & PIERCING EST.155155150410410410150LEVEL TEXTTEXT AMT02 2018 ESTIMATE150150101-0000-321.29-10 TATTOO & PIERCING PERSONL468480480965965965480LEVEL TEXTTEXT AMT02 2018 ESTIMATE480480101-0000-321.31-00 ALARM AGENTS5,986 5,733 5,300 5,416 5,416 5,416 5,300LEVEL TEXTTEXT AMT02 2018 ESTIMATE5,3005,300101-0000-321.32-10 LAWN PARKING UNDER 103,586 2,842 3,600 3,600 2,2850 2,800LEVEL TEXTTEXT AMT02 CITY CLERK - 2018 ESTIMATE2,8002,800101-0000-321.32-20 LAWN PARKING OVER 107,333 7,578 7,300 7,300 6,5520 7,500LEVEL TEXTTEXT AMT02 CITY CLERK - 2018 ESTIMATE7,5007,500------------ ------------ ------------ ------------ ------------ ------------ ------------*117,465 117,059 108,730 118,121 114,870 103,565 110,510Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm5 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0000-322.10-00 ENGINEERING34,780 37,19800000------------ ------------ ------------ ------------ ------------ ------------ ------------*34,780 37,19800000101-0000-331.02-00 PUBLIC SAFETY649,515 331,625 265,0000000------------ ------------ ------------ ------------ ------------ ------------ ------------*649,515 331,625 265,0000000101-0000-335.01-00 LIQUOR EXCISE TAX DIST. 64,350 74,432 75,000 75,000 71,082 42,158 75,000LEVEL TEXTTEXT AMT02 ESTIMATE BASED ON HISTORICAL TRENDS75,00075,000101-0000-335.02-00 LIQUOR GALLONAGE TAX DIST 211,919 214,542 210,000 210,000 163,691 107,554 210,000LEVEL TEXTTEXT AMT02 ABC GALLONAGE DISTRIBUTION FROM STATE. ESTIMATE210,000PER TRENDS210,000101-0000-335.03-00 CIGAR. TAX DIST. GEN. FD 69,269 70,289 70,000 70,000 31,826 31,826 70,000LEVEL TEXTTEXT AMT02 CIGARETTE TAX DISTRIBUTION PAID BY STATE.70,000PER CAPITA FORMULA. ESTIMATE PER TRENDS70,000101-0000-335.12-00 RIVERBOAT GAMING REVENUE 599,027 599,005 599,000 599,00000 599,000LEVEL TEXTTEXT AMT02 RIVERBOAT WAGERING TAX REVENUE SHARING599,000ESTIMATED - PER CAPITA FORMULAHB 1350 PASSED IN 2017 ELIMINATED GAMING REVENUETO SOUTH BEND AS OF JUNE 30, 2020599,000------------ ------------ ------------ ------------ ------------ ------------ ------------*944,565 958,268 954,000 954,000 266,599 181,538 954,000101-0000-338.00-00 PILOT TRANSFERS IN4,282,212 4,620,384 6,208,321 6,208,321 4,138,888 3,104,166 6,332,487LEVEL TEXTTEXT AMT02 2018 WATER & WASTEWATER PILOT ALLOCATIONIN 2017, ALL PILOT IS TRANSFERRED TO GENERAL FUNDFROM FUND 620-0640-658.60-03 WATER1,730,831FROM FUND 641-0630-793.60-03 WASTEWATER4,601,6566,332,487Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm6 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue------------ ------------ ------------ ------------ ------------ ------------ ------------*4,282,212 4,620,384 6,208,321 6,208,321 4,138,888 3,104,166 6,332,487101-0000-341.01-00 PLAN COMMISSION CHARGES9,565 6,132 7,000 7,000 3,251 2,451 6,100101-0000-341.03-00 COPIES OF PUBLIC RECORDS16151919165------------ ------------ ------------ ------------ ------------ ------------ ------------*9,581 6,133 7,005 7,019 3,270 2,467 6,105101-0000-344.30-00 ENVIRONMENTAL CLEANUP7,198- 30000000------------ ------------ ------------ ------------ ------------ ------------ ------------*7,198- 30000000101-0000-351.02-00 CITY FEES0 5,25620200020LEVEL TEXTTEXT AMT02 ESTIMATED2020101-0000-351.04-00 BAD CHECKS FINES18590400400213163400101-0000-351.07-00 CURFEW VIOLATION21321350050013888500101-0000-351.30-00 MISC COLLECTIONS REVENUE1,18725900000------------ ------------ ------------ ------------ ------------ ------------ ------------*1,585 5,818920920351250920101-0000-354.00-00 ORDINANCE VIOLATION12,526 8,8940 4,676 5,995 3,605 8,000LEVEL TEXTTEXT AMT02 BASED ON PRIOR YEAR COLLECTIONS8,0008,000------------ ------------ ------------ ------------ ------------ ------------ ------------*12,526 8,8940 4,676 5,995 3,605 8,000101-0000-360.00-00 MISCELLANEOUS REVENUE8,340 1,164 1,000 1,291 1,290 1,198 1,000101-0000-360.01-00 MUNICIPAL CODE SUPPLEMENT505 1,529 1,000 1,000832658 1,000101-0000-360.80-00 CURB PGM. RESIDENT SHARE1,648175 1,000 1,000150100200LEVEL TEXTTEXT AMT02 GOOD NEIGHBORS PROGRAM ELIMINATED - FORMER200PARTICIPANTS WITH PAYMENT ARRANGEMENTS MONITOREDBY THE CITY ATTORNEY'S OFFICE200101-0000-360.85-00 CURB LOAN RECEIPTS32,964-000000LEVEL TEXTTEXT AMT02 CURB PROGRAM DISCONTINUED BUT RESIDENTS ARE PAYINGFund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm7 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueON EXISTING ACCOUNTS.------------ ------------ ------------ ------------ ------------ ------------ ------------*22,471- 2,868 3,000 3,291 2,272 1,956 2,200101-0000-361.00-00 INTEREST EARNINGS106,341 227,436 180,000 220,000 188,121 111,857 240,000LEVEL TEXTTEXT AMT02 ADJUST INTEREST EARNINGS TO RECENT TRENDS240,000INTEREST EARNINGS MAY IMPROVE WITH THE NEWINVESTMENT PROGRAM ADMINISTERED BY 1ST SOURCE240,000------------ ------------ ------------ ------------ ------------ ------------ ------------*106,341 227,436 180,000 220,000 188,121 111,857 240,000101-0000-364.00-00 CABLE T.V. FRANCHISE723,676 749,565 748,000 748,000 388,077 192,238 768,000LEVEL TEXTTEXT AMT02 PAID QUARTERLY, ESTIMATED BASED ON TRENDS.768,000COMCAST PAYMENTS768,000------------ ------------ ------------ ------------ ------------ ------------ ------------*723,676 749,565 748,000 748,000 388,077 192,238 768,000101-0000-366.00-00 AT&T FRANCHISE FEES281,873 256,611 284,000 284,000 156,394 107,643 215,000LEVEL TEXTTEXT AMT02 PAID QUARTERLY, ESTIMATED BASED ON RECENT TRENDS215,000AT&T.215,000------------ ------------ ------------ ------------ ------------ ------------ ------------*281,873 256,611 284,000 284,000 156,394 107,643 215,000101-0000-367.30-00 NOTRE DAME CONTRIBUTION 330,000 330,000 330,000 330,000 330,0000 330,000LEVEL TEXTTEXT AMT02 NOTRE DAME ANNUAL CONTRIBUTION - STARTED IN330,0002009.TENYEARS-2009TO2018PLEDGED AMOUNTS - 2009 TO 2013 - $275,0002014 TO 2018 - $330,000TEN YEAR TOTAL - $3.025 MILLIONANNUAL PAYMENT USUALLY RECEIVED IN JULY OR AUGUST330,000------------ ------------ ------------ ------------ ------------ ------------ ------------*330,000 330,000 330,000 330,000 330,0000 330,000Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm8 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0000-380.10-99 MISC. REIMBURSEMENTS233 7,365 1,000 2,459 2,459 2,459 1,000LEVEL TEXTTEXT AMT02 ESTIMATE BASED ON HISTORICAL TRENDS1,0001,000------------ ------------ ------------ ------------ ------------ ------------ ------------*233 7,365 1,000 2,459 2,459 2,459 1,000101-0000-392.00-00 INTERFUND OPER. TRANSFER0 3,6730000 413,714LEVEL TEXTTEXT AMT02 TRANSFER FROM HEALTH INSURANCE FUND 711 - REBATE413,714FOR LOW HISTORICAL CLAIMS BY POLICE DEPTEMPOYEES PER THE GIBSON ANALYIS413,714101-0000-392.04-00 ADMINISTRATIVE COST3,642,955 3,824,590 4,977,026 4,977,026 3,317,984 2,488,488 5,454,725LEVEL TEXTTEXT AMT02 2018 ADMINISTRATIVE FEE ALLOCATION5,454,725RECAPTURE OF ADMIN/FINANCE/LEGAL BUDGET FROMALL FUNDS WITH EMPLOYEES - COVERS 100%OF ESTIMATED COSTS FOR MAYOR'SOFFICE, CITY CLERK, COMMON COUNCIL, ADMINISTAND FINANCE AND LEGAL COSTS5,454,725------------ ------------ ------------ ------------ ------------ ------------ ------------*3,642,955 3,828,263 4,977,026 4,977,026 3,317,984 2,488,488 5,868,439------------ ------------ ------------ ------------ ------------ ------------ ------------** GENERAL FUND51,780,283 54,178,685 56,530,002 56,731,833 32,397,758 29,782,710 57,358,601Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm9 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0101-347.01-86 SALE OF MERCHANDISE901601001007070100LEVEL TEXTTEXT AMT02 EST FOR SALE OF SHIRTS100100------------ ------------ ------------ ------------ ------------ ------------ ------------*901601001007070100101-0101-360.00-00 MISCELLANEOUS REVENUE045000000------------ ------------ ------------ ------------ ------------ ------------ ------------*045000000101-0101-367.20-00 DONATED SALARY65000000------------ ------------ ------------ ------------ ------------ ------------ ------------*65000000101-0101-380.10-99 MISC. REIMBURSEMENTS230500500000------------ ------------ ------------ ------------ ------------ ------------ ------------*230500500000------------ ------------ ------------ ------------ ------------ ------------ ------------** MAYOR1786106006007070100Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm10 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0104-380.10-99 MISC. REIMBURSEMENTS464,072 3,81000000LEVEL TEXTTEXT AMT02 311 IN A SEPARATE INTERNAL SERVICE FUND FOR 2016------------ ------------ ------------ ------------ ------------ ------------ ------------*464,072 3,81000000------------ ------------ ------------ ------------ ------------ ------------ ------------** 311 CALL CENTER464,072 3,81000000Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm11 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0301-367.20-00 DONATED SALARY379000000------------ ------------ ------------ ------------ ------------ ------------ ------------*379000000101-0301-380.10-16 TRAVEL REIMBURSEMENTS200000000------------ ------------ ------------ ------------ ------------ ------------ ------------*200000000------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMON COUNCIL579000000Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm12 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0401-360.00-00 MISCELLANEOUS REVENUE336000000101-0401-360.87-00 P-CARD COMMISSIONS0 13,548 12,000 12,254 12,254 12,254 12,000LEVEL TEXTTEXT AMT02 P-CARD COMMISSION TO BE REC'D IN 2018 BASED ON12,0002017 PURCHASES - 1% OF TOTAL SPEND FOR 201712,000------------ ------------ ------------ ------------ ------------ ------------ ------------*336 13,548 12,000 12,254 12,254 12,254 12,000101-0401-380.10-62 OFFICE MAX REBATE61253600000101-0401-380.10-99 MISC. REIMBURSEMENTS220 2,61550508850------------ ------------ ------------ ------------ ------------ ------------ ------------*832 3,15150508850------------ ------------ ------------ ------------ ------------ ------------ ------------** CONTROLLER1,168 16,699 12,050 12,304 12,262 12,262 12,050Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm13 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0404-360.00-00 MISCELLANEOUS REVENUE29,130 34,941 30,000 30,000 27,994 26,308 30,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS REVENUES FROM THE BOX OFFICE ACC.30,0002018 ESTIMATE30,000101-0404-360.12-00 ROOM RENTAL129,681 230,822 175,000 175,000 80,246 79,396 225,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE225,000225,000101-0404-360.13-00 EQUIPMENT RENTAL4,215 3,228 6,000 6,000 3,225 2,550 3,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE3,0003,000101-0404-360.15-00 BOX OFFICE COMMISSIONS37,108 68,064 40,000 40,000 33,106 28,225 45,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE45,00045,000101-0404-360.16-00 TICKET HANDLING FEES279,073 580,345 285,000 285,000 154,860 154,860 350,000LEVEL TEXTTEXT AMT02 TICKET HANDLING FEES PHONE / INTERNET350,0002018 ESTIMATE350,000101-0404-360.17-00 MERCHANDISE SALES9,184 28,266 15,000 25,000 20,011 8,382 25,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE25,00025,000101-0404-360.18-00 CONCESSION67,051 96,319 85,000 85,000 62,228 50,256 100,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE100,000100,000101-0404-360.19-00 FACILITY FEE136,415 252,979 197,000 197,000 127,681 112,354 187,500LEVEL TEXTTEXT AMT02 2018 ESTIMATE312,500Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm14 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue312,500101-0404-360.21-00 CREDIT CARD FEES20,090 50,000 50,000 50,000 25,388 25,388 50,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE50,00050,000101-0404-360.22-00 SECURITY8,569 10,872 10,000 10,000 6,751 5,230 11,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE11,00011,000101-0404-360.23-00 MPAC STAGE MANAGER23,460 32,183 30,000 30,000 18,045 15,885 32,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE32,00032,000101-0404-360.25-00 THEATRE SEATING LEASING 30,000 30,000 35,000 35,00000 35,000LEVEL TEXTTEXT AMT02 2018 ESTIMATED35,00035,000101-0404-360.51-00 INSURANCE REIMBURSEMENT000 1,645 1,645 1,6450------------ ------------ ------------ ------------ ------------ ------------ ------------*773,976 1,418,019 958,000 969,645 561,180 510,478 1,093,500101-0404-380.10-99 MISC. REIMBURSEMENTS5,213 7,623 7,000 7,000 5,509 4,499 7,500LEVEL TEXTTEXT AMT02 2018 ESTIMATE7,5007,500------------ ------------ ------------ ------------ ------------ ------------ ------------*5,213 7,623 7,000 7,000 5,509 4,499 7,500------------ ------------ ------------ ------------ ------------ ------------ ------------** MORRIS PAC779,189 1,425,642 965,000 976,645 566,689 514,976 1,101,000Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm15 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0405-360.00-00 MISCELLANEOUS REVENUE13,145 9,123 7,000 7,000 1,9250 4,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE4,000SMALL COMEDY EVENT, ETC.4,000101-0405-360.12-00 ROOM RENTAL41,310 28,917 49,572 49,572 26,785 19,622 49,572LEVEL TEXTTEXT AMT02 2018 ESTIMATE49,572RENTAL OF THE RETAIL SPACE49,572101-0405-360.18-00 CONCESSION169,967 197,548 200,000 200,000 127,262 64,274 250,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE250,000INCREASE IN CATERING SALES PROJECTED FOR 2018250,000101-0405-360.20-01 COMMON AREA PROPERTY TAX0006006700------------ ------------ ------------ ------------ ------------ ------------ ------------*224,422 235,588 256,572 257,172 156,039 83,896 303,572101-0405-362.02-00 BALLROOM RENTAL61,968 71,010 82,500 82,500 52,756 31,257 75,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE75,000WR, LUNCHEONS, HOLIDAY PARTIES, NFPAVERAGE OF 50 EVENTS AT $1,500.0075,000------------ ------------ ------------ ------------ ------------ ------------ ------------*61,968 71,010 82,500 82,500 52,756 31,257 75,000101-0405-380.10-99 MISC. REIMBURSEMENTS18,532 20,087 19,830 19,830 14,522 7,824 20,400LEVEL TEXTTEXT AMT02 2% ON $750,000 OF CATERING SALES15,000MISC. REIMBURSEMENTS-DUMPSTER4,200MISC. REIMBURSEMENTS-PHONE, EMAIL, ETC.1,2002018 ESTIMATE20,400------------ ------------ ------------ ------------ ------------ ------------ ------------*18,532 20,087 19,830 19,830 14,522 7,824 20,400Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm16 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue------------ ------------ ------------ ------------ ------------ ------------ ------------** PALAIS ROYALE BALLROOM304,922 326,685 358,902 359,502 223,317 122,977 398,972Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm17 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0501-360.00-00 MISCELLANEOUS REVENUE500000000101-0501-360.90-00 SETTLEMENT FEES0 1,73300000------------ ------------ ------------ ------------ ------------ ------------ ------------*5001,73300000101-0501-380.10-99 MISC. REIMBURSEMENTS57,588 74,753 75,377 75,377 56,225 37,350 76,885LEVEL TEXTTEXT AMT02 REIMBURSEMENT FOR LEGAL SERVICES - TIF DOLLARS76,88576,885------------ ------------ ------------ ------------ ------------ ------------ ------------*57,588 74,753 75,377 75,377 56,225 37,350 76,885------------ ------------ ------------ ------------ ------------ ------------ ------------** LEGAL DEPARTMENT58,088 76,486 75,377 75,377 56,225 37,350 76,885Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm18 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0602-322.10-00 ENGINEERING0 35,583 100,000 100,000 73,250 60,380 120,000LEVEL TEXTTEXT AMT02 ENGINEERING REVENUE: PERMITS120,000120,000101-0602-322.10-10 SPECIFICATIONS0 3,0000 6,127 6,252 5,802 12,000LEVEL TEXTTEXT AMT02 ENGINEERING: SPECIFICATIONS12,00012,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 38,583 100,000 106,127 79,502 66,182 132,000101-0602-360.00-00 MISCELLANEOUS REVENUE4,299 4,817 10,000 10,000725400 6,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS ENGINEERING REIMBURSEMENTS, 20186,0006,000------------ ------------ ------------ ------------ ------------ ------------ ------------*4,299 4,817 10,000 10,000725400 6,000101-0602-380.10-19 BLUEPRINTS/COPIES451001000050LEVEL TEXTTEXT AMT02 BLUEPRINTS, COPIES, 20185050101-0602-380.10-22 STATE PROJECTS00 3,000 3,000000101-0602-380.10-99 MISC. REIMBURSEMENTS2,555 34,434 204,237 204,237610 214,117LEVEL TEXTTEXT AMT02 RIVER WEST TIF REIMB OF ENGINEER I78,320REDEVELOPMENT ENGINEER 100% TIF FUNDED135,797PER THE ENGINEERING SERVICES AGREEMENT214,117------------ ------------ ------------ ------------ ------------ ------------ ------------*2,559 34,439 207,337 207,337610 214,167------------ ------------ ------------ ------------ ------------ ------------ ------------** ENGINEERING6,858 77,839 317,337 323,464 80,288 66,582 352,167Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm19 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0801-342.51-00 EVENT FEES759000000------------ ------------ ------------ ------------ ------------ ------------ ------------*759000000101-0801-360.00-00 MISCELLANEOUS REVENUE18,900 30,83700 56,44200101-0801-360.51-00 INSURANCE REIMBURSEMENT 40,651 49,1060 22,337 33,036 19,653 40,000------------ ------------ ------------ ------------ ------------ ------------ ------------*59,551 79,9430 22,337 89,478 19,653 40,000101-0801-362.00-00 RENTAL OF PROPERTY47,919 56,788 48,000 48,000 7,238 7,238 48,000------------ ------------ ------------ ------------ ------------ ------------ ------------*47,919 56,788 48,000 48,000 7,238 7,238 48,000101-0801-367.30-00 NOTRE DAME CONTRIBUTION00 7,500 7,50000 7,500LEVEL TEXTTEXT AMT02 FIREARMS TRAINING OF ND OFFICERS7,5007,500------------ ------------ ------------ ------------ ------------ ------------ ------------*00 7,500 7,50000 7,500101-0801-380.10-83 INSURANCE CLAIM000 8,365000101-0801-380.10-96 REPAIR REIMBURSEMENTS.5,142404 40,000 40,0001201000LEVEL TEXTTEXT AMT02 CAR REPAIR REIMBURSEMENTS FROM CLAIMS FILED40,00040,000101-0801-380.10-97 SALARY/OVERTIME188,483 216,217 230,000 536,405 140,337 73,505 464,500LEVEL TEXTTEXT AMT02 OPERATION PULL-OVER (GRANT)/SEAT BELT ENFORCEMENT50,000DUI PATROLS (GRANT)20,000DANGEROUS DRIVING (GRANT)10,000ATF REIMBURSE (2) (DEPT OF JUSTICE)25,000DEA REIMBURSE (2) (DEPT OF JUSTICE)US MARSHAL REIMBURSE (DEPT OF JUSTICE)7,500SPECIAL EVENTS/PARADES/VIP SECURITY20,000HUD PATROLS (ECONOMIC DEVELOPMENT)SCHOOL RESOURCE OFFICER PROGRAM - SB COMM. SCHOOLS 332,000464,500101-0801-380.10-99 MISC. REIMBURSEMENTS13,481 1,946 1,000 5,801 7,359 2,777 1,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS REIMBURSEMENTS1,0001,000Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm20 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue------------ ------------ ------------ ------------ ------------ ------------ ------------*207,106 218,567 271,000 590,571 147,816 76,382 465,500------------ ------------ ------------ ------------ ------------ ------------ ------------** POLICE DEPARTMENT315,335 355,298 326,500 668,408 244,532 103,273 561,000Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm21 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-0901-331.10-94 FIRE OFFICER SAFER GRANT000000 144,614LEVEL TEXTTEXT AMT02 STAFFING FOR ADEQUATE FIRE & EMERGENCY RESPONSE144,614(SAFER) GRANT. GRANT FOR SALARIES AND BENEFITSOF THREE FIREFIGHTERS FOR THREE YEARS. 2018-2020TOTAL OF $356,714 FOR THE THREE YEARS.YEAR 1 - $144,614, YEAR 2 - $144,614, YEAR 3 -$67,486.144,614------------ ------------ ------------ ------------ ------------ ------------ ------------*000000 144,614101-0901-340.20-00 NEO NATAL REVENUE97000000101-0901-340.23-00 MISCELLANEOUS CHARGES62523950050000500LEVEL TEXTTEXT AMT02 CPR COURSES,MISC REVENUE500500------------ ------------ ------------ ------------ ------------ ------------ ------------*72223950050000500101-0901-360.00-00 MISCELLANEOUS REVENUE29315009900101-0901-360.51-00 INSURANCE REIMBURSEMENT5,081 9,4850 37,987 37,987 37,9870------------ ------------ ------------ ------------ ------------ ------------ ------------*5,374 9,6350 37,996 37,996 37,9870101-0901-380.10-99 MISC. REIMBURSEMENTS3,725 9,584 1,000 4,387 4,387 4,387 1,000LEVEL TEXTTEXT AMT02 REIMBURSEMENTS AND REFUNDS1,0001,000------------ ------------ ------------ ------------ ------------ ------------ ------------*3,725 9,584 1,000 4,387 4,387 4,387 1,000------------ ------------ ------------ ------------ ------------ ------------ ------------** FIRE DEPT9,821 19,458 1,500 42,883 42,383 42,373 146,114Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm22 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue101-1205-349.09-00 DEMOLITION AND BOARDING876- 6,687-00000------------ ------------ ------------ ------------ ------------ ------------ ------------*876- 6,687-00000------------ ------------ ------------ ------------ ------------ ------------ ------------** UNSAFE BUILDING876- 6,687-00000------------ ------------ ------------ ------------ ------------ ------------ ------------*** GENERAL FUND53,719,617 56,474,525 58,587,268 59,191,016 33,623,524 30,682,573 60,006,889Fund 101 - General FundCity of South BendRevenue10/09/17, 1:49pm23