Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Session I - Public Works (3) Financials - Solid Waste & ReLeaf
City of South Bend, Indiana 2018 Budget Fund 610 - Solid Waste Operations Fund Type Enterprise 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 Charges for Services 5,003,799 5,511,281 5,746,175 2,625,349 5,347,191 5,347,191 5,347,191 5,347,191 5,347,191 (398,984) -7% Interest Earnings 2,162 3,096 2,500 1,885 2,800 2,500 2,500 2,500 2,500 300 12% Other Income 361,072 50,678 50,800 51,000 124,200 56,200 151,200 56,200 56,200 73,400 144% Transfers In - - - - - - - - - - - Total Revenue 5,367,033 5,565,055 5,799,475 2,678,234 5,474,191 5,405,891 5,500,891 5,405,891 5,405,891 (325,284) -6% Expenditures by Type Personnel Salaries & Wages 1,204,219 1,070,937 1,148,826 531,184 1,112,889 1,124,659 1,136,834 1,152,156 1,167,577 (35,937) -3% Fringe Benefits 451,964 458,405 632,296 289,541 608,180 638,509 672,020 708,559 747,821 (24,116) -4% Total Personnel 1,656,183 1,529,342 1,781,122 820,724 1,721,069 1,763,168 1,808,854 1,860,715 1,915,398 (60,053) -3% Supplies 283,987 309,671 187,532 114,016 373,700 240,232 246,309 252,567 259,014 186,168 99% Services & Charges Professional Services 824,308 774,231 893,856 193,592 171,435 174,007 177,487 181,036 184,657 (722,421) -81% Printing & Advertising 1,025 37 250 43 250 250 250 250 250 - 0% Utilities - - 6,900 - - - - - - (6,900) -100% Education & Training - 4,101 10,000 2,245 10,000 10,000 10,000 10,000 10,000 - 0% Travel 118,832 1,371 4,900 1,520 9,900 9,900 9,900 9,900 9,900 5,000 102% Repairs & Maintenance 720,468 756,162 662,538 362,460 661,500 642,250 643,038 643,864 644,733 (1,038) 0% Other Interfund Allocations 142,879 390,777 361,114 181,842 573,717 583,401 595,069 606,971 619,110 212,603 59% Debt Service Principal 49,000 9,700 9,700 - - - - - - (9,700) -100% Interest & Fees - - - - - - - - - - - Insurance 98,664 100,476 76,404 38,202 105,956 107,545 109,696 111,890 114,128 29,552 39% Transfers Out 659,600 925,000 835,613 493,600 1,076,706 1,113,809 1,106,897 808,845 584,393 241,093 29% Other Services & Charges 915,270 848,840 832,981 401,344 749,400 749,900 750,405 750,915 751,430 (83,581) -10% Total Services & Charges 3,530,046 3,810,695 3,694,256 1,674,848 3,358,864 3,391,062 3,402,742 3,123,671 2,918,601 (335,392) -9% Capital - - - - - - - - - - - Total Expenditures 5,470,216 5,649,708 5,662,910 2,609,589 5,453,633 5,394,462 5,457,905 5,236,953 5,093,013 (209,277) -4% Net Surplus / (Deficit)(103,183) (84,653) 136,565 68,645 20,558 11,429 42,986 168,938 312,878 Beginning Cash Balance 405,863 318,912 193,005 329,570 350,128 361,557 404,543 573,481 Cash Reserve Cash Adjustments 16,232 (41,254) - - - - - - Ending Cash Balance 318,912 193,005 329,570 350,128 361,557 404,543 573,481 886,359 Cash Reserves Target 547,022 564,971 566,291 545,363 539,446 545,791 523,695 509,301 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 10% of Annual expenditures This fund accounts for the operations of the Solid Waste Department. It is funded by charging City residents a monthly fee for pick-up and disposal of trash at area landfills and recycling centers. Funds are transferred out to the Solid Waste Capital Fund #611 for the payment of debt service obligations as needed. Decrease in budgeted revenue is mainly due to the fact that Recycling fees are now on residents' property tax bills instead of being collected by Solid Waste and then paid to Solid Waste Management District. 104 City of South Bend, Indiana 2018 Budget Fund 610 - Solid Waste Operations Accomplishments, Goals, KPI's 2017 Accomplishments & Outcomes - - - - -Increased efficiencies in extra pick ups by 33% - - - - - 2018 Department Goals & Objectives and Linkage to City Results - - - - - - - - - - - - - - - - Key Performance Indicators (KPI's) Measure Type Long Term Goal 2016 Actual 2017 Estimated 2018 Target -Efficiency 381 296 250 -Quality 43 66 70 -Efficiency 1788 2000 1248 -Efficiency 1377 1246 750 -Effectiveness 47 24 15 - - Types: output, efficiency, effectiveness, quality, outcome, technology 2018 Significant Changes/Challenges/Opportunities - - - - - - - - - - Reduce complaints Increase customer satisfaction Reduce missed Trash collection. Create a positive work environment where all can thrive Reduce missed Yard Waste collection. Reduce accidents Repurpose Picker I's to Drivers and Container positions, reducing Teamsters by 3 Complete alley to curbside transition Reduced complaints by 45% Reduced yard waste misses by 4% Increased customer satisfaction by 53% Successfully moved 12,590 alley to curbside collection to date Implemented the ELEMOS RFID program Recovered $151,077.44 per year in inaccurate billing Excellent Services and Efficient Processes - Improve customer service Excellent Services and Efficient Processes - Improve route efficiency with the utilization of Route Planner Effective, Responsive Leadership and Communication - Create education programs for public awareness Excellent Services and Efficient Processes - Complete alley to curbside transition Excellent Services and Efficient Processes - Offer new container cleaning program 105 City of South Bend, Indiana 2018 Budget Fund 610 - Solid Waste Operations Staffing (Full-Time Employees only) 2017 2018 2016 Amended 06/30/17 Proposed Forecast Position (* New title or additional position)Actual Budget Actual Budget 2019 2020 2021 2022 Non-Bargaining Manager - Solid Waste Operations 1.0 - - - - - - - Superintendent V - Route Manager*1.0 1.0 1.0 2.0 2.0 2.0 2.0 2.0 Administrative Assistant I 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Secretary V 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director - Solid Waste Operations - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Total Non-Bargaining 4.0 4.0 4.0 5.0 5.0 5.0 5.0 5.0 Bargaining Driver 16.0 16.0 16.0 15.0 15.0 15.0 15.0 15.0 Picker I 5.0 5.0 5.0 2.0 2.0 2.0 2.0 2.0 Job Leader*1.0 1.0 1.0 2.0 2.0 2.0 2.0 2.0 Total Bargaining 22.0 22.0 22.0 19.0 19.0 19.0 19.0 19.0 Total Full-Time Employees 26.0 26.0 26.0 24.0 24.0 24.0 24.0 24.0 Explain Significant Staffing Changes Below: - Reduced Picker I's by 3 - Created one additional Job Leader position - Created one additional Superintendent V- Route Manager position 106 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSOLID WASTE FUND610-0000-344.08-10 RESIDENTIAL TRASH3,504,548 3,865,414 4,073,354 4,073,354 2,593,414 2,074,709 4,393,207LEVEL TEXTTEXT AMT02 $12.48 PER MONTH (12 X 12.48 X~28,858)IN LIMITS4,321,774$16.22 PER MONTH (12 X 16.22 X 367) OUTSIDE LIMITS71,4334,393,207610-0000-344.08-11 RECYCLING FEE769,733 771,662 772,000 772,000 73,458 73,4510LEVEL TEXTTEXT AMT02 FEE FORMERLY BILLED BY CITY TO RESIDENTS.WILL BE ON PROPERTY TAX BILLS IN 2018.610-0000-344.08-20 COMMERCIAL70,444 81,368 88,367 88,367 55,109 44,363 94,984LEVEL TEXTTEXT AMT02 $16.22 PER MONTH (12 X $16.22 X ~488)94,98494,984610-0000-344.08-30APARTMENTS-2UNITS38,816 41,408 46,263 46,263 25,282 21,077 42,271LEVEL TEXTTEXT AMT02 $19.57 PER MONTH (12 X $19.57 X ~180)42,27142,271610-0000-344.08-40APARTMENTS-3UNITS18,125 19,162 21,755 21,755 12,560 10,206 21,115LEVEL TEXTTEXT AMT02 $26.66 PER MONTH (12 X $26.66 X ~66)21,11521,115610-0000-344.08-45APARTMENTS-4UNITS18,207 21,911 23,497 23,497 14,471 11,876 25,117LEVEL TEXTTEXT AMT02 $33.76 PER MONTH (12 X $33.76 X ~62)25,11725,117610-0000-344.08-50 SENIORS387,880 415,857 435,939 435,939 261,594 213,776 340,891LEVEL TEXTTEXT AMT02 $7.49 PER MONTH (12 X $7.49 X ~3719)IN LIMITS334,264$9.36 PER MONTH (12 X $9.36 X ~59)OUTSIDE LIMITS6,627340,891610-0000-344.08-60 SPECIAL PICK-UPS52,150 69,807 75,000 75,000 31,680 24,605 70,000LEVEL TEXTTEXT AMT02 ONE FREE ITEM PER RESIDENT PICKED UP AND DISPOSEDFund 610 - Solid Waste Operations & MaintenanceCity of South BendRevenue107 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenuePER MONTH, THEREAFTER, $24.72 PER CUBIC YARD70,00070,000610-0000-344.08-65 YARD WASTE EXTRA PICKUPS00 100,000 100,0009010 5,000LEVEL TEXTTEXT AMT02 FORMERLY POSTED TO MISCELLANEOUS REVENUE5,0005,000------------ ------------ ------------ ------------ ------------ ------------ ------------*4,859,903 5,286,589 5,636,175 5,636,175 3,067,658 2,474,073 4,992,585610-0000-346.08-10 MISC SERVICE REVENUE143,896 213,872 22,635 22,635 14,301 12,463 1,200LEVEL TEXTTEXT AMT02 START-UP OF $10.00, BASED ON HISTORICAL RECEIPTS1,2001,200610-0000-346.08-20 ADDITIONAL TRASH TOTES00 35,000 35,000 67,795 52,481 129,406LEVEL TEXTTEXT AMT02 REVENUE FORMERLY POSTED TO MISCELLANEOUS129,406129,406610-0000-346.08-30 YARD WASTE TOTES0 10,820 52,365 52,365 130,408 86,332 224,000LEVEL TEXTTEXT AMT02 ALL YARD WASTE PICK UPS MUST BE IN TOTES224,000EST 14,500 TOTES @ $16.00 RENTAL FEE224,000------------ ------------ ------------ ------------ ------------ ------------ ------------*143,896 224,692 110,000 110,000 212,504 151,276 354,606610-0000-360.00-00 MISCELLANEOUS REVENUE491 1,037 2,000 2,650 2,850 2,850 1,200LEVEL TEXTTEXT AMT02 ESTIMATED SALE OF SCRAP METAL1,2001,200610-0000-360.51-00 INSURANCE REIMBURSEMENT3,089000000------------ ------------ ------------ ------------ ------------ ------------ ------------*3,580 1,037 2,000 2,650 2,850 2,850 1,200610-0000-361.00-00 INTEREST EARNINGS2,162 3,096 2,500 2,500 2,627 1,885 2,800LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST EARNED ON CASH RESERVES2,800Fund 610 - Solid Waste Operations & MaintenanceCity of South BendRevenue108 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue2,800------------ ------------ ------------ ------------ ------------ ------------ ------------*2,162 3,096 2,500 2,500 2,627 1,885 2,800610-0000-380.10-90 CODE REIMBURSEMENT344,740000000LEVEL TEXTTEXT AMT02 ELIMINATED IN 2016610-0000-380.10-99 MISC. REIMBURSEMENTS12,752 26,825 32,000 48,150 48,150 48,150 48,000LEVEL TEXTTEXT AMT02 CNG FUEL REBATE FOR ESTIMATED 96,000 GALLONS48,000PURCHASED X $.50 PER GALLON REBATE48,000------------ ------------ ------------ ------------ ------------ ------------ ------------*357,492 26,825 32,000 48,150 48,150 48,150 48,000610-0000-391.01-00 SALE OF FIXED ASSETS0 22,8160000 75,000LEVEL TEXTTEXT AMT02 EXPECT TO SELL SEVERAL UNITS AT CITY AUCTION75,00075,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 22,8160000 75,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SOLID WASTE FUND5,367,033 5,565,055 5,782,675 5,799,475 3,333,789 2,678,234 5,474,191------------ ------------ ------------ ------------ ------------ ------------ ------------*** SOLID WASTE FUND5,367,033 5,565,055 5,782,675 5,799,475 3,333,789 2,678,234 5,474,191Fund 610 - Solid Waste Operations & MaintenanceCity of South BendRevenue109 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSOLID WASTE FUND610-0610-791.10-01 REGULAR WAGES186,956 186,590 202,853 202,853 112,898 97,089 267,032LEVEL TEXTTEXT AMT02 1 FTE DIRECTOR-SOLID WASTE OPERATIONS70,0001 FTE ADMINISTRATIVE ASSISTANT40,5251 FTE SECRETARY V34,0822 FTE SUPERINTENDENT-ROUTE MGR. V @ 57,565 EA115,130.12 FTE PUBLIC WORKS DIRECTOR14,342.12 FTE DEPUTY PUBLIC WORKS DIRECTOR11,690SALARY ALLOWANCE18,737-TOTAL 5.24 FTE267,032610-0610-791.10-02 HOURLY WAGES614,345 756,390 838,573 838,573 458,681 400,214 741,957LEVEL TEXTTEXT AMT02 15 DRIVERS @ (15 X 18.47 X 2080)576,265EQUIPMENT PROFICIENCY BONUS (8 X .50 X 2080)8,3202 PICKER @ (2 X 17.64 X 2080)73,3822 JOB LEADERS @ (2 X 19.47 X 2080)83,99019 FTE741,957610-0610-791.10-03 SEASONAL & INTERNS126,285 19,21300000LEVEL TEXTTEXT AMT02 DISCONTINUED USE OF TEMPS. ADDED 5 PICKER 1 FTE610-0610-791.10-04 EXTRA AND OVERTIME113,332 102,181 100,000 100,000 43,359 33,331 102,000LEVEL TEXTTEXT AMT02 ~167 HRS X $18.47 X 1.5102,000102,000610-0610-791.10-06 LONGEVITY PAY00 1,900 1,900550550 1,900LEVEL TEXTTEXT AMT02 PER 2017-2020 TEAMSTER CONTRACT1,9001,900610-0610-791.10-09 PERMANENT PART-TIME5,060000000610-0610-791.10-14 PRODUCTIVITY BONUS1,875 6,563 5,500 5,500000LEVEL TEXTTEXT AMT02 ELIMINATED IN 2018610-0610-791.11-01 FICA - REGULAR78,721 80,444 88,712 88,712 46,219 39,945 85,962LEVEL TEXTTEXT AMTFund 610 - Solid Waste OperationsCity of South BendExpenditures110 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 TAXABLE PAYROLL $1,112,889 @ 7.65%85,136TAXABLE BENEFITS $10,802 @ 7.65%82685,962610-0610-791.11-04 PERF - REGULAR99,764 112,226 22,720 126,720 66,258 57,193 124,431LEVEL TEXTTEXT AMT02 ELIGIBLE @ 11.2%: SALARIED $267,03229,908HOURLY $741,95783,099OVERTIME $102,00011,424124,431610-0610-791.11-05 PERF - UNION00 119,199 15,199 6,168 5,422 12,659LEVEL TEXTTEXT AMT02 ELIGIBLE HOURLY $741,957 @ 1.5%11,129OVERTIME $102,000 @ 1.5%1,53012,659610-0610-791.11-07 UNEMPLOYMENT COMP2,641 1,520 2,872 2,872000LEVEL TEXTTEXT AMT02 NOT BEING CHARGED IN 2018610-0610-791.11-08 HEALTH INSURANCE185,671 253,090 381,947 381,947 202,136 175,521 365,735LEVEL TEXTTEXT AMT02 LONG TERM DISABILITY:24.24 FTE X $4.00 X 24 PAY PERIODS2,327HEALTH INS22.24 FTE X $675.00 X 24 PAY PERIODS360,288HEALTH INS/REBATE:2 EMP X $ 65.00 X 24 PAY PERIODS3,120365,735610-0610-791.11-09 LIFE INSURANCE2,201 2,648 3,144 3,144 1,644 1,422 2,909LEVEL TEXTTEXT AMT02 24.24FTEX$5.00X24PAYPERIODS2,9092,909610-0610-791.11-10 CLOTHING ALLOWANCE5,327 7,035800800193193800LEVEL TEXTTEXT AMT02 PER CONTRACT:T-SHIRTS ISSUED BY CITY FOR TEAMSTERS800800610-0610-791.11-12 AUTO ALLOWANCE840600600600350300600Fund 610 - Solid Waste OperationsCity of South BendExpenditures111 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 ALLOCATION OF PW DIRECTOR ALLOWANCE $50/MO X 12600600610-0610-791.11-24 CELL PHONE ALLOWANCE792842 1,452 1,452847726 1,452LEVEL TEXTTEXT AMT02 2 SUPERVISORS X $55/MO X 12 MONTHSPW DIRECTOR ALLOCATION $5.50/MONTH X 121,4521,452610-0610-791.11-27 JOB READINESS ALLOWANCE00 9,350 9,350 8,819 8,819 9,350LEVEL TEXTTEXT AMT02 PER CONTRACT:22 TEAMSTERS X $425/EA, PAID 1ST CHECK IN JANUARY9,3509,350610-0610-791.11-29 PARENTAL LEAVE000000 2,782LEVEL TEXTTEXT AMT02 NEW FOR 2018 .25% OF TOTAL WAGES2,782$1,112,889 X .25%2,782610-0610-791.11-99 OTHER FRINGE BENEFITS4000 1,500 1,50000 1,500LEVEL TEXTTEXT AMT02 TEAMSTER'S DEFERRED COMP MATCH1,5001,500------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES1,424,210 1,529,342 1,781,122 1,781,122 948,122 820,724 1,721,069610-0610-791.21-02 PRINT SHOP1,4760 1,000 1,00000500LEVEL TEXTTEXT AMT02 MATERIALS PRINTED500500610-0610-791.21-03 C.S. OFFICE SUPPLIES3,895 1,256 3,500 3,656 1,856995 1,200LEVEL TEXTTEXT AMT02 MISC. OFFICE SUPPLIES, AS NEEDED1,2001,200610-0610-791.21-04 OTHER OFFICE SUPPLIES19094500500263208 1,500Fund 610 - Solid Waste OperationsCity of South BendExpenditures112 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 COPIER TONER & OTHER SUPPLIES NOT AT C.SERVICES1,5001,500610-0610-791.22-01 CENTRAL SERIVCE GASOLINE 140,776 59,312 70,000 62,945 23,073 19,170 50,000LEVEL TEXTTEXT AMT02 20,000 GAL X $2.50 PER CENTRAL SERVICES50,000MAJORITY OF TRUCKS ARE NOW ON CNG FUEL50,000610-0610-791.22-02 GASOLINE - CNG FUEL41,640 92,781 70,000 70,000 75,495 60,202 150,000LEVEL TEXTTEXT AMT02 ESTIMATE PER CENTRAL SERVICES150,000150,000610-0610-791.22-05 UNIFORMS4,545 5,797 7,000 7,000 4,228 3,585 7,000LEVEL TEXTTEXT AMT02 WEEKLY UNIFORM RENTAL & CLEANING AND RUG SERVICE7,0007,000610-0610-791.22-20 C.S. - MEDICAL/SAFETY2,497 1,732 2,500 2,500 1,360 1,360 3,000LEVEL TEXTTEXT AMT02 WORK GLOVES, HEARING PROTECTION, SAFETY GLASSESSAFETY VESTS3,0003,000610-0610-791.22-21 C.S. CLEANING SUPPLIES749 1,455 1,500 1,500403290 5,000LEVEL TEXTTEXT AMT02 BAGS FOR DOWNTOWN TRASH CONTAINERS, OTHER SUPPLIES5,000AS NEEDED FOR OFFICE AND VEHICLE CLEANING5,000610-0610-791.22-22 MEDICAL/SAFETY SUPPLIES570 1,500 3,555 3,373 3,373500LEVEL TEXTTEXT AMT02 SAFETY SUPPLIES NOT AVAILABLE AT CENTRAL STORES,FIRE EXTINGUISHER SERVICE & REPLACEMENTS500500610-0610-791.22-24 OTHER OPERATING SUPPLIES 77,573 147,232 7,000 34,876 25,469 24,833 155,000LEVEL TEXTTEXT AMTFund 610 - Solid Waste OperationsCity of South BendExpenditures113 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 HAND TOOLS, RAKES, SHOVELS, ETC.5,000REPLACEMENT TOTESAS NEEDED150,000155,000610-0610-791.22-60 COMPUTERS1,980000000LEVEL TEXTTEXT AMT02 REPLACEMENT COMPUTERS FOR MANAGERS NOT NEEDEDALL COMPUTERS ON LEASE-PURCHASE------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES275,378 309,659 164,500 187,532 135,520 114,016 373,700610-0610-791.31-06 OTHER PROFESSIONAL SVCS669000000610-0610-791.31-07 MGMT FEE TO WATERWORKS132,480 140,568 156,768 156,768 91,448 78,384 171,435LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #10171,435UTILITY CUSTOMER SERVICE OPERATIONS FEE171,435610-0610-791.31-70 ADM FEE ALLOCATION138,117 148,992 166,199 166,199 96,950 83,100 163,194LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #1163,194ADMINITRATIVE FEE163,194610-0610-791.31-71 CENTRAL STORES ALLOCATION 1,716 1,560 1,938 1,938 1,134972 4,118LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #34,118CENTRAL STORES OPERATING FEE4,118610-0610-791.31-72 GIS ALLOCATION1,081 1,13500000LEVEL TEXTTEXT AMT02 GIS ALLO. FEE MERGED WITH2017 FIXED ALLOCATION #7610-0610-791.31-73 PRINT SHOP ALLOCATION0 3,144 5,157 5,157 3,010 2,580 5,464LEVEL TEXTTEXT AMT02 2018 FIXED ALLOCATION #45,464PRINT SHOP ALLOCATION5,464610-0610-791.31-75 311 CALL CENTER ALLOC0 209,93000000LEVEL TEXTTEXT AMTFund 610 - Solid Waste OperationsCity of South BendExpenditures114 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 FIXED ALLO. MERGED WITH2017 FIXED ALLOCATION #7610-0610-791.31-76 IT ALLOCATION000000 400,941LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #7400,941MERGED WITH 311, VOIP, GIS ALLOCATIONS400,941610-0610-791.32-02 POSTAGE792552600 5,600 3,229 2,686 1,200LEVEL TEXTTEXT AMT02 MAILING MISC NOTICES/LETTERS TO RESIDENTS1,2001,200610-0610-791.32-04 TELEPHONE14,368 12,090 16,200 16,298 6,995 5,455 16,200LEVEL TEXTTEXT AMT02 PHONE SERVICE $140/MONTH X 121,680TRUCK COMPUTERS $50/MONTH X 12 X 20 TRUCKS12,000HOSTING FEE (TRUCKS) $30/MONTH X 7 TAB X 122,52016,200610-0610-791.32-05 OTHER COMM/TRANS118,832000000610-0610-791.32-21 TRAVEL - MILEAGE0020020000200LEVEL TEXTTEXT AMT02 MILEAGE REIMB. WHEN CITY VEHICLE UNAVAILABLE200200610-0610-791.32-22 TRAVEL - AIRFARE0463 2,000 2,000470470 4,000LEVEL TEXTTEXT AMT02 EXPOS, OTHER OUT OF AREA MEETINGS4,0004,000610-0610-791.32-23 TRAVEL - HOTEL0573 2,000 2,000767767 4,000LEVEL TEXTTEXT AMT02 OUT OF AREA MEETINGS, CONFERENCES4,0004,000610-0610-791.32-24 TRAVEL - MEALS0211600600185185 1,200LEVEL TEXTTEXT AMT02 WHEN TRAVELING OUTSIDE MICHIANA AREA1,2001,200Fund 610 - Solid Waste OperationsCity of South BendExpenditures115 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures610-0610-791.32-25 TRAVEL - OTHER01241001009797500LEVEL TEXTTEXT AMT02 TOLLS, PARKING, MISC TRAVEL EXP500500610-0610-791.33-02 PUBLICATION LEGAL NOTICE1,025372502504343250LEVEL TEXTTEXT AMT02 EMPLOYMENT ADVERTISING, EQUIPMENT BID NOTICES250250610-0610-791.34-02 LIABILITY INSURANCE98,664 100,476 76,404 76,404 44,569 38,202 105,956LEVEL TEXTTEXT AMT02 2018 FIXED ALLOCATION #5105,956LIABILITY INSURANCE105,956610-0610-791.35-01 ELECTRIC00 4,800 4,800000610-0610-791.35-02 HEAT00 2,000 2,000000610-0610-791.35-04 WATER00100100000610-0610-791.36-01 BUILDING R&M00 45,000 40,000 21,821 2,229 20,000LEVEL TEXTTEXT AMT02 BASIC MAINTENANCE ITEMS AS NEEDED10,000PAVING THE BACK LOT10,00020,000610-0610-791.36-02 OFFICE EQUIP R&M00 1,000 1,0001720 1,500LEVEL TEXTTEXT AMT02 SMALL, MISC REPAIRS AS NEEDED1,5001,500610-0610-791.36-03 AUTO EQUIPMENT R&M688,732 722,732 600,000 600,000 409,864 349,006 625,000LEVEL TEXTTEXT AMT02 REPAIRS AVERAGE $51-52,000/MONTH X 12=$625,000625,000625,000610-0610-791.36-04 COMPUTER EQUIP R&M1,965 2,088 163,820 163,820 95,564 81,9120610-0610-791.36-06 RADIO EQUIP R&M9,207 33,430 20,000 21,538 14,973 11,225 15,000LEVEL TEXTTEXT AMT02 ELEMOS REPAIR AND MAINTENANCE DONE IN HOUSE NOW15,00015,000Fund 610 - Solid Waste OperationsCity of South BendExpenditures116 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures610-0610-791.37-11 CAPITAL LEASE PRINCIPAL 49,000 9,7000 9,700000610-0610-791.39-11 DUES & MEMBERSHIPS245257500500257257 2,000LEVEL TEXTTEXT AMT02 SWANA, APWA, & OTHER DUES2,0002,000610-0610-791.39-45 LICENSES & PERMITS13,900 23,099 97,000 97,000 52,713 3,1310LEVEL TEXTTEXT AMT02 ANNUAL LICENSE FEE FOR TRUCK COMPUTERS (CASCADE)OFF SITE HOSTINGELEMOS ROUTING SOFTWARENOW PAID FROM COMPUTER EQUIPMENT ALLOCATION #7IN ACCOUNT 610-0610-791-36-04610-0610-791.39-70 EDUCATION & TRAINING0 4,101 10,000 10,000 2,245 2,245 10,000LEVEL TEXTTEXT AMT02 EXPO AND OTHER TRAINING OPPORTUNITIES10,00010,000610-0610-791.39-85 LANDFILL708,371 728,323 650,000 635,358 417,074 349,243 675,000LEVEL TEXTTEXT AMT02 PRAIRIE VIEW ESTIMATE $625000625,000GREEN TECH ESTIMATE $50,00050,000675,000610-0610-791.39-89 MISC CHARGES & SVCS21,236 6,672 5,000 20,225 3,240 1,275 5,000LEVEL TEXTTEXT AMT02 UNANTICIPATED, INCIDENTAL EXPENSES5,0005,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES2,000,400 2,150,257 2,027,636 2,039,555 1,266,820 1,013,464 2,232,158610-0610-791.50-02 OPERATING TRANSFER659,600 925,000 835,613 835,613 493,600 493,600 1,076,706LEVEL TEXTTEXT AMT02 DS-113 SUN TRUST167,200DS-125 OFFICE COMPUTERS438DS-130 GE CAPITAL LEASE1,230DS-136 HP COMPUTERS296DS-140 BANK OF AMERICA123,647DS-144 PNC39,659DS-149 PUBLICFINANCE.COM292,905DS-152 PUBLICFINANCE.COM71,920Fund 610 - Solid Waste OperationsCity of South BendExpenditures117 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresDS-158 PUBLICFINANCE.COM174,4282018 LEASE-PURCHASE REQUESTS3 - FRONT LOAD CNG TRASH TRUCKS, POWER WASHER204,983TRANSFER TO ACCT #611-0000-392.00-001,076,706610-0610-791.63-70 BAD DEBT EXP/RECYCLING60,646 61,349 50,000 50,000 42,201 34,339 50,000LEVEL TEXTTEXT AMT02 BASED ON HISTORIC WRITE OFFS50,00050,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES720,246 986,349 885,613 885,613 535,801 527,939 1,126,706------------ ------------ ------------ ------------ ------------ ------------ ------------** SOLID WASTE4,420,234 4,975,607 4,858,871 4,893,822 2,886,263 2,476,144 5,453,633Fund 610 - Solid Waste OperationsCity of South BendExpenditures118 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures610-0615-791.31-08 SW MD RECYCLING FEE691,159 633,663 737,088 737,088 115,208 115,2080610-0615-791.31-70 ADM FEE ALLOCATION0 23,928 24,000 24,000 15,491 13,2780------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES691,159 657,591 761,088 761,088 130,699 128,4860610-0615-791.63-70 BAD DEBT EXP/RECYCLING10,189 9,765 8,000 8,000 6,065 4,9590------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES10,189 9,765 8,000 8,000 6,065 4,9590------------ ------------ ------------ ------------ ------------ ------------ ------------** RECYCLING701,348 667,356 769,088 769,088 136,764 133,4450Fund 610 - Solid Waste OperationsCity of South BendExpenditures119 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures610-6117-791.10-01 REGULAR WAGES47,749000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.10-02 HOURLY WAGES105,846000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.10-04 EXTRA AND OVERTIME1,771000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.10-14 PRODUCTIVITY BONUS1,000000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.11-01 FICA - REGULAR11,447000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.11-04 PERF - REGULAR17,398000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.11-08 HEALTH INSURANCE44,990000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.11-09 LIFE INSURANCE452000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.11-10 CLOTHING ALLOWANCE500000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.11-24 CELL PHONE ALLOWANCE420000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.11-99 OTHER FRINGE BENEFITS400000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES231,973000000610-6117-791.22-01 CENTRAL SERIVCE GASOLINE4,016000000Fund 610 - Solid Waste OperationsCity of South BendExpenditures120 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.22-05 UNIFORMS6391200000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.22-20 C.S. - MEDICAL/SAFETY498000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.22-22 MEDICAL/SAFETY SUPPLIES495000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.22-24 OTHER OPERATING SUPPLIES2,961000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES8,6091200000610-6117-791.36-03 AUTO EQUIPMENT R&M22,529000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.39-85 LANDFILL84,103 6,73300000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET610-6117-791.39-89 MISC CHARGES & SVCS1,420000000LEVEL TEXTTEXT AMT02 CODE WILL HAVE THEIR OWN BUDGET------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES108,052 6,73300000------------ ------------ ------------ ------------ ------------ ------------ ------------** ILLEGAL DUMPING CREW348,634 6,74500000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SOLID WASTE FUND5,470,216 5,649,708 5,627,959 5,662,910 3,023,027 2,609,589 5,453,633Fund 610 - Solid Waste OperationsCity of South BendExpenditures121 City of South Bend, Indiana 2018 Budget Fund 611 - Solid Waste Capital Fund Type Enterprise 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 Grants/Intergovernmental - 300,000 - - - - - - - - - Interest Earnings 113 1,149 700 489 800 800 800 800 800 100 14% Other Income - - - - - - - - - - - Transfers In 659,600 925,000 835,613 493,600 1,076,706 1,113,809 1,106,897 808,845 584,393 241,093 29% Total Revenue 659,713 1,226,149 836,313 494,089 1,077,506 1,114,609 1,107,697 809,645 585,193 241,193 29% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal 666,950 851,406 1,078,343 515,114 1,009,386 1,053,577 1,067,533 774,508 576,220 (68,957) -6% Interest & Fees 27,521 38,738 45,270 22,924 67,320 60,232 39,364 34,337 8,173 22,050 49% Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 694,471 890,144 1,123,613 538,038 1,076,706 1,113,809 1,106,897 808,845 584,393 (46,907) -4% Capital - - 12,000 - - - - - - (12,000) -100% Total Expenditures 694,471 890,144 1,135,613 538,038 1,076,706 1,113,809 1,106,897 808,845 584,393 (58,907) -5% Net Surplus / (Deficit)(34,758) 336,005 (299,300) (43,949) 800 800 800 800 800 Beginning Cash Balance 35,162 442 335,856 36,556 37,356 38,156 38,956 39,756 Cash Reserve Cash Adjustments 38 (591) - - - - - - Ending Cash Balance 442 335,856 36,556 37,356 38,156 38,956 39,756 40,556 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund is used for debt service and capital expenditures related to the Solid Waste Department. This fund receives transfers from the Solid Waste Operations Fund 610. Solid Waste currently has six equipment leases for trucks and equipment, the oldest of which will be paid off in 2018. In addition, 2018 includes a new lease-purchase request to replace three of the oldest rear load trucks in the fleet with three CNG fueled, front load units. They are also requesting to lease-purchase a trailer mounted power washer for trash and yard waste tote maintenance. Amounts forecast in 2019-2022 are for existing lease payments and new leases to pay for the replacement of one or two trucks per year. 122 City of South Bend, Indiana2018 BudgetFund 611 - Solid Waste CapitalFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalFront Load Dedicated unitLease375,000 - - - - 375,000 Replacing 2009 Rear load 570Front Load Dedicated unitLease375,000 - - - - 375,000 Replacing 2010 Rear load 569Front Load Dedicated unitLease375,000 - - - - 375,000 Replacing 2011 Rear load 567Front Load Dedicated unitLease350,000 - - - 350,000 Replacing 2016 Rear load 571Front Load Dedicated unitLease- 350,000 - - 350,000 Replacing 2016 Rear load 572Front Load Dedicated unitLease- - 350,000 - - 350,000 Replacing 2011 Dual Auto 561Front Load Dedicated unitLease- - - 350,000 - 350,000 Replacing 2013 Dual Auto 577Front Load Dedicated unitLease- - - 350,000 - 350,000 Replacing 2013 Dual Auto 574Front Load Dedicated unitLease- - - - 350,000 350,000 Replacing 2013 Dual Auto 568Front Load Dedicated unitLease- - - - 350,000 350,000 Replacing 2013 Dual Auto 564Total Replacement Capital1,125,000 700,000 350,000 700,000 700,000 3,575,000 Project CapitalTote Power WasherLease70,000 - - - - - Refurbish and offer a cleaning service for totesTotal Project Capital70,000 - - - - 70,000 Minimum Thresholds:Total Capital1,195,000 700,000 350,000 700,000 700,000 3,645,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:123 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSOLID WASTE DEPR.611-0000-334.04-00 STATE GRANT-SANITATION0 300,00000000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 300,00000000611-0000-361.00-00 INTEREST EARNINGS113 1,149200700553489800LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST EARNED ON CASH RESERVES800COMMON COUNCIL ORDINANCE 10198-12, PASSED 10-29-12800------------ ------------ ------------ ------------ ------------ ------------ ------------*113 1,149200700553489800611-0000-392.00-00 INTERFUND OPER. TRANSFER 659,600 925,000 835,613 835,613 493,600 493,600 1,076,706LEVEL TEXTTEXT AMT02 TO FUND EXISTING LEASES:DS-113 SUN TRUST167,200DS-125 OFFICE COMPUTERS438DS-130 COPIER1,230DS-136 LAPTOPS296DS-140 2 TRASH TRUCKS, 2 PICK-UPS123,647DS-144 LIGHTNING LOADER39,659DS-149 TRASH TRUCKS, TRASH TOTES292,905DS-152 HOOK LIFT GRAPPLE TRUCK, PICKUP71,921DS-158 FRONT LOAD DUMPSTERS, TRASH TOTES174,4282018 CAPITAL REQUESTS:3 FRONT LOAD TRASH TRUCKS, POWER WASHER204,982TRANSFER FROM ACCT #610-0610-791.50-021,076,706------------ ------------ ------------ ------------ ------------ ------------ ------------*659,600 925,000 835,613 835,613 493,600 493,600 1,076,706------------ ------------ ------------ ------------ ------------ ------------ ------------** SOLID WASTE DEPR.659,713 1,226,149 835,813 836,313 494,153 494,089 1,077,506------------ ------------ ------------ ------------ ------------ ------------ ------------*** SOLID WASTE DEPR.659,713 1,226,149 835,813 836,313 494,153 494,089 1,077,506Fund 611 - Solid Waste Debt ServiceCity of South BendRevenue124 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSOLID WASTE DEPR.611-0610-415.37-11 CAPITAL LEASE PRINCIPAL 666,950 851,406 1,078,343 1,078,343 795,496 515,114 1,009,386LEVEL TEXTTEXT AMT02 DS-113 2013 VEHICLE LEASE165,233DS-125 2014 HP COMPUTER LEASE429DS-130 2014 RICOH COPIER LEASE1,134DS-136 2015 HP COMPUTER LEASE281DS-140 2015 VEHICLE/EQUIP LEASE NO.1119,043DS-144 2015 VEHICLE/EQUIP LEASE NO.238,017DS-149 2016 VEHICLE/EQUIP LEASE NO.1278,141DS-152 2016 VEHICLE/EQUIP LEASE NO.267,945DS-158 2017 VEHICLE/EQUIP LEASE NO.1153,8562018 LEASE-PURCHASES:3 - FRONT LOAD TRASH TRUCKS @ $350,000/EAPOWER WASHER @ $70,0005 YR LEASE, 2.5% INT, 2018 PRINCIPAL $185307185,3071,009,386611-0610-415.37-12 CAPITAL LEASE INTEREST27,521 38,738 45,270 45,270 29,468 22,924 67,320LEVEL TEXTTEXT AMT02 DS-113 2013 VEHICLE LEASE1,967DS-125 2014 HP COMPUTER LEASE9DS-130 2014 RICOH COPIER LEASE96DS-136 2015 HP COMPUTER LEASE15DS-140 2015 VEHICLE/EQUIP LEASE NO.14,604DS-144 2015 VEHICLE/EQUIP LEASE NO.21,642DS-149 2016 VEHICLE/EQUIP LEASE NO.114,764DS-152 2016 VEHICLE/EQUIP LEASE NO.23,976DS-158 2017 VEHICLE/EQUIP LEASE NO.120,5722018 LEASE PURCHASES3 - FRONT LOAD TRASH TRUCKS @ $350,000/EAPOWER WASHER $70,0005 YR LEASE, 2.5% INT, 2018 INTEREST $19,67519,67567,320------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES694,471 890,144 1,123,613 1,123,613 824,964 538,038 1,076,706611-0610-415.43-05 DEPARTMENTAL EQUIPMENT00 12,000 12,000000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL00 12,000 12,000000------------ ------------ ------------ ------------ ------------ ------------ ------------** SOLID WASTE694,471 890,144 1,135,613 1,135,613 824,964 538,038 1,076,706------------ ------------ ------------ ------------ ------------ ------------ ------------*** SOLID WASTE DEPR.694,471 890,144 1,135,613 1,135,613 824,964 538,038 1,076,706Fund 611 - Solid Waste Debt ServiceCity of South BendExpenditures125 City of South Bend, Indiana 2018 Budget Fund 655 - Project Releaf Fund Type Special Revenue 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 Charges for Services 438,225 440,649 440,153 221,371 439,680 444,077 448,518 453,003 457,533 (473) 0% Interest Earnings 6,133 7,817 4,403 3,866 6,120 6,181 6,243 6,305 6,368 1,717 39% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 444,358 448,466 444,556 225,237 445,800 450,258 454,761 459,308 463,901 1,244 0% Expenditures by Type Personnel Salaries & Wages 35,997 25,817 46,200 - 47,124 47,595 48,071 48,552 49,037 924 2% Fringe Benefits 2,902 1,975 3,651 - 3,605 3,641 3,677 3,714 3,751 (46) -1% Total Personnel 38,899 27,792 49,851 - 50,729 51,236 51,749 52,266 52,789 878 2% Supplies 847 1,754 4,344 876 4,344 4,387 4,431 4,476 4,520 - 0% Services & Charges Professional Services 11,796 12,432 13,740 6,870 17,647 17,823 18,002 18,182 18,364 3,907 28% Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance 10,100 10,034 10,606 591 10,606 10,712 10,819 10,927 11,037 - 0% Other Interfund Allocations 12,783 16,968 18,252 9,126 13,734 13,871 14,010 14,150 14,292 (4,518) -25% Debt Service Principal 68,587 69,615 70,659 35,198 48,405 48,889 49,378 49,872 50,370 (22,254) -31% Interest & Fees 3,631 2,603 1,561 911 577 583 589 594 600 (984) -63% Insurance 480 540 408 204 - - - - - (408) -100% Transfers Out 350,000 350,000 350,000 175,000 550,000 550,000 430,000 330,000 320,000 200,000 57% Other Services & Charges 5,765 5,456 5,995 2,714 6,000 6,060 6,121 6,182 6,244 5 0% Total Services & Charges 463,142 467,648 471,221 230,614 646,969 647,939 528,918 429,907 420,906 175,748 37% Capital - - - - - - - - - - - Total Expenditures 502,888 497,194 525,416 231,490 702,042 703,562 585,098 486,649 478,216 176,626 34% Net Surplus / (Deficit)(58,530) (48,728) (80,860) (6,253) (256,242) (253,304) (130,337) (27,341) (14,314) Beginning Cash Balance 978,745 920,836 871,573 790,713 534,471 281,167 150,829 123,488 Cash Reserve Cash Adjustments 621 (535) - - - - - - Ending Cash Balance 920,836 871,573 790,713 534,471 281,167 150,829 123,488 109,174 Cash Reserves Target 125,722 124,298 131,354 175,511 175,891 146,275 121,662 119,554 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 25% of Annual expenditures This fund accounts for the fall and spring leaf collection program. The program is financed by a $0.99 per month charge on residents' utility bills. In the 2018 budget, Transfers Out consists of $350,000 to the Motor Vehicle Highway Fund (202) and $200,000 to the Wastewater/Organic Resources Fund for costs incurred in the operating the Project Releaf program. Unless additonal revenue is generated in this fund, the amount of transfers out may need to be reduced in future years to maintain adequated cash reserves in the fund. 126 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenuePROJECT RELEAF655-0000-346.01-10 METERED SALES-RESIDENTIAL 438,225 440,649 440,153 440,153 274,389 221,371 439,680LEVEL TEXTTEXT AMT02 RATE $.99 PER MONTH PER HOUSEHOLD, BASED ON439,680HISTORICAL TRENDSCOMMON COUNCIL ORDINANCE 10197-12, PASSED 10-29-12INCREASE OF APPROX 1% PER YEAR OVER THE LAST 5 YRS2018: BASED ON AVG 2015, 2016, 2017439,680------------ ------------ ------------ ------------ ------------ ------------ ------------*438,225 440,649 440,153 440,153 274,389 221,371 439,680655-0000-361.00-00 INTEREST EARNINGS6,133 7,817 4,403 4,403 4,950 3,866 6,120LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST EARNED ON CASH RESERVES6,1202018: BASED ON AVG 2015, 2016, 20176,120------------ ------------ ------------ ------------ ------------ ------------ ------------*6,133 7,817 4,403 4,403 4,950 3,866 6,120------------ ------------ ------------ ------------ ------------ ------------ ------------** PROJECT RELEAF444,358 448,466 444,556 444,556 279,339 225,237 445,800------------ ------------ ------------ ------------ ------------ ------------ ------------*** PROJECT RELEAF444,358 448,466 444,556 444,556 279,339 225,237 445,800Fund 655 - Project ReLeafCity of South BendRevenue127 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresPROJECT RELEAF655-0609-435.10-03 SEASONAL & INTERNS30,788 24,493 33,600 33,60000 34,272LEVEL TEXTTEXT AMT02 12 SEASONAL EMPLOYEES - 280 HOURS @ 10.20/HR34,27234,272655-0609-435.10-04 EXTRA AND OVERTIME5,209 1,324 12,600 12,60000 12,852LEVEL TEXTTEXT AMT02 12 SEASONAL @ 15.30 X 70 HRS12,85212,852655-0609-435.11-01 FICA - REGULAR2,754 1,975 3,535 3,53500 3,605LEVEL TEXTTEXT AMT02 ALL WAGES X 7.65%3,6053,605655-0609-435.11-07 UNEMPLOYMENT COMP1480116116000LEVEL TEXTTEXT AMT02 NOT CHARGING IN 2018------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES38,899 27,792 49,851 49,85100 50,729655-0609-435.22-24 OTHER OPERATING SUPPLIES847 1,754 4,344 4,344876876 4,344LEVEL TEXTTEXT AMT02 MISC HAND TOOLS - RAKES, ETC4,3444,344------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES847 1,754 4,344 4,344876876 4,344655-0609-435.31-07 MGMT FEE TO WATER WORKS 11,796 12,432 13,740 13,740 8,015 6,870 13,734LEVEL TEXTTEXT AMT02 2017 FIXED COST ALLOCATION #613,734UTILITY CUSTOMER SERVICE OPERATIONS FEE13,734655-0609-435.31-70 ADM FEE ALLOCATION12,783 16,968 18,247 18,252 10,647 9,126 17,647LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #117,647ADMINISTRATIVE FEE17,647Fund 655 - Project ReLeafCity of South BendExpenditures128 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures655-0609-435.34-02 LIABILITY INSURANCE4805404084082382040LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #5LIABILITY INSURANCE655-0609-435.36-03 AUTO EQUIPMENT R&M10,100 10,034 10,606 10,606591591 10,606LEVEL TEXTTEXT AMT02 BASED ON 2016 - 10,100.00 + 5%10,60610,606655-0609-435.37-11 CAPITAL LEASE PRINCIPAL 68,587 69,615 70,659 70,659 46,742 35,198 48,405LEVEL TEXTTEXT AMT02 2013 LEAF VACS - DEBT SCHEDULE 113 - PD OFF 201848,40548,405655-0609-435.37-12 CAPITAL LEASE INTEREST3,631 2,603 1,561 1,561987911577LEVEL TEXTTEXT AMT02 2013 LEAF VACS - DEBT SCHEDULE 113 - PD OFF 2018577577------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES107,377 112,192 115,221 115,226 67,220 52,900 90,969655-0609-435.50-02 INTERFUND TRANSFER350,000 350,000 350,000 350,000 175,000 175,000 550,000LEVEL TEXTTEXT AMT02 TRANSFER TO COVER A PORTION OF MVH COSTS PAID FOR350,000SPRING AND FALL PROJECT RELEAF DURING 2015.INCLUDES SUPERVISORY WAGES AND BENEFITS, GASOLINE,DEPRECIATION ON LEAF VACS AND OTHER COSTS. TOTALESTIMATED COST - $343,870INCREASE OF $10,000 FROM 2011 BUDGETINCREASE TRANSFER BY $100,000 IN 2015TRANSFER TO ACCOUNT #202-0000-392.00-00NEW IN 2018:TRANSFER TO OR TO COVER A PORTION OF THE COSTSFOR PROCESSING LEAVES - TO 641-0631-344.07-55200,000550,000655-0609-435.63-70 BAD DEBT EXPENSES5,765 5,456 6,000 5,995 3,311 2,714 6,000LEVEL TEXTTEXT AMT02 AVERAGE 2012 - 2015 = 5,406.006,0006,000Fund 655 - Project ReLeafCity of South BendExpenditures129 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES355,765 355,456 356,000 355,995 178,311 177,714 556,000------------ ------------ ------------ ------------ ------------ ------------ ------------** LEAF PICKUP502,888 497,194 525,416 525,416 246,407 231,490 702,042------------ ------------ ------------ ------------ ------------ ------------ ------------*** PROJECT RELEAF502,888 497,194 525,416 525,416 246,407 231,490 702,042Fund 655 - Project ReLeafCity of South BendExpenditures130