20200930Michaelson Direct.pdf

Michae! C. Creamer (lSB No. 4030)
Preston N. Carter (lSB No. 8462)
Givens Pursley LLP
601 W. Bannock St.
Boise, lD 83702
Telephone: [phone]
Facsimile: (208) 388-1 300
[e-mail]
[e-mail]
il,;#f ltlES
ti:?i:iif, 3S Pl{ h; 57
_-!rrr jgt, :' . ,1.:: : i l_..-.. r.r
- l ',-; .; ";'tl,,.l,rli,itS$F+lC
Attorneysfor SUEZWater ldaho lnc.
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF THE APPLICATION
OF SUEZ WATER IDAHO INC. FOR
AUTHORITY TO INCREASE ITS RATES
AND CHARGES FOR WATER SERVICE
IN THE STATE OF IDAHO
Case No. SUZ-W-20-02
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
DIRECT TESTIMONY OF TIMOTHY MICHAELSON
SEPTEMBER 2O2O
1
2
3
4
5
6
7
I
I
o.Please state your name and business address.
My name is Timothy Michaelson, and my business address is 461 From Rd,
Suite 400, Paramus, New Jersey 07652.
By whom are you employed and in what capacity?
I am employed by SUEZWater Management & Services ("SWM&S"), which
ljoined in November of 1994. During my employment, I have worked in the
Corporate Accounting and Corporate Planning Departments as an
Accountant, Planning Analyst, Planning Manager and Planning Director. I
also worked as the Director of Finance for SUEZ Water's New Jersey
Division and as the Director of Finance for SUEZ Water's Regulated
Segment. ln May of 2009, I joined the Regulatory Business Department
where I currently work as Director.
Please summarize your educational background and qualifications.
I graduated from St. Thomas Aquinas College with a Bachelor of Science
degree in Accounting in 1990 and lona College with an MBA in Finance in
2000. I am currently the Treasurer of the New York Chapter of the National
Association of Water Companies.
Before what regulatory agencies have you previously presented
testimony?
I have testified in several cases before the New York State Public Service
Commission, the Connecticut Public Utilities Regulatory Authority, and the
State of Rhode lsland and Providence Plantations Public Utilities
Commission.
A
o.
A.
10
11
12
13 0.
14 A.
15
16
17
18 a.
19
20A
21
22
23
Michaelson, Di
SUEZ Water ldaho lnc.
1
1Q.
24.
3
40.
5A.
6
7
8
eo.
10
11 A.
12
13
14 0.
15 A.
16
17
18
19
20
21
22
23
What is the purpose of your testimony in this proceeding?
My testimony supports the proof of revenue under present and proposed
rates and the development of pro forma revenues.
What Exhibits are you sponsoring?
I am sponsoring Exhibit No. 5, which presents the proof of revenue including
the application of present and proposed rates to consumption analysis for
the twelve months ending March 31, 2021, and pro forma revenue under
present and proposed rates, including adjustments to revenue.
Have you prepared proofof revenue schedules under present and
proposed rates?
Yes. Schedules 1 through 9 in Exhibit 5 provide the proof of revenues from
the application of present and proposed rates to the customer consumption
analysis.
Please describe Schedule 1.
Schedule 1 summarizes the application of proposed rates to the
consumption analysis for the twelve months ended March 31,2021 and the
pro forma revenues under proposed rates for that same time period.
Column 2 presents the pro forma revenues at present rates from column 9
of Schedule 2. Column 3 presents the pro forma revenues at proposed
rates by applying the proposed rates to the detailed consumption analysis
by customer class provided in Schedule 3. Columns 4, 5 and 6 show the
impact at proposed rates of the adjustments presented in Schedules 44, 48
and 4C. Column 7 calculates the pro forma revenue at proposed rates,
Michaelson, Di
SUEZ Water ldaho Inc.
2
1
2
3
4
5
6
7
8
I
o.
A.
column 8 shows the proposed increase by customer class and column 9
provides the percentage increases by customer class.
Please describe Schedule 2.
Schedule 2 summarizes the application of present rates to the consumption
analysis and the pro forma revenues under present rates for the twelve
months ending March 31,2021. Column 2 presents the revenues per books
by customer class. Column 3 removes surcharge revenue, the balance of
unbilled revenue accrued at the end of the Test Year and other
miscellaneous adjustments. Column 5 shows the revenues from the
application of present rates to the detailed consumption analysis for the
twelve months ended June 30, 2020, from Schedule 3. Columns 6, 7 and
8 show the impact at current rates of the adjustments presented in
Schedules 4A, 49 and 4C. Finally, Column 9 presents pro forma revenue
at current rates.
Please describe Schedule 3.
Schedule 3 provides the application of present and proposed rates to the
detailed consumption analysis and billing determinants by customer class
as ofthe end ofthe Test Year, June 30, 2020.
Please describe the Schedules 4 through 4C.
Schedule 4 summarizes the impact on billing determinants associated with
the three revenue adjustments shown on Schedules 4A, 48 and 4C.
Adjustment R1, detailed on Schedule 4A, adjusts revenues at
present and proposed rates by annualizing for the gain or loss of customers
10
11
12
13
14
15 0.
16 A.
17
18
19 0.
20 A.
21
22
23
Michaelson, Di
SUEZ Water ldaho lnc.
3
1
2
3
4
5
6
7
8
I
10
11
12
13
14
15
16
17
18
19
20
21
22
23
during the Test Year (12 months ended June 30, 2020). Adjustment R2,
shown on Schedule 48, adjusts revenues at current and proposed rates for
the projected increase in the average number of customers through March
31, 2021. Adjustment R3, shown on Schedule 4C, adjusts revenues at
present and proposed rates due to the projected decline in customer usage
for residential and commercial customers.
O. How did you determine the projected decline in customer usage for
residential customers shown in Adiustment R3?
A. For the residentia! customer usage adjustment, I performed a 30-year
regression analysis of per-capita usage utilizing actual residential usage,
calendar year and Palmer Z index as inputs. The Palmer Z index is a
measure of shortterm drought on a monthly scale. For the calculation of
the customer usage projection, the Palmer Z index amounts were taken
from NOAA National Centers for Environmental information, Climate at a
glance: Divisional Time Series, published September 2020 from
https://www.ncdc.noaa.gov/cag/. A "Predicted residential" usage amount
was calculated (101.94 thousand gallons per customer) and compared to
the actual (107.11 thousand gallons per customer) usage. The difference,
(5.17 thousand gallons) was converted to CCFs to arrive at the (6.91) CCF
adjustment per residential customer. Exhibit 5 Schedule 4D provides the
calculation. I have attempted to utilize the methodology which the Company
believes was used by Staff in the Company's last rate case filing, which
utilizes a long-term period, to arrive at a reasonable volume adjustment for
Michaelson, Di
SUEZ Water ldaho lnc.
4
1
2
3
4
5
6
7
8
I
o.
A.
customers.
How did you determine the projected decline in customer usage for
commercial customers shown in Adjustment R3?
For the commercial customer usage adjustment, I performed a 2S-year
regression analysis of per-customer usage utilizing actual commercial
usage, calendar year and Palmer Z index as inputs. A "Predicted
commercial" usage amount was calculated (486.55 thousand gallons per
customer) and compared to the actual (500.77 thousand gallons per
customer) usage. The difference, (14.22 thousand gallons) was converted
to CCFs to arrive at the (19.01) CCF adjustment per commercial customer.
Exhibit 5 Schedule 4E provides the calculation.
Please describe Schedules 5 and 6.
Schedule 5 provides the average actual annual usage by residential
customer in gallons as well as the predicted average annual usage.
Schedule 6 plots the actual annual usage, predicted annual usage and
includes a linear trend line of actual usge demonstrating the decline in
average consumption. The table at the bottom of the graph compares
actual total gallons and CCFs at the Test Year compared to the Test Period
ending March 31,2021.
Please describe Schedules 7 and 8.
Schedule 7 provides the average actual annual usage by commercial
customer in gallons as well as the predicted average annual usage.
Schedule 8 plots the actual annual usage, predicted annual usage and
Michaelson, Di
SUEZ Water ldaho lnc
10
11
12 0.
13 A.
14
15
16
17
18
'19
20 0.
21 A.
22
23
5
1
2
3
4
5
6
7
8
I
10
11
12
includes a linear trend line of actual usage demonstrating the decline in
average consumption. The table at the bottom of the graph compares
actual total gallons and CCFs at the Test Year compared to the Test Period
ending March 31,2021.
O. How did you develop proposed volumetric and fixed rates?
A. The proposed volumetric and fixed rates were developed by applying the
overall revenue requirement increase of 22.3o/o to each existing rate.
Please see the testimony of Company witness Prettyman that describes the
Cost of Service Study results and rationale for spreading the overal!
revenue increase evenly across al! existing rates.
O. Does this conclude your testimony?
A. Yes.
Michaelson, Di
SUEZ Water ldaho lnc.
6
Michael C. Creamer (lSB No. 4030)
Preston N. Carter (lSB No. 8462)
Givens Pursley LLP
601 W. Bannock St.
Boise, lD 83702
Telephone: [phone]
Facsimile: (208) 388-1 300
m cc@oiven sou rslev.com
prestoncarter@qiven sourslev. com
Attorneys for SUEZ Water ldaho lnc.
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF THE APPLICATION
OF SUEZ WATER IDAHO INC. FOR
AUTHORITY TO INCREASE ITS RATES
AND CHARGES FOR WATER SERVICE
IN THE STATE OF IDAHO
Case No. SUZ-W-2O-O2
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
EXHIBIT 5 TO ACCOMPANY THE
DIRECT TESTIMONY OF TIMOTHY MICHAELSON
Nl/)rltrFrO . . Os-r-ooaoIzzE**f *€ uN€E=dI6-tr-d r/)zo
(!L)
arn.l
NN
r-tr.lNoro
FloF{
lnln0l,)(\t ft') Fl stFl@@tOlnoNo(rl@ff)Fl+-\o-Fl lrl lnrn u)
N(YtNo(o(O
F{
(nN(n
N6N
rJ1(oLn
oo'
(n
r\ooo)U1f\FlO6r.o6+d ui F.' ryiNF(nFl(nFooiddrn rJ1
st(n
@rJ)(o
rrtt
6
oF
oFl6
N(n
CJfc0,
o)d.
bocF(o
ooo
0,
o
}R.r'!
NN
tiFl
o@r-{or-{
N(nNo(n(o
Fl
(nNmra6N
(o.nOr lc)Or rJ)oo' oo't{ <f(n
sfN(ooN(o
lnsf
o
t!
=o
0.t(otl
(!
oF
}RaNN
o00ln
Orlr!N
NNN
OrN
rnslrJ)
rnroFl
Fl
-6!ad,
SEEE*EgE6d.tsi:uo*otrF.gEhgt5E 9=E5EiP
sxec(\lNNN
@<tNrnONotnN
f- 0Ooo (nOr Flo+(\lsf
d
FN
Or
ro
OrOrod
o00N(nf\ F{
N{T\(n
r-{
Fl <t(oo0
Fl d)
N fi)(OFl
el
adlNN
N(n(oooot
ot
oF{t\lnrn(r)
<iln
NrY)No(n
@r{
Flt/1o
00tnN
oNr./)oiN(n
NN€6Ord)
'Jiln
OlNo
tnlnsftsl
6gtt, >33 'Eo
(6-cliio.g'9E*
HE gE=
i,r6L!e
=oof6AE(JOF
xxxc rrl .YlNNNNNN
1./.} N Ct)lnLFtN(ON<t+F{N(n(noI 0o-r.c)N
d(o(no)(Y)oNo(n
NNr-lCN(NNNOOFI
@Ln(Y) F{
(noN(Oo(o<l to<toNd)
Fl
rrt 1.o 0lnF{OOsf sf Fl
cD (O (Yl(o00d
sfrrOor (o orsf(olnooiOrsl-(\
u.)l.r)(nFl Fl O)<tlc)N
Nr{O)NlJ1rOOF{r{o) (o
fn F{
(O CD sf01 N(ol.r) d) Fl
Fa F.' c,Fl Ol sl(n Or Fl
-ie.i(n Ft
g't
Eg9! (g^3.E!99EcL-
(ooc0)
,F gB
9 EER
^-)o-*oroE-3Pi
(n6E, Y,YeaQ);i botr^:l!E(oC,q'6v6f,.a,E
NC
dL-LtFlg6.19ON
cEES["t:i.vGr.m
doEC.P-Y6-CCp6JlP
P E: =gfrE S6
trc
'*,rHaaoEoJG =E =+5 H EE*E " E'5
CL
9 -.EAE9B9sEtiO
EEUf;
E
.9(!()
'6
(!-o3
o
Eo
)(J
vllrJF
EFzt!tttUG,o-
d,lrJozlvtUHft!
4N
> ri-l! d)d-L<L,,sca
=<6>1tcozEo^2.=u4aa-tt L
koE>Fsgz.>u=u) ErH=AFtrHoFZGfov)qUJJzUJ
U&,
Lo
t
f,tl
oI
o
EUJF
=NUJJvt
NlnNtrF{O . OsR:,€:*E*€ s\€E=ed-€;
d r/lzo
(o(J
stNFl(nrr) (o co sf
'ri d F.' oo'(o(\(nu)F{ tO tOi 'ri '/i<t st
oFm(nfn
Fl
oaor
(nN
roNolft6N
OINON(o(oFIFo(\€o(osiNNN(n(nNHslst.idd st$
OiNONtO(OFINoN0oo(lI=IFNr\(n(aF!..1 st sfr{G)(o++
.tst(oO
NNSI FNF.l Fl
INN(oNd)FIOFI(n€NFl
lnFlslF\(\ (n (Y) (n
FlrD(o si si
Eg
5
-:Eo)J
OO3EF(!OEoPo=G t/ttt g.E.gEP6e
oNfnfo(n
H
o00stoor olni+N(n N
(, tOGl t\r.f)oln u)r-l CON
Fl$rc)@dd)
N(Y)(o
Fl
Fl
osto1
aoN
tl)(nrnrn
Fl
rrt $6COtomN(n
Flj
r.n sl€srom
Nd)NFl
r-l
(o.\lN rrtNF{
or rou| (o$rnN(n(\ri
!i
NEE#JO9-SE€P6o-^'j5Hg;Eur.=F-bet5
= s=E5;iiP
otF.oroLn
tt'<t
NoNm(nm
Fl
@slo
c{
F{N
Hsiln
or(oN
NorFl
@c)ft1
l/]sl
NotFl
6o(n
'ri$
oN(n
N
NN6Irlo.r1
rn+
o
vt -3--- 'E tD=Ei bgE PEEEE5=€z<L)o-F
(oo)st(Y}Nrl)u) (n F{
Fa r..'dFl (h st(n O) Fl
FINmd
Fl (\r\ (nstNN(oFl FlOft1H
d lrl Flr\NONro(oFadFi(nNd
N€O0o1.r)Ou1N01l\(nFl(n(o-N
(nN(nLaN(ororo6oror6lnomOrNFI
H fY}(Y) Fl
(nN(Y!lnN(o(oro00o) or 00!no(noI 6t -ldmd) Fl
N(Or}NNN
N
d(n6mo6r\N6t\cD6lno(nO)NFl
Fl (r)mFl
EE a
E,$ o ?e,i : E o:
6bll !EA 6'FG.
@
F
(o
r}
(n
+
N
I
st
rn
N
!.1
p &-235@JFEEE9E.*
E*gE
FlN rQ.EbF=o tr€<.Ebco
9aaEo.<,-l o NEVL\.
N
doeE.co=-o'E i[ EE.E:Eo=oL
b1 :Po<E
.rE-a9F.9 oEqPE<E:q
=Esa
P* o
!:cOsoiEgE-
sdod*geFcPEE=o,f EG,f UI
E-eg 3RSsEH
E;!B
c
.9(!uE
(E(J
o
Eo
fU
thUF
G,Fzr
Uco-
ccUozf
-NzXU>du aY!E-<9
=da<o>Itcuzto^z=ui+t/) r
koG>
FUGZ!/)UH=LF
frHoFZGf,ourrUfzU
t!c,
Io
n
f,th
o-o
tUF
3NUfttl
SUEZ WATER IDAHO INC.
APPLICATION OF PRESENT RATES AND PROPOSED RATES TO CONSUMPTION ANALYSIS
WITH ADJUSTMENTS FOR THE TEST YEAR ENDED JUNE 30, 2O2O
Rate Block
CCF
Number Total Present
Of Bills Consumption Rate Revenue
Proposed
Rate
Proposed
Revenue
(1)(2)(3) (4\
Residential - BLMonthlv
(5)(6)(7)
Customer Charge
5/8
3t4
1
1 1t2
2
Subtotal
't39,214
319,537
51 ,515
1,512
665
0$
0
0
0
0
21.11 $
21.11
26.99
46.17
71.64
2,938,808 $
6,745,426
1,390,390
69,809
47,641
25.81 $
25.81
33.00
56.45
87.60
3,593,312
8,247,706
1,700,045
85,356
58,251
512,443 0 11,',t92,074 13,684,669
Winter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
0 4,253,062 1.4674 6,240,943 1.7942 7,630,869
0
0
618,557
7,331,090
1.4674
1.8577
907,671
13,618,966
1.7942
2.2714
1,109,819
16,652,058
0
5'.12,443
512,443
12,202,709 20,767,580
31,959,654
31,959,654
25,392,745
39,077,415
39,077,415
Subtotal 12,202,709
Total Class 12,202,709
Commercial - Bi-Monthlv
Customer Charge
5/8
3t4
1
I 112
2
3
4
6
Hydrant Rent Flat
Subtotal
3,762
11,952
't4,468
11,974
12,970
1,587
221
237il
0$
0
0
0
0
0
0
0
0
21.11 $
21 .',|1
26.99
46.',17
71.64
139.73
260.68
435.22
25.00
79,416 $
252,307
390,491
552,840
929,171
221,752
57,610
10,010
18,850
25.81 $
25.81
33.00
56.45
87.60
170.85
318.74
532.15
30.57
97,103
308,498
477,458
675,963
1 ,1 36,1 07
271,138
70,441
12,239
23,048
57,711 0 2,5'.t2,447 3,071,995
Winter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
0 2,490,080 't.4674 3,653,943 1.7942 4,467,716
0 65,9130 3,739,337
1.4674
1.8577
96,721 1.7942
2.2714
118,261
8,493,6426946566
0 6,295,330
6,295,330
10,697,230 13,079,620
$ 16,151,615
Case No. SUZ-W-20-02
Exhibit No. 5
Schedule No. 3
T. Michaelson
Page 1 of 2
Total Class 57,711 $ 13,209,677
SUEZWATER IDAHO INC
APPLICATION OF PRESENT RATES AND PROPOSED RATES TO CONSUMPTION ANALYSIS
WITH ADJUSTMENTS FOR THE TEST YEAR ENDED JUNE 30, 2O2O
Rate Block
ccF
Number Total Present
Of Bills Consumption Rate Revenue
Proposed
Rate
Proposed
Revenue
(1)(2)(3)(4)(5)(6)(7)
Other Public Authoritv - Bi-Monthlv
Gustomer Charge
5/8
314
1
1 1t2
2
3
Subtotal
29
59
163
125
233
6
0$
0
0
0
0
0
21.11 $
21.1',|
26.99
46.17
71.64
139.73
612 $
1,245
4,399
5,771
16,692
838
25.81 $
25.81
33.00
56.45
87.60
170.85
749
1,523
5,379
7,057
20,410
1,025
615 0 29,557 36,143
Winter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
0
0
0
13,186 1.4674 19,349 1.7942 23,658
929
47,690
1.4674
1.8577
1,363
88,s94
1.7942
2.2714
1,667
108,324
Total Class
0
615
570,769
61,805
61,805
18,559,844
109,306
$ 138,863
45,308,194
$
133,650
169,793
Private Fire Lines - Bi-Monthlv
Fire Line Size
3" and smaller
4"
6',
8u
10"
12"
Hydrants
4,672
3,607
3,246
1,006
60
30
936
0$
0
0
0
0
0
0
37.22 $
56.42
140.12
230.26
359.08
537.86
22.58
173,892 $
203,507
4t4,830
231,642
21,545
16,136
21,135
45.s1 $
68.99
171.33
281.54
439.05
657.65
27.61
2',t2,619
248,830
556,125
283,231
26,343
19,729
25,842
TotalPrivate Fire 13,557
6
584,326
0 $ 1,122,68s
3,384
$ 46,434,263
$ 1,372,720
4,138
$ 56,775,679
Public Fire 564.00 689.61
Total 18,559,844
Case No. SUZ-W-20-02
Exhibit No. 5
Schedule No. 3
T. Michaelson
Page2 of 2
SUEZ WATER IDAHO
SUMMARY OF BILLING DETERMINANTS FOR REVENUE ADJUSTMENTS
ADJUSTMENT Rl: ANNUALIZATION OF TEST YEAR GROWTH
Number of Customers
6130120L9 6130/2020 Gain/Loss
LlZ of
Growth
Number of Bi-
Monthly Bills
Average Usage
per Bill
ccF
Pro-Forma
Annualization
Adjustment
ccF
Residential
Commercial
Public Authority
Private Fire
84,819
9,692
747
2,782
86,102
9,740
139
2,243
23.87
111.58
82.06
0.00
91,857
16,067
(4e21
L,283
48
-2
67
t44
(6)
183
642
24
-t
31
3,849
Number of Bi-
Monthly Bills
Average Usage
per Bill
ccF
Pro-Forma
Growth
Adjustment
ccF
ADJUSTMENT R2: WEIGHTED CUSTOMER GROWTH THROUGH ?l3tl202t
Number of Customers
613012020 313112027 Gain/Loss
Residential
Commercial
Public Authority
Private Fire
86,102
9,740
139
2,243
86,474
9,79L
L4!
2,290
372.0
51.0
2.0
47.0
53,267
34,L43
985
2,232
306
72
282
23.87
111.58
82.06
0
Adjustment per
Customer
ccF
Pro-Forma
Weather
Adjustment
ccF
ADJUSTMENT R3: WEATHER USAGE ADJUSTMENT
Pro-Forma
No.
Customers
313112027
Residential
Commercial
86,474
9,797
-6.91
-19.01
(597,850)
(186,103)
TOTAT OF PRO-FORMA ADJUSTMENTS (Rl+ R2 + R3)
Pro-Forma
No.
customers
3l3L/2021
Total Pro-
Forma
Adjustment
ccF
Residential
Commercial
Public Authority
Fire
86,474
9,79t
t4t
2,290
{452,726l,
(135,892)
493
(588,126)
Case No. SUZ-W-20-02
Exhibit No. 5
Schedule No.4
T. Michaelson
Page 1 of 1
SUEZ WATER IDAHO INC.
R-1 APPLICATION OF PRESENT RATES AND PROPOSED RATES TO NUMBER OF CUSTOMERS ADDED IN TEST YEAR
YEAR ENDED JUNE 30, 2O2O
Rate Block
CCF
Number
Of Bills
Total
Consumotion
Present
Rete Revenue
Proposed Proposed
Rate Revenue
(1)
Customer Charge
5/8
Subtotal
Winter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
Total Class
Customer Charge
3t4
1
1 1t2
2
Subtotal
Winter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
Total Class
Customer Charge
2
Subtotal
Winter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
Total Class
Fire Line Size
3" and smaller
6"
8"
Total Class
(2)(3) (4)
Residential - Bi-Monthlv
0 $ 21.11
(7)
$81,252 $25.81 $ 99,348
81,252 99,348
46,979 1.7942 57,442
(6)(5)
3,849
3,849 0
3,849
91,857
91,857
32,015
4,656
55.185
1.4674
1.4674
1.8577
6,833
102,518
1.7942
2.2714
1.7942
2.2714
8,354
125,350
156,330
237,582
191,146
290,494
25.81 86533.00 1,339
56.45 1,89587.60 3,185
7,283
1.7942 11,403
Commercial - Bi-Monthlv
34
41u
36
0
0
0
o
21.11
26.99
46.17
71.64
707
1,095
1,550
2,605
144 0 5,957
9,326
247
'17 729
0
0
0
6,355 1.4674
168
9,544
1.4674
1.8577
16,067
16,067 $
Other Public Authoritv - Bi-Monthlv
0 71.04
(105)1.4674
(380)
1.4674
1.8577
(4s21
(4e2)
107,432
Private Fire Lines - BFMonthlv
37.22 $
56.42
140.12
230.26
0
(430)87.60
(430)
(1 54)1.7942
(1 1)
(705)
1.7942
2.2714
(526)
(526)
(188)
302
21,678
0 27,302
33,259
33,382
40,665144$
(6)
(6)0
(7)
0
0
0
(1 3)
(862)
0
(6)
3,987
$
(870)
(1,300)
26S,540
15,536
45.51 $
68.99
171.33
281.54
$
(1,064)
(1,5e0)
$ 18,996
68
53
47
15
2,539 $
2,971
6,641
3,384
3,105
3,633
8120
4,137
0$
0
0
0
183
4,170
$
$$ caseC(f S05w-2G02
Exhibit No. 5
Schedule No.4A
T. Michaelson
Page 1 of 1
Total 107,432 285,076
SUEZ WATER IDAHO INC.
R-2 APPLICATION OF PRESENT RATES AND PROPOSED RATES TO NUMBER OF CUSTOMERS ADDED IN FUTURE YEAR
YEAR ENDED MARCH 31,2021
Rate Block
ccF
Number
Of Bills
Total
Consumption
Present
Rate
Proposed
Rate
Proposed
Revenue Revenue
(1)(2')(3) (4)
Residential - Bi-Monthlv
0 $ 21.11
(5)(6)(71
Customer Charge
518
Subtotal
2,232 $ 47,118 $
47,'.t',tB
25.81 $57.611
2,232 0 57,611
Wnter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
0 18,565 1.4674 27,243 1.7942 33,310
0
0
2,700
32,001
1.4674
1.8577
3,962
59,449
1.7U2
2.2714
4,U5
72,689
Total Class
0
2,232
53,267
53,267
90,654
137,772
110,U4
'168,455
Commercial - Bi-Monthlv
Customer Charge
5/8
314
0
7'.!
86
71
77
0$
0
0
0
0
21.11 $
21.11
26.99
46.17
71.U
$25.81 $
25.81
33.00
56.45
87.60
1
1
2
112
1,503
2,327
3,293
5,53s
1,838
2,U5
4,027
6,768
Subtotal 306 0 12,658 't5,477
\Mnter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
0 13,505 1.4674 19,817 1.7942 24,231
0
0
357 1.4674 5251.8577 37.675
58,017
1.7942
2.2714
641
46.06620,28'.1
0 y,143
y,143
70,s38
86,416Total Class 306 $70,675 $
Other Public Authoritv - Bi-Monthlv
Customer Charge
2
Subtotal
12 0 71.64 860 87.60 1,051
12
0
0
0
0 860 1,051
Winter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
210 1.4674 308 1.7942 377
15
760
1.4674
1.8577
22
1.411
1.7942
2.2714
27
1.726
Total Class
0
12
2,550
985
985
88,395
$
1,741
2,601
211,U9
$
2,129
3,1 80
Private Fire Lines - Bi-Monthlv
Fire Line Size
3" and smaller
6"
8"
105
81
73
23
0
0
0
0
$37.22 $
56.42
140.',t2
230.26
3,913 $
4,579
10,234
5,214
45.51 $
68.99
171.33
281.54
4,7U
5,599
't2,513
6,375
Total Class 282 23,940 $
$
29,272
287,323
Case No. SUZ-W-20{2
Exhibit No.5
Schedule No.48
T. Michaelson
Page 1 of 1
Total 2,832 88,395 $ 234,989
SUEZ WATER IDAHO INC.
R-3 APPLICATION OF PRESENT RATES AND PROPOSED RATES TO USAGE ADJUSTMENTS
YEAR ENDED MARCH 31,202'I
Rate Block Number Total Present Proposed ProposedCCF Of Bills Consumption Rate Revenue Rate Revenue(1) (2) (3) (4) (5) (6) (7)
Residential - Bi-Monthlv
CustomerCharge 0 0 0 0
Winter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
0
0
0
(208,371)
(30,305)
1.4674 (305,764)1.7942 (373,861)
1.4674
1.8577
(44,4701
(667,237\
1.7942
2.2714
(54,374t.
(815.838)
Subtotal
0
0
0
(597,850)
(597,850)
(597,850)
(1,017 ,471\
(1,017 ,471)
(1,017 ,471)
(1,244,073',)
(1,244,0731
(1,244,073\Total Class
Customer Charge 0
Commercial - Bi-Monthlv
0 0 0
Winter Usage
Summer Usage
Up to 3 CCF
Over 3 CCF
Subtotal
0
0
0
(73,612)1.4674 (108,018)1.7942 (132,075)
(1,e4e)
fi10.5421
1.4674
1.8577
(2,85e)
(205.354)
1.7942
2.2714
(3,496)
(251,089)
Total Class
0
0
0
(1 86,103)
(1 86,103)
(783,953)
$
(316,2321
(316,232)
(1,333,702)
$
(386,660)
(386,660)
(1,630,732)Total
Case No. SUz-w-20{2
Exhibit No.5
Schedule No.4C
T. Michaelson
Page 1 of 1
NhOEHo.eoL*:efii>! oT b*E==e{--g,,23o
6u
F
ui
a9
<,9
!o
.E!o4i
!oc
o
i5
looox16fi8610{odl6No
=RliFFl-^-xlEtF
dloos
SleEI6ld N Il---IH€O
UiIH P D
BI}HF=l::_
$IHH5
$lEF$
lo--lq1f9
[e-mail] c a
[:_ldN6
t666EIfiER6lPh3-ld d oq
-[;;st666gHsp
:loH6st@dNElgnc6tNOO
l-o-rl$88clooNotNoo
El[n$
1,,*
-66 OON6OT Sr 6@H@N @6OH hAHrN6tsh$$OS! ! 4tr! .t I q! q tol c.1 dl n'1oq ol q h r:oq r: q c!'1 0q q'1 a \ q dl o:oEHN d6<tsFa @r s@$@ H €ra$ @o@6s66$rd@H?E6L d@ts666 S4 6h6$$ 66$6NNHNNHHHOHOO.=OHH ddHHdd dH HHTHH HTdd dHHHdHdHHd H!!9EEp
-60 6NOO9A Hr O6060 @OdO FO@r6$6d$@9d-a.n9 .! rn n q f!u) ul.1 n! n n \ rl q'4 61.! .1 \ oq r: I 6l r: c1 q.! <q.1
-E6o d6+6mo 6d NFFd i N6oo oQtNNoQ6@dmrqE6F 6hO6Q6 hr @646 S 666m NHHNNHHHOHOOf -iH -HiHdH HH HHHH d HHHH dddddHHddHdHE!iE-cd
dtu ++dNN6 60 Ndo@ 6 @<6N O6@hSNN+6h<6a !4'l q q \ qq ryq v! c'! I ul q q.! q\ 4 dl...! 0q n !q.\| r: -1 q n.!d6 NHHHHO NO OHHO O OOrO OdHOdOHOOHdO
oH doro@F o- 3559 S 995P ERSNRSPFNFRB
od +ospBs Bs gE*gH ilHRX HgS$fi HilHRF$H
soHNOtn@FoooHNo{69ts@ooHdo€6@N@oo6 66 66666666000000000 0dHHHHHHdHHNo 6rdt 660000 00 0000 0 0000 000000000000> :. T i A i id d dd N dNd N Nddd d N d dNNNNN N NN
N
rF@
IN.i
NF
oNq
NNN
NNohddNOoo@opfi
FOO
-@d5En600d6@@d
dtsoNN
co
od-b.; EoooEEF
oz
@ots60++NFONNONdoo@o€{F
r+oF666Fci ci ci ui
EG3!ro 66=E
c EU.9
g [E E ;EIe=g€
.!
B
so
Boq
FfdFfo
d
=:f
N
o
EcE
o66
t
ooo
Eo=6oEc6
=o
Co
e
Et
CoI
o
co!
oEEo
!o&
oco
of
GU
o!og
o
G3
g
=
I.z
d6rcdO t os*3ptj35-ctr &Nf;=36--P*z6oI
XN
9H pttt:>d
dd
oH Ndsh@ts *- 9SSS* 9SSE gRSNRXR
oo6@6tststs@N66da00
s83rFd
NtsO
@o6@NN@ooFiqog600
o60@6NFN@F@ON@O
r@@xi0cd
NNO
@@69Nr90@ri og oqoeo
*HESStr66xooEddo
NNO
toNNON
6d6
.i .i c''l
oNoNtsH
ts6@
oo@d\qHO{
F6N
N@O{orPE!FON
60
oqsq
6N6
o@ouiqcio6r
o+N
o
o*-b;s006deF
U
o)
@@@
.i@
dosH6iodddoi606+{O
qoq0qiiooo
I
.B9p- eE.E
..*EEEE
Efe=E5
I
G
so
eq
E
Ff4Ffo
=f
t9
<,f
Eo
5o4
=nocoo
6
oz
d+=oN oNNddH Nm 6od+d NodN NoHN+dh!.i F@ Nooo 60 0@ 6N@€ F @ HO{ d H@6606g 9.,,i Ei F ..i di 6i dt 6 ui { di ci 6 .i d oi..i d N r qi a ci ct oi e99@@ @tOQOe 60NdOdF {{tsN 6600d9@EE@@ @6@@@@ @@ @66@h 66666h666<<gE40u
=h@ N@6@tQ 66 HN@66 ts<N+ HO4066N* !qoc d) o) 9 d| oqq atr! q q 4s oq n q qut a o: dt u! ut oq.:
=tr@ QQ66@O SO @m$Od OO6d Otd9000ga40 060064 mm 6N6N t HNNN Nh6N+OOE a@F ts@FFFA A@ 6O@66 6666 hh46666
XEo
oo 6@ F@OOHN 6$ 6@NQO OidO<6@ts@OO> oooooooo o6 00000 Hidd *idr*fr N- oo oooooo oo oooo o 0000 a0aoo90O dd dHdNNN NN NNdNd NNdNNNNNNddoF
?cIGr!cIIoGg
E.9
4
EI
co
t's
o
EEo
!oE
3EGE!E:oOEi.9
=ENAfc
Nr aaoNHo @6 @t@N o 6@h$ FN{66tmr:q \q.\ q 4 utq 4q q q sr: 4 dt o{ a.'l \q..{ r:.t ry d -.!HH QNOQHH Oa AAHOQ HdOH OdOOddO
oH +6PRBs ss gE gg E ilERil Hg$$$Hil
o
EtA
oo
,1EH
SUEZ Water ldaho
Residential Consumption Trends 1990 -2020
(gallons per customerl
Year
Actual Annual
Usage
168,350
L70,604
180,289
L56,367
L84,782
155,001
L63,263
159,559
153,513
L7t,L73
!62,303
157,t27
t57,L90
L57,750
L44,388
L32,263
135,560
L39,23!
L30,28L
723,L72
LL6,702
LL4,864
L22,772
122,630
1L9,242
1L6,753
tls,2L4
tog,o42
L17,257
103,450
LO7,LO7
Change from
Previous Year Percent
Predicted
Residential
781,576
777,352
L82,t0t
L63,402
L74,9L5
L57,028
157,403
L56,967
146,835
L57,266
154,350
155,258
154,108
146,853
t4L,9L7
138,955
L37,752
L40,788
134,905
t26,748
120,359
LL8,209
L25,768
t24,822
LLg,245
119,169
LL4,449
L07,745
LLt,637
99,304
101,935
90
9L
92
93
94
95
96
97
98
99
00
01
02
03
04
05
06
07
08
09
10
LL
L2
13
L4
15
16
17
18
19
20
2,255
9,585
(23,9221
27,8L5
(29,181)
8,262
(3,704l.
(6,045)
L7,660
(8,870)
(5,175)
53
(5,440)
(7,3621
(L2,t251
3,297
3,67L
(8,949)
(7,L09t'
(6,47Ll
(1,837)
7,9o8
(t421
(3,388)
(2,4891
(1,540)
(7,L7tl
3,2L5
(7,7981
3,647
1.3%
5.7%
-L3.3%
L7.8%
-L5.80/o
53%
-2.30/o
-3.80/o
LL.5%
-5.2%
-3.2%
O.OYo
-3.s%
-4.9%
-8.4%
2.SYo
2.7%
-6.4%
-5.5%
-53%
-L.60/0
6.9%
-0.L%
-2.8%
-2.L%
-L.3%
'6.2Yo
3.OYo
-7.O%
3.5%
Case No. SUZ-W-20-02
Exhibit No. 5
Schedule No. 5
T. Michaelson
Page 1 of 1
NulrO CF{O . . Ou*:rt:
+EgE$N! BE.Td-€r-durzgI
LoEgh
,t,9LLOa,cLcLLEE EEa eE9h3
= *G, c,EE;IYEE,
E trH !>-nt-6ooldl oo
=?arOOr.do.nF!F{HNr!toI0,'E'
a-
ouo
f,E
trE
6
Go
=
oN
o
o
r
a
n
N
o
oo
P
No
@
o
o
o
No
o
oo
oo
oo
ro
@o
o
o
o
No
o
o
6Eo!
odEa
.9!@c
t
@@o
E
atr
=t
t
tEo
OE.go€Es-Foo=NEE;5 Oori:{ug=.udrE(,P6ooc
LO!U!EL9B_
(J6;:L!,Eqr> otlh-UCXoSo*o9E!!)gil-E!oE= E 17 S*- E,EsU*vF{N OitHtiairoge:R
RoF
E-c
!o
oo
@
ooqoo
ooqoN
ooo-oN
ooqo
ooo-o
ooo
6
oo
oo
ooqo
ooodoN
real:ad raurolsn3 rad suolleg
SUEZ Water ldaho
Commercial Consumption Trends 1990 -2020
(gallons per customer|
Year
95
96
97
98
99
00
01
02
03
04
05
06
07
08
09
10
LI
L2
13
t4
15
L6
L7
18
19
20
Actual Annual
Usage
657,648
706,860
700,319
680,964
705,535
703,356
738,845
550,058
634,278
635,250
596,605
623,667
634,363
579,490
541,893
510,165
520,94L
573,02L
57L,537
570,415
554,895
55L,347
526,498
540,532
503,834
500,766
Change from
Previous Year Percent
Predicted
Commercial
682,696
586,819
587,203
642,920
693,373
682,330
693,5L7
686,006
655,019
634,627
623,377
620,229
535,510
6LL,440
576,7L3
549,674
542,L63
576,6L8
577,4t8
554,118
556,164
535,811
508,317
528,645
469,6tL
486,549
49,2L2
(6,541)
(19,354)
24,670
(2,278!'
35,488
(88,787l.
(15,780)
973
(38,645)
27,062
10,596
{54,8731
.37,5971
13L,7281
t0,775
52,081
(L,4841
lt,L22l
(15,519)
(3,548)
124,8491
L4,034
(36,698)
(3,058)
7.5o/o
-o.9%
-2.8%
3.6%
-O.3Yo
s.0%
-L2.O%
-2.4%
0.2%
-6.L%
4.5%
L.7%
-8.7%
-6.5%
-5.9Yo
2.Lo/o
to.o%
-0.3%
-0.2%
-2.7%
-0.6%
-4s%
2.7%
-6.8%
-O.60/0
Case No. SUZ-W-20-02
Exhibit No. 5
Schedule No.7
T. Michaelson
Page 1 of 1
NlrOtrFlO . . OslOOra6HZZE;
=Eg€ sNf8={6-€;d,,z
o,
toU
bE>ol!P- !'PE8.8ch Eeg tO.r =Eeh:Epxt66ho
E 3$€ar ln ln aY!SBBq5\ttOc{too
$
G
Lt,olLEOb1EE
u6:b9 ECLL :f5tE;'E9>XO-!L-EI' P Ee &t;eC,^96.q6uE0vI\utN
hBEA
=l,trOF{!,F
-t(,
GO
oN
o
@
N
@
*S
f-Edi c
r'6r=6slh"o c3o:'i
6'o
oEEoU!o
€o4
I
o@6)
5c
ot
I
o
oo
No
@o
6o
(o
o
No
o
oo
oo
6o
tso
oo
6o
ooooo
oooooN
oOo
ooodo
ooocto6
oo@
aooor
ooodo6
atc
E
.86l!'E ^E 9XL EC'O:,Ng.qn
N;E
6L o
E
EoL'
Jee^ Jad Jaurolsnf, Jad guolleg
SUEZ WATER IDAHO
COMPARISON OF PRESENT AND PROPOSED RATES
Bi-Monthly Customer Charge Present Rates
Proposed
Rates
Percentage
lncrease
5lg"
314"
1t'
LL/2"
2"
3"
4"
6"
g"
10"
2t.Lt
2L,LL
26.99
46.L7
7L.64
L39.73
250.68
435.22
569.37
811.39
25.81
25.87
33.00
56.45
87.60
170.85
318.74
532.15
696.34
992.33
22.3o/o
22.3o/o
22.3%
223%
223%
223%
22.3o/o
22.3%
223%
22.3o/o
Consumption Charge Present Rates
Proposed
Rates
Percentage
lncrease
Winter Rates
up to 3 ccF
Over 3 CCF
L.4674
t.4674
L.7942
t.7942
22.3%
22.30/o
Summer Rates
Up to 3 CCF
Over 3 CCF
t.4674
t.8577
L.7942
2.27L4
22.3o/o
22.3o/o
Hydrant Rent Flat Rate
Street Sprinkling Service
Flat Rate Service
25.00
282.00
81.07
30.s7
344.80
99.03
22.3%
22.3%
22.2%
Private Fire Present Rates
Proposed
Rates
Percentage
lncrease
3" and smaller
4"
6tt
gtt
10"
t2"
Hydrants
37.22
56.42
t40.L2
230.26
359.08
537.86
22.58
45.51
68.99
L7L.33
28L.s4
439.05
557.55
27.6t
22.3%
22.3o/o
22.3%
22.3o/o
22.3%
223%
22.30/o
Case No. SUZ-W-20-02
Exhibit No. 5
Schedule No. 9
T. Michaelson
Page 1 of 1