Pavletic Consulting LLC
2014 Mann Parkway, Celina, TX 75009
Phone 510.439.6264
To: City of Ripon MFS Project No.:
259 N. Wilma Avenue Invoice No.:
Ripon, CA 95366 Date:
202002
202002-01_12-24
December 30, 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 21, 2024 through December 29, 2024 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 2.00 $160.00 $320.00 Task 2 - Develop Financial Plan / Revenue Requirements 2.00 $160.00 $320.00 Task 3 - Develop Rate Alternatives 0.00 $160.00 $0.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.50 $1,040.00
SEWER Hours Rate Billing Amount
Task 1 - Develop Customer Use Characteristics 0.00 $160.00 $0.00 Task 2 - Develop Financial Plan / Revenue Requirements 2.00 $160.00 $320.00 Task 3 - Develop Rate Alternatives 0.00 $160.00 $0.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 4.50 $720.00
GARBAGE Hours Rate Billing Amount
Task 1 - Develop Customer Use Characteristics 0.00 $160.00 $0.00 Task 2 - Develop Financial Plan / Revenue Requirements 2.00 $160.00 $320.00 Task 3 - Develop Rate Alternatives 0.00 $160.00 $0.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 4.50 $720.00
AMOUNT DUE THIS INVOICE 15.50 $2,480.00
WORK PROGRESS (week beginning date)
21-Oct-24 TEAMS call w/ Christiana Giedd (CG) on Oct 23; update previous years' final version of models for wtr/swr/gbg; update draft TM; send water, sewer, and garbage models v00 to CG on Oct 24; 28-Oct-24 no activity
4-Nov-24 no activity
11-Nov-24 no activity
18-Nov-24 receive v01 draft rate evaluation excel workbooks from CG on Nov 18; review FY24-FY27 actual adopted and projected data; TEAMS call w/CG on Nov 19 re: updates to swr model; update previous years' final version of models w/ wtr/swr/gbg updates; compose draft TM d1-0; conf call w/CG on Nov 20 re: wtr model v02 and TM d1-0; send draft TM d1-1, wtr model v04, swr model v02, and gbg model v02 to CG on Nov 21; receive draft TM d1-2 on Nov 22 with revisions by CG; update TM to final version f1-0 and send docx and pdf to CG on Nov 22; send table and figure of 15 year SF bill history to CG on Nov 22; 25-Nov-24 no activity
2-Dec-24 no activity
9-Dec-24 no activity
16-Dec-24 no activity
23-Dec-24 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
21-Oct-24 1.0 1.0 1.0 2.0 2.9% 2.0 2.9%
28-Oct-24 0.0 0.0% 2.0 2.9%
4-Nov-24 0.0 0.0% 2.0 2.9%
11-Nov-24 0.0 0.0% 2.0 2.9%
18-Nov-24 1.0 1.0 1.5 2.0 2.9% 4.0 5.9%
25-Nov-24 0.0 0.0% 4.0 5.9%
2-Dec-24 0.0 0.0% 4.0 5.9%
9-Dec-24 0.0 0.0% 4.0 5.9%
16-Dec-24 0.0 0.0% 4.0 5.9%
23-Dec-24 0.0 0.0% 4.0 5.9% No. 1
Total FY25 2.00 2.00 0.00 2.50 0.00 6.50 5.9%
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 FY24 1.25 1.00 0.25 1.50 0.00 4.00 5.9%
Total FY20-FY25 16.25 29.00 5.25 15.75 1.50 67.75 99.6% Budget 12.00 20.00 16.00 12.00 8.00 68.00
% Spent 135% 145% 33% 131% 19% 100%
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
21-Oct-24 1.0 1.0 1.0 1.5% 1.0 1.5%
28-Oct-24 0.0 0.0% 1.0 1.5%
4-Nov-24 0.0 0.0% 1.0 1.5%
11-Nov-24 0.0 0.0% 1.0 1.5%
18-Nov-24 1.0 1.5 1.0 1.5% 2.0 2.9%
25-Nov-24 0.0 0.0% 2.0 2.9%
2-Dec-24 0.0 0.0% 2.0 2.9%
9-Dec-24 0.0 0.0% 2.0 2.9%
16-Dec-24 0.0 0.0% 2.0 2.9%
23-Dec-24 0.0 0.0% 2.0 2.9% No. 1
Total FY25 0.00 2.00 0.00 2.50 0.00 4.50 2.9%
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 FY24 0.50 1.00 0.25 1.50 0.00 3.25 4.8%
Total FY20-FY25 14.50 21.00 6.25 18.75 1.00 61.50 90.4% Budget 12.00 20.00 16.00 12.00 8.00 68.00
% Spent 121% 105% 39% 156% 13% 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
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
21-Oct-24 1.0 1.0 1.0 1.5% 1.0 1.5%
28-Oct-24 0.0 0.0% 1.0 1.5%
4-Nov-24 0.0 0.0% 1.0 1.5%
11-Nov-24 0.0 0.0% 1.0 1.5%
18-Nov-24 1.0 1.5 1.0 1.5% 2.0 2.9%
25-Nov-24 0.0 0.0% 2.0 2.9%
2-Dec-24 0.0 0.0% 2.0 2.9%
9-Dec-24 0.0 0.0% 2.0 2.9%
16-Dec-24 0.0 0.0% 2.0 2.9%
23-Dec-24 0.0 0.0% 2.0 2.9% No. 1
Total FY25 0.00 2.00 0.00 2.50 0.00 4.50 2.9%
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 FY24 0.50 1.50 1.75 2.50 0.00 6.25 9.2%
Total FY20-FY25 11.50 19.00 6.75 16.75 1.00 55.00 80.9% Budget 12.00 20.00 16.00 12.00 8.00 68.00
% Spent 96% 95% 42% 140% 13% 81%
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: December 30, 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 $320.00 $2,280.00 $2,600.00 Task 2 - Develop Financial Plan / Revenue Requirements $3,200.00 $320.00 $4,320.00 $4,640.00 Task 3 - Develop Rate Alternatives $2,560.00 $0.00 $840.00 $840.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $400.00 $2,120.00 $2,520.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $240.00 $240.00 Total Labor $10,880.00 $1,040.00 $9,800.00 $10,840.00
SEWER
Task 1 - Develop Customer Use Characteristics $1,920.00 $0.00 $2,320.00 $2,320.00 Task 2 - Develop Financial Plan / Revenue Requirements $3,200.00 $320.00 $3,040.00 $3,360.00 Task 3 - Develop Rate Alternatives $2,560.00 $0.00 $1,000.00 $1,000.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $400.00 $2,600.00 $3,000.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $160.00 $160.00 Total Labor $10,880.00 $720.00 $9,120.00 $9,840.00
GARBAGE
Task 1 - Develop Customer Use Characteristics $1,920.00 $0.00 $1,840.00 $1,840.00 Task 2 - Develop Financial Plan / Revenue Requirements $3,200.00 $320.00 $2,720.00 $3,040.00 Task 3 - Develop Rate Alternatives $2,560.00 $0.00 $1,080.00 $1,080.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $400.00 $2,280.00 $2,680.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $160.00 $160.00 Total Labor $10,880.00 $720.00 $8,080.00 $8,800.00
TOTAL $32,640.00 $2,480.00 $32,640.00 $2,480.00 $2,480.00 $27,000.00 $27,000.00 $27,000.00 $29,480.00 $29,480.00 TOTAL PAID TO DATE $27,000.00
BALANCE OUTSTANDING $2,480.00
BUDGET REMAINING $3,160.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