Pavletic Consulting LLC
2014 Mann Parkway, Celina, TX 75009
Phone 510.439.6264
To: City of Ripon MFS Project No.: 202002
259 N. Wilma Avenue Invoice No.: 202002-01
Ripon, CA 95366 Date: January 1, 2024
Attention: Mr. Kevin Werner
Sent Via Email to: [email protected]
Subject: Water, Sewer and Garbage Fund Four-Year Rate Plan Reviews Billing Period: October 2, 2023 through December 31, 2023 Billing Number: 1
Reference: Agreement dated March 10, 2020
MFS Contact: Tom Pavletic, 510.439.6264
WATER Hours Rate Billing Amount
Task 1 - Develop Customer Use Characteristics 1.25 $160.00 $200.00 Task 2 - Develop Financial Plan / Revenue Requirements 1.00 $160.00 $160.00 Task 3 - Develop Rate Alternatives 0.25 $160.00 $40.00
Task 4 - Prepare Preliminary, Draft and Final Reports 1.50 $160.00 $240.00 Task 5 - Prepare Presentations/Attend Meetings 0.00 $160.00 $0.00 Total Labor 4.00 $640.00
SEWER Hours Rate Billing Amount
Task 1 - Develop Customer Use Characteristics 0.50 $160.00 $80.00 Task 2 - Develop Financial Plan / Revenue Requirements 1.00 $160.00 $160.00 Task 3 - Develop Rate Alternatives 0.25 $160.00 $40.00
Task 4 - Prepare Preliminary, Draft and Final Reports 1.50 $160.00 $240.00 Task 5 - Prepare Presentations/Attend Meetings 0.00 $160.00 $0.00 Total Labor 3.25 $520.00
GARBAGE Hours Rate Billing Amount
Task 1 - Develop Customer Use Characteristics 0.50 $160.00 $80.00 Task 2 - Develop Financial Plan / Revenue Requirements 1.50 $160.00 $240.00 Task 3 - Develop Rate Alternatives 1.75 $160.00 $280.00 Task 4 - Prepare Preliminary, Draft and Final Reports 2.50 $160.00 $400.00 Task 5 - Prepare Presentations/Attend Meetings 0.00 $160.00 $0.00 Total Labor 6.25 $1,000.00
AMOUNT DUE THIS INVOICE 13.50 $2,160.00
WORK PROGRESS (week beginning date)
2-Oct-23 receive email from KW on Oct 2 re: annual rate evaluation for 2024; update previous years' final version of models for wtr/swr/gbg to receive updated customer and financial data from city and send updated models "v0" to KW on oct 5; 9-Oct-23 no activity
16-Oct-23 no activity
23-Oct-23 no activity
30-Oct-23 no activity
6-Nov-23 no activity
13-Nov-23 receive v01 draft rate evaluation excel workbooks from CG on Nov 16; review FY24-FY27 adopted and projected rate increases and reply to CG and KW on Nov 16 re: Prop 218 for garbage fund 20-Nov-23 no activity
27-Nov-23 receive updated capital replacement for each of the utility funds from KW on Nov 28 and reply to CG and KW re: Prop 218 for garbage fund; ZOOM call w/CG on Nov 29 to discuss water use projections, annual CIP projections (to be developed by CG/KW), and garbage fund cash flow goals; receive "2024_review_gbg_rates_v02.xlsx" from CG on Nov 30 with changes to capital funding transfers; ZOOM call w/CG on Dec 1 to discuss garbage fund cash flow alternatives; ZOOM call w/KW & CG on Dec 1 to discuss garbage cash flow and TM preparation; receive v02 of water and sewer models on Dec 1; begin preparation of draft TM and update of wtr/swr/gbg models to v03
4-Dec-23 send prelim draft TM d1-0 and models v03 to CG on Dec 4; receive comments on regulatory expenditures from CG on Dec 5; send TM preliminary draft d2-0 and regulatory expenditures data workbook for fy22-fy24 to CG on Dec 5; receive comments from CG on Dec 6; send TM preliminary draft d2-1 and regulatory expenditures data workbook for fy22-fy23 to CG on Dec 6 send final TM f1-0 to CG on Dec 7; receive questions from KW on Dec 8; update report to f2-0 and send to KW & CG on Dec 8 11-Dec-23 no activity
18-Dec-23 no activity
25-Dec-23 no activity
Payment is due within 30 days of receipt of invoice, interest on the unpaid balance will accrue beginning with the 31st day at the rate of 1.5 percent per month or the maximum interest permitted by law, whichever is lesser. Page: 1 Pavletic Consulting LLC
2014 Mann Parkway, Celina, TX 75009
Phone 510.439.6264
Water Rates
Week Begin Task Total Cumulative
Monday 001 002 003 004 005 Hours % Hours % Inv
2-Oct-23 1.0 1.0 1.5% 1.0 1.5%
9-Oct-23 0.0 0.0% 1.0 1.5%
16-Oct-23 0.0 0.0% 1.0 1.5%
23-Oct-23 0.0 0.0% 1.0 1.5%
30-Oct-23 0.0 0.0% 1.0 1.5%
6-Nov-23 0.0 0.0% 1.0 1.5%
13-Nov-23 0.25 0.3 0.4% 1.3 1.8%
20-Nov-23 0.0 0.0% 1.3 1.8%
27-Nov-23 0.25 1.0 1.0 1.3 1.8% 2.5 3.7%
4-Dec-23 0.5 0.0 0.0% 2.5 3.7%
11-Dec-23 0.0 0.0% 2.5 3.7%
18-Dec-23 0.0 0.0% 2.5 3.7%
25-Dec-23 0.0 0.0% 2.5 3.7% No. 1
Total FY24 1.25 1.00 0.25 1.50 0.00 4.00 3.7%
Total FY21 13.00 15.00 4.00 8.00 1.50 41.50 61.0%
Total FY22 0.00 8.50 0.00 2.00 0.00 10.50 15.4%
Total FY23 0.00 2.50 1.00 1.75 0.00 5.25 7.7%
Total FY20-FY24 14.25 27.00 5.25 13.25 1.50 61.25 90.1% Budget 12.00 20.00 16.00 12.00 8.00 68.00
% Spent 119% 135% 33% 110% 19% 90%
Legend
Task 1 - Develop Customer Use Characteristics Task 4 - Prepare Preliminary, Draft and Final Reports Task 2 - Develop Financial Plan / Revenue Requirements Task 5 - Prepare Presentations/Attend Meetings Task 3 - Develop Rate Alternatives *
* In FY23, Task 3 accounts for evaluation of SSJID Treated Water Supply project costs and summary of regulatory impacts Payment is due within 30 days of receipt of invoice, interest on the unpaid balance will accrue beginning with the 31st day at the rate of 1.5 percent per month or the maximum interest permitted by law, whichever is lesser. Page: 2 Pavletic Consulting LLC
2014 Mann Parkway, Celina, TX 75009
Phone 510.439.6264
Sewer Rates
Week Begin Task Total Cumulative
Monday 001 002 003 004 005 Hours % Hours % Inv
2-Oct-23 0.5 0.5 0.7% 0.5 0.7%
9-Oct-23 0.0 0.0% 0.5 0.7%
16-Oct-23 0.0 0.0% 0.5 0.7%
23-Oct-23 0.0 0.0% 0.5 0.7%
30-Oct-23 0.0 0.0% 0.5 0.7%
6-Nov-23 0.0 0.0% 0.5 0.7%
13-Nov-23 0.25 0.3 0.4% 0.8 1.1%
20-Nov-23 0.0 0.0% 0.8 1.1%
27-Nov-23 1.0 1.0 1.0 1.5% 1.8 2.6%
4-Dec-23 0.5 0.0 0.0% 1.8 2.6%
11-Dec-23 0.0 0.0% 1.8 2.6%
18-Dec-23 0.0 0.0% 1.8 2.6%
25-Dec-23 0.0 0.0% 1.8 2.6% No. 1
Total FY24 0.50 1.00 0.25 1.50 0.00 3.25 2.6%
Total FY21 14.00 13.00 6.00 11.00 1.00 45.00 66.2%
Total FY22 0.00 3.50 0.00 2.00 0.00 5.50 8.1%
Total FY23 0.00 1.50 0.00 1.75 0.00 3.25 4.8%
Total FY20-FY24 14.50 19.00 6.25 16.25 1.00 57.00 83.8% Budget 12.00 20.00 16.00 12.00 8.00 68.00
% Spent 121% 95% 39% 135% 13% 84%
Legend
Task 1 - Develop Customer Use Characteristics Task 4 - Prepare Preliminary, Draft and Final Reports Task 2 - Develop Financial Plan / Revenue Requirements Task 5 - Prepare Presentations/Attend Meetings Task 3 - Develop Rate Alternatives
Payment is due within 30 days of receipt of invoice, interest on the unpaid balance will accrue beginning with the 31st day at the rate of 1.5 percent per month or the maximum interest permitted by law, whichever is lesser. Page: 3 Pavletic Consulting LLC
2014 Mann Parkway, Celina, TX 75009
Phone 510.439.6264
Garbage Rates
Week Begin Task Total Cumulative
Monday 001 002 003 004 005 Hours % Hours % Inv
2-Oct-23 0.5 0.5 0.7% 0.5 0.7%
9-Oct-23 0.0 0.0% 0.5 0.7%
16-Oct-23 0.0 0.0% 0.5 0.7%
23-Oct-23 0.0 0.0% 0.5 0.7%
30-Oct-23 0.0 0.0% 0.5 0.7%
6-Nov-23 0.0 0.0% 0.5 0.7%
13-Nov-23 0.25 0.3 0.4% 0.8 1.1%
20-Nov-23 0.0 0.0% 0.8 1.1%
27-Nov-23 0.50 1.50 2.0 2.9% 2.8 4.0%
4-Dec-23 1.0 2.5 1.0 1.5% 3.8 5.5%
11-Dec-23 0.0 0.0% 3.8 5.5%
18-Dec-23 0.0 0.0% 3.8 5.5%
25-Dec-23 0.0 0.0% 3.8 5.5% No. 1
Total FY24 0.50 1.50 1.75 2.50 0.00 6.25 5.5%
Total FY21 11.00 9.00 5.00 8.00 1.00 34.00 50.0%
Total FY22 0.00 4.00 0.00 2.00 0.00 6.00 8.8%
Total FY23 0.00 2.50 0.00 1.75 0.00 4.25 6.3%
Total FY20-FY24 11.50 17.00 6.75 14.25 1.00 50.50 74.3% Budget 12.00 20.00 16.00 12.00 8.00 68.00
% Spent 96% 85% 42% 119% 13% 74%
Legend
Task 1 - Develop Customer Use Characteristics Task 4 - Prepare Preliminary, Draft and Final Reports Task 2 - Develop Financial Plan / Revenue Requirements Task 5 - Prepare Presentations/Attend Meetings Task 3 - Develop Rate Alternatives
Payment is due within 30 days of receipt of invoice, interest on the unpaid balance will accrue beginning with the 31st day at the rate of 1.5 percent per month or the maximum interest permitted by law, whichever is lesser. Page: 4 Pavletic Consulting LLC
2014 Mann Parkway, Celina, TX 75009
Phone 510.439.6264
To: City of Ripon MFS Project No.: 202002 MFS Project No.:
259 N. Wilma Avenue Invoice No.: 202002-01 Invoice No.:
Ripon, CA 95366 Date: January 1, 2024 Date:
Attention: Mr. Kevin Werner
Water, Sewer and Garbage Fund Four-Year Rate Plan Reviews
SUMMARY OF ACCOUNT
Total This Prior Invoiced Total Invoiced
Item Budget Invoice To Date To Date
WATER
Task 1 - Develop Customer Use Characteristics $1,920.00 $200.00 $2,080.00 $2,280.00 Task 2 - Develop Financial Plan / Revenue Requirements $3,200.00 $160.00 $4,160.00 $4,320.00 Task 3 - Develop Rate Alternatives $2,560.00 $40.00 $800.00 $840.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $240.00 $1,880.00 $2,120.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $240.00 $240.00 Total Labor $10,880.00 $640.00 $9,160.00 $9,800.00
SEWER
Task 1 - Develop Customer Use Characteristics $1,920.00 $80.00 $2,240.00 $2,320.00 Task 2 - Develop Financial Plan / Revenue Requirements $3,200.00 $160.00 $2,880.00 $3,040.00 Task 3 - Develop Rate Alternatives $2,560.00 $40.00 $960.00 $1,000.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $240.00 $2,360.00 $2,600.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $160.00 $160.00 Total Labor $10,880.00 $520.00 $8,600.00 $9,120.00
GARBAGE
Task 1 - Develop Customer Use Characteristics $1,920.00 $80.00 $1,760.00 $1,840.00 Task 2 - Develop Financial Plan / Revenue Requirements $3,200.00 $240.00 $2,480.00 $2,720.00 Task 3 - Develop Rate Alternatives $2,560.00 $280.00 $800.00 $1,080.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $400.00 $1,880.00 $2,280.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $160.00 $160.00 Total Labor $10,880.00 $1,000.00 $7,080.00 $8,080.00
TOTAL $32,640.00 $2,160.00 $32,640.00 $2,160.00 $2,160.00 $24,840.00 $24,840.00 $24,840.00 $27,000.00 $27,000.00 TOTAL PAID TO DATE $24,840.00
BALANCE OUTSTANDING $2,160.00
BUDGET REMAINING $5,640.00
Payment is due within 30 days of receipt of invoice, interest on the unpaid balance will accrue beginning with the 31st day at the rate of 1.5 percent per month or the maximum interest permitted by law, whichever is lesser. Page: 5