Municipal Municipal Financial Services patter
Financial 2960 Valley Basin Avenue, Henderson, NV 89052 Services Phone 510.439.6264
To: City of Ripon MFS Project No.: 202002
259 N. Wilma Avenue Invoice No.: 202002-02
Ripon, CA 95366 Date: January 24, 2022
Attention: Mr. Kevin Wemer
Sent Via Email to: [email protected]
Subject: Water, Sewer and Garbage Fund Four-Year Rate Plan Reviews Billing Perlod: December 6, 2021 through January 23, 2022 Billing Number: 2
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.0 $160.00 $0.00 Task 2 - Develop Financial Plan / Revenue Requirements 3.5 $160.00 $560.00 Task 3 - Develop Rate Alternatives 0.0 $160.00 $0.00
Task 4 - Prepare Preliminary, Draft and Final Reports 2.0 $160.00 $320.00 Task 5 - Prepare Presentations/Attend Meetings 0.0 $160.00 $0.00 Total Labor 5.5 $880.00
SEWER Hours Rate Billing Amount
Task 1 - Develop Customer Use Characteristics 0.0 $160.00 $0.00 Task 2 - Develop Financial Plan / Revenue Requirements 0.5 $160.00 $80.00 Task 3 - Develop Rate Alternatives 0.0 $160.00 $0.00
Task 4 - Prepare Preliminary, Draft and Final Reports 2.0 $160.00 $320.00 Task 5 - Prepare Presentations/Attend Meetings 0.0 $160.00 $0.00 Total Labor 2.5 $400.00
GARBAGE Hours Rate Billing Amount
Task 1 - Develop Customer Use Characteristics 0.0 $160.00 $0.00 Task 2 - Develop Financial Plan / Revenue Requirements 2.0 $160.00 $320.00 Task 3 - Develop Rate Alteratives 0.0 $160.00 $0.00
Task 4 - Prepare Preliminary, Draft and Final Reports 2.0 $160.00 $320.00 Task 5 - Prepare Presentations/Attend Meetings 0.0 $160.00 $0.00 Total Labor 4.0 $640.00
AMOUNT DUE THIS INVOICE 12.0 $1,920.00
WORK PROGRESS (week beginning date)
6-Dec-21 no activity
13-Dec-21 conf call-gtm w/KW on Dec 16 to discuss water model v01 and garbage model v00 KW comments; send wtr model v03 and gbg v01 models to KW on Dec 16; conf call w/KW on Dec 17 regarding FY21 water use; send wtr model v04 to KW on Dec 17
20-Dec-21 receive wtr madel v04 with updates on Dec 21; update wtr model and send wtr model v05 to KW on Dec 23 27-Dec-21 receive gog model v01 with updates on Dec 29; update gog model and send gog model v02 to KW on Dec 30; prepare prelim TM d1-0 and send to KW on Dec 31 along with swr model v03; 3-Jan-22 receive email from KW re: TM on Jan 5; send TM_prelim_f1-0_2022-review to KW on Jan 6 10-Jan-22 no activity
17-Jan-22 receive request for rates and rate code list from LR on Jan 17; send Utility Rates 2022 xIsx" to LR & KW on Jan 18; send 2022_review_swr_rates_v04. xisx and 2022_review_gbg_rates_04.x/sx to KW on Jan 20 Payment is due within 30 days of receipt of invoice, interest on the unpaid balance will accrue beginning with the 3ist day at the rate of 1.5 percent per month or the maximum interest permitted by law. whichever is lesser. Page: 1 Municipal Municipal Financial Services
Financial 2960 Valley Basin Avenue, Henderson, NV 89052 Services Phone 510.439.6264
Water Rates
Week Begin Task Total Cumulative
Monday 001 002 003 004 005 Hours % Hours % Inv
6-Sep-21 0.0 0.0% 0.0 0.0%
13-Sep-21 0.0 0.0% 0.0 0.0%
20-Sep-21 0,0 0.0% 0.0 0.0%
27-Sep-21 0.0 0.0% 0.0 0.0%
4-0ct-21 0.0 0.0% 0.0 0.0%
11-0ct-21 0.0 0.0% 0.0 0.0%
18-0ct-21 0.0 0.0% 0.0 0.0%
25-0ct-21 2.0 2.0 2.9% 2.0 2.9%
1-Nov-21 0.0 0.0% 2.0 2.9%
8-Nov-21 0.0 0.0% 2.0 2.9%
15-Nov-21 0.0 0.0% 2.0 2.9%
22-Nov-21 0.0 0.0% 2.9%
29-Nov-21 3.0 4.4% 7.4%
6-Dec-2i --- 30 20%--50 - 74-NOL
13-Dec-21 2.5 2.5 3.7% 7.5 11.0%
20-Dec-21 1.0 1.0 1.5% 8.5 12.5%
27-Dec-21 2.0 0.0 0.0% 8.5 12.5%
3-Jan-22 0.0 0.0% 8.5 12.5%
10-Jan-22 0.0 0.0% 8.5 12.5%
17-Jan-22 0.0 0.0% 8.5 12.5% No.2
Total FY21 0.0 8.5 0.0 2.0 0.0 10.5 12.5%
Total FY20 13.0 15.0 4.0 8.0 1.5 41.5 61.0%
Total FY20+FY21 13.0 23.5 4.0 10.0 1.5 52.0 76.5%
Budget 12.0 20.0 16.0 12.0 8.0 68.0
% Spent 108% 118% 25% 83% 19% 76%
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 31si 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 2960 Valley Basin Avenue, Henderson, NV 89052 Services Phone 510.439.6264
Sewer Rates
Week Begin Task Total Cumulative
Monday 001 002 003 004 005 Hours Hours % Inv
6-Sep-21 0.0 0.0% 0.0 0.0%
13-Sep-21 0.0 0.0% 0.0 0.0%
20-Sep-21 0.0 0.0% 0.0 0.0%
27-Sep-21 0.5 0.5 0.7% 0.5 0.7%
4-0ct-21 0.0 0.0% 0.5 0.7%
11-0ct-21 0.5 0.5 0.7% 1.0 1.5%
18-0ct-21 0.0 0.0% 1.0 1.5%
25-0ct-21 20 2.0 2.9% 3.0 4.4%
1-Nov-21 0.0 0.0% 3.0 4,4%
8-Nov-21 3.0 4.4%
15-Nov-21 3.0 4.4%
22-Nov-21 3.0 4.4%
29-Nov-21 3.0 4.4% No. 1
- —I
6-Dec-21 3.00 -4.4%---
13-Dec-21 0.0 0.0% 3.0 4.4%
20-Dec-21 0.0 0.0% 3.0 4.4%
27-Dec-21 2.0 0.0 0.0% 3.0 4.4%
3-Jan-22 0.0 0.0% 3.0 4.4%
10-Jan-22 0.0 0.0% 3.0 4,4%
17-Jan-22 0.5 0.5 0.7% 3.5 5.1% No. 2
Total FY21 0.0 3.5 0.0 2.0 0.0 5.5 5.1%
Total FY20 14.0 13.0 6.0 11.0 1.0 45.0 66.2%
Total FY20+FY21 14.0 16.5 6.0 13.0 1.0 50.5 74.3%
Budget 12.0 20.0 16.0 12.0 8.0 68.0
% Spent 117% 83% 38% 108% 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: 3 Municipal Municipal Financial Services
Financial 2960 Valley Basin Avenue, Henderson, NV 89052 Services Phone 510.439.6264
Garbage Rates
Week Begin Task Total Cumulative
Monday 001 002 003 004 005 Hours % Hours % Inv
6-Sep-21 0.0% 0.0 0.0%
13-Sep-21 0.0% 0.0 0.0%
20-Sep-21 0.0 0.0% 0.0 0.0%
27-Sep-21 0.0 0.0% 0.0 0.0%
4-0ct-21 0.0 0.0% 0.0 0.0%
11-0ct-21 0.0 0.0% 0.0 0.0%
18-0ct-21 0.0 0.0% 0.0 0.0%
25-0ct-21 0.0 0.0% 0.0 0.0%
1-Nov-21 0.0 0.0% 0.0 0.0%
8-Nov-21 0.0 0.0% 0.0 0.0%
15-Nov-21 0.0 0.0% 0.0 0.0%
22-Nov-21 0.0 0.0% 0.0 0.0%
29-Nov-21 2.0 2.9% 2.9% No. 1
- - -- 2 320 --
6-Dec-21 25%
13-Dec-21 0.5 0.7% 2.5 3.7%
20-Dec-21 0.0 0.0% 2.5 3.7%
27-Dec-21 1.0 2.0 1.0 1.5% 3.5 5.1%
3-Jan-22 0.0 0.0% 3.5 5.1%
10-Jan-22 0.0 0.0% 3.5 5.1%
17-Jan-22 0.5 0.5 0.7% 4.0 5.9% No. 2
Total FY21 0.0 4.0 0.0 2.0 0.0 6.0 5.9%
Total FY20 11.0 9.0 5.0 8.0 1.0 34.0 50.0%
Total FY20+FY21 11.0 13.0 5.0 10.0 1.0 40.0 58.8%
Budget 12.0 20.0 16.0 12.0 8.0 68.0
% Spent 92% 65% 31% 83% 13% 59%
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 2960 Valley Basin Avenue, Henderson, NV 89052 Services Phone 510.439.6264
To: City of Ripon MFS Project No.: 202002
259 N. Wilma Avenue
Ripon, CA 95366 Involce No.: 202002-02
Date: January 24, 2022
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 $560.00 $3,200.00 $3,760.00 Task 3 - Develop Rate Alternatives $2,560.00 $0.00 $640.00 $640.00 Task 4 - Prepare Preliminary, Draft and Final Reports $1,920.00 $320.00 $1,280.00 $1,600.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $240.00 $240.00 $10,880.00 $880.00 $7,440.00 $8,320.00
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 $80.00 $2,560.00 $2,640.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 $320.00 $1,760.00 $2,080.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $160.00 $160.00 $10,880.00 $400.00 $7,680.00 $8,080.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 $320.00 $1,760.00 $2,080.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 $320.00 $1,280.00 $1,600.00 Task 5 - Prepare Presentations/Attend Meetings $1,280.00 $0.00 $160.00 $160.00 Total Labor $10,880.00 $640.00 $5,760.00 $6,400.00
TOTAL $32,640.00 $1,920.00 $20,880.00 $22,800.00
TOTAL PAID TO DATE $20,880.00
BALANCE OUTSTANDING $1,920.00
BUDGET REMAINING $9,840.00
ayment is due within 30 days of receipt of invoice, interest on the unpaid balance will accrue beginning with th 1st day at the rate of 1.5 percent per month or the maximum interest permitted by law. whichever is lesse Page: 5