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 (5) Financials - Wastewater & Sewers
City of South Bend, Indiana 2018 Budget Fund 640 - Sewer Repair Insurance 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 606,291 626,821 613,924 320,976 615,685 621,842 628,060 634,341 640,684 1,761 0% Interest Earnings 8,996 15,682 7,864 8,030 10,850 10,959 11,068 11,179 11,291 2,986 38% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 615,287 642,503 621,788 329,006 626,535 632,800 639,128 645,520 651,975 4,747 1% Expenditures by Type Personnel Salaries & Wages 115,696 109,978 146,524 71,134 150,324 153,330 156,397 159,525 162,716 3,800 3% Fringe Benefits 42,802 45,307 73,274 33,326 75,774 77,263 78,782 80,332 81,912 2,500 3% Total Personnel 158,498 155,285 219,798 104,460 226,098 230,594 235,179 239,857 244,628 6,300 3% Supplies 18,403 21,234 37,970 10,725 36,859 37,596 38,348 39,115 39,897 (1,111) -3% Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance 242,015 306,038 237,869 141,589 302,500 308,550 314,721 321,015 327,436 64,631 27% Other Interfund Allocations 16,323 17,520 18,845 9,420 17,763 18,118 18,481 18,850 19,227 (1,082) -6% Debt Service Principal 27,492 27,908 14,190 14,112 - - - - - (14,190) -100% Interest & Fees 943 528 107 106 - - - - - (107) -100% Insurance 120 132 108 54 104 106 108 110 113 (4) -4% Transfers Out - - - - - - - - - - - Other Services & Charges 6,980 7,073 5,622 2,698 6,072 6,193 6,317 6,444 6,573 450 8% Total Services & Charges 293,873 359,199 276,741 167,978 326,439 332,968 339,627 346,420 353,348 49,698 18% Capital - - - - - - - - - - - Total Expenditures 470,774 535,718 534,509 283,163 589,396 601,158 613,155 625,392 637,873 54,887 10% Net Surplus / (Deficit)144,513 106,785 87,279 45,843 37,139 31,643 25,974 20,128 14,102 Beginning Cash Balance 1,505,378 1,647,834 1,752,931 1,840,210 1,877,349 1,908,991 1,934,965 1,955,093 Cash Reserve Cash Adjustments (2,057) (1,689) - - - - - - Ending Cash Balance 1,647,834 1,752,931 1,840,210 1,877,349 1,908,991 1,934,965 1,955,093 1,969,195 Cash Reserves Target 117,694 133,929 133,627 147,349 150,289 153,289 156,348 159,468 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 25% of Annual expenditures 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. In 2017, three additional companies were added to do excavations. The City plans to continue to look for additional companies to provide second opinions and excavations. 182 City of South Bend, Indiana 2018 Budget Fund 640 - Sewer Repair Insurance 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 Director of Streets 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 Manager of Sewer Operations 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 Superintendent V 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 *Administrative Assistant I 0.2 0.2 0.2 0.2 0.2 0.2 0.2 0.2 *Administrative Assistant II 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 *Director of Financial Services 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 Total Non-Bargaining 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 Bargaining Job Leader 0.5 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Total Bargaining 0.5 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Total Full-Time Employees 2.2 2.7 2.7 2.7 2.7 2.7 2.7 2.7 Explain Significant Staffing Changes Below: * new titles 183 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSEWER INSURANCE. FUND640-0000-344.07-20 SEWER REPAIR INSURANCE538,794 565,171 559,680 559,680 350,930 284,009 554,550LEVEL TEXTTEXT AMT02 FLAT RATE OF $1.18 PER MONTH ESTIMATE BASED ON554,550TRENDS/APPROX 2,000 NEW CUSTOMERS ADDED - CLAYTOWNSHIP AND SBO UNMETERED CUSTOMERS554,550640-0000-344.07-25 SEWER REPAIR DEDUCTIBLE 67,497 61,650 54,244 54,244 44,451 36,967 61,135LEVEL TEXTTEXT AMT02 $500 SEWER INSURANCE DEDUCTIBLE61,1352018: BASED ON AVG 2015, 2016, 201761,135------------ ------------ ------------ ------------ ------------ ------------ ------------*606,291 626,821 613,924 613,924 395,381 320,976 615,685640-0000-361.00-00 INTEREST EARNINGS8,996 15,682 7,864 7,864 10,320 8,030 10,850LEVEL TEXTTEXT AMT02 INTERERST EARNINGS BASED ON TRENDS10,8502018: BASED ON AVG 2015, 2016, 201710,850------------ ------------ ------------ ------------ ------------ ------------ ------------*8,996 15,682 7,864 7,864 10,320 8,030 10,850------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWER INSURANCE. FUND615,287 642,503 621,788 621,788 405,701 329,006 626,535------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWER INSURANCE. FUND615,287 642,503 621,788 621,788 405,701 329,006 626,535Fund 640 - Sewer InsuranceCity of South BendRevenue184 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSEWER INSURANCE. FUND640-0620-811.10-01 REGULAR WAGES73,164 71,752 94,019 94,019 49,505 42,330 96,091LEVEL TEXTTEXT AMT02 DIRECTOR OF STREETS - 84,793.00 - 5%4,240MGR OF SEWER OPERATIONS - 62,944.00 - 30%18,883SUPERINTENDENT V57,566*ADMINISTRATIVE ASSISTANT - 40,525.00 - 20%8,105*ADMINISTRATIVE ASSISTANT II - 41,724.00 - 5%2,086*DIR FINANCIAL SVDS - 62,132.00 - 10%6,213SALARY ALLOWANCE1,002-FTE: 1.796,091640-0620-811.10-02 HOURLY WAGES21,488 21,125 43,202 43,202 24,624 21,341 43,535LEVEL TEXTTEXT AMT02 JOB LEADER - 20.68 X 2080 HOURS43,015CERTIFICATION - .25 X 2080 HOURS52043,535640-0620-811.10-04 EXTRA AND OVERTIME3,149 2,428 2,586 2,586 2,596 2,226 2,606LEVEL TEXTTEXT AMT02 JOBLEADER-7HRS/MONTH20.68 X 1.5 X 84 HRS2,6062,606640-0620-811.10-06 LONGEVITY0015015000150LEVEL TEXTTEXT AMT02 NEW IN 2017 - BASED ON YEARS OF SERVICE150150640-0620-811.10-13 CONTRACT ADD PAYS17,770 14,423 6,567 6,567 5,648 5,237 7,942LEVEL TEXTTEXT AMT02 STANDBY-JOB LEADER - 20.68 X 32 HRS/WK X 12 WKS7,9427,942640-0620-811.10-14 PRODUCTIVITY BONUS12525000000LEVEL TEXTTEXT AMT02 REPLACED IN 2017 W/JOB READINESS ALLOWANCE -SEE 640-0620-811.11-27640-0620-811.11-01 FICA - REGULAR8,379 7,928 11,343 11,343 6,132 5,294 11,634LEVEL TEXTTEXT AMTFund 640 - Sewer InsuranceCity of South BendExpenditures185 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 ALL INCOME/WAGES X 7.65%11,533CELL PHONE ALLOWANCE: 1,311 X 7.65%101AUTO ALLOWANCE: NONE IN 201711,634640-0620-811.11-04 PERF - REGULAR12,317 11,727 16,459 16,459 9,136 7,878 16,884LEVEL TEXTTEXT AMT02 ALL INCOME/WAGES X 11.20%16,88416,884640-0620-811.11-05 PERF - UNION00794794481420820LEVEL TEXTTEXT AMT02 NEW IN 2017 - CITY WILL PAY 1.5% OF TEAMSTERCONTRIBUTION820820640-0620-811.11-07 UNEMPLOYMENT COMP371150367367000LEVEL TEXTTEXT AMT02 NOT CHARGING IN 2018640-0620-811.11-08 HEALTH INSURANCE20,506 24,252 42,251 42,251 21,837 18,550 44,000LEVEL TEXTTEXT AMT02 HEALTH INSURANCE:2.7 EMP X 675.00 X 24 PAY PERIODS43,740LONG TERM DISABILITY:2.7 EMP X 4.00 X 24 PAY PERIODS26044,000640-0620-811.11-09 LIFE INSURANCE224225324324180153324LEVEL TEXTTEXT AMT02 2.7 EMP X 5.00 X 24 PAY PERIODS324324640-0620-811.11-10 CLOTHING ALLOWANCE12411600000LEVEL TEXTTEXT AMT02 REPLACED IN 2017 W/JOB READINESS ALLOWANCE -SEE 640-0620-811.11-27640-0620-811.11-12 AUTO ALLOWANCE8000000LEVEL TEXTTEXT AMT02 N/A IN 2017640-0620-811.11-24 CELL PHONE ALLOWANCE873909 1,311 1,311715606 1,311LEVEL TEXTTEXT AMTFund 640 - Sewer InsuranceCity of South BendExpenditures186 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 SUPERINTENDENT V - 55/MO X 12 MONTHS660JOB LEADER - 35.00/MO X 12 MONTHS420SEWER OPS MANAGER - 55.00/MO X 12 MONTHS X 30%198DIRECTOR OF STREETS - 55.00/MO X 12 MONTHS X 5%331,311640-0620-811.11-27 JOB READINESS ALLOWANCE00425425425425425LEVEL TEXTTEXT AMT02 NEW IN 2017 - REPLACES PRODUCTION BONUS AND425SHOE ALLOWANCE425640-0620-811.11-29 PARENTAL LEAVE000000376LEVEL TEXTTEXT AMT02 PARENTAL LEAVE - ALL WAGES X .25%376376------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES158,498 155,285 219,798 219,798 121,279 104,460 226,098640-0620-811.21-02 PRINT SHOP00700700354354700LEVEL TEXTTEXT AMT02 PRINT SEWER INSURANCE FORMS700700640-0620-811.21-03 C.S. OFFICE SUPPLIES0233033000330LEVEL TEXTTEXT AMT02 OFFICE SUPPLY - PAPER GOODS330330640-0620-811.22-01 CENTRAL SERVICE GASOLINE1,589 1,753 1,900 1,900 1,197 1,025 2,529LEVEL TEXTTEXT AMT02 TRUCK 456 - AVG 2014 - 20162,529CS RECOMMENDATION 1,011.43 GAL X 2.502,529640-0620-811.22-05 UNIFORMS00300300131101300LEVEL TEXTTEXT AMT02 UNIFORMS, T-SHIRTS300300640-0620-811.22-22 MEDICAL/SAFETY SUPPLIES06500000Fund 640 - Sewer InsuranceCity of South BendExpenditures187 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 N/A - 2017640-0620-811.22-24 OTHER OPERATING SUPPLIES7,155 7,456 6,000 9,74000 8,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS SUPPLIES8,0008,000640-0620-811.23-04 SEWER MAINT MATERIALS9,659 11,958 25,000 25,000 10,141 9,244 25,000LEVEL TEXTTEXT AMT02 CONCRETE, BACKFILL, ETC25,00025,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES18,403 21,234 34,230 37,970 11,823 10,725 36,859640-0620-811.31-70 ADM FEE ALLOCATION16,323 17,520 18,845 18,845 10,990 9,420 17,763LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #117,763ADMINISTRATIVE FEE17,763640-0620-811.32-02 POSTAGE1,339000000640-0620-811.32-04 TELEPHONE2833733733723636372LEVEL TEXTTEXT AMT02 I-PAD SERVICE - GIS ACCESS372372640-0620-811.34-02 LIABILITY INSURANCE1201321021086354104LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #5104LIABILITY INSURANCE104640-0620-811.36-03 AUTO EQUIPMENT R&M1,756476 2,500 2,500277277 2,500LEVEL TEXTTEXT AMT02 TRUCK 4562,5002,500640-0620-811.36-09 SEWER REPAIR240,259 305,562 233,469 235,369 179,355 141,312 300,000LEVEL TEXTTEXT AMTFund 640 - Sewer InsuranceCity of South BendExpenditures188 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 AVG 2014 - 2016 = 253,225.00300,000ADDED CLAY TOWNSHIP CUSTOMERS IN 2016 - PLANNINGFOR ADDITIONAL EXPENSE300,000640-0620-811.37-11 CAPITAL LEASE PRINCIPAL 27,492 27,908 14,190 14,190 14,112 14,1120LEVEL TEXTTEXT AMT02 2012 LEASE - PNC EQUIP FINANCE - SCHEDULE 98CAMERA TRUCK - SPLIT 50-50 WITH SEWER DEPARTMENTPAID OFF IN 2017640-0620-811.37-12 CAPITAL LEASE INTEREST9435281071071061060LEVEL TEXTTEXT AMT02 2012 LEASE - PNC EQUIPMENT FINANCE - SCHEDULE 98CAMERA TRUCK - SPLIT 50-50 WITH SEWER DEPARTMENTPAID OFF IN 2017------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES288,515 352,499 269,586 271,491 204,939 165,317 320,739640-0620-811.63-70 BAD DEBT EXPENSE5,358 6,700 5,250 5,250 3,051 2,661 5,700LEVEL TEXTTEXT AMT02 AVG 2014 - 20165,7005,700------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES5,358 6,700 5,250 5,250 3,051 2,661 5,700------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWER REPAIR470,774 535,718 528,864 534,509 341,092 283,163 589,396------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWER INSURANCE. FUND470,774 535,718 528,864 534,509 341,092 283,163 589,396Fund 640 - Sewer InsuranceCity of South BendExpenditures189 City of South Bend, Indiana 2018 Budget Fund 641 - Sewage Works 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 Licenses & Permits - - - - - - - - - - - Charges for Services 35,907,389 38,347,605 37,020,404 18,845,566 37,433,610 37,433,610 37,433,610 37,433,610 37,433,610 413,206 1% Interest Earnings 45,346 102,607 65,000 64,704 100,000 100,000 100,000 100,000 100,000 35,000 54% Other Income 95,750 84,096 56,500 19,087 52,975 52,975 52,975 52,975 52,975 (3,525) -6% Transfers In 23,677 35,808 30,000 20,893 230,000 230,000 110,000 30,000 30,000 200,000 667% Total Revenue 36,072,162 38,570,116 37,171,904 18,950,250 37,816,585 37,816,585 37,696,585 37,616,585 37,616,585 644,681 2% Expenditures by Type Personnel Salaries & Wages 3,491,615 3,613,711 4,061,456 1,824,231 5,449,274 5,558,288 5,670,198 5,784,423 5,907,750 1,387,818 34% Fringe Benefits 3,041,040 3,203,980 3,689,224 1,722,407 2,611,412 2,757,028 2,917,052 3,089,911 3,278,243 (1,077,812) -29% Total Personnel 6,532,655 6,817,691 7,750,680 3,546,638 8,060,686 8,315,316 8,587,250 8,874,334 9,185,993 310,006 4% Supplies 1,394,270 1,675,426 2,656,812 632,842 2,203,090 2,252,642 2,303,857 2,356,803 2,411,558 (453,722) -17% Services & Charges Professional Services 1,402,447 2,256,882 3,714,990 1,390,108 3,151,188 3,161,438 3,171,729 3,182,062 3,190,838 (563,802) -15% Printing & Advertising 4,851 2,199 3,820 938 4,300 4,312 4,324 4,337 4,349 480 13% Utilities 981,012 1,109,732 1,035,219 598,872 1,109,052 1,121,845 1,134,850 1,148,074 1,161,527 73,833 7% Education & Training 18,786 10,729 32,681 4,523 32,500 32,650 32,803 32,959 33,118 (181) -1% Travel 14,267 18,326 28,405 2,732 35,200 35,418 35,639 35,864 36,092 6,795 24% Repairs & Maintenance 1,525,933 1,689,156 2,513,477 934,658 1,803,545 1,846,409 1,890,926 1,937,167 1,985,209 (709,932) -28% Payment In Lieu of Taxes 3,497,196 3,672,060 4,422,402 2,211,204 4,601,656 4,606,258 4,610,864 4,615,475 4,620,090 179,254 4% Other Interfund Allocations 1,084,206 1,313,984 1,594,472 868,112 2,284,817 2,333,553 2,383,365 2,434,278 2,486,314 690,345 43% Debt Service Principal 354,606 573,954 830,433 340,862 667,094 631,824 602,453 337,979 188,490 (163,339) -20% Interest & Fees 29,939 40,421 52,436 20,636 49,828 32,465 20,092 8,548 2,936 (2,608) -5% Insurance 284,484 276,912 305,809 152,904 329,280 337,066 345,045 353,220 361,596 23,471 8% Transfers Out 17,525,877 12,575,437 13,629,745 6,535,540 17,512,379 9,044,676 8,936,015 7,803,089 7,823,319 3,882,634 28% Other Services & Charges 1,405,388 1,820,537 5,970,954 1,130,882 4,657,969 4,723,241 4,789,716 4,857,417 4,926,367 (1,312,985) -22% Total Services & Charges 28,128,992 25,360,329 34,134,843 14,191,970 36,238,808 27,911,156 27,957,820 26,750,468 26,820,247 2,103,965 6% Capital - - - - - - - - - - - Total Expenditures 36,055,917 33,853,446 44,542,335 18,371,449 46,502,584 38,479,113 38,848,927 37,981,605 38,417,797 1,960,249 4% Net Surplus / (Deficit)16,245 4,716,670 (7,370,431) 578,802 (8,685,999) (662,528) (1,152,342) (365,020) (801,212) Beginning Cash Balance 8,982,959 8,996,120 13,289,872 14,250,557 5,564,558 4,902,029 3,749,687 3,384,667 Cash Reserve Cash Adjustments (3,084) (422,919) 8,331,116 - - - - - Ending Cash Balance 8,996,120 13,289,872 14,250,557 5,564,558 4,902,029 3,749,687 3,384,667 2,583,455 Cash Reserves Target 1,802,796 1,692,672 2,227,117 2,325,129 1,923,956 1,942,446 1,899,080 1,920,890 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 5% of Annual expenditures This fund accounts for the operations of the Wastewater Department, Sewer Department, Organic Resources Department, and Concrete Crew. Sewer rates have increased recently due to higher operating costs and to cover the costs for the EPA-mandated Long Term Control Plan (LTCP), a construction project designed to address overflow issues. The Cash Adjustment of $8,331,116 is to bring cash balance to $14,250,557 actual at 6/30/2017. 190 City of South Bend, Indiana 2018 Budget Fund 641 - Sewage Works Operations Accomplishments, Goals, KPI's 2017 Accomplishments & Outcomes - - - - - - - - - - 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 -output 0000 -output 0 10 0 0 -output 90% 95.84% 97.35% 90% - - - - Types: output, efficiency, effectiveness, quality, outcome, technology 2018 Significant Changes/Challenges/Opportunities - - - - - - - - - - W - Maintain WWTP NPDES Permit parameters to 100% compliance W - Goal of zero CSO dry weather overflows for permit compliance W - Maintain CSO EmNet uptime of 90% Wastewater - Bring recommendations forward that will help combine the Water & Wastewater Departments into a Utility Department Sewers - Challenged by aging infrastructure, which increases digs and infaltration Wastewater - Maintained WWTP NPDES Permit parameters to 100% compliance Wastewater - Maintained CSO EmNet uptime above 90% Wastewater - Had ten CSO dry weather overflows in 2016 Sewers - 35 mainline digs YTD Sewers - Reduced mainline back-ups vs 2016 Excellent Services & Efficient Processes - Maintain CSO EmNet uptime at 90% Sewer- Double the mileage of sewer lines filmed vs. 2017; Also film lines we are currently not capable of filming. Safe Community for Everyone - Goal of zero CSO dry weather overflows for permit compliance Robust & Well Planned Infrastructure - Maintain WWTP NPDES Permit parameters to 100% compliance 191 City of South Bend, Indiana 2018 Budget Fund 641 - Sewage Works 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 Director of Utilities 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Assistant Director of Utilities 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Director of Wastewater Maintenance 0.9 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager-Maintenance 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager-Operations 1.0 1.0 1.0 2.0 2.0 2.0 2.0 2.0 Superintendent V 0.9 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager-Environmental Compliance 0.5 0.5 0.5 1.0 1.0 1.0 1.0 1.0 Director of Financial Services 1.0 - - - - - - - Industrial Pretreatment Specialist I 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager-Industrial Pretreatment 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director of Utility Safety 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Chemist 2.3 2.3 2.3 2.3 2.3 2.3 2.3 2.3 Chemist Lead 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 Assistant City Engineer 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director of SCADA Information Syst.0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Systems Specialist IV 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Manager-Utility Purchasing & Storeroom 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 Administrative Assistant I 1.9 1.9 1.9 2.0 2.0 2.0 2.0 2.0 SCADA Instrument Specialist 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director of Water Quality & Lab 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Director of CSO Project Management 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Supervisor-Operations 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director of Streets 0.4 0.4 0.4 0.4 0.4 0.4 0.4 0.4 Manager of Sewer Operations 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 Superintendent V 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Superintendent III 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Financial Specialist Senior 0.4 0.4 0.4 0.4 0.4 0.4 0.4 0.4 Accounting Clerk IV 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 Administrative Assistant I 0.4 0.4 0.4 0.4 0.4 0.4 0.4 0.4 Total Non-Bargaining 25.1 24.3 24.3 25.9 25.9 25.9 25.9 25.9 Bargaining Lead Operator 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Senior Operator 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 General Operator 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Maintenance Lead 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Maintenance Repair IV 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 Maintenance Electrician V 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Sanitation Operator 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Lift Station Rep. II 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 CSO Rep II 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 General Laborer 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Job Leader 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 Equipment Operator II 8.0 7.0 7.0 7.0 7.0 7.0 7.0 7.0 Equipment Operator III 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 Heavy Equipment Operator I 7.0 7.0 7.0 7.0 7.0 7.0 7.0 7.0 Heavy Equipment Operator II 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 General Labor`0.4 0.4 0.4 0.4 0.4 0.4 0.4 0.4 Concrete Finishers 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Total Bargaining 62.4 62.4 62.4 62.4 62.4 62.4 62.4 62.4 Total Full-Time Employees 87.5 86.7 86.7 88.3 88.3 88.3 88.3 88.3 Explain Significant Staffing Changes Below: 192 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSEWAGE OPER & MAINT FUND641-0000-344.01-10 METERED SALES-RESIDENTIAL 17,469,352 18,406,177 18,385,415 18,385,415 11,505,637 9,230,555 18,385,415LEVEL TEXTTEXT AMT02 NO INCREASE OVER 2017 METERED RATE18,385,41518,385,415641-0000-344.01-20 METERED SALES-COMMERCIAL 5,953,485 6,785,273 6,250,000 6,250,000 4,089,564 3,308,712 6,400,000LEVEL TEXTTEXT AMT02 NO INCREASE OVER 2017 METERED RATE, ACTUAL REVENUE 6,400,000RUNNING HIGHER THAN EXPECTED IN 2017.6,400,000641-0000-344.01-30 INDUSTRIAL5,240,191 5,705,662 5,200,000 5,200,000 3,368,097 2,576,512 5,300,000LEVEL TEXTTEXT AMT02 NO METERED RATE INCREASE FROM 2017.5,300,0005,300,000641-0000-344.01-40 METERED SALES-MULTI FAMLY 2,624,546 2,743,499 2,712,983 2,712,983 1,642,432 1,357,598 2,712,000LEVEL TEXTTEXT AMT02 NO INCREASE OVER 2017 METERED RATE2,712,0002,712,000641-0000-344.01-60 INSTITUTIONAL277,303 300,940 300,692 300,692 178,286 143,952 300,000LEVEL TEXTTEXT AMT02 NO INCREASE OVER 2017 METERED RATE300,000300,000641-0000-344.03-00 SEWER-PUBLIC AUTHORITIES 1,005,319 1,049,439 950,000 950,000 622,434 501,645 980,000LEVEL TEXTTEXT AMT02 NO INCREASE BUDGETED. SLIGHT INCREASE OVER 2017980,000BUDGET FOLLOWS REVENUE TREND.980,000641-0000-344.05-20 WHLSL METER- NEW CARLISLE 184,603 188,058 182,000 182,000 131,437 97,788 182,000LEVEL TEXTTEXT AMT02 NO RATE INCREASE FOR 2018 BUDGETED.182,000182,000641-0000-344.07-10 PENALTIES (FORFEIT DISC.) 655,547 653,258 600,000 600,000 397,845 330,800 650,000LEVEL TEXTTEXT AMTFund 641 - Wastewater Operations & MaintenanceCity of South BendRevenue193 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue02 METHOD OF ASSESSING PENALTIES CHANGED.650,0002018 ESTIMATE BASED ON 2017 ACTUAL RECEIPTS650,000641-0000-344.07-12 DUMPING FEES25,651 21,071 12,000 12,000 9,581 9,581 12,000LEVEL TEXTTEXT AMT02 REVENUE ESTIMATE BASED ON 2017 RECEIPTS.12,00012,000641-0000-344.07-13 ORGANIC RESOURCES60,440 92,350 80,000 80,000 57,077 49,192 80,000LEVEL TEXTTEXT AMT02 LABOR CHARGE TO LOAD REQUESTED MULCH OR COMPOST,80,000AND FEE TO DUMP YARD WASTE AT ORGANIC RESOURCESBASED ON 2017 REVENUE.80,000641-0000-344.07-14 LABORATORY SERVICE FEES 98,326 1,485 2,154 2,1547474 2,000LEVEL TEXTTEXT AMT02 VARIOUS FEES FOR LABORATORY WATER TESTING-2,000CITY POOLS $ 1,000MISC. TESTS $ 1,0002,000641-0000-344.07-16 DISCHARGE PERMIT FEES3,500 10,500 3,500 3,50000 3,500LEVEL TEXTTEXT AMT02 $500 EACH INDUSTRIAL RENEWAL FEE (7 X 500)3,5003,500641-0000-344.07-18 SYSTEM DEVELOPMENT FEE0 1,14500 87,234 60,937 100,000LEVEL TEXTTEXT AMT02 NEW FEE STARTED IN 2017. BUDGET ESTIMATE FOR 2018100,000BASED ON 2017 REVENUE TREND.100,000641-0000-344.07-54 MISC. SEWAGE REVENUES216,231 148,710 150,000 150,000 110,884 84,759 150,000LEVEL TEXTTEXT AMT02 2018 ESTIMATE BASED ON HISTORICAL REVENUE.150,000150,000------------ ------------ ------------ ------------ ------------ ------------ ------------*33,814,494 36,107,567 34,828,744 34,828,744 22,200,582 17,752,105 35,256,915Fund 641 - Wastewater Operations & MaintenanceCity of South BendRevenue194 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue641-0000-360.00-00 MISCELLANEOUS REVENUE28 1,545 1,000 1,000 2,221 2,021 1,000LEVEL TEXTTEXT AMT02 SMALL, UNFORSEEN RECEIPTS.1,0001,000641-0000-360.02-00 SALE OF SCRAP METAL668 2,024 4,000 4,000701211 4,000LEVEL TEXTTEXT AMT02 SALE OF ACCUMULATED METALS AT WASTEWATER PLANT4,000BASED ON PRIOR YEAR RECEIPTS.4,000641-0000-360.51-00 INSURANCE REIMBURSEMENT8,983 16,00700 10,439 10,4390------------ ------------ ------------ ------------ ------------ ------------ ------------*9,679 19,576 5,000 5,000 13,361 12,671 5,000641-0000-361.00-00 INTEREST EARNINGS45,346 102,607 65,000 65,000 82,696 64,704 100,000LEVEL TEXTTEXT AMT02 BASED ON 2017 REVENUE TREND.100,000100,000------------ ------------ ------------ ------------ ------------ ------------ ------------*45,346 102,607 65,000 65,000 82,696 64,704 100,000641-0000-380.10-04 REIMBURSEMENTS/EXTENSIONS 4,028 8,41700 1,324 1,200 3,000LEVEL TEXTTEXT AMT02 BASED ON 2017 RECEIPTS.3,0003,000641-0000-380.10-99 MISC. REIMBURSEMENTS24,169134 4,000 4,000800800 4,000LEVEL TEXTTEXT AMT02 BASED ON HISTORICAL RECEIPTS. SAME AS 2017 BUDGET.4,0004,000------------ ------------ ------------ ------------ ------------ ------------ ------------*28,197 8,551 4,000 4,000 2,124 2,000 7,000641-0000-392.00-00 INTERFUND OPER. TRANSFER 23,677 35,808 30,000 30,000 27,453 20,893 230,000LEVEL TEXTTEXT AMT02 INTEREST EARNED IN FUND 643; TRANSFERRED TO 64130,000TRANSFER FROM ACCT #643-0630-415.50-02NEW IN 2018, OPERATION RE-LEAF TO COVER A PORTION200,000OF THE COSTS ASSOCIATED WITH RECEIVING LEAVESFund 641 - Wastewater Operations & MaintenanceCity of South BendRevenue195 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueCOLLECTED WITHIN THE CITY AND PROCESSED INTOCOMPOST. TRANSFER OUT FROM FUND #655.230,000------------ ------------ ------------ ------------ ------------ ------------ ------------*23,677 35,808 30,000 30,000 27,453 20,893 230,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWAGE OPER & MAINT FUND33,921,393 36,274,109 34,932,744 34,932,744 22,326,216 17,852,372 35,598,915Fund 641 - Wastewater Operations & MaintenanceCity of South BendRevenue196 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue641-0621-360.02-00 SALE OF SCRAP METAL3,303 2,972 2,500 2,500 2,452 2,452 2,500LEVEL TEXTTEXT AMT02 SALE OF ACCUMULATED SCRAP METAL AT SEWER DEPT.2,500SAME AS 2017 BUDGET.2,500------------ ------------ ------------ ------------ ------------ ------------ ------------*3,303 2,972 2,500 2,500 2,452 2,452 2,500641-0621-391.01-00 SALE OF FIXED ASSETS506 14,14500000------------ ------------ ------------ ------------ ------------ ------------ ------------*506 14,14500000------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWER DEPARTMENT3,809 17,117 2,500 2,500 2,452 2,452 2,500Fund 641 - Wastewater Operations & MaintenanceCity of South BendRevenue197 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue641-0625-344.07-55 INTERFUND REVENUE31,342 21,281 29,500 29,500 1,076 1,076 16,695LEVEL TEXTTEXT AMT02 ESTIMATED CONCRETE CREW LABOR TO BE REIMBURSED16,695BY WATER WORKS THROUGH INTER-FUND BILLING2018: BASED ON ACTUAL 2017 1ST QTR BILLING16,695------------ ------------ ------------ ------------ ------------ ------------ ------------*31,342 21,281 29,500 29,500 1,076 1,076 16,695641-0625-360.86-00 SEWER CONCRT UTIL CUT MAT 54,042 28,870 45,000 45,000 1,965 1,965 38,475LEVEL TEXTTEXT AMT02 MATERIAL FOR CONCRETE/SEWER CUT REPAIRS FOR WATER38,475WORKS. SEWERS/SEWER INSURANCE PAY FROM OWN FUND2018: BASED ON ACTUAL 2017 1ST QTR BILLING38,475------------ ------------ ------------ ------------ ------------ ------------ ------------*54,042 28,870 45,000 45,000 1,965 1,965 38,475------------ ------------ ------------ ------------ ------------ ------------ ------------** CONCRETE CREW85,384 50,151 74,500 74,500 3,041 3,040 55,170Fund 641 - Wastewater Operations & MaintenanceCity of South BendRevenue198 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue641-0630-391.01-00 SALE OF FIXED ASSETS0 3,31200000------------ ------------ ------------ ------------ ------------ ------------ ------------*03,31200000------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT0 3,31200000Fund 641 - Wastewater Operations & MaintenanceCity of South BendRevenue199 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue641-0631-391.01-00 SALE OF FIXED ASSETS23 6,67000000------------ ------------ ------------ ------------ ------------ ------------ ------------*23 6,67000000------------ ------------ ------------ ------------ ------------ ------------ ------------** ORGANIC RESOURCES23 6,67000000Fund 641 - Wastewater Operations & MaintenanceCity of South BendRevenue200 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue641-0650-344.01-10 METERED SALES-RESIDENTIAL 1,147,351 1,208,706 1,233,948 1,233,948 700,484 598,798 1,233,000LEVEL TEXTTEXT AMT02 NO INCREASE OVER 2017 METERED RATE1,233,0001,233,000641-0650-344.01-20 METERED SALES-COMMERCIAL 535,166 608,918 537,997 537,997 355,742 298,862 537,000LEVEL TEXTTEXT AMT02 NO INCREASE OVER 2017 METERED RATE537,000537,000641-0650-344.01-40 METERED SALES-MULTI FAMLY 358,661 386,735 374,215 374,215 216,564 188,107 374,000LEVEL TEXTTEXT AMT02 NO INCREASE OVER 2017 METERED RATE374,000374,000641-0650-344.07-10 PENALTIES (FORFEIT DISC.) 20,375 14,398 16,000 16,000 7,983 6,618 16,000LEVEL TEXTTEXT AMT02 SAME AS 2017 BUDGET.16,00016,000------------ ------------ ------------ ------------ ------------ ------------ ------------*2,061,553 2,218,757 2,162,160 2,162,160 1,280,773 1,092,386 2,160,000------------ ------------ ------------ ------------ ------------ ------------ ------------** CLAY SEWAGE2,061,553 2,218,757 2,162,160 2,162,160 1,280,773 1,092,386 2,160,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE OPER & MAINT FUND36,072,162 38,570,116 37,171,904 37,171,904 23,612,482 18,950,250 37,816,585Fund 641 - Wastewater Operations & MaintenanceCity of South BendRevenue201 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSEWAGE OPER & MAINT FUND641-0621-792.10-01 REGULAR WAGES275,860 350,282 480,683 480,683 250,145 217,971 494,168LEVEL TEXTTEXT AMT02 DIRECTOR OF STREETS - 84,793.00 - 40%33,917MANAGER OF SEWER OPS - 62,944.00 - 70%44,061SUPERINTENDENT V57,566SUPERINTENDENT V57,566SUPERINTENDENT III (SWEEPER FOREMAN)52,442*ADMINISTRATIVEASSISTANTI-40,525.00-30%11,178*ADMINISTRATIVE ASSISTANT II - 41,724.00 - 40%16,690*DIR-FINANCIAL SVCS - 62,132.00 - 35%21,747DIRECTOR OF PUBLIC WORKS - 119,5151.00 - 12%14,342DEPUTY DIRECTOR OF PUBLIC WORKS - 97,419.00 - 12%11,690CITY ENGINEER - 104,336.00 - 14%14,607ASSISTANT CITY ENGINEER - 83,890.00 - 14%11,745ADMINISTRATIVE ASSISTANT II - 41,724.00 - 14%5,841ENGINEER I - 67,917.00 - 14%9,508ENGINEER I - 67,917.00 - 5%3,396ENGINEER I - 67,917.00 - 14%9,508ENGINEER I - 67,917.00 - 14%9,508EXEC ASST/DIR OF SPECIAL PROJ - 54,168.00 - 32%17,334MANAGER, PUBLIC CONSTRUCTION - 67,725.00 - 14%9,481PERMITS MANAGER - 49,425.00 - 14%6,920PROJECT INSPECTOR - 54,195.00 - 14%7,587PROJECT INSPECTOR - 54,195.00 - 14%7,587PROJECT INSPECTOR - 54,195.00 - 14%7,587ADMINISTRATIVE ASSISTANT I - 40,525.00 - 14%5,673LOCATOR - 43,042.00 - 50%21,521ASSISTANT CITY ENGINEER - 83,890.00 - 5%4,195ENGINEER 1 - 67,917.00 - 67,917.00 - 14%9,508*DIR OF INFORMATION SYSTEMS - 83,000.00 - 14%11,620PUBLIC INFORMATION OFFICER - 65,704.00 - 14%9,199SALARY ALLOWANCE9,356-494,168641-0621-792.10-02 HOURLY WAGES1,083,940 1,091,782 1,176,478 1,176,478 656,234 564,448 1,179,332LEVEL TEXTTEXT AMT02 5 JOB LEADERS (5 X 20.68 X 2080)215,07210 HEAVY EQUIP OP I (10 X 19.18 X 2080)398,9444 EQUIP OP III (4 X 18.49 X 2080) - VACTORS153,8375 EQUIP OP II (5 X 17.80 X 2080)185,1205 EQUIP OPER III (5 X $18.49 X 2080) - SWEEPERS192,2961 GENERAL LABORER @ 16.31 (PD @ 40%/60% STREETS)14,927CERTIFICATIONSCOLLECTION SYSTEM CERT (29 X .25 X 2080)15,080COLLECTION SYSTEM CERT (1 X .45 X 2080)936Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures202 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresCOLLECTION SYSTEM CERT (5 X .30 X 2080)3,120TOTAL STAFF: 29.4 FTE1,179,332641-0621-792.10-03 SEASONAL & INTERNS32,218 25,287 29,920 29,920 9,581 8,473 32,460LEVEL TEXTTEXT AMT02 SUMMER HELP - APPROX APRIL - SEPTEMBER24,9602 X 26 WKS X 40 HRS X 12.00/HRENGINEERING INTERNS7,50032,460641-0621-792.10-04 EXTRA AND OVERTIME166,229 155,361 156,055 156,055 40,824 37,766 173,572LEVEL TEXTTEXT AMT02 BASED ON AVERAGE 2013 - 2016173,5722017 - ADD 3RD DT PLOWING HOLIDAY173,572641-0621-792.10-06 LONGEVITY PAY00 3,850 3,850 2,250 2,100 3,250LEVEL TEXTTEXT AMT02 NEW IN 2017 - BASED ON YEARS OF SERVICE3,2503,250641-0621-792.10-09 PERMANENT PART-TIME63,490 76,206 100,851 100,851 42,492 37,324 100,912LEVEL TEXTTEXT AMT02 5 P/T EMPLOYEES - 29 HRS/WEEK29HRSX52WKS=1508HRS/YRX5X12.24/HR92,290ENGINEERING ALLOCATIONSP/T CITY ENGINEER - 44,822.00 - 14%6,275P/T SECRETARY V - 16,765.00 - 14%2,347FTE: 3.93100,912641-0621-792.10-13 STAND BY PAY125,281 73,150 98,505 98,505 48,245 43,891 99,012LEVEL TEXTTEXT AMT02 BACK-UP STAND BY: JOB LDR 20.68 X 32 HRS X 52 WKS34,412VACTOROPSTANDBY:HEOPI19.18X32HRSX52WKS 31,683SNOW CONTROL:HEOPI-11EMPX19.18X6HRSX18WKS22,786DAY STAND BY:OPIIISWPR-2EMPX18.49X3HRSX36DAYS3,994NIGHT STAND BY:OPIIISWPR-3EMPX18.49+.45NPX3HRSX36DAY6,13799,012Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures203 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0621-792.10-14 PRODUCTIVITY BONUS6,683 13,26200000LEVEL TEXTTEXT AMT02 REPLACED IN 2017 W/JOB READINESS ALLOWANCESEE 641-0621-792.11-27641-0621-792.11-01 FICA - REGULAR130,798 131,909 157,031 157,031 78,766 68,579 159,844LEVEL TEXTTEXT AMT02 ALL WAGES X 7.65%159,328CELL PHONE ALLOWANCE 5,175.00 X 7.65%397AUTO ALLOWANCE 930.00 X 7.65%119159,844641-0621-792.11-04 PERF - REGULAR185,436 187,545 214,544 214,544 111,736 97,034 218,326LEVEL TEXTTEXT AMT02 ALL FULL TIME WAGES X 11.20%218,326218,326641-0621-792.11-05 PERF - UNION00 21,711 21,711 11,189 9,707 22,015LEVEL TEXTTEXT AMT02 NEW IN 2017 - CITY WILL CONTRIBUTE 1.5% OFTEAMSTERS 3% MANDATED PERF22,01522,015641-0621-792.11-07 UNEMPLOYMENT COMP4,873 2,363 5,116 5,116000LEVEL TEXTTEXT AMT02 NOT CHARGING IN 2018641-0621-792.11-08 HEALTH INSURANCE342,275 434,563 567,580 567,580 295,129 254,163 615,500LEVEL TEXTTEXT AMT02 LONG TERM DISABILITY:37.77 EMP X 4.00 X 24 PAY PERIODS3,626HEALTH COVERAGE:37.77 EMP X 675.00 X 24 PAY PERIODS611,874RATE INCREASED FROM 648.00 IN 2017615,500641-0621-792.11-09 LIFE INSURANCE3,640 3,866 4,568 4,568 2,410 2,073 4,550LEVEL TEXTTEXT AMT02 37.77 EMP X 5.00 X 24 PAY PERIODS4,5504,550641-0621-792.11-10 CLOTHING ALLOWANCE7,159 7,19800000Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures204 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 REPLACED IN 2017 W/JOB READINESS ALLOWANCESEE 641-0621-792.11-27641-0621-792.11-12 VEH/TOOL ALLOWANCE1,440978 1,230 1,230473405 1,554LEVEL TEXTTEXT AMT02 DIRECTOR OF PUBLIC WORKS - 6,000.00 - 12%720DEPUTY DIRECTOR OF PUBLIC WORKS - 2,400.00 - 12%288CITY ENGINEER - 2,400.00 - 14%336ASST CITY ENGINEER - 1,500.00 - 14%2101,554641-0621-792.11-24 CELL PHONE ALLOWANCE3,152 4,069 5,088 5,088 2,530 2,239 5,182LEVEL TEXTTEXT AMT02 DIRECTOR OF STREETS264MANAGER OF SEWER OPERATIONS462SUPERINTENDENT V - 2 X 660.001,320SUPERINTENDENT III660JOB LEADERS - 2 X 660.001,320ENGINEERING ALLOCATIONSDIRECTOR OF PUBLIC WORKS - 660.00 - 12%80CITY ENGINEER - 660.00 - 14%93DEPUTY DIRECTOR OF PUBLIC WORKS - 660.00 - 12%80ASST CITY ENGINEER - 660.00 - 14%93ENGINEER I - 660.00 - 14%93ENGINEER I - 660.00 - 14%93ENGINEER I - 660.00 - 14%93ENGINEER I - 660.00 - 14%33PUBLIC CONSTRUCTION MANAGER - 660.00 - 14%93PROJECT INSPECTOR - 660.00 - 14%93PROJECT INSPECTOR - 660.00 - 14%93PROJECT INSPECTOR - 660.00 - 14%93ASST CITY ENGINEER - 660.00 - 5%33DIR OF INFORMATION SYSTEMS - 660.00 - 14%935,182641-0621-792.11-27 JOB READINESS ALLOWANCE00 12,495 12,495 12,495 12,495 12,495LEVEL TEXTTEXT AMT02 NEW IN 2017 - REPLACES PRODUCTION BONUS & SHOEALLOWANCE - 29.4 EMPLOYEES X 425.0012,49512,495641-0621-792.11-29 PARENTAL LEAVE000000 5,207LEVEL TEXTTEXT AMTFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures205 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 NEW IN 2018 - PARENTAL LEAVE - ALL WAGES X .25%5,2075,207641-0621-792.11-99 OTHER FRINGE BENEFITS2,2100 4,000 4,00000 4,000LEVEL TEXTTEXT AMT02 TEAMSTER 457 PLAN MATCHING BENEFIT4,0004,000------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES2,434,684 2,557,821 3,039,705 3,039,705 1,564,499 1,358,668 3,131,379641-0621-792.21-02 PRINT SHOP3,668175750750217217750LEVEL TEXTTEXT AMT02 SUPPLIES - FORMS, LETTERHEAD, ETC750750641-0621-792.21-03 C.S. OFFICE SUPPLIES17646760060000600LEVEL TEXTTEXT AMT02 COPY PAPER - ALL OTHER SUPPLIES FROM OFFICE MAX600600641-0621-792.21-04 OTHER OFFICE SUPPLIES810839 2,500 2,765563503 2,500LEVEL TEXTTEXT AMT02 OFFICE SUPPLIES2,5002,500641-0621-792.22-02 DIESEL FUEL112,564 104,357 147,360 147,360 53,683 46,068 144,395LEVEL TEXTTEXT AMT02 CS RECOMMENDATION144,39557,758 GAL X 2.50/GAL144,395641-0621-792.22-05 UNIFORMS8,367 7,816 9,328 10,437 4,942 4,248 9,328LEVEL TEXTTEXT AMT02 UNIFORMS, T-SHIRTS, CINTAS FOR UNIFORMS9,3289,328641-0621-792.22-06 COMPUTER SUPPLIES0526 1,500 1,500644325 1,500LEVEL TEXTTEXT AMT02 INK CARTRIDGES, MISC COMPUTER SUPPLIES1,5001,500Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures206 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0621-792.22-21 C.S. CLEANING SUPPLIES1,196 1,480 1,500 1,500696696 1,500LEVEL TEXTTEXT AMT02 JANITORIAL SUPPLIES AS NEEDED1,5001,500641-0621-792.22-22 MEDICAL/SAFETY SUPPLIES3,257 3,205 3,300 3,300 2,217 2,217 3,300LEVEL TEXTTEXT AMT02 SAFETY CLOTHING, SAFETY TRIPODS & WENCHES, SAFETY3,300METERS.3,300641-0621-792.22-24 OTHER OPERATING SUPPLIES4,860 6,257 43,000 46,669 7,776 6,430 43,000LEVEL TEXTTEXT AMT02 WILDFLOWER SUPPLIES & EQUIPMENTMISC CONSTRUCTION SUPPLIES & EQUIPMISC MAINTENANCE SUPPLIES & EQUIPJET RODDER SUPPLIES, CHEMICALS.TOOLS & EQUIPMENTMISC SAFETY EQUIPMENT/CONFINED SPACE EQUIPMENT43,00043,000641-0621-792.23-01 BUILDING MATERIALS809 2,05601132211110LEVEL TEXTTEXT AMT02 MOVED TO OTHER OPERATING SUPPLIES 22-24 IN 2017641-0621-792.23-02 STREET MATERIAL112,379 127,186 235,000 273,353 78,860 48,708 235,000LEVEL TEXTTEXT AMT02 RISERS, CASTINGS, STRUCTURES, AGGREGATE,CONCRETE/ASPHALT SURFACE PATCH MATERIAL235,000235,000641-0621-792.23-03 SEWER CONST. MATERIALS15,119 77,131 130,000 130,620 17,522 9,710 130,000LEVEL TEXTTEXT AMT02 ALL CONSTRUCTION SUPPLIES. BASED ON HISTORICAL130,000TRENDS130,000641-0621-792.23-04 SEWER MAINT MATERIALS2,912 1,473 175,000 175,000 1,977 1,995 175,000LEVEL TEXTTEXT AMT02 MAINTENANCE SUPPLIES, ROOT CONTROL,MAIN LINE REPAIRS/SEWER LATERAL PREVENTATIVEFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures207 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresMAINTENANCE, UNEXPECTED REPAIRS175,000175,000641-0621-792.23-10 REPAIR PARTS1,3805330614000LEVEL TEXTTEXT AMT02 MOVED TO 22-24 IN 2017641-0621-792.23-20 SMALL TOOLS & EQUIPMENT7,601 25,406 30,000 30,944 5,051 4,873 30,000LEVEL TEXTTEXT AMT02 TILE SAWS, WEED EATERS, HAND MOWERS FOR WEEDPROGRAM AND OTHER SMALL TOOLSSEWER CAMERA VIEWING TOOLS/CAMERA30,00030,000641-0621-792.23-40 SALT & WINTER MATERIALS 78,2260 126,000 182,180 33,673 33,673 117,600LEVEL TEXTTEXT AMT02 NEW SALT REIMBURSEMENT IN 2011 BUDGET FROM SEWER117,600DEPARTMENT FUND 641. IN 2013, SALT EXPENSEDDIRECTLY TO SEWER DEPARTMENT BASED ON SBOA FORMULAPER SBOA, COST OF SALT TO BE SHARED BY FUNDS 641AND 202.117,600641-0621-792.23-99 OTHER R&M SUPPLIES2,430 1,39600000LEVEL TEXTTEXT AMT02 N/A IN 2017 - MOVED TO 22-24------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES355,754 360,303 905,838 1,007,705 208,042 159,774 894,473641-0621-792.31-01 LEGAL SERVICES3860 1,000 13,536 11,536 11,536 1,000LEVEL TEXTTEXT AMT02 NEW IN 2015 - LEGAL FEES1,0001,000641-0621-792.31-70 ADM FEE ALLOCATION151,223 166,992 253,357 253,357 147,791 126,678 248,681LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #1248,681ADMINISTRATIVE FEE248,681641-0621-792.31-71 CENTRAL STORES ALLOCATION 4,035 3,912 3,356 3,360 1,960 1,680 7,978LEVEL TEXTTEXT AMTFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures208 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 2018 FIXED COST ALLOCATION #37,978CENTRAL STORES7,978641-0621-792.31-72 GIS ALLOCATION21,623 22,70400000LEVEL TEXTTEXT AMT02 IN 2017 - MOVED TO IT ALLOCATION #7641-0621-792.31-73 PRINT SHOP ALLOCATION0 3,084 2,117 2,117 1,232 1,056 2,449LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #42,449PRINT SHOP2,449641-0621-792.31-75 311 CALL CENTER ALLOC0 5,49200000LEVEL TEXTTEXT AMT02 2016 FIXED COST ALLOCATION311 CALL CENTERIN 2017 - MOVED TO IT ALLOCATION #7641-0621-792.31-76 IT ALLOCATION000000 383,406LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #7383,406INFORMATION TECHNOLOGYNEW IN 2017 - INCLUDES 311, VOIP, GIS & TECHNOLOGY383,406641-0621-792.32-04 TELEPHONE3,089 2,758 1,800 2,216 1,357955 2,412LEVEL TEXTTEXT AMT02 TELEPHONE - MOVED TO IT ALLOCATION #7 IN 2017CELL PHONES/I-PADS2,4122,412641-0621-792.32-21 TRAVEL - MILEAGE0030030000500LEVEL TEXTTEXT AMT02 APWA CONFERENCE, PUMPER SHOW500500641-0621-792.32-22 TRAVEL - AIRFARE000000 1,500LEVEL TEXTTEXT AMT02 APWA CONFERENCE, PUMPER SHOW1,5001,500Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures209 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0621-792.32-23 TRAVEL - HOTEL6510 1,500 1,500195195 1,500LEVEL TEXTTEXT AMT02 APWA CONFERENCE, PUMPER SHOW, MISCELLANEOUS1,5001,500641-0621-792.32-24 TRAVEL - MEALS3270 1,000 1,0005555 1,500LEVEL TEXTTEXT AMT02 APWA CONFERENCE, PUMPER SHOW, MISCELLANEOUS1,5001,500641-0621-792.32-25 TRAVEL - OTHER2502002005656400LEVEL TEXTTEXT AMT02 APWA CONFERENCE, PUMPER SHOW, MISCELLNEOUS400400641-0621-792.33-02 PUBLICATION LEGAL NOTICE3042243003735353600LEVEL TEXTTEXT AMT02 PUBLIC WORKS BID ANNOUNCEMENTS600600641-0621-792.34-02 LIABILITY INSURANCE97,356 99,756 110,264 110,268 64,323 55,134 118,809LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #5118,809LIABILITY INSURANCE118,809641-0621-792.35-01 ELECTRIC15,908 15,764 19,685 19,685 7,470 7,470 19,685LEVEL TEXTTEXT AMT02 BASED ON HISTORICAL INFO19,68519,685641-0621-792.35-02 GAS13,115 9,944 15,675 15,675 10,351 10,333 15,675LEVEL TEXTTEXT AMT02 2016 BUDGET - 14,250.00 + 10%15,67515,675641-0621-792.35-03 TRASH REMOVAL0079279200792LEVEL TEXTTEXT AMT02 NEW IN 2017 - SOLID WASTE WILL CHARGE FOR TRASHPICK UP FROM CITY DEPARTMENTSFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures210 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresESTIMATED 150.00/MO = 1,800.00/YR @ 44%792792641-0621-792.35-04 WATER6,126 6,042 5,458 5,458 3,340 2,832 6,400LEVEL TEXTTEXT AMT02 BASED ON TRENDS6,4006,400641-0621-792.36-01 BUILDING R&M18,801 20,914 51,095 51,152 12,797 11,686 50,937LEVEL TEXTTEXT AMT02 PEST CONTROL; ANNUAL SPRINKLER/FIRE EXTINGUISHERINSPECTIONS; MONTHLY ALARM MONITORING; BUILDING &HVAC REPAIRS; ROOF REPAIRS - STORM DAMAGE44% OF PWSC BUILDING EXPENSE50,93750,937641-0621-792.36-02 OFFICE EQUIP R&M1,824 1,995 3,206 3,206 1,699 1,676 3,206LEVEL TEXTTEXT AMT02 COPIER EXPENSES, OTHER OFFICE EQUIPMENT3,2063,206641-0621-792.36-03 AUTO EQUIPMENT R&M517,471 481,925 484,610 484,610 329,994 287,150 494,537LEVEL TEXTTEXT AMT02 AVGP&L2014-2016494,537494,537641-0621-792.36-04 COMPUTER EQUIP R&M1,965 2,088 33,108 33,108 19,313 16,5540641-0621-792.36-05 OTHER EQUIP R&M6,180 5,679 8,900 8,900156103 3,500LEVEL TEXTTEXT AMT02 EQUIPMENT REPAIR NOT AVAILABLE @ CENTRAL SERVICES3,5003,500641-0621-792.36-06 RADIO EQUIP R&M4,296 2,478 5,063 5,063 6,333 6,333 11,420LEVEL TEXTTEXT AMT02 RADIO REPAIR BASED ON ACTUAL USE11,42011,420641-0621-792.36-07 COLLECTION SYSTEM0 20,000 30,000 30,000 5,793 4,592 10,000LEVEL TEXTTEXT AMT02 SEWER LATERAL/MAIN LINE PREVENTATIVE MAINTENANCE10,00010,000Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures211 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0621-792.36-10 HAZARDOUS WASTE DISPOSAL 73,262 77,882 82,400 82,400 35,837 26,399 84,875LEVEL TEXTTEXT AMT02 SWEEPER DIRT TIPPING FEES84,87584,875641-0621-792.37-02 CAPITAL LEASE PAYMENTS8,5000 30,000 28,019 4,0500 30,000LEVEL TEXTTEXT AMT02 SMALL EXCAVATOR - AS NEEDED30,00030,000641-0621-792.37-11 CAPITAL LEASE PRINCIPAL 186,351 195,526 184,147 184,147 160,466 98,802 102,321LEVEL TEXTTEXT AMT02 2013 CAPITAL LEASE - DEBT SCHEDULE 11047,7792014 CAPITAL LEASE - DEBT SCHEDULE 12447,7492015 CAPITAL LEASE - DEBT SCHEDULE 1406,793102,321641-0621-792.37-12 CAPITAL LEASE INTEREST9,006 6,948 4,196 4,196 3,264 2,436 2,009LEVEL TEXTTEXT AMT02 2013 CAPITAL LEASE - DEBT SCHEDULE 1104382014 CAPITAL LEASE - DEBT SCHEDULE 1241,3082015 CAPITAL LEASE - DEBT SCHEDULE 1402632,009641-0621-792.39-10 SUBSCRIPTIONS0010010000100LEVEL TEXTTEXT AMT02 APWA/SEWER PUBLICATIONS100100641-0621-792.39-11 DUES & MEMBERSHIPS00 1,000 1,00000 1,000LEVEL TEXTTEXT AMT02 DUES, PROFESSIONAL FEES1,0001,000641-0621-792.39-70 EDUCATION & TRAINING8,360 2,350 4,500 4,500 1,105 1,105 7,500LEVEL TEXTTEXT AMT02 STATE CERTIFICATIONS F/COLLECTION SYS7,500COMPUTER CLASSESSEMINARS/TRAINING - APWAOTHER TRAININGFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures212 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures7,500641-0621-792.39-89 MISC CHARGES & SVCS1,843 5,603 10,000 10,15800 10,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS UNPLANNED EXPENSES10,00010,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES1,152,027 1,160,060 1,349,129 1,360,396 830,526 674,869 1,624,692641-0621-792.63-35 CONTRACTUAL SERVICE-OTHER 32,213 468,164 1,927,500 3,669,478 424,272 411,726 2,497,357LEVEL TEXTTEXT AMT02 MAIN LINE REPAIR, SEWER LINING/MANHOLE REPAIR2,347,357LTCP GSI PROJECTS150,0002,497,357641-0621-792.63-70 BAD DEBT EXPENSE212,212 244,543 181,966 181,966 130,558 115,079 209,000LEVEL TEXTTEXT AMT02 AVERAGE 2014 - 2016209,000209,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES244,425 712,707 2,109,466 3,851,444 554,830 526,804 2,706,357------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWER DEPARTMENT4,186,890 4,790,891 7,404,138 9,259,250 3,157,897 2,720,115 8,356,901Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures213 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0625-792.10-01 REGULAR WAGES52,820 52,244 56,305 56,305 33,579 28,951 74,062LEVEL TEXTTEXT AMT02 DIRECTOR OF STREETS - 84,793.00 - 5%4,240*ADMINISTRATIVEASSISTANTI-40,525.00-15%6,079*ADMINISTRATIVE ASSISTANT II - 41,724.00 - 5%2,086*DIR OF FINANCIAL SVCS - 62,132.00 - 10%6,213DIR OF PUBLIC WORKS - 119,514.00 - 10%11,951DEP DIR OF PUBLIC WORKS - 97,419.00 - 10%9,742CITY ENGINEER - 104,336.00 - 2%2,087ASST CITY ENGINEER - 83,890.00 - 2%1,678ADMINISTRATIVE ASSISTANT II - 41,724.00 - 2%4,173ENGINEER I - 67,917.00 - 2%1,358ENGINEER I - 67,917.00 - 2%1,358ENGINEER I - 67,917.00 - 2%1,358ENGINEER I - 67,917.00 - 2%1,358EXEC ASST/DIR OF SPECIAL PROJ - 54,168.00 - 4%2,167MANAGER-PUBLIC CONSTRUCTION - 67,725.00 - 2%1,354PERMITS MANAGER - 49,425.00 - 2%6,920PROJECT INSPECTOR - 54,195.00 - 2%1,084PROJECT INSPECTOR - 54,195.00 - 2D%1,084PROJECT INSPECTOR - 54,195.00 - 2%1,084ADMINISTRATIVE ASST I - 40,525.00 - 2%5,674*DIR OF INFORMATION SYSTEMS - 83,000.00 - 2%1,660PUBLIC INFORMATION OFFICE - 65,704.00 - 2%1,314SALARY ALLOWANCE1,960-FTE: .8974,062641-0625-792.10-02 HOURLY WAGES79,209 99,581 126,517 126,517 60,186 50,662 126,298LEVEL TEXTTEXT AMT02 3CONCRETEFINISHERS-3X19.99X2080124,738CERTIFICATIONS: 3 X .25 X 20801,560FTE: 3.00126,298641-0625-792.10-03 SEASONAL & INTERNS070300488330 1,000LEVEL TEXTTEXT AMT02 ENGINEERING INTERNS1,0001,000641-0625-792.10-04 EXTRA AND OVERTIME11,149 10,687 16,000 16,000 1,777 1,772 15,440LEVEL TEXTTEXT AMT02 AVG 2014 - 201615,4402017 - ADD 3RD DT PLOWING HOLIDAYFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures214 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures15,440641-0625-792.10-06 LONGEVITY PAY00300300000LEVEL TEXTTEXT AMT02 NEW IN 2017 - BASED ON YEARS OF SERVICENONE UNTIL 2020641-0625-792.10-09 PERMANENT PART-TIME1,577 1,120 1,223 1,223297240 1,231LEVEL TEXTTEXT AMT02 P/T CITY ENGINEER - 44,822.00 - 2%896P/T SECRETARY V - 16,765.00 - 2%3351,231641-0625-792.10-13 STAND BY PAY8,661 6,074 10,880 10,880 1,652 1,652 5,760LEVEL TEXTTEXT AMT02 SNOWSTANDBY-19.99X2X12HRS/WKX12WKS5,7605,760641-0625-792.10-14 PRODUCTIVITY BONUS625 1,23600000LEVEL TEXTTEXT AMT02 REPLACED IN 2017 W/JOB READINESS ALLOWANCESEE 641-0625-792.11-27641-0625-792.11-01 FICA - REGULAR11,453 12,519 16,268 16,268 7,312 6,251 17,218LEVEL TEXTTEXT AMT02 ALL WAGES X 7.65%17,121CELL PHONE ALLOWANCE: 333.00 X 7.65%26AUTO ALLOWANCE: 918.00 X 7.65%7117,218641-0625-792.11-04 PERF - REGULAR17,006 18,861 23,521 23,521 10,872 9,290 24,927LEVEL TEXTTEXT AMT02 WAGES LESS P/T X 11.20%24,92724,927641-0625-792.11-05 PERF - UNION00 2,321 2,321956814 2,232LEVEL TEXTTEXT AMT02 NEW IN 2017 - CITY WILL CONTRIBUTE 1.5% OFTEAMSTERS 3% MANDATED PERF2,2322,232641-0625-792.11-07 UNEMPLOYMENT COMP462233529529000LEVEL TEXTTEXT AMTFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures215 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 NOT CHARGING IN 2018641-0625-792.11-08 HEALTH INSURANCE28,720 43,400 61,029 61,029 28,204 23,510 63,392LEVEL TEXTTEXT AMT02 LTD - 3.9 X $4.00 X 24 PAY PERIODS374HEALTH - 3.9 X 675.00 X 24 PAY PERIODS63,018RATE INCREASED FROM 648.00 IN 201763,392641-0625-792.11-09 LIFE INSURANCE323401469469239199472LEVEL TEXTTEXT AMT02 LIFE - 3.9 X $5.00 X 24 PAY PERIODS472472641-0625-792.11-10 CLOTHING ALLOWANCE62457800000LEVEL TEXTTEXT AMT02 REPLACED IN 2017 W/JOB READINESS ALLOWANCESEE 641-0621-792.11-27641-0625-792.11-12 VEH/TOOL ALLOWANCE908654690690368315918LEVEL TEXTTEXT AMT02 DIRECTOR OF PUBLIC WORKS - 6,000.00 - 10%600DEPUTY DIRECTOR OF PUBLIC WORKS - 2,400.00 - 10%240CITY ENGINEER - 2,400.00 - 2%48ASST CITY ENGINEER - 1,500.00 - 2%30918641-0625-792.11-24 CELL PHONE ALLOWANCE484484725725181154333LEVEL TEXTTEXT AMT02 DIRECTOR OF PUBLIC WORKS - 660.00 - 10%66DEPUTY DIRECTOR OF PUBLIC WORKS - 660.00 - 10%66CITY ENGINEER - 660.00 - 2%14ASST CITY ENGINEER - 660.00 - 2%14PUBLIC CONSTRUCTION MANAGER - 660.00 - 2%14ENGINEER I - 660.00 - 2%14ENGINEER I - 660.00 - 2%14ENGINEER I - 660.00 - 14%14ENGINEER I - 660.00 - 2%14PROJECT INSPECTOR - 660.00 - 2%14PROJECT INSPECTOR - 660.00 - 2%14PROJECT INSPECTOR - 660.00 - 2%14DIRECTOR OF STREETS - 660.00 - 5%33ENGINEER I - 660.00 - 2%14DIR OF INFORMATION SYSTEMS - 660.00 - 2%14333Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures216 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0625-792.11-27 JOB READINESS ALLOWANCE00 1,275 1,275850850 1,275LEVEL TEXTTEXT AMT02 NEW IN 2017 - REPLACES PRODUCTION BONUS & SHOEALLOWANCE - 3 EMPLOYEES X 425.001,2751,275641-0625-792.11-29 PARENTAL LEAVE000000560LEVEL TEXTTEXT AMT02 PARENTAL LEAVE - ALL WAGES X .25%560560641-0625-792.11-99 OTHER FRINGE BENEFITS200000000------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES214,221 248,775 318,052 318,052 146,961 124,990 335,118641-0625-792.22-02 DIESEL FUEL9,496 3,301 6,300 6,300 1,640 1,408 7,960LEVEL TEXTTEXT AMT02 TRUCKS 431/465 - CS RECOMMENDATION3,184 GAL X 2.50 GAL7,9607,960641-0625-792.22-05 UNIFORMS836759 1,000 1,077306237 1,000LEVEL TEXTTEXT AMT02 UNIFORMS FROM CINTAS, T-SHIRTS1,0001,000641-0625-792.22-24 OTHER OPERATING SUPPLIES 32,660 9,691 18,000 16,202 2,797 1,702 20,000LEVEL TEXTTEXT AMT02 CONCRETE FORMS, AGGREGATE, ADA RAMPS20,00020,000641-0625-792.23-04 SEWER MAINT MATERIALS29,590 32,604 65,000 91,653 20,881 18,307 69,468LEVEL TEXTTEXT AMT02 REPAIR UTILITY CUTS69,46869,468641-0625-792.23-20 SMALL TOOLS & EQUIPMENT884 2,680 10,000 10,000540540 10,000LEVEL TEXTTEXT AMT02 HAND TOOLS, SAW, GENERATOR, MISCELLANEOUS TOOLS &10,000EQUIPMENTFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures217 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures10,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES73,466 49,035 100,300 125,232 26,164 22,195 108,428641-0625-792.31-70 ADM FEE ALLOCATION12,828 14,460 15,197 15,197 8,862 7,596 14,978LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #114,978ADMINISTRATIVE FEE14,978641-0625-792.34-02 LIABILITY INSURANCE480540408408238204417LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #5417LIABILITY INSURANCE417641-0625-792.36-03 AUTO EQUIPMENT R&M13,000 4,984 12,000 12,000 3,984 3,984 15,975LEVEL TEXTTEXT AMT02 TRUCKS 431 & 465AVG 2014 - 201615,97515,975641-0625-792.39-88 PENALTIES/FEES000 3,500 3,500 3,5000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES26,308 19,984 27,605 31,105 16,584 15,284 31,370------------ ------------ ------------ ------------ ------------ ------------ ------------** CONCRETE CREW313,995 317,794 445,957 474,389 189,709 162,468 474,916Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures218 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0630-793.10-01 REGULAR WAGES1,387,304 1,298,237 1,326,243 1,326,243 778,455 672,469 1,451,965LEVEL TEXTTEXT AMT02 .5 FTE DIRECTOR OF UTILITIES47,755.5 FTE ASSISTANT DIRECTOR OF UTILITIES42,3971 FTE DIRECTOR OF WASTEWATER MAINTENANCE72,8281 FTE MANAGER-MAINTENANCE65,5451 FTE MANAGER-OPERATIONS (CSO)69,9941 FTE SUPERINTENDENT V57,5651 FTE MANAGER-OPERATIONS69,9941 FTE MANAGER-ENVIRONMENTAL COMPLIANCE70,3691 FTE INDUSTRIAL PRETREATMENT SPEC. I53,7881 FTE MANAGER-INDUSTRIAL PRETREATMENT61,384.5 FTE DIRECTOR OF UTILITY SAFETY27,831.75 FTE CHEMIST37,904.75 FTE CHEMIST37,904.75 FTE CHEMIST37,904.75 FTE CHEMIST LEAD40,3191 FTE ASSISTANT CITY ENGINEER83,890.5 FTE DIRECTOR OF SCADA INFORMATION SYSTEMS38,968.5 FTE SYSTEMS SPECIALIST IV33,790.75 FTE MANAGER-UTILITY PURCHASING & STOREROOM39,7951 FTE ADMINISTRATIVE ASSISTANT40,5251 FTE SCADA INSTRUMENT SPECIALIST57,009.5 FTE DIRECTOR OF WATER QUALITY & LABORATORY36,414ALLOCATED POSITIONS:.12 FTE DIRECTOR OF PUBLIC WORKS14,342.12 FTE DEPUTY PUBLIC WORKS DIRECTOR11,6901 FTE DIRECTOR CSO PROJECT MANAGEMENT83,503.23 FTE CITY ENGINEER23,997.23 FTE ASSISTANT CITY ENGINEER19,295.23 FTE ENGINEER I15,621.23 FTE ENGINEER I15,621.23 FTE ENGINEER I15,621.23 FTE ENGINEER I15,621.23 FTE MANAGER PUBLIC CONSTRUCTION15,577.14 FTE EXEC. ASST. & DIR. SPECIAL PROJ.7,584.23 FTE PROJECT INSPECTOR II12,465.23 FTE PROJECT INSPECTOR II12,465.23 FTE PROJECT INSPECTOR I12,465.23 FTE ADMINISTRATIVE ASSISTANT I9,597.23 FTE ADMIN ASST II9,321.23 FTE PERMITS MANAGER11,368.23 FTE DIRECTOR OF OPER & ASSETS19,090.23 FTE PUBLIC INFORMATION OFFICER15,112SALARY ALLOWANCE12,262-TOTAL: 17.75 FTE + 4.14 ALLOCATED = 22.58 FTE1,451,965Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures219 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0630-793.10-02 HOURLY WAGES977,732 977,697 1,049,074 1,049,074 571,411 493,388 1,049,667LEVEL TEXTTEXT AMT02 PER TEAMSTERS' 2017-2020 CONTRACT:2 FTE LEAD OPERATORS @ (2 X $22.92 X 2080)95,3475 FTE SENIOR OPERATORS @ (5 X 20.48 X 2080)212,9924 FTE GENERAL OPERATORS @ (4 X $19.65 X 2080)163,4881 FTE MAINTENANCE LEAD @ (1 X 22.92 X 2080)47,6744 FTE MAINTENANCE REPAIR IV @ (4 X $21.30 X 2080)177,2161 FTE MAINT. ELECTRICIAN V @(1 X $22.60 X 2080)47,0082 FTE SANITATION OPERATORS @ (2 X $17.15 X 2080)71,3442 FTE LIFT STATION REP. II @ (2 X $20.48 X 2080)85,1972FTECSOREP.II@(2X$19.65X2080)81,7441 FTE GENERAL LABORER @ (1 X $16.31 X 2080)33,92524 FTE TOTAL7 OPER.DAY SHIFT PREMIUMS (7 X .15 X 2184)2,2934 OPER. NIGHT SHIFT PREMIUMS (4 X .45 X 2184)3,9315 OPER. CLASS II CERT PREMIUMS (5 X 1.00 X 2184)10,9201 OPER. CLASS I CERT. PREMIUMS (1 X .50 X 2184)1,0922 OPER. CLASS IV CERT PREMIUMS (2 X 2.00 X 2080)8,7361 MAINT. CLASS I CERT PREMIUMS (1 X .50 X 2080)1,0401 MAINT. BACKFLOW CERT PREMIUM (1 X .30 X 2080)6241 CSO CS-II CERT PREMIUM (1 X .45 X 2080)9361 JOURNEY/MASTER ELECTRICIAN (1 X 1.00 X 2080)2,0802 LIFT STATION CLASS I CERT (2 X .50 X 2080)2,0801,049,667641-0630-793.10-03 SEASONAL & INTERNS6,184 18,805 30,720 30,720 13,875 9,277 30,720LEVEL TEXTTEXT AMT02 1 SUMMER LABORER $16/HR X 16 WEEKS10,2402 ENGINEERING INTERNS $16/HR X 16 WEEKS20,480SAME AS 2017 BUDGET30,720641-0630-793.10-04 EXTRA AND OVERTIME138,435 143,605 148,045 148,045 81,923 70,950 152,088LEVEL TEXTTEXT AMT02 EST. 175 HR X $21.76 AVE. RATE X 1.5137,088OT FOR PROJECTS NOT ACCOMPLISHED 8 TO 4PM15,000152,088641-0630-793.10-06 LONGEVITY PAY00 5,100 5,100 2,000 2,000 4,950LEVEL TEXTTEXT AMT02 PER 2017-2020 TEAMSTER CONTRACT4,9504,950Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures220 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0630-793.10-09 PERMANENT PART-TIME9,462 10,337 14,064 14,064 3,421 2,764 14,165LEVEL TEXTTEXT AMT02 .23 FTE PT SECRETARY V3,856.23 FTE PT ASST. CITY ENGINEER10,30914,165641-0630-793.10-10 HIRING BONUS1,000000000641-0630-793.10-13 STAND BY PAY46,232 97,394 104,333 104,333 54,116 46,950 107,627LEVEL TEXTTEXT AMT02 CSO CREW STAND-BY 1664 HR X $20.1033,446MAINTENANCE STAND-BY 1664 HR X $20.8334,661OPERATIONS STAND-BY 1664 HR X $23.7539,520107,627641-0630-793.10-14 PRODUCTIVITY BONUS5,750 10,535 6,000 6,000000LEVEL TEXTTEXT AMT02 DISCONTINUED IN 2018641-0630-793.11-01 FICA - REGULAR192,019 190,012 207,131 207,131 113,139 97,695 216,952LEVEL TEXTTEXT AMT02 TAXABLE @ 7.65%: REG SALARIES $1,451,965111,062HOURLY 1,049,07480,300SEASONAL 30,7202,350OVERTIME 152,08811,635LONGEVITY 4,950379PERM. PART TIME 14,3451,097STAND-BY 107,6278,233AUTO ALLOW. 5,505421CELL PHONE ALLOW. 9,089695JOB READINES ALLOW. 10,200780216,952641-0630-793.11-04 PERF - REGULAR284,437 281,295 148,539 293,539 166,523 143,917 309,271LEVEL TEXTTEXT AMT02 ELIGIBLE @11.2%: REGULAR SALARIES $1,451,965162,620HOURLY$1,049,667117,563OVERTIME$ 152,08817,034STAND-BY$107,62712,054309,271641-0630-793.11-05 PERF - UNION00 165,284 20,284 10,223 8,886 19,641LEVEL TEXTTEXT AMTFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures221 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 PER TEAMSTER CONTRACT. CITY PAYS 1.5% OF 3% PERFHOURLY WAGES $1,049,667 X 1.5%15,745OVERTIME $ 152,088 X 1.5%2,281STAND-BY $ 107,627 X 1.5%1,61519,641641-0630-793.11-07 UNEMPLOYMENT COMP6,959 3,598 6,709 6,709000LEVEL TEXTTEXT AMT02 DISCONTINUED IN 2018641-0630-793.11-08 HEALTH INSURANCE430,363 539,336 648,831 648,831 332,788 283,159 693,364LEVEL TEXTTEXT AMT02 LONG TERM DISABLILITY:47.04 FTE X $4.00 X 24 PAY PERIODS4,516HEALTH INS.42.04 FTE X $675.00 X 24 PAY PERIODS681,048HEALTH INS/REBATE:5 FTE X $ 65.00 X 24 PAY PERIODS7,800693,364641-0630-793.11-09 LIFE INSURANCE5,270 5,260 5,513 5,513 3,089 2,630 5,645LEVEL TEXTTEXT AMT02 47.04 FTE X $5.00 X 24 PAY PERIODS5,6455,645641-0630-793.11-10 CLOTHING ALLOWANCE4,525 6,30000000641-0630-793.11-12 AUTO ALLOWANCE2,498 2,121 5,235 5,235 1,122969 5,505LEVEL TEXTTEXT AMT02 3 ALLOCATED ENGINEERING ALLOWANCES1,90550% UTILITY DIRECTOR, 50% ASST. UTIL, DIRECTOR3,6005,505641-0630-793.11-24 CELL PHONE ALLOWANCE6,701 8,038 8,580 8,580 4,994 4,264 9,089LEVEL TEXTTEXT AMT02 10 FTE X $55/MO X 12 MONTHS6,600ALLOCATED ENGINEERING PHONE ALLOWANCES2,4899,089641-0630-793.11-27 JOB READINESS ALLOWANCE00 10,200 10,200 9,669 9,563 10,200LEVEL TEXTTEXT AMT02 PER 2017-2020 TEAMSTER CONTRACT24 X $425/EA. PAID 1ST CHECK IN JANUARY10,20010,200Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures222 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0630-793.11-29 PARENTAL LEAVE000000 7,023LEVEL TEXTTEXT AMT02 NEW FOR 2018.7,023PAYROLL $2,833,315 X .25% = $7,0237,023641-0630-793.11-99 OTHER FRINGE BENEFITS2,435 2,040 2,500 2,50000 2,500LEVEL TEXTTEXT AMT02 TEAMSTER'S DEFERRED COMP MATCH2,500SAME AS 2017 BUDGET.2,500------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES3,507,306 3,594,610 3,892,101 3,892,101 2,146,748 1,848,879 4,090,372641-0630-793.21-02 PRINT SHOP1,3091826006005352200LEVEL TEXTTEXT AMT02 PRINTED MATERIALS COST200200641-0630-793.21-03 C.S. OFFICE SUPPLIES868805 2,000 2,000533404 1,500LEVEL TEXTTEXT AMT02 COPY PAPER, BASIC OFFICE SUPPLIES1,5001,500641-0630-793.21-04 OTHER OFFICE SUPPLIES3,349 3,708 5,800 7,389 4,391 3,931 4,500LEVEL TEXTTEXT AMT02 TONER, INK, ITEMS NOT AVAILABLE AT CENTRAL STORES4,5004,500641-0630-793.21-05 SMALL OFFICE EQUIPMENT4,473 2,473 4,500 4,50000 4,500LEVEL TEXTTEXT AMT02 MISC.OFFICE EQUIPMENT/REPLACEMENT CHAIRS AS NEEDED4,500SAME AS 2017.4,500641-0630-793.22-01 CENTRAL SERVICE GASOLINE 19,066 16,568 26,250 26,250 8,338 7,166 24,002LEVEL TEXTTEXT AMT02 ESTIMATED 6,601 GAL @ $2.50/GAL24,002AMOUNT CALCULATED BY CENTRAL SERVICESFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures223 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures24,002641-0630-793.22-02 COMPRESSED GAS/DIESEL11,058 1,469 7,000 9,450 3,309 3,309 5,000LEVEL TEXTTEXT AMT02 DIESEL FUEL FOR PLANT EQUIPMENT5,0005,000641-0630-793.22-05 UNIFORMS20,537 18,533 28,000 28,000 11,803 9,535 22,000LEVEL TEXTTEXT AMT02 WEEKLY UNIFORM RENTAL/CLEANING,RUG SERVICE22,000T-SHIRTS FOR TEAMSTERS, PER CONTRACT22,000641-0630-793.22-12 OIL12,598 6,267 10,000 10,000640640 7,000LEVEL TEXTTEXT AMT02 FOR GENERATORS/PUMPS/LIFT STATIONS7,0007,000641-0630-793.22-20 C.S. - MEDICAL/SAFETY1,488 2,344 2,500 2,500947947 1,500LEVEL TEXTTEXT AMT02 SAFETY GLOVES, FIRST AID SUPPLIES, NEUTRALIZERFOR FLAMMABLES, OTHER AS NEEDED.1,5001,500641-0630-793.22-21 C.S. CLEANING SUPPLIES4,893 5,085 5,500 5,500 1,175 1,111 5,500LEVEL TEXTTEXT AMT02 DEGREASERS, SOLVENTS, SOAPS, WAXES, ETC.5,5005,500641-0630-793.22-22 MEDICAL/SAFETY SUPPLIES 18,076 6,320 10,630 10,630 2,612884 6,275LEVEL TEXTTEXT AMT02 FIRE EXTINGUISHER ANNUAL SERVICE1,500SAFETY VESTS110SENSOR CARTRIGES FOR AIR MONITORS400CALIBRATION GAS FOR AIR MONITORS200LIFE RINGS80EYE WASH STATION MAINTENANCE100SAFETY GLASSES75DISPOSABLE EAR PLUGS100ELECTRICAL GLOVES480TRAFFIC SIGNS200MISC. FIRST AID SUPPLIES250Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures224 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresTRAFFIC CONES500"B" KIT1,400FULL BODY HARNESS400BOOTS FOR HAZMAT80ALARM FIRE TESTING4006,275641-0630-793.22-60 OFFICE COMPUTERS1,227000000641-0630-793.22-61 PROCESS COMPUTERS4,778 21,289 35,000 35,000 11,763 11,763 10,000LEVEL TEXTTEXT AMT02 HANDHELD MOBILE DEVICES FOR MAXIMO5,000SCADA DESKTOP COMPUTERS5,00010,000641-0630-793.23-10 REPAIR PARTS289,449 565,621 400,000 427,464 105,413 87,890 400,000LEVEL TEXTTEXT AMT02 CRITICAL PARTS INVENTORY75,000MISC. ELECTRICAL,PLUMBING PARTS,BEARINGS, SEALS325,000400,000641-0630-793.23-20 SMALL TOOLS & EQUIPMENT6,133 33,343 24,500 31,399 13,394 11,316 24,500LEVEL TEXTTEXT AMT02 CSO FLOW MONITORING EQUIPMENT10,000WWTP AUTOMATED SAMPLER7,000PLANT MAINT.-MOWERS, RAKES, TOOLS, ETC.7,50024,500641-0630-793.23-21 C.S. SMALL TOOLS & EQUIP196070070000100LEVEL TEXTTEXT AMT02 MISC SMALL ITEMS, HAND TOOLS, ETC. AS NEEDED.100100641-0630-793.23-60 LAB MATERIALS & SUPPLIES 79,860 51,841 51,000 55,328 25,593 20,516 46,000LEVEL TEXTTEXT AMT02 CHEMICALS, REAGENTS30,000UNANTICIPATED EQUIP. REPLACEMENT8,000ICP GASSES4,000REAGENT WATER SYSTEM REPLACEMENT4,00046,000641-0630-793.23-62 MATERIALS & SUPPLIES155,159 207,616 210,000 244,489 120,192 104,824 210,000LEVEL TEXTTEXT AMTFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures225 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 CHEMICALS, NUTS/BOLTS, BELTS, OTHER CONSUMABLES210,000210,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES634,517 943,464 823,980 901,199 310,156 264,288 772,577641-0630-793.31-01 LEGAL SERVICES46,614 42,542 250,000 239,437 165,936 144,278 400,000LEVEL TEXTTEXT AMT02 LONG TERM CONTROL PLAN-(LTCP), NATIONAL POLLUTATEDISCHARGE ELIMINATION SYSTEM (NPDES) PERMITNEGOTIATIONS400,000400,000641-0630-793.31-02 ENGINEERING276,950 893,232 1,100,000 1,865,379 636,290 488,778 1,200,000LEVEL TEXTTEXT AMT02 LONG TERM CONTROL PLAN ASSISTANCE/C.A. AT WWTP350,000LIFT STATION FACILITY PLAN100,000WWTP DEWATERING BELT PRESSES30,000MISC. PAY AS YOU GO CAP.-MAINT. ENGINEERING120,000WWTP ELECTRIC UPGRADES / GENERATORS450,000INFLUENT & HEADWORKS GATE REPLACEMENT150,0001,200,000641-0630-793.31-04 ACCOUNTING22,624 18,206 40,000 76,044 7,236 2,236 40,000LEVEL TEXTTEXT AMT02 CPA SERVICES-VARIOUS AUDITS, COST OF SERVICE STUDY40,00040,000641-0630-793.31-06 OTHER PROFESSIONAL SVCS4,76420000000641-0630-793.31-07 MGMT FEE TO WATERWORKS 1,022,364 1,261,956 1,442,856 1,442,856 841,666 721,428 1,444,188LEVEL TEXTTEXT AMT02 2017 FIXED COST ALLOCATION #61,444,188UTILITY CUSTOMER SERVICE OPERATIONS FEE1,444,188641-0630-793.31-09 CONTRACT LAB ANALYSIS28,302 25,394 42,000 66,738 22,087 20,351 50,000LEVEL TEXTTEXT AMT02 SLUDGE, BIOMONITORING, LL HG.ALL ANALYTICAL TESTS UNABLE TO PERFORM IN HOUSE50,00050,000641-0630-793.31-10 BOND ISSUANCE COSTS000 1,500 1,500 1,5000641-0630-793.31-70 ADM FEE ALLOCATION811,770 995,892 981,272 981,272 572,411 490,638 1,041,111Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures226 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #11,041,111ADMINISTRATIVE FEE-MAYOR, CLERK, COUNCIL,ADMIN &FINANCE, CITY ATTORNEY1,041,111641-0630-793.31-71 CENTRAL STORES ALLOCATION 6,911 6,840 7,243 7,243 4,228 3,624 14,308LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #314,308CENTRAL STORES OPERATIONS14,308641-0630-793.31-72 GIS ALLOCATION21,623 22,70400000LEVEL TEXTTEXT AMT02 NOW PART OF FIXED ALLOCATION #7, ACCOUNT 36-04641-0630-793.31-73 PRINT SHOP ALLOCATION0 1,236 1,376 1,376805690 1,123LEVEL TEXTTEXT AMT02 2018 FIXED ALLOCATION #41,1231,123641-0630-793.31-76 IT ALLOCATION000000 456,929LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #7456,929IT OPERATIONS, VOIP, GIS, & TECHNOLOGY456,929641-0630-793.32-02 POSTAGE3,186 4,321 5,000 5,255 2,576 2,385 5,000LEVEL TEXTTEXT AMT02 MAIL COURIER SERVICE & SUPPLIES5,0005,000641-0630-793.32-04 TELEPHONE22,598 19,703 18,972 19,735 4,763 3,958 20,000LEVEL TEXTTEXT AMT02 CITY ALLOCATION EST $900/MONTH10,800AT&T AVERAGE $585/MONTH7,020ATT MOBILITY AVERAGE $182/MONTH2,18020,000641-0630-793.32-21 TRAVEL - MILEAGE3,094 1,822 2,000 2,000697697 3,000LEVEL TEXTTEXT AMTFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures227 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 REIMBURSEMENTS FOR TRAVEL WHEN CITY VEHICLE ISNOT AVAILABLE.3,0003,000641-0630-793.32-22 TRAVEL - AIRFARE255 2,316 8,000 8,00000 10,000LEVEL TEXTTEXT AMT02 FOR MEETINGS, CONFERENCES, SEMINARS NOT IN AREA.10,00010,000641-0630-793.32-23 TRAVEL - HOTEL5,631 7,675 7,000 7,000979979 8,000LEVEL TEXTTEXT AMT02 TECHNICAL TRAINING, IWEA ANNUAL CONF, SECTIONAL8,000MEETINGS, COMPUTER TRAINING, OPERATOR OLYMPICS8,000641-0630-793.32-24 TRAVEL - MEALS2,120 2,462 2,000 2,105347277 3,000LEVEL TEXTTEXT AMT02 MEALS WHEN AWAY AT SEMINARS, CONFERENCES, ETC.3,0003,000641-0630-793.32-25 TRAVEL - OTHER1,022 1,337 1,000 1,0006363 1,500LEVEL TEXTTEXT AMT02 TOLLS, PARKING, OTHER TRAVEL MISC.1,5001,500641-0630-793.33-02 PUBLICATION LEGAL NOTICE4,441 1,938 3,000 3,247845845 3,500LEVEL TEXTTEXT AMT02 BID NOTIFICATIONS, EMPOYEE CLASSIFIEDS3,5003,500641-0630-793.34-02 LIABILITY INSURANCE185,208 174,984 193,908 193,908 113,113 96,954 208,803LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #5208,803LIABILITY INSURANCE208,803641-0630-793.35-01 ELECTRIC702,985 971,100 801,109 776,109 527,733 465,644 872,000LEVEL TEXTTEXT AMT02 BASED ON 2017 USAGE800,0009% UTILITY OFFICE FEE72,000872,000Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures228 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0630-793.35-02 HEAT222,429 87,749 163,500 163,500 92,394 90,650 163,500LEVEL TEXTTEXT AMT02 SAME AS 2017.150,0009% UTILITY OFFICE FEE13,500163,500641-0630-793.35-04 WATER11,658 12,564 17,500 41,500 16,227 16,207 20,000LEVEL TEXTTEXT AMT02 EXPECTING RATE INCREASE IN 2018.20,00020,000641-0630-793.36-01 BUILDING R&M262,344 51,589 312,000 627,004 94,982 89,479 306,500LEVEL TEXTTEXT AMT02 HVAC MAINTENANCE CONTRACT16,000OVERHEAD CRANES2,000ROLLING GATES1,000OVERHEAD DOORS2,500ALL OTHER BUILDING REPAIRS125,000ROOF REPLACEMENTS AT WWTP100,000PAVING, CONCRETE REPL. AT WWTP50,000LIGHTING & SECURITY CAMERAS10,000306,500641-0630-793.36-02 OFFICE EQUIP R&M2,538981 2,000 2,00000 1,500LEVEL TEXTTEXT AMT02 SMALL, INCIDENTAL COMPUTER REPAIRS1,5001,500641-0630-793.36-03 AUTO EQUIPMENT R&M52,295 44,982 40,000 41,035 38,589 34,720 40,000LEVEL TEXTTEXT AMT02 PARTS & LABOR FOR IN-HOUSE & 3RD PARTY REPAIRS40,00040,000641-0630-793.36-04 COMPUTER EQUIP R&M22,677 37,521 242,801 242,801 141,631 121,3980641-0630-793.36-05 OTHER EQUIP R&M330,060 749,136 593,000 969,107 430,115 408,795 593,000LEVEL TEXTTEXT AMT02 GENERATORS PM AND COMPRESSORS PM SERVICES20,000REPLACE WWTP PUMPS & CONTROLS100,000LIFT STATION UPGRADES& BYPASS INSTALLATIONS100,000OUTSIDE REPAIR SERVICES FOR EQUIPMENT80,000DEWATERING PRESS REBUILD200,000Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures229 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresRIVER BANK STABILIZATION93,000593,000641-0630-793.36-06 RADIO EQUIP R&M812 2,839 10,000 10,000 3,452 3,436 1,500LEVEL TEXTTEXT AMT02 RADIO SHOP REPAIR WORK1,5001,500641-0630-793.36-10 HAZARDOUS MAT'L REMOVAL409490500500200200500LEVEL TEXTTEXT AMT02 SAME AS 2017 BUDGET.500500641-0630-793.37-11 CAPITAL LEASE PRINCIPAL 150,773 138,366 147,448 147,454 141,184 72,089 83,932LEVEL TEXTTEXT AMT02 DS-36 2001 PUBLIC WORKS BLDG.73,185DS-125 2014 HP COMPUTER LEASES2,821DS-132 2014 RICOH COPIERS (2)1,772DS-138 2015 HP COMPUTER LEASES540DS-150 2016 HP COMPUTER LEASES807DS-152 2016 PNC VEHICLE LEASE #21,339DS-155 2016 HP COMPUTER LEASES2,069DS-159 2017 RICOH COPIER LEASE1,39983,932641-0630-793.37-12 CAPITAL LEASE INTEREST20,234 16,712 13,641 13,665 13,726 7,520 10,381LEVEL TEXTTEXT AMT02 DS-36 2001 PUBLIC WORKS BLDG.9,444DS-125 2014 HP COMPUTER LEASES58DS-132 2014 RICOH COPIERS (2)106DS-138 2015 HP COMPUTER LEASES40DS-150 2016 HP COMPUTER LEASES76DS-152 2016 PNC VEHICLE LEASE #278DS-155 2016 HP COMPUTER LEASES289DS-159 2017 RICOH COPIER LEASE29010,381641-0630-793.39-10 SUBSCRIPTIONS60,024 56,457 74,530 78,992 29,923 4,000 586,500LEVEL TEXTTEXT AMT02 TECHCONNECT-SCADA26,000AUTOCAD400LINKO4,000VM WARE100Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures230 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresMAXIMO SOFTWARE OPGRADE TO 7.635,000MAXIMO MAINTENANCE SOFTWARE30,000WATERTRAX SOFTWARE SUPPORT11,000BILLING SOFTWARE480,000586,500641-0630-793.39-11 DUES & MEMBERSHIPS21,480 11,034 25,000 25,632 3,840 3,695 25,000LEVEL TEXTTEXT AMT02 NACWA17,000WET WEATHER PARTNERSHIP2,500APWA, AWWA, WEF, OTHERS5,50025,000641-0630-793.39-39 CREDIT CARD FEES845 1,123500 1,500719566500LEVEL TEXTTEXT AMT02 CREDIT CARD TERMINAL AT ORGAINC RESOURCES500AVERAGE FEE $42/MONTH500641-0630-793.39-70 EDUCATION & TRAINING10,426 7,559 24,000 25,906 4,977 3,244 24,000LEVEL TEXTTEXT AMT02 12 STAFF @ $2,000 EACH24,00024,000641-0630-793.39-89 MISC CHARGES & SVCS61510010000100LEVEL TEXTTEXT AMT02 SMALL, UNFORSEEN EXPENSES100100------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES4,341,472 5,674,977 6,573,256 8,090,900 3,915,234 3,301,326 7,639,375641-0630-793.50-01 STATE BOARD OF ACCOUNTS0 15,352 9,000 9,00000 16,000LEVEL TEXTTEXT AMT02 ANNUAL AUDIT FEE, STATE BOARD OF ACCOUNTS16,00016,000641-0630-793.50-02 OPERATING TRANSFER17,525,877 12,575,437 13,629,745 13,629,745 7,798,338 6,535,540 17,512,379LEVEL TEXTTEXT AMT02 2018 DEBT SERVICE-PER SCHEDULE9,157,379TRANSFER TO FUND 649-0000-392.00-00PAY AS YOU GO CAPITAL-WASTEWATER5,605,000Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures231 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresTRANSFER TO FUND 642-0000-392.00-00PAY AS YOU GO CAPITAL-SEWERS2,750,000TRANSFER TO FUND 642-0000-392.00-0017,512,379641-0630-793.60-03 PAYMENT IN LIEU OF TAX 3,497,196 3,672,060 4,422,402 4,422,402 2,579,738 2,211,204 4,601,656LEVEL TEXTTEXT AMT02 PILOT CALCULATION - 3% X NBV OF CAPITAL ASSETS4,601,656TRANSFER TO FUND 101-0000-338.00-004,601,656641-0630-793.63-35 CONTRACTUAL SERVICE-OTHER 845,687 729,808 1,167,000 1,572,895 427,983 361,840 944,500LEVEL TEXTTEXT AMT02 JF NEW GREEN SOLUTIONS25,000FISH STUDY WITH CITY OF ELKHART50,000PREV.MAINT.FLOW METERS & CSO DMR PROGRAM CONTROL40,000ANNUAL WASTEWATER NPDES PERMIT30,000LAB SVC.CONTRACT, ICP; BALANCE WEIGHT TESTING16,000PREV. MAINT. SCADA INSTRUMENTATION25,000FIRE, PEST, LAWN, XP-SWMM, UNTERWRITER'S, RIVER BA5,000HACH SERVICE CONTRACT-ONLINE METERING13,000MISCELLANEOUS CONTRACTS100,000LARGE DIAMETER SEWER CLEANING & CSO REPAIRS100,000EMNET CSO SERVICE FEE320,000RMP-PSM REVISION; PROCESS HAZARD ANALYSIS18,000AIR PERMIT ASST.,EMISSIONS TESTING-RICE NESHOP17,000CSO OPERATIONAL PLAN ASSISTANCE30,000ABANDON GROUND WATER WELL CASTINGS100,000UPDATE MAXIMO ANYWHERE DEVICES50,000RIVERSIDE DRIVE ROADWAY ISLAND MAINTENANCE3,000LEEPER PARK RIVER CROSSING & ODOR CONTROL MAINT2,500944,500641-0630-793.63-36 WASTE HAULING44,413 57,882 62,000 62,000 35,837 26,399 62,000LEVEL TEXTTEXT AMT02 LANDFILL-GRIT, STREET SWEEPINGS50,000LG DIAMETER SEWER GRIT DISPOSAL10,000TRASH PICK UP SERVICE AT WWTP2,00062,000641-0630-793.63-37 BASEMENT VALVE FUND0 42,1770 75,000 42,460 42,460 50,000LEVEL TEXTTEXT AMT02 NEW CITY PROGRAM IN 2017 TO REIMBURSE RESIDENTS50,000A PORTION OF THE COST OF HAVING A BACKFLOW VALVEFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures232 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresINSTALLED IN THEIR BASEMENT TO PREVENT SEWERBACKUPS50,000641-0630-793.65-06 VARIOUS CHEMICALS261,874 261,619 418,231 543,758 164,586 147,031 345,000LEVEL TEXTTEXT AMT02 CHLORINE @ $267/TON35,000SULFUR DIOXIDE @ $486/TON48,000FERRIC CHLORIDE @ $.89/GALLON54,000SODIUM HYPOCHLORITE @ $.72/GALLON8,000CALCIUM NITRATE @ $1.98/GALLON60,000DRY POLYMER FLOCCULENT @ $1.54/LB90,000POLYGONE @41.90/GALLON40,000MISC. OTHER CHEMICALS10,000345,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES22,175,047 17,354,335 19,708,378 20,314,800 11,048,942 9,324,474 23,531,535------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT30,658,342 27,567,386 30,997,715 33,199,000 17,421,080 14,738,966 36,033,859Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures233 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0631-793.10-01 REGULAR WAGES95,793 112,320 119,407 119,407 67,622 58,639 119,163LEVEL TEXTTEXT AMT02 1.0 FTE SUPERVISOR - OPERATIONS59,9951.0 FTE ADMINISTRATIVE ASSISTANT 140,525.10 FTE PUBLIC WORKS DIRECTOR SALARY11,951.10 FTE DEPUTY PW DIRECTOR SALARY9,742SALARY ALLOWANCE3,050-2.2 FTE TOTAL119,163641-0631-793.10-02 HOURLY WAGES165,881 160,542 162,240 162,240 86,480 74,147 163,488LEVEL TEXTTEXT AMT02 4 HEAVY EQUIP.OPERATORS II @ $19.65 X 2080 HR163,488163,488641-0631-793.10-04 EXTRA AND OVERTIME12,768 9,942 37,440 37,440 10,306 10,284 37,728LEVEL TEXTTEXT AMT02 EST 320 HR @ $19.65 HRLY RATE X 1.537,728LAND APP BIOSOLIDS SPRING & FALL, SNOW PLOWINGAS NEEDED37,728641-0631-793.10-05 TEMPORARY SERVICES1,280 7,2870 1,813 1,807 1,8070641-0631-793.10-06 LONGEVITY PAY00 1,100 1,100400400900LEVEL TEXTTEXT AMT02 PER 2017-2020 TEAMSTER CONTRACT900900641-0631-793.10-13 STAND BY PAY4,568 6,544 10,238 10,238 7,275 7,275 10,316LEVEL TEXTTEXT AMT02 SNOW REMOVAL EST 525 HR X $19.6510,31610,316641-0631-793.10-14 PRODUCTIVITY BONUS1,000 2,000 1,000 1,000000LEVEL TEXTTEXT AMT02 DISCONTINUED IN 2018641-0631-793.11-01 FICA - REGULAR21,562 22,036 25,591 25,591 13,366 11,713 25,622LEVEL TEXTTEXT AMT02 TOTAL WAGES $331,596 X 7.65%25,367TAXABLE BENEFITS $3,333 X 7.65%25525,622Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures234 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0631-793.11-04 PERF - REGULAR31,215 32,407 13,374 36,374 19,297 16,908 37,038LEVEL TEXTTEXT AMT02 SALARIES $119,163 X 11.2%13,346HOURLY $163,488 X 11.2%18,311OVERTIME $37,728 X 11.2%4,226STAND-BY $10,316 X 11.2%1,15537,038641-0631-793.11-05 PERF - UNION00 26,799 3,799 1,389 1,249 3,173LEVEL TEXTTEXT AMT02 ELIGIBLE @ 1.5% HOURLY$163,4882,452OVERTIME37,728566STAND-BY10,3161553,173641-0631-793.11-07 UNEMPLOYMENT COMP843395829829000LEVEL TEXTTEXT AMT02 DISCONTINUED FOR 2018 BUDGET641-0631-793.11-08 HEALTH INSURANCE37,994 59,455 97,005 96,792 33,194 28,728 101,034LEVEL TEXTTEXT AMT02 L.T. DISABILITY-6.2 EMP. X $4.00 X 24 PAY PERIODS594HEALTH INS-6.2 EMP. X $675.00 X 24 PAY PERIODS100,440101,034641-0631-793.11-09 LIFE INSURANCE692743744744404342744LEVEL TEXTTEXT AMT02 6.2 EMP. X $5 X 24 PAY PERIODS744744641-0631-793.11-10 CLOTHING ALLOWANCE750 1,02700000641-0631-793.11-12 AUTO ALLOWANCE840600600600350300840LEVEL TEXTTEXT AMT02 PW DIRECTOR, DEPUTY DIRECTOR ALLOCATED ALLOW.840840641-0631-793.11-24 CELL PHONE ALLOWANCE682787792792462396792LEVEL TEXTTEXT AMT02 1FTEX$55/MOX12MONTHS660PW DIRECTOR ALLOCATION $5.50/MONTH X 1266ASST. PW DIRECTOR ALLO. $5.50/MONTH X 1266Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures235 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures792641-0631-793.11-27 JOB READINESS ALLOWANCE00 1,700 1,913 1,913 1,913 1,700LEVEL TEXTTEXT AMT02 PER TEAMSTER 2017-2020 CONTRACT1,7004 X $425/EACH, PAID 1ST CHECK IN JANUARY1,700641-0631-793.11-29 PARENTAL LEAVE000000829LEVEL TEXTTEXT AMT02 NEW FOR 2018.829SALARIES $331,596 X .25%829641-0631-793.11-99 OTHER FRINGE BENEFITS57640015015000450LEVEL TEXTTEXT AMT02 TEAMSTER MATCH ON 401K DEFERRALS450450------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES376,444 416,485 499,009 500,822 244,265 214,101 503,817641-0631-793.21-02 PRINT SHOP0010010000100LEVEL TEXTTEXT AMT02 SUPPIES COST FOR PRINTED ITEMS100100641-0631-793.21-04 OTHER OFFICE SUPPLIES219246750768133133500LEVEL TEXTTEXT AMT02 BASIC OFFICE SUPPLIES AS NEEDED500500641-0631-793.21-05 SMALL OFFICE EQUIPMENT011930030000200LEVEL TEXTTEXT AMT02 PRINTERS, CALCULATORS, FILES, AS NEEDED200200641-0631-793.22-01 CENTRAL SERVICE GASOLINE 64,735 55,731 67,500 67,500 43,813 38,059 74,062LEVEL TEXTTEXT AMT02 EST. 29,625GAL. @ $2.5074,062AMOUNT CALCULATED BY CENTRAL SERVICESFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures236 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures74,062641-0631-793.22-05 UNIFORMS1,661 1,718 2,200 2,200 1,021864 2,300LEVEL TEXTTEXT AMT02 WEEKLY UNIFORM CLEANING + T-SHIRTS FOR2,300TEAMSTERS, PER UNION CONTRACT2,300641-0631-793.22-21 C.S. CLEANING SUPPLIES42793500500275275250LEVEL TEXTTEXT AMT02 SOAPS, DEGREASERS, CLEANING SOLVENTS250250641-0631-793.22-22 MEDICAL/SAFETY SUPPLIES1011693003001560200LEVEL TEXTTEXT AMT02 SAFETY GLASSES, EAR PLUGS, OTHER SAFETY ITEMS200200641-0631-793.23-10 REPAIR PARTS1,50073 2,250 2,250202202 2,000LEVEL TEXTTEXT AMT02 REPLACEMENT BLADES, REPAIRS TO RENTED EQUIPOTHER SMALL REPAIR PARTS AS NEEDED2,0002,000641-0631-793.23-21 C.S. SMALL TOOLS & EQUIP0 1,868 3,000 3,0002121 2,000LEVEL TEXTTEXT AMT02 MISC SMALL TOOLS AND PARTS AS NEEDED2,0002,000641-0631-793.23-62 MATERIALS & SUPPLIES16988 2,000 2,00000 1,000LEVEL TEXTTEXT AMT02 NUTS, BOLTS, CONSUMABLES1,0001,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES68,659 61,005 78,900 78,918 45,621 39,555 82,612641-0631-793.31-06 OTHER PROFESSIONAL SVCS4430500500000641-0631-793.31-70 ADM FEE ALLOCATION33,437 49,044 47,616 47,616 27,776 23,808 53,452LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #153,452Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures237 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresADMINISTRATIVE FEE53,452641-0631-793.31-71 CENTRAL STORES ALLOCATION322372455455266228894LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #3894CENTRAL STORES894641-0631-793.31-76 IT ALLOCATION000000 59,508LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #759,508INFORMATION TECHNOLOGY, VOIP, & GIS59,508641-0631-793.32-02 POSTAGE43350504444200LEVEL TEXTTEXT AMT02 STAMPS TO MAIL CUSTOMER INVOICES, POSTCARDS200200641-0631-793.32-04 TELEPHONE960960 1,200 1,20000 1,000LEVEL TEXTTEXT AMT02 EST. $80-85/MONTH X 12 MONTHS1,0001,000641-0631-793.32-05 OTHER COMM/TRANS1,022 1,274 2,500 2,500635355 1,500LEVEL TEXTTEXT AMT02 SECURITY SYSTEM MONITORING,SCALE TESTING, REPAIRS, & MAINT.1,5001,500641-0631-793.32-21 TRAVEL - MILEAGE027020020010054200LEVEL TEXTTEXT AMT02 REIMBURSE DAY TRIPS, MEETING/CONF. TRAVEL WHEN ACITY VEHICLE IS NOT AVAILABLE200200641-0631-793.32-22 TRAVEL - AIRFARE0471 1,000 1,00000 1,000LEVEL TEXTTEXT AMT02 TRAVEL TO CONFERENCES, SEMINARS OUT OF AREA1,0001,000Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures238 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0631-793.32-23 TRAVEL - HOTEL105591 1,000 1,00000 1,000LEVEL TEXTTEXT AMT02 LODGING FOR OUT OF AREA MEETINGS/CONFERENCES1,0001,000641-0631-793.32-24 TRAVEL - MEALS157940040000400LEVEL TEXTTEXT AMT02 OUT OF AREA MEETINGS/CONFERENCES WHERE MEALSARE NOT INCLUDED400400641-0631-793.32-25 TRAVEL - OTHER02920020000200LEVEL TEXTTEXT AMT02 TOLLS, PARKING FEES, OTHER TRAVEL INCIDENTAL EXP200200641-0631-793.33-02 PUBLICATION LEGAL NOTICE106372002004040200LEVEL TEXTTEXT AMT02 ADVERTISE FOR LAND APP BIDS, OTHER200200641-0631-793.34-02 LIABILITY INSURANCE1,440 1,632 1,225 1,225714612 1,251LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #51,251LIABILITY INSURANCE1,251641-0631-793.35-01 ELECTRIC2,148 2,207 2,000 2,000 1,335 1,171 3,000LEVEL TEXTTEXT AMT02 BASED ON HISTORICAL USAGE.3,0003,000641-0631-793.35-02 HEAT6,458 4,177 9,000 9,000 4,276 4,228 7,000LEVEL TEXTTEXT AMT02 BASED ON HISTORICAL EXPENSE LEVELS.7,0007,000641-0631-793.35-04 WATER185185500500423336 1,000LEVEL TEXTTEXT AMTFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures239 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 EXPECTING RATE INCREASE IN 2018.1,0001,000641-0631-793.36-01 BUILDING R&M44,6810 35,000 34,25000 35,000LEVEL TEXTTEXT AMT02 MISC REPAIRS, PAVING35,00035,000641-0631-793.36-02 OFFICE EQUIP R&M0050050000200LEVEL TEXTTEXT AMT02 CASH REGISTER, SCALE, OTHER REPARS WHEN NEEDED200200641-0631-793.36-03 AUTO EQUIPMENT R&M192,486 203,606 150,000 150,000 62,511 55,497 150,000LEVEL TEXTTEXT AMT02 HEAVILY USED EQUIPMENT REQUIRES CONSTANT REPAIR150,000150,000641-0631-793.36-04 COMPUTER EQUIP R&M786828 6,570 6,570 3,836 3,2880641-0631-793.36-05 OTHER EQUIP R&M0050050000100LEVEL TEXTTEXT AMT02 ELECTRICAL, MECHANICAL CONTRACTORS AS NEEDED100100641-0631-793.36-06 RADIO EQUIP R&M480491500 1,250624609795LEVEL TEXTTEXT AMT02 RADIO EQUIP REPAIRS, UPGRADES, PER RADIO SHOP795795641-0631-793.37-11 CAPITAL LEASE PRINCIPAL 17,482 240,062 498,832 498,832 235,074 169,971 480,841LEVEL TEXTTEXT AMT02 2014 RICOH COPIER LEASE DS-1328862015 VEHICLE/EQUIP LEASE NO.1 DS-140101,9592015 VEHICLE/EQUIP LEASE NO.2 DS-14440,5522016 VEHICLE/EQUIP LEASE NO.1 DS-149139,0712016 VEHICLE/EQUIP LEASE NO.2 DS-15229,5252017 VEHICLE/EQUIP LEASE NO.1 DS-158168,848480,841641-0631-793.37-12 CAPITAL LEASE INTEREST699 16,761 34,563 34,575 14,215 10,680 37,438LEVEL TEXTTEXT AMTFund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures240 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 2014 RICOH COPIER LEASE DS-132542015 VEHICLE/EQUIP LEASE NO.1 DS-1403,9442015 VEHICLE/EQUIP LEASE NO.2 DS-1441,7522016 VEHICLE/EQUIP LEASE NO.1 DS-1497,3832016 VEHICLE/EQUIP LEASE NO.2 DS-1521,7282017 VEHICLE/EQUIP LEASE NO.1 DS-15822,57737,438641-0631-793.39-11 DUES & MEMBERSHIPS30351001003535100LEVEL TEXTTEXT AMT02 IWEA, OTHER100100641-0631-793.39-70 EDUCATION & TRAINING0820 2,000 2,275174174 1,000LEVEL TEXTTEXT AMT02 TO SEND MANAGERS FOR TRAINING OPPORTUNITIES1,0001,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES303,289 523,964 796,611 796,898 352,078 271,130 837,279641-0631-793.63-35 CONTRACTUAL SERVICE-OTHER 145,383 152,757 206,950 222,308 153,729 153,729 177,950LEVEL TEXTTEXT AMT02 PUBLIC OUTREACH PARTICIPATION750LAND APP TRANSPORTATION175,000FIRE EXTINGUISHER, PEST CONTROL SERVICES200OVERHEAD DOORS, GATES1,000MISC. CONTRACTS1,000177,950641-0631-793.63-36 WASTE HAULING0 20,000 10,000 10,00000 10,000LEVEL TEXTTEXT AMT02 TIPPING FEES FOR TRASH & DEBRIS REMOVAL10,00010,000641-0631-793.63-39 CLOSED LANDFILL MONITORIN000000 25,000LEVEL TEXTTEXT AMT02 TO COMPLY WITH IDEM MANDATED ORDER TO IMPROVE25,000AND MONITOR CLOSED BIOSOLIDS LAGOON.25,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES145,383 172,757 216,950 232,308 153,729 153,729 212,950** ORGANIC RESOURCES------------ ------------ ------------ ------------ ------------ ------------ ------------893,775 1,174,211 1,591,470 1,608,946 795,693 678,515 1,636,658Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures241 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures641-0650-851.74-01 BAD DEBT EXPENSE2,915 3,164750750693512250LEVEL TEXTTEXT AMT02 DECREASED FROM 2017 BASED ON ACTUAL EXPENSE.250250------------ ------------ ------------ ------------ ------------ ------------ ------------*2,915 3,164750750693512250------------ ------------ ------------ ------------ ------------ ------------ ------------** CLAY SEWAGE2,915 3,164750750693512250------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE OPER & MAINT FUND36,055,917 33,853,446 40,440,030 44,542,335 21,565,072 18,300,575 46,502,584Fund 641 - Wastewater Operations & MaintenanceCity of South BendExpenditures242 City of South Bend, Indiana 2018 Budget Fund 642 - Sewage Works 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 Interest Earnings 34,993 71,137 45,000 28,132 45,000 45,000 45,000 45,000 45,000 - 0% Bond Proceeds - - - - - - - - - - - Other Income - - 400,000 400,000 - - - - - (400,000) -100% Transfers In 8,000,000 2,487,000 4,442,000 1,442,000 8,355,000 1,263,000 1,147,000 - - 3,913,000 88% Total Revenue 8,034,993 2,558,137 4,887,000 1,870,132 8,400,000 1,308,000 1,192,000 45,000 45,000 3,513,000 72% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 37,895 - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 37,895 - - - - - - - - - - Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- - - - - - 400,000 400,000 - - - Motor Equipment 1,036,942 178,256 1,525,424 704,424 1,545,000 1,613,000 1,147,000 751,000 1,312,500 19,576 1% Machinery & Equipment 1,975,527 3,899,220 6,515,031 2,119,321 5,310,000 650,000 600,000 750,000 700,000 (1,205,031) -18% Infrastructure - - - - 1,500,000 - - - - 1,500,000 - Total Capital 3,012,469 4,077,476 8,040,455 2,823,745 8,355,000 2,263,000 2,147,000 1,901,000 2,012,500 314,545 4% Total Expenditures 3,050,364 4,077,476 8,040,455 2,823,745 8,355,000 2,263,000 2,147,000 1,901,000 2,012,500 314,545 4% Net Surplus / (Deficit)4,984,629 (1,519,339) (3,153,455) (953,613) 45,000 (955,000) (955,000) (1,856,000) (1,967,500) Beginning Cash Balance 3,747,697 8,723,058 7,204,341 6,263,400 6,308,400 5,353,400 4,398,400 2,542,400 Cash Reserve Cash Adjustments (9,267) 622 2,212,514 - - - - - Ending Cash Balance 8,723,058 7,204,341 6,263,400 6,308,400 5,353,400 4,398,400 2,542,400 574,900 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No Reserves - transfer from operating account as needed This fund is used to purchase capital equipment and fund major renovations/restorations for the Wastewater and Sewer Departments. Cash adjustment of $2,212,514 is to bring cash balance to $6,263,400 actual at 6/30/17. 243 City of South Bend, Indiana2018 BudgetFund 642 - Sewage Works CapitalFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget2019202020212022TotalJustificationReplacement CapitalS/A Crane TruckCash240,000 - - - - 240,000 Replace 2000 unit, s/n 4703/4 ton Cargo VanCash40,000 36,000 - 36,000 20,000 132,000 Replace 2006 unit, s/n 494Utility CartCash15,000 - 15,000 15,000 - 45,000 Replace 2006 unit, s/n 676SCADA ServersCash30,000 - - - - 30,000 Replace #3,#4ICP Lab equipmentCash80,000 - - - - 80,000 Beyond useful lifeFarmington 14B Lift StationCash500,000 - - - - 500,000 Per Jones & Henry Facility Plan. Beyond useful lifeUpgrade and rebuild #2 Raw PumpCash500,000 - - - - 500,000 Critical WWTP pump to keep in service Admin. & Compressor bldg. window & brick rehab.Cash- - 400,000 400,000 - 800,000 Moisture seepage deteriorating building exteriors3/4 ton Pick-up TruckCash- 32,000 40,000 - - 72,000 Replace s/n 484, s/n 655,Front end loadersCash- 410,000 - - - 410,000 Replace s/n 602, s/n 613Pressure Washer for Organic ResourcesCash- 10,000 - - - 10,000 Replace s/n 646Riding MowerCash- 15,000 - - - 15,000 Replace s/n 370Douglas Rd, Laurel Rd, Edison Rd, Smilax Rd Lift stationsCash- 650,000 600,000 750,000 700,000 2,700,000 Per Jones & Henry Facility Plan. Beyond useful lifePhoenix Power Screen machine for Organic ResourcesCash- - - - 400,000 400,000 Replace 2008 s/n 6492 EA - Crew TrucksCash320,000 - - - - 320,000 Replace 457 (1999) & 460 (1997)2 EA - Single Axle Dump TrucksCash300,000 - - - - 300,000 Replace 485 (1995) & 467 (2003)1 EA - Excavator, Rubber TrackCash200,000 - - - - 200,000 Replace 489 (1993)2 EA - ZTR Mowers & TrailerCash30,000 - - - - 30,000 Replace 4452 & 44531 EA - Vactor/Jet RodderCash400,000 - - - - 400,000 Replace 488 (2006)1 EA - Back Hoe w/needleCash- 175,000 - - - 175,000 Replace 600 (2010)3 EA - 3/4 Ton Pickup w/extended cab, 4WD, v-plow, CNGCash- 165,000 - - - 165,000 Replace 455, 456, 473 (2011)1 EA - 1 Ton Utility TruckCash- 70,000 - - - 70,000 Replace 474 (2005)1 EA - Vactor/Jet RodderCash- 400,000 - - - 400,000 Replace 486 (2005)1 EA - Sweeper, MechanicalCash- 300,000 - - - 300,000 Replace 4471 (2012)2 EA - Sweeper, VacuumCash- - 550,000 - - 550,000 Replace 4472 (2013) & 4473 (2014)2 EA - Crew TrucksCash- - 352,000 - - 352,000 Replace 458, 472 (2002)1 EA - 3/4 Ton Pick w/standard cab, 4WD, v-plow, CNGCash- - 65,000 - - 65,000 Replace 205 (2011)1 EA - Skid Loader w/attachments & trailerCash- - 125,000 660,000 - 785,000 Replace 291 (2009)2 EA - Sweeper, MechanicalCash- - - 40,000 - 40,000 Replace 4474 (2015) & 4475 (2016)1 EA - ChipperCash- - - - - - Replace 607 (1996)1 EA - Back Hoe w/needleCash- - - - 157,500 157,500 Replace 610 (2015)3 EA - 3/4 Ton Pickup w/extended cab, 4WD, v-plow, CNGCash- - - - 165,000 165,000 Replace 402 (2005), 450 (2015) & 453 (2015)1 EA - Camera TruckCash- - - - 325,000 325,000 Replace 489 (2012)1 EA - Excavator, Rubber TrackCash- - - - 245,000 245,000 Replace 601 (2011)Total Replacement Capital2,655,000 2,263,000 2,147,000 1,901,000 2,012,500 10,978,500 Project CapitalGenerators for the Wastewater PlantCash4,000,000 - - - - 4,000,000 To provide back-up power when needed at WWTPInstall CL2 RAS for Filament controlCash200,000 - - - - 200,000 WWTP process controlSewer LiningCash750,000 - - - - 750,000 To prolong the life of sewer infrastructureLTCPCash750,000 - - - - 750,000 Mandated by consent decreeTotal Project Capital5,700,000 - - - - 5,700,000 Minimum Thresholds:Total Capital8,355,000 2,263,000 2,147,000 1,901,000 2,012,500 16,678,500 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:244 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSEWAGE DEPRECIATION FUND642-0000-360.91-01 POKAGON CONTRIBUTION000 400,000 400,000 400,0000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 400,000 400,000 400,0000642-0000-361.00-00 INTEREST EARNINGS34,993 71,137 45,000 45,000 36,246 28,132 45,000LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST BASED ON FUND BALANCE45,00045,000------------ ------------ ------------ ------------ ------------ ------------ ------------*34,993 71,137 45,000 45,000 36,246 28,132 45,000642-0000-392.00-00 INTERFUND OPER. TRANSFER 8,000,000 2,487,000 4,442,000 4,442,000 1,942,000 1,442,000 8,355,000LEVEL TEXTTEXT AMT02 2018 BUDGET:FOR SEWER DEPT. CAPITAL REQUESTS2,750,000FOR WASTEWATER CAPITAL REQUESTS5,605,0008,355,000------------ ------------ ------------ ------------ ------------ ------------ ------------*8,000,000 2,487,000 4,442,000 4,442,000 1,942,000 1,442,000 8,355,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWAGE DEPRECIATION FUND8,034,993 2,558,137 4,487,000 4,887,000 2,378,246 1,870,132 8,400,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE DEPRECIATION FUND8,034,993 2,558,137 4,487,000 4,887,000 2,378,246 1,870,132 8,400,000Fund 642 - Wastewater/Sewage DepreciationCity of South BendRevenue245 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSEWAGE DEPRECIATION FUND642-0621-415.42-05 SEWER REHABILITATION000000 1,500,000LEVEL TEXTTEXT AMT02 SEWER LINING750,000LTCP750,0001,500,000642-0621-415.43-02 MOTOR EQUIPMENT982,983 118,032 675,000 1,297,130 628,130 628,130 1,250,000LEVEL TEXTTEXT AMT02 2 EA CREW TRUCKS320,0002 EA SINGLE AXLE DUMP TRUCKS300,0001 EA RUBBER TRACK EXCAVATOR200,0002 EA ZTR MOWERS & TRAILER30,0001 EA JET RODDER/VACTOR400,0001,250,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL982,983 118,032 675,000 1,297,130 628,130 628,130 2,750,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWER DEPARTMENT982,983 118,032 675,000 1,297,130 628,130 628,130 2,750,000Fund 642 - Wastewater/Sewage DepreciationCity of South BendExpenditures246 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures642-0630-415.31-06 OTHER PROFESSIONAL SVCS 37,895000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES37,895000000642-0630-415.43-02 MOTOR EQUIPMENT53,959 60,224 152,000 228,294 76,294 76,294 295,000LEVEL TEXTTEXT AMT02 CRANE TRUCK-REPLACE 2000 S/N 470240,0003/4 TON CARGO VAN-REPLACE 2006 S/N 49440,000UTILITY CART-REPLACE 2006 S/N 67615,000295,000642-0630-415.43-08 COMPUTER EQUIP. & NETWORK00 15,000 15,00000 30,000LEVEL TEXTTEXT AMT02 UPGRADE SCADA SERVER #315,000UPGRADE SCADA SERVER #415,00030,000642-0630-415.43-10 MISCELLANEOUS EQUIPMENT0 170,7380 5,192 5,192 5,192 80,000LEVEL TEXTTEXT AMT02 REPLACE AGING ICP EQUIPMENT IN WASTEWATER LAB80,00080,000642-0630-415.43-66 TREATMENT & DISPOSAL EQ. 1,975,527 3,728,482 3,600,000 6,494,839 2,510,915 2,114,129 5,200,000LEVEL TEXTTEXT AMT02 FARMINGTON 14B LIFT STATION REPLACEMENT500,000WWTP ELECTRICAL & BACK-UP GENERATORS4,000,000UPGRADE RAW PUMP #2500,000INSTALL CL2 RAS FOR FILAMENT CONTROL200,0005,200,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL2,029,486 3,959,444 3,767,000 6,743,325 2,592,401 2,195,615 5,605,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT2,067,381 3,959,444 3,767,000 6,743,325 2,592,401 2,195,615 5,605,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE DEPRECIATION FUND3,050,364 4,077,476 4,442,000 8,040,455 3,220,531 2,823,745 8,355,000Fund 642 - Wastewater/Sewage DepreciationCity of South BendExpenditures247 City of South Bend, Indiana 2018 Budget Fund 643 - Sewage Works Reserve Operations & Maint. 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 - - - - - - - - - - - Interest Earnings 20,869 39,734 30,000 21,748 35,000 35,000 35,000 35,000 35,000 5,000 17% Other Income - - - - - - - - - - - Transfers In 256,086 957,725 516,755 516,755 - - - - - (516,755) -100% Total Revenue 276,955 997,459 546,755 538,503 35,000 35,000 35,000 35,000 35,000 (511,755) -94% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out 23,677 35,808 30,000 20,893 35,000 35,000 35,000 35,000 35,000 5,000 17% Other Services & Charges - - - - - - - - - - - Total Services & Charges 23,677 35,808 30,000 20,893 35,000 35,000 35,000 35,000 35,000 5,000 17% Capital - - - - - - - - - - - Total Expenditures 23,677 35,808 30,000 20,893 35,000 35,000 35,000 35,000 35,000 5,000 17% Net Surplus / (Deficit)253,278 961,651 516,755 517,611 - - - - - Beginning Cash Balance 3,416,919 3,668,277 4,627,379 5,153,129 5,153,129 5,153,129 5,153,129 5,153,129 Cash Reserve Cash Adjustments (1,920) (2,549) 8,995 - - - - - Ending Cash Balance 3,668,277 4,627,379 5,153,129 5,153,129 5,153,129 5,153,129 5,153,129 5,153,129 Cash Reserves Target 3,088,958 3,547,044 5,153,129 4,832,667 4,906,721 5,030,759 5,100,099 5,165,507 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 16.67% of Annual operating expenses in Fund 641, net of transfers The purpose of this fund is to hold the equivalent of two month's of Sewage Works (Sewers & Wastewater) budgeted operating expenses in reserve. No adjustment to the reserve balance is budgeted for 2018. Due to increased capital spending, transfers out of Fund 641 to Fund 642 have reduced the net operating budget total subject to O&M reserve requirements. 248 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSEWAGE WORKS O&M RESERVE643-0000-361.00-00 INTEREST EARNINGS20,869 39,734 30,000 30,000 28,309 21,748 35,000LEVEL TEXTTEXT AMT02 ESTIMATE $2,900 PER MO INT. X 12 MOS.35,00035,000------------ ------------ ------------ ------------ ------------ ------------ ------------*20,869 39,734 30,000 30,000 28,309 21,748 35,000643-0000-392.00-00 INTERFUND OPER. TRANSFER 256,086 957,725 23,721 516,755 516,755 516,7550LEVEL TEXTTEXT AMT02 TRANSFER TO ADJUST RESERVE TO 2018 O&M BUDGETRESERVE CALCULATION:2018 SEWAGE WORKS BUDGET = $47,457,7292017 ROLL-OVER P.O. ALLOW. $ 1,000,000LESS: TRANSFERS FOR DEBT, CAPITAL ($19,012,379)EQUALS NET OPERATING COSTS $29,445,350TIMES 2 MOS. RESERVES (X 16.67%) = $4,908,540CURRENT (2017) RESERVE = $5,153,129.15NO RESERVE SHORTAGE IN 2018.------------ ------------ ------------ ------------ ------------ ------------ ------------*256,086 957,725 23,721 516,755 516,755 516,7550------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWAGE WORKS O&M RESERVE276,955 997,459 53,721 546,755 545,064 538,503 35,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE WORKS O&M RESERVE276,955 997,459 53,721 546,755 545,064 538,503 35,000Fund 643 - Wastewater/Sewage O&M Debt ReserveCity of South BendRevenue249 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSEWAGE WORKS O&M RESERVE643-0630-415.50-02 INTER-FUND OPER. TRANSFRS 23,677 35,808 30,000 30,000 27,453 20,893 35,000LEVEL TEXTTEXT AMT02 TRANSFER OUT OF INTEREST EARNINGS TO FUND 64135,000TRANSFER TO ACCT #641-0000-392.00-0035,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES23,677 35,808 30,000 30,000 27,453 20,893 35,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT23,677 35,808 30,000 30,000 27,453 20,893 35,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE WORKS O&M RESERVE23,677 35,808 30,000 30,000 27,453 20,893 35,000Fund 643 - Wastewater/Sewage O&M Debt ReserveCity of South BendExpenditures250 City of South Bend, Indiana 2018 Budget Fund 649 - Sewage Sinking 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 - - - - - - - - - - - Interest Earnings 30,727 37,483 13,000 10,902 13,000 13,000 13,000 13,000 13,000 - 0% Other Income - - - - - - - - - - - Transfers In 9,269,791 9,141,954 9,164,024 4,576,785 9,166,379 7,780,676 7,788,015 7,802,089 7,822,319 2,355 0% Total Revenue 9,300,518 9,179,437 9,177,024 4,587,687 9,179,379 7,793,676 7,801,015 7,815,089 7,835,319 2,355 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal 6,103,712 6,863,032 6,997,472 - 7,147,038 5,931,732 6,076,557 6,236,519 6,406,619 149,566 2% Interest & Fees 3,182,402 2,305,483 2,166,282 1,081,626 2,009,341 1,848,944 1,711,458 1,565,570 1,415,700 (156,941) -7% Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 9,286,114 9,168,515 9,163,754 1,081,626 9,156,379 7,780,676 7,788,015 7,802,089 7,822,319 (7,375) 0% Capital - - - - - - - - - - - Total Expenditures 9,286,114 9,168,515 9,163,754 1,081,626 9,156,379 7,780,676 7,788,015 7,802,089 7,822,319 (7,375) 0% Net Surplus / (Deficit)14,404 10,922 13,270 3,506,061 23,000 13,000 13,000 13,000 13,000 Beginning Cash Balance 789,489 804,674 814,230 827,500 850,500 863,500 876,500 889,500 Cash Reserve Cash Adjustments 781 (1,366) - - - - - - Ending Cash Balance 804,674 814,230 827,500 850,500 863,500 876,500 889,500 902,500 Cash Reserves Target 804,674 814,230 827,500 850,500 863,500 876,500 889,500 902,500 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves per bond covenants This fund is used to pay all debt service obligations for Wastewater and Sewers. Mandatory transfers from Sewage Works Operating Fund #641 are done in specified amounts each month to satisfy bond covenants. Per the City amortization schedules, payments due in 2019-2022 on the 2013A Bond (debt schedule 105) will be significantly lower than the amounts budgeted in 2018. 251 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSEWAGE WORKS SINKING649-0000-361.00-00 INTEREST EARNINGS30,727 37,483 13,000 13,000 16,318 10,902 13,000LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST EARNED ON CASH RESERVES13,000BASED ON MONTHLY TRANSFERS IN TO THE FUND13,000------------ ------------ ------------ ------------ ------------ ------------ ------------*30,727 37,483 13,000 13,000 16,318 10,902 13,000649-0000-392.00-00 INTERFUND OPER. TRANSFER 9,269,791 9,141,954 9,164,024 9,164,024 5,339,583 4,576,785 9,166,379LEVEL TEXTTEXT AMT02 FOR 2018 DEBT SERVICE PAYMENTS9,148,379PER CITY DEBT SCHEDULE MASTERPAYING AGENT FEES8,000TRANSFERS FROM FUND 641-0630-793.50-02INTEREST EARNED ON BOND FUND 661, TO BE USED FOR10,000DEBT SERVICE PAYMENTS. 661-0630-793-50-029,166,379------------ ------------ ------------ ------------ ------------ ------------ ------------*9,269,791 9,141,954 9,164,024 9,164,024 5,339,583 4,576,785 9,166,379------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWAGE WORKS SINKING9,300,518 9,179,437 9,177,024 9,177,024 5,355,901 4,587,687 9,179,379------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE WORKS SINKING9,300,518 9,179,437 9,177,024 9,177,024 5,355,901 4,587,687 9,179,379Fund 649 - Wastewater/Sewage Debt ServiceCity of South BendRevenue252 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSEWAGE WORKS SINKING649-0630-472.38-01 PRINCIPAL5,950,000 6,705,000 6,835,000 6,835,00000 6,980,000LEVEL TEXTTEXT AMT02 2010 SEWAGE WORKS REVENUE BOND DS-80405,0002011 SEWAGE WORKS REVENUE BOND DS-93920,0002012 SEWAGE WORKS REVENUE BOND DS-1011,075,0002013A SEWAGE WORKS REFUNDING BONDS (2) DS-1051,995,0002015 SEWAGE WORKS REFUNDING BONDS (2) DS-1452,585,0006,980,000649-0630-472.38-02 INTEREST3,105,865 2,233,844 2,095,068 2,095,068 1,047,327 1,047,327 1,942,691LEVEL TEXTTEXT AMT02 2010 SEWAGE WORKS REVENUE BOND DS-80282,8182011 SEWAGE WORKS REVENUE BOND DS-93627,4502012 SEWAGE WORKS REVENUE BOND DS-101465,4802013A SEWAGE WORKS REFUNDING BONDS (2) DS-105118,2432015 SEWAGE WORKS REFUNDING BONDS (2) DS-145448,7001,942,691649-0630-472.38-03 PAYING AGENT FEES2,679 3,100 5,000 5,000 2,250 2,250 5,000LEVEL TEXTTEXT AMT02 FEES CHARGED FOR PROCESSING BOND PAYMENTS5,0005,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES9,058,544 8,941,944 8,935,068 8,935,068 1,049,577 1,049,577 8,927,691649-0630-473.38-01 PRINCIPAL 98 BOND SRF153,712 158,032 162,472 162,47200 167,038LEVEL TEXTTEXT AMT02 2009 SEWAGE WORKS REVENUE BOND (SRF) DS-70167,038167,038649-0630-473.38-02 INTEREST SRF BONDS72,858 68,539 63,214 63,214 32,049 32,049 58,650LEVEL TEXTTEXT AMT02 2009 SEWAGE WORKS REVENUE BOND (SRF) DS-7058,65058,650649-0630-473.38-03 PAYING AGENT FEES1,0000 3,000 3,00000 3,000LEVEL TEXTTEXT AMT02 FEES CHARGED BY BANKS FOR PROCESSING PAYMENTS3,0003,000* OTHER SERVICES & CHARGES** WASTEWATER DEPARTMENT*** SEWAGE WORKS SINKING------------ ------------ ------------ ------------ ------------ ------------ ------------227,570 226,571 228,686 228,686 32,049 32,049 228,688------------ ------------ ------------ ------------ ------------ ------------ ------------9,286,114 9,168,515 9,163,754 9,163,754 1,081,626 1,081,626 9,156,379------------ ------------ ------------ ------------ ------------ ------------ ------------9,286,114 9,168,515 9,163,754 9,163,754 1,081,626 1,081,626 9,156,379Fund 649 - Wastewater/Sewage Debt ServiceCity of South BendExpenditures253 City of South Bend, Indiana 2018 Budget Fund 653 - Sewage Debt Service Reserve 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 - - - - - - - - - - - Interest Earnings 3 6,009 4,400 6,777 14,700 14,700 14,700 14,700 14,700 10,300 234% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 3 6,009 4,400 6,777 14,700 14,700 14,700 14,700 14,700 10,300 234% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees 3,181,211 - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 3,181,211 - - - - - - - - - - Capital - - - - - - - - - - - Total Expenditures 3,181,211 - - - - - - - - - - Net Surplus / (Deficit)(3,181,208) 6,009 4,400 6,777 14,700 14,700 14,700 14,700 14,700 Beginning Cash Balance 7,286,832 4,105,624 4,111,633 4,116,033 4,130,733 4,145,433 4,160,133 4,174,833 Cash Reserve Cash Adjustments - - - - - - - - Ending Cash Balance 4,105,624 4,111,633 4,116,033 4,130,733 4,145,433 4,160,133 4,174,833 4,189,533 Cash Reserves Target 4,105,624 4,111,633 4,116,033 4,130,733 4,145,433 4,160,133 4,174,833 4,189,533 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves per bond covenants and Crowe Horwath This fund accounts for required debt service reserves as required by bond documents. Increase in interest income is based on year to date trend in 2017. 254 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSEWAGE WORKS DS RESERVE653-0630-361.00-00 INTEREST EARNINGS3 6,009 4,400 4,400 8,951 6,777 14,700LEVEL TEXTTEXT AMT02 ESTIMATED $1,225/MONTH X 12 MONTHS14,700BASED ON 2017 HISTORICAL REVENUE.14,700------------ ------------ ------------ ------------ ------------ ------------ ------------*3 6,009 4,400 4,400 8,951 6,777 14,700------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT3 6,009 4,400 4,400 8,951 6,777 14,700------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE WORKS DS RESERVE3 6,009 4,400 4,400 8,951 6,777 14,700Fund 653 - Sewage Works Debt Service ReserveCity of South BendRevenue255 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSEWAGE WORKS DS RESERVE653-0630-793.38-05 BOND PRINCIPAL REFUNDING 3,181,211000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES3,181,211000000------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT3,181,211000000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE WORKS DS RESERVE3,181,211000000Fund 653 - Sewage Works Debt Service ReserveCity of South BendExpenditures256 City of South Bend, Indiana 2018 Budget Fund 661 - Sewer Bond 2012 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 Interest Earnings 92,792 96,136 50,000 12,292 10,000 - - - - (40,000) -80% Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In 5 - - - - - - - - - - Total Revenue 92,797 96,136 50,000 12,292 10,000 - - - - (40,000) -80% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 1,937 - 250,000 - - - - - - (250,000) -100% Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - 10,000 - - - - 10,000 - Other Services & Charges - - - - - - - - - - - Total Services & Charges 1,937 - 250,000 - 10,000 - - - - (240,000) -96% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.520,250 9,470,447 621,450 497,305 - - - - - (621,450) -100% Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 2,479,833 1,649,375 2,138,914 351,244 - - - - - (2,138,914) -100% Total Capital 3,000,083 11,119,822 2,760,364 848,549 - - - - - (2,760,364) -100% Total Expenditures 3,002,020 11,119,822 3,010,364 848,549 10,000 - - - - (3,000,364) -100% Net Surplus / (Deficit)(2,909,223) (11,023,686) (2,960,364) (836,256) - - - - - Beginning Cash Balance 16,801,222 13,888,878 2,881,288 - - - - - Cash Reserve Cash Adjustments (3,120) 16,096 79,076 - - - - - Ending Cash Balance 13,888,878 2,881,288 - - - - - - Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: Bond fund - spend down to zero - no reserves required This fund accounts for expenditures of bond proceeds. This bond has been fully encumbered in 2017. Any expenses recorded in 2018 will be from purchase order carry overs. Some interest revenue will likely be earned until cash balance is completely spent. Any interest earned will be transferred to the debt service Fund 649 to be applied to future payments. 257 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue2012 SEWER BOND661-0000-361.00-00 INTEREST EARNINGS92,792 96,136 50,000 50,000 14,959 12,292 10,000LEVEL TEXTTEXT AMT02 REMAINING CASH BALANCE BEING SPENT DOWN,10,000LESS INTEREST EARNED IN 2018.10,000------------ ------------ ------------ ------------ ------------ ------------ ------------*92,792 96,136 50,000 50,000 14,959 12,292 10,000661-0000-392.00-00 INTERFUND OPER. TRANSFER5000000------------ ------------ ------------ ------------ ------------ ------------ ------------*5000000------------ ------------ ------------ ------------ ------------ ------------ ------------** 2012 SEWER BOND92,797 96,136 50,000 50,000 14,959 12,292 10,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** 2012 SEWER BOND92,797 96,136 50,000 50,000 14,959 12,292 10,00077,652,031 77,161,296 78,346,606 77,577,979 46,554,711 37,794,102 82,337,265Fund 661 - 2012 Sewer BondCity of South BendRevenue258 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures2012 SEWER BOND661-0415-415.31-01 LEGAL SERVICES1,937000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES1,937000000------------ ------------ ------------ ------------ ------------ ------------ ------------** HALL OF FAME1,937000000Fund 661 - 2012 Sewer BondCity of South BendExpenditures259 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures661-0621-415.31-02 ENGINEERING00 200,000 200,000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 200,000 200,000000661-0621-415.42-05 SEWER REHABILITATION 2,479,833 1,649,375 300,000 2,138,914 780,712 351,2440------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL2,479,833 1,649,375 300,000 2,138,914 780,712 351,2440661-0621-415.50-02 INTER-FUND OPER. TRANSFRS000000 10,000LEVEL TEXTTEXT AMT02 TRANSFER FINAL INTEREST AND FUND BALANCE TO10,000DEBT SERVICE FUND 64910,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES000000 10,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWER DEPARTMENT2,479,833 1,649,375 500,000 2,338,914 780,712 351,244 10,000Fund 661 - 2012 Sewer BondCity of South BendExpenditures260 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures661-0630-415.31-02 ENGINEERING00 50,000 50,000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 50,000 50,000000661-0630-415.42-06 WASTEWATER PLANT520,250 9,470,447 450,000 621,450 1,056,681 497,3050------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL520,250 9,470,447 450,000 621,450 1,056,681 497,3050------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT520,250 9,470,447 500,000 671,450 1,056,681 497,3050------------ ------------ ------------ ------------ ------------ ------------ ------------*** 2012 SEWER BOND3,002,020 11,119,822 1,000,000 3,010,364 1,837,393 848,549 10,000Fund 661 - 2012 Sewer BondCity of South BendExpenditures261