The URL can be used to link to this page

Water Department FY 2017 Budget Presentation Copyright 2014 City of Dubuque Public Hearings # 1. ITEM TITLE: Water Department FY2017 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Water Department FY17 Recommended Budget Supporting Documentation Water Department 7- This page intentionally left blank. -8- WATER DEPARTMENT %Change FY 2014/15 FY 2015/16 FY 2015/16 FY 2016/17 from Adopted Budget Highlights Actual Adopted Amended Recomm'd FY 2015/16 Employee Expense 2,311,964 2,266,019 2,266,019 2,409,275 6.3% Supplies and Services 2,158,189 2,212,805 2,212,805 2,467,222 11.5% Machinery and Equipment 62,021 785,207 785,207 1,155,395 47.1% Total 4,532,174 5,264,031 5,264,031 6,031,892 14.6% Administrative Overhead Recharges/Finance Utility Billing/Payment in Lieu of Taxes 1,030,968 300,325 300,325 317,491 5.7% Payment to Construction Fund 595,000 24,100 24,100 1,012,000 4099.2% Debt Service 1,410,082 1,627,792 1,627,792 1,647,089 1.2% Total Requirements 7,568,224 7,216,248 7,216,248 9,008,472 24.8% Operating Revenue 7,829,512 8,642,689 8,642,689 9,009,007 4.2% Total Resources 7,829,512 8,642,689 8,642,689 9,009,007 Net Operating Surplus (Deficit) 261,288 1,426,441 1,426,441 535 (1,425,906) Personnel -Authorized FTE 26.07 25.57 25.57 25.57 *Revenues include a 3% rate increase, generating $0 for the Operating Budget and $226,821 for the Capital Budget (each 1% generates $75,607). Improvement Package Summary 1 of 2 This improvement package would provide funding for a vacuum excavator. Similar to a shop vacuum used in residential settings, the proposed vacuum excavator has up to 27 horsepower with suction power of 540 cubic feet per minute. Distribution staff would use this tool to clean out and access street valve boxes for operating water valves during water main maintenance and 'valve turning exercising' program which is a requirement of the IDNR. Use of this tool will save staff time and potential damage to public and private structures during water main break repair. Additional uses being quick valve clean out of ice during winter conditions and safely exposing other utility lines during excavation for water main maintenance. This piece of equipment would be easily transported with a flatbed or pickup truck. Related Cost: $ 22,300 Water User Fees — Non-Recurring Recommend -Yes Water User Fee Impact: +0.29% Activity: Water Administration -9- 2 of 2 This improvement package would provide study material for Iowa Department of Natural Resources certification program of recently hired new employee. IDNR has a four year program for Grade IV— Water Distribution Operator certification. Related Cost: $ 400 Water User Fees— Non-Recurring Recommend -Yes Water User Fee Impact: +0.01% Activity: Water Distribution Significant Line Items at Maintenance Level (Without Recommended Improvement Packages) Employee Expense 1. FY 2017 employee expense reflects a 2.5% wage package increase. 2. The Iowa Public Employee Retirement System (IPERS) City contribution remains at 8.93% and the employee contribution remains at 5.95% in FY 2017. 3. The City portion of health insurance expense increased from $1,040 in FY 2016 to $1,325 in FY 2017 per month per contract, resulting is an increase of$85,500 (27.40%). 4. Overtime decreased from $105,040 in FY 2016 to $90,040 in FY 2017 based on three year average. 5. Safety Equipment decreased from $13,208 in FY 2016 to $6,000 in FY 2017 based on a three year average. This line item represents hard hats, safety glasses, gloves and high visibility vests. 6. Employee Physicals increased from $872 in FY 2016 to $1,492 in FY 2017 based on FY 2015 actual of$1,511. 7. FY 2017 is the fifth year that eligible retirees with at least twenty years of continuous service in a full-time position or retired as a result of a disability and are eligible for pension payments from the pension system can receive payment of their sick leave balance with a maximum payment of one-hundred twenty sick days payable bi-weekly over a five year period. The sick leave payout included in Water's budget is $7,577 (for one employee) in FY 2017. 8. One part-time secretary position in the Water Division that was frozen in FY 2016 will be reinstated in FY 2017 at a cost of$21,628. -10- Supplies & Services 9. Postage and Shipping increased from $1,608 in FY 2016 to $2,262 in FY 2017 based on a three year average. 10. Hand Tools and Equipment increased from $3,207 in FY 2016 to $6,285 in FY 2017 based on FY 2015 actual of$6,162 plus 2%. 11. Janitorial Supplies decreased from $5,775 in FY 2016 to $4,708 in FY 2017 based on FY 2015 actual of$4,569 plus 3%. 12. Safety Related Supplies decreased from $7,661 in FY 2016 to $2,763 in FY 2017 based on FY 2015 actual $2,550 plus 8%. 13. Electrical Supplies decreased from $16,937 in FY 2016 to $13,711 in FY 2017 based on FY 2015 actual $13,198 plus 4%. 14. Lab Supplies decreased from $15,860 in FY 2016 to $13,078 in FY 2017 based on FY 2015 actual of$12,822 plus 2%. 15. Plumbing Materials decreased from $12,125 in FY 2016 to $4,408 in FY 2017 based on a three year historical average. 16. Printing and Binding increased from $352 in FY 2016 to $1,157 in FY 2017 based on a three year historical average. 17. Copying and Reproduction decreased from $2,291 in FY 2016 to $1,043 in FY 2017 based on FY 2015 actual of$1,044. 18. Boiler Insurance increased from $1,454 in FY 2016 to $6,730 in FY 2017. During an insurance review in FY 2016 it was determined that the Public Works department floodwall operations was being charged $5,091 for boiler insurance that belonged to the Water Department, FY 2017 reflects this correction. 19. Electricity Utility Expense increased from $549,045 in FY 2016 to $563,243 in FY 2017 based on FY 2015 actual 521,521 plus 5%. 20. Sales Tax expense increased from $400,000 in FY 2016 to $445,000 in FY 2017 based on an increase in water rates in FY 2016. This expense is directly offset by Sales Tax Revenue. 21. Damage Claims increased from $2,867 in FY 2016 to $0 in FY 2017 based on FY 2015 actual of$0. 22. Gas Utility Expense increased from $34,675 in FY 2016 to $38,406 in FY 2017 based on FY 2015 actual of $40,633 23. Fuel Oil Utility Expense decreased from $12,103 in FY 2016 to $5,500 in FY 2017 based on a three year historical average. This fuel is used to power the generators when needed. -11- 24. Telephone expense decreased from $14,284 in FY 2016 to $7,850 in FY 2017 based on FY 2016 actual annualized. $1,351 of this line item was moved to internet services for service to the vehicle laptops. 25. Radio fees increased from $0 in FY 2016 to $2,500 in FY 2017 due to a change in radio equipment. 26. Property Maintenance decreased from $68,137 in FY 2016 to $57,951 in FY 2017 based on a three year historical average. 27. Barricade Rental increased from $0 in FY 2016 to $3,038 in FY 2017 based on FY 2015 actual of$2,978 plus 2%. These barricades were previously a capital improvement item that was moved in the operating budget. 28. Motor Vehicle Fuel decreased from $34,814 in FY 2016 to $26,229 in FY 2017 based on FY 2015 actual of $29,144. 29. Motor vehicle maintenance increased from $19,534 in FY 2016 to $37,963 in FY 2017 based on FY 2015 actual of$36,270 plus 5%. Increased maintenance is expected as the water department fleet is aging. 30. Motor Vehicle Maintenance Outsourced increased from $3,439 in FY 2016 to $11,616 in FY 2017 based on a three year historical average. FY 2015 actual was $11,465. 31. Machinery and Equipment Maintenance increased from $77,897 in FY 2016 to $132,368 in FY 2017 based on FY 2015 actual $129,772 plus 2%. 32. Costs for Fluoride, Phosphate, Chlorine, Lime, and Polymer expense (water processing materials) are projected to increase from $386,774 in FY 2016 to $389,428 in FY 2017 based on FY 2015 actual $381,793 plus 2%. Liquid CO2 decreased from $19,278 to $18,000 based on a three year historical average. 33. Programming increased from $562 in FY 2016 to $5,117 in FY 2017 based on the new contract for System Control and Data Acquisition (SCADA) programming. The SCADA software was upgraded in FY 2015. 34. Internet Services increased from $0 in FY 2016 to $1,351 in FY 2017. This line item was moved from the Telephone expense line, as the expense is internet service for laptops in water vehicles. 35. Valve expense increased from $10,157 in FY 2016 to $66,000 in FY 2017 due to moving $32,000 of the Water Main Replacement Capital Improvement Project to this line item to reflect the yearly expense for valves. FY 2015 actual was $33,866. 36. Pipe-Special Fittings increased from $26,500 in FY 2016 to $50,000 in FY 2017 due to moving $23,500 of the Water Main Replacement Capital Improvement Project to this line item. 37. Land Fill fees decreased from $5,283 in FY 2016 to $202 in FY 2017 based on FY 2015 actual of$198 plus 2% -12- 38. Legal Services increased from $0 in FY 2016 to $60,000 in FY 2017 based on the legal expense incurred in FY 2015 of$60,944 and FY 2016 year-to-date expense of $66,791. 39. Consultant Services increase from $0 in FY 2016 to $2,000 in FY 2017 based on moving the following Capital Improvement Project to the Operating Budget: Storage Tank Inspection ($2,000). 40. Miscellaneous Services decreased from $25,000 in FY 2016 to $20,000 in FY 2017 based on a decreased need in the Fire Hydrant Painting Program. 41. Grants increased from $0 in FY 2016 to $8,500 in FY 2017 which represents the expense attributed to the Water Leak Repair Grant. 42. Environmental Testing increased from $26,803 in FY 2016 to $30,811 in FY 2017 based on FY 2015 actual $30,207 plus 2%. This line item represents the lab services provided by the environmental lab at Water and Resource Recovery Center. 43. Hauling Services increased from $126,831 in FY 2016 to $139,699 in FY 2017 based on FY 2015 actual of $133,049 plus 5%. Machinery & Equipment 44. Equipment replacement items at the maintenance level include ($338,500): Meters 2002 Dodge Pickup $ 70,000 Software $ 1,500 Large Water Meters $ 15,000 Plant Operation & Maintenance Laboratory Equipment $ 3,500 Shop Equipment $ 1,000 Pumps $ 1,000 Smart Phone (2) $ 800 Water Distribution System Hydrants $ 70,000 Shop Equipment $ 300 Barricades $ 500 Test Equipment $ 1,000 Smart Phone $ 400 2001 Freightliner Dump Truck $ 70,000 1997 Backhoe/Loader $ 95,000 Utility Trailer $ 8,000 Software $ 500 -13- In addition, maintenance related items that have historically been budgeted in the capital improvement program have been moved to the operating budget to more accurately reflect the cost of operations. These items budgeted in equipment line items are as follows ($794,595): Automatic Meter Reading System Maintenance $15,000 Filter Maintenance Program $25,000 Internal Lines Loan Program $45,000 Water Main Break Replacements $536,781 Water Meter Exchange $68,522 Water Valve Box Maintenance $15,000 Water Meter Testing $25,000 Well Maintenance Program $26,802 Generator Main Program $17,490 Pump Replacement $20,000 Debt Service 45. Debt service reflects repayment to ($1,647,089): $62,955 2008 SRF Clear Well (last year 2028) $129,882 2009 Revenue Bonds Water Projects (last year 2023) $218,168 2010 SRF Meter Change-Out (last year 2031) $396,575 2011 Revenue Bonds Water Projects (last year 2030) $207,255 2012 GO Bond Water Tower & Line on NW Arterial (last year FY 2017) $110,693 2012 GO Bond Water Projects (last year 2032) $43,386 2013 GO Bond Water Projects (last year 2033) $129,650 2013 GO Bond Water Projects (last year 2032) $295,131 2014 GO Bond Water Projects (last year 2033) $43,804 2016 GO Bond Water Projects (last year 2036) $9,590 2017 SRF Water Projects (last year 2037) 46. Payments to the Depreciation Fund are adjusted when debt service either increases or decreases in order to avoid significant fluctuations related to debt. Revenue 47. Flat Rates increased from $17,371 in FY 2016 to $23,581 in FY 2017 based on a three year average. 48. Fire Protection Rates increased from $130,500 in FY 2016 to $134,101 in FY 2017 based on a three year average. 49. Connection Charge Large Service decreased from $23,801 in FY 2016 to $17,221 in FY 2017 based on a three year average. 50. Connection Charge Front Footage decreased from $45,657 in FY 2016 to $35,570 in FY 2017 based on a three year average. FY 2015 actual was $9,385. 51. Repair of meters increased from $3,326 in FY 2016 to $10,371 in FY 2017 based on a three year average. FY 2015 actual was $11,453. -14- 52. Penalties increased from $70,683 in FY 2016 to $80,109 in FY 2017 based on a three year average. 53. Sales Tax Collected increased from $400,000 in FY 2016 to $445,000 in FY 2017 based on the rate increase for water fees. This line item off-sets the sales tax expense. 54. Water fees have been projected based on a five percent (3%) rate increase effective July 1, 2016. -15- This page intentionally left blank. -16- City of Dubuque Water Department Organizational Chart (1)Water Department Manager (1)Water Plant (1)Water Manager (0.5)Secretary Distribution Supervisor (8) Plant (1)Electrons (1)Water (1)Water Operators (1) GIS Specialist Engineering Distribution Assistant Foreman I I I I (3) Meter (1) Distribution (1)Equipment (4) Distribution Repairworker I Equipment Operator II Maintenance Operator Workers -17- This page intentionally left blank. -18- WATER DEPARTMENT The Water Department ensures our community has high quality, safe, reliable and affordable drinking water. Water Department iirI i Plant Water Administration Operations and Distribution Water Meters Maintenance SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PLANNING The Water Department is engaged in PEOPLE conscientious, strategic planning which allows for maintaining compliance with the Employees of the Water state and federal regulatory agencies in Department are provided training order to provide the highest quality, safe to ensure the maintenance of the and cost effective drinking water possible. appropriate licenses required by pp- the Iowa Department of Natural ' row � Resources. Other job-related I � _ N educational training is provided alffra ,„i, .. I to broaden employee skills and - : it increase productivity. pm I _ --a a _ 411111,3/4.. • i' -- PARTNERSHIPS The Water Department is involved in Community Activities/Partnerships/ Outreach programs such as Water Conservation Educational Program and the Smarter City Initiative. The Water Department provides tours of its Eagle Point Treatment Plant to local schools and organizations. -19- WATER DEPARTMENT Re sources and Property Tax Support 9000000 - 8000000 7000000 , ; 6000000 , , 5000000 — , , 4000000 — , , 3000000 , , 2000000 I 1000000 _ 0 Administrative Overhead Operating Revenue ■FY2015 ■FY2016 ■FY2017 The Water Department is supported by 25.57 full-time equivalent employees, which accounts for 39.9% of the department expense as seen below. Overall, the departments' expenses are expected to increase by 14.6% in FY 2017 compared to FY 2016. Expenditures by Category by Fiscal Year Payment to Construction100 10121100 Fund 5cHi ii ii i 1647089 Debt ServiceNW 16 27792 141: 82 Machinery and Equipment - - $1,155,395 $62,021 P $'E:6.2]7 $2,467,222 Supplies andServices 52,212,805 Employee pen 2158,189 $2,409,275 $0 $500,000 $2,266,019 $1,000,000 $1,500,000 $2,000,000 $2,311,964 $2,500,000 ■FY2017 ■FY2016 ■FY2015 -20- F 9 fj c �i r7�i`J t' N1 AV' `V Nw Nw 4*1 V7� Mete ed�/ater 9 v Mem Water 79.75% �►/ater[vss Lt- O t c c sIf 301 20 fr�os fr�o9 fr�10 fr�11 fr�1� fr��3 fY�14 fro A I MWIF 73 ug m U78 !llA 11 ! ml!q lllz:! fY'i2 Arc I MWIF 73 ug m U78 !llA 11 ! ml!q lllz:! fY'i2 r r� FI An lo, �� } � �ccor�- V4- Ff7 97ul el Fla FRO. rAq UP na - A rills VN97//M No LJL-j Ir <I cc 9'i FZ cc tq�CL� AA j y t do 9 a vo i lr, -Ar� 44" t f d r m YINIZOMI'MA � S'M i�/lill�i AU, W"rA-lFT.rpmw- Reconstructions/ Implip mm M TAW Reconst��ction V-10SIMMAN- v IF T-� r { ,"Ot rn WINE ;glgl j� FX20 VACUUM EXCAVATOR iTi=b 6 9 D L tank —� Y(�y —r e� grktl fi ke rRr01s` is mo ted p=_ dy eta " nl ly' bl le 45 tl�ree argle, nA ki'gth. ca Inc prat or ien eit Yer sl�of the unit tlumplrg cycle quiokeN®sy and multiple short runs per day: munil ®� n peal�ei'cl�rs mea r bent wmenrzr - ��.�e rs^- rg,�ki�r,anaeand residential debris cleanup and land exp�irrg utility lines, pcethi digging, Wxe R • y s, �I 0 0Nsl pg sucion pvxerN - cfm 115.3 m'hninl in e, - compact, extremteN tluable package; bekdriven blo'aer '- t 4 tellable zntl eary to mairAain' sx�a.�an�Fxc Pi ftt in tFe hank ofa pckup. � _ — trick, fhlbsl trailer i aspec hyd Igned y hrkch Vit h t -kar. -'• J 35 hp 1201 br imc i n K _ Wy � + ig.t erg l abren aj manlryantl �seN ��iVate�MoinRea/acements n Tank�o�t%ingP�og��m �!/oter'NlainRe%tioafor' � sonta�yse►�er :Monfio% AMF AV .toration C I ``jf` y1'`' ! �► l , 6 6 J '�r• ' � UJJCJJJJ l � i On/ineP�o_ces_-s ir,19, rd MA Rea/_acemeIts �u_dy s m $20r72889 E�23111,_9.65 �221r7,017 X226.6,019 fY14Ac a/ fY15Ac a/ Expense Expense �2409,2�75 r sy J.`VJ r, s� 51,980,912 �2334,2�28 $2158,189 fY1�lActua/ fY15Actua/ Expense Expense mm IF 51,980,912 �2334,2�28 $2158,189 fY1�lActua/ fY15Actua/ Expense Expense mm $200,000 c X62020 $62021 fY14Actua/ fY15Budget Expense $785,207 �1,200,D00 -�1,000,000 w i -l" 40iiiow U LJ LtvJ / / / / / ' U U C.1lJ / ' / ' / INS" Mzw Amow ut u I au Budget mount �25D0,000 z��u8F389 X1,263145 u 'WHIM ff SO u $1,410,082 SBudget 0 $7,274,137 $7,92-U9169-$7, $8000000 _y r $B4O00,�D00 . sti ;, $4000,000 $2000,000 $0 4 $7,218,248 $9,008,472 F WI -D Lq- WON IN 11, OR 74&dr AV SM ARF/t% AMW WATER DEPARTMENT Administration Overview The Dubuque Water Department is dedicated to producing and delivering drinking water that is in compliance with all state and federal drinking water standards. We continually strive to adopt new and better methods of delivering the best quality drinking water to the citizens of Dubuque in the most cost-effective manner. Water Department Administration is responsible for the preparation of operating and capital budgets, analysis of rate structure, interacting with the state and federal regulatory agencies, evaluation and coordination of treatment facility operations and the water distribution system functions. Water Administration Funding Summary FY 2014/15 FY 2015/16 FY 2016/17 Actual Adopted Recommended Expenditures $2,239,416 $2,267,547 $2,426,667 Resources $6,529 $0 $0 Water Administration Position Summary FY 2016/17 FTE's Water Department Manager 1.00 Secretary 0.50 GIS Specialist 1.00 Total FT Equivalent Employees 2.50 Highlights of Fiscal Year 2016 t -rte_ T`4t ` li -1� 411 ;11.V : 1 - ‘11‘1":411,. . a .1.. 1 .- ,A. . .. 1 v . Y, _. 4 $ 4 - Airport Water Main Extension - 19.981 feet (3.8 miles)of varying sizes of water main pipe including fire hydrants,valves,two pump stations and a 500,000 gallon reservoir -21- WATER DEPARTMENT Future Initiatives • Maintain appropriate staffing levels to ensure proper functioning of utility • Provide industry related training to maintain licensing and expand the skill set of Water Department employees • Utility extensions to support areas of future growth Performance Measures (Administration — Activity Statement Provides evaluation and coordination of daily operations and long term planning of the department and interacts with state and federal regulatory agencies to maintain regulatory compliance. Goal: Financially Responsible & High Performance Organization A: Outcome #1: Maintain a financially viable water utility Financial viability allows the Water Department to achieve its operating objectives and allows the department to fulfill its mission over the long term. Outcome #2: Strategic planning of Water Department activities Strategic planning enables the Water Department to focus the energy, resources, and time of everyone in the organization in the same direction to become more efficient and cost-effective Plant Operations and Maintenance Overview Plant Operations and Maintenance ensures that water used for domestic, commercial and industrial purposes is safe for drinking and is supplied at sufficient volumes to meet the needs of our community as well as provide for fire protection. Responsible for the management of equipment and chemicals used to treat and disinfect groundwater for human consumption and to maintain compliance with all Federal, State and Local water quality standards. Over two hundred tests a day are performed by water treatment plant operators. In addition to these tests, the Dubuque Water& Resource Recovery Laboratory performs over 60 bacteriological analyses of our drinking water on a monthly basis. Other compliance related testing is performed by the University of Iowa Hygienic Laboratory and Keystone Laboratories. All of these analytical measures ensure that the water reaching your home is safe to drink. -22- WATER DEPARTMENT Plant Operations and Maintenance Funding Summary FY 2014/15 FY 2015/16 FY 2016/17 Actual Adopted Recommended Expenditures $2,397,773 $2,402,006 $2,525,856 Resources $714 $400 $200 Plant Operations and Maintenance Position Summary FY 2016/17 FTE's Water Plant Manager 1.00 Electronic Technician 1.00 Equipment Mechanic 1.00 Plant Operator II 5.00 Plant Operator Ill & IV 3.00 Total FT Equivalent Employees 11.00 Highlights of the Past Year • Pump Impeller Replacements • North Softening Basin Renovation • Well #2 and #10 Maintenance • Backwash Meter Replacement • Motor Controller Replacement for Pumps #6 and #7 • Stafford Booster Station Communications Upgrade 41 , - —1.... ....411701. -== NW - s=1� .1FM1 IrA fitI ► r��l nil :l „� c ti � llc r74: + • ' T 4 iit44111114.. J Ir r I'' -23- WATER DEPARTMENT Future Initiatives • Maintain the operations and maintenance of the Eagle Point Water Plant and all associated storage, pumping and well facilities in the most environmentally conscious manner • Ensure continued compliance with all regulatory agencies Performance Measures Plant Operations and Maintenance —Activity Statement [ Protect, preserve and promote the public health and welfare of the residents of the city of Dubuque by effectively and efficiently managing, maintaining and operating the Eagle Point Water Treatment Plant. o Goal: Environmental Integrity Outcome #1: Ensure proper treatment of drinking water that meets or exceeds drinking water regulations Drinking water is one of our most vital resources and is essential to human health. The Eagle Point Water Treatment Plant delivers an average of 7 million gallons of clean water each day to our homes, schools and businesses which is then used for cooking, drinking, cleaning, bathing, watering our lawns and so forth. FINISHED WATER TAP REPORT --b 1141 r. I I1....L2.1.... .-:___ 111101.1171 mrrtrar�a 11Pw[i els I row"'axes DUEL E I.I.i. I !M _ ;6anuY15 7 0 ;a 011701 N!! NA 040O47ou ND .Elv.rn yrwii.0 ;rePa 1.414r-trrmrrrOF? I'llrh1i;a,iasipii Emmen vr.IrvY Fluoride a # Ma am asi Lo mu pa 4"."1"4"" wiz.dude 6f31m1Wa I • --_ _ - ��U.nM rmmlmllaer i1.sr.7eI[h.1ltro. -"- •Nitrate 1 IID ID SGL 0.i PS 4.4 7014 HD 1 4iL:ez I.fl.,.-N%: rasan ar�ellrH iM :1•�Foal,. 1 t:::4rt IRyVfI ice' -1 I Sodium hu Mrt Sa F4 AMa N!A EBN470ll WI I1b .e.,w�,e E .wlr Juin,Lvtm•r0 - .F Dr:..1. - DISTRIBUTION SYSTEM REPORT Pen nAw .rl . _... • RNYH! •- `- HYMN .f./a1 n rna rIR vMK IIf1,Isa IA rt .+...o. rrhuk Prr.lt -- Tatnl Chlonnn IPPTn) .0 =a ke,6 ]A DBI LIE 70}4 i.; '.'I".o�1..uwu _ Is.: -anLd mkrod.. . l -- - Imo..., In Pn.u•r*n rro 4 M a]avl Mevrlr F•"nl mlwl ?Mil[Warm➢Jlikni■ ah wulnl.y i4 .1[. 1 MI/ma 117011 aa yn.InsMlrc ..-4•1411 wain total EaloaceticAcids w a: .0 131:11 1t1322.141laza 6yvo-lvn.aldil.r. //yy ' bI myweoran Y - l `',11■1LT f II _ t(PPotalTrih>knng11/110c haw I � —y � eu n:. +aa t]:ih:_r40 mac it,. 1._ ��0'rddrr4/y tr-'- .` - Irobl waiardduwnlon �jy��fy f�j rfQ/.� y [144.',04.0 41414m, cr.wv..el.wwlldd ..// 00111nrn ND o.Cir IO D 2014 Erosan ornnlrl IPPI^� 13 L3 �awf[I.saaUllNl ha.n //_}'yJ/yf// flort Mand U.1131,1 fn, 67111 VI ��{�1� !S O MI 4i0 MD J3 SO 0 PLl Iq �� dmu.fl The 2015 Water Quality Report can be downloaded at http://cityo fdubupue.orq/DocumentCenter/View/24076 -24- WATER DEPARTMENT Outcome#2: Produce high quality water at the required pressures and volumes Maintaining the proper pressures and volumes ensures adequate fire suppression abilities and consumer demand Vater Treafd (2,6Zii CjGI!1011J� 3,000 ' 2902 2.900 2.088 2.1153 2,805 2.787 2x80 I I I 4700 I I I I I 2.638 2.882 ENS 1 1 1 1 1 2,598 I 2,539 I I I I I III 2"60 I I I 2.300 - - -FY06 FY07 FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY IS DID YOU • KNOW? 1.' ' Dubuque's drinking X { water comes from Amity r r/"rr Wclls. There are five •' shallow wells located `- ''� �r ,� + •. at the A.Y. McDonald '`r' �► _ 1 Park and four deep -- -- -��! • t wells located around 1 • •-••••v the Eagle Point Water Treatment Plant on diftt - Hawthorne Street. -25- WATER DEPARTMENT Water Distribution Overview The function of the Water Distribution Division is to safely transport potable water from the source to point of use. Distribution is also responsible for the machinery, equipment, materials and personnel required to repair main breaks; install water mains, control valves and fire hydrants and assist other sections of the Water Department. It is our goal to operate and maintain a water distribution system consistent with established procedures recognized by the American Water Works Association for efficient management practices and to meet Federal, State and local rules and regulations Water Distribution Funding Summary FY 2014/15 FY 2015/16 FY 2016/17 Actual _ Adopted Recommended_ Expenditures $2,589,969 $2,255,587 $2,586,311 Resources $7,710,953 $8,559,706 $8,914,756 Water Distribution Position Summary FY 2016/17 FTE's Equipment Operator II 2.00 Water Distribution Maintenance Worker 4.00 Water Distribution Foreman 1.00 Water Distribution Supervisor 1.00 Water Engineering Assistant 1.00 Custodian I 0.07 Total FT Equivalent Employees 9.07 Highlights of Fiscal Year 2016 • Phase 4 of the Fire Hydrant Painting Program • Street Reconstruction/Engineering Projects Future Initiatives • The Water Distribution Division is prepared to replace; as needed, the aged, existing water main, fire hydrants, control valves and lead service lines on construction projects in partnership with the Engineering and Public Works Departments. Performance Measures ti Water Distribution —Activity Statement Operate and maintain a water distribution system consistent with established procedures recognized by the American Water Works Association for efficient management practices. -26- WATER DEPARTMENT Goal: Planned and Managed Growth Outcome#1: Ensure the integrity of the distribution system piping system Maintains the safety of our drinking water through flushing, replacing aged piping, valves and fire hydrants - -sty r_:. X21- fes a• a!: B-Branch project—Rhomberg Ave., 20" & 8" water main replacement. 2,965 feet(0.56 miles)of varying sizes of water main pipe Outcome#2: Addressing customer and system issues in a timely manner Minimizes the time customers are without water bIb YOU 1 Math Srea,' KNOW? ,17 The distribution system is composed 120 of 321 miles of .— water mains ranging as II in diameter from 4' b 011r111 I up to 30", 8,017 a f'1 I I I I III I control valves; and I I I I II 2,330 fire hydrants • FM MO MA IPTIO Fell PM MB revs Fru -27- WATER DEPARTMENT Sen'ce 740f 350 301 301 288 300 270 25° 1 I 206 200 I >3 1 [ 179 150 1 1 105 I I I A 10 0 1 1 r I I I I i I so FY'06 Fr07 Fr'Os Fr09 FY 10 FY11 FY'12 FY'13 FY'14 iris Service taps are new connections to the publicwater mains Fire Hydrant Painting Project - cabling completion To date there have been 7,038 fire hydrant caps re-cabled to the 2,346 public fire hydrants from the completion of the Fire Hydrant Painting project. •11111: .11 ' 00001 . -1 i• I.k , b . i.,t; .4 - Cables secure the fire hydrant caps to fire hydrants -28- WATER DEPARTMENT Water Meters Overview The Water Meter Division provides dependable meter repair consisting of testing, dismantling, cleaning, repairing, and reassembling meters as required. The Meter Division performs installation services, addresses pressure complaints, investigates illegal use of water, installs outside registers, and performs special reading of meters upon request and performs backflow administration to comply with state and federal mandates while ensuring accurate charges to the customer. Water Meters Funding Summary FY 2014/15 FY 2015/16 FY 2016/17 Actual Adopted Recommended Expenditures $268,324 $291,108 $368,936 Resources $113,203 $82,583 $94,051 Water Meters Position Summary _ FY 2016/17 FTE's Water Meter Repair Worker I 3.00 Total Full-Time Equivalent Employee's 3.00 Future Initiatives • Continue to educate the public of the importance of adhering to all State and Federal mandates concerning Backflow Control Devices, which protect public water supplies from potential contamination • Continue to provide excellent customer service Performance Measures (Water Meters —Activity Statement Provide dependable meter repair, installation services and backflow administration to comply with state and federal mandates to ensure accurate charges to customers. C Goal: Environmental Integrity (A Outcome #'1 : Provide accurate meter readings Ensures that customers pay for the appropriate amount of water used by tracking private water service line leaks(internal and external). Repair reimbursement and service line assistance. -29- WATER DEPARTMENT Outcome #2: Backflow protection Minimizes the possibility of contamination of the distribution system by preventing back siphonage. A backflow prevention device prevents contamination of the water system from industrial and commercial water services by using equipment that stops the backward flow of water through a pipe or cross connection between potable water and contaminants. DID YOU KNOW? Since the adoption by the . 11 Dubuque aty Council of I e o .� the Backflow Prevention , Program, we have - , J r /. established over 1 ,851 .� ",i-'�� accounts having Backflow ft `� . Protection and we also igas4,,monitor over 2,624 -�; Control Devices. These accounts are a Typical Meter/Fire Sprinkler Room combination of various Industrial and Commercial facilities. Annually we receive $25.00 per device • as the administration fee. y ti,.- It is expected an additional 75 accounts will iii 1 be established before the " end of the fiscal year Meter -30- WATER DEPARTMENT Outcome #3: Responding to customer inquiries in a timely manner Maintains consumer confidence in the water utility Service Cam 1,100 - 1,005 1,000 869 768 800 773681 714 600 11111 M 420 400 111111112001 FY'06 FY'07 FY'08 FY'09 FY'10 FY'11 FY'12 FY'13 FY'14 FY'15 -31- Recommended Operating Revenue Budget - Department Total 42 -WATER Fund Account Account Title FY14 Actual FY15 Actual FY16 Adopted FY17 Recomm'd Revenue Revenue Budget Budget 640 43110 INVESTMENT EARNINGS 22,924 21,947 21,000 0 640 43232 LEASE, FINLEY HOSIPTAL 0 0 1 0 43- USE OF MONEY AND PROPERTY 22,924 21,947 21,001 0 640 51105 METER RATES 6,649,493 6,873,347 7,695,211 8,023,216 640 51106 UB REFUND CLEARING ACCT 0 (6,992) 0 0 640 51110 FLAT RATES 35,532 14,209 17,371 23,581 640 51115 FIRE PROTECTION RATES 130,444 137,758 130,500 134,101 640 51125 TAPS-3/4&1 INCH 22,052 31,536 32,546 30,344 640 51130 CONNECT CHG LARGE SERVICE 26,082 14,860 23,801 17,221 640 51135 CONNECT CHG FRONT FOOTAGE 63,015 9,385 45,657 35,570 640 51145 SALE OF METERS 21,225 28,930 18,530 18,530 640 51146 SALE OF UFR DEVICES 11,889 7,295 1,300 3,338 640 51165 MAINTENANCE CHARGES 11,416 8,196 9,575 9,732 640 51170 REPAIR OF METERS 16,415 11,453 3,326 10,371 640 51175 SHUT OFF PENALTIES 12,551 15,329 12,500 13,586 640 51176 METERTAMPERING FEE 2,719 3,222 2,500 2,684 640 51177 CALL OUT CHARGE 2,010 2,494 1,500 2,300 640 51178 CREDIT CARD FEE 2 0 0 0 640 51180 CROSS CON. CNTL ADMIN FEE 61,133 63,407 58,907 61,026 640 51215 PENALTIES 79,882 89,213 70,683 80,109 640 51310 MONTHLY RENTAL 91,636 82,184 91,636 91,621 640 51981 COPY SERVICE CHARGES 7 0 0 0 I 51- CHARGES FOR SERVICES 7,237,504 7,385,826 8,215,543 8,557,330 I 640 53201 REFUNDS 0 20 0 0 640 53610 INSURANCE CLAIMS 597 1,715 0 0 640 53615 DAMAGE CLAIMS 47,081 7,099 5,195 5,087 640 53620 REIMBURSEMENTS-GENERAL 1,583 8,593 50 690 640 53630 SALES TAX COLLECTION 397,048 405,147 400,000 445,000 I 53- MISCELLANEOUS 446,309 422,575 405,245 450,777 I 640 54106 EQUIPMENT SALES 17,500 0 0 0 640 54109 SALVAGE SALES 2,922 1,051 900 900 54-OTHER FINANCING SOURCES 20,422 1,051 900 900 42-WATER TOTAL 7,727,159 7,831,399 8,642,689 9,009,007 -32- Recommended Operating Expenditure Budget - Department Total 42 -WATER Fund Account Account Title FY14 Actual FY15 Actual FY16 Adopted FY 17 Recomm'd Expense Expense Budget Budget 640 61010 FULL-TIME EMPLOYEES 1,464,936 1,408,801 1,468,638 1,511,988 640 61020 PART-TIME EMPLOYEES 4,178 4,460 3,066 21,741 640 61050 OVERTIME PAY 100,919 71,486 105,040 90,040 640 61071 HOLIDAY PAY-OVERTIME 17,284 15,331 14,000 14,000 640 61072 TANK CLIMBING PAY 540 0 1,200 1,200 640 61091 SICK LEAVE PAYOFF 0 4,606 7,039 7,039 640 61310 IPERS 141,796 133,957 138,316 146,364 640 61320 SOCIAL SECURITY 116,434 109,966 119,031 125,923 640 61410 HEALTH INSURANCE 375,456 371,280 312,000 397,500 640 61415 WORKMENS' COMPENSATION 75,382 82,099 80,174 82,465 640 61416 LIFE INSURANCE 1,204 1,102 2,935 3,023 640 61417 UNEMPLOYMENT INSURANCE 0 6,585 0 0 640 61620 UNIFORM ALLOWANCE 0 1,737 0 0 640 61640 SAFETY EQUIPMENT 11,986 3,449 13,208 6,000 640 61650 MEAL ALLOWANCE 996 646 500 500 640 61660 EMPLOYEE PHYSICALS 854 1,511 872 1,492 61 -WAGES AND BENEFITS 2,311,964 2,217,017 2,266,019 2,409,275 640 62010 OFFICE SUPPLIES 4,610 4,412 4,703 4,464 640 62011 UNIFORM PURCHASES 13,547 13,725 13,817 14,000 640 62030 POSTAGE AND SHIPPING 1,532 5,208 1,608 2,262 640 62033 HAND TOOLS/EQUIPMENT 1,674 6,162 3,207 6,285 640 62034 REPAIR PARTS/SUPPLIES 6,714 8,050 9,669 8,210 640 62036 CONSTRUCTION SUPPLIES 786 2,985 2,802 3,467 640 62061 DP EQUIP. MAINT CONTRACTS 13,440 15,975 16,956 17,453 640 62062 JANITORIAL SUPPLIES 5,171 4,569 5,775 4,708 640 62063 SAFETY RELATED SUPPLIES 7,510 2,550 7,661 2,763 640 62064 ELECTRICAL SUPPLIES 16,115 13,198 16,937 13,711 640 62065 LAB SUPPLIES 15,549 12,822 15,860 13,078 640 62066 PLUMBING MATERIALS 11,887 3,933 12,125 4,408 640 62090 PRINTING&BINDING 345 1,640 352 1,157 640 62110 COPYING/REPRODUCTION 2,246 1,044 2,291 1,043 640 62130 LEGAL NOTICES &ADS 3,137 3,021 1,273 1,040 640 62170 SUBSCRIPTIONS-BOOKS-MAPS 722 1,020 936 1,359 640 62190 DUES &MEMBERSHIPS 3,740 4,007 5,128 4,487 640 62206 PROPERTY INSURANCE 72,003 84,149 90,041 87,871 640 62207 BOILER INSURANCE 1,400 1,400 1,454 6,730 640 62208 GENERAL LIABILITY INSURAN 22,016 21,679 22,071 21,334 640 62210 SALES TAX 392,726 408,269 400,000 445,000 640 62221 DAMAGE CLAIMS 2,811 0 2,867 0 640 62310 TRAVEL-CONFERENCES 4,383 4,110 4,575 4,196 640 62320 TRAVEL-CITY BUSINESS 0 577 200 200 640 62340 MILEAGE/LOCAL TRANSP 6,361 3,401 6,488 4,368 640 62360 EDUCATION&TRAINING 5,457 7,302 6,026 6,742 640 62411 UTILITY EXP-ELECTRICITY 549,045 521,521 549,045 563,243 -33- Recommended Operating Expenditure Budget - Department Total 42 -WATER Fund Account Account Title FY14 Actual FY15 Actual FY16 Adopted FY 17 Recomm'd Expense Expense Budget Budget 640 62412 UTILITY EXP-GAS 41,210 40,633 34,675 38,406 640 62414 UTILITY EXP-FUEL OIL 3,977 482 12,103 5,500 640 62415 UTILITY EXPENSE STORMWATR 0 45 1,400 1,400 640 62416 UTILITY EXP-WATER 0 9 0 0 640 62421 TELEPHONE 14,106 11,975 14,284 7,850 640 62423 TELECOMMUNICATION CG 8,012 7,742 8,173 7,896 640 62424 RADIO/PAGER FEE 0 0 0 2,500 640 62431 PROPERTY MAINTENANCE 42,291 31,119 68,137 57,951 640 62433 CUSTODIAL SERVICES 675 0 689 700 640 62435 ELEVATOR MAINTENANCE 1,998 0 2,038 2,200 640 62436 RENTAL OF SPACE 1,670 1,680 1,704 1,714 640 62437 BARRICADE RENTAL 0 2,978 0 3,038 640 62511 FUEL, MOTOR VEHICLE 41,446 29,144 34,814 26,229 640 62521 MOTOR VEHICLE MAINT. 26,121 36,270 19,534 37,963 640 62528 MOTOR VEH. MAINT.OUTSOUR 13,665 11,465 3,439 11,616 640 62611 MACH/EQUIP MAINTENANCE 76,370 129,772 77,897 132,368 640 62613 METER MAINTENANCE 9,331 1,601 9,517 1,600 640 62614 EQUIP MAINT CONTRACT 0 210 0 0 640 62615 MACH/EQUIP MAINT.OUTSOUR 0 1,798 0 0 640 62630 FLUORIDE 14,040 14,270 14,321 14,555 640 62631 LIME 262,037 258,686 267,278 263,859 640 62632 PHOSPHATE 66,007 63,294 67,327 64,560 640 62633 CHLORINE 30,276 37,066 30,882 37,807 640 62638 POLYMER 6,829 8,477 6,966 8,647 640 62639 LIQUID CO2/02 18,900 15,228 19,278 18,000 640 62663 SOFTWARE LICENSE EXP 0 136 15,000 16,000 640 62664 LICENSE/PERMIT FEES 6,790 6,837 6,926 7,000 640 62667 INTERNET SERVICES 0 0 0 1,351 640 62669 PROGRAMMING 551 24,344 562 5,117 640 62671 MISC. OPERATING SUPPLIES 262 0 409 0 640 62675 VALVES 9,957 33,866 10,157 66,000 640 62676 PIPE-SPECIAL FITTINGS 25,980 67,672 26,500 50,000 640 62692 LANDFILL FEES 5,179 198 5,283 202 640 62696 OUTSIDE COLLECTOR EXPENSE 5,235 7,687 6,545 404 640 62710 CONTRACTOR SERVICES 124 606 126 500 640 62713 LEGAL SERVICES 0 60,944 0 60,000 640 62716 CONSULTANT SERVICES 102,400 100,000 0 2,000 640 62721 FINANCIAL CONSULTANT 0 0 785 0 640 62726 AUDIT SERVICES 3,325 3,500 3,600 3,700 640 62731 MISCELLANEOUS SERVICES 0 0 25,000 20,000 640 62746 ONE CALL OPERATION 3,877 4,514 3,955 5,000 640 62765 GRANTS 0 0 0 8,500 640 62767 ENVIRON.TESTING/MON. 26,278 30,207 26,803 30,811 640 62780 HAULING SERVICES 124,344 133,046 126,831 139,699 -34- Recommended Operating Expenditure Budget - Department Total 42 -WATER Fund Account Account Title FY14 Actual FY15 Actual FY16 Adopted FY 17 Recomm'd Expense Expense Budget Budget 640 62811 ENG. DIVISION SERVICES 0 0 56,000 61,000 62-SUPPLIES AND SERVICES 2,158,189 2,334,228 2,212,805 2,467,222 640 71123 SOFTWARE 6,598 2,316 7,500 2,000 640 71312 VAN/PICKUP/WAG REPL 0 0 0 70,000 640 71314 TRUCK-REPLACEMENT 0 0 0 70,000 640 71315 TRUCK-ADDITIONAL 0 9 0 0 640 71318 HEAVY EQUIP-REPLACEMENT 0 0 0 95,000 640 71328 TRAILERS 0 0 0 8,000 640 71410 SHOP EQUIPMENT 4,557 224 1,000 1,300 640 71413 LABORATORY EQUIPMENT 3,323 0 3,500 3,500 640 71414 AIR HAMMER/DRILL 1,421 227 0 0 640 71419 TAPPING MACHINE 0 1,950 13,700 0 640 71510 HYDRANTS 17,050 59,206 62,441 70,000 640 71511 PUMPS 520 30 1,000 21,000 640 71516 LARGE WATER METERS 28,196 2,901 83,500 83,522 640 71550 MISCELLANEOUS EQUIPMENT 0 82 0 0 640 71619 OTHER MAINT. EQUIPMENT 0 260 0 22,300 640 72418 TELEPHONE RELATED 0 847 2,040 1,200 640 72515 TEST EQUIPMENT,OTHER 0 2,777 0 1,000 I 71- EQUIPMENT 61,666 70,831 174,681 448,822 640 72115 BARRICADES/WARN SIGNALS 355 4,840 1,000 500 I 72- EQUIPMENT 355 4,840 1,000 500 640 73211 CONST.CONTR-NOT BLDG 0 765 609,526 688,583 640 73410 EQUIP ACQUISITION 0 0 0 17,490 I 73-CIP EXPENDITURES 0 765 609,526 706,073 640 74111 PRINCIPAL PAYMENT 789,975 812,975 826,193 879,595 640 74112 INTEREST PAYMENT 473,170 597,107 801,599 767,494 74- DEBT SERVICE 1,263,145 1,410,082 1,627,792 1,647,089 640 91100 TO GENERAL 960,389 862,719 142,985 142,884 640 91250 TO ROAD USE TAX FUND 80,000 0 0 0 640 91740 TO WATER CONSTRUCTION 940,000 595,000 24,100 1,012,000 91-TRANSFER TO 1,980,389 1,457,719 167,085 1,154,884 42-WATER TOTAL 7,775,708 7,495,482 7,058,908 8,833,865 I -35- Recommended Expenditure Budget Report by Activity & Funding Sounce 42 -WATER UNDISTRIBUTED - 10640 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget SUPPLIES AND SERVICES 5,235 7,291 7,330 0 TRANSFER TO 1,980,389 1,457,719 167,085 1,154,884 UNDISTRIBUTED 1,985,624 1,465,010 174,415 1,154,884 WATER ADMINSTRATION -42100 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget DEBT SERVICE 1,263,145 1,410,082 1,627,792 1,647,089 SUPPLIES AND SERVICES 512,858 588,485 420,407 526,609 WAGES AND BENEFITS 273,067 240,850 219,348 252,969 WATER ADMINSTRATION 2,049,070 2,239,416 2,267,547 2,426,667 METERS - 42300 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget EQUIPM ENT 28,986 3,691 16,360 86,500 SUPPLIES AND SERVICES 25,998 24,787 28,217 22,293 WAGES AND BENEFITS 244,675 239,846 246,531 260,143 METERS 299,659 268,324 291,108 368,936 PLANT OPER. &MAINT - 42400 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget EQUIPMENT 9,890 2,304 11,860 6,300 SUPPLIES AND SERVICES 1,397,150 1,431,354 1,429,858 1,490,900 WAGES AND BENEFITS 941,338 964,115 960,288 1,028,656 PLANT OPER.&MAINT 2,348,377 2,397,773 2,402,006 2,525,856 WATER DISTR. SYSTEM -42700 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget CIP EXPENDITURES 0 765 0 0 EQUIPMENT 23,144 69,675 78,961 268,000 SUPPLIES AND SERVICES 216,949 282,312 205,993 295,920 WAGES AND BENEFITS 852,885 772,206 839,852 867,507 WATER DISTR.SYSTEM 1,092,978 1,124,959 1,124,806 1,431,427 STORAGE TANK INSPECT/MON - 42705 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual FY15 Actual FY16 Adopted FY17 Recomm'd Expense Expense Budget Budget SUPPLIES AND SERVICES 0 0 0 2,000 STORAGE TANK INSPECT/MON 0 0 0 2,000 AUTO MTR RD SYS MNT PROG - 42710 -36- Recommended Expenditure Budget Report by Activity & Funding Sounce 42 -WATER FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual FY15 Actual FY16 Adopted FY17 Recomm'd Expense Expense Budget Budget CIP EXPENDITURES 0 0 15,000 15,000 AUTO MTR RD SYS MNT PROG 0 0 15,000 15,000 PUMP REPLC VACUUM FILTER-42713 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual FY15 Actual FY16 Adopted FY17 Recomm'd Expense Expense Budget Budget EQUIPMENT 0 0 0 20,000 PUMP REPLC VACUUM FILTER 0 0 0 20,000 FILTER MAINT PROGRAM - 42715 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget CIP EXPENDITURES 0 0 25,000 25,000 FILTER MAINT PROGRAM 0 0 25,000 25,000 FIRE HYDRANT PAINTING - 42720 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget SUPPLIES AND SERVICES 0 0 10,000 5,000 FIRE HYDRANT PAINTING 0 0 10,000 5,000 —1M.GENERATOR MAIN PROGRAM - 42725 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual FY15 Actual FY16 Adopted FY17 Recomm'd Expense Expense Budget Budget CIP EXPENDITURES 0 0 0 17,490 GENERATOR MAIN PROGRAM 0 0 0 17,490 GIS MAINT/UPDATES - 42730 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget SUPPLIES AND SERVICES 0 0 15,000 15,000 GIS MAINT/UPDATES 0 0 15,000 15,000 SERVICE LINE ASSIST - 42735.111 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget SUPPLIES AND SERVICES 0 0 15,000 15,000 SERVICE LINE ASSIST 0 0 15,000 15,000 VALVE EXERCISE PROGRAM -4 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget SUPPLIES AND SERVICES 0 0 25,000 25,000 VALVE EXERCISE PROGRAM 0 0 25,000 25,000 -37- Recommended Expenditure Budget Report by Activity & Funding Sounce 42 -WATER INTERNAL LINES LOAN -42750 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget CIP EXPENDITURES 0 0 0 45,000 SUPPLIES AND SERVICES 0 0 0 5,000 INTERNAL LINES LOAN 0 0 0 50,000 WATER MAIN REPLACEMENTS - 42755 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual FY15 Actual FY16 Adopted FY17 Recomm'd Expense Expense Budget Budget CIP EXPENDITURES 0 0 504,000 536,781 SUPPLIES AND SERVICES 0 0 56,000 56,000 WATER MAIN REPLACEMENTS 0 0 560,000 592,781 WATER METER EXCHANGE - 42760 lir FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget EQUIPM ENT 0 0 68,500 68,522 WATER METER EXCHANGE 0 0 68,500 68,522 WATER LEAK REPAIR GRANT - 42765 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget SUPPLIES AND SERVICES 0 0 0 8,500 WATER LEAK REPAIR GRANT 0 0 0 8,500 WATER VALVE BOX MAINT - 42770 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget CIP EXPENDITURES 0 0 15,000 15,000 WATER VALVE BOX MAINT 0 0 15,000 15,000 WATER METER TESTING - 42790 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget CIP EXPENDITURES 0 0 25,000 25,000 WATER METER TESTING 0 0 25,000 25,000 WELL MAINT PROGRAM - 42795 FUNDING SOURCE: WATER UTILITY OPERATION Account FY14 Actual Expense FY15 Actual Expense FY16 Adopted Budget FY17 Recomm'd Budget CIP EXPENDITURES 0 0 25,526 26,802 WELL MAINT PROGRAM 0 0 25,526 26,802 WATER TOTAL $7,775,707.83 ` $7,495,481.63 ` $7,058,908.00 $8,833,865.00 -38- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 42 WATER DEPARTMENT FY 2015 FY 2016 FY 2017 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 103,098 1.00 103,453 1.00 106,708 640 2775 GE-37 WATER PLANT MGR. 1.00 86,155 1.00 86,436 1.00 88,299 640 3200 GE-37 WATER DISTRIBUTION SUPERVISOR 1.00 80,378 1.00 69,063 1.00 85,338 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 70,212 1.00 70,444 1.00 63,371 640 2650 GE-31 FOREMAN-WATER DISTR. 1.00 64,911 1.00 65,144 1.00 66,540 640 2610 GE-30 GIS SPECIALIST 1.00 59,163 1.00 59,339 1.00 60,630 640 0225 GE-25 SECRETARY 1.00 46,638 0.00 0 0.00 0 640 2400 OE-16 ELECTRONIC TECHNICIAN 1.00 57,869 1.00 59,412 1.00 60,669 640 2800 OE-14 EQUIPMENT MECHANIC 1.00 55,512 1.00 56,997 1.00 58,206 640 2550 OE-13 WATER PLANT OPR CERT GR III/IV 3.00 163,914 3.00 168,263 3.00 171,813 640 2475 OE-12 WATER PLANT OPERATOR CRT GR II 5.00 248,039 5.00 262,629 5.00 271,998 640 2305 OE-10 EQUIPMENT OPERATOR II 2.00 104,270 2.00 107,032 2.00 109,279 640 1775 OE-09 WATER METER REPAIRWORKER I 3.00 149,146 3.00 154,871 3.00 158,303 640 1476 OE-09 WATER DISTR MAINTENANCE WORKE 4.00 198,132 4.00 205,555 4.00 210,834 TOTAL FULL TIME EMPLOYEES 26.00 1,487,438 25.00 1,468,638 25.00 1,511,988 61020 Part-Time Employee Expense 640 0225 GE-25 SECRETARY 0.00 0 0.50 0 0.50 18,552 640 2050 OE-06 CUSTODIAN I 0.07 2,905 0.07 3,066 0.07 3,189 TOTAL PART TIME EMPLOYEES 0.07 2,905 0.57 3,066 0.57 21,741 TOTAL WATER DEPARTMENT 26.07 1,490,343 25.57 1,471,704 25.57 1,533,729 -39- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY Run Date. 01/22/16 FY 2015 FY 2016 FY 2017 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Water Administration-FT 64042100 61010 640 0225 GE-25 SECRETARY 1.00 46,638 0.00 0 64042100 61010 640 GE-30 GIS SPECIALIST 1.00 59,163 1.00 59,339 1.00 60,630 64042100 61010 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 103,098 1.00 103,453 1.00 106,708 Total 3.00 208,899 2.00 162,792 2.00 167,338 Water Administration-PT 64042100 61020 640 0225 GE-25 SECRETARY 0.00 0 0.50 0 0.50 18,552 Total 0.00 0 0.50 0 0.50 18,552 Water Meters-FT 64042300 61010 640 1775 0E-09 WATER METER REPAIRWORKER 3.00 149,146 3.00 154,871 3.00 158,303 Total 3.00 149,146 3.00 154,871 3.00 158,303 Water Plant Operation-FT 64042400 61010 640 2475 0E-12 WATER PLANT OPER.CRT GR II 5.00 248,039 5.00 262,629 5.00 271,998 64042400 61010 640 2550 0E-13 WATER PLANT OPR CERT GR III/I) 3.00 163,914 3.00 168,263 3.00 171,813 64042400 61010 640 2775 GE-37 WATER PLANT MGR. 1.00 86,155 1.00 86,436 1.00 88,299 64042400 61010 640 2800 0E-16 ELECTRONIC TECHNICIAN 1.00 57,869 1.00 59,412 1.00 60,669 64042400 61010 640 3015 0E-14 EQUIPMENT MECHANIC 1.00 55,512 1.00 56,997 1.00 58,206 Total 11.00 611,490 11.00 633,737 11.00 650,985 Water Distribution-FT 64042700 61010 640 1476 0E-09 WATER DIST MAINTENANCEWOR 4.00 198,132 4.00 205,555 4.00 210,834 64042700 61010 640 2305 0E-10 EQUIPMENT OPERATOR II 2.00 104,270 2.00 107,032 2.00 109,279 64042700 61010 640 2650 GE-31 FOREMAN-WATER DISTR. 1.00 64,911 1.00 65,144 1.00 66,540 64042700 61010 640 2950 GE-33 WATER ENGINEERING ASSISTAN. 1.00 70,212 1.00 70,444 1.00 63,371 64042700 61010 640 3200 GE-37 WATER DISTRIBUTION SUPERVIS 1.00 80,378 1.00 69,063 1.00 85,338 Total 9.00 517,903 9.00 517,238 9.00 535,362 Water Distribution-PT 64042700 61020 640 2050 GD-03 CUSTODIAN I 0.07 2,905 0.07 3,066 0.07 3,189 Total 0.07 2,905 0.07 3,066 0.07 3,189 TOTAL WATER DEPARTMENT 26.07 1,490,343 25.57 1,471,704 25.57 1,533,729 -40- Capital Improvement Projects by Department/Division WATER CIP Capital Improvement Project FY 14 Actual FY 15 Actual FY 16 Adopted FY 17 Recomm'd Number Title Expense Expense Budget Budget 3602594 SW ARTERIAL MAIN EXT 0 0 253,000 500,000 7401389 GIS MAINTENANCE/UPGRADE 10,735 2,741 0 0 7401390 SERVICE LINE ASSISTANCE 2,223 0 0 0 7401397 EP OFFICE/LAB PUMP ROOM W 6,251 0 0 0 7401398 WATER INTERNAL LINES-LOAN 0 0 0 0 7401400 WATER METER EXCHANGE 64,469 61,990 0 0 7401405 WATER MAIN REPLACEMENTS 1,968,132 585,249 442,050 489,900 7401409 FIRE HYDRANT REPLACMENTS 40,875 67,975 0 0 7401410 VALVE REPLACEMENT 51,303 13,825 0 0 7401411 MAIN EXT ANNEXATION REL. 37,810 72,805 0 0 7401412 ANNUAL TANK INSPECTION 0 0 0 0 7401415 SHALLOW WELL REHAB 50,630 0 0 0 7401422 BUNKER HILL PUMP STATION 604,385 0 0 0 7401672 ROOSEVELT RD MAIN EXT. 26,150 69,350 0 150,000 7401826 PAINT PUMP ROOM PIPES 0 0 50,000 0 7402044 GREEN ALLEY PILOT PROJECT 0 0 0 0 7402147 DRINKING WATER STUDY 106 0 0 0 7402200 WATER SVC REPAIR GRANT 10,630 7,888 0 0 7402201 FIRE HYDRANT PAINTING 96,936 74,343 0 0 7402203 WATER VALVE BOX MAINT 26,406 14,824 0 0 7402204 ASBURYTANK PAINTING 381,469 0 0 0 7402205 PUMP REPLC VACUUM FILTER 0 0 0 0 7402209 WEST 3RD RENOVATION 0 0 0 0 7402225 MOBILE GIS SYSTEM 165 0 0 0 7402261 RAMP UTILITY RELOCATION 153,509 0 0 0 7402310 WELL FIELD ELECT UPGRADES 10,353 0 0 0 7402311 FILTER MAINTENANCE PRG 707 0 0 0 7402314 AUTO MTR RD SYST MNT PRG 12,937 10,036 0 0 7402394 GENERATOR MAINT PROGRAM 16,242 0 0 0 7402395 WATER EXT-AIRPORT 153,379 305,750 0 0 7402396 NORTH SOFTENING BASIN REN 13,289 185,802 0 0 7402398 EP-TREATMENT PPR WIN RP 0 0 0 0 7402399 WTR USGE AND SYS ACCT AUD 0 0 0 0 7402400 BRK BLD- REPAIR- EPP PS 15,392 0 0 0 7402402 OFFICES/CTRL RM/LAB REMOD 860 0 0 0 7402472 WATER COMP LEAK SURVEY 0 26,050 0 0 7402473 WATER ARC FLASH ANALYSIS 21,300 0 0 0 7402504 ENGLISH MILL WATER MAIN E 110,263 61,638 0 0 7402524 ONLINE PROCESS ANALYZER 0 453 15,000 15,000 7402526 SRF GREEN ALLEY 0 0 0 0 7402527 GENERATOR 0 0 0 0 7402528 RAW H2O TRANSMISSION LINE 0 0 50,000 0 7402594 SW ARTERIAL MAIN EXT 0 0 847,388 2,942,000 -41- Capital Improvement Projects by Department/Division CIP Capital Improvement Project FY 14 Actual FY 15 Actual FY 16 Adopted FY 17 Recomm'd Number Title Expense Expense Budget Budget 7402595 CREEK CROSSING RESTORE 0 0 46,730 46,730 7402596 MAIN RELOC SEWER MANHOLE 0 0 20,000 50,000 7402633 PRIVATE WATER SYS PURCH 0 0 0 0 7402653 LIME SLAKER REPLACE STUDY 0 0 0 10,000 7402654 FIRE HYDRNT ASSMBLY SW PG 0 0 0 12,000 7402655 MAINT WTR MN-RETAIN WAL 0 0 0 20,000 7402656 WATER STORAGE TANK COATIN 0 0 0 88,500 7402657 WTR MN UPGRADES-STREET 0 0 0 20,000 7402658 WTR MN REPLACE-SWR CONS 0 0 0 240,350 WATER TOTAL 3,886,907 1,560,721 1,724,168 4,584,480 -42- City of Dubuque Recommended Capital Improvement Program Summary Fiscal Year 2017-2021 PROGRAM/DEPT PROJECT DESCRIPTION SOURCE OF FUNDS FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 TOTAL PAGE WATER DEPARTMENT Business Type Water Main Replacements-Streets State Revolving Fund $ 489,900 $ 169,050 $ 362,250 $ 230,000 $ 586,500 $ 1,837,700 113 Loan Water Storage Tank Coating State Revolving Fund $ 88,500 $ 590,000 $ 112,680 $ 751,200 $ 139,350 $ 1,681,730 115 Program Loan Water Main Relocation for Sanitary State Revolving Fund $ 50,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 130,000 116 Sewer Manhole Loan Replacement/Rehabilitation Project Creek Crossing Restoration State Revolving Fund $ 46,730 $ 46,730 $ 46,730 $ 46,730 $ 46,730 $ 233,650 117 Loan Water Main Upgrades during Street State Revolving Fund $ 20,000 $ 25,000 $ 30,000 $ 35,000 $ 40,000 $ 150,000 118 General Repairs Loan Maintenance of Public Water Mains State Revolving Fund $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 119 during Stone Retaining Wall Repair Loan Fire Hydrant Assembly State Revolving Fund $ 12,000 $ 12,000 $ 12,000 $ 20,000 $ 20,000 $ 76,000 120 Relocation/Replacement for the Loan Sidewalk Program Southwest Arterial Water Main Water Construction $ 3,442,000 $ 250,000 $ - $ 770,000 $ 3,778,750 $ 8,240,750 121 Extension Fund,DMATS Grant,Housing TIF,GO Borrowing(Water Fund) Water Main Replacements-Sewer State Revolving Fund $ 240,350 $ - $ 119,600 $ 138,000 $ - $ 497,950 123 Consent Decree Loan Roosevelt Road Main Extension State Revolving Fund $ 150,000 $ - $ - $ - $ - $ 150,000 125 Online Process Analyzer State Revolving Fund $ 15,000 $ 15,000 $ - $ - $ - $ 30,000 126 Lime Slaker Replacement Study State Revolving Fund $ 10,000 $ - $ - $ - $ - $ 10,000 127 Loan Tamarak Park Frontage Road Water Construction Fund $ - $ 546,000 $ - $ - $ - $ 546,000 128 Water Main English Ridge Water Main English Ridge TIF $ - $ 330,000 $ - $ - $ - $ 330,000 129 20"Transmission Main,12 and 8" State Revolving Fund $ - $ 150,000 $ 250,000 $ - $ - $ 400,000 130 Water Main Loan Relocation/Replacement/Extension Bulk CO2 Tank Replacement State Revolving Fund $ - $ 75,000 $ - $ - $ - $ 75,000 131 Loan Vacuum Filter Plant Process State Revolving Fund $ - $ 30,000 $ 200,000 $ - $ - $ 230,000 132 Upgrade Loan Bridge Repairs/Maintenance of the State Revolving Fund $ - $ 25,000 $ - $ - $ - $ 25,000 133 Water Main Supply Line to City Loan Island Raw Water Transmission Lines State Revolving Fund $ - $ - $ - $ 75,000 $ - $ 75,000 134 Loan Paint Pipes at Eagle Point Water State Revolving Fund $ - $ - $ - $ 75,000 $ - $ 75,000 135 Plant Loan Annexation Study and Water Construction Fund $ - $ - $ - $ - $ 200,000 $ 200,000 136 Implementation West End Annexation Phase II Water Construction Fund $ - $ - $ - $ - $ 200,250 $ 200,250 137 -43- City of Dubuque Recommended Capital Improvement Program Summary Fiscal Year 2017-2021 PROGRAM/DEPT PROJECT DESCRIPTION SOURCE OF FUNDS FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 TOTAL PAGE West End Annexation Study and Water Construction Fund $ - $ - $ - $ - $ 70,000 $ 70,000 138 Implementation Phase I Total-Water Department $ 4,584,480 $ 2,303,780 $ 1,173,260 $ 2,180,930 $ 5,121,580 $ 15,364,030 -44-