Loading...
HomeMy WebLinkAbout1997 r L, r- JEFFERSONVILLE WASTEWATER TREATMENT FACILITY r t I. 10.., ....., r ELECTRICAL CAP ADJUSTMENT REpORT r L PRESENTED By: ENVIRONMENTAL MANAGE.MENT CORPORATION r JANUARY 27, 1997 *, l L r L, - [ .-S""' = ~ ~ ~"., f1 I~I [ fJ EB r r: t!.:.,~ January 27, 1997 Dick Spencer City of Jeffersonville City/County Building Jeffersonville In. 47130 ENVIRONMENTAL MANAGEMENT CORPORATION 701 CHAMPION ROAD JEFFERSONVILLE. INDIANA 47130 812-285-6451 FAX 812-285-6454 Re: Electrical Rate Increase Report Dear Mr. Spencer: Enclosed please find documentation detailing Public Service of Indiana's (PSI) electrical rate increase and its effect on the electrical costs of the Treatment Facility and Lift Stations. The rate increases differed, depending on the amount of usage and rate structure at the various locations. The overall average increase is 7.81 %. As discussed previously, the increase requires a change of the electrical cap as outlined in EMC's contract with the City. The new annual cap should be $191,027.40. The cap for the 1996-1997 contract year should be prorated (effective September 1, 1996) at $186,414.60. Attachment A contains the 1996-1997 electrical cap adjustments at the facility and all lift stations. This table details the percent increase on the electrical rate, monthly budget increase, annual cap and the prorated cap. Attachment B shows the breakdown of the electrical rate expenditures. Attachment C shows the breakdown of the electrical rate expenditures on all the individual lift stations and the treatment facility. As always, we appreciate the opportunity to be of service to the City of Jeffersonville, and we are available to discuss this report at the convenience of the City. Sincerely, ENVIRONMENTAL MANAGEMENT CORPORATION ~.~ Scott J. Timmermann Assistant Facility Manager fl lU n by_" Attachment A Electrical Cap Adjustment.. 1996/1997 ~-""H'~ JEFFERSONVILLE, IN I , [I "' 1996-1997 Electrical Cap Adjustment Budget Old Budget New Budget Lift Stations 0.10 Increase Increase/month /month /month Wilson School 4.6% $0.51 $11.00 $11.51 Powerhouse 4.6% $3.45 $75.00 $78.45 Middle School 4.6% $2.30 $50.00 $52.30 Camp Powers 4.6% $3.31 $72.00 $75.31 Magnolia 4.6% $0.36 $7.75 $8.11 Ewing Lane 4.6% $10.78 $234.25 $245.03 Eastern Blvd. 4.6% $0.83 $18.00 $18.83 Rolling Fields 4.6% $1.00 $23.45 $24.53 Arctic Springs 4.6% $0.64 $14.00 $14.64 Colonial Park 4.6% $0.64 $14.00 $14.64 Louise St. 4.6% $0.68 $14.70 $15.38 Mill Creek 4.6% $24.24 $527.00 $551.24 Crums Lane 2 4.6% $0.52 $11.28 $11.80 1 st St. 4.6% $0.05 $1.00 $1.05 Riverport 1 4.6% $4.09 $89.00 $93.09 Riverport 2 4.6% $1.70 $37.00 $38.70 Cederview 4.6% $0.37 $8.00 $8.37 Rivershore 4.6% $0.72 $15.71 $16.43 Utica 1 4.6% $3.39 $73.70 $77 .09 Utica 2 4.6% $0.60 $13.00 $13.60 Sunset Mobile Home 4.6% $0.64 $14.00 $14.64 Crums Lane 1 4.6% $9.20 $200.00 $209.20 Crums Lane 3 4.6% $0.73 $15.77 $16.50 Tenth St. 8.8% $152.06 $1,728.00 $1,880.06 Golfview 4.6% $0.92 $20.00 $20.92 Spring St. 9.7% $26.69 $275.14 $301.83 Eastbrook 4.6% $1.98 $43.00 $44.98 Silvercreek 4.6% $19.92 $1.00 $20.92 Cherry Creek 4.6% $36.21 $14.00 $50.21 Wastewater Facilitv 7.6% $843.60 $11,100.00 $11 ,943.60 Total Monthly Cap 7.81% $1,153.21 $14,765.75 $15,918.95 Annual Cap 7.81% $1,153.21 $177,189.00 $191,027.40 Prorated Annual Cap 7.81% $1,153.21 $177,189.00 $186,414.60 11'",_1:'=- JEFFERSONVILLE, IN Attachment B Annual Electrical Expenditures fj tJ ".._0 JEFFERSONVillE, IN Annual Electrical Expenditures EleCtrical Cap - $177,189.00 .~. JEFFERSONVILLE, IN n LJ Attachment C Annual Facility and lift Station Electrical Expenditures n L: ::'=1lUfU..-: -- JEFFERSONVILLE, IN Wilson Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 Jan-97 Feb-97 Mar-97 Apr-97 Totals $11.00 $11.00 $11.00 $11.00 $11.51 $11.51 $11.51 $11.51 $11.51 $11.51 $11.51 $11.51 $136.08 $19.49 $1.83 $1.65 $2.89 $7.20 $3.03 $28.59 $0.57 $0.40 $0.31 $0.26 $0.34 $0.32 $0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $2.58 ($8.49) $9.17 $9.35 $8.11 $4.31 $8.48 ($17.08) $0.00 $0.00 $0.00 $0.00 $0.00 $13.85 $64.68 Wilson Electrical Expenditures Ui ~ ri "'. 30.00 25.00 20.00 15.00 D" il ,,'I 10.00 (l li :,:",J 5.00 0.00 co q> ~ :!: co 0) C ::l ., co q> '3 ., co 0) C, ::l <( co 0) 6.. Q) (/) co 0) 13 o co 0) ~ z co 0) ~ o r-- 0) ~ ., r-- 0) .h af D KWH r-- 0) .:. al :!: r-- 0) .:. c. <( 442 41 36 60 165 38 581 1363~ . Budget . Actual [] Credit "_JIiIIlII"~ JEFFERSONVILLE, IN Middle School Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 $50.00 $82.20 $0.57 ($32.20) 1864 Jun-96 $50.00 $50.11 $0.40 ($0.11 ) 1121 Jul-96 $50.00 $110.97 $0.31 ($60.97) 2423 Aug-96 $50.00 $51. 77 $0.26 ($1. 77) 1074 Sep-96 $52.30 $57.00 $0.34 ($4.70) 1182 Oct-96 $52.30 $88.37 $0.32 ($36.07) 1771 Nov-96 $52.30 $61. 84 $0.38 ($9.54) 1257 Dec-96 $52.30 $0.00 $0.00 Jan-97 $52.30 $0.00 $0.00 Peb-97 $52.30 $0.00 $0.00 Mar-97 $52.30 $0.00 $0.00 Apr-97 $52.30 $0.00 $0.00 Totals $618.40 $502.26 $2.58 ($145.36) 106921 Middle School Electric~1 Expenditures 120.00 fl 100.00 ..~j 80.00 . Budget 60.00 . Actual 40.00 [J Credit 20.00 0.00 co co co co co co co co I'- I'- S; I'- 1 OJ ~ OJ OJ OJ OJ OJ OJ % OJ C: '5 C, 6. 8 ~ ~ C: .:.. .:.. :::J :::J <Il III Q) III a. :E .., .., <( (J) z 0 .., u.. ::E <( n U u ~l~'l' .~ JEFFERSONVILLE. IN Powerhouse Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 $75.00 $74.71 $0.57 $0.29 1,694 Jun-96 $75.00 $88.10 $0.40 ($13.10) 1,971 Jul-96 $75.00 $64.35 $0.31 $10.65 1,405 C Aug-96 $75.00 $53.84 $0.26 $21.16 1,117 Sep-96 $78.45 $79.06 $0.34 ($0.61) 1,623 Oct-96 $78.45 $87.28 $0.32 ($8.83) 1749 Nov-96 $78.45 $61.50 $0.38 $16.95 1250 Dec-96 $78.45 $0.00 $0.00 Jan-97 $78.45 $0.00 $0.00 Feb-97 $78.45 $0.00 $0.00 Mar-97 $78.45 $0.00 $0.00 Apr-97 $78.45 $0.00 $0.00 Totals $927.60 $508.84 $2.58 $26.51 10,8091 Powerhouse Electrical Expenditures 90.00 80.00 70.00 60.00 IR 50.00 lei . Budget 40.00 . Actual 30.00 C Credit 20.00 10.00 0.00 co co co co co co co co r-.. b; r-.. r-.. 0) 0) cp 0) 0) 0) 0) 0) 0) 0) 0) ~ C: 0, ~ t ~ g C .h. ~ ~ :::l "3 :::l ell Q) ell Q, :E ~ ~ < en 0 z 0 ~ u. :E < -~= JEFFERSONVILLE, IN Magnolia Electrical Expenditure MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 $7,75 $16.23 $0.57 ($8.48) 368 Jun-96 $7.75 $8.40 $0.40 ($0.65) 188 Jul-96 $7.75 $9.07 $0.31 ($1.32) 198 Aug-96 $7.75 $7.66 $0.26 $0,09 159 Sep-96 $8.11 $11.62 $0.34 ($3.51 ) 254 Oct-96 $8.11 $7.58 $0,32 $0.53 152 Nov-96 $8.11 $11.61 $0.38 ($3.50) 236 Dec-96 $8.11 $0.00 $0.00 Jan-97 $8.11 $0.00 $0.00 Feb-97 $8,11 $0.00 $0.00 Mar-97 $8.11 $0.00 $0.00 Apr-97 $8.11 $0.00 $0.00 Totals $95.88 $72.17 $2.58 ($\6.84) 15551 Magnolia Electrical Expenditures 18.00 16.00 14.00 12,00 10.00 . Budget 8.00 . Actual 6.00 C Credit 4,00 2,00 0.00 <0 <0 <0 <0 <0 <0 <0 <0 ,.... ,.... ,.... t;; Ol Ol cr Ol Ol Ol Ol Ol Ol Ol Ol ~ C: 0, 6.. t ~ ~ ~ .b .:.. .:.. '3 al C. :::I -.. :::I Q) 0 Q) ::2 <( ::2 -.. <( en z c -.. lL q U U:1 ",','. !i nCI' 11 :,I! '.1 y [?~ ri l; :! Lij _~-D#fiI JEFFERSONVILLE. IN Ewing Lane Electrical Expenditures D MonthlY ear Budget Actual Credit Budget Diff. r I f l May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 Jan-97 Feb-97 Mar-97 Apr-97 Totals $234.25 $234.25 $234.25 $234.25 $245.03 $245.03 $245.03 $245.03 $245.03 $245.03 $245.03 $245.03 $2,897.24 $141.08 $143.67 $114.60 $122.57 $128.27 $119.76 $73.60 $0.57 $0.40 $0.31 $0.26 $0.34 $0.32 $0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $2.58 $93.17 $90.58 $119.65 $111.68 $116.76 $125.27 $171.43 $0.00 $0.00 $0.00 $0.00 $0.00 $828.54 [J r -'-- $843.55 250.00 200.00 150.00 100.00 il u 50.00 tl I,~:,:~ 0.00 co co co co co co co co b; ,.... ,.... ,.... O'l O'l ~ O'l O'l O'l O'l O'l O'l O'l O'l ~ C: '3 0, Q. .,!.. ~ 0 C: .b ~ ~ ::J ::J Q) (J Q) a:l Q) a:l Co :2: ...., ...., <( C/) 0 z 0 ...., u.. :2: <( Ui II 1j >r' KWH 3,199 3,214 2,503 2,543 2,601 2400 1496 17,9561 . Budget . Actual [J Credit ----: JEFFERSONVILLE_ IN Camp Powers Electrical Expenditures fl tJ MonthlYear Budget Actual Credit Budget Diff. KWH May-96 $72.00 $16.62 $0.57 $55.38 377 Jun-96 $72.00 $15.11 $0.40 $56.89 338 Jul-96 $72.00 $14.61 $0.31 $57.39 319 Aug-96 $72.00 $14.32 $0.26 $57.68 297 Sep-96 $75.31 $17.04 $0.34 $58.27 381 Oct-96 $75.31 $16.12 $0.32 $59.19 323 Nov-96 $75.31 $12.00 $0.38 $63.31 244 Dec-96 $75.31 $0.00 $0.00 Jan-97 $75.31 $0.00 $0.00 Feb-97 $75.31 $0.00 $0.00 Mar-97 $75.31 $0.00 $0.00 Apr-97 $75.31 $0.00 $0.00 Totals $890.48 $105.82 $2".58 $408.11 2,2791 Camp Powers Electrical Expenditures 80.00 70.00 60.00 50.00 . Budget 40.00 . Actual 30.00 [J Credit 20.00 10.00 0.00 co co co co co co co co I'- I'- I'- I'- Ol Ol cp Ol Ol Ol Ol cp Ol Ol Ol Ol ~ C: "'5 b c.. ,.!.. ~ u C: lJ ~ ~ ~ ~ (]) 8 (]) 11l (]) 11l a. :!E J J <( en z Cl J L.l. :!E <( ~ c-:- l I! lJ t':"""',il "I! -~ f1 ~ Ii ld D' ,!~ i :, "t. ~~r JEFFERSONVILLE, IN Eastern Blvd. Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 $18.00 $12.83 $0.57 $5.17 297 Jun-96 $18.00 $14.39 $0.40 $3.61 322 Jul-96 $18.00 $31.46 $0.31 ($13.46) 687 Aug-96 $18.00 $30.27 $0.26 ($12.27) 628 Sep-96 $18.83 $20.12 $0.34 ($1 .29) 435 Oct-96 $18.83 $17.71 $0.32 $1.12 355 Nov-96 $18.83 $14.76 $0.38 $4.07 300 Dec-96 $18.83 $0.00 $0.00 Jan-97 $18.83 $0.00 $0.00 Feb-97 $18.83 $0.00 $0.00 Mar-97 $18.83 $0.00 $0.00 Apr-97 $18.83 $0.00 $0.00 Totals $222.64 $141.54 $2.58 ($13.05) 30241 Eastern Blvd. Electrical Expenditures 35.00 30.00 25.00 20.00 . Budget . Actual 15.00 fl [] Credit ,.i! t~ 10.00 5.00 0.00 <0 <0 <0 <0 <0 <0 <0 <0 !;; .... !;; !;; ~ 0) ~ ~ 0) 0) 0) 0) 0) ~ C: '5 Ol 0. ..:. ~ ~ C: .b .:. .:. :::J :::J Q) 8 <<l Q) <<l a. ::?: -, -, <( U) z 0 -, u. ::?: <( ~mJ] JEFFERSONVillE. IN F r :; t Rolling Fields Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 $23.45 $83.30 $0.57 ($59.85) 1889 Jun-93 $23.45 $70.49 $0.40 ($47.04) 1577 Jul-96 $23.45 $36.09 $0.31 ($12.64) 788 Aug-96 $23.45 $24.87 $0.26 ($1.42) 516 Sep-96 $24.35 $23.30 $0.34 $1.05 489 Oct-96 $24.35 $24.55 $0.32 ($0.20) 492 Nov-96 $24.35 $23.17 $0.38 $1.18 471 Dec-96 $24.35 $0.00 $0.00 Jan-97 $24.35 $0.00 $0.00 Feb-97 $24.35 $0.00 $0.00 Mar-97 $24.35 $0.00 $0.00 Apr-97 $24.35 $0.00 $0.00 Totals $288.60 $285.77 $2.58 ($118.92) 6222~ Rolling Fields Electrical Expenditures 90.00 80.00 70.00 60.00 50.00 . Budget 40.00 II Actual U [J Credit \,"" 30.00 20.00 10.00 0.00 <0 ~ <0 <0 <0 <0 <0 <0 S; S; r-- S; 0> ~ 0> 0> 0> 0> 0> 0> ~ C: en 6. 13 ~ g C: .b ~ ~ ::l "5 ::l Q) tU Q) tU 0- ::E -, -, ~ (f) 0 z Cl -, u. ::E ~ --- JEFFERSONVillE, IN Artic Springs Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH c n'l " ,I il( liIo",~; [,, i~ ~;) Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 Jan-97 Peb-97 Mar-97 Apr-97 Totals $14.00 $14.00 $14.00 $14.64 $14.64 $14.64 $14.64 $14.64 $14.64 $14.64 $14.64 $159.12 $10.64 $10.58 $11.91 $11.38 $17.91 $12.49 $0.40 $0.31 $0.26 $0.34 $0.32 $0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $2.01 $3.36 $3.42 $2.09 $3.26 ($3.27) $2.15 $0.00 $0.00 $0.00 $0.00 $0.00 $11.01 $74.91 Artic Springs Electrical Expenditures 20.00 18.00 16.00 14.00 12.00 10.00 8.00 6.00 4.00 2.00 0.00 <0 0) C: :::l ~ <0 c:p "5 ~ <0 0) 6- Q) CJ) <0 0) > o Z <0 0) o Q) Cl ...... 0) .b Q) u. ...... c:p 5. <( ...... 0) C: III ~ ...... 0) ~ :2 <0 0) 61 :::l <( co 0) t> o 238 231 247 249 359 254 1578l . Budget . Actual Cl Credit ====-'11_- JEFFERSONVILLE. IN Colonial Park Electrical Expenditures [ MonthlY ear Budget Actual Credit Budget Diff. KWH r-- t f \'u Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 Jan-97 Feb-97 Mar-97 Apr-97 Totals $14.00 $14.00 $14.00 $14.64 $14.64 $14.64 $14.64 $14.64 $14.64 $14.64 $14.64 $159.12 $13.00 $13.60 $13.50 $21.56 $13.97 $12.39 $0.40 $0.31 $0.26 $0.34 $0.32 $0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $2.01 $1.00 $0.40 $0.50 ($6.92) $0.67 $2.25 $0.00 $0.00 $0.00 $0.00 $0.00 ($2. ] 0) ~ $88.02 Colonial Park Electrical Expenditures 25.00 20.00 15.00 U,: ......i\ ;J 10.00 5.00 0.00 \0 0) C: ::l ..., \0 0) bl ::l <( \0 0) 6. Q) CJ) \0 0) t o \0 0) ~ o ,.... 0) ~ ..., ,.... 0) ~ ~ ,.... 0) ~ <( ,.... 0) .h Q) LL \0 0) ~ z \0 ~ '3 ..., 781 291 279 280 454 280 23651 . Budget . Actual [J Credit ~ JEFFERSONVILLE, IN Mill Creek Electrical Expenditures c [":1 tJ :JIiiJ~~ JEFFERSONVILLE IN Louise Street Electrical Expenditures MonthlYear Budget Actual Credit Budget Difr. KWH May-96 $14.70 $10.23 $0.57 $4.47 232 Jun-96 $14.70 $12.65 $0.40 $2.05 283 Ju1-96 $14.70 $13.00 $0.31 $1.70 286 Aug-96 $14.70 $15.62 $0.26 ($0.92) 324 Sep-96 $15.38 $17.09 $0.34 ($1.71) 372 Oct-96 $15.38 $17.07 $0.32 ($1.69) 342 Nov-96 $15.38 $17.47 $0.38 ($2.09) 355 Dec-96 $15.38 $0.00 $0.00 Jan-97 $15.38 $0.00 $0.00 Feb-97 $15.38 $0.00 $0.00 Mar-97 $15.38 $0.00 $0.00 Apr-97 $15.38 $0.00 $0.00 Totals $181.84 $103.13 $2.58 $1.81 21941 Louise Street Electrical Expenditures 18.00 16.00 14.00 12.00 10.00 . Budget 8.00 Ii Actual 6.00 [J Credit 4.00 2.00 0.00 co co co co co co co co !;; I'- I'- !;; Ol Ol ~ Ol Ol Ol Ol Ol Ol Ol ~ C 0, a. 8 ~ 0 ~ .h ~ ~ ~ '3 ::l Q) Q) Q) ell ~ ~ ..., ..., <( en z 0 ..., u. ~ ~ JEFFERSONVILLE, IN Cedarview Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 Jan-97 Feb-97 Mar-97 Apr-97 Totals $8.00 $8.00 $8.00 $8.00 $8.37 $8.37 $8.37 $8.37 $8.37 $8.37 $8.37 $8.37 $98.96 $3.00 $3.67 $2.52 $2.80 $2.00 $6.38 $4.53 $0.57 $0.40 $0.31 $0.26 $0.34 $0.32 $0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $2.58 $5.00 $4.33 $5.48 $5.20 $6.37 $1.99 $3.84 $0.00 $0.00 $0.00 $0.00 $0.00 $32.21 $24.90 Cedarview Electrical Expenditures 9.00 8.00 7.00 6.00 5.00 4.00 D'I :1 . .W 3.00 2.00 1.00 0.00 I"- 0) .h (Jl IL <0 0) ~ ~ <0 0) C: =' ..., <0 cp '3 ..., <0 (l) c, =' <( <0 0) 6. (Jl (f) <0 0) <3 o <0 0) ~ o I"- 0) C: ltl ..., <0 0) ~ z U'i ill "" I"- 0) ffi ~ 68 82 55 58 67 128 92 550l . Budget . Actual [J Credit I"- 0) 5- <( __ JEFFERSONVILLE, IN Crums II Electrical Expenditures MonthlYear Budget Actual Credit Budget Diff. KWH May-96 $11.28 $15.39 $0.57 ($4.11 ) 349 Jun-96 $11.28 $12.83 $0.40 ($1.55) 287 Jul-96 $11.28 $9.57 $0.31 $1.71 209 Aug-96 $11.28 $11.42 $0.26 ($0.14) 237 Sep-96 $11.80 $13.07 $0.34 ($1.27) 283 Oct-96 $11.80 $11.92 $0.32 ($0.12) 239 Nov-96 $11.80 $14.96 $0.38 ($3.16) 304 Dec-96 $11.80 $0.00 $0.00 Jan-97 $11.80 $0.00 $0.00 Feb-97 $11.80 $0.00 $0.00 Mar-97 $11.80 $0.00 $0.00 Apr-97 $11.80 $0.00 $0.00 Totals $139.52 $89.16 $2.58 ($8.64) 1908l CREDIT - ACTUAL = $86.58 [] Crums II Electrical Expenditures :l j 16.00 14.00 12.00 10.00 . Budget 8.00 . Actual 6.00 [J Credit 4.00 U 2.00 ,; II 0.00 ;j" <0 <0 <0 <0 <0 <0 <0 <0 r-- r-- r-- !;; en en cp en en en en en en en en ~ C "S C, C. .,!. ~ g ~ .b ~ ~ :::I :::I Q) 0 Q) <Il C. ~ .., .., c:( CI) 0 z Cl .., u.. ~ c:( lJ :; .~:J 0' "j .. ... ~ i l'!i ~'fUIi1" JEFFERSONVILLE, IN 1st Street Bldg. Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 $1.00 $1.46 $0.57 ($0.46) Jun-96 $1.00 $0.19 $0.40 $0.81 Jul-96 $1.00 $0.00 $0.00 $1.00 Aug-96 $1.00 $0.27 $0.26 $0.73 Sep-96 $1.05 $0.05 $0.34 $1.00 Oct-96 $1.05 $0.00 $0.00 $1.05 Nov-96 $1.05 $0.00 $0.00 $1.05 Dec-96 $1.05 $0.00 $1.05 Jan-97 $1.05 $0.00 $1.05 Peb-97 $1.05 $0.00 $1.05 Mar-97 $1.05 $0.00 $1.05 Apr-97 $1.05 $0.00 $1.05 Totals $12.40 $1.97 $1.57 10.43~ 01 1 st Street Bldg. Electrical Expenditures 1.60 1.40 1.20 1.00 . Budget 0.80 . Actual 0.60 [] Credit 0.40 0.20 0.00 <0 <0 <0 <0 <0 <0 <0 <0 I'- b; I'- I'- 9 en 9 en en en en en en en en rr ~ C: :; C, 6. ..!.. > 6 C: .0 ~ ~ .1..... :J :J Q) 0 0 Q) ctl Q) <<l a. ! ::!: .., .., <( CJ) 0 z 0 .., u.. ::!: <( - ---=Mf;; JEFFERSONVILLE, IN Landsburg Cove Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 $14.00 $56.52 $0.00 ($42.52) 1686 Jun-96 $14.00 $35.21 $0.00 ($21.21) 1650 Jul-96 $14.00 $24.42 $0.00 ($10.42) 1392 Aug-96 $14.00 $20.11 $0.00 ($6.11) 1422 Sep-96 $31.20 $18.73 $0.00 $12.47 1422 Oct-96 $31.88 $27.21 $0.00 $4.67 1739 Nov-96 $31.88 $36.23 $0.00 ($4.35) 1626 Dec-96 $31.88 $0.00 $0.00 Jan-97 $31.88 $0.00 $0.00 Feb-97 $31.88 $0.00 $0.00 Mar-97 $31.88 $0.00 $0.00 Apr-97 $31.88 $0.00 $0.00 Totals $310.36 $218.43 $0.00 ($67.4 7) 10937' ACTUAL - CREDIT = $218.43 September 1996 - 31.20 Budget for Landsburg Cove. Calculated bills since the lift station went on line and divided by number of months. Landsburg Cove Electrical Expenditures 60.00 10.00 . Budget II Actual Cl Credit 50.00 40.00 30.00 20.00 0.00 <0 ~ iO' ::iE <0 0) c!: ::l ..., <0 ~ "5 ..., <0 0) C:n ::l < <0 0) 6- (]) en <0 0) t5 o <0 0) ~ z <0 0) ~ Cl I"- 0) c!: al ..., I"- 0) .0 (]) u. b; ffi ::iE I"- 0) .:. a. < _me JEFFERSONVilLE, IN Riverport I Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diee. KWH May-96 $89.00 $144.73 $0.00 ($55.73) 2,240 Jun-96 $89.00 $141.56 $0.00 ($52.56) 2,160 Jul-96 $89.00 $221.88 $0.00 ($132.88) 3,360 Aug-96 $89.00 $247.33 $0.00 ($158.33) 3760 Sep-96 $93.09 $225.86 $0.00 ($132.77) 3120 Oct-96 $93.09 $161.17 $0.00 ($68.08) 1840 Nov-96 $93.09 $244.99 $0.00 ($151.90) 3120 Dec-96 $93.09 $0.00 $0.00 Jan-97 $93.09 $0.00 $0.00 Feb-97 $93.09 $0.00 $0.00 Mar-97 $93.09 $0.00 $0.00 Apr-97 $93.09 $0.00 $0.00 Totals $1,100.72 $1,387.52 $0.00 (S752.25) 19,6001 ACTUAL - CREDIT = $1,387.52 Riverport I Electrical Expenditures 250.00 200.00 150.00 . Budget . Actual 100.00 C1Credit 50.00 Lo# 0.00 <0 <0 <0 <0 <0 <0 <0 <0 "- "- "- "- Ol Ol <:1> Ol Ol Ol Ol Ol Ol Ol (l) (l) .:-"1 ~ C: '5 0, 0.. .,!.. ~ ~ C: .0 .!.. .!.. ::l ::l Cl) 0 <<l If <<l 0. :E "") "") <( C/) 0 z 0 "") :E <( .t. JEFFERSONVILLE, IN Riverport II Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 $37.00 $54.97 $0.00 ($17.97) 577 Jun-96 $37.00 $0.00 $0.00 $37.00 0 Jul-96 $37.00 $91.22 $0.00 ($54.22) 894 Aug-96 $37.00 $39.80 $0.00 ($2.80) 369 Sep-96 $38.70 $46.12 $0.00 ($7.42) 428 Oct-96 $38.70 $44.21 $0.00 ($5.51) 346 Nov-96 $38.70 $55.25 $0.00 ($16.55) 479 Dec-96 $38.70 $0.00 $0.00 1;.,,,, Jan-97 $38.70 $0.00 $0.00 Feb-97 $38.70 $0.00 $0.00 Mar-97 $38.70 $0.00 $0.00 Apr-97 $38.70 $0.00 $0.00 Totals $457.60 $331.57 $0.00 ($67.47) 30931 ACTUAL - CREDIT = $331.57 Riverport II Electrical Expenditures 100.00 90.00 80.00 70.00 60.00 . Budget 50.00 . Actual 40.00 [J Credit 30.00 20.00 10.00 L 0.00 <0 <0 <0 <0 <0 <0 <0 <0 l"- I"- l"- I"- ~ Ol cp Ol Ol cp Ol Ol Ol Ol Ol Ol iU' C: '3 C, 6. '0 ~ g C: .6 .:.. .:.. ::l ::l <Il as <Il as 0- ::::iE .. .. <( CI) 0 Z Q .. u.. ::::iE <( -l'BD[~ JEFFERSONVILLE, IN r I Rivershore Electrical Expenditures MonthlYear Budget Actual Credit Budget Diff. KWH May-96 $15.71 $13.77 $0.00 $1.94 62 Jun-96 $15.71 $14.28 $0.00 $1.43 68 Jul-96 $15.71 $13.26 $0.00 $2.45 56 Aug-96 $15.71 $13.88 $0.00 $1.83 63 Sep-96 $16.43 $15.61 $0.00 $0.82 70 Oct-96 $16.43 $16.78 $0.00 ($0.35) Nov-96 $16.43 $14.55 $0.00 $1.88 45 Dec-96 $16.43 $0.00 $0.00 Jan-97 $16.43 $0.00 $0.00 Feb-97 $16.43 $0.00 $0.00 Mar-97 $16.43 $0.00 $0.00 Apr-97 $16.43 $0.00 $0.00 Totals $194.28 $102.13 $0.00 $10.00 3641 Rivershore Electrical Expenditures 18.00 16.00 14.00 12.00 10.00 . Budget 8.00 . Actual [J Credit 6.00 4.00 2.00 0.00 <0 <0 <0 <0 <0 <0 <0 <0 b; ..... b; b; ~ 0) ~ 0) 0) 0) 0) 0) 0) ia' C: '3 0, 6.. .,!. ~ b C: .b .:. .:. ::l ::l <Il 0 <Il III <Il III 0. ::E ..., ..., <( (J) 0 z 0 ..., IL ::E <( ~1IfI JEFFERSONVILLE. IN r.'; :." :1 Utica Electrical Expenditures MonthlY ear Budget Actual Credit Budget Dirr. KWH May-97 $73.70 $118.99 $0.00 ($45.29) 1,506 Jun-96 $73.70 $100.33 $0.00 ($26.63) 1218 Jul-96 $73.70 $70.61 $0.00 $3.09 786 Aug-96 $73.70 $66.47 $0.00 $7.23 730 Sep-96 $77.09 $85.09 $0.00 ($8.00) 933 Oct-96 $77 .09 $76.52 $0.00 $0.57 735 Nov-96 $77 .09 $107.33 $0.00 ($30.24) 1118 Dec-96 $77 .09 $0.00 $0.00 Jan-97 $77.09 $0.00 $0.00 Feb-97 $77 .09 $0.00 $0.00 Mar-97 $77 .09 $0.00 $0.00 Apr-97 $77 .09 $0.00 $0.00 Totals $911.52 $625.34 $0.00 ($99.27) 7,0261 ACTUAL - CREDIT = $625.34 Utica Electrical Expenditures 120.00 100.00 80.00 . Budget 60.00 . Actual 40.00 [] Credit r- 20.00 0.00 ~ co co co co co co co l"- S; l"- I"- 0> cr 0> 0> 0> 0> 0> 0> 0> 0> ~ C '5 0, 6. .,!. ~ ~ C .0 ~ ~ ::l ::l CD () CIS CD CIS 0- ~ ...., ...., <( C/) 0 z 0 ...., I.L. ~ <( 'M( JEFFERSONVILLE, IN Utica II Electrical Expenditures I~~~ JEFFERSONVILLE, IN Sunset Mobile Home Electrical Expenditures MonthlYear Budget Actual Credit Budget Diff. KWH May-96 $14.00 $39.97 $0.00 ($25.97) 373 Jun-96 $14.00 $48.01 $0.00 ($34.01 ) 482 Jul-96 $14.00 $41.86 $0.00 ($27.86) 397 Aug-96 $14.00 $19.80 $0.00 ($5.80) 233 Sep-96 $14.64 $26.57 $0.00 ($11.93) 208 Oct-96 $14.64 $33.82 $0.00 ($19.18) 242 Nov-96 $14.64 $33.71 $0.00 ($19.07) 234 Dec-96 $14.64 $0.00 $0.00 Jan-97 $14.64 $0.00 $0.00 Feb-97 $14.64 $0.00 $0.00 Mar-97 $14.64 $0.00 $0.00 Apr-97 $14.64 $0.00 $0.00 Totals $173.12 $243.74 $0.00 ($143.82) 21691 ACTUAL - CREDIT = $243.74 Sunset Mobile Home Electrical Expenditures 50.00 45.00 40.00 35.00 30.00 . Budget 25.00 . Actual 20.00 [] Credit 15.00 10.00 5.00 0.00 co co co co co co co co l"- I"- l"- I"- C>> C>> q> C>> C>> C>> C>> C>> C>> C>> C>> C>> ~ C: C, 6- t ~ b C: l:J ~ ~ ::l '5 ::l Q) Q) <ll Q) <ll 0. ::E ""') ""') c:( (/) 0 z 0 ""') LL ::E c:( .~ JEFFERSONVILLE, IN Crums I Electrical Expenditures MonthlY ear Budget Actual Credit Budget Diff. KWH May-96 $200.00 $347.12 $0.00 ($147.12) 5,800 Jun-96 $200.00 $236.35 $0.00 ($36.35) 3,560 Jul-96 $200.00 $193.46 $0.00 $6.54 2,680 ,..... Aug-96 $200.00 $165.74 $0.00 $34.26 2,320 f . Sep-96 $209.20 $272.12 $0.00 ($62.92) 4,000 f t." Oct-96 $209.20 $242.77 $0.00 ($33.57) 3,080 Nov-96 $209.20 $361.06 $0.00 ($151.86) 5,200 r Dec-96 $209.20 $0.00 $0.00 r L. Jan-97 $209.20 $0.00 $0.00 Feb-97 $209.20 $0.00 $0.00 Mar-97 $209.20 $0.00 $0.00 Apr-97 $209.20 $0.00 $0.00 Totals $2,473.60 $1,818.62 $0.00 ($39] .02) 26,6401 ACTUAL - CREDIT = $1,818.62 Crums I Electrical Expenditures 400.00 350.00 300.00 250.00 . Budget 200.00 . Actual 150.00 [J Credit 100.00 50.00 0.00 to to to to to to to to .... .... .... .... Cl Cl ~ Cl Cl Cl Cl Cl Cl Cl Cl Cl ~ C :; b:, 6. J,. ~ ~ C .b ~ ~ ::l ::l OJ 0 I'll {f, I'll 0. ::2 .., .., 0:( en 0 z 0 .., ::2 0:( [ -~ JEFFERSONVILLE, IN Crums III Electrical Expenditures ~- JEFFERSONVillE, IN I, Tenth Street Electrical Expenditures MonthlY ear Budget Budget Diff. KWH KVA Actual Credit May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 Jan-97 Peb-97 Mar-97 Apr-97 Totals $2,734.95 $1,949.36 $1,586.12 $1,660.94 $1,855.27 $1,744.85 $1,995.93 $19.33 $14.17 $11.38 $11.94 $12.78 $11.31 $13.01 $0.00 $0.00 $0.00 $0.00 $0.00 $74.59 $13,452.83 54,000 38,100 30,600 32,100 33,900 30,000 34,500 ($1,006.95) ($221.36) $141.88 $67.06 $24.79 $135.21 ($115.87) $0.00 $0.00 $0.00 $0.00 $0.00 ($975.24 ) $1,728.00 $1,728.00 $1,728.00 $1,728.00 $1,880.06 $1,880.06 $1,880.06 $1,880.06 $1,880.06 $1,880.06 $1,880.06 $1,880.06 $21,952.48 $13,527.42 CREDIT - ACTUAL = 253,200 2,004 Tenth Street Electrical Expenditures 3000.00 2500.00 2000.00 1500.00 1000.00 500.00 0.00 \0 c:p 1a' ~ \0 c:p '3 ., \0 OJ fj o \0 OJ ~ r-.. OJ ~ ~ r-.. OJ .!.. 0. <( r-.. OJ C: ell ., r-.. OJ .h If \0 OJ Cl ::J <( \0 OJ 6. Q) (/) \0 c:p ~ z \0 c:p c:: ::J ., 292 292 286 302 292 244 296 . Budget Ii Actual [J Credit J-.- JEFFERSONVILLE, IN D' , i1 .:;: Golfview Electrical Expenditures 35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 co O'l ~ ::!!: co ~ "5 ..., co O'l t> o co O'l g o !;; .0 Q) u. !;; l5. c:( ..... O'l l\; ::!!: co O'l 0, ::l c:( co O'l 6.. Q) en co O'l ~ Z ..... O'l C: a5 ..., co O'l C: ::l ..., . Budget . Actual []Credit -~ JEFFERSONVILLE, IN r: LJ MonthlY ear Spring Street Electrical Expenditures Budget Actual Credit Budget Dirr. KWH KVA $802.59 $606.72 $418.92 $363.06 $466.80 $602.58 $492.05 $5.44 $3.95 $2.68 $0.00 $3.04 $3.68 $2.90 $0.00 $0.00 $0.00 $0.00 $0.00 $21.69 $2,928.44 May-96 Jun-96 Jul-96 Aug-96 Sep-96 Oct-96 Nov-96 Dec-96 Jan-97 Feb-97 Mar-97 Apr-97 TOTALS $275.14 $275.14 $275.14 $275.14 $301.83 $301.83 $301.83 $301.83 $301.83 $301.83 $301.83 $301.83 $3,515.20 $2,950.13 ACTUAL - CREDIT = ($527.45) ($331.58) ($143.78) ($87.92) ($] 64.97) ($300.75) ($190.22) $0.00 $0.00 $0.00 $0.00 $0.00 ($1,746.67) Spring Street Electrical Expenditures 15,200 11,040 7,200 7,400 8,160 9,760 7,680 51,240 (0 (0 (0 (0 (0 (0 (0 (0 f'o- f'o- f'o- f'o- Ol Ol ~ Ol Ol Ol Ol Ol Ol Ol Ol Ol U ~ C '3 en 6.. t ~ ~ C: .b .!.. .!.. ::l ::l CIl (\l CIl (\l 0- il ::E ..., ..., <( en 0 z Cl ..., LL ::E <( 'I 'if;! n tel.? 900.00 800.00 700.00 600.00 500.00 400.00 300.00 200.00 100.00 0.00 . Budget . Actual [J Credit -~~- JEFFERSONVILLE, IN 69 64 53 54 67 77 34 4171 Eastbrook Electrical Expenditures ~MIt~-- JEFFERSONVILLE, IN Silver Creek Electrical Expenditures "-~ JEFFERSONVillE, IN r ! b"",1 C! I ,,; R u o r\ Wastewater Treatment Plant ELECTRICAL CAP $177,189 W ASTEW A TER FACILITY $133,000 MonthlY ear Budget Actual Credit Budget Diff. KWH KVA May-96 $11,100.00 $11,966.87 $74.35 ($866.87) 329,000 704 Jun-96 $11,100.00 $13,003.96 $84.87 ($1,903.96) 369,000 744 JuI-96 $11,100.00 $11,828.53 $71.76 ($728.53) 312,000 707 Aug-96 $11,100.00 $12,605.13 $80.04 ($] ,505.13) 348,000 727 Sep-96 $11,943.00 $11,862.45 $50.34 $80.55 291,000 663 Oct-96 $11,943.00 $12,394.85 $50.86 ($451.85) 294,000 656 Nov-96 $11,943.00 $12,781.31 $60.38 ($838.31 ) 349,000 608 Dec-96 $11,943.00 $0.00 $0.00 Jan-97 $11,943.00 $0.00 $0.00 Peb-97 $11,943.00 $0.00 $0.00 Mar-97 $11,943.00 $0.00 $0.00 Apr-97 $11,943.00 $0.00 $0.00 ITOT ALS $139,944.00 $86,443.10 $472.60 $53,500.90 2,292,000 4,8081 ACTUAL - CREDIT = $85,970.50 Wastewater Treatment Plant Electrical Expenditures 14000.00 . Budget . Actual IJCredit 12000.00 10000.00 8000.00 6000.00 4000.00 2000.00 0.00 co Cll iO' ::2 co 0> C, :;:, <( co 0) 13 o co 0> ~ Cl S; .0 Cll u. S; 5- <( co 0) C: :;:, ""J co Cll "3 ""J co 0) 6. Cll (J) co 0) ~ z r-- 0) C: ell ""J r-- 0) :ij ::2 ~ JEFFERSONVillE, IN Cherry Creek Electrical Expenditures U MonthlY ear Budget Actual Credit Budget Diff. KWH -. I] May-96 $14.00 $0.00 }:I Jun-96 $14.00 $0.00 w Ju1-96 $14.00 $0.00 Aug-96 $14.00 $0.00 0 Sep-96 $48.00 $23.17 $0.00 $24.83 253 t'! Oct-96 $50.21 $61 .35 $0.00 ($11.14) 593 Nov-96 $50.21 $59.50 $0.00 ($9.29) 530 Dec-96 $50.21 $0.00 $0.00 Jan-97 $50.21 $0.00 $0.00 Feb-97 $50.21 $0.00 $0.00 Mar-97 $50.21 $0.00 $0.00 Apr-97 $50.21 $0.00 $0.00 Totals $455.47 $144.02 $0.00 $4.40 1376~ Q ACTUAL - CREDIT = $144.02 September 1996 - 48.00 Budget for Cherry Creek. Calculated bills since the lift station went on line and divided by number of months. Cherry Creek Electrical Expenditures 10.00 . Budget . Actual o Credit 70.00 60.00 50.00 40.00 30.00 20.00 0.00 to 0> ~ :2 to 0> C ::l ..., to cr "'5 ..., to 0> C, ::l < to 0> 6.. Q) (/') to 0> <3 o to 0> ~ Z to cr o Q) o '" 0> C <tl ..., '" 0> .0. Q) L1. '" 0> ~ :E '" 0> l5. < ~ ~' q J -[g JEFFERSONVILLE, IN