Loading...
HomeMy WebLinkAboutD-192 1979 Budget/WaterORDINANCE #D- 192 AN ORDINANCE BUDGETING EXPERDITURES FROM THE CITY WATERUTILITY WHEREAS, the Con,on Council of the City of Carmel is desireous of exercisiD~ it's statutory authority pursuant to IC 8-1-2-100 to request the Board of Public Works of the City of Carmel to "~ubmit a budget of its financial needs for the ensuing year to be set out in such detail as the municipal council may direct"; and WIqEREAS, the Common Council of the City of Carmel hereby proclaims that the submission of a comprehensive budget by the Board of Works to the Common Council for review and adoption greatly facilitates the Council's annual budgetary review aud appropriation process; and NOW, THEREFORE, BE IT ORDAINED by the Common Council of the City of Carmel that; for the expenses of the City Water Utility for the fiscal year ending December 31, 1979, the following sums of money are hereby appropriated and ordered set apart out of the funds herein named and for the purposes herein specified. Such sums herein appropriated shall be held to include all expenditures authorized to be made during the yea~, unless otherwise expressly stipulated. Transfers may be made, by ordinance, from one classification to another at any regular public meetim~. Projected revenue for year 1979 - Operating and Depreciation Account Balance 1-1-79 $424,009.64 4 o,422. 4 $834,432.18 Budget by accounts Source of supply 611 Structures & Improvements 614 Wells & Springs Pumping Erpense 622 Power Production 623 Purchased Power 626 Misc. Expense(includes telephone) 631 Mtce Structures & Imp 633 Mtce Pumping Equipment Water Treatment 6kl Chemicals 642 Labor & Expense 643 Misc. (Includes telephone) 651 Mtce. Structure & Imp. 652 Mtce Equipment Transmission & Distribution 660 Supervision & Engineering Regular Overtime $ 2,350.00 13,800.00 94o.oo 43,234.94 1,260.85 1,732.00 6,864.73 64,772.41 24,038.35 2,250.00 2,882.00 1,028.00 4,630.00 3,896.10 Page 2 Customer Accounts 902 Meter Reading ~. Vehicle Mtce. 903 Records & Collection 903.1 Computer Billing Expense A~m~uistration & General 920 Salaries 921 Office Supplies & Expense 923 Outside Services 924 Property Insurance 926 Employee Pension & Benefits 930 Misc. Genera& 932 General Plant 933 Transportation Undistributed Expenses 408 Employees ~ICA 408.1 Indian~ Unemployment 408.4 Indian~ Sales Tax 409.3 Indian~ Gross Income Tax TOTAL DEPRECIATION FUND Utilit,y~Plant in Service. Water Treatment 330 Land & Land Rights 331 Structures & Improvements 325 Electric Pumping Equipment $1o,4 5.oo 3oo. oo 34,467.00 8,811.29 43,979.90 8,970.00 12,301.00 8,~0.10 896.00 880. O0 3,164.00 7,918.41 4o0.00 11 ? 000.00 300. O0 .280.00 15o.0d Transmission & Distribution 342 Distr. M~ins & Reservoirs 3~5 Trans. & Distr. Services 346 Trans.&Distr. Meters 3~7 Meter Instal. 80.00 1,050.00 17,000.00 18,000.00 General Plant 390 Structures & Improvements 391 Office Fur. & Equip. 392 Transporta%ion Equip. 394 Tools, shop & garage equip. 397 Communication Equipment 396 Power operated equipment 399 Other tangible equipment Total 300.00 1,J50.00 7,000.00 120.00 1,45~.00 1,000.00 ~0.00 '48,1~0.00 436,778.~3 This Ordinance shall be in full force-and effect immediately ~fter its . _'. _, _.__, ___'___n ,.-) ''''c+ J.o. 1 . 01', 211 3 14 4 5 01. 6 22 7 23 8 26 9 10 31 11 33 12 13 01. 3 14 41 15 42 16 17 18 43 19 51 10 h5 2 11 22 23 w'Ol, 4 - 24 660 25 h61 26 h 62 17663 28 . c., 29 65, 30 71 31 72 32 73 33 75 34 76 35 77 36 )7 38 39 40 Source.of Sunnlv . Structures &.Imnrovements liIelis & Snrin"s Pumping Expense' Power Product~on Purcha.sed Power" Misc. Exnense(In~lu~~ .. c.. :. '.' ."..' . . -'" . Mtce Structnres' & 1m'", Mtc~' Pum"incr E'-'ui"ment 1_. ',J." 'Wat'er Treatment . Chemical s' Labor & Expense Re ~ular Overtime Mise, (Includes telephone '! Mtce Structure & Imn, Mtce E"uinment ~ Tran:smi ss ion & Di stribut i( Supervision & En~ineering Storage Facilities Lines (include labor) Meters Renairs. I,.,. ~.., . Misc.(includes auto exn,) Mtce,Structures & Imn. Reservoi~~ & ~+~n~p~ Mtce Mains Mtce.. Services ~. M~int~~ance'Meters Maintenance Hvdrants -- : ) lq7R . 'Yearlv Total /. ;;'7 . j;; ~I " ----. t<i~ ~ 2"ri ...- . '., ~ ~I---" 2 . V 3" v 1 cj 7q Yearly t r'ojected. Tctal ?,1~,o 00 1'1~~rooo I ft'l. ~~ 0 00 i fc; 01 ~~!qJ.l ~d~ O~ ;;.1,'0 'is .1,. ,,_ d. 1 . I ~LiJ lOll !;l.(no) ,~(! ;. . ,~JI ~~ ,. ,.., , I I I';'] .~i~ Ifb III~I b is q)[.,iS h 1 ! I "7gl trO r~ ~,j\3.~ I !~~ 5'1, i' :7'1.J'j I i I , i II I rr<.-o 11::,45'3,<]':' ..1~~l9J9.'. .R' Ii',' ,,.. I . ,..'23 I i I I.~ ~~f3~ 1 I ,f I/o ! : 9l,L;n.;l1 I i-,'. I, I 7. J I '/) ,I '1/ , . .:<.10; I I '- II II i ! II , I ~~ 7~] <II I '1C2~~5 b ~I~?l ~o I ~~sb 00 1'1 ," difo~ \ !'3b ob I II ! ! i, ! . I , ! 3~j~ I,.; i 11!od_ :9123!t. ?o. ! I II I I '! .. D,Yt~ , ~ooroo i i 1101010<> , ':11 " "0""~ It.l..!-. ex) .iJ1_ I j r~ 00 i , I 1\ I II I! I i I I 1 i ! I I !! 1 i i 1\ I' Iii I, 1 11 4 ---=, I . ~ - 3 1 4 5 6 7 8 9 110 I '11 11 11 II I II I' I II I __~ Ill: II II I I . 17 I U___-.~ 11 !' ~i I I t 2( I i I 121 1'1 '. I _2= I ., !" 2: 1, IE I I 2' 21 ! I :, Ii , , 121 I.. f." 21 11 i : , i: I ,. I ! II I 3' . , !.... ; . ~_ w Ii I . J Ii I , 3. 3 3 3 Ii ; 3 3 3 I' It : I I: , I i II ____'-L- I.... -.-,.-------..--- . -.---- -~. ---.---. ='" .. _ hS.S2~ . No. 1 401 5 1 902 3 4 903 5 903 1 . Customer Accounts Meter Reading Vehicle Mt ce . Records E Collection Computer Billing Expense 6 ] ll~ ~03t RCW..~aLr 8 401 6 Administrqtion E Gen~ral 9 920 Salaries JO 921 Office supplies E Expensel 11 923 Outside Services 11 924 Propertv Insurance 13[926 .! Employee Pension E ~~~~;:pa~~~:~: J61933 Transportation .1.9 7 A Yearly Total II ,-lr,', , '~J{:ilJ 0..5 - . I Sa. 3:/: - f.~ Jl2l ~j- . h. ' , ItJl./, I I' L..-i 'J '."" 0 I~" ' . I/! $3. '. A",I I' i I -L 5-!.L]" Cio I Benefi:~ I '()]JJ Q"i II I :'" Ii . ,~I'~ 0<.1, I I: I )ioo 00 ! i .~Ic~ ' !,jl OJ. Db I! I! 17, 10 i !! ::1 =1\ 21 ! 11-",'1: ')~..ihutd-Ixpe.ns""" 21 ! 408 Ii ErUJd.lm,ee s FICA' 23 '408 3 I Ih:aiana Unemplovment N 408 4 Indiana Sales Tax ~ 409 3 Indiana Gross Income Tax 26\ Ii Dct3r~r>~ ""t::.ioPi I:}"'!-,~Jn:.e 17 '~(- I: H,i:ere.i: long t'ilPIR ac:l:>t 2E 29 30 . ::~ 31 33 34 3, 36 I ,] 38 39 ", il " , , , I, ! ~ 1 I I II i I I I I ,. I '! ,I , t!j "--, lJ,Q.1.5 00 I : ! sJJoo I '1S/''; oc I 5','/00 ;l .....' I , , i I ; 'i II ' , ; It I : , , I I I I I , , 1 , I , , i i I i I , , i I 1 I , Hi ..... !.~ ;.. ~ "-1" " ~.. - JcL<! "11, ob~ 0 ~ ~ ~' + ,;';; ~~ ~11 , " I , ,I; I " ; Ii! '! I _ 1 i I 'I I' , I II Ii I I [I i I -I! I: I I I' 1. t 1 t I' , i i I I ! I II : , , , I I II II I I, i i l i ! 1 I i i ! , i .,iM V. , ~~ ), l' U...'1j/ ...., , Ii Ii "j I . ,I ~ r II , ' . , i ! II i i ! ' i ....LJ_ , , i i ).. )H 3' ~ .- '1979 - -,=:=.,".. '"""f ----... .....e I' Proiected I !Yearlv Tota --~~:~=-_"=.L tl. JJ-~ i-,-- _I ,/,f '1 J :, 00 II 1 I ' I rho}; ~;- -11-1 i-'I ' - 3~Tttl op_ IT T1 .-- I, ": ~1r)l),,1' - 11',t-t I I J I II I -H 1'1 -- if' , 111"-11' I~c 11 i I,I ~ ; j : 'Of: ,...~ Jr~ ~, '<'i"':" ....~: : '6H~'o ~ ,i: I . I : I -/.JJ~,:'3:0:1 e><)~ i '--+1 i-li- . _.:~;~ ':3..J 7 :1. '_ ___.:. : I' . W..2~ loJi I'. . : , : T'g~ oJ I! ! -:-11= 1: -~ I :: I?:(O 00 I . . , , !3IJii" "" I Iji I~' .- ~l~ 1III 'T . ! :! ! I I '3: --' I -v I ': t1 '.-r-:': i : Ii I i iT '1"-;: i J _. !____ , i J nL9i// \; '" of-o'" ".n .-.- ..- ~. -.- I' Ii . 1-- f~ ,. .__.. . L . I J ,. -. --l . .I.-~:' . _ I ~ , i . I' I . I ! , I , !' I i I I; ,-~-H . , , , '-'-'--C"- .- - -. - I ! I I i I I , . , I , , , --- :' - , , , , ._- i __ e_-'-_ I I "i-' I I I , , , , - ....... '. ... -.., . _. . ,. ~, ).. . )_ .'u_. _:...__............. .__. I o=-=: ~= Acct. - -No. -' J 2 UTILITY PLANT IN SERVIC W~.r. T_:r..e~.D..t. Land & Land Ri~hts Structures & Improvements Electric Pumping Equip. 3 330 4 "331 5 325 6 ) 8 9 lC,342 JJ 1343 12 345 !: 346 14! 347 15 I 348 Transmission IDistr. 'Mains I~ . & Distribut ion & Reservoirs \I 1.. Ma1.nS Service s Meters II II 16 171 I, II. i.' " , I I , II . " Heter Instal'. J6 Ii ]9 I I 10 I IGenpral Pl ;'ll11' _~.d: 3901 !lsTY'l"C':t.u.ce.s.. f, Tmpw)\/pmpnt.sJl ;] ,a'! IlofLiN> Fur_ & ~-i I 23 i"l9?1 !iT~XspoY'ta.:tion~'~~T>. I 24 394 Tools, shop & garage equi' . 25 397 Communication Equipment ~t.i 396! ,:Power operated e.ouinment II 12.L389niOther tangible equipment .2B I ' i 29 30 31 I 32 33 34 25 36 ;) '38 39 40 I ~-- i-~"'~-':~~-3-'--'='~~~= 4'~""'''' '.== I f ~~ JJ II II Ii i I iT}, ,,, i I II 1 " I' I' ! /.pJ~ I I. I i ~~g!:lbt Tl I! i :;1;--'" ;/11 i' ! : ~!_lL:OD r_.. I, : .! '.,' , i i \ I I IT II I II 1'otal Actu I ~:Xp..ens.e_th I" 11-14-78 ~?f 00 ):35: K2 t-. I I Lao 00 II II 0'1""'0 Ii i I I l , I I. II II ! i I. TT i I I! : i I II I I 'r{.:b 'I? ; I i I !: )j;JJ.jt~.1 f- ! ~_ I: , :- 0 ' h,1 " ,.. 1!.6. l."J~ I I !! I I ~:;~q ! I i 1 i 'I.' ,/,1 TT ,I .' Iii! , .' 0.541 O~t-- . ;: , :;3..Q' X i-..L- i, ~ 1 ~: I 1 II II I! I: , , ! ! , , i \ , I , , , , ! I I , I I, ! I ,--'-I -- .... ---;--7- -1-'- ; .. , : I j I i I: I II - T I i ~ i: I I I! ! I II I! I I I '-, ': ---r--t-!-- -- , ! ; : ; ! I i I , I . ". T~~,=,z;''''~'ll- 1-9-7" '___'_'h_ . "11 E=.;j.e..c.:t.e.L ___.._.... .. Total ocJ OrJ II;:;; d l~":~ t~j-1'-' - ~._ _.........1_ . .",_ ~ II I! II J.L-1 J I: 'I j-H.! 'J[ '1" I . 1 f' -- -"'-'- , , 1: ; ! ~ ! : 9 00 i I I i I ! I i : 05, (JU . I! ',~ -Tl I ' I :654...-';i.J \ '<slo..Qi" '" 0 I ' !! ! , -'- I .__ ._,2 .1 I I , - "-7-: I, ' , i I " __-* I!! " __ _'] .J-. I I . :. --- ..--- ! Ii, ; II II i : ,--'liI' ! i :j~1:o ! L.":" -!- )).0'01) !__ ..I.~ , :,. "I ., ,. ; I ;:: 00"" ,u ~)~1'; I ' IT,).!; . ILJ',,! oD I . . 'I I' __..1.. <.J c_CZj.o o1i;~ __ ~_ J _~ . "-,1' .! " ..",..;>0'.0..<:1. . j ..J; ~ 1:\ I,n~ '- !: -~l.:. ,!' -l " 1 " --q~ i~ '1 !. :,~~: - ~~ f1.=- . 1_- . I j' I I I 1 i , , 'i j , I , ! , ' I \ I i i I! I I ,. I 1 I , I : i :] I i I I I! , I '..1-" _ : I ! I MAJOR PROJECTS 1979 1. Plant #4 Well test ,boring Structural soil boring Plant #4 Land Engineering topa survey Engineering & Observation Resident Inspection Plant #4 Wells Plant #4 Well land Public Service Commission Engr. Svc. Public Service Commission legal Public Service Commission McCullough 2. Plant #2 Iron Waste Project Include replacement of multiport valves 3. Main Extensions in City ) $ 5,000.00 3,500.00 I 1,600.00 250,000.00 85,000.00 5,000.00 $250,000.00 12,000.00 $210,000.00 . . I _,.'..l ," Acct No. \ WATER BUDGET NOTES Source of Supply " 611 Structures & Improvements Paint ~ell houses Road to Well # 6 Add power transfer switches Two @ $600.00 to wells 3 & 614 622 623 626 531 " $ 200.00 j 950.00 9 1,200.00 Total $ 2,350.00 Wells & Springs Average routine maintenance year Clean 2 wells @ $3500.00 Repair one ~ell 1,800.00 7,000.00 5,000.00 $13,800.00 Total .. " Pumping Expense Power Production Maintenance Supplies Diesel Repairs $ $ 290.00 650.00 940.00 Total Power Purchased 1978 Expe ct to pump 6 % Rate increase .for more 1 yr. ( 4 % 0 f 41,572. 06 ) Total $39,2],9.06 2,353.00 1,662.88 $43,234.94 .~.... Misc. Expense - includes phone 1978 Add telemetering new at Ground Storage Tank @ $36.0o/mo. Total $ 828.85 432.00 $ 1,260.85 ~aintenance Structures & Improvements 1978 Building Repairs Downtown Building Repairs Plant #3 $ 232.98 1,100.00 400.00 $ 1,732.98 Total 633 Maintenance Pumping Equipment 1978 Inflation 10% All equipment 1 yr older 6% Standby pump at Plant #3 Overhaul one high service pump $ 1,384.73 138.00 92.00 2,600.00 $ 2,650.00 Total 6,864.73 , . .,. ) Page 2 Water Budget Notes Acct. 641 642 643 651 652 663 920 Water Treatment No. Chemicals: 1978 6% more pumping Approximately 7% cost increase Operation Labor & Expense: Pace . Whittaker Waples Dougherty Overtime Uniform Service Misc. Expense: 1978 10% Inflation .. Maintenance Structures & Improvements: 1978 10% Inflation Furnace overhaul Total . T~t al Total Total Maintenance Water Treatment Equipment: 1978 \: 10% Inflation, All equipment 1 yr. older - add 6% Total Meter Repairs 10% of 4500 meters x $9.00 Administrative Salaries Dougherty Williams Pickett Horvath Sw i ft Reiman Meecham Garretson Doane Kern Cline Smith Hohl. . Cout s Zie s e J.k;r.J<<N'\..r" Total $57,108.46 3,426.5.0 4,237.45 $64,772.41 '. 6,325.00 7,335.00 4',950.00 2,343.75 2,250.00 834.6b $24,038.35 $ 2,619.36 262.00 $ 2,881.36 $ 624.54 63.00 340.00 $ 1,027.54 $ 3,971.00 39 .00 262.00 $ 4,630.00 4,500.00 7031.25 3300.00 5667.74 399.96 399.96 399.96 399.96 399.96 399.96 4332.90 3300.00 4834.18 2597.40 3116.67 3300.00 $39,879..90 _ .J JAto'J ~ '., ". I Page 3 Water Budget Notes Acct. 660 Transmissio~ & Distribution No. Supervision " Engineering: Fred Hohl 1/:) M:l'pilynn \.1hi tmiln 1/4 Davc McConnoll ~" 0 \I e x L ~JIle. . $ 3,,896.10 -4,323.00 3,000.Oil 'i,gOO gg So' 3,896.10 " Total -- 661 Storage Facilities Operation; Cathodic Protection Cont~act $ 1,200.00 Tower Maintenance & Controls 700.00 Ground Storage Maintenance grounds, controls, telemetery,generator 4,400.00 Total $ 6,300.00 662 903 " Lines - Labor & Expense: Allot Randy Strong Jim Conway CETA Lance Briggs '~Overtime This account includes uniform service @ $278.20 per year per man for 3 men Total 14,400.00 9,500.00 9,000.00 4,000.00 834.60 $37,734.60 Thalls Acct. Rec. , Lowry Becker o ve:rt ime $4,675.00 5,100.00 4,510.00 4~510.00 2',400:00 $21,195.00 Total ..... . ) Page 4 Water Budget Notes Customer Accounts Acct. No. " 902 Meter Reading 0'. Wyatt J. Morrison Overtime + CETA - Will not cover in $ 1979 " Total 4,675.00 5,665.00 410.00 10,750.00 This would change if CETA . cuts off fun8s .' 903 Customer Records & Collecting: 1979 Payroll Thalls $4675 Acct. 5100 Becker 4510 Lowrv. 4510 = Dvertlme 240Q Postage ~or billing 1978 Postage for office Average - 200 new customers Billing Forms *Conversion Cost New Computer Postage Meter @ $lO.OO/mo x 12 , Total $21,195.00 4,692.00 480.00 180.00 3,600.00 4,200.00 120.00 fu. 46 7 :00---- 903.1. Computer Billing: Since we may purchase our i~ hard to budget. . Based on last year J% price increase Plus average of 200 year ~ 2 own comput er or change services, it $ 7,954.44 556.85 new customers for water 300.00 Total $ 8,811.29 , . ~ ' - " --.._----.- --"Ci'" ~~. i ;f.' ." 1_... L.____._. I~ -. ...~.l,;,.i ~,;",.;':"~ 2 .. " , 4 ..5 6 7':.. '. ....A-t;':~/, . 'C'. ,. .~. .~. r '. I, I.. . .. . ...:....,., ,Au -1:5i; .:1.+::0 -, . oJ_" .... :>.. b'3/-7P p I. ,;. .. . I ." "" -- . I 't 1 . '.' ^..........~:::.,..: iil..... .. .,. Il) =1~1. - ... . . .. - .... 1 ; ........'. k'P. ~::"'.... ~q :< . R ~ . . . ,-,., , I,', 2 - , . '. 1 d . ......j1... r.-.. Jl7~ .... '. LJ I OYj b ." c' lO 7J , .' } 4 ~., ~ 1:;'. ~.. -lJ. - . 1~l>Y . 4 5 ,41,';', )i-w~-'- J 5 I sa . SI s;! 5 6 '" I ..~ ;" ......... ft c; . - IS I' 6 .... '0' /li..- '" . D, : " r O~ '. j all . ",,' (j- 5 ) ,. .' '. -"; '" -'~ '. .' B ".' .. '" .' .' , .... .. s '. ,.,..,',' . , t.~::! . . .. ,.< .. :':i '_~ .:-t!:.: .r..' . ..~.:i ," -.-0" ,,'-. 9 . 1'1 . '''"' .. 9 . T i'l,: H ,'/9'1eT-;, " 9Y 10 .' 5 '1lv"3 - & il .~ I...>:.... J I . 11:'jj',g. _"A ... .. ~~.- . .. . .. 'h -- ... .. .. .. n . .. . .. O' .-'. _....~ . ". 11 , -- . 1: .. . .. . -.-~' .. J. .~ , 1/ "'. .. .'.. . '" ". - "'. . ..--.." . '1: . . ; .. '. ..:,. : . '''E'. , ~ .. . .. ..." . .. .. "'. . . . . ;.. ,>, , 13 I Ii , ,- , 3 , 14 1. . JCXl ."1 ; . , ,., /U IS \! '. .. '.~ ~lkl I 16 .. . 11 .. . ...... ..........,.. '::-..' i.' _~:, ~ '. ....... .... . , '. . l' , .;;;::: , .. l ~ . . ,,: .. , .... 1B " " " 19 ' '. ',. . .. .. '. , ," I " ,.01" . .... I. . re' . . '--' ... .. .. . I. 20 ..' .. o. I 21 . ... .. --:: . 21 ; : 2: . . ,..,."..... --::. . - ~ 1"--" .".' -, .- . .. --. . i 22 . I. . '. . .. ~-' .. . I 13 .. j. I 'n I I 24 I , ,~- 1-. .' ..-""'- - . 25 I i i . 2 26 I ; 2, . I .. 7 , 28 ,'. r'+- .. .. 29 II .. -.- IT - 30 . .. ...- - h 31 -..; f!- 3 .. . . -. l .' . " . ! ! ~ 3 =--=+ . ! ; 34 . .. .. 35 I ! I I . , , I : I I I I i I ! i I ! I '<; ! I i ! I I J -. I! Ii Ii ! i ! i 37 i I 3 - . ! I , i 1 II I I 3B , ; 1 ' I .... :.;1 , i i ! 39 : : i I 3 II I : I i' 4 40 ., I !. . I ! I I I : I , ! I I ; , : I , ..