20230308Michaelson Rebuttal Exhibits.PDF

Preston N. Carter, ISB No. 8462
Blake W. Ringer, ISB No. 11223
Givens Pursley LLP 601 W. Bannock St. Boise, Idaho 83702 Telephone: [phone]
Facsimile: [phone]
[e-mail] [e-mail] Attorneys for Veolia Water Idaho, Inc.

BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
VEOLIA WATER IDAHO, INC. FOR
WATER SERVICE IN
CASE NO. VEO-W-22-02

BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
EXHIBIT NO.17 TO ACCOMPANY THE
REBUTTAL TESTIMONY OF TIMOTHY MICHAELSON

RECEIVED
2023 March, 8 4:42PM
IDAHO PUBLIC
UTILITIES COMMISSION
Customer Classification
Per Books
Revenues
Historic Test
Year Rates
Removal of
Unbilled,
Surcharges &
Adjusted
Historic Test
Year Book
Revenues
Historic Test
Year Rates
Adjustment 1
Annualization
Customer
Growth from
1/1/23 -
Adjustment R3
weather usage
Eagle Historic
Test Year
Normalization
of Phase 1 Revenue
(1)(2)(3)(4) = (2) + (3)(5)(6)(7)(8)(9)(10)
+ (7) + (8) + (9)
Case No. VEO-W-22-02
Exhibit No. 17
Schedule 2
T. Michaelson
Page 1 of 1
ADJUSTMENT R2: WEIGHTED CUSTOMER GROWTH THROUGH 3/31/2023
Average Usage Growth
Number of Bi-
Monthly Bills
ADJUSTMENT R2: WEIGHTED CUSTOMER GROWTH THROUGH 3/31/2023
Average Usage Growth
Number of Customers Number of
Monthly Bills
Rate Block Number Total Present
CCF Of Bills Consumption Rate Revenue
(1)(2)(3)(4)(5)
Customer Charge
5/8 93 22.96$ 2,143$
3/4 218 22.96 5,004
1 37 29.35 1,077
Subtotal 348 8,224
Winter Usage 0 2,920 1.5959 4,660
Summer Usage
Up to 3 CCF 0 310 1.5959 495
Over 3 CCF 0 4,767 2.0204 9,630
Subtotal 0 7,997 14,785
Total Class 348 7,997 23,010
Customer Charge
3/4 22 22.96$ 500$
1 27 29.35 795
1 1/2 22 50.21 1,094
2 25 77.92 1,974
Subtotal 96 4,363
Winter Usage 0 4,409 1.5959 7,037
Summer Usage
Up to 3 CCF 0 85 1.5959 136
Over 3 CCF 0 6,396 2.0204 12,923
Subtotal 0 10,891 20,096
Total Class 96 10,891 24,460$
Customer Charge
1 2 29.35$ 56$
1 1/2 1 50.21 74
2 3 77.92 204
Subtotal 6 334
Winter Usage 0 156 1.5959 249
Summer Usage
Up to 3 CCF 0 6 1.5959 10
Over 3 CCF 0 371 2.0204 749
Subtotal 0 533 1,008
Total Class 6 533 1,342$
Fire Line Size
3" and smaller 2 0 40.48$ 91$
4"2 0 61.36 106
6"2 0 152.39 235
8"0 0 250.43 124
Total Class 6 0 555$
Total Adjustment 456 19,421 49,366
VEOLIA WATER IDAHO, INC.
R-2 APPLICATION OF PRESENT RATES TO NUMBER OF CUSTOMERS ADDED IN TEST YEAR - VWID
Residential - Bi-Monthly
Commercial - Bi-Monthly
Other Public Authority - Bi-Monthly
Private Fire Lines - Bi-Monthly
Case No. VEO-W-22-02
Exhibit No. 17
Schedule 4 - VWID System
Page 1 of 1
Michaelson
B
Rate Block Number Total Present
CCF Of Bills Consumption Rate Revenue
(1)(2)(3)(4)(5)
Customer Charge
5/8 85 11.48 976
3/4 97 11.48 1,115
Subtotal 182 2,091
Winter Usage 0 764 1.5959 1,220
Summer Usage
Up to 3 CCF 0 81 1.5959 130
Over 3 CCF 0 1,247 2.0204 2,520
Subtotal 0 2,093 3,869
Total Class 182 2,093 5,960
Customer Charge
3/4 4 11.48 45
1 3 14.68 45
1 1/2 6 25.11 150
2 6 38.96 223
Subtotal 19 463
Winter Usage 0 428 1.5959 684
Summer Usage
Up to 3 CCF 0 8 1.5959 13
Over 3 CCF 0 621 2.0204 1,255
Subtotal 0 1,058 1,952
Total Class 19 1,058 2,415
Customer Charge
5/8 0 6.70 -
3/4 0 6.70 -
1 1/2 0 14.64 -
2 0 22.73 -
Subtotal 0 -$
Winter Usage 0 0 1.5959 0
Summer Usage
Up to 3 CCF 0 0 1.5959 0
Over 3 CCF 0 0 2.0204 0
Subtotal 0 0 0
Total Class 0 0 -
Fire Line Size
3" and smaller 6 0 20.24 120
4"4 0 30.68 137
Total Class 10 0 257
Total Adjustment 211 3,151 8,633
Private Fire Lines - Monthly
VEOLIA WATER IDAHO, INC.
R-2 APPLICATION OF PRESENT RATES TO NUMBER OF CUSTOMERS ADDED IN TEST YEAR - EAGLE NEW
Commercial - Monthly
Residential - Monthly
Other Public Authority - Monthly
Case No. VEO-W-22-02
Exhibit No. 17Schedule 4B - Eagle New
Page 1 of 1
Michaelson