HomeMy WebLinkAbout20240806SWS to Staff 57 - time sheets etc.pdf Case # SWS-W-24-0 1 -StoneRidge Water Company General Rate Case
4th Production Request
REQUEST NO 57: Please provide all documents, including invoices, receipts,
time sheets/weekly worked reports, etc. that support the Company's
response to Staffs Production Request No.1, Rate Case Labor Cost Details to
date schedule.
Answer:
a. 2020-2023 Mailing Costs/Publishing Costs of $1,215. See attached labor
hour worksheet for mailer prep and see attached LISPS postage receipts for
Mailing February 2024.
b. 2020-2023 Publication Costs of $194.81 Bonner Bee and $291.67 The
Beacon—invoices attached.
c. 2020-2023 Labor Costs of $50,200, there are no time sheets for this prior
period, the bulk of the time was Jeff Merkeley (30% of his contract time
billed to the rate case and 70% to ongoing Water Operations Compliance)
the balance of billing was for Chan Karupiah Owner's time.
d. Jan-Mar 2024 Labor Costs $12,300, no time sheets, hours worked table
attached.
e. April 1-15, Labor costs $33,442.50—Summary and time sheets attached
f. April 16-April 30th Labor costs $28,772.00--Summary and time sheets
attached
g. May 1-May 30th Labor Costs $21,887.00--Summary and time sheets
attached
h. June 1-June 30th Labor Costs $9,155.00--Summary and time sheets
attached
Company Response 7/8/2024
Date Feb 28, 2024
Individual Hours Rate Total
Prep Mailers
J M 8 24 $ 192.00
R F 8 35 280.00
472.00
USPS Postage $ 257.00
Bonner Bee 194.81
The Beacon 291.67
Total Publishing $ 486.48
Total $ 1,215.48
Fold Mailer and apply address labels and edge stickers and Postage 400 Pieces
StoneRidge Utilities 1523
(?-o!54zL r
StoneRidge Utilities 1523
v c ry
uj C. E 3
00
co
Cam`^ � » Y-= �, _ ?uQ
• C
ZI R� b Z
f � ZL
r ,
.''ram � '� � .a � '•-� ��� ��..-+." � ��"�'
;� _ - •P G CX `-L � �5 J
•LMPIOO M/P CHECK
sk ccxrd
2 !�'Yv tls
3 �
StoneRidge Utilities 1543
Bonn .r County Doily Bee 3/20/2024
194.81
131.1 WTB 1064 Ckg Invoice# 19330-02292024 194.81
•Ud1P100 M/P CHECK II I I I I II III I II I I III
104621
StoneRidge Utilities 1524
River Valley Beacon 2/22/2024
291.67
I
131.1 WTB 1064 Ckg INV 5093 291.67
MP100 M/P CHECK II I I I I II III I II I I III
Bonner County Daily Bee BILLING PERIOD ADVERTISER NAME
310 CHURCH 02/01/2024 to 02/29/2024 CDS STONERIDGE UTILITIES
SANDPOINT, ID 83864
(208)263-9534 TOTAL AMOUNT DUE 'UNAPPLIED AMOUNT TERMS OF PAYMENT
S 194 81 $0 00 Net+15
CURRENT NET AMOUNT 30 DAYS 60 DAYS OVER 90 DAYS
ADVERTISING STATEMENTANVOICE $194 B1 $0 00 $0 00 $0 00
BILLING DATE REMITTANCE ADDRESS
CDS STONERIDGE UTILITIES 02/29/2024
PO BOX 298 BILLED ACCOUNT NUMBER Bonner County Daily Bee
BLANCHARD, ID 83804 53241 PO BOX 7000
ADVERTISER NUMBER COEUR D ALENE,ID 83816
53241
MAKE CHECKS PALPABLE TO:Bonner County Daily Bee
PLEASE DETACH AND RETURN UPPER PORTION WITH YOUR REMITTANCE
Bonner County Daily Bee
Start Date End Date Newspaper Reference Description Days Billed Amount
02/29/2024 02/29/2024 0000019330-02292024 BCB#5894 SWS-W-24-01 1 $194 81
Previous Amount Owed; $0 00
New Charges This Period: $194.81
Cach This Period- 111;0 00
Debit Adjustments This Period: $0 00
Credit Adjustments This Period: $0 00
We appreciate your business
STATEMENT OF ACCOUNT
CURRENT 30 DAYS 60 DAYS 90 DAYS+ TOTAL AMOUNT DUE 'UNAPPLIED AMOUNT
$194 81 $0 00 $0 00 Soot) $194 81 $0 00
Sales Rep Advertiser Information
Billing Period Billed Account Number Advertiser Number Advertiser Name
House,BCB 02/01/2024 to 02/29/2024 53241 53241 CDS STONERIDGE UTILITIES
03/01/2024 13:04:52
c
INVOICE
River Valley Beacon dhood@rivervalleybeacon.com EA
PO Box 1949 208-448-1949
Priest River,ID 83856 th
CDS Stoneridge Utilities
Bin to
CDs Stoneridge Utilities
PO Box 298
Blanchard,ID 83804
Invoice details
Invoice no.:5093
Invoice date:01/31/2024
Due date:02/15/2024
# Date Product or service SKU MY Rate Amount
1. Full Page $640.00 $640.00
Advertising in The Beacon 1/23
Total Q
2�2
N1
LL
U)
a) a)
Z3 a
Q 0
0
OOOO O uON r- �
+, Iql- 00 O O N N N 1 rla)
0 N O N L6 T T cl
o o
~ co
ER EA Efl ER ER ffl ffl tf) EA J
� a)
co co Mcn U
co (D
Q.
U
0 Y Q
+. U E
m O
� � U
o cn
T
OOOrn a)
D O O M M
L
O M LO T 00 0 N
C W
o LL^`
T A
U O LL
J M
J NCL It -0
}, N N
r CDU O
N N
N Efl Efl Efl EF? Efl U)
= N N c U
i U J o c
m � M Q m
C A N V! ' � y U O
O `- NU -0 U)U) N N
m a) o O a
cC O L 0 Q) Q
U Z CO L, -0 Co ca U � m Uco C: La U
E m O E OU Q C L E
?, V a_ c) cna 0 � �
C D LO
Qa m _
. 0 m
E
O N
U FO-
N
O m
N �
O
T (n
4 (o
1 �
O
C �
U
0
IJ
cnco
1 g c
O CO
Q
O E
O
o ® ® o En U
0 0 CD '
O 00 In ll E r
r N i ++
tn
U 0
o
CnCL
a
U
I-S 619, Cl-
co co co Co Q
EnY
�p U
U f°
o
m
N 0U
0
c c
0 0
Cl-
Iq cr-
N "2
- - O O
N o 0 0 o 0
+L+ o ca ca o N
C ® co In
J � 0 ri �
T
CL
O O N
c 1 U O
Nu4 N
1
co
L
VI �
ch O J ~
c cn N d
x
s. N M m
.0 U � Y
vn E M as U a
� z � w � 0o � m g
L '> a V)
E ( 0-4 E ° C. c a a"i
Z U m a cn cn a a
r I o
M a m
E n a�
C+K1:Q14ompany Name:CDS StoneRidge Utilities, LLC
Idaho PUC Case Number: SWS-W-24-01
Test Year ended: 12/31/2023
Amortization of Rate Case Costs
4/1/2024 thru 4-15-2024
Total Hours
Name JM RF TZ BL CK TK JD GZ 'Total hours per day
1-Apr 11 11 0 0 9 8.5 0 8 47.5
2-Apr 11 11 0 0 9 8.5 0 8 47.5
3-Apr 11 11 0 0 9 0 0 0 31
4-Apr 8 81 0 0 0 01 0 0 16
5-Apr 8 8 0 0 0 0 0 0 16
6-Apr 12 0 0 0 8 3 0 0 23
7-Apr 8 8 0 0 0 0 0 0 16
8-Apr 12.5 10.5 4.5 8 9 8.5 2 1 56
9-Apr 12.5 10.5 6.5 7 9.5 8.5 0 8 62.5
10-Apr 14 10.51 1 7 9.5 8.51 0 8 58.5
11-Apr 11 11 7 0 11.5 8.51 0 8 47
12-Apr 10 101 7 0 10 3 0 6 46
13-Apr 6 0 0 0 6 1 0 0 13
14-Apr 8 0 01 01 8 8 01 01 24
15-Apr 7 7 01 01 7 7 01 01 28
Total hours per person 150 106.5 261 221 105.51 73 21 471 532
Total Cost
Name JM RF TZ BL CK TK JD GZ
Labor rate $25.00 $40.00 $26.00 $25.00 $125.00 $125.00 $30.00 $39.00 Total Cost per day
4/1/2024 $275.00 $440.00 $0.00 $0.00 $1.125.00 $1,062,50 $0.00 $312.00 $3.214,50
4/2/2024 $275.00 $440.00 $0 00 $0.00 $1,125.00 $1,062.50 $0.00 $312.00 $3,214.50
4/3/2024 $275.00 $440.001 $0.00 $0.00 $1,125.00 $0,001 $0.00 $0,00 $1,840,00
4/4/2024 $200.00 $320.00 $0 00 $0.00 $0 00 $0 00 $0.00 $0.00 $520,00
4/5/2024 $200.00 $320.00 $0 00 $0.00 $0.00 $0,00 $0.00 $0.00 $520.00
4/6/2024 $300.00 $0 00 $0 00 $0.00 $1,000,00 $375.00 $0.00 $0.00 $1,675.00
4/7/2024 $200.00 $320 00 $0,00 $0.00 $0.00 $0.00 $0.00 $0.00 $520 00
4/8/2024 $312.50 $420.00 $117.00 $200.00 $1,125.00 $1,062-50 $60.00 $39.00 $3,336.00
4/9/2024 $312.50 $420.001 5169-00 $175.00 P.1-87.50 $1,062.501 $0.00 $312.00 $3,638.50
4/10/2024 $350:00 $420 00 $26.00 $175.00 $1,187 50 $1,062.50 $0.00 $312.00 $3,533.00
4/11/2024 $275.00 $40,00 $182,00 $0.00 $1,437 50 $1,062.50 $0,00 $312.00 $3.309 00
4/12/2024 $250.00 $400 00 $182,00 $0,00 $1.250.00 $375.00 $0.00 $234.00 $2,691-00
4/13/2024 $150.00 $0 00 $0 00 $0.001 $750.00 $125.00 $0.00 $0.00 $1,025.00
4/14/2024 $200.00 $0.00 $0 00 $0.00 $1,000.00 $1,000-00 $0.00 $0.00 $2.200-00
4/15/2024 $175.00 $280 00 $0 00 $0.00 $875.00 $875.00 $0.00 $0.00 $2,205.00
Total Cost per day $3,750.00 $4.260 00 $676 00 $550.00 $13.187.50 $9,125.00 $60 00 $1,833 00 r$33,441.50
1 e _. ---
\\dellr510\ProjectsW IPUC Rate Tariff 2024\24-01 Record Request\Backup IPUC submittals\First Prod Request Final Submittal -4-16-2024
IPUC Submitted File\PR1 Quest.1 - Comp\Rate case Labor Cost Details to date