Municipal Municipal Financial Services
Financial 2014 Mann Parkway, Celina, TX 75009
Services Phone 510.439.6264
To: City of Ripon MFS Project No.: 202002
259N. Wilma Avenue Invoice No.: 202002-01
Ripon, CA 95366 Date: January 2, 2023
Attention: Mr. Kevin Werner
Sent Via Email to: [email protected]
Subject: Water, Sewer and Garbage Fund Four-Year Rate Plan Reviews Billing Period: October 17, 2022 through January 1, 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 0.00 $160.00 $0.00 Task 2 - Develop Financial Plan / Revenue Requirements 2.50 $160.00 $400.00 Task 3 - Develop Rate Altematives 1.00 $160.00 $160.00
Task 4 - Prepare Preliminary, Draft and Final Reports 1.75 $160.00 $280.00 Task 5 - Prepare Presentations/Attend Meetings 0.00 $160.00 $0.00 Total Labor 5.25 $840.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 1.50 $160.00 $240.00 Task 3 - Develop Rate Altematives 0.00 $160.00 $0.00
Task 4 - Prepare Preliminary, Draft and Final Reports 1.75 $160.00 $280.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.00 $160.00 $0.00 Task 2 - Develop Financial Plan / Revenue Requirements 2.50 $160.00 $400.00 Task 3 - Develop Rate Alteratives 0.00 $160.00 $0.00
Task 4 - Prepare Preliminary, Draft and Final Reports 1,75 $160,00 $280.00 Task 5 - Prepare Presentations/Attend Meetings 0.00 $160.00 $0.00 Total Labor 4.25 $680.00
AMOUNT DUE THIS INVOICE 12.75 $2,040.00
WORK PROGRESS (week beginning date)
17-Oct-22 cont call-TEAMS w/ Kevin Wemer and Christiana Giedd on Oct 17 re: schedule and data requirements; update TM for FY23 rate review; update wts/ swr/gbg rate models for trasnmitttat to City for customer data; conf call-TEAMS w/CG on Oct 18 to review swr & gog models; 24-0ct-22
31-0ct-22 no activity
7-Nov-22 receive 2023_review to&_rates_ 103 on Nov 3; TEAMS w/CG on Nov & re: operating & capital budget and fund balances 14-Nov-22 no activity
21-Nov-22 receive 2023 _review_808_rates_106 on Nov 22 and send v07 tp_review to CG; receive 2023 _review_swr_ rates_126 on Nov 22 and send v03 p_review to CG; receive 2023 _review_ w_rates_ v01 on Nov 22 and send v02 p_review to CG; TEAMS w/CG on Nov 22 re:
8og cash flow, swr cash flow, wtr cash flow for SSJID & nonresidential water use, & rate survey; prepare d1-0 TM and send to KW & CG on Nov 23;
28-Nov-22 receive comments on TM d1-0 and models wt v04_Iw; swr v04_Iw and gog V08_Iw on Dec 1; update TM to d2-0 and models to wtr v05; swr v05 and gog v09 and sent to KW & CG on Dec 2 5-Dec-22 receive comment re: TM d2-0 from DB on Dec 5; incorporate comment, update to final and send f1-0 to KW & DG on Dec 5; 12-Dec-22 no activity
19-Dec-22 no activity
26-Dec-22 no activity READY TO PAY
BY: Kn
yment is due within 30 days of receipt of invoice, interest on the unpaid balance will accrue beginning with. 'st day at the rate of 1.5 percent per month or the maximum interest permitted by law, whichever is les:
Municipal Municipal Financial Services
Financial 2014 Mann Parkway, Celina, TX 75009
Services Phone 510.439.6264
Water Rates
Week Begin Task Iotal Cumulative
Monday 001 002 003 004 005 Hours % Hours Inv
17-0ct-22 2.0 1.0 3.0 4.4% 3.0 4.4%
24-0ct-22 0.0 0.0% 3.0 4.4%
31-0ct-22 0.0 0.0% 3.0 4.4%
7-Nov-22 0.0 0.0% 3.0 4,4%
14-Nov-22 0.0 0.0% 3.0 4.4%
21-Nov-22 0.5 1.0 0.5 0.7% 3.5 5.1%
28-Nov-22 0.75 0.0 0.0% 3.5 5.1%
5-Dec-22 0.0% 3.5 5.1%
12-Dec-22 0.0 0.0% 3.5 5.1%
19-Dec-22 0.0 0.0% 3.5 5.1%
26-Dec-22 0.0% 3.5 5.1% No. 1
Total FY23 0.00 2.50 1.00 1.75 0.00 5.25 5.1%
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 FY20-FY23 13.00 26.00 5.00 11.75 1.50 57.25 84.2% Budget 12.00 20.00 16.00 12.00 8.00 68.00
% Spent 108% 130% 31% 98% 19% 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 *
* In FY23, Task 3 accounts for evaluation of SJID 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 Municipal Municipal Financial Services
Financial 2014 Mann Parkway, Celina, TX 75009
Services Phone 510.439.6264
Sewer Rates
Week Begin Task Total Cumulative
Monday 001 002 003 004 005 Hours % Hours % Inv
17-0ct-22 1.0 1.0 1.5% 1.0 1.5%
24-0ct-22 0.0 0.0% 1.0 1.5%
31-0ct-22 0.0 0.0% 1.0 1.5%
7-Nov-22 0.0 0.0% 1.0 1.5%
14-Nov-22 0.0 0.0% 1.0 1.5%
21-Nov-22 0.5 1.0 0.5 0.7% 1.5 2.2%
28-Nov-22 0.75 0.0 0.0% 1.5 2.2%
5-Dec-22 0.0 0.0% 1.5 2.2%
12-Dec-22 0.0 0.0% 1.5 2.2%
19-Dec-22 0.0 0.0% 1.5 2.2%
26-Dec-22 0.0 0.0% 1.5 2.2% No. 1
Total FY23 0.00 1.50 0.00 1.75 0.00 3.25 2.2%
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 FY20-FY23 14.00 18.00 6.00 14.75 1.00 53.75 79.0% Budget 12.00 20.00 16.00 12.00 8.00 68.00
% Spent 117% 90% 38% 123% 13% 79%
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 Municipal Municipal Financial Services
Financial 2014 Mann Parkway, Celina, TX 75009
Services Phone 510.439.6264
Garbage Rates
Week Begin Task Iotal Cumulative
Monday 001 002 003 004 005 Hours Hours % Inv
17-0ct-22 1,0 1.0 1.5% 1.0 1.5%
24-0ct-22 0.5 0.5 0.7% 1.5 2.2%
31-0ct-22 0.0 0.0% 1.5 2.2%
7-Nov-22 0.5 0.5 0.7% 2.0 2.9%
14-Nov-22 0.0 0.0% 20 2.9%
21-Nov-22 0.5 1.0 0.5 0.7% 25 3.7%
28-Nov-22 0.75 0.0 0.0% 2.5 3.7%
5-Dec-22 0.0 0.0% 2.5 3.7%
12-Dec-22 0.0 0.0% 25 3.7%
19-Dec-22 0.0 0.0% 2.5 3.7%
26-Dec-22 0.0 0.0% 2.5 3.7% No. 1
Total FY23 0.00 2.50 0.00 1.75 0.00 4.25 3.7%
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 FY20-FY23 11.00 15.50 5.00 11.75 1.00 44.25 65.1% Budget 12.00 20.00 16.00 12.00 8.00 68.00
% Spent 92% 78% 31% 98% 13% 65%
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 Municipal Municipal Financial Services
Financial 2014 Mann Parkway, Celina, TX 75009
Services 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 2, 2023
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 $0.00 $2,080.00 $2,080.00 Task 2 - Develop Financial Plan / Revenue Requirements $3,200.00 $400.00 $3,760.00 $4,160.00 Task 3 - Develop Rate Alternatives $2,560.00 $160.00 $640.00 $800.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $280.00 $1,600.00 $1,880.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $240.00 $240.00 Total Labor $10,880.00 $840.00 $8,320.00 $9,160.00
SEWER
Task 1 - Develop Customer Use Characteristics $1,920.00 $0.00 $2,240.00 $2,240.00 Task 2 - Develop Financial Plan / Revenue Requirements $3,200.00 $240.00 $2,640.00 $2,880.00 Task 3 - Develop Rate Alternatives $2,560.00 $0.00 $960.00 $960.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $280.00 $2,080.00 $2,360.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $160.00 $160.00 Total Labor $10,880.00 $520.00 $8,080.00 $8,600.00
GARBAGE
Task 1 - Develop Customer Use Characteristics $1,920.00 $0.00 $1,760.00 $1,760.00 Task 2 - Develop Financial Plan / Revenue Requirements $3,200.00 $400.00 $2,080.00 $2,480.00 Task 3 - Develop Rate Alternatives $2,560.00 $0.00 $800.00 $800.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $280.00 $1,600.00 $1,880.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $160.00 $160.00 Total Labor $10,880.00 $680.00 $6,400.00 $7,080.00
TOTAL $32,640.00 $2,040.00 $22,800.00 $24,840.00
TOTAL PAID TO DATE $22,800.00
BALANCE OUTSTANDING $2,040.00
BUDGET REMAINING $7,800.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