The URL can be used to link to this page

ITEM 1 Proposed 2015 Utility Fund Operating Budgets0 otS11.1= O MINNESOTA MEMORANDUM TO: Mayor and City Council FROM: Lori Johnson, City Administrator DATE: October 9, 2014 SUBJECT: Proposed 2015 Utility Fund Operating Budgets Attached are the proposed 2015 operating budgets for the Water and Wastewater funds. Please note that capital items are not included; they will be added after the Capital Improvement Plan (CIP) discussions with the Council in November. The CIP items may include equipment, vehicles, and infrastructure projects. One of the most significant projects up for discussion is the remediation of odor and future expansion of the west treatment plant. When this was discussed at last year's CIP meetings, the Council decided not to begin an engineering study of the need or cost for expansion in 2014. However, addressing odor concerns may accelerate the discussion depending upon the scope of the changes/improvements needed to abate the odors. More information on that item will be forthcoming. The revenues proposed for 2015 include the rate increases approved by the City Council on February 11, 2013. The rate increases follow the recently completed rate study. An update of the study is included with the budget material. The update is marked draft because additional research is being done on previous years' data. Finally, the Public Works Subcommittee has been discussing the inflow and infiltration that is causing high flows to the west plant following rain storms. It is believed this is coming from sump pumps that are connected to the sanitary sewer system when they should be draining outside. Additional seasonal hours have been added to the budget for that program assuming the Council will approve an ordinance revision to address the sump pump issue. Eliminating the additional flow from sump pumps will have a significant positive impact on the treatment plant in that it can delay expansion and it reduces treatment costs, albeit nominally. Staff is prepared to review the operating budgets in detail on Monday. Additional discussion about the sump ordinance and capital items will follow in November. City of Otsego Water Utility Fund for the year ending December 31, 2015 2011 REVENUES 601 37150 Water Sales 601 37155 Water Sales - Irrigation 15,313 - - Subtototal: Water Sales 601 37165 Water Tower Leases 601 36100 Special Assessments 601 37170 DNR Fees Collected 601 31900 Penalties and Interest 601 34302 Water Meters 601 36210 Interest Earned 601 34109 Other Administrative Charges 601 38990 Other Miscellaneous Revenue 2,226 3,662 TOTAL REVENUES EXPENDITURES 2012 2013 2014 2015 728,544 837,928 862,413 1,026,830 1 1,052,500 - - 139,419 - 75,000 728,544 837,928 1,001,831 1,026,830 1,127,500 - 55,168 64,050 60,000 60,000 rate Increase approved 2/11/13 55,050 79,090 72,294 - - 14,299 - 16,422 17,045 18,600 $ 6.36 X 2,924 connections 10,331 12,226 34,142 25,000 35,000 24 598 57 219 70 313 60 000 68 000 1170 x $ 400. 27,618 17,226 (8,393) - - 582 1,684 15,313 - - 7,322 6,082 2,644 - - 868,344 1,066,623 1,268,617 1,188,875 1,309,100 601 49400 101 Full -Time Employees Regular 29,619 27,826 74,726 30,049 47,720 259/. water 75% wastewater 601 49400 102 FT Overtime - - - 660 1,100 601 49400 104 Part -Time Employees - - - 180 300 601 49400 119 Payroll Allocation 24,955 24,960 3,750 - 601 49400 121 PERA 2,147 2,008 4,979 2,226 3,662 601 49400 122 FICA and Medicare 2,128 1,921 5,474 2,363 3,758 601 49400 123 Health 2,577 2,620 5,919 5,894 8,679 601 49400 130 Other Emplolyee Insurance - - - - 601 49400 140 Unemployment Compensation - - - 601 49400 150 Workers Compensation - 322 1, 347 2 142 PERSONAL SERVICES 61,426 59,335 95,170 42,719 67,361 601 49400 201 Offlce Supplies and Expenses 91 7,036 11,651 10,500 10,000 601 49400 202 Fuel 515 202 162 750 61833 811/13-8/25/14,,2873g used In vehicles, 771g generators = 3644g/year @ 3.75/g (1/2) 601 49400 206 Postage 5,345 4,595 4,720 6,000 61600 (2200 bills @ 0.49x12)/2+additional WWIF Postage items 601 49400 210 Operating Supplies 14,048 41,061 99,139 98,100 107,110 See Attachment 210 601 49400 220 Repair/Maintenance Supplies 2,412 7,850 5,152 16,000 14,820 See Attachment 220 601 49400 225 Uniform/Clothing Allowance - - 1,254 1,475 1,100 [550/yrx4srarfy2 601 49400 227 Safety Supplies - - 808 200 11000 Arc Flash suit/traffic vest/ear plugs/glasses, 1st aid Idt supplies, Insolated tools, trench box (1/2), triocd 601 49400 240 Small Tools and Equipment - - 8,064 4,000 500 Hydrant king nut stop removal/Drill 601 49400 298 Fleet Expenses - - - 9,000 21600 8 oil changes@ $40e, 4 tire rotate @ $15e, )et Vac oil $420, Crane truck cable, Air Filter, Light Battery, Brakes, wheel well paint, trany flush@$200.(1/2). Fuel moved to 402 SUPPLIES 22,411 60,744 130,950 146,025 150,563 W Y:\Budget 2015 Input\2015 Utilities\Water 2015 Initial 10/9/2014 601 49400 301 Legal Fees 601 49400 302 Engineering Feses 601 49400 303 Planning Fees 601 49400 306 Permits & Fees 601 49400 310 Miscellaneous 601 49400 315 GIS Services 601 49400 320 Telephone 601 49400 321 Mileage & Travel 601 49400 322 Utilities 601 49400 350 Print & Publishing 601 49400 355 Dues & Memberships 601 49400 360 Education/Training/Conferences 601 49400 361 LiabllitV & Property Insurance 601 49400 375 Water Test Fee 601 49400 390 Contracted Services 601 49400 402 Repairs & Maintenance Services 601 49400 410 Rentals 601 49400 420 Depreciation CONTRACTUAL SERVICES 601 49400 602 Bond Interest 601 49400 720 Operating Transfers TRANSFERS 601 49400 501 Equipment EQUIPMENT 2011 4ctual 2012 Actual 2013 Actual 2014 Budget 887 232 462 1,000 17,128 7,144 1,921 33,000 470 750 175 1,000 - 7,713 150 9,500 2014 udget Comments 500 15,000 WHP amendment 2 500 29,000 DNRAppropration 9000fl-ledl 4x175=500/MDH connectionfees (6.36 per connection@27241n 2014) estimating 2924 2015; 2 well maintenance permits 50e 10,297 - - - 2,064 190 2,501 3,000 3,000 - - 2,181 4,140 21301 2 hard lines @ 213.53/ mo =2562.36 4 cell = r(50+40(3)1x12=2040 - - 91 - 52,689 50,368 54,189 57,000 57,000 2,766 2,559 265 3,500 300 - 392 623 300 340 MRWA=$225/2 MMUA $404/2; AW WA $25 - - 650 1,700 2,859 MMUA allocation for safety training = 3718/2 250 x 4 = 1000 8,426 6,690 - 6,145 14,772 437 16,240 17,100 - zero - moved to line 306 184,372 207,144 117,551 49,200 58,600 See Attachment 390 19,065 - 4,755 - - 473,231 473,379 469,094 487,580 502,200 786,167 756,998 670,848 674,165 671,600 641,232 424,914 424,914 424,914 424,914 32,459 9,800 - 40,379 56,638 673,691 434,714 424,914 465,293 481,552 18,871 - - 22,250 subject to modification following 2015 QP discussions 18,871 - - 22,250 - TOTAL EXPENDITURES 1,562,566 1,311,791 1,321,883 1,350,452 1,371,076 NET OPERATIONS (694,222) (245,168) (53,266) (161,577) (61,976) 40 Y:\Budget 2015 Input\2015 Utilities\Water 2015 Initial 10/9/2014 2100 Operating Suppfies 2015 2016 2017 Water Chemical Budget 58,000 60,000 62,000 Chem Budget History - Based on Use 2010 35,400 Preventative Maintenance 2011 46,000 Oils / Grease / Filters / Gloves / Paint 500 500 500 2012 55,500 Ball valves/torches/zip ties/tie downs 100 100 100 2013 54,000 Laboratory - Reagents / pipet / wipes 200 200 200 Chem pump parts - diaphram/repair kit/4way valve/connector 500 500 750 Chlorine tubing 100 100 100 Chemical injection parts 200 200 200 generator wheel covers 100 Bungees 10 10 10 Salt - Snow markers - shovel 100 100 100 Hose repairs 100 100 100 C - Fold Towels / Cleaning Supplies 100 100 100 Hydrants 1 nozzle, 4 main valve rubber, seats, 4 Flange Gaskets, 1 cane 1,200 1,200 1,200 rubber seats 45e Traffic Flange Replacement 4- 225e 900 900 900 Meters for Resale 45,000 45,000 45,000 170 X $260. Total 107,110 109,010 111,260 41 220 Repaks i Maa nto Supp oes Attachment 2015 2016 2017 Distribution Repairs - valve extentions, main parts 7,000 5,000 5,000 2 Transducers - Well level monitoring - 7 year life 2,000 2,000 2,000 Lawn Maintenance -Trees/Mulch/Weed Spray 100 100 100 Community Ed - Displays Prairie Fest 500 Well House #2 Chem Room Air Exchange 3,000 Hanging Heater repair/replacement 800 1 Chem Pump - life expectancy 7 yr 800 800 800 PLC Well 1 4,000 Chlorine Regulator- life expectancy 7 yr 1,200 WH1 WH2 WH3 WH4 Hi E Dry Dehumidifier replacement 800 4 top bell water valves @ $80 each 320 320 320 Variable Frequency Drives / Soft Starters Total) 14,820 12,220 9,920 WA 390 Contracted Servkes 2015 2016 I 2017 Stericyle Communications - ans service 800 800 800 Softronics 5,000 5,000 5,000 Civic Systems 1,200 1,200 1,200 2 Well Pump Pulls 6,000 6,000 6,000 AE2SS 3 visits 1100 each 3,300 3,300 3,300 Electrician Services 2,000 2,000 2,000 Generator Service - Annual Maintenance 1,430 1,430 1,430 Public Water System Testing - LIC Labs-15x9x12 Total Coliform 1,620 1,800 1,800 (20x0.25)=5 20-5=15 Bear Alarms - alarm monitoring Well Sites 1,750 1,750 1,750 Spraying Lawn Area Well sites 200 200 200 Fire Ext Testing / Replacement 100 100 100 Meter Testing - Municipal Wells / Residents 1,000 1,000 1,000 RPZTesting -4bulk water meters 200 200 600 $50/insp;2017@150/rebuild Well 3 motor replacement & Check valve 2014 + 7yr = 2021 @$13000 Locates 25,000 25,000 25,000 Water Tower 2 & 3 inspection and cleaning 8,000 8,000 8,000 PSI control valve seat replacement 1,000 1,000 1,000 Totall 58,600 1 58,7801 59,180 43 O O � O N o(oO� O N 44 a) a O U C o c 0 0 aC N ! U @ � N O . n a o O t1 � 3 w N C a) L O W N Rd m O C N 0) a) UQ w�tn 0 N _T a) T a) m N E w ( N z M T cl O N cox N Q O .6 mo o O O m Nm m N U N C O O m N o N (D C CC N U V a) o a •- a) R N O. Z a u�m =a)a) acntn0 mh 0) v tnv<ty oO It ooho0) W C O N vrnth O 01 a OO N cc h ' • ' O M M O r h'0 O r oc0)r ' v rn 000co V_ �_ r O M O OD coO CO 0 ' O 01 (n o V 0) corn tO OD I- r0) ho vo ►� N oM m0 0)N N O'co Irvv'n h rrNU) NN (D U) ODO(vfl- tO Wm 'It M v hvh tO hM0) L U N O O N r CO ` N N (` @ m N N r N E a` zaol I=UU C E t1 3i :Eid3 N N N tti .1m, .a m N W a U) U) m 69 U) U) U) U) 6% FA 0 0 U) U) 69 U) m 69 U) U) U) U) U) 69 69 69 N Q NM M 00d•tohN (Ov N toowON 10 t0 NN a v0) O O N N' CF) 0) M Mh O0) 'O cc O) M O' o h 0O0 OOr r (0 ' 01 O r 0 0 v 0) M' (0 O M to V tO MN N h vv aih It LO h MOOor (O I.- C-4 10 v M N r=MM MO M O o to (O N N OO O N Mco r h r C4 U) N to N torn ry r Nm N hvN r N N � ))rt fA U) U) U) E9 d4 . M Hi 69 611,61119 11 611 1,17 U3 01 69 69 69 19 1% fA f9 Vd O ( fti �ft M M (0 aO (Orn 00 fD O O O r (O 0) r t0 a oln m !I't tO 0) h U) M �ijM o o� ' (O r t0 t0 O N O (O t0 ' NOrnoN v v M v O 0)NC) v U o to (O '4t $))1 -N r v N o v CoO m (O Co Co tfJ Co (O h N N OD r v N N W)(O N M O to (Orn M co 0) N 00 'C'co 0 rr cq NN to N 0) Nv O O VN O N r N v N M a 69 s9 (;; U) U) E9 U) 69 W. to U) (9 M fo U) 69 U) M 6% U) 69 U) m to fA w L; co O M O hv d' (O v 0 0 O M h co M co r m O rC) (O (o ".@ to (o ool�om ' t0 o o cov N tD a m r In ca N r c'v h to co m o r v (O t_ 0 0 0 kt r rn o h" tri <r O' N t� (o O m �r) N coO v oMNr NK! r �V t0 V' NO u)htO t0 0) V' Y�f OD d• V(OM N (O N O O N r '. c. ) + N w r N v a 1t. "}1�fi1f4 ,# E''O �) 69 (9 U) 69 69 k (» a{s $0'.(» 69 to 69 t9 U) U) (» (» (» 6% f9 Ut v (0 r m r O 0 N v M N 00 O c0 co c) OD h a MN t0 v_ to (o I�-- coh v. (O rh o_. rn u) o'N m c0 MON h N ', to o r O hN0 C o r o 0) N (D N - v co -if"m v o rn '(p N N ao N Or CL O LO 0) tO N N O O M 0) Eq r- 0)) t0 CDN co O Nv to tO N O a_ U) U) 69 69 69 69 69 (a U)' 69 U3 m f9 69tri UY I V3. U) U) U) . 69 '; 69 U) U) 69 U) 0) co 0) v h co U) v CO l'0 1 0) 0 O ', A•1n d M :':.1 fj) 0) v Sm l V' t0 (O a O N N h 0) ' co' O 0) O O M 0) OD CCLr' N .. GO. r ' M,N CO h h v h � N O OD rm+ v to v 10 OD v (o O (4 NV' .��f"..� ao I�_ v t r a) O N N Lc r r N VOD' ! (�4 �f!'jf1 rn 1q rn tff a N r _ j r 111:147 m 60 69 FA U) M, fa f9 6% U) 69 tR (a U) 69 U) U) 69 W t9 6% U) 69 M v N -. ODW E N M ov 0) co t0 0) co M y M M h 10 N (0 M �0)0)j v N Jq�j ( II'IIIII M Octv ' O t n ' m e h N ' r Cl) N' ' t 1.1RL `*' 0000 (MO W M t0 h rn CO O ti 00 tq 'It rn ch o h M ch rn jt' v V o r v h N v M N v ':.�h Oiffto Q N 69 6% 6% m f9 EA m fA U), m U) 69 (9 co U) 69 (9 ER 6% , C{t f I) U) 69 v U) hN ODM 10 co O rn o v 0)m v0 v M h rn oo 0) h O t0 `lI O l (jsl(��o `ffjl� M h v f0. fi rn v ' r (O ' N M h (O M' 0) 0) M' ' ' R Lq C I( Octr N (ON cov -n r- v 0)0M PO yr M mww It,@cov 1400 =3 CO LO t0 O rn v c0 to (O 00 h N tO Nv vM oh v v CD C m co OrtO Nv v (D Q N r r co r M 60 w U) w U> m W. 6% 6% U) 69 w U) to U) f9 U) U) U) U) U) U) w 6A 63 U3 yrf0 h rI-- my O M (o Mco hN It (0 M 1O0 ' ' m ' co N O CO 0) o v Oct N ' Otin P. M O N ' ' O ' v M co O M V0 rn CIL OMq M r to v co h N M h ct) M c0 M h O m V O No N I,. N r ") O N COh (Ov CO M y O h (0 v 0) O N 0tO0)0) O r O C O Q N N r M U3 U) U) 69 m f9 U) 69 CO. to FA 69 U) m U) m (9 () 6% U) m U), U) U) U) w vv to M Nv CO 00 MM WtO 10 v O N vim Orn NhO NM Orn v rM ' ' C` ' o (V Nt7 t0 NM ClO tO tOcc' Nr oc ' ' ' h ' O N tO U)Oo) m 0 r- co O N V MM by co to co ho0r(OM ca V O My C, htO CO NM h Mr M M y vM h v v (0 0(o t0vto NyM MtA Q N N r N 69 U) U) 64 U) U) U)03, 69 m t9 U) 69 03, w 69 U) 69 Ui U) U) (9 U) U) 69 U) 44 a) a O U C o c 0 0 aC N ! U @ � N O . n a o O t1 � 3 w N C a) L O W N Rd m O C N 0) a) UQ w�tn 0 N _T a) T a) m N E w ( N z M T cl O N cox N Q O .6 mo o O O m Nm m N U N C O O m N o N (D C CC N U V a) o a •- a) R N O. Z a u�m =a)a) acntn0 a) O d W C O IL) � O O 01 U N N c�`6 O C C C. (� L O 0 a) O p O.0 N N E c� =mc>aoz �Ir 0) N aA m .5 a) U a d U C (a a>) mQ o o N m o N ° 44 a) a O U C o c 0 0 aC N ! U @ � N O . n a o O t1 � 3 w N C a) L O W N Rd m O C N 0) a) UQ w�tn 0 N _T a) T a) m N E w ( N z M T cl O N cox N Q O .6 mo o O O m Nm m N U N C O O m N o N (D C CC N U V a) o a •- a) R N O. Z a u�m =a)a) acntn0 O d i-' •U U N w a d 0` rn N ° j Cl�o0°a mm m ►� O V U .0 L U N O , O CO ` N N (` @ m C (D N f1 U �Im �0 (1) a) E 4) �m 4)C zaol I=UU C E t1 3i :Eid3 N N N tti .1m, .a m N W a N N a) a) a) O 0 Z 0 N m 7 7 3 O Z o.aaah m L m or a mUUUw m U N Q 44 a) a O U C o c 0 0 aC N ! U @ � N O . n a o O t1 � 3 w N C a) L O W N Rd m O C N 0) a) UQ w�tn 0 N _T a) T a) m N E w ( N z M T cl O N cox N Q O .6 mo o O O m Nm m N U N C O O m N o N (D C CC N U V a) o a •- a) R N O. Z a u�m =a)a) acntn0 602 49450 101 Full -Time Employees Regular City of Otsego 22,840 72,045 170,276 602 49450 102 FT Overtime - - Sewer Utility Fund 3,740 602 49450 104 Part -Time Employees - - - r for the year ending December 31, 2015 49,507 24,960 3,750 - 602 49450 121 PERA 1,591 2011 2012 2013 2014 2015 Fund Account Description Actual Actual Actual Budget Requested Comments 5,256 33,397 602 49450 130 Other Emplolyee Insurance 136 161 662 - 602 49450 140 Unemployment Compensation REVENUES - - - 602 49450 150 Workers Compensation 602 37200 Sewer Sales 1,022,681 1,019,258 1,136,423 1,181,900 1,240,995 5% rate increase approved 2/11/13 602 34000 Charges for Service 13,200 9,553 7,873 - 7,000 septicdisposal 602 31900 Penalties and Interest 16,064 14,519 42,227 35,000 40,000 4,702 602 36210 Interest Earned 19,505 12,279 (5,049) 6,000 - 49450 220 Repair/Maintenance Supplies 602 38991 Refunds and Reimbursements 14,854 11,347 - 11,000 - 1,253 1,425 602 TOTAL REVENUES 1,086,304 1,066,956 1,181,474 1,233,900 1,287,995 602 49450 101 Full -Time Employees Regular 22,135 22,840 72,045 170,276 602 49450 102 FT Overtime - - - 3,740 602 49450 104 Part -Time Employees - - - 1,020 602 49450 119 Payroll Allocation 49,507 24,960 3,750 - 602 49450 121 PERA 1,591 1,647 4,785 12,616 602 49450 122 FICA and Medicare 1,544 1,539 5,269 13,390 602 49450 123 Health 902 1,456 5,256 33,397 602 49450 130 Other Emplolyee Insurance 136 161 662 - 602 49450 140 Unemployment Compensation - - - - 602 49450 150 Workers Compensation - - 1,264 7,632 31,289 PERSONAL SERVICES 75,815 52,603 93,031 242,071 602 49450 201 Office Supplies and Expenses 97 6,878 11,651 10,500 602 49450 202 Fuel 4,571 5,203 3,208 5,500 602 49450 206 Postage 5,345 4,595 4,702 6,000 602 49450 210 Operating Supplies 1,464 - 12,930 53,000 602 49450 220 Repair/Maintenance Supplies 24,476 29,334 26,369 66,000 602 49450 225 Uniform/Clothing Allowance - - 1,253 1,425 602 49450 227 Safety Supplies - 3,435 300 602 49450 240 Small Tools and Equipment - 7,031 1,000 602 49450 298 W/S Fleet Expenses - - - 9,000 SUPPLIES 602 49450 301 Legal Fees 602 49450 302 Engineering Fees 602 49450 303 Planning Fees 602 49450 306 Permits & Fees 602 49450 310 Miscellaneous 602 49450 315 GIS Services 602 49450 320 Telephone 602 49450 321 Mileage &Travel 602 49450 322 Utilities 602 49450 325 Garbage Service 602 49450 350 Print & Publishing 602 49450 355 Dues & Memberships 602 49450 360 Education/Training/Conferences 602 49450 361 Liability & Property Insurance 602 49450 390 Contracted Services 602 49450 402 Repairs & Maintenance Services 602 49450 410 Rentals 602 49450 419 Biosolids Removal 602 49450 420 Depreciation CONTRACTUAL SERVICES 602 49450 610 Bond Interest 602 49450 720 Operating Transfers TRANSFERS 602 49450 501 Equipment 35,953 46,010 70,579 152,725 2,182 652 - 1,000 18,745 10,405 6,849 11,000 1,020 760 225 1,000 - 4,142 4,140 7,500 8,632 - - - 7,991 190 57 4,000 - - 2,834 4,140 128,145 124,947 150,225 165,000 - - 3,478 - 2,452 2,250 116 3,500 - - 25 200 - - 1,126 1,300 20,739 17,913 4,064 20,205 395,580 482,537 258,155 101,300 31,289 - 73,488 - 61,942 2,500 32,346 35,000 826,095 826,242 846,492 843,252 1,504,812 1,472,538 1,383,620 1,198,397 1,139,971 755,400 755,400 755,400 18,000 19,600 - 45,006 1,157,971 775,000 755,400 800,406 22,107 - 320 58,7501 EQUIPMENT I 22,107 - 58,750 43 161 25% water 75% wastewater 3,300 22,350 Includes 1 seasonal for sump drainage project study 226,108 8,000 Bank charges & PSN Fees, $300Ink WWTF, hanging file folders, record boxes, pens, markers 61833 8/1/13-8/.5/14; 2873g used In vehicles, 771g generators = 3644g/year @ 3.75/9 (1/2) 6,600 (2200 bilis @ 0.49x12)/2 + additional W WTF Postaoe items 43,337 See Attachment 210 80,700 See Attachment 220 1,250 [550/yrx4stafij2+seasonal 11000 Aro Flash suit/baffic vest/ear plugs/glasses (1/2), lifejacket, Ist akl kit supplies, insolated toots, trench box 500 Impact (1/2), backpack sprayer (1/2), shovel.small air comoressor 2,600 8 oil changes@ $40e, 4 tire rotate @ $15e, ]et Vac oil $420, Crane truck cable, Air Filter, Ughk Battery, Brakes, wheel well paint' trany Flush@$200.(12) 150,820 0,000 Increase for incorporate West digester 1,000 7,700 EWWTF annual 5900 WWWTF annual 1450 SWPPP annual 400 zero 4,000 2,301 2 hard lines @ 213.53/ mo =2562.36, 4 cell = f150+40(3)7x12=2040, total 4603 (12) zero 0,000 6,851 3 yards per week [377.61+193.217x12=6851.04 200 340 MWRA225/2 AWWA25 MMUA4042 2 859 MMUA allocation for safety training = 3718/2 ' 250 x 4 = 1000 �1n See Attachment 390 60 000 1,200,000gxo.05/gal 860,117 2% growth in asset 1,200,082 812,038 =subject to modification foiowing 2015 CIP discussions TOTAL EXPENDITURES I 2,796,658 2,346,151 2,302,950 2,452,349 2,389,048 NET OPERATIONS 45 Y:\Budget 2015 Input\2015 Utilities\Sewer 2015 Initial 10/9/2014 220 Repairs and Maintenance West WWTF 2015 2016 2017 Pretreatment Building sampler replacement- Influent 5,000 sigma SD 900 refrigerated sampler RAS pump 6,000 Hi E Dry 5,000 Piping options 1,500 Control Building Generator PLC 4,000 ASCO Transfer Control Center Display Blower Building Blower rehab GBT Building Heater replacement Ferric room 500 Ferric Pump 400 400 UV Building UV-fans/ac/compressor/bulbs/cards/psi gauge 700 East= 48 bulbs 24 cards West40 bulbs 20 cards Digester/Storage/Aeration/Other Storage nozzle repair 4,000 Concrete Repairs/Sealing Sealed 2014 5 tree/w tub replacement N fence line 2,000 Splitter box bar rack 300 Control Panel PLC/UPS/Program Card 2,000 Vfd life expectancy 12years heat tape clarifiers EWWTF 200 3 Mechanical Air Units, Fine Screen, Gravity Belt, 2 Positive Displacement Pumps, 4 Blowers Pretreatment Building Inf channel concrete repair 3,000 MAU #1 motor replacement 400 Odor Control Activated Carbon Replacement 1,500 Entrance Door - Pretreatment 800 Grit Cyclone Pipe reduction 100 Water line repair 100 Control Building RAS meter replacement 5,000 Chemical Building Heater replacement Ferric room 500 GBT Building EWWTF GBT Floor 2,000 Blower Building UV Building UV fans/ac/compressor/bulbs/cards 3,300 East = 48 bulbs 24 cards West 40 bulbs 20 cards control valve100 /bulbs 150e /card 650 /fan 339 Digester/Storage/Aeration/Other Storm water Pollution Prevention Items 2,000 Mixer repair 5,000 Vfd life expectancy 12years 3 Mechanical Air Units, Fine Screen, Gravity Belt, 2 Positive Displacement Pumps, 4 Blowers Control Panel PLC/UPS/Program Card Collection System 21000 Lift Stations Grinders Otsego Preserve 400 GMH isolation valve repair 1,000 LS#3 Chord and rail repair 1,000 Soft Starts (2) 4,000 Collection System Chimney Seals - CIP 15,000 15,000 15,000 $350 each Chimney replacements - CIP 12,000 12,000 12,000 30/ring, 300/skirt & ext, 350 casting &cover,30 adhesive, 30 fasteners = $740 each 1 air relief valve 1,000 1,000 1 1,000 Total 80,7001 33,000 1 34,400 46 21®Operating Sup Hes Attachment 2015 2016 1 2017 Chemical Related Ferric History Ferric Consumption 5g/day West 2009 E 6900 W 11500 =18400 Ferric Consumption 2g/day East 2010 E 8600 W 7900 =16500 Total 6g/day x $2.7/g = $6000 Ferric 6,899.00 7,100.00 7,300.00 2011 E 4600 W 8200 =12800 Contingency high phosp (660g or 2 totes) = 1,782.00 1,782.00 1,782.00 2012 E 25 W 5900 = 5925 Polymer 6 barrels EW WTF $919 per 5,514.00 5,514.00 5,514.00 2013 E 400 W 4500 = 4900 Polymer 6 barrels WWWTF $919 per 5,514.00 5,514.00 5,514.00 Preventative Maintenance Lubricants - oil / grease / oil analysis 3,000.00 3,000.00 3,000.00 Belts - Blowers / Transfer pumps / Exhaust systems 600.00 600.00 600.00 Air Filters - blowers / compressors / furnace / dehumidifiers 300.00 300.00 300.00 OilFilters-Aerators 300.00 300.00 300.00 Seal kits / gaskets / shim kits / mechanical seal 1,000.00 1,000.00 1,000.00 fuses/relays/starters/alternators/phase monitor 4,000.00 4,000.00 4,000.00 UV bulbs + disposal; $180/bulbEWWTF 48 total WWWTF 32 total 8,640.00 5,760.00 Batteries-UPS/Equipment/Sensors/Flashlights/Gas Detector/Timers 300.00 300.00 300.00 Sampler Tubing East & West Influent/Effluent 100.00 100.00 100.00 Shop towels/glue/tape/screws bolts nuts/helicoil 150.00 150.00 150.00 West Auger liners 490.00 490.00 490.00 $17.50 each x 24+35 x 2 Delivery Disposable Gloves/Winter Gloves/Rubber Gloves/Leather Gloves 650.00 650.00 650.00 60x10 = 600+ other gloves Ferric Pump tubing -1&2 size - supply/distribution replacement 150.00 150.00 150.00 $75/5pk#1, $75/5pk#2 Process sensors - DO / pH - Probe life expect 2year 1,000.00 1,000.00 1,000.00 portable DO probe $345(2014/2017) Salt Bridges /Solution - Inf/Eff pH Meters EWWTF 500.00 500.00 500.00 Cable ties / fittings / torches / propane / plumbing supplies 100.00 100.00 100.00 shear pins / 1445 repairs / blades/auger/blower 200.00 200.00 200.00 Bulb replacement: Driveway lights/Building Exterior/Interior/WT/LED status lights 200.00 200.00 200.00 4' lights $2.50/Ballast 50+ Outlet/motor rewind/ext chord 400.00 200.00 400.00 Bea rings/Desica nt/Fi ne Screen Blades 700.00 700.00 700.00 Gravity Belt Thickener Blade -Plows -filter belt 1,000.00 - 1,000.00 EW WTF GBT Belt -908.60 P#063952 Janitorial C Fold Towels/Soap/Go10/Hand Sanitizer/Glass & Surface Cleaner 500.00 500.00 500.00 600 Garbage bags / mop / 4'-8' brushes / Bleach / Floor Cleaner 350.00 350.00 350.00 Pesticides / Herbicides / Sprayers - 8 Wasp Spray 5e / 4 Round up 80e 400.00 400.00 400.00 Paint & Paint Supplies / Floor Treatment 1,000.00 Pretreatment Building U/L/Main Restroom Items - urinal cakes, 40 Toilet paper, hand soap 100.00 100.00 100.00 Sidewalk/Driveway Salt; $20/5g 200.00 200.00 200.00 Snow Markers; 20/yr @ $3 each 60.00 60.00 60.00 Plates/forks/spoons/W microwave 70.00 30.00 30.00 Granite Chips Driveway 600.00 - 600.00 Site Application Markers 10/year Beach 80.00 80.00 80.00 Air Cans / Lock De icer / Ice Scrapers 25.00 25.00 25.00 Double Jacket Hydrant hose Q/C 50; 50'@ 200each/garden hose 400.00 200.00 200.00 Oil Dry/algae brushes - 3/entry rugs/ 100.00 - - Collection System Lift Station Ultrasonic/Pressure Transmitter (1) life expectence 7year 820.00 820.00 820.00 Lift Station Cleaning 1,600.00 1,600.00 1,600.00 Lift Station Floats 2@100each 200.00 200.00 200.00 Lift Station Pump/Panel; alternator, phase monitor, relay, fuses 200.00 200.00 200.00 Sewer Plugs - lift station cleaning 500.00 Community Ed - Display Prairie Festival 200.00 Air relief valve parts 1,000.00 Joint seal 1,000.00 1,000.00 1,000.00 Lab Filter pads -5 bx/yr=125; Kim Wipes 4bx/yr=70; Phosver 3 packets 4 units/yr--160 355.00 355.00 355.00 Process testing reagents/glassware/pipets / pipet bulb/pans 100.00 100.00 100.00 Ice for Samples- EW WTF $3x26wk 78.00 78.00 78.00 pH buffer and storage solution/DI water 100.00 100.00 100.00 pH meter replacement probe $100/yr /DO meter replacement probe $300/2yr 100.00 400.00 100.00 Desicant Process Testing 50.00 50.00 50.00 Total 1 43,337.00 1 49,338.00 1 49,858.00 47 390 Contract Services Attachment 2015 1 2016 2017 Generator System Services - Generator Maintenance E&W WWTF 3,000 3,000 3,000 NRI- HVAC - Heating cooling maintenance/repairs 3,000 3,000 3,000 Fall maint = 490W 340E AE2S - instrumentation services -1100/day 6 visits 6,600 6,600 6,600 Softronics 3,000 3,000 3,000 Contracted - Lawn Spraying 2,000 2,000 2,000 RPZ inspections 3 @ WWTF 150 150 450 $50/inspection; rebuild 2017 @ $150 each Bear Alarms 700 700 700 _ Civic Systems 4,700 4,700 4,700 Nelsons - LS pump repairs major / MF annual inspection 2,000 2,000 2,000 5 trips 200 each + parts Nielson Co - meter calibrations - permit required 2x/yr 1,240 1,240 1,240 617.60 Feb 14, 586.20 Aug 14; done 2x/yr Fire Extinguisher Annual Inspections 200 200 200 Locates 25,000 25,000 25,000 Camera Inspections 1,500 1,500 1,500 Spectrophotometer calibration 417 Hach $397 + $20 for shipping Answering Service - Stericycle 715 715 715 59.58/mo Chain hosit inspection - Midwest Crane 40 40 40 Permit renewal East WWTF - added analytes 500 - - Laboratory EWWTF- Pace Analytical CBOD 4,992 4,992 4,992 Cost/Sam 16.00 #SAMPLES 312 Cost 4,992.00 TSS 2,808 2,808 2,808 9.00 312 2,808.00 T Phosp routine + average reduction 3,200 3,200 3,200 10.00 320 3,200.00 HG 2,800 2,800 2,800 140.00 20 2,800.00 Fecal 1,872 1,872 1,872 12.00 156 1,872.00 NH4 2,028 2,028 2,028 13.00 156 2,028.00 Cost/Sam # SMPLS Cost CBOD (27x0.25)=6.75 27-6.75=20.25 2,106 2,106 2,106 20.25 104 2,106.00 TSS (16.50x0.25)=4.125 16.50-4,125=12,375 1,287 1,287 1,287 12.38 104 1,287.00 TPhosp(20x0.25)=5 20-5=15 routine+average reduction 1,800 1,800 1,800 15.00 120 1,800.00 Fecal 384 384 384 12.00 32 384.00 Salty Discharge pH N/C 0 Chloride (16.50x0.25)=4.125 16.50-4,125=12,375 149 149 149 12.38 12 148.56 Calcium (24.5x0.25)=6.125 24.5-6,125=18,375 221 221 221 18.38 12 220,56 Sodium (24.5x0.25)=6.125 24.5-6,125=18,375 221 221 221 18.38 12 220.56 Magnesium (24.5x0.25)=6.125 24.5-6,125=18,375 221 221 221 18.38 12 220.56 Potassium (24.5x0.25)=6.125 24.5-6.125= 18.375 221 221 221 18.38 12 220.56 Sample Prep Fee (23x0.25)=5.75 23-5.75=17.25 207 207 207 17.25 12 207.00 TDS (16.50x0.25)=4.125 16.50-4,125=12,375 149 149 149 12.38 12 148.56 Sulfate (38.5x0.25)=9.6 38.5-9.625=28,875 347 347 347 28.88 12 346.56 Alkalinity N/C - - - - 12 - Bicarbonate (20x0.25)=5 20-5=15 180 180 180 15.00 12 180.00 Specific Conductance (15.5x0.25)=3.875 15.5-3.875=11,625 140 140 140 11.63 12 139.56 N 120 120 120 60.00 2 120.00 HG 140 140 140 140.00 1 140.00 Biosolids 503 1,020 1,020 1,020 510.00 2 1,020.00 Pathogen Reduction MPN 910 910 910 65.00 14 910.00 Acute Toxicity 850 850 850 850.00 1 850.00 Soil Samples - 186 62 62.00 0 - Priority Pollutants 1,000 1,000 1,000 991.00 1 991.00 83,714 i 83,400 i 83,993 ER K 000 ' N hIM N_ o o a v a) v m v 'Ovom C) OD OD Oo v W 0 0 -0 (O h N v W O tO v m O O N d N ctT O O (D O O m O tf) ' ' N t0 O (o O ' ui N M co AD m W) ' Oo O (o N o ct E cr O C) m M to tO t0 N Y w T N N r (O tO t0 a0 r (O m t0 h O' m M O 10 0) (0 OAK din (Am��l-H O N r N h oo M O r N r a` o N N N (» (» 69 69 69 M fff fA (9 M 69 09 03 69 f9 0 69 (fl 6% 69 (f! M 09. 69 03 1- (D t0 m m 0 m h It h f0O t0 p p N a M co O h oo M O V: cch (O (o M O It oct O' m p«j Ua0 'crM LD N NN m NmhN ON N cooCD (9 (y b9 cf> •O O N O N tO 0D o r t0 M M tO r M m (O m M M c0 O r m b W N �--. cN ' cc) (D N N r o M h N 64 Eg (9 f9 fA fA �fJ (9 (A (4 " (H (9 (H f9 (:i V3 f9 ff3 f9 M o\ O M h O m' o o O v o (o M o m O O m .O N v N GS�"i�'', tO m (Y) a0 h ' M M v O M co OO td o«s Nr V ED ' M ! m It mNa0C tOh �Chc(o O oh C ho ' o (00 aUiT o v LO W, (D O o{N (o rn b O y mo (o rn V_ W v O N r N h N r a` 64 69 (A 69 (a v3 b} se b9 (9 (n 69 % 69 (a (» 69 (9 (9 (» 69 (n (a 69 CO) m r- v h (CO, N oo v co 00 O o co 0 rL 000 a u�'. .� ' rn ' tN0 r(Mco O D. i om0 ' oo ' coo 00(ry p t(j UCO n 0 V- co _(O m M (0 h' M h O O co j�1 O hr c't0 u5 m m o(Oom Mm r r j0 w i� M m Imo t0 co '� L O W _rN yO 4. i X69 69 6% 69 69 69 S4 b9 �(9( 69 69 V> fA 69 V3 (9 f9 (A co iii c4 Lo u R 00 c') N M M N h. 00 (o (0�!, i�tjl'i . v m N h ;Nj1 m m N O M O O Ld ,a oc ' v ' M. (O N }(M�(j�'�lrr;{'1 ' m O N 777 � �� ' v r'r p ((j O (O co O 00 N u) N V N �!' O m O KK�� (0 M O W Q o M y oc ;': �' p v M h N r O N r r m h If M cc 11 N O (O Oci c0 ��j 11(9 T m mNmvcn V o m (n f7) f9 f9 co f9 f9 f9 64 m 69 69 m .(( 6 169 69 fA O 0 o ch Q m (O O LO tO (o m y v m ((fv t�(tt' 00 v m M ' ' h O h v 0 m tO ' N O t l` f� N oo ([j o ui (V m r r cc V_ - N m rn n 10.f�t (�Iifli I tN O N O N v ti v a :3N ti r_ v r a0 h v omoOil mvr 't mi(((N N m . C 4) m f1 (D u N O v V= •= T= of d' L t6 N M Q ur U a :� � nwQ d vi b9 LL V o O No 64 69 69(969 MfAf9(9(9(9(9(�C�,(�(�( a 0 c. Nco cq (D M W (O m O N O °) W n' ' M' m W V ' o M V' v w v (N4 cl q(v0 (am N �7 O. IRM (0 LO m� (6 F m (ovc) vM °)�voND N (D (D2 v Z V O - �-' m (oma co N w Y Q N r ;L- N r OF 11 C CLL C .� 7 L N W N N O p, •- 'O N N (� (U ?� N Q N f1 Z f1 mvmciw 69 fA fA 69 f9 69 0 f%? 64 69 64 69 69 (fi m 69 69 64 64' d ' (n O (O h r M CO O tO Nn O N O O t Y .O ht0 tnN ' COr mm ' Nu v my Oto mo NN ' 14: I( v O LOt CIL ' ' ' (CL LQ (U O N N (*i o0 0 N C0 (O (0 0 (D m Oi 0D t II mm O vh Oto rm N h (O vvN (ON co 00 h M N r t co t C Q N r r N co (�>'p 69 fry(ri W303 6M M 6964(969 69 E96% f9(ff 69 0% V» U). 0 O u) o M O 0o t0 v N t0 (0 N tO O ( vm vh m ' vtONm to vM OcO ' Nm m o ( C O ' [ (6 r mV_ a0 t0 oo Oom ui N C) c0 m h (0 OD c 'p. tON _v hMON MO N c V O O r r M h a0 r au 01) U Q N r r N C 69 69 69 ui 69 69 6% M (9 f9 69 69 69 69 M f9 f9 64 69 (9 E O O O tYp N L t0 h N N M vm m tO OD m o v a 01 4)) 'O 0) 01 t0 v v f0 ' m t0 M h ' v N N (4 O aD c0 r (O (O M ' N (O V_ w 0 0 0 m ' ' O r 0 ya a fl' O O N O N(0 rh v 'It hhrO� h M m, vr0 O LL b y my r o tO n r M h (000 hc' C) m r oo u o m.=+ Qo N r < 0 U(nQN 69 f9 69 E9696964 -6964--f9 f9 --64-b9 f9b K 000 ' N hIM N_ o m a) U-Ak o W � c_T6 � C 0) c E � CD LL � ancu) N d N ctT D U roQw67 U)m O ty 61 N N N O C C (nZ a 01 CO N 0 C `�w�E`)`6� U Q in C) U 0 0 3 U O Q O N 'O (0 rn u1 N N X E cr = OaOz v� c c °) O O c(qw 0 CL zap !`vv N Y w T N N > 3 U C N N C Q d 01 Q O •- •- O Q N Q Z a >i Z- N O 0) N 0) 0) O N 3 N 4) N w N Q) 7 7 7 O OAK din (Am��l-H a_ U) (AOzag u)z nl nni- K 000 ' N hIM N_ o m r N O LO N N t0 69 69 69 6%6% OD Gu) oo(- oo d_ ' PI:. M h o0 C) m m h oo M O r N o N N N (» (» 69 69 69 o ' rnLQv NM N O R O Nr LD N NN (9 (y b9 cf> fa aD v n f0 cN ' cc) (D o o M h N V a! M LO r N N 6s 69 (n 6% +A a0 h h co N ' M m oo (O N 000 to v W N r r h E 64 69 (A 69 (a 1 M h co V CO) I• ' v N IfO N n N N N O C N 0 rL �61�69fia. N co j�1 O1 Il;m II:I�IIr p L O _rN yO i v (�'M 14iP. V ul co iii c4 Lo co Nr- N i � N 41 I��I1iI v r'r 7 f9 6% C' <A o m h If M cc N O (O Oci c0 C T m mNmvcn V o m (n (0 C m V 0 M at N O Q C d) 0 f 69c).64 64 v -T N O (V hOcoMo N Q 11 ro E T �, m O N O N N_ a :3N O M v co • M^ mvr N m . C 4) m f1 (D u N O v V= •= T= of d' L t6 N M Q ur U a :� � nwQ d vi b9 C V o O No O a 0 e N M) _ (D C N c0 o a) Q °) m o o m 0)cu w v a) cl (am N �7 O. N N and m (6 F m O 3 N (D (D2 > L w w a`wi U¢ w C CU C C m O(D U w Y 0) N 6 ;L- N C CLL C .� 7 L N W N N O p, •- 'O N N (� (U ?� N Q N f1 Z f1 mvmciw v a ci¢ wm(n wa('0w0