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 (4) Financials - Water Works
City of South Bend, Indiana 2018 Budget Fund 620 - Water 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 Charges for Services 14,288,227 15,041,060 15,570,122 6,852,156 16,998,852 19,901,962 19,935,818 19,970,360 20,005,597 1,428,730 9% Interest Earnings 24,939 30,590 35,000 12,779 35,000 36,050 37,132 38,245 39,393 - 0% Other Income 61,848 65,874 83,000 19,412 72,500 70,500 70,500 70,500 70,500 (10,500) -13% Transfers In 43,661 45,514 62,500 30,671 63,000 64,950 66,895 68,905 68,965 500 1% Total Revenue 14,418,675 15,183,038 15,750,622 6,915,018 17,169,352 20,073,462 20,110,345 20,148,010 20,184,455 1,418,730 9% Expenditures by Type Personnel Salaries & Wages 3,291,209 3,493,369 3,745,168 1,709,214 3,783,323 3,871,633 3,927,495 3,983,775 4,040,971 38,155 1% Fringe Benefits 1,378,399 1,623,493 1,858,989 848,337 1,936,753 1,976,584 2,010,764 2,045,479 2,080,846 77,764 4% Total Personnel 4,669,608 5,116,862 5,604,157 2,557,551 5,720,076 5,848,217 5,938,259 6,029,254 6,121,817 115,919 2% Supplies 1,386,062 1,180,467 1,727,233 555,907 1,424,736 1,467,482 1,511,504 1,556,845 1,603,557 (302,497) -18% Services & Charges Professional Services 1,592,672 1,310,806 1,958,002 581,486 1,893,510 1,625,341 1,587,602 1,709,101 1,673,871 (64,492) -3% Printing & Advertising 1,971 3,209 5,430 193 5,280 5,439 5,601 5,770 5,943 (150) -3% Utilities 686,836 725,324 731,900 323,490 740,050 762,574 785,451 809,015 833,285 8,150 1% Education & Training 7,259 4,249 31,445 9,820 25,175 25,930 26,709 27,509 28,335 (6,270) -20% Travel 4,442 3,031 18,750 2,493 18,750 19,313 19,892 20,489 21,103 - 0% Repairs & Maintenance 347,146 344,463 566,579 159,134 380,310 390,605 402,328 414,402 426,833 (186,269) -33% Payment In Lieu of Taxes 1,942,608 2,039,748 1,785,919 892,962 1,730,831 1,765,448 1,800,757 1,836,772 1,873,507 (55,088) -3% Other Interfund Allocations 452,308 741,247 1,188,996 594,498 1,181,266 1,204,891 1,228,990 1,253,568 1,278,641 (7,730) -1% Debt Service Principal 6,763 111,630 304,973 104,858 398,008 408,942 416,166 306,184 214,277 93,035 31% Interest & Fees 1,361 9,472 23,880 8,128 35,914 24,567 16,932 9,717 4,045 12,034 50% Insurance 158,136 134,484 161,529 80,766 158,252 161,417 164,645 167,938 171,297 (3,277) -2% Transfers Out 2,193,528 2,273,521 2,120,891 1,135,272 2,000,217 5,415,041 4,570,986 4,326,083 4,334,522 (120,674) -6% Other Services & Charges 1,405,379 1,458,784 1,497,570 549,699 1,511,170 1,576,398 1,617,837 1,660,569 1,704,497 13,600 1% Total Services & Charges 8,800,409 9,159,968 10,395,864 4,442,798 10,078,733 13,385,906 12,643,896 12,547,117 12,570,156 (317,131) -3% Capital - - - - - - - - - - - Total Expenditures 14,856,079 15,457,297 17,727,254 7,556,257 17,223,545 20,701,605 20,093,659 20,133,216 20,295,530 (503,709) -3% Net Surplus / (Deficit)(437,404) (274,259) (1,976,632) (641,239) (54,193) (628,143) 16,686 14,794 (111,075) Beginning Cash Balance 4,298,441 3,889,248 3,801,473 1,832,230 1,778,037 1,149,894 1,166,580 1,181,374 Cash Reserve Cash Adjustments 28,212 186,484 7,389 - - - - - Ending Cash Balance 3,889,248 3,801,473 1,832,230 1,778,037 1,149,894 1,166,580 1,181,374 1,070,299 Cash Reserves Target 742,804 772,865 886,363 861,177 1,035,080 1,004,683 1,006,661 1,014,777 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 5% of Annual expenditures This fund was established to account for all revenue and operational expenses of the water utility. This fund provides the monies for debt service obligations, reserve requirements and revenue funded capital improvements through transfer of monies to other funds within the utility operations. Results from an Accounting Report on Rate Study, which was provided in October 2016, reflect an approximate across the board increase in rate and charges of 43.0%. Ordinance 10479-77 was approved in March 2017 with intent of a two year rate phase in. The Water Rate Case in presently underway. Revenue assumptions based on retail water sales and fire protection in 2018 includes nine (9) months of additional revenue at a rate of 22%. Forward projections are 12 months with the additional 21% remaining. Beginning in 2019, annual pay-as-you-go transfers out are forecasted for funding capital improvement expenditures. 131 City of South Bend, Indiana 2018 Budget Fund 620 - Water 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 100% 100% 100% 100% -output 96% 97% 96% 96% - - - - - Types: output, efficiency, effectiveness, quality, outcome, technology 2018 Significant Changes/Challenges/Opportunities - - - - - - - - - - Drinking Water Compliance Service Orders completed on time Drinking Water Compliance - 100% Work Orders Completed on Schedule - 96.7% Telephone Call Response - 92.3% of calls were answered Excellent Services and Efficient Processes - Goal of 96% Service Orders completed on time Safe Community for Everyone - 100% Compliance with Drinking Water Standards 132 City of South Bend, Indiana 2018 Budget Fund 620 - Water 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 Finance (Water Utility)1.0 - - - - - - - Director of Distributions 1.0 1.0 1.0 - - - - - Maintenance Manager *Title Change - - - 1.0 1.0 1.0 1.0 1.0 Director of Treatment 1.0 - - - - - - - Director of SCADA Information Systems 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Director of Utility Safety 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Chemist (3 @ .25 ea)0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 Chemist Lead 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 Manager-Environmental Compliance 0.5 0.5 0.5 - - - - - Manager-Utility Purchasing & Storeroom 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 Distribution System Specialist 1.0 1.0 - - - - - - Superintendent V 2.1 2.0 2.0 2.0 2.0 2.0 2.0 2.0 System Specialist III 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 System Specialist IV 0.5 0.5 0.5 - - - - - Asst Dir of SCADA Infor Syst*Title Change - - - 0.5 0.5 0.5 0.5 0.5 Utilities System Specialist 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Assistant Director of Treatment 1.0 - - - - - - - Administrative Assistant I 0.1 0.1 0.1 - - - - - Financial Specialist Senior 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Financial Specialist IV 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Financial Specialist III 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Water Treatment Operator PF 2.0 - - - - - - - Quality Assurance Distribution Tech 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Water Quality Specialist 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Customer Service Supervisor 2.0 - - - - - - - Distribution Records Drafter 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Engineering Aide IV 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Locator 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Director of Customer Service & Billing Office 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director of Water Quality & Laboratory 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Director of Wastewater Maintenance 0.1 - - - - - - - Manager-Operations - - - - - - - - SCADA Instrument Specialist 0.2 - - - - - - - Manager - Operations 0.1 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager - Operations Distribution - 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 Supervisor - Operations - 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Manager - Customer Service - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Assistant Manager - Customer Service - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Total Non-Bargaining 28.9 28.4 27.4 26.8 26.8 26.8 26.8 26.8 Bargaining Job Leader 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 Heavy Equipment Operator II 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Heavy Equipment Operator I 3.0 4.0 3.0 3.0 3.0 3.0 3.0 3.0 Machinist 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Operator II 2.0 2.0 1.0 2.0 2.0 2.0 2.0 2.0 Operator I 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Field Repairman/Inspector III 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Field Repairman/Inspector II 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Field Repairman/Inspector I 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Group Leader-Meter Reading 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Meter Serviceman IV 8.0 8.0 8.0 8.0 8.0 8.0 8.0 8.0 Maintenance Tech II 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Maintenance Tech I 2.0 3.0 2.0 4.0 4.0 4.0 4.0 4.0 Auditor I 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Customer Service & Billing 4.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 Data Processor 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Total Bargaining 40.0 43.0 40.0 43.0 43.0 43.0 43.0 43.0 Total Full-Time Employees 68.9 71.4 67.4 69.8 69.8 69.8 69.8 69.8 Explain Significant Staffing Changes Below: Reductions: Distribution System Specialist (NB) -1.0, Manager-Environmental Compliance (NB) -.50, Administrative Assistant I (NB) -.10 Utilities Dept Total Reduction 1.60 133 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueWATERWORKS GENERAL FUND620-0000-346.01-10 METERED SALES-RESIDENTIAL 4,898,908 5,062,204 5,795,673 5,100,000 3,038,511 2,338,595 5,897,468LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE5,897,468RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)5,897,468620-0000-346.01-20 METERED SALES-COMMERCIAL 1,463,223 1,483,874 1,726,242 1,515,000 880,364 706,988 1,643,676LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE1,643,676RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)1,643,676620-0000-346.01-30 METERED SALES-INDUSTRIAL 317,971 305,046 365,329 350,000 182,575 151,851 333,656LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE333,656RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)333,656620-0000-346.01-40 METERED SALES-MULTI FAMLY 758,031 783,555 881,871 805,000 463,822 375,305 867,387LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE867,387RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)867,387620-0000-346.01-50 BULK SALES - OLIVE ST.2,619 3,813 4,234 4,234 1,943 1,711 4,186LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE4,1864,186620-0000-346.01-60 METERED SALES-INSTITUTION 82,873 86,987 95,566 95,566 50,515 40,152 95,612LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE95,612RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)95,612620-0000-346.02-10 PUBLIC FIRE PROTECTION 1,533,464 1,537,217 1,856,890 1,555,000 949,076 773,858 1,704,355LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE1,704,355RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)1,704,355Fund 620 - Water Works OperationsCity of South BendRevenue134 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue620-0000-346.02-20 PRIVATE FIRE PROTECTION 283,971 288,640 336,297 296,000 176,431 145,611 319,581LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE319,581RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)319,581620-0000-346.03-00 SALES-PUBLIC AUTHORITIES 282,163 287,398 349,603 300,000 175,596 132,692 317,626LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE317,626RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)317,626620-0000-346.04-00 METERED SALES-IRRIGATION 771,041 1,024,234 1,091,149 1,091,149 410,252 124,580 1,129,540LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE1,129,540RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)1,129,540620-0000-346.06-10 PENALTIES (FORFEIT DISC.) 106,088 74,433 105,000 80,000 42,015 33,384 82,000LEVEL TEXTTEXT AMT02 ANTICIPATE MINIMAL CHANGE82,00082,000620-0000-346.06-20 OTHER WATER/MISC SERVICE 435,971 419,736 496,686 400,000 207,905 157,474 435,000LEVEL TEXTTEXT AMT02 NONRECURRING CHARGES (ANTICIPATE CHANGE IN RATES)435,000CHARGE TYPES: TAP FEES,DELINQUENCY PROCESSING FEE,NSF CHARGE BACK FEE, SERVICE INITIATION FEE,ETC.435,000620-0000-346.06-22 BACKFLOW PREVENTION INSP. 126,400 111,250 143,954 143,954 87,350 71,575 120,000LEVEL TEXTTEXT AMT02 BASED ON TWO YEAR AVERAGE 2016/2015120,000120,000620-0000-346.06-25 SYSTEM DEVELOPMENT FEE0000 12,113 3,183 25,000620-0000-346.06-32 MGMT FEE - WASTE WATER 1,022,364 1,261,956 1,442,856 1,442,856 841,666 721,428 1,444,188LEVEL TEXTTEXT AMT02 UTILITY CUSTOMER SERVICE CHARGE1,444,188ALLOCATION NO.6Fund 620 - Water Works OperationsCity of South BendRevenue135 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue1,444,188620-0000-346.06-33 MGMT FEE - SOLID WASTE132,480 140,568 156,768 156,768 91,448 78,384 171,444LEVEL TEXTTEXT AMT02 UTILITY CUSTOMER SERVICE CHARGE171,444ALLOCATION NO. 6171,444620-0000-346.06-34 MGMT FEE - PROJECT RELEAF 11,796 12,432 13,740 13,740 8,015 6,870 13,740LEVEL TEXTTEXT AMT02 UTILITY CUSTOMER SERVICE CHARGE13,740ALLOCATION NO. 613,740620-0000-346.06-40 RENTS FROM WATER PROPERTY 17,548 16,198 19,597 19,597 10,984 8,099 20,000LEVEL TEXTTEXT AMT02 WATER TOWER CELLULAR ANTENNA LEASE20,000"ANTENNAS ATOP THE IRELAND RD TANK"20 YEAR LEASE EXPIRES IN 10/201820,000620-0000-346.06-52 REVENUE FROM CUT OFF FEES 2,475 3,375 6,049 6,049 2,025 1,875 5,000LEVEL TEXTTEXT AMT02 NONRECURRING CHARGE - DEMOLITION/INSPECTION FEE5,0005,000620-0000-346.06-54 MISC. WATER REVENUES00 22,623 22,623000------------ ------------ ------------ ------------ ------------ ------------ ------------*12,249,386 12,902,916 14,910,127 13,397,536 7,632,606 5,873,615 14,629,459620-0000-360.00-00 MISCELLANEOUS REVENUE2,03311 2,500 2,500267234 2,500620-0000-360.02-00 SALE OF SCRAP METAL3,286 41,328 20,000 20,000 4,257 4,257 20,000LEVEL TEXTTEXT AMT02 SCRAP METAL PROCEEDS FROM RETIRED WATER METERS20,000AND OTHER MISC SOURCES20,000620-0000-360.51-00 INSURANCE REIMBURSEMENT5,4550 2,500 2,500000------------ ------------ ------------ ------------ ------------ ------------ ------------*10,774 41,339 25,000 25,000 4,524 4,491 22,500620-0000-361.00-00 INTEREST EARNINGS24,939 30,590 35,000 35,000 16,010 12,779 35,000LEVEL TEXTTEXT AMTFund 620 - Water Works OperationsCity of South BendRevenue136 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue02 BASED ON CURRENT EARNINGS TREND35,00035,000------------ ------------ ------------ ------------ ------------ ------------ ------------*24,939 30,590 35,000 35,000 16,010 12,779 35,000620-0000-380.10-60 WATER - MAIN EXTENSIONS2,704 1,358 3,000 3,0003092920620-0000-380.10-99 MISC. REIMBURSEMENTS6,437 12,353 10,000 20,000 14,779 14,629 15,000------------ ------------ ------------ ------------ ------------ ------------ ------------*9,141 13,711 13,000 23,000 15,088 14,921 15,000620-0000-391.01-00 SALE OF FIXED ASSETS8,418 5,313 15,000 15,00000 15,000LEVEL TEXTTEXT AMT02 AUCTION PROCEEDS FROM SALE OF VEHICLES & LG EQUIP15,00015,000620-0000-391.02-21 HYDRANT DAMAGE REIMB.33,5150 20,000 20,00000 20,000LEVEL TEXTTEXT AMT02 HYDRANT HIT PROPERTY DAMAGE CLAIM RECOVERY20,00020,000620-0000-391.02-22 VEHICLE DAMAGE REIMB.0 5,51100000------------ ------------ ------------ ------------ ------------ ------------ ------------*41,933 10,824 35,000 35,00000 35,000620-0000-392.00-00 INTERFUND OPER. TRANSFER 43,661 45,514 62,500 62,500 37,187 30,671 63,000LEVEL TEXTTEXT AMT02 INTEREST EARNINGS FROM OTHER RESTRICTED FUNDSDEPOSIT FUND ACCT #624-0640-658.50-0215,000SINKING FUND ACCT #625-0640-658.50-029,000BOND RESERVE FUND ACCT #626-0640-658.50-0216,000O&M RESERVE FUND ACCT #629-0640-658.50-0223,00063,000------------ ------------ ------------ ------------ ------------ ------------ ------------*43,661 45,514 62,500 62,500 37,187 30,671 63,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATERWORKS GENERAL FUND12,379,834 13,044,894 15,080,627 13,578,036 7,705,415 5,936,477 14,799,959Fund 620 - Water Works OperationsCity of South BendRevenue137 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue620-0630-344.07-30 WATER LEAK INSURANCE959,779 974,068 1,173,361 980,000 603,694 488,922 1,012,683LEVEL TEXTTEXT AMT02 ASSUMPTION BASE INCLUDES 9 MONTHS OF NEW PROPOSED 1,012,683RATE OF $2.10 / MONTH (APPROX 40,670 CUSTOMERS)RATE ORDINANCE 10479-771,012,683------------ ------------ ------------ ------------ ------------ ------------ ------------*959,779 974,068 1,173,361 980,000 603,694 488,922 1,012,683------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT959,779 974,068 1,173,361 980,000 603,694 488,922 1,012,683Fund 620 - Water Works OperationsCity of South BendRevenue138 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue620-0660-346.01-10 METERED SALES-RESIDENTIAL 483,595 522,131 561,301 525,000 282,394 226,913 608,283LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE608,283RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)608,283620-0660-346.01-20 METERED SALES-COMMERCIAL 195,687 207,828 221,375 210,000 118,924 99,315 242,120LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE242,120RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)242,120620-0660-346.01-40 METERED SALES-MULTI FAMLY 95,890 97,276 105,244 105,244 53,744 46,849 113,327LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE113,327RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)113,327620-0660-346.02-10 PUBLIC FIRE PROTECTION153,637 156,267 185,084 160,000 91,272 78,147 182,051LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE182,051RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)182,051620-0660-346.02-20 PRIVATE FIRE PROTECTION 17,162 18,304 20,565 20,565 10,791 9,249 21,324LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE21,324RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)21,324620-0660-346.04-00 METERED SALES-IRRIGATION 128,130 159,746 164,519 164,519 60,624 28,218 186,105LEVEL TEXTTEXT AMT02 ASSUMPTION BASE: 9 MONTHS (2016) X 22% INCREASE186,105RATE ORDINANCE 10479-77 (1ST OF 2 INCREASES)186,105620-0660-346.06-10 PENALTIES (FORFEIT DISC.) 4,961 2,524 7,258 7,258 1,193927 3,500------------ ------------ ------------ ------------ ------------ ------------ ------------*1,079,062 1,164,076 1,265,346 1,192,586 618,942 489,619 1,356,710------------ ------------ ------------ ------------ ------------ ------------ ------------** CLAY WATER1,079,062 1,164,076 1,265,346 1,192,586 618,942 489,619 1,356,710*** WATERWORKS GENERAL FUND------------ ------------ ------------ ------------ ------------ ------------ ------------14,418,675 15,183,038 17,519,334 15,750,622 8,928,051 6,915,018 17,169,352Fund 620 - Water Works OperationsCity of South BendRevenue139 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresWATERWORKS GENERAL FUND620-0630-711.61-02 PLUMBING CONTRACTORS966,036 1,014,438 1,025,000 1,025,000 413,002 310,267 1,025,000LEVEL TEXTTEXT AMT02 WATER INSURANCE SERVICE LINE LEAK REPAIRS1,025,0001,025,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES966,036 1,014,438 1,025,000 1,025,000 413,002 310,267 1,025,000620-0630-751.74-01 BAD DEBT EXPENSE6,286 6,198 10,000 10,000 3,401 2,887 10,000LEVEL TEXTTEXT AMT02 UNCOLLECTABLE ACCOUNTS RECEIVABLE10,00010,000------------ ------------ ------------ ------------ ------------ ------------ ------------*6,286 6,198 10,000 10,000 3,401 2,887 10,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT972,322 1,020,636 1,035,000 1,035,000 416,403 313,154 1,035,000Fund 620 - Water Works OperationsCity of South BendExpenditures140 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures620-0640-601.21-05 SMALL OFFICE EQUIPMENT00 2,500 2,50000500620-0640-601.22-01 GENERATOR FUEL3,319 1,463 4,000 4,00000 3,000LEVEL TEXTTEXT AMT02 GENERATOR FUEL (1200 GAL X $2.50/GAL)3,0003,000620-0640-601.22-06 COMPUTER SUPPLIES21,332050050000500LEVEL TEXTTEXT AMT02 BASIC COMPUTER SUPPLIES500500620-0640-601.23-01 BUILDING MATERIALS1,248332 5,000 5,000427413 3,000LEVEL TEXTTEXT AMT02 MAINTENANCE MATERIALS FOR WELL HOUSES3,000AND FILTRATION BUILDINGS3,000620-0640-601.23-10 REPAIR PARTS4,384 9,029 40,675 70,103 25,702 25,702 45,000LEVEL TEXTTEXT AMT02 30 WELLS X $116735,000OTHER MISCELLANEOUS PARTS10,00045,000620-0640-601.23-20 SMALL TOOLS & EQUIPMENT2,982000000620-0640-601.23-21 C.S. SMALL TOOLS & EQUIP090500500100100250620-0640-601.23-62 MATERIALS & SUPPLIES2,026 1,389 6,900 6,900 1,366969 2,000LEVEL TEXTTEXT AMT02 O&M WATER SYSTEM MATERIALS2,0002,000620-0640-601.24-05 OTHER OPERATING SUPPLIES2,4998500000620-0640-601.24-51 NON-CAPITAL OFFICE EQUIP.0 8,67400000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES37,790 21,062 60,075 89,503 27,595 27,184 54,250620-0640-601.35-01 ELECTRIC632,538 665,169 650,000 650,000 308,770 296,660 667,000LEVEL TEXTTEXT AMT02 ELECTRICITY FOR ALL DISTRIBUTION SITES667,000667,000620-0640-601.35-02 HEATING FUEL (GAS)531000000620-0640-601.37-04 UNIFORM RENTAL5,090000000Fund 620 - Water Works OperationsCity of South BendExpenditures141 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES638,159 665,169 650,000 650,000 308,770 296,660 667,000620-0640-602.31-06 OTHER PROFESSIONAL SVCS 70,222 92,353 140,000 147,479 54,684 52,880 125,000LEVEL TEXTTEXT AMT02 ELECTRICAL TECHNICIAN35,000PLC TECHNICIAN25,000WELL CLEANING (2)50,000GROUND WATER SAMPLING15,000125,000620-0640-602.31-35 CONTRACTUAL SERV. OTHER 29,833 31,221 35,960 38,850 10,027 9,291 42,500LEVEL TEXTTEXT AMT02 OFFICE CLEANING-NORTH PUMPING STATION9,000CATHODIC MONITORING1,500HVAC PREVENTATIVE MAINT-MULTIPLE LOCATIONS20,000GENERATOR(S) PREVENTATIVE MAINTENANCE6,500MISC SERVICES5,50042,500620-0640-602.36-01 BUILDING R&M30,352 2,73800000620-0640-602.36-02 OFFICE EQUIP R&M480913 1,050 1,050551410 1,050LEVEL TEXTTEXT AMT02 COPIER MAINT AGREEMENT - COPIES1,0501,050620-0640-602.36-05 OTHER EQUIP R&M95,045 103,191 96,000 146,564 36,202 36,202 120,000LEVEL TEXTTEXT AMT02 SERVICE WORK ON PUMPS/MOTOR & EQUIPMENT120,000120,000620-0640-602.37-11 CAPITAL LEASE PRINCIPAL1,916 1,017995995572489 1,049LEVEL TEXTTEXT AMT02 2013 WATER WORKS NORTH STATION COPIER #1341,0491,049620-0640-602.37-12 CAPITAL LEASE INTEREST3851599595615337LEVEL TEXTTEXT AMT02 2013 WATER WORKS NORTH STATION COPIER #1343737------------ ------------ ------------ ------------ ------------ ------------ ------------Fund 620 - Water Works OperationsCity of South BendExpenditures142 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures* OTHER SERVICES & CHARGES228,233 231,592 274,100 335,033 102,097 99,326 289,636620-0640-603.21-02 PRINT SHOP12475656252256LEVEL TEXTTEXT AMT02 MATERIALS5656620-0640-603.21-03 C.S. OFFICE SUPPLIES293505510510162106510620-0640-603.21-04 OTHER OFFICE SUPPLIES911 2,513 6,000 6,098 1,318 1,176 3,000LEVEL TEXTTEXT AMT02 MISC SUPPLIES3,0003,000620-0640-603.22-07 LANDSCAPING MATERIAL779 2,423 3,050 3,050803473 3,050620-0640-603.22-20 C.S. - MEDICAL/SAFETY1,068 1,476 1,500 1,500718459 1,500LEVEL TEXTTEXT AMT02 VESTS, GLOVES, GOGGLES1,50010 EMPLOYEES X $150 EA1,500620-0640-603.22-21 C.S. CLEANING SUPPLIES1,260 1,017500500393340500LEVEL TEXTTEXT AMT02 CLEANING SUPPLIES FOR ALL SITES500500620-0640-603.22-22 MEDICAL/SAFETY SUPPLIES 14,054 16,922 17,000 17,000 13,370 12,605 14,000LEVEL TEXTTEXT AMT02 SAFETY SUPPLIES14,000SELF CONTAINED BREATHING APPARATUS (2)14,000620-0640-603.22-25 CHEMICALS130,947 126,969 150,000 166,368 80,436 54,251 150,000LEVEL TEXTTEXT AMT02 CHLORINE,PUREX SALT,HYDROFLUORISILICIC ACID,150,000POLYPHOSPHATE150,000620-0640-603.23-10 REPAIR PARTS67,184000000620-0640-603.23-20 SMALL TOOLS & EQUIPMENT3,661 29,781 11,000 17,170 7,519 7,329 11,000620-0640-603.23-60 LAB MATERIALS & SUPPLIES00 49,220 49,220 27,651 21,750 49,220LEVEL TEXTTEXT AMTFund 620 - Water Works OperationsCity of South BendExpenditures143 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 CHEMICALS,MATERIALS,SUPPLIES25,500LAB EQUIPMENT REPLACEMENT (UNANTICIPATED)7,000REAGENT WATER ION EXCHANGE TANKS3,500ICP GASES6,670MISC6,55049,220620-0640-603.23-62 MATERIALS & SUPPLIES8,594 45,316 13,200 13,599 1,119990 13,200LEVEL TEXTTEXT AMT02 MISC HARDWARE SUPPLY ITEMS13,20013,200620-0640-603.24-05 OTHER OPERATING SUPPLIES9,852 6,09700000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES238,615 233,066 252,036 275,071 133,514 99,500 246,036620-0640-603.31-35 OTHER4,699 57,376 65,760 70,768 16,832 16,228 65,760LEVEL TEXTTEXT AMT02 WATER QUALITY TECHNICAL SERVICES50,000FIRE ALARM MONITOR/TEST2,500FIRE EXTINQUISHER & SPRINKLER SYST INSPECT2,000ICP CONTRACT9,700CRANE INSPECTION560MISC SERVICES1,00065,760620-0640-603.31-37 COMPUTER RELATED SERVICES0 7,765 21,000 21,00000 16,000LEVEL TEXTTEXT AMT02 TECH CONNECT SOFTWARE SUPPORT-SCADA16,00016,000620-0640-603.31-51 LABORATORY WATER TESTING 127,589 12,068 50,000 51,131 13,632 11,927 50,000LEVEL TEXTTEXT AMT02 REQUIRED WATER TESTING50,00050,000620-0640-603.32-04 TELEPHONE37,775 33,951 40,000 40,000 24,237 21,223 40,000LEVEL TEXTTEXT AMT02 SERVICE FOR SCADA CONNECTIVITY - 17 SITES40,00040,000620-0640-603.35-02 HEATING FUEL (GAS)27,815 41,892 50,000 50,000 16,847 14,529 50,000LEVEL TEXTTEXT AMTFund 620 - Water Works OperationsCity of South BendExpenditures144 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 NATURAL GAS HEAT FOR ALL DISTRIBUTION SITES50,00050,000620-0640-603.36-03 AUTO EQUIPMENT R&M6,736000000620-0640-603.36-05 OTHER EQUIP R&M3,929 22,49100000620-0640-603.37-04 UNIFORM RENTAL2,728 6,279 8,475 8,475 2,915 2,331 7,500LEVEL TEXTTEXT AMT02 UNIFORM/MAT RENTALS- NORTH STATION FACILITY7,5007,500620-0640-603.39-70 EDUCATION & TRAINING3,418 2,702 10,000 15,898 6,725 6,518 10,000LEVEL TEXTTEXT AMT02 SCADA CONFERENCE400AWWA STATE CONFERENCE250AWWA DISTRICT SPRING & FALL CONFERENCES120AWWA NATIONAL CONFERENCE750VARIOUS MISC SEMINARS6,740CERTIFICATIONS $30/EA60CERTIFICATION TUITION & TEXTBOOKS1,68010,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES214,689 184,524 245,235 257,272 81,188 72,757 239,260620-0640-604.23-10 REPAIR PARTS59,899 215,080 275,000 318,526 122,801 102,673 275,000LEVEL TEXTTEXT AMT02 REPAIR PARTS - MISC SITES275,000275,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES59,899 215,080 275,000 318,526 122,801 102,673 275,000620-0640-604.31-06 OTHER PROFESSIONAL SVCS595000000620-0640-604.31-35 CONTRACTUAL SERV. - OTHER849000000620-0640-604.36-01 BUILDING R&M4,758 6,618 21,000 21,000 2,118 1,020 5,000LEVEL TEXTTEXT AMT02 SERVICE FOR VARIOUS FACILITY SITES5,0005,000620-0640-604.36-05 OTHER EQUIP R&M16,685 15,682 15,000 15,00000 5,000LEVEL TEXTTEXT AMT02 MISC EQUIP. REPAIR WORK5,0005,000Fund 620 - Water Works OperationsCity of South BendExpenditures145 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures620-0640-604.37-02 EQUIPMENT RENTAL1,40040 1,500 1,50000 1,000LEVEL TEXTTEXT AMT02 MISC RENTALS1,0001,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES24,287 22,340 37,500 37,500 2,118 1,020 11,000620-0640-605.21-02 PRINT SHOP871466006004343600620-0640-605.21-03 C.S. OFFICE SUPPLIES666573750750280280600620-0640-605.21-04 OTHER OFFICE SUPPLIES1,184 1,106 1,675 1,720791541 1,500620-0640-605.21-05 SMALL OFFICE EQUIPMENT00 3,000 3,000 1,157 1,157 2,000620-0640-605.22-06 COMPUTER SUPPLIES1660 5,000 5,71700 5,000LEVEL TEXTTEXT AMT02 BASIC COMPUTER SUPPLIES5,0005,000620-0640-605.22-07 LANDSCAPING MATERIAL32218 1,000 1,000116116500LEVEL TEXTTEXT AMT02 MISC FLOWERS AND LAWN SUPPLIES500500620-0640-605.22-20 C.S. - MEDICAL/SAFETY2,232133 2,500 2,500717575500620-0640-605.22-21 CLEANING SUPPLIES859936 1,350 1,350246161 1,000LEVEL TEXTTEXT AMT02 CLEANING RAGS, ETC.1,0001,000620-0640-605.23-01 BUILDING MATERIALS504114 3,065 3,065510 1,000LEVEL TEXTTEXT AMT02 GENERAL MAINTENANCE SUPPLIES1,0001,000620-0640-605.23-20 SMALL TOOLS & EQUIPMENT530 14,373 15,750 16,404 7,289 6,779 15,000LEVEL TEXTTEXT AMT02 ASSORTMENT OF BASIC TOOLS15,00015,000620-0640-605.23-21 C.S. SMALL TOOLS & EQUIP699050050000250620-0640-605.23-62 MATERIALS & SUPPLIES373,709 80,337 75,000 112,294 47,752 45,321 75,000LEVEL TEXTTEXT AMTFund 620 - Water Works OperationsCity of South BendExpenditures146 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 METER SUPPLIES75,00075,000620-0640-605.24-05 OTHER OPERATING SUPPLIES3,011 2,997 3,500 3,500795660 3,500LEVEL TEXTTEXT AMT02 HARDWARE SUPPLIES, ETC.2,300BACKFLOW TEST KIT (1)1,2003,500620-0640-605.24-51 NON-CAPITAL OFFICE EQUIP. 1,194 3,69309969959950------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES384,873 104,626 113,690 153,396 60,232 56,628 106,450620-0640-605.31-06 OTHER PROFESSIONAL SVCS 124,742 48,541 151,000 211,112 22,082 11,917 76,000LEVEL TEXTTEXT AMT02 LARGE WATER METER TESTING70,000MISC LEAK CORRELATION5,000LAWN CARE SERVICE1,00076,000620-0640-605.31-35 CONTRACTUAL SERVICE-OTHER 18,381 14,090 21,100 21,850 7,887 5,830 21,100LEVEL TEXTTEXT AMT02 FIRE PROTECTION750PM HVAC6,200PEST CONTROL750OFFICE CLEANING12,400MISC SERVICES1,00021,100620-0640-605.31-37 COMPUTER RELATED SERVICES764530 10,850 10,850 2,090 1,5600620-0640-605.33-01 OUTSIDE PRINTING SERVICES67954475075000750LEVEL TEXTTEXT AMT02 BACKFLOW PROGRAM FORMS750750620-0640-605.35-01 ELECTRIC14,564 7,926 16,000 16,000 4,564 3,977 10,000LEVEL TEXTTEXT AMT02 ELECTRICITY FOR OLIVE PUMPING STATION FACILITIES10,000"ADMIN BLDG & POLE BUILDINGS"10,000620-0640-605.35-02 HEATING FUEL (GAS)6,544 5,205 9,650 9,650 5,642 5,371 6,500LEVEL TEXTTEXT AMTFund 620 - Water Works OperationsCity of South BendExpenditures147 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 NATURAL GAS HEAT FOR OLIVE PUMPING STATION6,500" ADMIN BLDG & GARAGES "6,500620-0640-605.36-01 BUILDING R&M2,707 2,9880 25,467 25,057 6,5570620-0640-605.36-08 CONSTRUCTION EQUIP REPAIR646255 2,500 2,50000 1,200LEVEL TEXTTEXT AMT02 BACKFLOW EQUIP REPAIR/RECALIBRATION1,2001,200620-0640-605.37-04 UNIFORM RENTAL10,258 9,184 11,000 11,000 5,007 4,086 11,000LEVEL TEXTTEXT AMT02 UNIFORM & MAT RENTAL - OLIVE STREET FACILITY11,00011,000620-0640-605.39-70 EDUCATION & TRAINING2,032150 4,000 4,00000 4,000LEVEL TEXTTEXT AMT02 AWWA STATE CONFERENCE125AWWA DISTRICT SPRING & FALL CONFERENCE240AWWA NATIONAL CONFERENCE750CERTIFICATION TUITION & TEXTBOOKS840CERTIFICATIONS $30/EA120MISC SEMINARS1,9254,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES181,317 89,413 226,850 313,179 72,329 39,299 130,550620-0640-606.22-01 CENTRAL SERVICE GASOLINE 76,790 62,923 105,000 105,000 35,252 30,480 75,000LEVEL TEXTTEXT AMT02 30,000 GALLONS X $2.50/GAL75,00075,000620-0640-606.23-10 REPAIR PARTS136,274 115,276 119,500 119,500 73,170 66,006 119,500LEVEL TEXTTEXT AMT02 CENTRAL SERVICES REPAIR PART COST117,500GENERAL REPAIR PARTS2,000119,500620-0640-606.23-20 SMALL TOOLS & EQUIPMENT 18,176 17,442 24,000 32,858 15,098 13,064 20,000LEVEL TEXTTEXT AMT02 ASSORTMENT OF BASIC TOOLS20,000Fund 620 - Water Works OperationsCity of South BendExpenditures148 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures20,000620-0640-606.23-30 CONCRETE & ASPHALT98,898 81,389 155,000 164,337 19,321 5,957 135,000LEVEL TEXTTEXT AMT02 CRUSHED CONCRETE & COLD PATCH MATERIAL93,000BASE ASPHALT - SUMMER ROAD REPAIR MATERIAL8,000CONCRETE - WINTER ROAD REPAIR MATERIAL34,000135,000620-0640-606.23-62 MATERIALS & SUPPLIES294,201 298,196 352,000 412,180 229,583 141,907 352,000LEVEL TEXTTEXT AMT02 FIRE HYDRANTS120,000STOP BOXES25,000WATER MAIN MATERIAL (UNANTICIPATED)50,000FITTINGS,ETC45,000TAP & VALVE MATERIAL50,0004" TWO WAY HYDRANT (6)12,000LARGE VALVES50,000352,000620-0640-606.24-05 OTHER OPERATING SUPPLIES9,002 8,025 10,225 10,225 6,975 6,632 10,225LEVEL TEXTTEXT AMT02 HARDWARE ITEMS & INDUSTRIAL GASES10,22510,225------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES633,341 583,251 765,725 844,100 379,399 264,045 711,725620-0640-606.31-37 COMPUTER RELATED SERVICES0 9,112 20,000 20,00000 1,000LEVEL TEXTTEXT AMT02 IBM MAXIMO ADDITIONAL USER LICENSES1,0001,000620-0640-606.31-51 CONTRACTUAL SERVICE-OTHER 265,291 145,335 150,000 194,775 16,212 12,039 150,000LEVEL TEXTTEXT AMT02 STREET CUT REPAIRS70,000LINE STOP SERVICES40,000INFRA-RED PATCHING30,000MISC SERVICES ( STREET BARRICADING,ETC )10,000150,000620-0640-606.36-01 BUILDING R&M8,836 7,569 45,500 48,433 14,117 10,767 8,000LEVEL TEXTTEXT AMTFund 620 - Water Works OperationsCity of South BendExpenditures149 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 MAINT SERVICE FOR ADMIN & POLE BLDG'S8,0008,000620-0640-606.36-02 OFFICE EQUIP R&M935 1,046 1,140 1,140727566 1,400LEVEL TEXTTEXT AMT02 COPIER MAINT AGREEMENT-COPIES1,4001,400620-0640-606.36-03 AUTO EQUIPMENT R&M79,275 83,956 85,000 85,000 49,664 41,570 85,000LEVEL TEXTTEXT AMT02 CENTRAL SERVICE LABOR REPAIR COST85,00085,000620-0640-606.36-08 CONSTRUCTION EQUIP REPAIR 4,174 2,060 5,500 5,50000 3,500LEVEL TEXTTEXT AMT02 LOCATING EQUIPMENT REPAIRS3,5003,500620-0640-606.36-50 STOP BOX REPAIRS53,875 75,600 75,000 75,000 33,455 25,405 75,000LEVEL TEXTTEXT AMT02 OUTSOURCED REPAIRS ON STOP BOX75,00075,000620-0640-606.36-61 WATER SYSTEM REPAIRS9,714 14,243 80,000 80,000 13,388 13,124 40,000LEVEL TEXTTEXT AMT02 VARIETY OF REPAIR WORK40,000"MISC PLUMBING SERVICES & OTHER CONTRACTED SERV'S"40,000620-0640-606.37-11 CAPITAL LEASE PRINCIPAL1,981 9,331 9,600 9,600 9,155 4,767 9,769LEVEL TEXTTEXT AMT02 2015 VEHICLE/EQUIPMENT LEASE (1.27%) #1408,7142013 COPIER LEASE #1201,0559,769620-0640-606.37-12 CAPITAL LEASE INTEREST394790550550514294369LEVEL TEXTTEXT AMT02 2015 VEHICLE/EQUIP LEASE (1.27%) #1403372013 COPIER LEASE #12032369Fund 620 - Water Works OperationsCity of South BendExpenditures150 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures620-0640-606.39-70 EDUCATION & TRAINING130125 5,000 5,0006060 5,000LEVEL TEXTTEXT AMT02 AWWA STATE CONFERENCE250AWWA NATIONAL CONFERENCE750AWWA DISTRICT SPRING & FALL CONFERENCE240CERTIFICATION TUITION & TEXTBOOKS840CERTIFICATIONS $30/EA30MISCELLANEOUS SEMINARS2,8905,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES424,605 349,167 477,290 524,998 137,292 108,593 379,038620-0640-657.21-02 PRINT SHOP908541 1,200 1,200678416 1,000620-0640-657.21-03 C.S. OFFICE SUPPLIES751541 1,300 1,30018417 1,000620-0640-657.21-04 OTHER OFFICE SUPPLIES5,472 7,043 10,000 10,443 3,296 2,989 8,000620-0640-657.21-05 SMALL OFFICE EQUIPMENT00 10,000 10,00000 7,000620-0640-657.22-06 COMPUTER SUPPLIES2,738 5,105 5,000 10,77500 7,000LEVEL TEXTTEXT AMT02 BASIC COMPUTER SUPPLIES7,0007,000620-0640-657.22-21 OTHER - MEDICAL/SAFETY470253600600321273500620-0640-657.22-22 MEDICAL/SAFETY SUPPLIES0035035000350LEVEL TEXTTEXT AMT02 MISC350350620-0640-657.23-01 BUILDING MATERIALS123050050000250LEVEL TEXTTEXT AMT02 GENERAL MAINTENANCE SUPPLIES250250620-0640-657.24-05 OTHER OPERATING SUPPLIES52642600000620-0640-657.24-51 NON-CAPITAL OFFICE EQUIP. 9,247 6,71809909909900------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES20,235 20,627 28,950 36,158 5,469 4,686 25,100620-0640-657.31-06 OTHER PROFESSIONAL SVCS250 3,436 1,500 10,920 10,920 10,920 381,500LEVEL TEXTTEXT AMT02 NOTARY FEES1,500IMPLEMENTATION SUPPORT SERVICE FOR CUSTOMER380,000SERVICE BILLING SOFTWAREFund 620 - Water Works OperationsCity of South BendExpenditures151 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures381,500620-0640-657.31-35 CONTRACTUAL SERVICE-OTHER 854,169 576,290 600,000 598,655 380,747 302,642 690,000LEVEL TEXTTEXT AMT02 OFFICE CLEANING13,800RETAIL LOCKBOX ITEM FEE(MAIL PYMT PROCESSING SERV)35,000BANK ACH FEES1,400CREDIT CARD FEES350,000PEST CONTROL SERVICE710BUILDING SECURITY ALARM2,200BUILDING HVAC MAINT1,315FIRE ALARM MONITORING/TEST & WET SPRINKLER TEST3,975ARMORED TRANSPORT6,100CUSTOMER BILL PRODUCTION/MAILING275,500690,000620-0640-657.31-37 COMPUTER RELATED SERVICES 6,500 2,750 5,800 10,270 8,270 5,5200620-0640-657.31-39 COLLECTION AGENCY FEES15,610 7,571 25,000 19,573 4,629 3,746 12,000620-0640-657.31-75 311 CALL CENTER ALLOC0 213,00700000620-0640-657.32-02 POSTAGE3,070 3,384 6,000 6,000 2,803 2,245 5,000LEVEL TEXTTEXT AMT02 VARIOUS MAILINGS5,0005,000620-0640-657.33-02 PUBLICATION LEGAL NOTICE00650000500620-0640-657.35-01 ELECTRIC3,187 4,068 3,900 3,900 1,858 1,858 4,200LEVEL TEXTTEXT AMT02 ELECTRICITY FOR CUSTOMER SERVICE FACILITY4,2004,200620-0640-657.35-02 HEATING GAS (FUEL)1,657 1,064 2,350 2,350 1,127 1,095 2,350LEVEL TEXTTEXT AMT02 NATURAL GAS HEAT FOR CUSTOMER SERV FACILITY2,3502,350620-0640-657.36-01 BUILDING R&M850 1,554 10,000 10,000323323 5,000LEVEL TEXTTEXT AMT02 CUSTOMER SERVICE BUILDING MAINT REPAIRS5,0005,000620-0640-657.36-02 OFFICE EQUIP R&M20,946727 23,350 44,615 21,715 21,578 23,350LEVEL TEXTTEXT AMTFund 620 - Water Works OperationsCity of South BendExpenditures152 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 INTERACTIVE VOICE RESPONSE (IVR SUPPORT & MAINT)22,000COPIER MAINT (COPIES)850MISC EQUIP REPAIRS50023,350620-0640-657.37-04 UNIFORM RENTAL1,815 1,874 2,550 2,550 1,104960 2,100LEVEL TEXTTEXT AMT02 MAT RENTALS FOR CUSTOMER SERVICE FACILITY2,1002,100620-0640-657.37-11 CAPITAL LEASE PRINCIPAL893943 1,000 1,000575492 1,055LEVEL TEXTTEXT AMT02 2013 WATER WORKS COLFAX COPIER #1191,0551,055620-0640-657.37-12 CAPITAL LEASE INTEREST1931429090585132LEVEL TEXTTEXT AMT02 2013 WATER WORKS COLFAX COPIER #1193232620-0640-657.39-70 EDUCATION & TRAINING859149 3,000 1,95000 3,000LEVEL TEXTTEXT AMT02 CUST SERV CONFERENCE900AWWA STATE CONFERENCE125SUNGARD MIDWEST CONFERENCE200GENERAL TRAINING SESSIONS1,7753,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES909,999 816,959 685,190 711,873 434,129 351,429 1,130,087620-0640-657.63-70 BAD DEBT EXPENSES99,903 91,102 105,000 104,950 56,785 49,480 120,000LEVEL TEXTTEXT AMT02 UNCOLLECTABLE ACCOUNTS RECEIVABLE120,000120,000620-0640-657.63-71 CASHIER OVER/SHORT13160125175044-125LEVEL TEXTTEXT AMT02 CASH SHORTAGE OR OVERAGE125125------------ ------------ ------------ ------------ ------------ ------------ ------------Fund 620 - Water Works OperationsCity of South BendExpenditures153 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures* OTHER USES99,916 91,262 105,125 105,125 56,785 49,435 120,125620-0640-658.10-01 REGULAR WAGES1,364,012 1,579,942 1,631,796 1,631,796 911,000 790,130 1,640,228LEVEL TEXTTEXT AMT02 DIRECTOR OF UTILITIES - 0.5047,754ASSISTANT DIRECTOR OF UTILITIES - 0.5042,396MAINTENANCE MANAGER - 1.0 *PENDING MAYOR APPROV65,545MANAGER OF OPERATIONS - 169,994SYSTEM SPECIALIST III - 160,493DIRECTOR OF SCADA INFORMATION SYSTEMS - 0.5038,968ASST DIR SCADA SYSTEMS- 0.50 *PENDING MAYOR APPROV33,790DIRECTOR OF UTILITY SAFETY - .5027,831CHEMIST-3X0.25= 0.7537,905CHEMIST LEAD - 0.2513,440MANAGER UTILITY PURCHASING & STOREROOM - 0.2513,265SUPERINTENDENT V - 2.0115,130UTILITIES SYSTEM SPECIALIST - 1.056,335MANAGER OF MAINTENANCE- 1.065,545FINANCIAL SPECIALIST SR- 1.055,251FINANCIAL SPECIALIST IV - 3.0144,933FINANCIAL SPECIALIST III - 1.043,628SUPERVISOR - OPERATIONS - 2.0119,990WATER QUALITY SPECIALIST - 1.058,591QUALITY ASSURANCE DISTRIBUTION TECH - 1.042,632DISTRIBUTION RECORDS DRAFTER - 1.042,251ENGINEERING AIDE IV - 1.042,251LOCATOR - 0.5021,521DIR CUSTSERV & BILL OFFICE-1.0 *PENDING MAYOR APPR71,360DIRECTOR WATER QUALITY & LABORATORY 0.5036,414MANAGER-CUSTOMER SERVICE - 1.0 *PENDING MAYOR APPR51,759ASSISTANT MANAGER - CUSTOMER SERVICE - 1.047,430MANAGER - OPERATIONS DISTRIBUTION - 1.069,870EXECUTIVE ASST & DIR SPEC PROJ - 0.2513,542DIRECTOR - PUBLIC WORKS - 0.2023,903DEPUTY DIRECTOR OF PUBLIC WORKS - 0.2019,484ASSISTANT CITY ENGINEER - 0.7562,918ENGINEER 1 - 0.053,396NON-EXEMPT OVERTIME COMPENSATION25,000SALARY ALLOWANCE44,287-1,640,228620-0640-658.10-02 HOURLY WAGES1,622,515 1,570,119 1,694,187 1,694,187 886,247 766,779 1,706,797LEVEL TEXTTEXT AMT02 CONSTRUCTION/MAINT WORK GRP:JOB LEADER - $41,995 X 4.0 FTE167,980HEAVY EQUIP OPER II - $41,350 X 1.0 FTE41,350Fund 620 - Water Works OperationsCity of South BendExpenditures154 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresMACHINIST - $40,477 X 1.0 FTE40,477HEAVY EQUIP OPER I - $39,894 X 3.0 FTE119,682OPERATOR II - $37,024 X 2.0 FTE74,048OPERATOR I - $35,755 X 1.0 FTE35,755METER WORK GROUP:JOB LEADER - $41,995 X 1.0 FTE41,995FIELD REP/INSPECTOR III - $40,976 X 1.0 FTE40,976FIELD REP/INSPECTOR II - $40,477 X 1.0 FTE40,477FIELD REP/INSPECTOR I - $39,936 X 2.0 FTE79,872GROUP LEADER - $40,352 X 1.0 FTE40,352METER SERVICEMAN IV - $37,752 X 8.0 FTE302,016WATER TREATMENT WORK GROUP:MAINTENANCE TECH II - $39,458 X 3.0 FTE118,374MAINTENANCE TECH I - $37,128 X 4.0 FTE148,512CUSTOMER SERVICE WORK GROUP:AUDITOR I - $36,608 X 2.0 FTE73,216CUSTOMER SERV & BILLING - $34,445 X 5.0 FTE172,225DATA PROCESSOR - $38,043 X 3.0 FTE114,129OTHER COMPENSATION:WT3 CERTIFICATION 4.0 FTE X $1.15 X 2080 HRS9,568BACKFLOW CERTIFICATION 4.0 FTE X $0.90 X 2080 HRS7,488DSL CERTIFICATION 10.0 FTE X $0.90 X 2080 HRS18,720CERTIFICATION OT:CONSTRUCT/MAINT EST HRS 830 HRS X $1.35 HR1,121METER SERVICE EST HRS 1145 X $1.35 HR1,546TREATMENT EST HRS 1500 X $1.73 HR2,588CERTIFICATION DOUBLETIME:CONST/MAINT EST HRS 130 X $1.80 HR234METER GRP EST HRS 30 X $1.80 HR54TREATMENT GRP EST HRS 1005 X $2.30 HR2,312CERTIFICATION STANDBY:CONST/MAINT EST HRS 800 X $0.90 HR738METER GRP EST HRS 550 X $0.90 HR495TREATMENT GRP EST 1580 HRS X $1.15 HR1,817CERTIFICATION CALL-BACK:CONST/MAINT EST 20 HRS X $1.35 HR28METER GRP EST 200 HRS X $1.35 HR270NIGHT PREMIUM:TREATMENT GRP EST 4160 HRS X $0.45 HR1,872NIGHT PREMIUM OT:TREATMENT GRP EST 550 HRS X $0.68 HR360OUT OF GRADE PAY EST 3000 HRS X $2.056,1501,706,797620-0640-658.10-03 SEASONAL & INTERNS8,162 8,726 37,000 37,000 9,452 2,830 37,000LEVEL TEXTTEXT AMT02 2 HYDRANT PAINTERS18,500Fund 620 - Water Works OperationsCity of South BendExpenditures155 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures2 YARD/LANDSCAPING WORKERS18,500SEASONAL WORKERS $11.50 HR X APPROX 800 HR EA37,000620-0640-658.10-04 EXTRA AND OVERTIME159,362 202,459 238,105 238,105 108,581 93,818 255,410LEVEL TEXTTEXT AMT02 CONST/MAINT WORK GRP: OVERTIME $31 X 2500 EST HRS77,500METER WORK GRP: OVERTIME $31 X 1370 EST HRS42,470TREATMENT WORK GRP: OVERTIME $29 X 1500 EST HRS43,500CUSTOMER SERVICE WORK GRP: OVERTIME $27 X 400 HRS10,800CONST/MAINT WORK GRP: DOUBLETIME $41 X 290 EST HRS11,890METER WORK GRP: DOUBLETIME $41 X 60 EST HRS2,460TREATMENT WORK GRP: DOUBLE TIME $38 X 1260 EST HRS47,880CONST/MAINT WORK GRP: CALL BACK $31 X 220 EST HRS6,820METER WORK GRP: CALL BACK $31 X 390 EST HRS12,090255,410620-0640-658.10-05 TEMPORARY SERVICES25,697 3,13400000620-0640-658.10-06 LONGEVITY PAY00 8,000 8,000 3,700 3,150 7,150LEVEL TEXTTEXT AMT02 TEAMSTER CONTRACT: 2017-20207,1507,150620-0640-658.10-09 PERMANENT PART-TIME32,198 29,922 48,880 48,880 15,418 13,422 49,338LEVEL TEXTTEXT AMT02 CLERICAL 2 X $11.22 X 1040 HRS23,338OFFICESECURITY2X$13,000ANNUAL26,00049,338620-0640-658.10-13 SUPPLEMENTAL PAY73,213 81,355 87,200 87,200 45,541 39,085 87,400LEVEL TEXTTEXT AMT02STAND BY PAYCONST/MAINT WORK GRP - $20 X 1550 EST HRS31,000METER WORK GRP - $20 X 1220 EST HRS24,400TREATMENT WORK GRP - $20 X 1600 EST HRS32,00087,400620-0640-658.10-14 PRODUCTIVITY BONUS6,050 17,71200000620-0640-658.11-01 FICA - REGULAR241,753 256,730 286,505 286,505 147,370 127,463 291,526LEVEL TEXTTEXT AMT02 TAXABLE EARNINGS $3,810,797 X 7.65 % TAX RATE291,526291,526Fund 620 - Water Works OperationsCity of South BendExpenditures156 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures620-0640-658.11-04 PERF - REGULAR360,680 384,555 182,761 409,840 218,983 189,627 414,062LEVEL TEXTTEXT AMT02 RETIREMENT CONTRIBUTION - 11.20%414,062SALARIES - $1,640,228TEAMSTER WAGES - $1,706,797TEAMSTER EXTRA & OVERTIME - $255,410TEAMSTER LONGEVITY - $7,150TEAMSTER SUPPLEMENTAL - $87,400414,062620-0640-658.11-05 PERF - UNION00 257,492 30,413 14,944 13,051 30,851LEVEL TEXTTEXT AMT02 CITY TEAMSTER RETIREMENTMENT CONTRIBUTION - 1.5%30,851TEAMSTER WAGES - $1,706,797TEAMSTER EXTRA & OVERTIME - $255,410TEAMSTER LONGEVITY PAY - $7,150TEAMSTER SUPPLEMENTAL - $87,40030,851620-0640-658.11-07 UNEMPLOYMENT COMP8,552 4,896 9,1280000620-0640-658.11-08 HEALTH INSURANCE740,332 937,686 1,070,168 1,070,168 564,642 484,651 1,130,995LEVEL TEXTTEXT AMT02 HEALTH INSURANCE:69.2 FTE X $16,200 YR1,121,040REBATE:2.0 FTE X $1,560 YR3,120LONG TERM DISABILITY:71.2 FTE X $96 YR6,8351,130,995620-0640-658.11-09 LIFE INSURANCE7,706 8,250 8,160 8,160 4,581 3,911 8,544LEVEL TEXTTEXT AMT02 71.2 FTE X $120 YR8,5448,544620-0640-658.11-10 CLOTHING ALLOWANCE8,452 9,1270 9,128681581 5,000LEVEL TEXTTEXT AMT02 BOOTS, TEE-SHIRTS, RAIN GEAR, HATS5,000PER TEAMSTER CONTRACT5,000620-0640-658.11-12 AUTO ALLOWANCE3,922 2,320 2,500 2,500 1,225 1,050 2,600LEVEL TEXTTEXT AMTFund 620 - Water Works OperationsCity of South BendExpenditures157 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 $216 (APPROX) X 12 MONTHS2,6002,600620-0640-658.11-22 PARKING ALLOWANCE0 11,205 12,000 12,000 10,285 7,645 15,180LEVEL TEXTTEXT AMT02 CUSTOMER SERVICE & BILLING OFFICE PERSONNEL15,18023 SPACES X $55 MONTH X 1215,180620-0640-658.11-24 CELL PHONE ALLOWANCE4,407 6,254 8,000 8,000 3,889 3,357 6,600LEVEL TEXTTEXT AMT02 $550 MONTH X 12 MONTHS6,6006,600620-0640-658.11-27 JOB READINESS ALLOWANCE00 18,275 18,275 17,000 17,000 18,275LEVEL TEXTTEXT AMT02 TEAMSTER CONTRACT: 2017-202043 POSITIONS X $425/EA18,27518,275620-0640-658.11-29 PARENTAL LEAVE000000 9,120LEVEL TEXTTEXT AMT02 TOTAL EARNINGS - $3,646,585 X 0.25%9,1209,120620-0640-658.11-99 OTHER FRINGE BENEFITS2,595 2,470 4,000 4,00000 4,000LEVEL TEXTTEXT AMT02 TEAMSTER DEFERRED COMPENSATION PROGRAM4,0004,000------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES4,669,608 5,116,862 5,604,157 5,604,157 2,963,539 2,557,551 5,720,076620-0640-658.21-02 PRINT SHOP6,7911745005001313350620-0640-658.21-03 C.S. OFFICE SUPPLIES838 1,033 1,175 1,175348236 1,175620-0640-658.21-04 OTHER OFFICE SUPPLIES1,841 1,548 5,000 5,154944944 2,000620-0640-658.21-05 SMALL OFFICE EQUIPMENT00 3,000 3,00000 2,000620-0640-658.22-06 COMPUTER SUPPLIES0050050000500LEVEL TEXTTEXT AMT02 BASIC COMPUTER SUPPLIES500500Fund 620 - Water Works OperationsCity of South BendExpenditures158 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures620-0640-658.22-21 C.S. CLEANING SUPPLIES0050500050620-0640-658.24-05 OTHER OPERATING SUPPLIES00100100180100620-0640-658.24-51 NON-CAPITAL OFFICE EQUIP. 1,839000000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES11,309 2,755 10,325 10,479 1,323 1,193 6,175620-0640-658.31-01 LEGAL SERVICES963 4,641 75,000 75,000 31,361 17,294 35,000LEVEL TEXTTEXT AMT02 LEGAL COUNSEL FOR PROPOSED RATE CASE35,00035,000620-0640-658.31-02 ENGINEERING0 7,750 95,000 95,00000 90,000LEVEL TEXTTEXT AMT02 SERVICES FOR CAPITAL PLANNING90,00090,000620-0640-658.31-04 ACCOUNTING4,000 3,250 10,000 11,00000 5,000LEVEL TEXTTEXT AMT02 GENERAL ACCOUNTING SERVICES5,0005,000620-0640-658.31-06 OTHER PROFESSIONAL SVCS 48,732 252,787 150,000 316,749 146,633 110,427 100,000LEVEL TEXTTEXT AMT02 EVALUATION STUDIES50,000POINT OF ENTRY ASSET ANALYSIS50,000100,000620-0640-658.31-35 CONTRACTUAL SERVICE-OTHER 19,483 20,939 24,350 27,220 12,366 9,264 25,150LEVEL TEXTTEXT AMT02 OUTLSIDE ANSWERING SERVICE7,150UTILITY LOCATE FEES14,000GEOLOGICAL SURVEY - DEPT OF THE INTERIOR3,000OFFICE SECURITY ALARM SERVICE-MAIN ST1,00025,150620-0640-658.31-70 ADM FEE ALLOCATION404,409 472,800 572,775 572,775 334,117 286,386 574,371LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION #1574,371574,371620-0640-658.31-71 CENTRAL STORES ALLOCATION 5,449 5,340 6,161 6,161 3,591 3,078 13,484LEVEL TEXTTEXT AMTFund 620 - Water Works OperationsCity of South BendExpenditures159 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 FIXED COST ALLOCATION #313,48413,484620-0640-658.31-72 GIS ALLOCATION21,623 22,70400000620-0640-658.31-73 PRINT SHOP ALLOCATION0 5,736 6,212 6,212 3,626 3,108 5,197LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION #45,1975,197620-0640-658.31-76 IT ALLOCATION000000 588,214LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #7588,214588,214620-0640-658.32-02 POSTAGE131318400400221113400620-0640-658.32-04 TELEPHONE24,482 23,542 12,000 12,000 5,353 4,488 9,300LEVEL TEXTTEXT AMT02 CELLULAR SERVICE9,300$775 X 12 MONTHS = $9,3009,300620-0640-658.32-21 TRAVEL - MILEAGE0734 1,500 1,500645645 1,500LEVEL TEXTTEXT AMT02 AWWA STATE CONFERENCE300MISC SEMINARS & GENERAL TRAINING200SUNGARD MIDWEST REGIONAL300SCADA CONFERENCE200MISC MILEAGE REIMB5001,500620-0640-658.32-22 TRAVEL - AIRFARE1,0930 5,500 5,50000 5,500LEVEL TEXTTEXT AMT02 AWWA NATIONAL CONFERENCE2,700CUSTOMER SERVICE CONFERENCE900SUNGARD NATIONAL900PW ADMIN ALLOC %600MISC4005,500620-0640-658.32-23 TRAVEL - HOTEL2,432 1,702 8,500 8,500 1,326 1,326 8,500LEVEL TEXTTEXT AMT02 AWWA NATIONAL CONFERENCE1,500Fund 620 - Water Works OperationsCity of South BendExpenditures160 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresCUSTOMER SERVICE CONFERENCE750SUNGARD NATIONAL1,100SUNGARD MIDWEST REGIONAL2,500MISC SEMINARS500AWWA STATE CONFERENCE1,400PW ADMIN ALLOC %100SCADA CONFERENCE6508,500620-0640-658.32-24 TRAVEL - MEALS499427 2,500 2,500384384 2,500LEVEL TEXTTEXT AMT02 AWWA STATE CONFERENCE800SUNGARD NATIONAL200SUNDARD MIDWEST REGIONAL500GENERAL TRAINING SESSIONS200AWWA NATIONAL CONFERENCE400SCADA CONFERENCE200CUSTOMER SERVICE CONFERENCE2002,500620-0640-658.32-25 TRAVEL - OTHER418168750750138138750LEVEL TEXTTEXT AMT02 AWWA STATE CONFERENCE200SUNGARD NATIONAL100AWWA NATIONAL CONFERENCE100SUNGARD MIDWEST REGIONAL150GENERAL TRAINING SESSIONS100CUSTOMER SERVICE CONFERENCE100750620-0640-658.33-02 PUBLICATION LEGAL NOTICE1,292165 1,530 1,530193193 1,530LEVEL TEXTTEXT AMT02 ADVERTISEMENT PUBLICATIONS1,5301,530620-0640-658.33-03 PROMOTIONAL0 2,500 2,500 2,50000 2,500LEVEL TEXTTEXT AMT02 MISC ITEMS (PENCILS, CUPS, ETC)2,5002,500620-0640-658.34-02 LIABILITY INSURANCE158,136 134,484 161,529 161,529 94,227 80,766 158,252LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION #5158,252Fund 620 - Water Works OperationsCity of South BendExpenditures161 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures158,252620-0640-658.36-02 OFFICE EQUIP R&M2,772 2,832 2,810 2,810 1,920 1,611 2,810LEVEL TEXTTEXT AMT02 PLOTTER MAINT $1550 & COPIER MAINT $12602,8102,810620-0640-658.36-04 COMPUTER EQUIP R&M20,827 21,660 603,848 603,848 352,247 301,9260620-0640-658.36-06 RADIO EQUIP R&M4,4310 2,50065000 4,000LEVEL TEXTTEXT AMT02 RADIO SERVICE ALIGNMENT MAINTENANCE4,0004,000620-0640-658.37-06 BUILDING RENTAL52,421 52,421 55,000 55,000 30,579 26,210 53,000LEVEL TEXTTEXT AMT02 MAIN STREET OFFICE SPACE RENTAL53,000"LEASE RENEWAL EFFECTIVE 8/1/2017"53,000620-0640-658.37-11 CAPITAL LEASE PRINCIPAL1,973 100,339 293,378 293,378 100,131 99,110 386,135LEVEL TEXTTEXT AMT02 2013 WATER WORKS MAIN STREET COPIER #1181,2582014 HP COMPUTER LEASE #1 (1.54%) #1254762014 HP COMPUTER LEASE #1 (1.55%) #1254792014 HP COMPUTER LEASE #1 (1.55%) #1254792014 HP COMPUTER LEASE #2 (83.58%) #1268332014 HP COMPUTER LEASE #7 #1293912015 HP COMPUTER LEASE #9 (9.23%) #1382,9972016 VEHICLE/EQUIP LEASE (29%) #149192,0502016 HP COMPUTER LEASE #12 (19.69%) #1508072016 HP COMPUTER LEASE #1 (8.64%) #1553,0452017 VEHICLE/EQUIP LEASE (NEW) -1ST PYMT181,0002017 HP COMPUTER LEASE (NEW)1,1202018 HP LEASE (NEW)1,200386,135620-0640-658.37-12 CAPITAL LEASE INTEREST389 8,381 23,145 23,145 7,847 7,729 35,476LEVEL TEXTTEXT AMT02 2013 WATER WORKS MAIN STREET COPIER #118382014 HP COMPUTER LEASE #1 (1.54%) #125102014 HP COMPUTER LEASE #1 (1.55%) #125102014 HP COMPUTER LEASE #1 (1.55%) #125102014 HP COMPUTER LEASE #2 (83.58%) #12619Fund 620 - Water Works OperationsCity of South BendExpenditures162 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures2014 HP COMPUTER LEASE #7 #129102015 HP COMPUTER LEASE #9 (9.23%) #1382242016 VEHICLE/EQUIP LEASE (29%) #14910,1942016 HP COMPUTER LEASE #12 (19.69%) #150762016 HP COMPUTER LEASE #1 (8.64%) #1554252017 VEHICLE/EQUIP LEASE (NEW)24,2502017 HP COMPUTER LEASE (NEW)902018 HP COMPUTER LEASE (NEW)12035,476620-0640-658.39-11 DUES & MEMBERSHIPS6,556 12,221 10,000 11,100 6,095 6,095 11,225LEVEL TEXTTEXT AMT02 AMERICAN WATER WORKS ASSOCIATION5,500NATIONAL ASSOC OF CLEAN WATER AGENCIES5,000CHAMBER OF COMMERCE72511,225620-0640-658.39-70 EDUCATION & TRAINING820 1,123 3,175 4,297 3,447 3,241 3,175LEVEL TEXTTEXT AMT02 AWWA STATE CONFERENCE250AWWA NATIONAL CONFERENCE450SUNGARD NATIONAL CONFERENCE450SUNGARD MIDWEST CONFERENCE400GENERAL TRAINING SESSIONS1,505AWWA DISTRICT SPRING & FALL CONFERENCES1203,175------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES783,331 1,158,964 2,130,063 2,301,054 1,136,447 963,533 2,122,969620-0640-658.50-01 STATE BOARD OF ACCOUNTS0 13,001 7,500 7,50000 7,500LEVEL TEXTTEXT AMT02 AUDIT FEES7,5007,500620-0640-658.50-02 INTERFUND TRANSFER2,193,528 2,273,521 2,120,891 2,120,891 1,135,272 1,135,272 2,000,217LEVEL TEXTTEXT AMT02 TRANSFER TO DEBT SERVICE FUND 625-0000-392.00-00 2,000,2172,000,217620-0640-658.60-02 STATE GROSS INCOME TAX148,875 162,650 165,000 165,000 79,500 79,500 170,000LEVEL TEXTTEXT AMT02 INCOME TAX RATE OF 1.4% ON TAXABLE SALE RECEIPTS170,000Fund 620 - Water Works OperationsCity of South BendExpenditures163 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures"UTILITY RECEIPTS TAX"170,000620-0640-658.60-03 PILOT TRANSFER OUT1,942,608 2,039,748 1,785,919 1,785,919 1,041,789 892,962 1,730,831LEVEL TEXTTEXT AMT02 PILOT CALCULATION - 3% OF NBV OF ASSETS1,730,831TRANSFER TO ACCT #101-0000-338.00-00FIXED ALLOCATION 21,730,831620-0640-658.60-09 OTHER TAXES & LICENSES5520205520620-0640-658.63-75 MISCELLANEOUS EXPENSES37,361 39,643 42,000 42,000 39,643 39,643 42,000LEVEL TEXTTEXT AMT02 IDEM - PUBLIC WATER SYSTEM FEE39,000MISC3,00042,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES4,322,377 4,528,568 4,121,330 4,121,330 2,296,209 2,147,382 3,950,568------------ ------------ ------------ ------------ ------------ ------------ ------------** WATER WORKS13,882,583 14,435,287 16,062,641 16,688,754 8,321,236 7,242,892 16,185,045Fund 620 - Water Works OperationsCity of South BendExpenditures164 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures620-0660-657.63-70 BAD DEBT EXPENSES1,174 1,374 3,500 3,500237211 3,500LEVEL TEXTTEXT AMT02 UNCOLLECTABLE ACCOUNTS RECEIVABLE3,5003,500------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES1,174 1,374 3,500 3,500237211 3,500------------ ------------ ------------ ------------ ------------ ------------ ------------** CLAY WATER1,174 1,374 3,500 3,500237211 3,500------------ ------------ ------------ ------------ ------------ ------------ ------------*** WATERWORKS GENERAL FUND14,856,079 15,457,297 17,101,141 17,727,254 8,737,876 7,556,257 17,223,545Fund 620 - Water Works OperationsCity of South BendExpenditures165 City of South Bend, Indiana 2018 Budget Fund 622 - Water 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 Charges for Services - - - - - - - - - - - Interest Earnings 17,400 25,424 15,000 10,849 25,000 25,750 26,525 27,325 28,150 10,000 67% Other Income - - - - - - - - - - - Transfers In - - - - - 3,400,000 2,750,000 2,500,000 2,500,000 - - Total Revenue 17,400 25,424 15,000 10,849 25,000 3,425,750 2,776,525 2,527,325 2,528,150 10,000 67% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - 66,070 28,427 - - - - - (66,070) -100% Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - 66,070 28,427 - - - - - (66,070) -100% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment 246,891 303,642 807,110 278,460 350,000 377,000 473,000 455,000 392,000 (457,110) -57% Machinery & Equipment 15,382 14,675 41,286 23,098 18,000 38,000 - - - (23,286) -56% Water Meters - - - - 800,000 3,050,000 2,305,000 2,075,000 2,135,000 800,000 - Infrastructure - - 500,000 8,299 - - - - - (500,000) -100% Total Capital 262,273 318,317 1,348,396 309,857 1,168,000 3,465,000 2,778,000 2,530,000 2,527,000 (180,396) -13% Total Expenditures 262,273 318,317 1,414,466 338,284 1,168,000 3,465,000 2,778,000 2,530,000 2,527,000 (246,466) -17% Net Surplus / (Deficit)(244,873) (292,893) (1,399,466) (327,435) (1,143,000) (39,250) (1,475) (2,675) 1,150 Beginning Cash Balance 3,135,399 2,876,026 2,582,972 1,188,527 45,527 6,277 4,802 2,127 Cash Reserve Cash Adjustments (14,500) (160) 5,021 - - - - - Ending Cash Balance 2,876,026 2,582,972 1,188,527 45,527 6,277 4,802 2,127 3,277 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund is used for acquiring, constructing, and improving water utility capital assets. Water utility capital assets include Wells, Reservoirs, Transmission and Distribution Mains, Water Meters, Pumping Equipment, Treatment Equipment, Transportation Equipment, and other general plant items. Pay-as-you-go financing for capital expenditures is expected to increase as a result of an Accounting Report on Rate Study. A proposed annual capital improvement amount of $4,090,722 is included in the rate case and is based on an approximate across the board rate increase of 43.0%. Approval and phase in of the additional revenues needed will have an impact on the funding availability and timing of those projects. Lease purchase of water meters will discontinue in 2018. 166 City of South Bend, Indiana2018 BudgetFund 622 - Water Works CapitalFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalLoaderCash110,000 110,000 - - - 220,000 2002 replacement - unit #555Cargo VanCash40,000 - 40,000 - - 80,000 2001 replacement - unit #556Skid LoaderCash75,000 - - - - 75,000 1993 replacement - unit #584Case LoaderCash125,000 - - - - 125,000 2009 replacement - unit #586CompressorCash18,000 18,000 - - - 36,000 2000 replacement - unit #535Truck(s), 2WD w/utility bodies & 4 x 4 w/plowCash- 82,000 - 80,000 180,000 342,000 Aging replacementsMowerCash- 10,000 - - - 10,000 2012 replacement - unit #566Track ExcavatorCash- 175,000 - - - 175,000 1998 replacement - unit #575Arrow Board(s)Cash- 20,000 - - - 20,000 1998 & 1999 replacements - unit #598 #599Mini Cargo VanCash- - 33,000 165,000 165,000 363,000 Aging replacementsVactorCash- - 400,000 - - 400,000 2013 replacement - unit #577Tractor Cash- - - 120,000 - 120,000 1993 replacement - unit #574Crane TruckCash- - - 90,000 - 90,000 1990 replacement - unit #533Car(s), Mid-SizeCash- - - - 47,000 47,000 Aging replacementsWater MetersCash800,000 800,000 800,000 800,000 800,000 4,000,000 Water Meter Replacement ProgramImprovement & Replacement Capital - To Be DeterminedCash- 2,250,000 1,505,000 1,275,000 1,335,000 6,365,000 Critical Projects identified in Rate Case CIPTotal Replacement Capital1,168,000 3,465,000 2,778,000 2,530,000 2,527,000 12,468,000 Project CapitalTotal Project Capital- - - - - - Minimum Thresholds:Total Capital1,168,000 3,465,000 2,778,000 2,530,000 2,527,000 12,468,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:167 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueWATERWORKS DEPR FUND622-0000-361.00-00 INTEREST EARNINGS17,400 25,424 15,000 15,000 13,740 10,849 25,000LEVEL TEXTTEXT AMT02 BASED ON CURRENT EARNINGS TREND25,00025,000------------ ------------ ------------ ------------ ------------ ------------ ------------*17,400 25,424 15,000 15,000 13,740 10,849 25,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATERWORKS DEPR FUND17,400 25,424 15,000 15,000 13,740 10,849 25,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** WATERWORKS DEPR FUND17,400 25,424 15,000 15,000 13,740 10,849 25,000Fund 622 - Water Works CapitalCity of South BendRevenue168 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresWATERWORKS DEPR FUND622-0640-415.43-02 MOTOR EQUIPMENT246,891 303,642 492,000 807,110 326,953 278,460 350,000LEVEL TEXTTEXT AMT02 LOADER, 2002 REPLACEMENT-UNIT 555110,000CARGO VAN, 2001 REPLACEMENT-UNIT 55640,000SKID LOADER, 1993 REPLACEMENT-UNIT 58475,000CASE LOADER, 2009 REPLACEMENT-UNIT 586125,000350,000622-0640-415.43-08 COMPUTER EQUIP. & NETWORK0 14,6750 18,188000622-0640-415.43-10 MISCELLANEOUS EQUIPMENT 15,38200 23,098 23,098 23,098 18,000LEVEL TEXTTEXT AMT02 COMPRESSOR, 2000 REPLACEMENT-UNIT 53518,00018,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL262,273 318,317 492,000 848,396 350,051 301,558 368,000622-0640-661.31-02 ENGINEERING000 66,070 38,089 28,4270------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES000 66,070 38,089 28,4270622-0640-661.46-02 WELLS000 500,000 8,299 8,2990622-0640-661.46-04 MAINS00 500,0000000622-0640-661.46-05 WATER METERS000000 800,000LEVEL TEXTTEXT AMT02 WATER METER REPLACEMENT PROGRAM800,000800,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL00 500,000 500,000 8,299 8,299 800,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATER WORKS262,273 318,317 992,000 1,414,466 396,439 338,284 1,168,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** WATERWORKS DEPR FUND262,273 318,317 992,000 1,414,466 396,439 338,284 1,168,000Fund 622 - Water Works CapitalCity of South BendExpenditures169 City of South Bend, Indiana 2018 Budget Fund 624 - Water Works Customer Deposit 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 8,595 13,911 15,000 6,867 15,000 15,500 15,950 16,425 16,915 - 0% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 8,595 13,911 15,000 6,867 15,000 15,500 15,950 16,425 16,915 - 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out 9,709 12,228 15,000 6,582 15,000 15,500 15,950 16,425 16,915 - 0% Other Services & Charges - - - - - - - - - - - Total Services & Charges 9,709 12,228 15,000 6,582 15,000 15,500 15,950 16,425 16,915 - 0% Capital - - - - - - - - - - - Total Expenditures 9,709 12,228 15,000 6,582 15,000 15,500 15,950 16,425 16,915 - 0% Net Surplus / (Deficit)(1,114) 1,683 - 285 - - - - - Beginning Cash Balance 1,478,773 1,509,816 1,541,423 1,544,420 1,544,420 1,544,420 1,544,420 1,544,420 Cash Reserve Cash Adjustments 32,157 29,924 2,997 - - - - - Ending Cash Balance 1,509,816 1,541,423 1,544,420 1,544,420 1,544,420 1,544,420 1,544,420 1,544,420 Cash Reserves Target 1,509,816 1,541,423 1,541,423 1,544,420 1,544,420 1,544,420 1,544,420 1,544,420 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves for customer deposits Security deposits are collected from utility customers and are retained in this separate fund. Upon termination of service, refunds are credit applied to the customers final bill. 170 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueWATERWORKS DEPOSIT FUND624-0000-361.00-00 INTEREST EARNINGS8,595 13,911 15,000 15,000 8,790 6,867 15,000LEVEL TEXTTEXT AMT02 BASED ON CURRENT INVESTMENT EARNINGS TREND15,00015,000------------ ------------ ------------ ------------ ------------ ------------ ------------*8,595 13,911 15,000 15,000 8,790 6,867 15,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATERWORKS DEPOSIT FUND8,595 13,911 15,000 15,000 8,790 6,867 15,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** WATERWORKS DEPOSIT FUND8,595 13,911 15,000 15,000 8,790 6,867 15,000Fund 624 - Water Works Customer DepositsCity of South BendRevenue171 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresWATERWORKS DEPOSIT FUND624-0640-658.50-02 INTERFUND TRANSFER9,709 12,228 15,000 15,000 8,505 6,582 15,000LEVEL TEXTTEXT AMT02 TRANSFER OUT INVESTMENT INTEREST EARNINGS15,000TRANSFER TO FUND ACCT #620-0000-392.00-0015,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES9,709 12,228 15,000 15,000 8,505 6,582 15,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATER WORKS9,709 12,228 15,000 15,000 8,505 6,582 15,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** WATERWORKS DEPOSIT FUND9,709 12,228 15,000 15,000 8,505 6,582 15,000Fund 624 - Water Works Customer DepositsCity of South BendExpenditures172 City of South Bend, Indiana 2018 Budget Fund 625 - Water Works 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 6,262 7,290 8,500 3,039 9,000 9,275 9,555 9,845 10,140 500 6% Other Income - - 12,751 12,750 - - - - - (12,751) -100% Transfers In 2,043,540 2,046,060 2,046,391 984,000 2,000,217 2,015,041 1,820,986 1,826,083 1,834,522 (46,174) -2% Total Revenue 2,049,802 2,053,350 2,067,642 999,789 2,009,217 2,024,316 1,830,541 1,835,928 1,844,662 (58,425) -3% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal 1,312,053 965,231 1,395,954 - 1,431,617 1,487,345 1,338,099 1,383,877 1,434,682 35,663 3% Interest & Fees 731,735 1,035,073 650,437 254,184 568,600 527,696 482,887 442,206 399,840 (81,837) -13% Transfers Out 6,265 7,294 8,500 3,030 9,000 9,275 9,555 9,845 10,140 500 6% Other Services & Charges - - - - - - - - - - - Total Services & Charges 2,050,053 2,007,598 2,054,891 257,214 2,009,217 2,024,316 1,830,541 1,835,928 1,844,662 (45,674) -2% Capital - - - - - - - - - - - Total Expenditures 2,050,053 2,007,598 2,054,891 257,214 2,009,217 2,024,316 1,830,541 1,835,928 1,844,662 (45,674) -2% Net Surplus / (Deficit)(251) 45,752 12,751 742,575 - - - - - Beginning Cash Balance 4,650 4,398 50,069 62,918 62,918 62,918 62,918 62,918 Cash Reserve Cash Adjustments (1) (81) 98 - - - - - Ending Cash Balance 4,398 50,069 62,918 62,918 62,918 62,918 62,918 62,918 Cash Reserves Target 4,398 50,069 62,918 62,918 62,918 62,918 62,918 62,918 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves per bond covenants The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. It receives transfers from the Water Works Operations Fund 620. Biannual installments are disbursed at the end of June and December. June's payment includes 50% of the annual interest and December's payment comprises the rest of the interest and all of the principal. Refunding bonds were issued in 2016 for the current refunding of the Water Works Revenue Bonds of 2000 and the Water Works Revenue Bonds of 2006. Prior issue debt service proceeds totaling $420,783 were part of the new issue acquisition price. 173 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueWATERWORKS SINKING FUND625-0000-360.00-00 MISCELLANEOUS REVENUE000 12,751 12,750 12,7500------------ ------------ ------------ ------------ ------------ ------------ ------------*000 12,751 12,750 12,7500625-0000-361.00-00 INTEREST EARNINGS6,262 7,290 8,500 8,500 4,304 3,039 9,000LEVEL TEXTTEXT AMT02 BASED ON CURRENT INVESTMENT EARNINGS TREND9,0009,000------------ ------------ ------------ ------------ ------------ ------------ ------------*6,262 7,290 8,500 8,500 4,304 3,039 9,000625-0000-392.00-00 INTERFUND OPER. TRANSFER 2,043,540 2,046,060 2,046,391 2,046,391 984,000 984,000 2,000,217LEVEL TEXTTEXT AMT02 TRANSFER IN FOR PURPOSE OF DEBT SERVICE COVERAGE 2,000,217PRINCIPAL & INTEREST $1,999,717AGENT FEES $500TRANSFER FROM FUND 620-0640-658.50-022,000,217------------ ------------ ------------ ------------ ------------ ------------ ------------*2,043,540 2,046,060 2,046,391 2,046,391 984,000 984,000 2,000,217------------ ------------ ------------ ------------ ------------ ------------ ------------** WATERWORKS SINKING FUND2,049,802 2,053,350 2,054,891 2,067,642 1,001,054 999,789 2,009,217------------ ------------ ------------ ------------ ------------ ------------ ------------*** WATERWORKS SINKING FUND2,049,802 2,053,350 2,054,891 2,067,642 1,001,054 999,789 2,009,217Fund 625 - Water Works Debt ServiceCity of South BendRevenue174 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresWATERWORKS SINKING FUND625-0640-471.38-01 PRINCIPAL1,312,053 965,231 1,392,954 1,395,95400 1,431,617LEVEL TEXTTEXT AMT02 2009 WATER BONDS, SERIES A (SRF) #6821,6172009 WATER BONDS, SERIES B #69250,0002012 WATER BONDS #99360,0002012 WATER REFUNDING BONDS "B" #25380,0002016 WATER REFUNDING BONDS #156420,0001,431,617------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES1,312,053 965,231 1,392,954 1,395,95400 1,431,617625-0640-472.38-02 INTEREST730,985 613,540 652,387 649,387 304,784 254,184 568,100LEVEL TEXTTEXT AMT02 2009 WATER BONDS, SERIES A (SRF) #6810,5032009 WATER BONDS, SERIES B #69227,9612012 WATER BONDS #99202,6862012 WATER REFUNDING BONDS "B" #2540,1002016 WATER REFUNDING BONDS #15686,850568,100625-0640-472.38-03 PAYING AGENT FEES750750 1,050 1,0502350500LEVEL TEXTTEXT AMT02 ADMINISTRATIVE FEE - 2012 WATER BONDS #99500500625-0640-472.38-05 BOND PAYOUT0 420,78300000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES731,735 1,035,073 653,437 650,437 305,019 254,184 568,600625-0640-658.50-02 INTERFUND TRANSFER6,265 7,294 8,500 8,500 4,295 3,030 9,000LEVEL TEXTTEXT AMT02 TRANSFER OUT INVESTMENT INTEREST EARNINGS9,000TRANSFER TO FUND ACCT #620-0000-392.00-009,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES6,265 7,294 8,500 8,500 4,295 3,030 9,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATER WORKS2,050,053 2,007,598 2,054,891 2,054,891 309,314 257,214 2,009,217------------ ------------ ------------ ------------ ------------ ------------ ------------*** WATERWORKS SINKING FUND2,050,053 2,007,598 2,054,891 2,054,891 309,314 257,214 2,009,217Fund 625 - Water Works Debt ServiceCity of South BendExpenditures175 City of South Bend, Indiana 2018 Budget Fund 626 - Water Works Bond 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 6,166 14,781 16,000 6,432 16,000 16,475 16,975 17,485 18,010 - 0% Other Income - 330,000 - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 6,166 344,781 16,000 6,432 16,000 16,475 16,975 17,485 18,010 - 0% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - 550,448 - - - - - - - - - Transfers Out 13,281 6,531 16,000 10,000 16,000 16,475 16,975 17,485 18,010 - 0% Other Services & Charges - - - - - - - - - - - Total Services & Charges 13,281 556,979 16,000 10,000 16,000 16,475 16,975 17,485 18,010 - 0% Capital - - - - - - - - - - - Total Expenditures 13,281 556,979 16,000 10,000 16,000 16,475 16,975 17,485 18,010 - 0% Net Surplus / (Deficit)(7,115) (212,198) - (3,568) - - - - - Beginning Cash Balance 1,644,945 1,637,116 1,424,915 1,427,622 1,427,622 1,427,622 1,427,622 1,427,622 Cash Reserve Cash Adjustments (714) (3) 2,707 - - - - - Ending Cash Balance 1,637,116 1,424,915 1,427,622 1,427,622 1,427,622 1,427,622 1,427,622 1,427,622 Cash Reserves Target 1,637,116 1,424,915 1,424,915 1,427,622 1,427,622 1,427,622 1,427,622 1,427,622 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves per bond covenants and Crowe Horwath The purpose of this fund is to ensure compliance with certain debt service bond covenants. Required balance is determined by debt service financing arrangements at the time of issuance. Refunding bonds were issued in 2016 for the current refunding of the Water Works Revenue Bonds of 2000 and the Water Works Revenue Bonds of 2006. Additional debt service reserves totaling $330,000 were part of the new issue acquisition price. The old debt service reserve amount of $550,448 was part of the bond payout. 176 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueWATER WORKS BOND RESERVE626-0000-360.95-10 BOND CLOSING REVENUE0 330,00000000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 330,00000000626-0000-361.00-00 INTEREST EARNINGS6,166 14,781 16,000 16,000 8,223 6,432 16,000LEVEL TEXTTEXT AMT02 BASED ON CURRENT EARNINGS TREND16,00016,000------------ ------------ ------------ ------------ ------------ ------------ ------------*6,166 14,781 16,000 16,000 8,223 6,432 16,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATER WORKS BOND RESERVE6,166 344,781 16,000 16,000 8,223 6,432 16,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** WATER WORKS BOND RESERVE6,166 344,781 16,000 16,000 8,223 6,432 16,000Fund 626 - Water Works Bond ReserveCity of South BendRevenue177 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresWATER WORKS BOND RESERVE626-0640-658.38-05 BOND PAYOUT0 550,44800000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 550,44800000626-0640-658.50-02 INTERFUND TRANSFER13,281 6,531 16,000 16,000 10,000 10,000 16,000LEVEL TEXTTEXT AMT02 TRANSFER OUT INVESTMENT INTEREST EARNINGS16,000TRANSFER TO FUND ACCT #620-0000-392.00-0016,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES13,281 6,531 16,000 16,000 10,000 10,000 16,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATER WORKS13,281 556,979 16,000 16,000 10,000 10,000 16,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** WATER WORKS BOND RESERVE13,281 556,979 16,000 16,000 10,000 10,000 16,000Fund 626 - Water Works Bond ReserveCity of South BendExpenditures178 City of South Bend, Indiana 2018 Budget Fund 629 - Water Works Reserve Operations & Maintenance 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 12,703 21,912 23,000 11,514 23,000 23,700 24,415 25,150 23,900 - 0% Other Income - - - - - - - - - - - Transfers In 150,228 227,461 151,500 151,272 - - - - - (151,500) -100% Total Revenue 162,931 249,373 174,500 162,786 23,000 23,700 24,415 25,150 23,900 (151,500) -87% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out 14,406 19,461 23,000 11,059 23,000 23,700 - - - - 0% Other Services & Charges - - - - - - - - - - - Total Services & Charges 14,406 19,461 23,000 11,059 23,000 23,700 - - - - 0% Capital - - - - - - - - - - - Total Expenditures 14,406 19,461 23,000 11,059 23,000 23,700 - - - - 0% Net Surplus / (Deficit)148,525 229,912 151,500 151,727 - - 24,415 25,150 23,900 Beginning Cash Balance 2,081,600 2,228,964 2,457,950 2,614,228 2,614,228 2,614,228 2,638,643 2,663,793 Cash Reserve Cash Adjustments (1,161) (926) 4,778 - - - - - Ending Cash Balance 2,228,964 2,457,950 2,614,228 2,614,228 2,614,228 2,638,643 2,663,793 2,687,693 Cash Reserves Target 2,110,847 2,197,735 2,601,581 2,537,729 2,548,270 2,587,630 2,635,049 2,660,700 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 16.67% of Annual operating expenses in Fund 620, net of transfers The purpose of this fund is to hold cash reserves to serve as fiscal protection against the risk of revenue shortfalls, emergencies, and other economic risks that may impact the Water Utility's ability to meet financial commitments. Typically, interest earnings are transferred to Fund 620 Water Works Operations & Maintenance. Starting in 2020, the transfer will be suspended in order to meet the cash reserve requirement for Fund 629. 179 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueW.W. DEBT RES OPR. & MAIN629-0000-361.00-00 INTEREST EARNINGS12,703 21,912 23,000 23,000 14,842 11,514 23,000LEVEL TEXTTEXT AMT02 BASED ON CURRENT EARNINGS TREND23,00023,000------------ ------------ ------------ ------------ ------------ ------------ ------------*12,703 21,912 23,000 23,000 14,842 11,514 23,000629-0000-392.00-00 INTERFUND OPER. TRANSFER 150,228 227,461 74,500 151,500 151,272 151,2720LEVEL TEXTTEXT AMT02 TRANSFER IN FROM FUND 620 TO COVER TWO MONTHSOF OPERATING EXPENDITURES PLUS ADDTL $$ FORANTICIPATED ROLL OVER ENCUMBRANCESTRANSFER FROM ACCT #620-0640-658.50-022018 - TO BE DETERMINED------------ ------------ ------------ ------------ ------------ ------------ ------------*150,228 227,461 74,500 151,500 151,272 151,2720------------ ------------ ------------ ------------ ------------ ------------ ------------** W.W. DEBT RES OPR. & MAIN162,931 249,373 97,500 174,500 166,114 162,786 23,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** W.W. DEBT RES OPR. & MAIN162,931 249,373 97,500 174,500 166,114 162,786 23,000Fund 629 - Water Works O&M ReserveCity of South BendRevenue180 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresW.W. DEBT RES OPR. & MAIN629-0640-658.50-02 INTERFUND TRANSFER14,406 19,461 23,000 23,000 14,387 11,059 23,000LEVEL TEXTTEXT AMT02 TRANSFER OUT INTEREST EARNINGS TO FUND 62023,000TRANSFER TO ACCT #620-0000-392.00-0023,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES14,406 19,461 23,000 23,000 14,387 11,059 23,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATER WORKS14,406 19,461 23,000 23,000 14,387 11,059 23,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** W.W. DEBT RES OPR. & MAIN14,406 19,461 23,000 23,000 14,387 11,059 23,000Fund 629 - Water Works O&M ReserveCity of South BendExpenditures181