Pavletic Consulting LLC
2014 Mann Parkway, Celina, TX 75009
Phone 510.439.6264
To: City of Ripon Project No.: 202502
259 N. Wilma Avenue Invoice No.: 202502-02
Ripon, CA 95366 Date: December 29, 2025
Attention: Mr. Kevin Werner
Sent Via Email to: [email protected]
Subject: Water, Sewer and Garbage Fund FY26 - FY30 Rate Study Billing Period: June 30, 2025 through December 28, 2025 Billing Number: 2
Reference: Agreement dated February 11, 2025
Contact: Tommy Pavletic, 510.439.6264
WATER Hours Rate Billing Amount
Task 1 - Develop Customer Use Characteristics 1.00 $160.00 $160.00 Task 2 - Develop Financial Plan / Revenue Requirements 7.00 $160.00 $1,120.00 Task 3 - Develop Rate Alternatives 6.00 $160.00 $960.00 Task 4 - Prepare Preliminary, Draft and Final Reports 11.00 $160.00 $1,760.00 Task 5 - Prepare Presentations/Attend Meetings 0.00 $160.00 $0.00 Total Labor 25.00 $4,000.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 0.50 $160.00 $80.00 Task 3 - Develop Rate Alternatives 2.50 $160.00 $400.00 Task 4 - Prepare Preliminary, Draft and Final Reports 10.50 $160.00 $1,680.00 Task 5 - Prepare Presentations/Attend Meetings 0.00 $160.00 $0.00 Total Labor 13.50 $2,160.00
GARBAGE Hours Rate Billing Amount
Task 1 - Develop Customer Use Characteristics 8.00 $160.00 $1,280.00 Task 2 - Develop Financial Plan / Revenue Requirements 0.50 $160.00 $80.00 Task 3 - Develop Rate Alternatives 3.50 $160.00 $560.00 Task 4 - Prepare Preliminary, Draft and Final Reports 11.00 $160.00 $1,760.00 Task 5 - Prepare Presentations/Attend Meetings 0.00 $160.00 $0.00 Total Labor 23.00 $3,680.00
AMOUNT DUE THIS INVOICE 61.50 $9,840.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: 1 Pavletic Consulting LLC
2014 Mann Parkway, Celina, TX 75009
Phone 510.439.6264
To: City of Ripon Project No.: 202502
259 N. Wilma Avenue Invoice No.: 202502-02
Ripon, CA 95366 Date: December 29, 2025
Attention: Mr. Kevin Werner
Sent Via Email to: [email protected]
Subject: Water, Sewer and Garbage Fund FY26 - FY30 Rate Study Billing Period: June 30, 2025 through December 28, 2025 Billing Number: 2
Reference: Agreement dated February 11, 2025
Contact: Tommy Pavletic, 510.439.6264
WORK PROGRESS (week beginning date)
30-Jun-25 no activity
7-Jul-25 no activity
14-Jul-25 no activity
21-Jul-25 receive "2026_wtr_rates_fy26-32_v00-0_kw1.xlsx" from KW on Jul 24; review KW updates of wtr model and reply on Jul 24 with talking points for discussion;
28-Jul-25 ZOOM w/KW on Jul 29 to review the FY25-FY30 water rate model source data, cash flow, and formulas for evaluating alternative 1) CIP expenditures and funding; and 2) expenditures; send "2026_wtr_rates_fy26-32_v01-0.xlsx" to KW on Jul 29; add worksheets and formulas to water model for testing alternative budget and CIP worksheets; prepare 16-year SF bill comparison; develop water cash flow alternatives dashboard and test scenarios; send "ripon_2026_wtr_rates_fy26-30_v02.xlsx" to KW on Jul 30 4-Aug-25 receive "2026_gbg_rates_fy26-32_v00-0_kw.xlsx" from KW on Aug 9; 11-Aug-25 no activity
18-Aug-25 no activity
25-Aug-25 no activity
1-Sep-25 no activity
8-Sep-25 receive "Enterprise Operating Budget Summary_20250421.xlsx" from KW on Sep 13 15-Sep-25 no activity
22-Sep-25 no activity
29-Sep-25 TEAMS w/KW on Oct 2 to review the FY25-FY30 rate models source data, cash flow, and formulas for evaluating alternative; review wtr-swr-gbg rate models; send 2026_wtr-swr-gbg_bills_fy14-fy30.xlsx and v2 of wtr-swr-gbg rate models to KW on Oct 3; 6-Oct-25 TEAMS w/Lisa Roos (LR) on Oct 9 to review garbage rate calculations; receive "Utility Rates 2022-Calculations for future years.xlsx" from LR on Oct 9; update gbg model formulas for FY26-FY32 and send gbg model v2_rev1 to LR for review on Oct 10; update wtr-swr-gbg bills history to include FY06-FY14 data and send to LR for missing data and review on Oct 10; receive email from LR on Oct 10 re: gbg rate calcs; make revisions to gbg rates and save a v2_rev2; prepare prelim rate study report; 13-Oct-25 TEAMS w/LR on Oct 13 to review garbage rate calculations; send gbg model v2_rev3 to LR on Oct 13; receive additional garbage rate data from LR on Oct 15; update garbage rate model on Oct 16; update rate survey; send gbg model to LR on Oct 16 re:
number of units for new rate categories; prepare d0_model_v3 prelim report; send 2025 ripon_wtr-swr-gbg-rpt_d0_models_v3.docx and excel files w/tables and figures to KW on Oct 16; 20-Oct-25 TEAMS w/KW on Oct 20 to review the FY25-FY30 rate models and prelim report document; update models and prelim report; send 2025 ripon_wtr-swr-gbg-rpt_d1_models_v4.docx and excel files w/tables and figures to KW on Oct 20; receive 2025 ripon_wtr-swr-gbg-prelim_rpt_d1_models_v4_kw.xlsx from KW on Oct 23; send 2025 ripon_wtr-swr-gbg-rpt_d2_models_v5.docx and excel files w/tables and figures to KW on Oct 24 27-Oct-25 receive updated expenditure values for water and garbage funds, and garbage bills for other cities, from KW on Oct 28; send 2025 ripon_wtr-swr-gbg-rpt_d3_models_v6.docx and excel files w/tables and figures to KW on Oct 29 3-Nov-25 receive updated expenditure values for water and garbage funds from KW on Nov 03; updated models and report and send 2025 ripon_wtr-swr-gbg-draft_rpt_d4_models_v7.pdf and Word and Excel files w/tables and figures to KW on Nov 04 10-Nov-25 no activity
17-Nov-25 no activity
24-Nov-25 no activity
1-Dec-25 no activity
8-Dec-25 no activity
15-Dec-25 no activity
22-Dec-25 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
9-Jun-25 0.0 0.0% 0.0 0.0%
16-Jun-25 4.0 8.0 12.0 25.5% 12.0 25.5%
23-Jun-25 0.0 0.0% 12.0 25.5% No. 1
30-Jun-25 0.0 0.0% 12.0 25.5%
7-Jul-25 0.0 0.0% 12.0 25.5%
14-Jul-25 0.0 0.0% 12.0 25.5%
21-Jul-25 0.5 1.0 1.5 3.2% 13.5 28.7%
28-Jul-25 0.5 5.0 4.0 9.5 20.2% 23.0 48.9%
4-Aug-25 0.0 0.0% 23.0 48.9%
11-Aug-25 0.0 0.0% 23.0 48.9%
18-Aug-25 0.0 0.0% 23.0 48.9%
25-Aug-25 0.0 0.0% 23.0 48.9%
1-Sep-25 0.0 0.0% 23.0 48.9%
8-Sep-25 0.0 0.0% 23.0 48.9%
15-Sep-25 0.0 0.0% 23.0 48.9%
22-Sep-25 0.0 0.0% 23.0 48.9%
29-Sep-25 1.0 2.0 3.0 6.4% 26.0 55.3%
6-Oct-25 2.0 2.0 4.3% 28.0 59.6%
13-Oct-25 7.0 7.0 14.9% 35.0 74.5%
20-Oct-25 1.0 1.0 2.1% 36.0 76.6%
27-Oct-25 0.5 0.5 1.1% 36.5 77.7%
3-Nov-25 0.5 0.5 1.1% 37.0 78.7%
10-Nov-25 0.0 0.0% 37.0 78.7%
17-Nov-25 0.0 0.0% 37.0 78.7%
24-Nov-25 0.0 0.0% 37.0 78.7%
1-Dec-25 0.0 0.0% 37.0 78.7%
8-Dec-25 0.0 0.0% 37.0 78.7%
15-Dec-25 0.0 0.0% 37.0 78.7%
22-Dec-25 0.0 0.0% 37.0 78.7% No. 2
Total FY26 5.00 15.00 6.00 11.00 0.00 37.00 78.7%
Budget * 8.00 15.00 7.00 10.00 7.00 47.00
% Spent 63% 100% 86% 110% 0% 79%
* 28 Hours Budgeted and Spent for Task 006 are for FY27-FY30 and are not shown in this invoice.
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: 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
9-Jun-25 0.0 0.0% 0.0 0.0%
16-Jun-25 4.0 8.0 12.0 25.5% 12.0 25.5%
23-Jun-25 0.0 0.0% 12.0 25.5% No. 1
30-Jun-25 0.0 0.0% 12.0 25.5%
7-Jul-25 0.0 0.0% 12.0 25.5%
14-Jul-25 0.0 0.0% 12.0 25.5%
21-Jul-25 0.0 0.0% 12.0 25.5%
28-Jul-25 0.0 0.0% 12.0 25.5%
4-Aug-25 0.0 0.0% 12.0 25.5%
11-Aug-25 0.0 0.0% 12.0 25.5%
18-Aug-25 0.0 0.0% 12.0 25.5%
25-Aug-25 0.0 0.0% 12.0 25.5%
1-Sep-25 0.0 0.0% 12.0 25.5%
8-Sep-25 0.0 0.0% 12.0 25.5%
15-Sep-25 0.0 0.0% 12.0 25.5%
22-Sep-25 0.0 0.0% 12.0 25.5%
29-Sep-25 0.5 2.0 2.5 5.3% 14.5 30.9%
6-Oct-25 2.0 2.0 4.3% 16.5 35.1%
13-Oct-25 7.0 7.0 14.9% 23.5 50.0%
20-Oct-25 0.5 1.0 1.5 3.2% 25.0 53.2%
27-Oct-25 0.0 0.0% 25.0 53.2%
3-Nov-25 0.5 0.5 1.1% 25.5 54.3%
10-Nov-25 0.0 0.0% 25.5 54.3%
17-Nov-25 0.0 0.0% 25.5 54.3%
24-Nov-25 0.0 0.0% 25.5 54.3%
1-Dec-25 0.0 0.0% 25.5 54.3%
8-Dec-25 0.0 0.0% 25.5 54.3%
15-Dec-25 0.0 0.0% 25.5 54.3%
22-Dec-25 0.0 0.0% 25.5 54.3% No. 2
Total FY26 4.00 8.50 2.50 10.50 0.00 25.50 54.3%
Budget * 8.00 15.00 7.00 10.00 7.00 47.00
% Spent 50% 57% 36% 105% 0% 54%
* 28 Hours Budgeted and Spent for Task 006 are for FY27-FY30 and are not shown in this invoice.
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
9-Jun-25 0.0 0.0% 0.0 0.0%
16-Jun-25 4.0 8.0 12.0 25.5% 12.0 25.5%
23-Jun-25 0.0 0.0% 12.0 25.5% No. 1
30-Jun-25 0.0 0.0% 12.0 25.5%
7-Jul-25 0.0 0.0% 12.0 25.5%
14-Jul-25 0.0 0.0% 12.0 25.5%
21-Jul-25 0.0 0.0% 12.0 25.5%
28-Jul-25 0.0 0.0% 12.0 25.5%
4-Aug-25 2.0 2.0 4.3% 14.0 29.8%
11-Aug-25 0.0 0.0% 14.0 29.8%
18-Aug-25 0.0 0.0% 14.0 29.8%
25-Aug-25 0.0 0.0% 14.0 29.8%
1-Sep-25 0.0 0.0% 14.0 29.8%
8-Sep-25 0.0 0.0% 14.0 29.8%
15-Sep-25 0.0 0.0% 14.0 29.8%
22-Sep-25 0.0 0.0% 14.0 29.8%
29-Sep-25 0.5 2.0 2.5 5.3% 16.5 35.1%
6-Oct-25 4.0 2.0 6.0 12.8% 22.5 47.9%
13-Oct-25 2.0 1.0 7.0 10.0 21.3% 32.5 69.1%
20-Oct-25 0.5 1.0 1.5 3.2% 34.0 72.3%
27-Oct-25 0.5 0.5 1.1% 34.5 73.4%
3-Nov-25 0.5 0.5 1.1% 35.0 74.5%
10-Nov-25 0.0 0.0% 35.0 74.5%
17-Nov-25 0.0 0.0% 35.0 74.5%
24-Nov-25 0.0 0.0% 35.0 74.5%
1-Dec-25 0.0 0.0% 35.0 74.5%
8-Dec-25 0.0 0.0% 35.0 74.5%
15-Dec-25 0.0 0.0% 35.0 74.5%
22-Dec-25 0.0 0.0% 35.0 74.5% No. 2
Total FY26 12.00 8.50 3.50 11.00 0.00 35.00 74.5%
Budget * 8.00 15.00 7.00 10.00 7.00 47.00
% Spent 150% 57% 50% 110% 0% 74%
* 28 Hours Budgeted and Spent for Task 006 are for FY27-FY30 and are not shown in this invoice.
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 Project No.: 202502
259 N. Wilma Avenue Invoice No.: 202502-02
Ripon, CA 95366 Date: December 29, 2025
Attention: Mr. Kevin Werner
Water, Sewer and Garbage Fund FY26 - FY30 Rate Study
SUMMARY OF ACCOUNT
Total This Prior Invoiced Total Invoiced
Item Budget Invoice To Date To Date
WATER
Task 1 - Develop Customer Use Characteristics $1,280.00 $160.00 $640.00 $800.00 Task 2 - Develop Financial Plan / Revenue Requirements $2,400.00 $1,120.00 $1,280.00 $2,400.00 Task 3 - Develop Rate Alternatives $1,120.00 $960.00 $0.00 $960.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,600.00 $1,760.00 $0.00 $1,760.00 Task 5 - Prepare Presentations/Attend Meetings $1,120.00 $0.00 $0.00 $0.00 Total Labor $7,520.00 $4,000.00 $1,920.00 $5,920.00
SEWER
Task 1 - Develop Customer Use Characteristics $1,280.00 $0.00 $640.00 $640.00 Task 2 - Develop Financial Plan / Revenue Requirements $2,400.00 $80.00 $1,280.00 $1,360.00 Task 3 - Develop Rate Alternatives $1,120.00 $400.00 $0.00 $400.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,600.00 $1,680.00 $0.00 $1,680.00 Task 5 - Prepare Presentations/Attend Meetings $1,120.00 $0.00 $0.00 $0.00 Total Labor $7,520.00 $2,160.00 $1,920.00 $4,080.00
GARBAGE
Task 1 - Develop Customer Use Characteristics $1,280.00 $1,280.00 $640.00 $1,920.00 Task 2 - Develop Financial Plan / Revenue Requirements $2,400.00 $80.00 $1,280.00 $1,360.00 Task 3 - Develop Rate Alternatives $1,120.00 $560.00 $0.00 $560.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,600.00 $1,760.00 $0.00 $1,760.00 Task 5 - Prepare Presentations/Attend Meetings $1,120.00 $0.00 $0.00 $0.00 Total Labor $7,520.00 $3,680.00 $1,920.00 $5,600.00
TOTAL * $22,560.00 $9,840.00 $5,760.00 $15,600.00
* Totals and Budget Remaining excludes 28 Hours and $13,440 Budgeted for Task 006 for FY27-FY30.
TOTAL PAID TO DATE $5,760.00
BALANCE OUTSTANDING $9,840.00
BUDGET REMAINING * $6,960.00
* Totals and Budget Remaining excludes 28 Hours and $13,440 Budgeted for Task 006 for FY27-FY30.
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