Rate increase 2014 worksheet
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVW
1
HLP "Averages'
Please EDIT only the pink shaded numbers
2
HLP 2014 Rate Inc rease
Pls return C5 to 12.54, F6 to 21.64, K4 to .097 and L to .079 for others to see the effects of changes.
Alternate Simple Calculator
3
Residential
Commercial
Adjustable inputs
straight rate
Reduce @ 10K
4
currentproposedincreasecurrentproposedincreaseExamplesincrease0.09700.0790
change from
5
Service1212.544.5%0smalllarge
Proposed 2014
6
Kwhrservice$21.64$3,532.50250kw fee +
7
250$30.81$32.194.5%$51.32$24.25-24.7%
8
500$49.63$51.844.5%$74.60$80.998.6%$48.50-6.4%
9
750$68.44$71.494.5%$100.73$110.679.9%$72.751.8%
10
1,000$87.25$91.144.5%$126.85$140.3410.6%$97.006.4%
11
2,000$193.75$202.484.5%$206.75$220.846.8%
250kW Demand
$194.00-4.2%
12
3,000$394.75$412.624.5%$286.65$301.345.1%
370kW Demand
$291.00 -3.4%
13
3,600$652.45$682.044.5%$334.59$349.644.5%$349.20-0.1%
14
5,000$1,042.45$1,089.784.5%$446.45$462.343.6%$485.004.9%
15
10,000$1,904.95$1,991.524.5%$845.95$864.842.2%$580.00$970.00$880.001.8%
16
15,000$1,245.45$1,267.341.8%$765.00$1,455.00$1,275.000.6%
17
20,000$1,644.95$1,669.841.5%$950.00$6,178.10275.6%$1,940.00$1,670.000.0%
18
30,000$2,443.95$2,474.841.3%$1,320.00$4,852.5098.6%$2,910.00$2,460.00-0.6%
19
40,000$3,242.95$3,279.841.1%$1,690.00$5,222.5061.0%$3,880.00$3,250.00-0.9%
20
50,000$4,041.95$4,084.841.1%$2,060.00$5,592.5038.4%$4,850.00$4,040.00-1.1%
21
60,000$4,840.95$4,889.841.0%$2,430.00$5,962.5023.2%$5,820.00$4,830.00-1.2%
22
70,000$5,639.95$5,694.841.0%$2,800.00$6,332.5012.3%$6,790.00$5,620.00-1.3%
23
100,000$8,036.95$8,109.84
24
116,300$9,339.32$9,421.990.9%$4,513.10$9,741.204.3%$11,281.10$9,277.70-1.5%
25
180,000$14,428.95$14,549.840.8%$6,870.00$10,402.50-27.9%$17,460.00$14,310.00-1.6%
26
200,000$16,026.95$16,159.840.8%$7,610.00$12,838.10-19.9%$19,400.00$15,890.00-1.7%
27
250,000$20,021.95$20,184.840.8%$9,460.00$14,688.10-26.6%$24,250.00$19,840.00-1.7%
28
29
30
Large Commercial = peak of 250kw
31
ResidentialCommercial
% commercial
Assume 250 for 1 hour and 150 for 23 =
32
Usage kWhr81,533,45867,156,354148,689,81245.2%Line 25145500kwhr per mo
33
revenue$7,751,108$5,812,259$13,563,36742.9%Line 4
34
rate$0.095$0.0879.8%Res Higher
250 x 24 hr x 30 days=
35
2014$8,204,028$6,275,731$14,479,75943.3%Line 61180000kwhr per mo
36
$0.101$0.0937.7%Res Highersmalllarge
yearly savings
37
increase6%8%$14,550$9,741$57,704
38
cost?$8,219,563$6,287,615$14,507,17843.3%
BENEFITS large commercial, amount dependent on “peak demand” amount.
39
40
Conclusions or Questions:
41
1 Are there only the 11 listed entities who would be “large,” if so, what is their normal monthly usage?
42
1a Why were they listed alphabetically?
43
2 . . . Service fees affect small residential by higher percentage; same for samll commercial.
44
3 . . . rates do not cause lowering of peak demand - Isn't that the purposes of the smart meters?
45
4 Proposed rate schedule gives higher rate increase for small commercial (under 3000 kwh)
46
5 How is the 250 kw peak demand determine? One time, monthly average, ONCE in a year?
47
6 If once a YEAR, it would appear that turning everything ON fo an hou once a year could save a lot of money
48
7 As 3 of the 11 are “large users” are schools, it appears a different analysis (than $) is necessary to adjust load factors
49
8 If the whole “large commercial” is to modify use, lowering the rate won't do it.
50
8a If the proposed rate is to increase revenue, why decrease the higher users' costs?
51
9 How many users are there in each category, what are the range of their usages?
Loading...
 
 
 
Sheet1
Sheet2
Sheet3