Cities Index.
Attachment 1 – Sonoma County Water Agency Water Transmission FY 2023/24 Draft Budget and Rates

Santa Rosa City Council
March 28, 2023

Document
Attachment 1 – Sonoma County Water Agency Water Transmission FY 2023/24 Draft Budget and Rates
Meeting
March 28, 2023
Body
Santa Rosa City Council
Original file
2.9 MB
Text extracted from the city's file for reading and search. Open the original on legistar.granicus.com. That file is the official record.

S
onoma Water i Draft 2/28/2023
Water Transmission FY 20 23/2024 Draft Budget and Rates This draft FY 2023/2024 Water Transmission Budget has been developed based on the prior 12-months of water deliveries of 41,847 Acre-Feet (AF). Due to the drought and the community’s water conservation measures, budgeted deliveries are 8.5% less than FY 2022/2023. The draft budget is shown in the table below:

F
Y 2023/2024 Draft Budget Financial Summary compared to FY 2022/2023 Adopted Budget: Factors affecting the rate increase:

Operations and Maintenance (O&M)
• 8.5% decrease in budgeted deliveries.
• 1% increase in water sales revenue
• FY 2023/2024 budgeted expenditures: $40.41 million. An increase of $1.73 million or 4.5%. • $640,000 in Use of Fund Balance.
• Budgeted expenditures increase is attributable to the tank recoat program, SCADA improvements, and large equipment purchases.
• Must have sufficient net operating revenues to meet 1.15x debt coverage bond covenant requirement. • Water Sales Revenue Shortfall:
o FY 2021/2022: $1 million; FY 2022/2023: estimated $4 million to $6 million below budget. • Actual Expenditures plus Encumbrances compared to Budgeted Expenditures tracked very closely in FY 2 021/2022 and are anticipated to align closely in FY 2022/2023 with the exception of several projects that experienced unforeseen delays: Cathodic Protection, Tank Maintenance Program, SCADA improvements. Unspent budget from these projects is rolled forward to subsequent budget years to avoid being included in the rate calculation more than once. The FY 2023/2024 budget shows increased costs for these projects over prior years.
• Budgeted projects have been thoroughly reviewed and edited, and represent the budgeted work that can reasonably occur in FY 2023/2024. Budgeted maintenance projects are a priority and cannot be deferred further.
• 10.70% rate increase compared to 18.97% increase in FY 2022/2023.

FY22-23 FY23-24
Budget
(in Millions)
Budget
(in
Millions)
Change
(in Millions)
Operations and Maintenance $38.68 $40.41 $1.73
Capital Projects $13.25 $12.28 ($0.97)
Biological Opinion Compliance, Water
Supply Planning, Water Conservation $13.89 $9.78 ($4.11) Debt Service $6.01 $5.83 ($0.18)
Totals $71.83 $68.30 ($3.53)
Grants, Use of Fund Balance, and Bond
Proceeds $15.31 $18.15 $2.84
DRAFT
Attachment 1

Sonoma Water ii Draft 2/28/2023
Sonoma Water Identified certain maintenance projects that could be deferred. The O&M budget has been reduced by deferring $2.4 million in maintenance projects: Deferring maintenance projects reduced the O&M rate increase from more than 20% to 10.70%. Deferred projects include:
• DeMuth Property Hydrogeologic Investigation
• Dive Services
• Emergency Inventory Procurement
• Hearn Avenue Electrical Project
• pH and Chlorine Systems Assessment
• Reduced Emergency Inventory Procurement
• Regional Water Emergency Prep Program Development
• Regional Water Supply Resiliency Study
• Russian River Operations Support
• Transmission System Condition Assessments
• Transmission System Monitoring Master Plan

Capital Projects
Capital Projects: FY 2023/2024 draft budgeted expenditures of $12.28 million decreased by $970,000 or 7%.

Hazard mitigation projects ($6.3 million) and infrastructure improvement projects/drought resiliency projects ($5.9 million) are fully funded by Water Revenue Bonds, grants, and existing rolled forward Fund Balance.

Investing in Infrastructure:

Construction: Hazard Mitigation Projects $5,468,900
Ely BPS Flood Control & Electrical Upgrade 600,000 RDS Pump and Motor Control Center Replacement 2,300,000 Wilfred Booster Station 2,568,900

Design: Hazard Mitigation Projects $866,300
Bennett Valley Fault Crossing 566,300
Seismic Retrofit of Storage Tanks 300,000

Construction: Other Capital Projects $5,389,600
Occidental Road Well 3,041,600
Warm Springs Dam Hydroturbine Retrofit 2,050,000 Wohler Bridge Fiber Optic Cable 298,000

Design Other Capital Projects $550,785
Mirabel/Wohler Storage Building 157,200 Ralphine Tanks Flow Thru Conversion 264,185 Sebastopol Road Well 79,400
South East Greenway Acquisition 50,000

DRAFT

Sonoma Water iii Draft 2/28/2023
Biological Opinion
• 8.5% decrease in deliveries
• 3% increase in revenue
• 44% decrease in expenditures
• $3.50 million in Use of Fund Balance reduces rate increase from 266% to 9.94% • 9.94% rate increase compared to -75.35% increase in FY 2022/2023 when $7.5 million in Use of Fund Balance was budgeted.

Dry Creek Habitat Enhancement Phase 4 design activities have been completed. The U.S Army Corps anticipates construction of Phase 4 in the summer of 2023. Right-of-way activities are ongoing for all three phases. Sonoma Water has pending expenditure credits under review by the U.S. Army Corp. The credits may offset a portion of Sonoma Water’s 35% cost share for Phases 4, 5, and 6 construction costs. The draft budget includes the addition of design, right-of way, and construction for Dry Creek Habitat Enhancement Phase 4 inlet 13B, ongoing costs for Phases 5 and 6 design, right-of way, and construction and other required biological opinion activities.

Among other ongoing biological opinion activities, Sonoma Water staff are currently working on revisions in anticipation of recirculating the Draft EIR in 2023.

In FY23/24, a $150,000 match contribution has also been included for the Potter Valley Project Russian River Water Forum Grant application submitted to DWR under the 2022 Urban Community Drought Relief Grant Program. If the grant is awarded additional match would also be provided by the County of Sonoma, County of Mendocino, and the Sonoma Water Russian River Projects Fund.

Water Conservation
• 8.5% decrease in deliveries
• 0% increase in revenue
• 3% decrease in expenditures
• $418,000 in Use of Fund Balance. Reduces rate increase from 34.88% to 13.85%. o FY 2022/2023 Adopted Budget used $568,000 in Fund Balance to reduce the Water Conservation Rate Increase to 6.89%.
o Without the Use of Fund Balance in the FY 2022/2023 Adopted budget, the Water Conservation rate increase would have been 34.88%.
o Due to decreased deliveries, there is limited capacity to use Fund Balance in the FY 2023/2024 Adopted Budget.
• 13.85% rate increase compared to 6.89% increase in FY 2022/2023 when $568,000 in Use of Fund Balance was budgeted.

Programmatic Summary an d Effect on Rate Increase:

Sonoma Water and the Sonoma Marin Saving Water Partnership plan to continue work on drought related initiatives and corresponding outreach and education activities.

There was an expansion of programs (at the direction of the Water Contractors) to respond to the historical drought conditions after rates were set in FY21/22 and FY22/23. The costs of these programs were not captured in the previous years’ rates and the expenses we therefore paid for by fund balance. These programs included a $66,000 increase for Drought kits and prize giveaways, as well as $40,000 in printed drought outreach materials, $195,000 in advertising, and $28,000 in ad-design services (photography, videos, and graphic design).

This year we are also proposing to apply for and if awarded administer a Department of Water Resources (DWR) grant through the Urban Community Drought Relief Grant Program. Pursuing this grant does increase the proposed rate in the subfund for FY23/24 by approximately 8.5% due to upfront match costs, which includes not only programmatic match, but also match from grant administration staff expenses that disproportionately fall DRAFT

Sonoma Water iv Draft 2/28/2023
in FY23/24 (due to required agreements needed with the Partners) that are only 55 percent reimbursable. The programmatic costs also hit FY23/24 disproportionally due to the match requirements of the grant program.

However, the grant ultimately covers 75% of total programmatic costs and the added benefit to the water contractors vastly outweighs the extra 8.5% rate increase that would be incurred. Additional benefits that will be realized for this cost include a commercial, industrial, and institutional (CII) sector Spatial Analysis to provide landscape area measurements (and non-functional turf measurement) needed for the CII standard of the statewide water conservation framework, a regional WaterSmart Plant Kit Program to convert 1.2 million square feet of turf to low water use landscaping, residential Water Smart Home Assessments, and additional QWEL trainings and development of a new QWEL greywater manual. Grant funds will be able to offset costs we would have incurred anyway for ongoing regional programs such as QWEL trainings, the annual Eco-Friendly Garden Tour, and the WaterSmart Plant Label Program, with some small expansion of this program included in the grant in direct support of marketing the WaterSmart Plant Kit program. Overall, however, these ongoing program costs will be significantly lower for the three-year period of the grant. Lastly, we are maximizing pre-award cost match to keep the programmatic match costs low.

The Water Conservation Subfund budget is otherwise only inclusive of what is needed to maintain existing successful regional programs of the Partnership, including the Water Education Program, Green Business Program, Garden Sense Program, Water Loss Working Group and Validation Services, QWEL Program, DIY Toolkit, Eco-Friendly Garden Tour, Russian River Friendly Landscaping, and the WaterSmart Plant Label Program.

Additional funding is included to sustain the Partnership regional outreach campaigns, website, and regional representation for the developing Urban Water Use Objectives. No expanded services would be included for the plant label program ($10,000) without the grant, and no reimbursement of future program costs for these ongoing programs would occur. The table below summarizes the budget and rates with and without the DWR grant.

DRAFT

Sonoma Water v Draft 2/28/2023

FY 2022/2023 Water Conservation Rate: $47.50
Budget and Rates without
DWR Grant
Budget and Rates with DWR
Grant DWR Grant Benefits (over 3 years)
Programs included: Programs included: Additional Programs baseline projects baseline projects
Spatial Analysis to meet new State
Standards

Additional Water saving programs for
residents
Plus: Additional QWEL Trainings
Cll Spatial Analysis QWEL greywater manual
WaterSmart Plant Kit Program

Water Smart Home
Assessments ~$3.8M in offsetting revenue
Additional QWEL trainings for new and existing programs FY 2023/2024 Expenditures FY 2023/2024 Expenditures
$2,591,500 $4,615,242 Conservatively, contingent on a number of FY2022/2023 vs FY 2023/2024 FY2022/2023 vs FY 2023/2024 factors, 3% rate increases on average are ($2,175,924) ($152,182) anticipated over three future fiscal years. % Decrease from PY % Decrease from PY
-46% -3%
FY 2023/2024 Rate FY 2023/2024 Rate
$49.92 $54.08
FY 2023/2024 Rate Increase FY 2023/2024 Rate Increase

5.07% 13.85%
Total Water Transmission
Rate Increase
Total Water Transmission
Rate Increase

10.17% 10.56%
Net effect of Water Conservation Rate Increase on Total Water Transmission Rate Increase

0.39%
Debt Service
Debt Service Expenditures decreased by $180,000 or 3% resulting from the issuance of $15M 2022 Water Revenue Bonds offset by the refinancing of the 2012 Water Revenue Bonds. S&P assigned a rating of “AAA” to the 2022 Bonds, the highest possible rating, which represented an affirmation of the existing credit rating on parity bonds. The 2022 Bonds were issued at a total interest cost of 3.32%. The refunding of the 2012 Bonds generated $311,771 of present value savings or approximately 4.04% of the par amount refunded.

Summary
The draft proposed budget for FY 2023/2024 is based on accomplishing the required elements of the Biological Opinion, maintenance of facilities, and continued implementation of hazard mitigation and reliability projects, and projects responsive to the drought conditions.

Sonoma Water recognizes the profound impact of natural hazards and the COVID-19 pandemic to many residents, businesses, and our retail water contractors throughout our county and beyond. In response to the far-reaching financial hardships, Sonoma Water made a conscious effort to keep rate increases at a minimum while continuing to maintain system reliability and public health and safety. Sonoma Water has consistently kept DRAFT

Sonoma Water vi Draft 2/28/2023
average rate increases at 4.62% and 4.68% over the past five and ten years respectively, lower than a 5% average rate increase, even with the 6.05% rate increase in FY 2022/2023.

Rate increases following the events impacting the county averaged 4.26% and were as follows:

Rate Increase History
Budget Year
Following Event
Rate
Increase
Tubbs Fire October 2017 FY 2018/2019 3.67%
Floods January-February 2019 FY 2019/2020 4.60%
Kincade Fire October 2019 FY 2020/2021 5.30%
Covid March 2020 FY 2021/2022 3.47%

Sources of revenue include water sales and charges for services, federal and state grants, existing fund balances, contributions, interest, and bond financing.

Revenues
FY 2023/2024
Draft Budget
Increase/(Decrease)
over FY 2022/2023
Water Sales & Charges for Services 50,251,488 1%
Operating Grants 1,764,210 5,348%
Capital Grants 1,225,000 (75%)
Contributions 303,965 (75%)
Interest & Investment Earnings 1,004,962 677%
TOTAL 54,549,625 (2%)

Fund Balance FY 2023/2024 Draft
Budget
Increase/(Decrease)
over FY 2022/2023
Use of Fund Balance: 37% from
Operating Funds; 63% from Capital
Funds 12,297,157 26%

Bond Funds FY 2023/2024
Draft Budget
Increase/(Decrease)
over FY 2022/2023
Use of Bond Funds 2,860,000 (56%)
Budget Requirements:
• Maintain 3-month operating reserve.
• Maintain 1.15x debt coverage bond covenant.
• Rates collect 1.15x debt service in accordance with the provisions of the Water Transmission System Master Ordinance.

Budget and Rate Reduction Measures reflected in the March 1 draft budget:
• Decreased rate increase from 20% to 10.56% in part by deferring $2.4 million in operations and maintenance projects. Sonoma Water has been deferring millions of dollars of capital and maintenance projects annually to reduce rate increases. The $2.4 million in deferred maintenance projects in this FY 2023/2024 Draft Budget is the maximum that can reasonably be deferred. • Total expenditures budget is 4.91% lower than FY 2022/2023. • Capital Program is fully funded by the 2022 sale of $15 million in Revenue Bonds, grants, and fund balance. No contribution from Water Transmission O&M Fund.

DRAFT

Sonoma Water vii Draft 2/28/2023
• The contractors on the Santa Rosa AQ maintained their discretionary capital charge at $11 resulting in a rate of 10.56%. The contractors on the Petaluma AQ have decreased their capital charge to $0 reducing their rate to 9.42%. The contractors on the Sonoma AQ reduced their capital change from $38 to $34.90 reducing their rate to 10.56%.
• Use of $18.15 million in grants, fund balance, and bond proceeds reduces the rate increase from 51.44% to 10.56%.
o Use of Fund Balance: $12.3 million. Unable to use more prudent reserve and remain compliant with debt coverage covenant.
o Grant revenue: $2.99 million
o Bond proceeds: $2.86 million
• Water Transmission System Total Cost per Gallon is $0.004.

Factors affecting the Rate Increase:
• 8.5% decrease in budgeted water deliveries.
• Two years with actual water deliveries between 4% and an estimated 9% less than budget. • 2.5% decrease in total revenue.
• 4.5% increase in O&M costs.
• 77% of the rate increase is attributable to the O&M budget, 14% to debt service, and 8% to the subfunds (Water Management, Watershed Planning and Restoration, Recycled Water and Local Supply, and Water Conservation).
• The net effect of the Water Conservation Rate Increase (including or excluding the proposed Department of Water Resources grant) on the Total Water Transmission Rate Increase is 0.39%. • Increases in material and equipment costs for aging infrastructure and priority maintenance projects that can no longer be deferred, continued supply chain disruptions, long lead times on equipment, and the current inflationary environment are putting upward pressure on the Water Transmission System budget.

DRAFT

Sonoma Water viii Draft 2/28/2023
Proposed rates are shown in the table below:

Charge / Aqueduct Santa Rosa Petaluma Sonoma
Deliveries (Acre-Feet) 41,847
O&M $903.30 $903.30 $903.30
Water Management Planning $0.00 $0.00 $0.00
Watershed Planning & Restoration $35.96 $35.96 $35.96
Recycled Water and Local Supply $0.00 $0.00 $0.00
Water Conservation $54.08 $54.08 $54.08
Total O&M $993.34 $993.34 $993.34
Storage & Common Bond/Loan Charges $168.75 $168.75 $168.75 Sonoma Aqueduct Bond/Loan Charge $151.68
Prime Contractors $1,162.09 $1,162.09 $1,313.77

Discretionary Charges
Capital Charges - to build fund balance for
future projects $11.00 $0.00 $34.90

Total Prime Contractors $1,173.09 $1,162.09 $1,348.67
Total Overall Increase: 10.56% 9.42% 10.56%

• Deliveries: (Budget Packet Pages 9-14):

FY 2021/2022
Budget
FY 2021/2022
Actuals
FY 2022/2023
Budget
FY 2022/2023
Actuals
FY 2023/2024
Estimated Budget
3-year Average 3-year average 12-months
46,095.00 44,236.90 45,748.00 41,847 41,847

4% less than
budget

8.5% less than
budget
FY22-23 vs FY23-24
Budget
Variance (1,858.10) (3,901)

FY 2022/2023 Budgeted Deliveries vs FY
2023/2024 Budgeted Deliveries

8.5% decrease
FY 2021/2022 Actuals vs FY 2022/2023 Estimated
Actuals

5.4% decrease

DRAFT

Sonoma Water ix Draft 2/28/2023

• Operations and Maintenance (O&M) – Water Transmission O&M Fund (Budget Packet Pages 15-24):
o In accordance with the Restructured Agreement for Water Supply:
 The rate is calculated by dividing operations and maintenance expenditures (less specific cash and noncash revenues and expenditures) by budgeted deliveries.

O&M Fund
Increase
(Decrease)
in Dollars
Percent
Change Description
Rate per AF $87.28 10.7% Increase due to lower than budgeted water sales resulting in a lower delivery figure for budgeting.

Revenue $779,000 1.6%
Increase in revenue is attributable to the rate increase. Using an estimated $1,500,000 in Prudent Reserve in FY22/23 to cover lower than anticipated deliveries and $640,000 of fund balance in FY23/24 to reduce rate increase.

Expenditures $184,000 .3%
Increase is attributable to an increase in maintenance projects (cathodic protection, tank recoats, pump and valve replacements, chlorine and pH improvement projects, SCADA upgrades), studies (Regional Water Supply Resiliency, Watershed and Water Quality Seismic Mitigation Studies, Local Hazard Mitigation Plan), and emergency inventory procurement.

Factors affecting the O&M rate:

O&M Fund
Expenditures
Increase
(Decrease)
in Dollars
Percent
Change Description
Labor $885,000 5.1%
Increase is attributable to an increase in labor costs for maintenance projects (cathodic protection, tank recoating program, tank maintenance program, pump and valve replacements,
electrical projects, chlorine and pH improvement projects, SCADA upgrades), studies (Regional Water Supply Resiliency, Watershed and Water Quality Seismic Mitigation Studies, Local Hazard Mitigation Plan), emergency inventory procurement, and mitigation monitoring for recently completed FEMA projects, offset by decrease in labor for deferred maintenance projects.

Power $750,000 21.4%
Increase due to elevated energy production and transmission costs caused by drought, geopolitical events, and supply chain constraints.

Chemicals $75,000 10.7% Increase due to Santa Rosa Plain Well activation.

Testing/Analysis $50,000 33.3%
Increase associated with expanded sampling and analysis tied to the Santa Rosa Plain Wells Projects as well as additional Perfluoroalkyl and Polyfluoroalkyl Substances (PFAS) testing.

Contract
Services ($510,000) -4.4%
Decrease attributable to $1.36M in deferrals. Decrease offset by increased maintenance project costs attributable to Tank Maintenance and Tank Recoat Projects.

Maintenance -
Equipment ($411,000) -12.5% Decrease attributable to lower budgeted expenses and $380,000 in deferrals.

Small Tools -
Instruments $50,000 50.0% Increase reflects five-year average expenditures.

Operating
Transfers ($276,000) -2.7%
Operating Transfers (OT’s) move revenue generated by rates into respective funds (debt service funds, subfunds, aqueduct capital funds and Common Facilities) and maintain appropriate fund balance.

DRAFT

Sonoma Water x Draft 2/28/2023
• Subfunds: (Budget Packet Pages 25-34):
o Subfund rates are calculated by dividing subfund expenditures minus grant revenue by budgeted water deliveries.
o W ater Management Planning:
 Expenditures are for Urban Water Management Planning (UWMP) which is required to be updated every five years.

Water
Management
Planning
Increase
(Decrease)
in Dollars
Percent
Change Description
Rate per AF ($0.20) -100.0%
Fiscal Year 2022/2023 rate is $0.20. Fund is for Urban Water Management Plan updates and the Annual Water Supply &
Demand Assessment. Past rate increases have accumulated fund balance and allow rate to be set at $0 in FY23/24. Current Urban Water Management Plan was submitted in Fiscal Year 2021.

Revenue ($6,000) -52.0% Using an estimated $100,000 in fund balance to decrease rate to $0 resulting in lower revenue.

Expenditures $25,000 33.3%
Budget increase is due to staff time related to the annual water supply and demand assesment. Budget request is for follow-up meetings, responding to State Department of Water Resources and contractor requests, tracking regulatory compliance changes, and coordinating with climate adaption strategic planning efforts.

o W atershed Planning and Restoration:
 Expenditures are for planning, design, and implementation of watershed restoration projects and projects required under the Biological Opinion.

Watershed
Planning and
Restoration
Increase
(Decrease)
in Dollars
Percent
Change Description
Rate per AF $3.25 9.9%
Fiscal Year 2022/2023 rate is $32.70. Rate increase is primarily a result of an 8.5% decrease in deliveries. Rate of $120/AF based on $5M in expenditures and 41,847 AF is reduced to $35.96/AF by using $3.5 million in fund balance.

Revenue $47,000 2.9% Increase due to subfund rate increase offset by use of fund balance to reduce and smooth overall rate increase.

Expenditures ($3,992,000) -44.4%
Decrease in expenditures is a result of reduced budgeted cost share due to U.S. Army Corps credits for Sonoma Water’s share of costs for construction of Dry Creek Habitat Enhancement phases 4, 5, and 6. Budget includes addition of the PVP RR Water Forum Two Basin Solution Phase 2 - DWR 2022 Urban Community
Drought Relief Grant Program match, and ongoing costs for Dry Creek Habitat Enhancement Phases 4, 5, 6, and phase 4 inlet 13B and other required biological opinion activities.

DRAFT

Sonoma Water xi Draft 2/28/2023

o R ecycled Water and Local Supply:
 Expenditures are for planning, design, and implementation of recycled water and local supply projects. The fund previously included water contractor projects under the Local Recycled Water Tier 2 (LRT2) Program.

Recycled Water
and Local Supply
Increase
(Decrease)
in Dollars
Percent
Change Description
Rate per AF ($0.50) -100.0% Fiscal Year 2022/2023 rate is $0.50. Due to accumulated fund balance budget reduces rate to $0 in FY23/24.

Revenue ($19,000) -75.2% Using an estimated $56,000 in fund balance to decrease rate to $0 resulting in lower revenue.

Expenditures $0 0.0%
No increase anticipated over FY2022-2023 budget. Expenditures are for Sonoma Water's share of Groundwater Sustainability Agencies' budgets.

Water Conservation:
 Expenditures are for water use efficiency projects, outreach, and education.

Water
Conservation
Increase
(Decrease)
in Dollars
Percent
Change Description
Rate per AF $6.58 13.8%
Fiscal Year 2022/2023 rate is $47.50. Rate increase is primarily a result of an 8.5% decrease in deliveries. Rate of $63.06/AF based on $2.6M of net expenditures and 41,847 AF is reduced to $54.08/AF by using $418,000 in fund balance.

Revenue $14,000 0.3% Increase due to subfund rate increase offset by use of fund balance to reduce and smooth overall rate increase.

Expenditures ($152,000) -3.2%
Decrease is associated with offsetting grant revenue from DWR Urban Community Drought Relief Grant Program. Expenditures used to implement water use efficiency, outreach and education projects, address drought conditions and ongoing water
conservation needs, and pass-through grant funds to water contractors and other partners.

• Storage, Common, and Sonoma Bond/Loan Charges: (Budget Packet Pages 45-59):
o The rates are calculated by dividing the annual debt service and reserve requirements (2015A, 2019A, and 2022A Water Revenue Bonds) by water deliveries.

Storage and
Common
Bond/Loan
Charges
Increase
(Decrease)
in Dollars
Percent
Change Description
Storage
Bond/Loan
Charge
$2.59 9.8%
Fiscal Year 2022/2023 rate is $26.55. Rate is based on revenue requirement for debt service divided by water deliveries. Total Debt service lower than previous year due to savings associated with refunding in the 2022 Revenue Bond Issuance. Rate increase is due to decrease in budgeted water deliveries.

DRAFT

Sonoma Water xii Draft 2/28/2023
Storage and
Common
Bond/Loan
Charges
Increase
(Decrease)
in Dollars
Percent
Change Description
Common
Bond/Loan
Charge
$13.05 10.3%
Fiscal Year 2022/2023 rate is $140.41. Rate is based on revenue requirement for debt service divided by water deliveries. Total Debt service lower than previous year due to savings associated with refunding in the 2022 Revenue Bond Issuance. Rate increase is due to decrease in budgeted water deliveries.

Sonoma
Aqueduct
Bond/Loan
Charge
$20 15.0%
Fiscal Year 2022/2023 rate is $151.68. Sonoma Aqueduct pays an additional revenue bond charge for the bonds associated with Sonoma Booster Station Electrical Upgrade and Pumping Reliability Project, Bennett Valley Fault Crossing Project, and other Creek Crossing Projects on the Aqueduct. Total Debt service lower than previous year due to savings associated with refunding in the 2022 Revenue Bond Issuance. Rate increase is due to decrease in budgeted water deliveries.
***S&P assigned a rating of “AAA” to the 2022 Bonds, the highest possible rating, which represented an affirmation of the existing credit rating on parity bonds. The 2022 Bonds were issued at a total interest cost of 3.32%. The refunding of the 2012 Bonds generated $311,771 of present value savings or approximately 4.04% of the par amount refunded.

Aqueduct Capital Charge: (Budget Packet Page 1):
o A discretionary charge is added by the water contractors to build fund balance for future aqueduct capital projects and to provide rate stabilization capacity. o The FY 2022-2023 draft budget includes a $11 per Acre-Foot charge for the Santa Rosa Aqueduct, a $12 per Acre-Foot charge for the Petaluma Aqueduct, and a $38 per Acre-Foot charge for the Sonoma Aqueduct.
o The FY 2023-2024 draft budget includes a $11 per Acre-Foot charge for the Santa Rosa Aqueduct, a $0 per Acre-Foot charge for the Petaluma Aqueduct, and a $34.90 per Acre-Foot charge for the Sonoma Aqueduct.

• Overall Draft Proposed Rate Increases: (Budget Packet Pages 1-8):
o 10.56% (Santa Rosa Aqueduct); 9.42% (Petaluma Aqueduct); 10.56% (Sonoma Aqueduct) o FY 202
3/ 2024 budgeted deliveries are based on 12 months of deliveries (41,847AF). FY 2023/2024 budgeted deliveries are 8.5% less than FY 2022/2023 budgeted deliveries. o Th e FY 2023/2024 budget accommodates an increase in maintenance projects (cathodic protection, pump and valve replacements, chlorine and pH improvement projects, tank recoats), studies (Regional Water Supply Resiliency, Watershed and Riverbank Filtration Water Quality Studies), emergency inventory purchases, Biological Opinion Flow EIR and Dry Creek Habitat Enhancement design and right- of-way for phases 4 inlet 13B, 5, and 6, and construction for phases 4, and 5, two DWR the Urban Community Drought Relief Grant Programs, and investment in hazard mitigation and other capital infrastructure projects.

DRAFT

Sonoma Water xiii Draft 2/28/2022
FY 2023-2024 Capital Projects (Budget Packet Pages 35-44):

DRAFT
Sonoma County Water Agency
Fiscal Year 2023/2024 Draft Water Transmission Budget and Rates Budget Packet Page
Rates
Prime Contractor Rates Summary 1-2
Water Charges Per Acre-Foot 3
Revenue Summary 4
Water Rates 5
O&M Rate 6
Line Item Rate Comparison 7
Russian River Projects and Conservation Charges 8
Deliveries
Deliveries (36 Mo) 9
Deliveries (12 Mo) 10
Deliveries and Revenue - All Aqueducts 11
Deliveries and Revenue - Santa Rosa Aqueduct 12
Deliveries and Revenue - Petaluma Aqueduct 13
Deliveries and Revenue - Sonoma Aqueduct 14
Agency O&M Fund
Agency Fund Cash Summary 15-18
Major Services and Supplies Expenditure Items 19
Equipment Maintenance, Contracts, Consulting Services 20-21 Contract Services & Contributions Project Information 22-24 Subfunds
Water Management Subfund 25
Watershed Planning and Restoration Subfund 26-27
Recycled Water and Local Supply Subfund 28-29
Water Conservation Subfund 30-31
Subfund Contract Services 32-34
Facilities and Other Funds
Santa Rosa Aqueduct Capital Fund 35-36
Petaluma Aqueduct Capital Fund 37-38
Sonoma Aqueduct Capital Fund 39
Storage Facilities Cash Summary 40-41
Common Facilities Cash Summary 42-43
North Marin Water Deposit Fund 44
Bonds and Loans
State Revolving Loan Debt Service Fund 45
State Revolving Loan Reserve Fund 46
Storage Bonds 2012 Cash Summary 47
Common Bonds 2012 Cash Summary 48
Sonoma Bonds 2012 Cash Summary 49
Storage Bonds 2015 Cash Summary 50
Common Bonds 2015 Cash Summary 51
Sonoma Bonds 2015 Cash Summary 52
Common Bonds 2019 Cash Summary 53
Sonoma Bonds 2019 Cash Summary 54
Storage Bonds 2022 Cash Summary 55
Common Bonds 2022 Cash Summary 56
Sonoma Bonds 2022 Cash Summary 57
Bond & Loan Charges 58-59
Fund Balances and Operating Transfers 60
DRAFT
Fiscal Year 2023/2024 Prime Contractor Rates Summary
Santa Rosa Petaluma Sonoma
Aqueduct Aqueduct Aqueduct FY22-23
Percent
Change
SR Pet Son
O&M Charge [4.2] 903.30 903.30 903.30 $816.03 $816.03 $816.03 10.70% Water Management Planning Sub-charge [4.13] 0.00 0.00 0.00 $0.20 $0.20 $0.20 -100.00% Watershed Planning/Restoration Sub-charge [4.14] 35.96 35.96 35.96 $32.70 $32.70 $32.70 9.94% Recycled Water & Local Supply Sub-charge [4.15] 0.00 0.00 0.00 $0.50 $0.50 $0.50 -100.00% Water Conservation Sub-charge [4.16] 54.08 54.08 54.08 $47.50 $47.50 $47.50 13.85% O&M Charge 993.34 993.34 993.34 $896.93 $896.93 $896.93 10.75% Storage and Common Bond & Loan Charges 168.75 168.75 168.75 $153.11 $153.11 $153.11 10.22% Sonoma Aqueduct Bond Charge 151.68 $131.87 15.0%
PRIME CONTRACTORS $1,162.09 $1,162.09 $1,313.77 $1,050.04 $1,050.04 $1,181.90 10.67% Capital Charges - to build fund balance
for future projects 11.00 0.00 34.90 $11.00 $12.00 $38.00 0% PRIME CONTRACTORS 11.00 0.00 34.90 $11.00 $12.00 $38.00 0% TOTAL PRIME CONTRACTORS $1,173.09 $1,162.09 $1,348.67 $1,061.04 $1,062.04 $1,219.90 10.56% Increase from Fiscal Year 2022/2023 10.56% 9.42% 10.56% 9.73% 9.83% 10.18% With No Capital Charge 9.52% 9.42% 7.69%
Deliveries:
12-month 36-month
FY14-15 46,000
FY15-16 50,590
FY16-17 40,524
FY17-18 41,446
FY18-19 41,768
FY19-20 43,870
FY20-21 43,707
FY21-22 46,095
FY22-23 45,748
FY23-24 41,847
CHARGE PER ACRE FOOT:
3/1/2023
1 DRAFT
Fiscal Year 2023/2024 Prime Contractor Rates Summary
CHARGE PER ACRE FOOT:

Petaluma AQ

NMWD NMWD
Percent
Change
FY23-24 FY22-23
O&M Charge [4.2] 903.30 $816.03 10.70%
Water Management Planning Sub-charge [4.13] 0.00 $0.20 -100.00% Watershed Planning/Restoration Sub-charge [4.14] 35.96 $32.70 9.94% Recycled Water & Local Supply Sub-charge [4.15] 0.00 $0.50 -100.00% Water Conservation Sub-charge [4.16] 54.08 $47.50 13.85% O&M Charge 993.34 $896.93 10.75%
North Marin Bond & Loan Charge [4.9] 93.16 $75.61 23.21% Russian River Conservation Charge [4.18 (a)] 137.33 $115.36 19.04% Russian River Projects Charge [4.18 (b)] 15.79 $13.92 13.41% TOTAL NMWD $1,239.61 $1,101.82 12.51%
Rates Rate Increase
Town of Windsor $1,173.09 10.56%
Town of Windsor (Diverted Water) $90.03 11.28%
NMWD 1,239.62 12.51%
MMWD $1,455.25 11.25%
3/1/2023
2 DRAFT
SANTA
ROSA

AQUEDUCT
% INCR.
(DECR.)

PETALUMA

AQUEDUCT
% INCR.
(DECR.)
SONOMA

AQUEDUCT
% INCR.
(DECR.)
2023 - 2024 1173.09 10.56% 1162.09 9.42% 1348.67 10.56% 2022 - 2023 1061.04 6.05% 1062.04 6.15% 1219.90 6.52%
2021 - 2022 1000.46 3.47% 1000.46 3.47% 1145.18 3.43%
2020 - 2021 966.95 5.30% 966.95 5.30% 1107.21 5.57%
2019 - 2020 918.30 4.60% 918.30 4.60% 1048.80 4.77%
2018 - 2019 877.88 3.67% 877.88 3.67% 1001.06 5.98%
2017 - 2018 846.78 4.98% 846.78 4.98% 944.56 5.58%
2016 - 2017 806.59 5.98% 806.59 5.98% 894.62 6.94%
2015 - 2016 761.05 4.16% 761.05 4.16% 836.55 5.46%
2014 - 2015 730.68 3.60% 730.68 3.60% 793.24 3.19%
2013 - 2014 705.30 4.95% 705.30 4.95% 768.75 3.84%
2012 - 2013 672.03 5.98% 672.03 5.98% 740.34 5.26%
2011 - 2012 634.11 5.00% 634.11 5.00% 703.33 4.28%
2010 - 2011 603.92 6.93% 603.92 6.93% 674.47 8.42%
2009 - 2010 564.78 19.88% 564.78 10.50% 622.11 27.95%
2008 - 2009 471.13 6.66% 511.13 10.71% 486.22 7.22%
2007 - 2008 441.70 2.41% 461.70 2.31% 453.49 2.46%
2006 - 2007 431.29 4.51% 451.29 4.30% 442.60 4.26%
2005 - 2006 412.68 2.53% 432.68 2.41% 424.53 2.44%
2004 - 2005 402.51 2.19% 422.51 2.08% 414.42 1.59%
2003 - 2004 393.89 1.65% 413.89 4.02% 407.95 5.30%
2002 - 2003 387.49 1.10% 397.90 3.61% 387.43 3.76%
2001 - 2002 383.29 15.88% 384.02 15.80% 373.38 16.41%

WATER TRANSMISSION SYSTEM
FY23-24 WATER CHARGES PER ACRE-FOOT

FOR PRIME CONTRACTORS
FISCAL
YEAR
A-2 3/1/2023
3 DRAFT
FY23-24 FY22-23 FY23-24
WATER CUSTOMER Budgeted Water
Use (Acre-Feet)
Rate
$/Acre-Foot
Proposed Rate
$/Acre-Foot Dollar Change Percent
Change
Santa Rosa Aqueduct 15,373 $1,061.04 $1,173.09 $112.05 10.56% Petaluma Aqueduct 8,034 1,062.04 1,162.09 $100.05 9.42% Sonoma Aqueduct 3,383 1,219.90 1,348.67 $128.77 10.56%
North Marin Water District 5,303 1,101.82 1,239.62 $137.81 12.51% Marin Municipal – Fourth
Off Peak 4,300 1,308.14 1,455.25 $147.11 11.25%
Marin Municipal –
Supplemental 3,639 1,308.14 1,455.25 $147.11 11.25%
Forestville Aqueduct 342 1,061.04 1,173.09 $112.05 10.56% Wholesale/Municipal 889 1,463.87 1618.394 $154.52 10.56% Surplus 47 1,076.32 1,192.01 $115.69 10.75%
Windsor 535 1,061.04 1,173.09 $112.05 10.56%
TOTAL 41,847

WATER TRANSMISSION SYSTEM
FY23-24 REVENUE SUMMARY CHART
3/1/2023
4 DRAFT
[x] ESTIMATED [ ] OFFICIAL CHARGE PER ACRE FOOT:

Santa Rosa Petaluma Sonoma
Aqueduct Aqueduct Aqueduct

PRIME CONTRACTORS
O&M Charge [4.2] $903.30 $903.30 $903.30
Water Management Planning Sub-charge [4.13] $0.00 $0.00 $0.00 Wat
ershed Planning/Restoration Sub-charge [4.14] $35.96 $35.96 $35.96 Recycled Water & Local Supply Sub-charge [4.15] $0.00 $0.00 $0.00 Water Conservation Sub-charge [4.16] $54.08 $54.08 $54.08 O&M Charge $993.34 $993.34 $993.34
Bond & Loan Charges - to pay for existing debt service
Storage Facilities Capital Charge [4.7] 29.14 29.14 29.14 Common Facilities Capital Charge [4.8] 139.61 139.61 139.61 Sonoma Aqueduct Facilities Capital Charges [4.6 b] 151.68 Total Bond & Loan Charges $168.75 $168.75 $320.43
Discretionary:

Aqueduct Capital Charges - to build fund balance for future projects Aqueduct Facilities Capital Charges [4.6 e] 11.00 0.00 34.90 LRT2 - included in Recycled Water & Local Supply Sub-Charge above.

TOTAL PRIME CONTRACTORS $1,173.09 $1,162.09 $1,348.67
Charge without LRT2 and voluntary AQ Capital Charge $1,162.09 $1,162.09 $1,313.77

OTHER AGENCY CUSTOMERS/WHOLESALE CHARGES
(WATER CO’S & PUBLIC AGENCIES)
O&M Charge $993.34 $993.34 $993.34
Capital Charges 168.75 168.75 320.43
Aqueduct Facilities Capital Charge [4.12] $456.30 $456.30 $304.62 TOTAL OTHER AGENCY CUSTOMERS/WHOLESALE CHARGES (4.12) $1,618.39 $1,618.39 $1,618.39 (120% OF HIGHEST PRIME)
FORESTVILLE 0.08
O&M Charge [4.2] * $903.30
Water Management Planning Sub-charge [4.13] -
Watershed Planning/Restoration Sub-charge [4.14] 35.96
Recycled Water & Local Supply Sub-charge [4.15] -
Water Conservation Sub-charge [4.16] 54.08
O&M Charge $993.34
Bond & Loan Charges - to pay for existing debt service
Aqueduct Facilities Capital Charges [4.6] 11.00
Storage Facilities Capital Charge [4.7] 29.14
Common Facilities Capital Charge [4.8] 139.61
Total Capital Charges $179.75
TOTAL FORESTVILLE $1,173.09
* Forestville Water District was exempt from Santa Rosa Aqueduct sub-charge from FY 06/07 to FY 16/17 [4.12].

NORTH MARIN WATER DISTRICT
O&M Charge $993.34 Note: N. Marin pays
North Marin Bond & Loan Charge [4.9] 93.16 bond and loan charge Russian River Conservation Charge [4.18 (a)] 137.33 in lieu of Capital Charge.

Russian River Projects Charge [4.18 (b)] 15.79
TOTAL NORTH MARIN WATER DISTRICT 1,239.62

FOURTH OFF-PEAK (MARIN MUNICIPAL)
Highest Prime on SR and PET AQ x 1.11 $1,302.13
Russian River Conservation Charge 137.33
Russian River Projects Charge 15.79
TOTAL FOURTH OFF-PEAK $1,455.25

SUPPLEMENTAL (MARIN MUNICIPAL)
Highest Prime on SR and PET AQ x 1.11 $1,302.13
Russian River Conservation Charge 137.33
Russian River Projects Charge 15.79
TOTAL SUPPLEMENTAL $1,455.25

SURPLUS
Non-Municipal / Municipal [4.11 (a)] $1,192.01 $1,192.01 $1,192.01 (120% of O&M Charge)
Town of Windsor $1,173.09
$1,173.09
The applicable section of the Restructured Agreement has been indicated in brackets.

Beginning in FY22/23 all water delivered to Town of Windsor is charged at the the Santa Rosa Aqueduct rate [4.17 (a)]. Town of Windsor pays all subcharges [4.13, 4.14, 4.15, and 4.16] on all water they divert from the Russian River using their equipment [4.17 (b)].

SONOMA COUNTY WATER AGENCY RATES FOR WATER DELIVERIES IN FY23-24 5 DRAFT
FY 2023-24 BUDGET

SONOMA COUNTY WATER AGENCY
Operations and Maintenance Rate Computation

O & M REVENUE REQUIREMENT
ESTIMATED FISCAL YEAR EXPENDITURES $57,263,297
685.02
LESS:

Depreciation Amortization 6,832,000
Investment Income, Interest on Pooled Cash, Charges for Services 249,895 Power Sales 100,000
PWRPA Pre-paid Expense - FY 08/09 Rate Reduction-One time only "Mandatory Prudent Reserve" charge
Use of Fund Balance 640,000
Recycled Water funds (Sub-object 7277) taken from special reserve 0 Transfers Out 10,019,899
REVENUE REQUIREMENT (Net Expenditures) $39,421,502

O & M ACRE FOOT BASE
DELIVERIES: 41,847.2
LESS:

Marin Municipal 7,938.9
Surplus (Irrigation) 47.3
TOTAL BASE DELIVERIES 33,861.0
O & M RATE COMPUTATION:

Rate = Revenue Requirement - (Marin Municipal Deliveries x 1.11 x 0.92568 x Highest Prime Rate on Petaluma or Santa Rosa Aqueduct - Subfunds)
Total Deliveries - Surplus Deliveries - Marin Muni Deliveries = 39,421,502 - (4,300.00 x 1112.84) - (3,638.90 x 1112.84) 41,847.2 - 47.3 - 7,938.9
* = 903.30
FY23-24
3/1/2023
6 DRAFT
FY22-23 FY23-24
(Actual) (Proposed) % Change
O&M Charge 816.03 903.30 10.70%
Water Management Planning Sub-Charge 0.20 0.00 -100.00% Watershed Planning/Restoration Sub-Charge 32.70 35.96 9.94% Recycled Water Sub-Charge 0.50 0.00 -100.00%
Water Conservation Sub-Charge 47.50 54.08 13.85%
Total O&M Charge 896.93 993.34 10.75%
Santa Rosa Aqueduct Rate
O&M Charge 896.93 993.34 10.75%
Aqueduct Facilities Capital Charges [4.6 e] 11.00 11.00 0.0% Storage Facilities Capital Charge [4.7] 26.55 29.14 9.76% Common Facilities Capital Charge [4.8] 126.56 139.61 10.31% TOTAL 1061.03 1173.09 10.56%
Petaluma Aqueduct Rate
O&M Charge 896.93 993.34 10.75%
Aqueduct Facilities Capital Charges [4.6 e] 12.00 0.00 -100.0% Storage Facilities Capital Charge [4.7] 26.55 29.14 9.76% Common Facilities Capital Charge [4.8] 126.56 139.61 10.31% TOTAL 1062.03 1162.09 9.42%
Sonoma Aqueduct Rate
O&M Charge 896.93 993.34 10.75%
Aqueduct Facilities Capital Charges [4.6 e] 38.00 34.90 -8.2% Storage Facilities Capital Charge [4.7] 26.55 29.14 9.76% Common Facilities Capital Charge [4.8] 126.56 139.61 10.31% Sonoma Aqueduct Facilities Capital Charges 131.87 151.68 15.02% TOTAL 1219.90 1348.67 10.56%
FY23-24
Proposed Water Rates
3/1/2023
7 DRAFT

SONOMA COUNTY WATER AGENCY

RUSSIAN RIVER CONSERVATION CHARGE COMPUTATION
FISCAL YEAR 2023-24
PROPERTY ASSESSMENT VALUES AS OF FY22-23:

TAX CODE ENTITY SECURED UNSECURED TOTAL VALUE
14000 Forestville Co Water District 515,933,061 2,302,623 $518,235,684 42800 City of Cotati 1,342,132,391 29,258,828 1,371,391,219 43500 City of Petaluma 11,842,325,315 468,775,648 12,311,100,963 43800 City of Rohnert Park 6,718,411,430 166,127,188 6,884,538,618 44500 City of Santa Rosa 28,489,889,874 912,923,827 29,402,813,701 45000 City of Sonoma 3,375,490,571 92,445,286 3,467,935,857 N/A Valley of the Moon Water District 4,215,365,914 19,985,195 4,235,351,109 TOTAL $56,499,548,556 $1,691,818,595 $58,191,367,151 Notes:
1 Total value of secured and unsecured property in service areas of Prime Water Contractors of Sonoma County (see above) $58,191,367,151 2 2016-17 Sonoma County tax rate per $100 of full cash value assessed for payment of Warm Springs Dam Project Obligations 0.007 3 Total tax levied on citizens residing in service areas of Prime Water Contractors of Sonoma County, i.e., (Line 1/100) x Line 2 $4,073,396
4 Total acre feet of water delivered to Prime Water Contractors of Sonoma County (excluding North Marin and Town of Windsor) plus deliveries to Forestville 29,660.34 during the prior 12 month period ending March 31.
5 Total Russian River Conservation Charge per Acre Foot (Line 3 / Line 4) $137.33 Russian River Projects Charge RR Conservation Charge
Historical calculations Historical calculations
For FY Calculated Actual Charge
06-07 17.02 $17.02 $48.33
07-08 21.4 $20.00 $52.70
08-09 25.08 $20.00 $58.44
09-10 24.68 $20.00 $57.70
10-11 24.4 $20.00 $74.62
11-12 23.44 $20.00 $72.27
12-13 20.38 $20.00 $72.08
13-14 14.72 $14.72 $63.30
14-15 8.72 $8.72 $63.90
15-16 12.39 $12.39 $69.38
16-17 12.96 $12.96 $78.73
17-18 13.08 $13.08 $105.78
18-19 9.13 $9.13 $109.75
19-20 8.34 $8.34 $102.09
20-21 8.68 $8.68 $106.12
21-22 10.63 $10.63 $115.94
22-23 13.92 $13.92 $115.36
23-24 15.79 $15.79 $137.33
3/1/2023
8 DRAFT

SCHEDULE OF WATER DELIVERIES BY AQUEDUCT
PAST 36 MONTHS / 12 MONTHS AVERAGE
DELIVERING AQUEDUCT Monthly
Santa Rosa Petaluma Forestville Sonoma Total
36 Jan-20 1,029.5 1,198.3 18.9 168.7 2,415.4
35 Feb-20 1,100.9 1,411.3 20.3 170.5 2,702.9
34 Mar-20 1,258.5 1,644.6 22.2 268.9 3,194.3
33 Apr-20 1,483.7 1,749.8 27.9 289.9 3,551.3
32 May-20 1,532.6 1,713.9 30.7 356.7 3,633.9
31 Jun-20 1,700.7 2,162.3 42.3 471.0 4,376.3
30 Jul-20 2,458.9 2,844.2 55.9 631.6 5,990.6
29 Aug-20 1,889.6 2,304.7 47.2 532.0 4,773.5
28 Sep-20 1,656.9 2,133.9 42.0 444.3 4,277.1
27 Oct-20 2,108.6 2,653.4 52.5 522.1 5,336.7
26 Nov-20 1,318.5 2,013.1 31.8 360.4 3,723.7
25 Dec-20 1,329.1 2,126.5 27.3 289.9 3,772.8
24 Jan-21 1,341.2 2,161.8 25.8 251.8 3,780.6
23 Feb-21 1,137.9 1,750.8 20.3 176.2 3,085.1
22 Mar-21 1,066.4 2,050.6 21.7 170.9 3,309.6
21 Apr-21 1,617.8 3,025.1 36.1 373.9 5,052.9
20 May-21 1,402.9 2,533.3 40.4 388.6 4,365.2
19 Jun-21 1,450.2 2,468.5 40.2 421.5 4,380.3
18 Jul-21 1,863.3 2,297.6 51.0 466.7 4,678.6
17 Aug-21 1,507.9 1,705.1 39.5 315.6 3,568.1
16 Sep-21 1,455.3 1,654.3 36.8 298.1 3,444.4
15 Oct-21 1,514.3 1,842.1 36.7 306.9 3,700.0
14 Nov-21 968.6 1,552.0 17.4 215.8 2,753.9
13 Dec-21 1,228.0 2,149.4 23.5 268.1 3,669.0
12 Jan-22 1073.2 1423.2 18.6 205.2 2,720.2
11 Feb-22 1041.5 1861.2 20.0 195.4 3,118.1
10 Mar-22 1227.5 2175.2 26.0 237.7 3,666.4
9 Apr-22 1233.9 2107.2 24.0 250.7 3,615.8
8 May-22 1649.3 2923.1 33.1 378.7 4,984.0
7 Jun-22 1448.3 2456.3 33.3 380.6 4,318.5
6 Jul-22 1415.9 1538.8 34.9 358.4 3,348.0
5 Aug-22 1752.9 1762.2 44.6 382.9 3,942.7
4 Sep-22 1459.2 1453.6 35.2 277.2 3,225.2
3 Oct-22 1430.9 1549.8 30.9 274.3 3,285.8
2 Nov-22 1132.2 1427.5 23.3 231.8 2,814.8
1 Dec-22 1091.1 1487.9 18.5 210.2 2,807.7
Total Deliveries 51,377.2 71,312.4 1,150.5 11,543.2 135,383.3 3-Year Annual Average 17,125.7 23,770.8 383.5 3,847.7 45,127.8 Past 12 Months 15,955.9 22,165.9 342.3 3,383.1 41,847.2 Total Deliveries 51,377.2 71,312.4 1,150.5 11,543.2 135,383.3 Less: North Marin 19,419.5 19,419.5
Marin Municipal 22,202.3 22,202.3
Sonoma Co. Deliveries 51,377.2 29,690.5 1,150.5 11,543.2 93,761.4 3-Year Annual Average 17,125.7 9,896.8 383.5 3,847.7 31,253.8 3/1/2023
9 DRAFT

SONOMA COUNTY WATER AGENCY SONOMA COUNTY WATER AGENCY
SCHEDULE OF ACTUAL PRIOR 12 MONTHS WATER DELIVERIES IN ACRE FEET (BY CUSTOMER TYPE) ACTUAL WATER DELIVERY DISTRIBUTION BY AQUEDUCT (ACRE FEET) JANUARY THROUGH DECEMBER PRIOR 12 MONTHS
Aqueduct * * * * DELIVERING AQUEDUCT * * * *
No. Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 TOTAL Santa Rosa Petaluma Sonoma TOTAL PRIMES DELIVERED TO:
1 City of Santa Rosa 1,022.7 986.2 1 ,156.1 1,151.7 1,572.7 1,362.7 1,338.2 1,680.4 1,381.4 1,376.6 1,094.2 1,056.4 15,179.2 2 City of Petaluma 438.7 425.7 491.6 474.3 669.4 574.4 520.1 645.1 598.6 510.2 464.8 398.5 6,211.3 CITY OF SANTA ROSA (A) 2 North Marin Water Dist. 363.1 364.1 399.9 422.6 806.6 410.6 483.0 548.7 446.9 422.0 329.8 306.0 5,303.2 Jan 2022 861.9 0.0 160.8 1,022.7 2 City of Rohnert Park 204.9 177.5 227.9 201.7 244.7 189.7 145.1 143.1 104.2 157.5 138.0 114.6 2,048.9 Feb 2022 801.0 0.0 185.2 986.2 2 City of Cotati 24.9 24.0 28.2 30.6 45.4 53.5 50.4 57.9 52.7 58.0 29.1 25.5 480.3 Mar 2022 943.5 0.0 212.7 1,156.1 1 Town of Windsor 35.4 35.5 57.4 66.0 52.7 48.9 48.5 49.8 49.9 39.7 26.1 25.6 535.5 Apr 2022 936.2 0.0 215.4 1,151.7 4 City of Sonoma 92.9 112.6 131.0 130.7 181.3 191.2 173.6 160.1 103.7 102.1 114.1 95.1 1,588.4 May 2022 1,294.1 0.0 278.6 1,572.7 4 Valley of the Moon Dist. 99.7 73.2 96.5 108.5 171.3 171.8 166.3 201.0 162.0 160.4 107.0 107.1 1,624.8 Jun 2022 1,112.6 0.0 250.2 1,362.7 TOTAL PRIMES 2,282.3 2,198.8 2,588.7 2,586.1 3,744.1 3,002.8 2,925.2 3,485 .9 2,899.3 2,826.4 2,303.1 2,128.9 32,971.5 Jul 2022 1,090.9 0.0 247.3 1,338.2 Aug 2022 1,375.6 0.0 304.8 1,680.4
OTHER AGENCY CUSTOMERS Sep 2022 1,126.5 0.0 254.9 1,381.4 1 Cal-American Water 14.3 18.9 12.9 15.7 23.3 35.5 22.0 19.4 27.2 13.9 11.3 8.5 222.8 Oct 2022 1,154.3 0.0 222.3 1,376.6 2 Penngrove Water Co 10.7 10.4 12.4 12.5 18.7 20.7 20.7 22.9 16.9 16.4 11.6 9.5 183.4 Nov 2022 899.1 0.0 195.1 1,094.2 4 Lawndale Mutual 3.4 2.7 3.6 3.1 6.9 7.0 9.0 10.7 3.7 4.5 2.6 1.7 58.9 Dec 2022 879.0 0.0 177.4 1,056.4 4 Kenwood Village Water Co 0.6 0.6 0.7 0.7 1.0 0.7 0.7 1.0 0.8 0.9 0.8 0.8 9.3 TOTAL SANTA ROSA 12,474.7 0.0 2,704.5 15,179.2 3 Forestville Co Water Dist. 18.6 20.0 26.0 24.0 33.1 33.3 34.9 44.6 35.2 30.9 23.3 18.5 342.3 1 Other Gov-Santa Rosa Aq 0.7 0.9 1.0 0.5 0.6 1.2 0.8 0.4 0.7 0.7 0.6 0.6 8.8 OTHER PRIME CONTRACTORS (B) 2 Other Gov-Petaluma Aq 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 CITY OF PETALUMA 0.0 6,211.3 6,211.3 4 Other Gov-Sonoma Aq 6.7 5.1 4.4 5.4 6.9 5.1 4.9 6.0 4.9 4.8 5.5 4.2 64.0 NORTH MARIN WATER DISTRICT 5,303.2 5,303.2 TOTAL OTHER AGY. CUST 55.0 58.5 61.0 62.1 90.6 103.4 93.0 1 04.9 89.3 72.0 55.7 43.8 889.4 CITY OF ROHNERT PARK 37.2 2,011.6 2,048.9 CITY OF COTATI 3.6 476.7 480.3
OFF-PEAK CUSTOMERS TOWN OF WINDSOR 535.5 535.5
2 Marin Municipal 380.8 859.6 1,015.2 965.5 1,138.1 1,207.4 319.5 344.6 234.5 385.8 454.2 633.7 7,938.9 CITY OF SONOMA 1,588.4 1,588.4 VALLEY OF THE MOON DISTRICT 1,624.8 1,624.8
SURPLUS CUSTOMERS TOTAL OTHER PRIME CONTRACTORS 576.3 14,002.8 3,213.2 17,79 2.3 1 Irrigation-Santa Rosa Aq 0.0 0.0 0.0 0.0 0.0 0.0 6.4 3.1 0.0 0.0 0.0 0.0 9.5 2 Irrigation-Petaluma Aq 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 TOTAL DELIVERIES TO PRIMES 13,051.0 14,002.8 5,917.7 32,971.5 4 Irrigation-Sonoma Aq 2.0 1.2 1.5 2.2 11. 3 4.8 3.9 4.2 2.1 1.6 1.8 1.2 37.8 TOTAL SURPLUS CUST. 2.0 1.2 1.5 2.2 11.3 4.8 10.3 7.3 2.1 1.6 1.8 1.2 47.3 LESS: NORTH MARIN (5,303.2) (5,303.2) TOTAL DELIVERIES 2,720.2 3,118.1 3,666.4 3,615.8 4,984.0 4,318.5 3,348.0 3,942.7 3,225.2 3,285.8 2,814.8 2,807.7 41,847.2 TOTAL SONOMA COUNTY DELIVERIES 13,051.0 8,699.6 5,917.7 27,668.3 3/1/2023
10 DRAFT
FY 2023-24 BUDGET
Water Transmission System Agency Fund
ESTIMATED WATER DELIVERIES AND WATER SALES - O&M plus Surcharges

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE

WATER SALES - O&M
1 PRIMES without Subcharges 32,971.5 903.30 29,783,323
2 OTHER AGENCY CUSTOMERS 889.4 1,528.36 1,359,372
3 MARIN MUNICIPAL (OFF-PEAK) 4,300.0 1,112.84 4,785,227 4 MARIN MUNICIPAL (SUPPLEMENTAL) 3,638.9 1,112.84 4,049,523 5 SURPLUS CUSTOMERS 47.3 1,101.97 52,144
TOTAL WATER SALES - O&M 41,847.2 N/A $40,029,589
Note: MMWD rate adjusted per Amended MMWD Water Supply Agreements Effective 7/1/15.

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE
WATER SALES - Sub-charges
1a Water Management Planning Sub-charge [4.13] 41,847.2 0.00 0 1b Watershed Planning/Restoration Sub-charge [4.14] 41,847.2 35.96 1,504,670 1c Recycled Water & Local Supply Sub-charge [4.15] 41,847.2 0.00 0 1d Water Conservation Sub-charge [4.16] 41,847.2 54.08 2,263,032 TOTAL WATER SALES - Subcharges 41,847.2 N/A $3,767,702
Sub-Object 4175, 4176, 4177, and 4178
3/1/2023
11 DRAFT
FY 2023-24 BUDGET
Water Transmission System Agency Fund
SANTA ROSA AQUEDUCT ESTIMATED WATER DELIVERIES AND WATER SALES - O&M plus Surcharges

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE

WATER SALES - O&M
1 SANTA ROSA AQUEDUCT 15,955.9 903.30 14,413,004

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE
WATER SALES - Sub-charges
1a Water Management Planning Sub-charge [4.13] 15,955.9 0.00 0 1b Watershed Planning/Restoration Sub-charge [4.14] 15,955.9 35.96 573,714 1c Recycled Water & Local Supply Sub-charge [4.15] 15,955.9 0.00 0 1d Water Conservation Sub-charge [4.16] 15,955.9 54.08 862,869 TOTAL WATER SALES - Subcharges 15,955.9 N/A $1,436,583

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE

CAPITAL CHARGES
Aqueduct Facilities Capital Charges [4.6 e] 15,955.9 11.00 175,515

BOND AND LOAN CAPITAL CHARGES
Storage Facilities Capital Charge [4.7] 15,955.9 29.14 464,977 Common Facilities Capital Charge [4.8] 15,955.9 139.61 2,227,580 Sonoma Aqueduct Facilities Capital Charges [4.6 b] 15,955.9 0.00 0 TOTAL WATER SALES - Capital & Bond and Loan Charges 15,955.9 N/A $2,868,072 TOTAL ESTIMATED REVENUE $18,717,659
Sub-Object 4175, 4176, 4177, and 4178
3/1/2023
12 DRAFT
FY 2023-24 BUDGET
Water Transmission System Agency Fund
PETALUMA AQUEDUCT ESTIMATED WATER DELIVERIES AND WATER SALES - O&M plus Surcharges

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE

WATER SALES - O&M
1 PETALUMA AQUEDUCT 22,165.9 903.30 20,022,561

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE
WATER SALES - Sub-charges
1a Water Management Planning Sub-charge [4.13] 22,165.9 0.00 0 1b Watershed Planning/Restoration Sub-charge [4.14] 22,165.9 35.96 797,004 1c Recycled Water & Local Supply Sub-charge [4.15] 22,165.9 0.00 0 1d Water Conservation Sub-charge [4.16] 22,165.9 54.08 1,198,699 TOTAL WATER SALES - Subcharges 22,165.9 N/A $1,995,703

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE

CAPITAL CHARGES
Aqueduct Facilities Capital Charges [4.6 e] 22,165.9 0.00 0

BOND AND LOAN CAPITAL CHARGES
Storage Facilities Capital Charge [4.7] 22,165.9 29.14 645,946 Common Facilities Capital Charge [4.8] 22,165.9 139.61 3,094,556 Sonoma Aqueduct Facilities Capital Charges [4.6 b] 22,165.9 0.00 0 TOTAL WATER SALES - Capital & Bond and Loan Charges 22,165.9 N/A $3,740,502 TOTAL ESTIMATED REVENUE $25,758,766
Sub-Object 4175, 4176, 4177, and 4178
3/1/2023
13 DRAFT
FY 2023-24 BUDGET
Water Transmission System Agency Fund
SONOMA AQUEDUCT ESTIMATED WATER DELIVERIES AND WATER SALES - O&M plus Surcharges

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE

WATER SALES - O&M
1 SONOMA AQUEDUCT 3,383.1 903.30 3,055,999

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE
WATER SALES - Sub-charges
1a Water Management Planning Sub-charge [4.13] 3,383.1 0.00 0 1b Watershed Planning/Restoration Sub-charge [4.14] 3,383.1 35.96 121,645 1c Recycled Water & Local Supply Sub-charge [4.15] 3,383.1 0.00 0 1d Water Conservation Sub-charge [4.16] 3,383.1 54.08 182,955 TOTAL WATER SALES - Subcharges 3,383.1 N/A $304,600

ESTIMATED

REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED

DELIVERED RATES REVENUE

CAPITAL CHARGES
Aqueduct Facilities Capital Charges [4.6 e] 3,383.1 34.90 118,071

BOND AND LOAN CAPITAL CHARGES
Storage Facilities Capital Charge [4.7] 3,383.1 29.14 98,589 Common Facilities Capital Charge [4.8] 3,383.1 139.61 472,315 Sonoma Aqueduct Facilities Capital Charges [4.6 b] 3,383.1 151.68 513,148 TOTAL WATER SALES - Capital & Bond and Loan Charges 3,383.1 N/A $1,202,123 TOTAL ESTIMATED REVENUE $4,562,722
Sub-Object 4175, 4176, 4177, and 4178
3/1/2023
14 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Water Transmission System Agency Fund
Fund/Department No: 44205 33040100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNNG FUND BALANCE 16,027,234 21,483,922 10,327,462

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 149,403 250,000 36,000 249,895 213,895 594.15% 44003 Other Interest Earnings 0 0 0 0 0 N/A
44050 Unrealized Gains & Losses (866,252) 0 0 0 0 N/A 44109 Concessions 0 0 0 0 0 N/A
44101 Rent - Real Estate 0 0 0 0 0 N/A
SUBTOTAL (716,848) 250,000 36,000 249,895 213,895 594.15%

INTERGOVERNMENTAL REVENUES
42282 State CalOES Disaster Funding (2,038) 0 0 0 0 N/A 42284 State Cal OES Admin Allowance 0 0 0 0 0 N/A 42358 State Other Funding 8,979 0 0 0 0 N/A
42441 Federal FEMA Disaster Funding (8,150) 0 0 0 0 N/A 42443 Federal FEMA Admin Allowance 0 0 0 0
42461 Federal Other Funding 0 0 0 0 0 N/A
42610 Other Governmental Agencies 0 0 0 0 0 N/A 42621 North Marin Water District 0 0 0 0 0 N/A
42701 Revenue Appl - PY Intergovmtl 0 0 0 0 0 N/A SUBTOTAL (1,209) 0 0 0 0 N/A

CHARGES FOR SERVICES
45062 Construct/Bldg Permit Rvw Svcs 0 0 0 0 0 N/A 45065 Inspection Fees 0 0 0 0 0 N/A
45223 Sewer/Water Hook up Fees 22,896 20,000 0 20,000 20,000 N/A 45301 Charges for Services 65,858 15,000 0 0 0 N/A 45314 Sale - Power 0 100,000 100,000 100,000 0 0.00%
45315 Sale - Water, Wholesale 32,494,227 35,287,622 39,208,469 40,029,589 821,120 2.09% 45316 Water Conservation 2,110,478 1,955,739 2,173,043 2,263,032 89,989 4.14% 45323 Common Fac Rev Bond Chg 2,886,446 4,128,123 4,128,123 3,986,916 (141,207) (3.42%) 45324 Storage Fac Rev Bond Chg 721,507 866,050 866,050 832,214 (33,837) (3.91%) 45325 Sonoma Aqueduct Rev Bond Chg 440,457 532,320 532,320 513,148 (19,172) (3.60%) 45327 Santa Rosa Aqueduct Cap Chg 417,654 279,159 279,159 298,319 19,161 6.86% 45328 Petaluma Aqueduct Cap Chg 296,424 155,228 155,228 0 (155,228) (100.00%) 45329 Sonoma Aqueduct Cap Chg 174,320 145,727 145,727 127,572 (18,155) (12.46%) 45330 North Marin Rev Bond Chg 386,739 488,069 488,069 494,028 5,960 1.22% 45331 Water Mgmt Plan/Restore Chg 1,535 8,100 9,000 0 (9,000) (100.00%) 45332 Watershed Plan/Restore Chg 6,265,024 1,346,553 1,496,170 1,504,670 8,500 0.57% 45333 Recycled Water & Local Supply 45,603 20,700 23,000 0 (23,000) (100.00%) 45401 Revenue Appl PY Chgs for Svcs 0 0 0 0 0 N/A SUBTOTAL 46,329,166 45,348,390 49,604,358 50,169,488 565,131 1.14% 3/1/2023
15 DRAFT
Section Title: Water Transmission System Agency Fund
Fund/Department No: 44205 33040100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change Miscellaneous Revenues
46027 Insurance Claims Reimbursement 2,891 0 0 0 0 N/A 46029 Donations/Contributions 0 0 0 0 0 N/A
46040 Miscellaneous Revenue 10,380 0 0 0 0 N/A
46041 Discounts Earned 94 0 0 0 0 N/A
46050 Cancelled/Stale Dated Warrants 9 0 0 0 0 N/A 46200 Revenue Appl PY Misc Revenue 0 0 0 0 0 N/A 46205 PY Revenue – Charges for Servi 0 0 0 0 0 N/A 46215 Other Grants 0 0 0 0 0 N/A
SUBTOTAL 13,374 0 0 0 0 N/A

OTHER FINANCING SOURCES
47002 Sale of Capital Assets 0 0 0 0 0 N/A
47101 Transfers In - within a Fund 0 0 0 0 0 N/A 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 0
TOTAL REVENUES 45,624,483 45,598,390 49,640,358 50,419,384 779,026 1.57%

EXPENDITURES

SERVICES AND SUPPLIES
51021 Communications Expense 0 0 0 0 0 N/A
51031 Waste Disposal Services 0 0 0 0 0 N/A
51032 Janitorial Services 6,552 7,100 6,600 7,000 400 6.06% 51041 Insurance - Liability 0 0 0 0 0 N/A
51061 Maintenance - Equipment 766,433 3,000,000 3,286,389 2,875,200 (411,189) (12.51%) 51071 Maintenance - Bldg & Improve 0 0 0 0 0 N/A 51072 Landscaping Services 0 10,000 25,000 0 (25,000) (100.00%) 51077 Maint-Infrastructure 0 0 0 0 0 N/A
51083 VSP Premiums 0 50 50 0 (50) (100.00%)
51205 Advertising/Marketing Svc 4,564 8,000 4,000 6,000 2,000 50.00% 51209 Information Tech Svc (non ISD) 150 260 260 260 0 0.00% 51211 Legal Services 67,489 24,000 20,000 28,000 8,000 40.00% 51212 Outside Counsel - Legal Advice 5,738 2,000 2,000 2,000 0 0.00% 51214 Agency Extra/Temp Help 0 0 0 0 0 N/A
51221 Medical/Laboratory Services 0 20,000 0 0 0 N/A 51226 Consulting Services 0 17,000 0 0 0 N/A
51230 Security Services 1,677 2,000 1,500 3,000 1,500 100.00% 51231 Testing/Analysis 136,150 240,000 150,000 200,000 50,000 33.33% 51241 Outside Printing and Binding 1,038 500 500 500 0 0.00% 51242 Bank Charges 125 50 50 50 0 0.00%
51244 Permits/License/Fees 79,784 80,000 90,000 90,000 0 0.00% 51249 Other Professional Services 0 0 0 0 0 N/A 51301 Publications and Legal Notices 0 0 0 0 0 N/A 51401 Rents and Leases - Equipment 282,181 600,000 500,000 400,000 (100,000) (20.00%) 51402 Rents and Leases - Heavy Eqt 281,062 220,000 5,000 200,000 195,000 3900.00% 51421 Rents and Leases - Bldg/Land 0 0 0 0 0 N/A 51601 Training Services 163,247 15,000 15,000 15,000 0 0.00% 3/1/2023
16 DRAFT
Section Title: Water Transmission System Agency Fund
Fund/Department No: 44205 33040100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change 51602 Business Travel/Mileage 1,097 5,000 10,000 6,000 (4,000) (40.00%) 51605 Private Car Expense 1,886 1,000 1,000 750 (250) (25.00%) 51801 Other Services 0 0 0 0 0 N/A
51803 Other Contract Services 1,807,038 19,491,888 11,559,826 11,049,855 (509,971) (4.41%) 51902 Telecommunication Usage 54,150 75,000 75,000 75,000 0 0.00% 51911 Mail Services 65 150 150 150 0 0.00%
51917 District Operations Chgs 16,732,705 17,647,134 17,491,944 18,377,036 885,092 5.06% 51921 Equipment Usage Charges 849,966 850,000 925,000 900,000 (25,000) (2.70%) 52021 Clothing, Uniforms, Personal 5,770 4,000 5,000 5,000 0 0.00% 52031 Food 0 700 700 500 (200) (28.57%)
52041 Household Supplies Expense 0 100 100 0 (100) (100.00%) 52042 Janitorial Supplies 0 0 0 0 0 N/A
52043 Safety Supplies/Equipment 0 2,500 0 0 0 N/A 52061 Fuel/Gas/Oil 48,235 110,000 50,000 75,000 25,000 50.00% 52071 Materials and Supplies Expense 23,728 35,000 35,000 35,000 0 0.00% 52072 Chemicals 588,190 800,000 700,000 775,000 75,000 10.71% 52081 Medical/Laboratory Supplies 42,159 25,000 20,000 25,000 5,000 25.00% 52091 Memberships/Certifications 41,221 45,000 37,500 40,000 2,500 6.67% 52101 Other Supplies 96 150 0 0 0 N/A
52111 Office Supplies 4,005 2,500 5,000 5,000 0 0.00%
52114 Freight/Postage 2,192 1,000 1,000 1,000 0 0.00%
52115 Books/Media/Subscriptions 262 500 500 500 0 0.00% 52117 Mail and Postage Supplies 76 2,500 1,500 1,500 0 0.00% 52141 Minor Equipment/Small Tools 125,195 300,000 100,000 150,000 50,000 50.00% 52142 Computer Equipment/Accessories 0 10,000 10,000 1,000 (9,000) (90.00%) 52143 Computer Software/Licensing Fees 26,151 40,000 40,000 30,000 (10,000) (25.00%) 52162 Special Department Expense 0 0 0 0 0 N/A
52171 Water Conservation Program 0 0 0 0 0 N/A
52191 Utilities 2,142 4,000 500 2,000 1,500 300.00%
52193 Utilities - Electric 4,466,958 4,500,000 3,500,000 4,250,000 750,000 21.43% SUBTOTAL 26,619,475 48,199,082 38,676,069 39,632,301 956,232 2.47%

OTHER CHARGES
53103 Interest on LT Debt 0 0 0 0 0 N/A
53104 Other interest Expense 0 0 0 0 0 N/A
53401 Amortization Expense 3,433 54,000 54,000 54,000 0 0.00% 53402 Depreciation Expense 6,638,630 8,023,000 8,023,000 6,778,000 (1,245,000) (15.52%) 53403 Loss - Disposed Capital Asset 0 0 0 0 0 N/A 53500 Contributions Non-County Agy 0 0 0 0 0 N/A 53501 Contributions 0 0 0 745,396 745,396 N/A
53610 Other Charges 0 0 0 0 0 N/A
SUBTOTAL 6,642,063 8,077,000 8,077,000 7,577,396 (499,604) (6.19%)

FIXED ASSETS
19820 Machinery and Equipment 0 0 0 0 0 N/A
19822 Mobile Equipment 0 0 0 0 0 N/A
19824 Computer Equipment 0 0 0 0 0 N/A
19831 CIP - Bldg & Impr 0 0 0 0 0 N/A
19832 CIP - Infrastructure 4,157 0 0 0 0 N/A
19840 Work in Progress - Eqt 0 0 0 0 0 N/A
19841 Work in Progress - Intang 0 30,000 30,000 33,700 3,700 12.33% 19851 Intangible Assets - Non-amort 0 0 0 0 0 N/A SUBTOTAL 4,157 30,000 30,000 33,700 3,700 12.33%
3/1/2023
17 DRAFT
Section Title: Water Transmission System Agency Fund
Fund/Department No: 44205 33040100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change

OTHER FINANCING USES
57011 Transfers Out - within a Fund 14,158,394 10,025,768 10,295,889 10,019,899 (275,990) (2.68%) 57012 Transfers Out - btw Govtl Fund 0 0 0 0 0 N/A SUBTOTAL 14,158,394 10,025,768 10,295,889 10,019,899 (275,990) (2.68%) APPROP. FOR CONTINGENCIES
55011 Appropriation for Contingency 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A

REMIBURSEMENTS
58010 Reimb. - General 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 0 0 0 0 0 N/A 59005 Admin Control Acct Clearing 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 47,424,088 66,331,849 57,078,958 57,263,297 184,339 0.32% Adjustments to Reserves/Encumbrances:

Depreciation 6,642,063 8,077,000 6,832,000
Donated Asset (Caltrans) 0
Outstanding Encumbrances - Net Change (100,940) 0
Capitalized Interest 0
Gain/Loss on disposal of fixed assets 0
Unrealized Gain/ Loss (GASB 31) 866,252
Change in Prepaid Expense 5,313
Change in Prudent Reserve 1,500,000
Post audit adjustments - Payables (156,395)
Use of Fund Balance (640,000)
Rounding 0
ENDING FUND BALANCE 21,483,922 10,327,462 9,675,550
Operations and Maintenance 44205 Fund Balance Reserve Goal 9,916,500 Over/(Under) Goal (240,951)
3/1/2023
18 DRAFT
Water Transmission System Agency Fund
Major Services & Supplies Expenditure Items
Fund/Department No: 44205 33040100
Actual Adopted Requested Percent
FY21-22 FY22-23 FY23-24 Difference Change
51061 Maintenance - Equipment 766,433 3,286,389 2,875,200 (411,189) -12.5% 51211 Legal Services 67,489 20,000 28,000 8,000 40.0%
51231 Testing/Analysis 136,150 150,000 200,000 50,000 33.3% 51803 Other Contract Services 1,807,038 11,559,826 11,049,855 (509,971) -4.4% 51917 District Operations Chgs 16,732,705 17,491,944 18,377,036 885,092 5.1% 51921 Equipment Usage Charges 849,966 925,000 900,000 (25,000) -2.7% 52072 Chemicals 588,190 700,000 775,000 75,000 10.7%
52141 Minor Equipment/Small Tools 125,195 100,000 150,000 50,000 50.0% 52193 Utilities - Electric 4,466,958 3,500,000 4,250,000 750,000 21.4% Increase due to elevated energy production and transmission costs caused by drought, geopolitical events, and supply chain constraints.

Reflects five year average expenditures.

Reflects five year average expenditures.

Decrease attributable to lower budgeted expenses and $380,000 in deferrals.

Decrease attributable to $1.36M in deferrals. Decrease offset by increased maintenance project costs attributable to Tank Maintenance and Tank Recoat Projects.

Increase reflects five-year average expenditures.

Increase associated with expanded sampling and analysis tied to the Santa Rosa Plain Wells Projects as well as additional Increase is attributable to an increase in labor costs for maintenance projects (cathodic protection, tank recoating program, tank maintenance program, pump and valve replacements, electrical projects, chlorine and pH improvement projects, SCADA upgrades), studies (Regional Water Supply Resiliency, Watershed and Water Quality Seismic Mitigation Studies, Local Hazard Mitigation Plan), emergency inventory procurement, and mitigation monitoring for recently completed FEMA projects, offset by decrease in labor for deferred maintenance projects.

Increase due to Santa Rosa Plain Well activation.
3/1/2023
19 DRAFT

AMOUNT DEFERRED
AMOUNT
1 Backflow Maintenance 50,000
2 Collector 1 MOV Maintenance 124,900
3 Electrical Supplies and Maintenance Services 400,000
4 Emergency Inventory Procurement 340,000 380,000 5 Groundwater Monitoring Instruments 49,300
6 Kisters Annual License Fee 20,000
7 Mirabel Pump 10 Replacement 523,000
8 Pump and Pipeline Supplies and Maintenance Services 240,000 9 RDS Dam Fill Pipeline Maintenance 150,000
10 Safety Program - Self Contained Breathing Apparatus Replacem 62,000 11 Santa Rosa Plain Well Monitoring Program (SW Wells) 25,000 12 Valve Replacement Program 250,000
13 Wohler/Mirabel CL2 Detector OSHA 77,000
14 Wohler Pump 4 Replacement 404,000
15 WT Monitoring Well Pressure Transducers 20,000
2,875,200$ 380,000$
2023-24
Water Transmission System Agency Fund
51061 Maintenance - Equipment
3/1/2023
20 DRAFT
Other Contract Services AMOUNT DEFERRED
AMOUNT
1 As-Needed Dive Services - 60,000
2 As-Needed Electrical Design Services 150,000
3 As-Needed Planning Studies - 150,000 4 As-Needed O&M Engineering Services 50,000 25,000 5 Asset Management 100,000
6 Caisson 6 Valve and Vault Replacement 220,000
7 Cathodic Protection - Maintenance 100,000
8 Cathodic Protection - Site Assesment and Design Support 100,000 9 Cathodic Protection - SR/Cotati 277,150
10 Hazardous Materials Management 50,000
11 Hearn Ave Electrical Project 200,000 550,000 12 Sleepy Mountain Lease Agreement 20,000
13 Tank Maintenance Program 1,398,330
14 Tank Recoating Program 7,463,875
15 TPW Pavement Preservation Program 25,000
16 Transmission System Condition Assessments 100,000 100,000 17 Water Transmission System Transient Analysis 150,000 18 Regional Water Emergency Prep Program Development - 150,000 Advocacy
19 Community Outreach Program 40,000
Integrated Water Management Plan
20 Bay Area 5,500
21 North Coast 35,000
22 Legislative Advocacy - Federal 95,000
23 Legislative Advocacy - State 50,000
24 North Bay Water Regional Outreach Coordination 25,000 Studies -
25 DeMuth Property Hydrogeologic Investigation 150,000 200,000 26 Groundwater Banking Feasibility - Pilot Studies 50,000 27 Hydrography Study 20,000
28 Regional Water Supply Resiliency Study 75,000 25,000 29 Transmission System Monitoring Master Plan - 100,000 30 Transmission System Modeling & Assessment Program 50,000 31 Wohler/Mirabel Groundwater Model Update and Supporting Stud 50,000 11,049,855$ 1,360,000$
Contributions AMOUNT DEFERRED
AMOUNT
1 SCADA Improvements 745,396
745,396$ -$
Labor associated with deferred projects 699,200$
Total amount of work deferred 2,439,200$
51803
53501
3/1/2023
21 DRAFT
51803 Other Contract Services & 53501 Contributions Project Information FY23-24 Asset Management 100,000
The primary objectives of Sonoma Water’s Asset Management Program (AMP) are to improve the cost-effective management of assets throughout their life-cycle, promote data sharing and interconnectivity, and demonstrate fiscal responsibility. Phase 1 included review of Sonoma Water’s current asset management practices, development of an AMP vision and charter, asset management framework, identifying business improvement opportunities for data integration and management, and establishing an enterprise-wide AMP Statement of commitments. To date the AMP has delivered: Asset Management Framework Tech Memo; State of the Assets Tech Memo; Asset Management Implementation Plan (AMIP) Report; and Asset Management Program Statement of Commitments. In FY21-22, Phase 2 will include a Mirabel Production Facility asset inventory, condition assessment, and updating the Asset Management Implementation Plan. In FY22-23, continue to conduct assessments of the water system and wastewater facilities; implement a new CMMS software; develop a program for inspection the aqueduct. In FY 23/24, Phase 3 will involve integrating the recommendations during Phase 2 into the full roll-out of the enterprise-wide AMP, implementing the selected CMMS software, furthering data management and integration and continuing with additional condition assessments of water and wastewater facilities.

Caisson 6 Valve and Vault Replacement 220,000
The Collector 6 valve vault project will install a new vault around two existing shutoff valves located along the 20” and 24” discharge pipes at Collector 6. The new vault is required to facilitate needed repairs and maintenance on the valves.

Cathodic Protection - SR/Cotati 277,150
Provide improvements to upgrade the cathodic protection system along the existing Santa Rosa Aqueduct and Russian River-Cotati Intertie. The project includes designing and constructing a new corrosion protection system to protect the pipeline from corrosion and monitor the state of the pipelines. The corrosion protection system will have a useful life of approximately 50 years, and will allow for remote assessment and data collection to quantify the condition of the pipeline and state of the cathodic protection system. The project will be constructed in two phases with a completed project that consists of 27 corrosion protection well sites and 51 test stations.

In FY 21-22, design efforts commenced and CEQA environmental review was completed for the project. FY 22-23 funding will be used to continue advancing design of Phase 1, and to initiate design of Phase 2. In FY23-24, Sonoma Water plans on advertising and completing construction of Phase 1, and also advancing necessary right-of-way to continue design development of Phase 2.

Hearn Ave Electrical Project 200,000
Repair/update Electrical Feed and communication lines to the equipment on the south side of Hearn Ave. This includes power and instrumentation communications to the Cathodic rectifier, AQ flowmeter and pressure transducer. Directional boring for new conduits, new wire, communication cabling, and verification. In FY23-24, repairs will be made to the conduit, new wires will be pulled, and the system will be tested.

SCADA Improvements 745,396
SCADA software and hardware: The scope of the project is to upgrade SCADA workstations and software to current supported versions. Other objectives include upgrades to field components such as Programmable Logic Controllers (PLCs) and Remote Telemetry devices.

SCADA Upgrade: The scope of this project is to reassess and revamp programming standards to accommodate current technologies as well as implement these new standards to streamline maintenance and operations. During FY21/22, we were able to complete much of the background work necessary to upgrade our SCADA system. This includes documenting the logic embedded in our existing SCADA system interface, duplicating that logic into a new PLC, and creating new interface graphics. In FY22/23, we have begun testing live, side-by-side testing of the new system and will be completing reporting requirements. In FY23/24, we will be cutting over to the new system and undertaking under- taking additional system improvements including optimizing system performance and hardware replacements and upgrades.

Tank Maintenance Program 1,398,330
Sonoma County Water Agency (Sonoma Water) owns and operates 18 water storage tanks with a total combined capacity of 128.8 million gallons as a part of the water transmission system that provides clean drinking water to approximately 600,000 residents in nine major cities and water districts within Sonoma and Marin counties. Maintaining these tanks is critical. This program covers a 10-year agreement for maintenance services with a Service Provider. In FY 23/24 Enhanced Washout Cleaning and Inspections will be conducted on 4 tanks, and Visual Inspections will be conducted on 11 tanks. The remaining 3 tanks are actively under design to be re-coated. 3/1/2023
22 DRAFT
51803 Other Contract Services & 53501 Contributions Project Information FY23-24 Tank Recoating Program 7,463,875
Water storage tanks are an integral component of Sonoma Water’s transmission and supply system and provide operational flexibility and system supply resiliency when demand exceeds production capacity. In total, Sonoma Water’s 18 welded steel water tanks provide 129 million gallons of storage, which is approximately three times the average daily system demand. Welded-steel tanks are susceptible to corrosion and have a limited functional lifespan of approximately 50 years without coatings. With regularly scheduled and targeted maintenance, monitoring, and recoating activities welded-steel tanks can attain a lifespan of over 100 years. Sonoma Water’s Tank Recoating Program specifically targets the protection and maintenance of welded-steel tanks by designing and implementing tank rehabilitation projects that include interior and exterior recoating, structural repairs, and installation of cathodic protection systems to maximize the functional life of each facility.

In FY 21-22 Sonoma Water began developing plans for the recoating of the Kastania and Cotati No.1 tanks. FY 22-23 funding will be used to begin construction at the Kastania and Cotati No. 1 tanks and to initiate design of the Cotati No. 3 tank recoating project. Work in FY 22-23 at Kastania and Cotati No. 1 will include interior and exterior coating removal and replacement, structural repairs to corroded roof rafters, and other ancillary repairs. Planned work for FY23-24 includes beginning construction on Cotati No. 3 tank recoating and beginning design of Ralphine No. 3 and Sonoma No. 2 tank recoating projects.

Transmission System Condition Assessments 100,000
Prepare an assessment report that reviews the water system pipeline infrastructure to develop an approach and framework for a risk-based prioritization model to conduct inspections. The project will evaluate appropriate pipeline inspection technologies and formulate an inspection projects prioritization plan.

Water Transmission System Transient Analysis 150,000
Sonoma Water completed a comprehensive transient analysis of the water transmission system in 1999. In support of specific projects, the study was partially updated for select locations in 2003, 2007, and 2013. Utilizing a contemporary modeling platform, a new system-wide study will be prepared for the current status of the transmission system. The study will identify and recommend solutions to address current transient vulnerabilities in the water transmission system.

Minimal efforts were focused on this project in FY 21-22 given other competing priorities. FY 22-23 Sonoma Water plans on engaging a consultant to update a system-wide transient analysis. In FY23-24, Sonoma Water plans on finalizing the transient analysis and identifying CIP projects needed to address and mitigate any existing system vulnerabilities to surge and pressure transients.

Studies
DeMuth Property Hydrogeologic Investigation 150,000
The DeMuth property hydrogeologic investigation will advance feasibility evaluation of siting additional diversion facilities (i.e., a well field or additional collector well) within the DeMuth parcels adjoining the eastern bank of the Russian River, just south of Wohler Bridge. Particular focus of the study will 1) evaluate appropriate methods for investigating the hydrostratigraphy of the parcels (e.g., with drilling and/or geophysical methods), 2) leverage existing internal modeling tools to estimate well production efficiencies and potential well interference with existing collector wells, and 3) assess strategies for mitigating seismic risks to existing Wohler/Mirabel diversion facilities by siting new diversion facilities on the DeMuth parcels.
3/1/2023
23 DRAFT
51803 Other Contract Services & 53501 Contributions Project Information FY23-24 Groundwater Banking Feasibility - Pilot Studies 50,000
In FY 22/23, Sonoma Water provided technical review and support to Valley of the Moon Water District and City of Petaluma in developing scopes of work for aquifer storage and recovery (ASR) pilot studies, performed technical review and coordination for potential groundwater banking aspects of the Regional Water Supply Resiliency Study, initiated evaluation of Sonoma Water's future ASR operations at its Sebastopol and Occidental Rd well sites (currently being upgraded for ASR operations under a DWR grant), and initiated planning and scope development for an update to the regional 2013 Groundwater Banking Feasibility Study.

Funds expected to be expended in FY 23/24 would support an update to the regional 2013 Groundwater Banking Feasibility Study to 1) update the source water (Russian River) availability and transmission system capacity assumptions; 2) update assessment of potential ASR locations/operations, including those that benefit GSP implementation; and 3) design implement pilot studies for favorable areas. It is anticipated that funding for the regional Groundwater Banking Feasibility Study would be cost shared by Sonoma Water, the three GSAs and interested Water Contractors. Funds will also be used for Sonoma Water staff to continue coordination with other entities, such as the City of Petaluma and Valley of the Moon Water District, currently planning ASR pilot studies, participants of the Regional Water Supply Resiliency Study, and staff of the San Francisco Bay and North Coast Regional Water Quality Control Boards.

Hydrography Study 20,000
In order to better understand tributary flow dynamics on water supply and aquatic habitats, Sonoma Water hired Mike Webster as a consultant to assist with the installation and maintenance of an extensive stream gauging network of tributaries to the Russian River. Over the last fiscal year, Mike Webster has continued to capture manual stream discharge measurements at multiple gauged tributaries in order to maintain stream discharge rating curves. Mike Webster used his rating curves and stream flow measurements to develop an annual discharge computation for Feliz Creek, providing Sonoma Water with a daily streamflow summary for the tributary. Additionally, Mike continues to maintain real time stream gauging equipment, fixes and/or replaces damaged instruments and provides guidance to Sonoma Water staff in order to ensure that best practices are followed in capturing surface water streamflow.

Regional Water Supply Resiliency Study 75,000
Retail water providers to over 600,000 people in Sonoma and Marin Counties are regionally connected through existing water supply infrastructure. Along with purchasing wholesale water from the Sonoma County Water Agency, each retail provider also has local supplies which are used to meet the demands of their customers. Although these systems are connected, they are not operated or managed in a coordinated manner, especially in times of water shortage.

Development of a decision support tool could be used to evaluate strategies and water supply projects that would make the region more resilient to future water shortages.

Funds expended in FY 19/20 were used to develop a work plan in cooperation with Sonoma Water’s Water Contractors.

Funds budgeted for FY 20/21 were expended building a decision support model to evaluate the regions resiliency to drought under historical operations and with existing facilities. In cooperation with Sonoma Water’s contractors, scenarios were developed and evaluated that either through operational changes or new water supply facilities could improve the regions resiliency to drought. Funds budgeted for FY 21/22 were expended using the decision support model to complete analysis of scenarios focused on drought resiliency and to begin evaluating water shortage scenarios resulting from disruptions to Sonoma Water’s water supply and transmission system due to natural hazards such as seismic events, wildfires and flooding. Funds budgeted for FY 22/23 will be expended completing all modeling scenarios, completing development and evaluation of projects to improve the regions water supply reliability during periods of water supply shortages and completing a final report documenting the model and study results. Funds budgeted for FY 23/24 will be expended for ongoing support for efforts to improve the regions water supply resiliency.

Transmission System Modeling & Assessment Program 50,000 Update and maintain water transmission system hydraulic model used to simulate water system operations and deliveries. Analyze conditions and system capabilities under operational scenarios that support operations, maintenance and design decisions. Develop system performance assessment and monitoring tools. Analyze pump operations at production and booster station facilities using system monitoring data collected by SCADA system. 3/1/2023
24 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Water Management Planning
Fund/Department No: 44210 33041000
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 457,790 369,637 259,895

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 2,779 1,680 1,680 5,357 3,677 218.87% 44050 Unrealized Gains and Losses (15,139) 0 0 0 0 N/A SUBTOTAL (12,360) 1,680 1,680 5,357 3,677 218.87%

INTERGOVERNMENTAL REVENUE
42619 Town of Windsor 0 478 478 0 (478) (100.00%)
SUBTOTAL 0 478 478 0 (478) (100.00%)

CHARGES FOR SERVICES
45301 Charges for Services 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 1,535 8,100 9,000 0 (9,000) (100.00%) 47102 Transfers In - btw Govtl Fund 0 0 0 0 0 N/A SUBTOTAL 1,535 8,100 9,000 0 (9,000) (100.00%)
TOTAL REVENUES (10,825) 10,258 11,158 5,357 (5,801) (51.99%)

EXPENDITURES

SERVICES AND SUPPLIES
51205 Advertising Marketing 0 0 0 0 0 N/A
51211 Legal Services 353 0 0 0 0 N/A
51212 Legal Services - External 0 0 0 0 0 N/A
51241 Outside Printing & Binding 0 0 0 0 0 N/A
51601 Training/Conference Expense 0 0 0 0 0 N/A 51602 Business Travel/Mileage 0 0 0 0 0 N/A
51605 Private Car Expense 0 0 0 0 0 N/A
51803 Other Contract Services 100,669 100,000 75,000 75,000 0 0.00% 51917 District Operations Chgs 28,342 20,000 0 25,000 25,000 N/A 51921 Equipment Usage Charges 0 0 0 0 0 N/A
52171 Water Conservation Program 0 0 0 0 0 N/A
SUBTOTAL 129,363 120,000 75,000 100,000 25,000 33.33%

OTHER CHARGES
53103 Interest on LT Debt 0 0 0 0 0 N/A
53501 Contributions 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A 57012 Transfers Out - btw Govtl Fun 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 129,363 120,000 75,000 100,000 25,000 33.33% Adjustments to Reserves/Encumbrances:

Outstanding Encumbrances - Net Change 36,896 0 0
Audit Adjustment (A/P) 0 0 0
Unrealized Gain/ Loss (GASB 31) 15,139 0 0
Rounding 0
ENDING FUND BALANCE 369,637 259,895 165,252
3/1/2023
25 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Watershed Planning/Restoration
Fund/Department No: 44215 33041100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 12,565,071 15,629,400 3,423,809

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 91,028 14,400 14,400 45,028 30,628 212.70% 44050 Unrealized Gains and Losses (543,724) 0 0 0 0 N/A SUBTOTAL (452,695) 14,400 14,400 45,028 30,628 212.70%

INTERGOVERNMENTAL REVENUE
42461 Federal Other Funding 0 0 0 0 0 N/A
42619 Town of Windsor 323,985 79,538 79,538 87,446 7,908 9.94% SUBTOTAL 323,985 79,538 79,538 87,446 7,908 9.94%

CHARGES FOR SERVICES
45301 Charges for Services 0 0 0 0 0 N/A
45332 Watershed Plan/Restore Chg 53,972 100,000 40,000 40,000 0 0.00% Subtotal Charges for Services 53,972 100,000 40,000 40,000 0 0.00%

MISCELLANEOUS REVENUE
46021 Capital Grants - Federal 0 0 0 0 0 N/A
46029 Donations/Contributions 0 0 0 0 0 N/A
46040 Miscellaneous Revenue 0 0 0 0 0 N/A
46041 Discounts Earned 0 0 0 0 0 N/A
46050 Cancelled/Stale Dated Warrant 6 0 0 0 0 N/A 46200 Revenue Appl PY Misc Revenu 82 0 0 0 0 N/A SUBTOTAL 88 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 6,265,024 1,346,553 1,496,170 1,504,670 8,500 0.57% 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 6,265,024 1,346,553 1,496,170 1,504,670 8,500 0.57% TOTAL REVENUES 6,190,373 1,540,491 1,630,108 1,677,144 47,036 2.89%

EXPENDITURES

SERVICES AND SUPPLIES
51021 Communication Expense 0 0 0 0 0 N/A
51061 Maintenance - Equipment 551 500 0 0 0 N/A 51205 Advertising Marketing 0 0 0 0 0 N/A
51209 Information Tech Svc (non ISD) 0 0 0 0 0 N/A 51211 Legal Services 3,793 5,000 0 0 0 N/A
51212 Legal Services - External 511 250 0 0 0 N/A 51221 Medical/Laboratory Services 0 0 0 0 0 N/A 51226 Consulting Services 0 25,000 0 0 0 N/A
51231 Testing/Analysis 102,678 140,000 0 0 0 N/A 51241 Outside Printing and Binding 0 0 0 0 0 N/A 51244 Permits/License/Fees 150 500 0 0 0 N/A
51401 Rents and Leases - Equipment 54,290 40,000 0 0 0 N/A 51402 Rents and Leases - Heavy Eqt 20,620 35,000 0 0 0 N/A 51601 Training/Conference 0 0 0 0 0 N/A
51602 Business Travel/Mileage 0 0 0 0 0 N/A
51605 Private Car Expense 452 500 0 0 0 N/A
51801 Other Services 0 0 0 0 0 N/A
51803 Other Contract Services 834,919 6,796,112 5,043,920 1,624,870 (3,419,050) (67.79%) 51902 Telecommunication Usage 0 0 0 0 0 N/A
51917 District Operations Chgs 2,309,953 2,997,278 2,746,250 2,883,800 137,550 5.01% 51921 Equipment Usage Charges 54,405 50,000 0 0 0 N/A 3/1/2023
26 DRAFT
Section Title: Watershed Planning/Restoration
Fund/Department No: 44215 33041100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change 52021 Clothing, Uniforms, Personal 2,121 1,500 0 0 0 N/A 52031 Food 0 0 0 0 0 N/A
52042 Janitorial Supplies 0 0 0 0 0 N/A
52043 Safety Supplies/Equipment 0 0 0 0 0 N/A
52061 Fuel/Gas/Oil 78 200 0 0 0 N/A
52063 Vehicle Parts 0 0 0 0 0 N/A
52071 Materials and Supplies Expense 5,112 1,000 0 0 0 N/A 52081 Medical/Laboratory Supplies 0 0 0 0 0 N/A 52091 Memberships/Certifications 0 0 0 0 0 N/A
52101 Other Supplies 0 0 0 0 0 N/A
52111 Office Supplies 656 0 0 0 0 N/A
52114 Freight/Postage 0 0 0 0 0 N/A
52115 Books/Media 157 1,000 0 0 0 N/A
52117 Mail and Postage Supplies 0 0 0 0 0 N/A
52141 Minor Equipment/Small Tools 2,728 2,500 0 0 0 N/A 52142 Computer Equipment/Accessor 0 0 0 0 0 N/A 52143 Computer Software 0 0 0 0 0 N/A
52181 Business Meals/Supplies 0 0 0 0 0 N/A
52191 Utilities Expense 0 0 0 0 0 N/A
SUBTOTAL 3,393,172 10,096,340 7,790,170 4,508,670 (3,281,500) (42.12%)

OTHER CHARGES
53104 Other Interest Expense 0 0 0 0 0 N/A
53402 Depreciation Expense 5,786 6,600 6,000 8,000 2,000 33.33% 53403 Loss - Disposed Capital Asset 0 0 0 0 0 N/A 53501 Contributions 0 0 0 0 0 N/A
SUBTOTAL 5,786 6,600 6,000 8,000 2,000 0

REIMBURSEMENTS
58010 Reimb. - General 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

FIXED ASSETS
19840 Acq-WIP-Equipment 30,736 0 0 0 0 N/A
19841 Acq-WIP-Intangibles 1,233,049 3,649,142 1,200,000 488,000 (712,000) 19851 Intangible Assets - Non-amort 0 0 0 0 0 N/A SUBTOTAL 1,263,785 3,649,142 1,200,000 488,000 (712,000) (1)

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A 57012 Transfers Out - btw Govtl Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 4,662,743 13,752,082 8,996,170 5,004,670 (3,991,500) (44.37%) Adjustments to Reserves/Encumbrances:

Outstanding Encumbrances - Net Change 987,189 0
Capital Interest 0 0
Depreciation 5,786 6,000 8,000
Change in prepaid expense 0 0
Gain/loss on disposal of Capital Assets 0
Unrealized Gain/ Loss (GASB 31) 543,724 0
Audit Adjustment (A/P) 0 0
Rounding 0 0
ENDING FUND BALANCE 15,629,400 3,423,809 104,283
3/1/2023
27 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Recycled Water and Local Supply
Fund/Department No: 44220 33041200
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 256,671 294,825 268,747

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 4,289 2,000 480 6,125 5,645 1176.03% 44050 Unrealized Gains and Losses (26,323) 0 0 0 0 N/A SUBTOTAL (22,034) 2,000 480 6,125 5,645 1176.03%

INTERGOVERNMENTAL REVENUE
42358 State Other Funding 0 0 0 0 0 N/A
42619 Town of Windsor 2,271 1,223 1,223 0 (1,223) (100.00%) SUBTOTAL 2,271 1,223 1,223 0 (1,223) (100.00%)

CHARGES FOR SERVICES
45301 Charges for Services 0 0 0 0 0 N/A
45333 Recycled Water & Local Supply 33 0 0 0 0 N/A 45401 Revenue Appl PY Chgs for Svcs 0 0 0 0 0 N/A SUBTOTAL 33 0 0 0 0 0

MISCELLANEOUS REVENUE
46022 Capital Grants-State 0 0 0 0 0 N/A
46029 Donations/Contributions 0 450,000 0 0 0 N/A 46200 Revenue Appl PY Misc Revenue 0 0 0 0
46029 Donations/Contributions 0 0 0 0 0 N/A
SUBTOTAL 0 450,000 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 45,603 20,700 23,000 0 (23,000) (100.00%) 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 45,603 20,700 23,000 0 (23,000) (100.00%)
TOTAL REVENUES 25,873 473,923 24,703 6,125 (18,578) (75.21%)

EXPENDITURES

SERVICES AND SUPPLIES
51021 Communication Expense 0 0 0 0 0 N/A
51061 Maintenance - Equipment 0 0 0 0 0 N/A
51205 Advertising/Marketing Svc 0 0 0 0 0 N/A
51209 Information Tech Svc (non ISD) 0 0 0 0 0 N/A 51211 Legal Services 0 0 0 0 0 N/A
51212 Legal Services - External 0 0 0 0 0 N/A
51226 Consulting Services 0 0 0 0 0 N/A
51241 Outside Printing and Binding 0 0 0 0 0 N/A 51244 Permits/License/Fees 0 0 0 0 0 N/A
51401 Rents and Leases - Equipment 0 0 0 0 0 N/A 51601 Training Services 0 0 0 0 0 N/A
51602 Business Travel/Mileage 0 0 0 0 0 N/A
51803 Other Contract Services 0 450,000 0 0 0 N/A 51902 Telecommunication Usage 0 0 0 0 0 N/A
51915 ISD - Reprographics Services 0 0 0 0 0 N/A 51917 District Operations Chgs 0 0 0 0 0 N/A
51921 Equipment Usage Charges 0 0 0 0 0 N/A
52031 Food 0 0 0 0 0 N/A
3/1/2023
28 DRAFT
Section Title: Recycled Water and Local Supply
Fund/Department No: 44220 33041200
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change 52061 Fuel/Gas 0 0 0 0 0 N/A
52101 Other Supplies 0 0 0 0 0 N/A
52115 Books/Media/Subscriptions 0 0 0 0 0 N/A
52117 Mail and Postage Supplies 0 0 0 0 0 N/A
52141 Minor Equipment/Small Tools 0 0 0 0 0 N/A 52143 Computer Software/Licensing Fees 0 0 0 0 0 N/A 52171 Water Conservation Program 0 0 0 0 0 N/A
52191 Utilities Expense 0 0 0 0 0 N/A
SUBTOTAL 0 450,000 0 0 0 N/A

OTHER CHARGES
53103 Interest on LT Debt 0 0 0 0 0 N/A
53104 Other Interest Expense 0 0 0 0 0 N/A
53402 Depreciation Expense 5,966 6,000 6,000 6,000 0 0.00% 53501 Contributions 11,772 50,000 50,000 50,000 0 0.00% SUBTOTAL 17,738 56,000 56,000 56,000 0 0.00%

FIXED ASSETS
19831 CIP - Bldg & Impr 0 0 0 0 0 N/A
19832 CIP - Infrastructure 0 0 0 0 0 N/A
19841 Work in Progress - Intang 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A 57012 Transfers Out - btw Govtl Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 17,738 506,000 56,000 56,000 0 0.00% Adjustments to Reserves/Encumbrances:

Outstanding Encumbrances - Net Change 0 0
Change in Windsor Reserve (2,271) 0
Capital Interest 0 0 0
Depreciation 5,966 6,000 6,000
Audit Adjustment (A/P) 0 0 0
Unrealized Gain/ Loss (GASB 31) 26,323 0 0
Rounding 0 0
ENDING FUND BALANCE 294,825 268,747 224,872
3/1/2023
29 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Water Conservation
Fund
/Department No: 44225 33041300
Actual Estimated Adopted Re quested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 1,748,431 1,180,750 253,867

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 9,734 6,000 3,360 3,351 (9) (0.27%) 44050 Unrealized Gains and Losses (46,977) 0 0 0 0 N/A SUBTOTAL (37,242) 6,000 3,360 3,351 (9) (0.27%)

INTERGOVERNMENTAL REVENUE
42358 State Other Funding 3,058 669,325 61,186 1,849,210 1,788,024 2922.28% 42461 Federal Other Funding 0 935,195 935,195 0 (935,195) (100.00%) 42610 Other Governmental Agencies 0 0 0 0 0 N/A 42611 City of Santa Rosa 0 0 0 0 0 N/A
42612 City of Petaluma 0 0 0 0 0 N/A
42613 City of Rohnert Park 0 0 0 0 0 N/A
42615 City of Cotati 0 0 0 0 0 N/A
42618 City of Sonoma 0 0 0 0 0 N/A
42619 Town of Windsor 108,532 115,521 115,521 131,519 15,998 13.85% 42621 North Marin Water District 0 0 0 0 0 N/A
0 0 0 0
SUBTOTAL 111,590 1,720 ,041 1,111,902 1,980,729 868,827 78.14% Charges for Services
45301 Charges for Services 193,038 42,000 42,000 42,000 0 0.00% 45316 Water Conservation 21,498 0 0 0 0 N/A
SUBTOTAL 214,536 42,00 0 42,000 42,000 0 0.00%

MISCELLANEOUS REVENUE
46021 Capital Gains - Federal 0 0 0 0 0 N/A
46022 Capital Grants - State 0 0 0 0 0 N/A
46029 Donations/Contributions 0 280,000 1,030,000 85,000 (945,000) (91.75%) 46040 Miscellaneous Revenue 185,548 0 0 0 0 N/A 46041 Discounts Earned 0 0 0 0 0 N/A
46050 Cancelled/Stale Dated Warrants 1,400 0 0 0 0 N/A 46200 Revenue Appl PY Misc Revenue 0 0 0 0 0 N/A 46204 PY Intergovmntl Rev - Other 0 0 0 0 0 N/A 46215 Other Grants 0 0 0 0 0 N/A
SUBTOTAL 186,948 280,000 1,030,000 85,000 (945,000) (91.75%)

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 2,110,478 1,955,739 2,173,043 2,263,032 89,989 4.14% 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 2,110,478 1,955 ,739 2,173,043 2,263,032 89,989 4.14% TOTAL REVENUES 2,586,311 4,003 ,780 4,360,305 4,374,112 13,807 0.32%

EXPENDITURES

SERVICES AND SUPPLIES
51021 Communication Expense 0 0 0 0 0 N/A
51032 Janitorial Services 0 0 0 0 0 N/A
51061 Maintenance - Equipment 12,334 0 0 0 0 N/A 51071 Maintenance - Bldg & Improve 5,067 0 0 0 0 N/A 51205 Advertising/Marketing Svc 208,817 0 0 0 0 N/A 51209 Information Tech Svc (non ISD) 90 0 0 0 0 N/A 3/1/2023
30 DRAFT
Section Title: Water Conservation
Fund/Department No: 44225 33041300
Actual Estimated Adopted Re quested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change 51211 Legal Services 3,173 0 0 0 0 N/A
51214 Agency Extra/Temp Help 0 0 0 0 0 N/A
51225 Training Services 0 0 0 0 0 N/A
51230 Security Services 0 0 0 0 0 N/A
51241 Outside Printing and Binding 43,526 73,500 73,500 43,000 (30,500) (41.50%) 51244 Permits/License 0 0 0 0 0 N/A
51249 Other Professional Services 0 0 0 0 0 N/A 51250 Planning/Mapping/Inspections 0 0 0 0 0 N/A 51301 Publications and Legal Notices 0 0 0 0 0 N/A 51401 Rents and Leases - Equipment 111 0 0 0 0 N/A 51601 Training Services 4,557 0 0 0 0 N/A
51602 Business Travel/Mileage 0 13,000 13,000 13,000 0 0.00% 51605 Private Car Expense 148 150 0 0 0 N/A
51801 Other Services 0 0 0 0 0 N/A
51803 Other Contract Services 473,626 774,804 1,231,000 1,063,668 (167,332) (13.59%) 51902 Telecommunication Usage 0 0 0 0 0 N/A
51915 ISD Reprographics Services 0 0 0 0 0 N/A
51917 District Operations Chgs 1,967,816 1,962,238 1,962,238 2,049,000 86,762 4.42% 51921 Equipment Usage Charges 12,258 0 0 0 0 N/A 52021 Clothing, Uniforms 301 0 0 0 0 N/A
52031 Food 749 0 0 0 0 N/A
52042 Janitorial Supplies 225 0 0 0 0 N/A
52061 Fuel/Gas/Oil 0 0 0 0 0 N/A
52071 Materials and Supplies Expense 212,786 75,000 75,000 78,000 3,000 4.00% 52091 Memberships/Certifications 6,219 12,000 12,000 12,000 0 0.00% 52101 Other Supplies 0 0 0 0 0 N/A
52111 Office Supplies 454 0 0 0 0 N/A
52112 Office Furniture/Fixtures 0 0 0 0 0 N/A
52114 Freight/Postage 0 0 0 0 0 N/A
52115 Books/Media/Subscriptions 520 0 0 0 0 N/A 52117 Mail and Postage Supplies 2 0 0 0 0 N/A
52141 Minor Equipment/Small Tools 347 0 0 0 0 N/A 52142 Computer Equipment/Accessories 0 0 0 0 0 N/A 52162 Special Department Expense 0 0 0 0 0 N/A
52171 Water Conservation Program 43,836 501,146 433,000 294,500 (138,500) (31.99%) 52181 Business Meals/Supplies 0 0 0 0 0 N/A
SUBTOTAL 2,996,962 3,411 ,838 3,799,738 3,553,168 (246,570) (6.49%)

OTHER CHARGES
53500 Contributions Non-County Agy 0 0 0 0 0 N/A 53501 Contributions 5,500 1,515,825 967,686 1,062,074 94,388 9.75% 53502 Community Grants 3,061 3,000 0 0 0 N/A
SUBTOTAL 8,561 1,518 ,825 967,686 1,062,074 94,388 9.75%

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A 57012 Transfers Out - btw Govtl Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 3,005,523 4,930 ,663 4,767,424 4,615,242 (152,182) (3.19%) Adjustments to Reserves/Encumbrances:

Outstanding Encumbrances - Net Change 56,410 0 0
Chang
e in Windsor Reserve 233,876 0 0
Change in Prepaid Expense 0 0 0
Unrealized Gain/ Loss (GASB 31) 46,977 0 0
Post Audit Adjustment (485,731) 0 0
Rounding (1) 0 0
ENDING FUND BALANCE 1,180,750 253,867 12,737
3/1/2023
31 DRAFT
Water Transmission Budget
2023-24
Itemized Detail for Subfunds Consulting/Contractual Services Budget FY23-24
Water Management Planning
Annual Water Supply and Demand Assessment: Develop scope, cost, and schedule to complete a water supply and demand analysis and preparation and submittal of the required Annual Water Shortage Assessment Report to the Department of Water Resources by July 1 each year. Results of the Annual Assessment are also required to inform the work of Sonoma Water’s contractors’ Assessment Reports to DWR. In 21/22, the 2020 UWMP was verified complete by DWR. Work to complete the update to the Water Shortage Allocation Methodology and Model continued, with Board adoption of the methodology in January 2022. Final minor changes to the Water Shortage Allocation Model were completed in July 2022. 50,000$
Watershed Planning/Restoration
RRIFR Decision 1610 Change Petition: Russian River Flows: Continued preparation of Environmental Impact Report for Fish Habitat Flows and Water Rights Project (Fish Flow Project EIR) in preparation for Board of Directors consideration for certification. Consultant services for responses to comments on the Draft EIR, preparation of recirculated Draft EIR, and any additional impact analysis, flow modeling, and monitoring, needed. Fish Flow Project EIR. The EIR is being prepared by Sonoma Water staff, with assistance from consultants on some areas of analysis. A Draft EIR was released on August 19, 2016. In FY21/22, most of the work focused on preparing the recirculated Draft EIR. Work also includes submission of annual Temporary Urgency Change (TUC) Petitions to the State Board to approve the requested changes to minimum in-stream flows as identified in the Biological Opinion and fisheries and water quality monitoring and reporting required by any State Board TUC Order. Work being accomplished in FY22/23 includes updates to modeling and project analysis, and lab analysis for water quality monitoring under the multiple TUC Orders issued in 2022. Work anticipated for FY23/24 includes work on the recirculated draft EIR as well as lab analysis for water quality monitoring related to the annual TUC. 183,000$
RRIFR Estuary Management: Required Annual Biological Opinion Activities: Sonoma Water, in consultation with the National Marine Fisheries Service (NMFS), California Department of Fish & Wildlife (CDFW) and the U.S. Army Corps of Engineers (Corps), is required to annually prepare a lagoon outlet adaptive management plan by April 1; conduct and record monthly surveys of the beach topography and the outlet channel; use a time lapse video camera to record the interaction of waves, tides and the river mouth; conduct baseline monitoring of seals and other pinnipeds, conduct estuary water quality monitoring, conduct juvenile steelhead and coho salmon rearing surveys, and prepare annual reports. Other FY21/22 and FY22/23 activities include installation and monitoring of downstream migrant salmonid traps and water quality monitoring stations, and flood risk feasibility studies. Work being completed in FY22/23 and includes preparation of the annual adaptive management plan, renewing regulatory permits, and continuation of monitoring and studies. Work anticipated for FY23/24 includes renewing regulatory permits and monitoring studies. 430,000$
Upper Russian River Water Quality Monitoring: This water quality monitoring was conducted in FY21/22 for the Upper Russian River, including the East Fork Russian River above Lake Mendocino and Lake Mendocino to contribute to planning and modeling efforts for the Potter Valley Project (PVP), Lake Mendocino management, Fish Habitat Flows and Water Rights Project, the Forecast Informed Reservoir Operations (FIRO) projects, and the ongoing drought conditions. Monitoring included the deployment of datasondes and collection of grab samples, as well as laboratory analysis. Work anticipated for FY22/23 includes the efforts described above.
23,000$
3/1/2023
32 DRAFT
Water Transmission Budget
2023-24
Itemized Detail for Subfunds Consulting/Contractual Services Budget FY23-24
Winter Russian River Algae /WQ Monitoring : This water quality monitoring was conducted for over winter water quality and algae monitoring on the mai
nstem Russian River to collect data on conditions during changes in watershed hydrology. Monitoring included deployment of datasondes, collection of grab samples, sampling of algae, as well as laboratory analysis. Work anticipated for FY22/23 and FY 23/24 includes the lab analysis related to water quality monitoring grab sampling efforts described above.
14,000$
PVP RR Water Forum: This line item is for Phase 2 of the Two Basin Solution. It reflects a match contribution for the submitted DWR 2022 Urban Community Drought Relief Grant Program which will be funded by County of Sonoma, County of Mendocino, Sonoma Water, and the Water Contractors. 150,000$ Landscape Resiliency: Build fire landscape resiliency through vegetation management at Lake Sonoma to protect source water quality in partnership with the U.S. Army Corps. 100,000$
900,000$
Recycled Water and Local Supply
Funding for Groundwater Management in FY 23/24 for Groundwater Sustainability activities. 50,000$ 50,000$
Water Conservation
51241-Outside Printing and Binding
WUE/Water Ed Program materials, Eco-Friendly Garden Tour materials. 43,000$ 51602-Business Travel/Mileage
Attend local and statewide meetings representing the Partnership and Sonoma Water 13,000$ 51803-Other Contract Services
Cotati Water Conservation Program: Funding to provide residential water assessments and other water conservation program services 8,000$ Garden Sense Contract: Funding provides onsite visits by local master gardeners to support local turf removal programs 20,000$ Green Business Program: Funding to staff a part time position which provides water assessments for local businesses pursuing the Green Business Certification 30,000$
Online Educational Content: Development of online educational content 25,000$ Plant Labeling Program: Funding for nursery liaison to ensure locally appropriate plants are labeled 25,000$ QWEL: Instructors to teach QWEL trainings and Database maintenance contract 68,000$ Sonoma County Fair: Fair materials and hardware that are WUE focused for distribution at the Sonoma County fair 15,000$ SMSWP website: Website hosting, maintenance, and development. 4,000$ Spatial Analysis: Analysis for CII customers of the Partnership to provide landscape area measurements and non-functional turf data 120,000$ Water Ed Bus Contract: Shuttle from school to field study sites for Water Education Program 50,000$ Water Loss Programs: Technical assistance for regional water loss meetings, regional program assistance, and validation services for contractor annual water loss audits 12,000$
WaterSmart Plant Kit Program: DIY residential turf conversion program providing scalable design choices and corresponding low water use plants from local nurseries. 666,668$
Water Use Efficiency Videos: How-to video series of water use efficiency best practices. 20,000$ 1,063,668$
3/1/2023
33 DRAFT
Water Transmission Budget
2023-24
Itemized Detail for Subfunds Consulting/Contractual Services Budget FY23-24
51917-District Operations Chgs
Salaries, benefits and overhead costs for staff assigned to projects budgeted within the Water Conservation Fund 2,049,000$ 52071-Materials and Supplies Expense
Water Ed Teaching Materials: pH strips, fabric for displays, youth outreach displays, pencil sharpeners, pencils, classroom testing kits, maps, workbooks, rulers, toothbrushes, stickers, etc. 78,000$
52091-Memberships/Certifications
Irrigation Association Certificate Renewals, Water Education Foundation, and California Water Efficiency Partnership, Alliance for Water Efficiency, etc. 12,000$ 52171-Water Conservation Program
Outdoor Water Use Focused Programs: Qualified Water Efficient Landscaper Training in English and Spanish, Russian River Friendly Workshops, Living Learning Landscapes Demo Gardens, etc.
1,500$
Public Information/Outreach Programs: Media campaign for the Sonoma-Marin Saving Water Partnership including media ad buy, ad development, DIY toolkits
183,000$
Saving Water Partnership Wholesaler Support: Act as the regional liaison attend meetings of the CalWEP, Alliance for Water Efficiency, Independent Technical Panel, Urban Advisory Group, CA Science Teachers Association, environmental education conference 20,000$
School Education Program: Such as assembly program, RAY Fellowship, port-a-potties, steelhead in the classroom program, youth outreach events, teacher program, teacher trainings, educational workbooks, maps 70,000$
Seminars, Workshops, Training: Host trainings/ workshops to benefit the Partnership, such as Water Loss, WELO; Participation in national/statewide studies such as those conducted by CalWEP and AWE
20,000$
294,500$
Total 3,553,168$
3/1/2023
34 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Santa Rosa Aqueduct Capital Fund
Fund/Department No: 44230 33045000
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 8,399,534 9,118,684 8,475,980

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 49,731 26,400 26,400 217,372 190,972 723.38% 44003 O
ther Interest Earnings 0 0 0 0 0 N/A
44050 Unrealized Gains & Loss (305,468) 0 0 0 0 N/A

SUBTOTAL (
255,737) 26,400 26,400 217,372 190,972 723. 38%

MISCELLANEOUS REVENUES
46040 Miscellaneous Revenue 0 0 0 0 0 N/A
46021 Capital Grants - Federal 43,397 0 0 0 0 N/A 46029 Donations/Contributions 0 0 0 0 0 N/A
46050 Cancelled/Stale Dated W 0 0 0 0 0 N/A
SUBTOTAL 43,
397 0 0 0 0 N/A

ADMINISTRATIVE CONTROL ACCOUNT
49002 Advances 0 0 0 0 0 N/A
49003 Advances
Clearing 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a F 417,654 279,159 279,159 298,319 19,161 6.86% 47102 Transfers In - btw Govtl 0 0 0 0 0 N/A
SUBTOTAL 417,
654 279,159 279,159 298,319 19,161 6. 86%

SPECIAL ITEMS
48004 Residual Equity Transfe 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/
A
TOTAL REVENUES 205,314 305,559 305,559 515,691 210,133 68. 77%

EXPENDITURES

OTHER CHARGES
53103 Interest on LT Debt 0 0 0 0
53104 Other Interest Expense 0 0 0 0
53105 Costs of Issuance 0 0 0 0
SUBTOTAL 0 0 0 0 0 N/A

FIXED ASSETS
19820 Machinery and Equipme 0 0 0 0
19822 Mobile E
quipment 0 0 0 0
19824 Computer Equipment 0 0 0 0
19831 CIP - Bldg & Impr 0 0 0 0
19832 CIP - Infrastructure 6,736 948,263 50,000 0 (50,000) (100.00%) 19840 Work in Progress - Eqt 0 0 0 0
3/1/2023
35 DRAFT
Section Title: Santa Rosa Aqueduct Capital Fund
Fund/Department No: 44230 33045000
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change 19841 Work in Progress - Intan 0 0 0 0
19851 Intangible Assets - Non- 0 0 0 0
SUBTOTAL 6,736 948,263 50,000 0 (50,000) ( 100.00%)

OTHER FINANCING USES
57011 Transfers Out - within a 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/
A
TOTAL EXPENDITURES 6,736 948,263 50,000 0 (50,000) ( 100.00%) Adjustments to Reserves/Encumbrances:

Repayment of Loan to Storage 0 0 0
Unrealized Gain/ Loss (GASB 31) (15,000) 0 0
Capitalized Interest 305,468 0 0
Post Audit Adjustment 230,103 0 0
Rounding 2 0 0
ENDING FUND BALANCE 9,118,684 8,475,980 8,991,671
3/1/2023
36 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Petaluma Aqueduct Capital Fund
Fund/Department No: 44235 33045100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 8,020,746 7,843,323 6,524,167

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 45,260 33,120 33,120 127,610 94,490 285.30% 44003 Other Interest Earnings 0 0 0 0 0 N/A
44050 Unrealized Gains & Losses (267,243) 0 0 0 0 N/A SUBTOTAL (221,983) 33,120 33,120 127,610 94,490 285. 30%

MISCELLANEOUS REVENUE
46021 Capital Gains - Federal 161,430 1,990,074 0 0 0 N/A SUBTOTAL 161,430 1,990,074 0 0 0 N/A

ADMINISTRATIVE CONTROL ACCOUNT
49002 Advances 0 0 0 0 0 N/A
49003 Advances Clearing 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 296,424 155,228 155,228 0 ( 155,228) (100.00%) 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 296,424 155,228 155,228 0 (155,228) (100.00%)
TOTAL REVENUES 235,871 2,178,422 188,348 127,610 (60, 738) (32.25%)

EXPENDITURES

OTHER CHARGES
53103 Interest on LT Debt 0 0 0 0
53104 Other Interest Expense 0 0 0 0
53105 Costs of Issuance 0 0 0 0
53403 Loss - Disposed Capital Asset 0 0 0 0
SUBTOTAL 0 0 0 0 0 N/A

FIXED ASSETS
19820 Machinery and Equipment 0 0 0 0
19822 Mobile Equipment 0 0 0 0
19824 Computer Equipment 0 0 0 0
19831 CIP - Bldg & Impr 0 0 0 0
19832 CIP - Infrastructure 674,184 3,490,578 941,215 3,168,900 2,227,685 236.68% 19840 Work in Progress - Eqt 0 0 0 0 0 N/A
19841 Work in Progress - Intang 10,679 7,000 0 0 0 N/A 19851 Intangible Assets - Non-amort 0 0 0 0
SUBTOTAL 684,863 3,497,578 941,215 3,168,900 2,227,685 236.68% 3/1/2023
37 DRAFT
Section Title: Petaluma Aqueduct Capital Fund
Fund/Department No: 44235 33045100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change

SPECIAL ITEMS
56030 Residual Equity Transfers 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/
A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOT
AL EXPENDITURES 684,863 3,497,578 941,215 3,168,900 2, 227,685 236.68% Adjustments to Reserves/Encumbrances:

Advance to Common 0 0 0
Increase/(Decrease) in Loan Payable 0 0 0
Capitalized Interest 0 0 0
Loss on Fixed Asset 0 0 0
Principal Received on Loan 0 0 0
Change in Encumbrances 4,325 0 0
Donated Asset 0 0 0
Unrealized Gain/ Loss (GASB 31) 267,243 0 0
Rounding 1
ENDING FUND BALANCE 7,843,323 6,524,167 3,482,877
3/1/2023
38 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Sonoma Aqueduct Capital Fund
Fund/Department No: 44240 33045200
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 662,993 126,146 247,354

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 12,728 480 480 6,350 5,870 1222.82% 44003 Other Interest Earnings 0 0 0 0 0 N/A
44050 Unrealized Gains & Losses (17,866) 0 0 0 0 N/A SUBTOTAL (5,138) 480 480 6,350 5,870 1222.82%

MISCELLANEOUS REVENUES
46200 Transfers In - within a Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 547,544 145,727 145,727 127,572 (18,155) (12.46%) 47102 Transfers In - btw Govtl Fund 0 0 155,000 155,000 0 0.00% SUBTOTAL 547,544 145,727 300,727 282,572 (18,155) (6.04%)

SPECIAL ITEMS
48004 Residual Equity Transfers 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A
TOTAL REVENUES 542,406 146,207 301,207 288,922 (12,286) (4.08%)

EXPENDITURES

OTHER CHARGES
53103 Interest on LT Debt 0 0 0 0
53104 Other Interest Expense 0 0 0 0
53105 Costs of Issuance 0 0 0 0
53403 Loss-Disposed Capital Asset 0 0 0 0
SUBTOTAL 0 0 0 0 0 N/A

FIXED ASSETS
19820 Machinery and Equipment 0 0 0 0
19822 Mobile Equipment 0 0 0 0
19824 Computer Equipment 0 0 0 0
19831 CIP - Bldg & Impr 0 0 0 0
19832 CIP - Infrastructure 1,338,547 25,000 25,000 283,150 258,150 1032.60% 19840 Work in Progress - Eqt 0 0 0 0
19841 Work in Progress - Intang 0 0 0 0
19851 Intangible Assets - Non-amor 0 0 0 0
SUBTOTAL 1,338,547 25,000 25,000 283,150 258,150 1032.60%

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 1,338,547 25,000 25,000 283,150 258,150 1032.60% Adjustments to Reserves/Encumbrances:

Outstanding Encumbrances - Net Change 471,530 0 0
Sale or Purchase of Fixed Asset 0 0 0
Unrealized Gain/ Loss (GASB 31) 17,866 0 0
Post Audit Adjustment (230,103)
Rounding 1 0 0
ENDING FUND BALANCE 126,146 247,354 253,125
3/1/2023
39 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Storage Facilities
Fund/Department No: 44250 33043000
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 1,078,199 1,279,741 462,652

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 6,234 3,000 0 5,412 5,412 N/A 44050 Unrealized Gains & Losses (36,048) 0 0 0 0 N/A SUBTOTAL (29,814) 3,000 0 5,412 5,412 N/A

MISCELLANEOUS REVENUE
46021 Capital Grants - Federal 0 0 0 0 0 N/A
46022 Capital Grants - State 0 0 0 0 0 N/A
46029 Donations/Contributions 0 0 0 0 0 N/A
46040 Miscellaneous Revenue 0 0 0 0 0 N/A
46041 Discounts Earned 0 0 0 0 0 N/A
46200 PY Revenue - Miscellaneous 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A
Administrative Control
49002 Advances 0 0 0 0 0 N/A
49003 Advances Clearing 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 356,657 220,000 220,000 117,000 (103,000) (46.82%) 47102 Transfers In - btw Govtl Funds 0 900,000 900,000 288,000 (612,000) (68.00%) SUBTOTAL 356,657 1,120,000 1,120,000 405,000 (715,000) (63.84%) TOTAL REVENUES 326,843 1,123,000 1,120,000 410,412 (709,588) (63.36%)

EXPENDITURES

OTHER CHARGES
53103 Interest on LT Debt 0 0 0 0 0 N/A
53104 Other Interest Expense 0 0 0 0 0 N/A
53403 Loss - Disposed Capital Asset 0 0 0 0
SUBTOTAL 0 0 0 0 0 N/A

FIXED ASSETS
19831 CIP - Bldg & Impr 0 0 0 0 0 N/A
19832 CIP - Infrastructure 105,823 1,886,928 1,100,000 897,335 (202,665) (18.42%) 19841 Acq-WIP-Intangibles 9,133 53,161 0 0 0 N/A 19851 Intangible Assets - Non-amort 0 0 0 0 0 N/A SUBTOTAL 114,956 1,940,089 1,100,000 897,335 (202,665) (18.42%) 3/1/2023
40 DRAFT
Section Title: Storage Facilities
Fund/Department No: 44250 33043000
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change

ADMINISTRATIVE CONTROL ACCOUNT
59002 Advances 0 0 0 0 0 N/A
59003 Advances Clearing 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 114,956 1,940,089 1,100,000 897,335 (202,665) (18.42%) Adjustments to Reserves/Encumbrances:

Repayment of Loan from SR Aqueduct Cap 0 0 0
Princ. Pymnt on loan from SR Aqueduct Ca 0 0 0
Advances 0 0 0
Outstanding Encumbrances - Net Change 0 0 0
PY CIP adjustment - reclass to PY Exp 0 0 0
B & I Tsfrs 0 0 0
LTD Proceeds 0 0 0
Sold Asset 0 0 0
Capitalized Interest 0 0 0
Move Project CIP Balance 0 0 0
Gain/loss on disposal of Capital Assets 0 0 0
Unrealized Gain/ Loss (GASB 31) 36,048 0 0
Change in Encumbrances (46,393) 0 0
Rounding 1 0 0
ENDING FUND BALANCE 1,279,741 462,652 (24,271)
3/1/2023
41 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Common Facilities
Fund/Department No: 44260 33043200
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 11,978,801 5,478,792 4,964,324

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 79,190 60,000 4,800 68,343 63,543 1323.81% 44003 Other Interest Earnings 0 0 0 0 0 N/A
44050 Unrealized Gains & Losses (361,419) (10,000) 0 0 0 N/A SUBTOTAL (282,229) 50,000 4,800 68,343 63,543 1323. 81%

CHARGES FOR SERVICES
45062 Construct/Bldg Permit Rvw Svc 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/
A

MIECELLANEOUS REVENUES
46021 Capital Grants - Federal 2,360,232 217,505 0 0 0 N/A 46022 Capital Grants - State 694,516 5,759,588 3,900,000 1,140,000 (2,760,000) (70.77%) 46029 Donations/Contributions 0 0 0 0 0 N/A
46040 Miscellaneous Revenue 254,106 0 0 0 0 N/A 46041 Discounts Earned 0 0 0 0 0 N/A
46200 Revenue Appl PY Misc Revenu 1,730 0 0 0 0 N/A SUBTOTAL 3,
310,584 5,977,093 3,900,000 1,140, 000 (2,760,000) (70.77%)

ADMINISTRATIVE CONTROL
49002 Advances 0 0 0 0 0 N/A
49003 Advances Clearing 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 2,140,661 11,100,000 6,100,000 2,300,000 (3,800,000) (62.30%) 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 2,140,661 11,100,000 6,100,000 2,300, 000 (3,800,000) (62.30%) TOTAL REVENUES 5,169,016 17,127,093 10,004,800 3,508, 343 (6,496,457) (64.93%)

EXPENDITURES

OTHER CHARGES
53103 Interest on LT Debt 0 0 0 0 0 N/A
53104 Other
Interest Expense 0 0 0 0 0 N/A
53403 Loss - Disposed Capital Asset 1,059,243 0 0 0 0 N/A SUBTOTAL 1,059,243 0 0 0 0 N/A

FIXED ASSETS
19810 Land 0 0 0 0 0 N/A
19812 Acq-CIP-Land 22,233 0 0 0 0 N/A
19831 CIP - Bldg & Impr 0 0 0 0 0 N/A
19832 CIP - Infrastructure 12,227,806 16,641,561 11,134,466 7,926,200 (3,208,266) (28.81%) 19840 Acq-WIP-Equipment 0 0 0 0 0 N/A
19841 Work in Progress - Intang 2,694 500,000 0 0 0 N/A 3/1/2023
42 DRAFT
Section Title: Common Facilities
Fund/Department No: 44260 33043200
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change 19851 Intangible Assets - Non-amort 0 500,000 0 0 0 N/A SUBTOTAL 12,252,733 17,641,561 11,134,466 7,926, 200 (3,208,266) (28.81%)

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A

ADMINISTRATIVE CONTROL ACCOUNT
59002 Advances 0 0 0 0 0 N/A
59003 Advances Clearing 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A
TOT
AL EXPENDITURES 13,311,975 17,641,561 11,134,466 7,926, 200 (3,208,266) (28.81%) Adjustments to Reserves/Encumbrances:

Loan from Petaluma Aqueduct Capital Fund 0 0 0
Technic
al Adjustments - BRO's 0 0 0
Principal payment on Loan from Petaluma A 0 0 0
Advances 0 0 0
Outstanding Encumbrances - Net Change 714,080 0 0
Capital
ized Interest 0 0 0
Gain/loss on disposal of Capital Assets 1,059,243 0 0
Proceeds from State Loan & Other LT Debt 0 0 0
PY CIP adjustment - reclass to PY Exp (loss 0 0 0
B & I Tsfr
to ISF (Facilities) Fund 0 0 0
Auditor Adj - Reversal of Duplicate Pymt 0 0 0
Sale or Purchase of Fixed Asset 0 0 0
Change in Deposit w/Others 0 0 0
Move Project CIP Balance 0 0 0
Change in Contingent Liability 0 0 0
Post Audit Adjustment (491,790) 0 0
Unrealized Gain/ Loss (GASB 31) 361,419 0 0
Rounding (1) 0 0
ENDING FUND BALANCE 5,478,792 4,964,324 546,467
3/1/2023
43 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: North Marin Water Deposit
Fund/Department No: 44300 33045300
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE 1,127,825 28,095 28,175

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 6,486 81 81 710 629 779.98% 44050 Unrealized Gains and Losses (39,055) 0 0 0 0 N/A SUBTOTAL (32,569) 81 81 710 629 779.98%
Intergovernmental Revenue
42610 Other Governmental Agencies 52,545 0 0 0 0 N/A SUBTOTAL 52,545 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL REVENUES 19,977 81 81 710 629 779.98%

EXPENDITURES

OTHER CHARGES
53501 Contributions 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 1,106,217 0 0 0 0 N/A SUBTOTAL 1,106,217 0 0 0 0 N/A
TOTAL EXPENDITURES 1,106,217 0 0 0 0 N/A
Adjustments to Reserves/Encumbrances:

Unrealized Gain/ Loss (GASB 31) 39,055 0
Post Audit Adjustment (52,545) 0
Post Audit Adjustment 0 0
Rounding 0 (1)
ENDING FUND BALANCE 28,095 28,175 28,884
3/1/2023
44 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: State Loan Debt Service Fund
Fund/Department No: 44265 33047000
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE $606,376 $638,781 $651,789

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 8,417 1,920 1,920 17,189 15,269 795.28% 44003 Other Interest Earnings 0 0 0 0 0 N/A
44050 Unrealized Gains and Losses (55,253) 0 0 0 0 N/A SUBTOTAL (46,836) 1,920 1,920 17,189 15,269 795.28%

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 1,196,267 1,196,268 1,196,268 1,196,268 0 0.00% 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 1,196,267 1,196,268 1,196,268 1,196,268 0 0.00% TOTAL REVENUES 1,149,431 1,198,188 1,198,188 1,213,457 15,269 1.27%

EXPENDITURES

OTHER CHARGES
53103 Interest on LT Debt 177,619 153,355 153,355 153,355 0 0.00% SUBTOTAL 177,619 153,355 153,355 153,355 0 0.00%

OTHER FINANCING USES
57011 Transfers Out - within a Fund 120,000 120,000 120,000 120,000 0 0.00% SUBTOTAL 120,000 120,000 120,000 120,000 0 0.00%
ADMIN. CONTROL ACCOUNT
59002 Advances 862,613 886,878 886,878 886,878 0 0.00%
59003 Advances Clearing (862,613) (886,878) (886,878) (886,878) 0 0.00% SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 297,619 273,355 273,355 273,355 0 0.00% Adjustments to Reserves/Encumbrances:

Principal payments on loan (874,661) 0
(Increase) / Decrease in Principal Payable 0 (911,825) (839,012) Advances from Other Govt 55,253 0 (22,328)
Unrealized Gain/ Loss (GASB 31) 1 0 0
Rounding 0 0 0
ENDING FUND BALANCE $638,781 $651,789 $730,551
3/1/2023
45 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: State Loan Reserve Fund
Fund/Department No: 44270 33047100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE $0 ($0) ($0)

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 0 0 0 (0) (0) N/A 44003 Other I
nterest Earnings 0 0 0 0 0 N/A
44050 Unreali
zed Gains and Losses (45,179) 0 0 0 0 N/A
SUBTOTAL (45,179) 0 0 (0) (0) N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL REVENUES (45,179) 0 0 (0) (0) N/A

EXPENDITURES

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 0 0 0 0 0 N/A
Adju
stments to Reserves/Encumbrances:

Increase in Reserve 0 0 0
Unrealized Gain/ Loss (GASB 31) 45,179 0
Rounding 0 0
ENDING FUND BALANCE ($0) ($0) ($0)
3/1/2023
46 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Storage Facilities Revenue Bond - 2012A
Fund/Department No: 44280 33047300
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE $110,231 $140 $139

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 366 0 0 3 3 #########
44003 Other Interest Earnings 263 0 0 0 0 N/A
44050 Unrealized Gains and Losses (5,368) 0 0 0 0 N/A SUBTOTAL (4,739) 0 0 3 3 #########

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 309,610 0 308,325 0 (308,325) (100.00%) 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 309,610 0 308,325 0 (308,325) (100.00%)

SPECIAL ITEMS
48004 Transfers In - within a Fund 2,526,439 0 0 0 0 N/A SUBTOTAL 2,526,439 0 0 0 0 N/A
TOTAL REVENUES 2,831,310 0 308,325 3 (308,322) (100.00%)

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 884 0 1,000 0 (1,000) (100.00%)
SUBTOTAL 884 0 1,000 0 (1,000) (100.00%)

OTHER CHARGES
53103 Interest on LT Debt 76,338 0 72,300 0 (72,300) (100.00%) 53104 Other Interest Expense (5,056) 0 5,526 0 (5,526) (100.00%) 53105 Costs of Issuance 0 0 0 0 0 N/A
SUBTOTAL 71,282 0 77,826 0 (77,826) (100.00%)

OTHER CHARGES
56030 Interest on LT Debt 483,013 0 0 0 0 N/A
SUBTOTAL 483,013 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 206,657 0 70,000 0 (70,000) (100.00%) SUBTOTAL 206,657 0 70,000 0 (70,000) (100.00%)
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 183,077 0 189,283 0 (189,283) (100.00%) 59005 Admin Control Acct Clearing (183,077) 0 (189,283) 0 189,283 (100.00%) SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 761,836 0 148,826 0 (148,826) (100.00%) Adjustments to Reserves/Encumbrances:

Principal payments on bonds 0 0 0
Restricted cash with trustee (reserve) 0
Debt Issuance Costs
(Increase) / Decrease in Bonds Payable 0
Amortization of bond discount 0 0 0
Amortization of deferred amount of refunding 60,786 0 0 Changed in Reserved Fund Balance 260,067
Unrealized Gain/ Loss (GASB 31) 5,368
Change in Principal - Refund of Debt (2,392,413)
Change in bond premium - Refund of Debt (113,373)
Rounding 0 (1)
ENDING FUND BALANCE $140 $139 $142
3/1/2023
47 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Common Facilities Revenue Bonds - 2012 A Fund/Department No: 44275 33047200
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEG. FUND BALANCE $398,235 $194 $194

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 1,443 0 1,440 99 (1,341) (93.15%) 44003 Other Interest Earnings 368 0 0 0 0 N/A
44050 Unrealized Gains and Losses (15,981) 0 0 0 0 N/A SUBTOTAL (14,170) 0 1,440 99 (1,341) (93.15%)

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 433,705 0 431,907 0 (431,907) (100.00%) 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 433,705 0 431,907 0 (431,907) (100.00%)

SPECIAL ITEMS
48004 Transfers In - within a Fund 3,467,653 0 0 0 0 N/A SUBTOTAL 3,467,653 0 0 0 0 N/A
TOTAL REVENUES 3,887,188 0 433,347 99 (433,248) (99.98%)

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 1,138 0 1,500 0 (1,500) (100.00%)
SUBTOTAL 1,138 0 1,500 0 (1,500) (100.00%)

OTHER CHARGES
53103 Interest on LT Debt 106,893 0 101,239 0 (101,239) (100.00%) 53104 Other Interest Expense (6,539) 0 7,787 0 (7,787) (100.00%) 53105 Costs of Issuance 0 0 0 0 0 N/A
SUBTOTAL 100,354 0 109,026 0 (109,026) (100.00%)

OTHER CHARGES
56030 Interest on LT Debt 676,343 0 0 0 0 N/A
SUBTOTAL 676,343 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 464,444 0 0 0 0 N/A SUBTOTAL 464,444 0 0 0 0 N/A
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 256,355 0 265,045 0 (265,045) (100.00%) 59005 Admin Control Acct Clearing (256,355) 0 (265,045) 0 265,045 (100.00%) SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 1,242,279 0 110,526 0 (110,526) (100.00%) Adjustments to Reserves/Encumbrances:

Principal payments on bonds 0 0 0
(Increase) / Decrease in Bonds Payable 0 0 0
Restricted cash with trustee (reserve) 364,160 0 0
Amortization of bond discount 0 0 0
Amortization of bond premium 0 0 0
Amortization of deferred amount of refunding 85,656 0 0 Unrealized Gain/ Loss (GASB 31) 15,981 0 0
Change in Principal - Refund of Debt (3,349,995)
Change in bond premium - Refund of Debt (158,752)
Rounding 0 0
ENDING FUND BALANCE $194 $194 $293
3/1/2023
48 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Sonoma Aqueduct Revenue Bonds 2012
Fund/Department No: 44285 33047400
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE $134,670 $114 $114

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 470 0 960 65 (895) (93.19%) 44003 Other Interest Earnings 216 0 0 0 0 N/A
44050 Unrealized Gains and Losses (5,935) 0 0 0 0 N/A SUBTOTAL (5,249) 0 960 65 (895) (93.19%)

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 254,884 (0) 253,827 0 (253,827) (100.00%) 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 254,884 (0) 253,827 0 (253,827) (100.00%)

SPECIAL ITEMS
48004 Transfers In - within a Fund 2,036,697 0 0 0 0 N/A SUBTOTAL 2,036,697 0 0 0 0 N/A
TOTAL REVENUES 2,286,333 (0) 254,787 65 (254,722) (99.97%)

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 775 0 1,000 0 (1,000) (100.00%)
SUBTOTAL 775 0 1,000 0 (1,000) (100.00%)

OTHER CHARGES
53103 Interest on LT Debt 62,783 0 59,462 0 (59,462) (100.00%) 53104 Other Interest Expense (3,723) 0 4,585 0 (4,585) (100.00%) 53105 Costs of Issuance 0 0 0 0 0 N/A
53109 Capitalized Interest 0 0 0 0 0 N/A
SUBTOTAL 59,060 0 64,047 0 (64,047) (100.00%)

OTHER CHARGES
56030 Interest on LT Debt 397,245 0 0 0 0 N/A
SUBTOTAL 397,245 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 173,224 0 0 0 0 N/A SUBTOTAL 173,224 0 0 0 0 N/A
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 150,568 (155,672) 0 0 0 N/A 59005 Admin Control Acct Clearing (150,568) 155,672 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 630,304 0 65,047 0 (65,047) (100.00%) Adjustments to Reserves/Encumbrances:
(Increase)/Decrease in Bonds Payable
Principal Payments on Bonds 0 0 0
Amortization of bond discount 0 0 0
Change in Reserved Fund Balance 213,887 0 0
Capitalized Interest 0 0 0
Amortization of deferred amount of refundin 50,427 0 0
Change in Principal - Refund of Debt (1,967,592)
Change in bond premium - Refund of Debt (93,242)
Unrealized Gain/ Loss (GASB 31) 5,935 0 0
Rounding 0 0 0
ENDING FUND BALANCE $114 $114 $179
3/1/2023
49 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Storage Facilities Revenue Bonds 2015
Fund/Department No: 44290 33047500
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE $212,358 $131,617 $49,750

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 1,730 432 432 651 219 50.61% 44003 Other Interest Earnings 170 0 0 0 0 N/A
44050 Unrealized Gains and Losses (9,646) 0 0 0 0 N/A SUBTOTAL (7,746) 432 432 651 219 50.61%
Miscellaneous Revenues
46200 PY Revenue - Miscellaneous 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 476,381 480,268 480,268 477,198 (3,069) (0.64%) 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 476,381 480,268 480,268 477,198 (3,069) (0.64%) TOTAL REVENUES 468,635 480,700 480,700 477,849 (2,851) (0.59%)

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 1,174 1,500 1,500 1,500 0 0.00%
SUBTOTAL 1,174 1,500 1,500 1,500 0 0.00%

OTHER CHARGES
53103 Interest on LT Debt 169,148 157,214 157,214 144,521 (12,693) (8.07%) 53104 Other Interest Expense (11,468) 5,058 5,058 5,058 0 0.00% 53105 Costs of Issuance 0 0 0 0 0 N/A
53109 Capitalized Interest 0 0 0 0 0 N/A
SUBTOTAL 157,680 162,272 162,272 149,579 (12,693) (7.82%)

OTHER FINANCING USES
57011 Transfers Out - within a Fund 150,000 150,000 150,000 117,000 (33,000) (22.00%) 57012 Transfers Out - btw Govtl Fund 0 0 0 0 0 N/A SUBTOTAL 150,000 150,000 150,000 117,000 (33,000) (22.00%) ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 238,545 253,852 253,852 263,876 10,024 3.95% 59005 Admin Control Acct Clearing (238,545) (253,852) (253,852) (263,876) (10,024) 3.95% SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 308,854 313,772 313,772 268,079 (45,693) (14.56%) Adjustments to Reserves/Encumbrances:

Change in Principal due to Bond Reallocation 0
Change in Bond Premium due to Bond Realloc 0
Capitalized Interest 0
Loss on Refunding of Debt 5,058 5,058 5,058
Principal Payment (238,545) (253,852) (263,876)
Special Fund Stmts'!B449 0 0 0
Amortization of Bond Premium (16,526) 0 0
Change in Reserved Fund Balance (156)
Unrealized Gain/ Loss (GASB 31) 9,646
Rounding 0 (0)
ENDING FUND BALANCE $131,617 $49,750 $702
3/1/2023
50 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Common Facilities Revenue Bonds 2015
Fund/Department No: 44295 33047600
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEG. FUND BALANCE $482,808 $351,484 $338,871

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 3,994 2,400 2,400 8,381 5,981 249.22% 44003 Other Interest Earnings 167 0 0 0 0 N/A
44050 Unrealized Gains and Losses (22,436) 0 0 0 0 N/A SUBTOTAL (18,275) 2,400 2,400 8,381 5,981 249.22%

MISCELLANEOUS REVENUES
46200 PY Revenue - Miscellaneous 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 1,224,505 1,230,285 1,230,285 1,228,700 (1,585) (0.13%) 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 1,224,505 1,230,285 1,230,285 1,228,700 (1,585) (0.13%) TOTAL REVENUES 1,206,230 1,232,685 1,232,685 1,237,082 4,397 0.36%

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 2,075 2,500 2,500 2,500 0 0.00%
SUBTOTAL 2,075 2,500 2,500 2,500 0 0.00%

OTHER CHARGES
53103 Interest on LT Debt 483,196 454,461 454,461 424,044 (30,417) (6.69%) 53104 Other Interest Expense (25,008) 4,516 4,516 4,516 0 0.00% 53105 Costs of Issuance 0 0 0 0 0 N/A
53109 Capitalized Interest 0 0 0 0 0 N/A
SUBTOTAL 458,188 458,977 458,977 428,560 (30,417) (6.63%)

OTHER FINANCING USES
57011 Transfers Out - within a Fund 300,000 180,000 180,000 180,000 0 0.00% 57012 Transfers Out - btw Govtl Fund 0 0 0 0 0 N/A SUBTOTAL 300,000 180,000 180,000 180,000 0 0.00%
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 574,580 608,336 608,336 637,375 29,039 4.77% 59005 Admin Control Acct Clearing (574,580) (608,336) (608,336) (637,375) (29,039) 4.77% SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 760,263 641,477 641,477 611,060 (30,417) (4.74%) Adjustments to Reserves/Encumbrances:

Principal Payment (574,580) (608,336) (637,375)
Change in Principal due to Bond Reallocat 0 0 0
Change in Bond Premium due to Bond Rea 0 0 0
Revenue Bonds Pay - Change in Current B 0 0 0
Amortization of Bond Premium (29,523) 0 0
Capitalized Interest 0
Change in Reserved Fund Balance (139)
Loss on Refunding Debt 4,515 4,515 0
Unrealized Gain/ Loss (GASB 31) 22,436 0 0
Rounding (1) 0 0
ENDING FUND BALANCE $351,484 $338,871 $327,517
3/1/2023
51 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Sonoma Aqueduct Revenue Bonds 2015
Fund/Department No: 44305 33047700
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE $96,882 $102,582 $78,537

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 591 384 384 1,238 854 222.35% 44003 Other Interest Earnings 1 0 0 0 0 N/A
44050 Unrealized Gains and Losses (3,522) 0 0 0 0 N/A SUBTOTAL (2,929) 384 384 1,238 854 222.35%

MISCELLANEOUS REVENUES
46200 PY Revenue - Miscellaneous 0 0 0 0 0 N/A
SUBTOTAL 0 0 0 0 0 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 37,809 37,917 37,917 37,971 54 0.14% 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 37,809 37,917 37,917 37,971 54 0.14%
TOTAL REVENUES 34,880 38,301 38,301 39,209 908 2.37%

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 325 500 500 500 0 0.00%
SUBTOTAL 325 500 500 500 0 0.00%

OTHER CHARGES
53103 Interest on LT Debt 15,502 14,658 14,658 13,768 (890) (6.07%) 53104 Other Interest Expense (689) 0 0 0 0 N/A
53105 Costs of Issuance 0 0 0 0 0 N/A
SUBTOTAL 14,812 14,658 14,658 13,768 (890) (6.07%)

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 65,000 65,000 65,000 0 0.00% SUBTOTAL 0 65,000 65,000 65,000 0 0.00%
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 16,875 17,813 17,813 18,750 937 5.26% 59005 Admin Control Acct Clearing (16,875) (17,813) (17,813) (18,750) (937) 5.26% SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 15,137 80,158 80,158 79,268 (890) (1.11%) Adjustments to Reserves/Encumbrances:

Change in Principal due to Bond Reallocation 0 0 0
Change in Bond Premium due to Bond Realloc 0 0 0
Accrual of Principal Payment - Revenue Bonds (16,875) 17,813 (18,750) Principal Payment 0 0 0
Amortization of Bond Premium (689) 0 0
Unrealized Gain/ Loss (GASB 31) 3,522 0 0
Change in Reserved Fund Balance 0
Rounding (1) 0 0
ENDING FUND BALANCE $102,582 $78,537 $19,728
3/1/2023
52 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Common Facilities Revenue Bonds 2019
Fund/Department No: 44310 33047800
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEG. FUND BALANCE $102,593 $41,116 $708,986

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 1,199 480 480 18,860 18,380 3829.10% 44003 Other Interest Earnings 133 0 0 0 0 N/A
44050 Unrealized Gains and Losses (6,686) 0 0 0 0 N/A
SUBTOTAL (5,354) 480 480 18,860 18,380 3829.10%

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 674,569 676,780 676,780 676,992 213 0.03% 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A
SUBTOTAL 674,569 676,780 676,780 676,992 213 0.03%
TOTAL REVENUES 669,215 677,260 677,260 695,852 18,592 2.75%

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 2,675 3,000 3,000 3,000 0 0.00%
SUBTOTAL 2,675 3,000 3,000 3,000 0 0.00%

OTHER CHARGES
53103 Interest on LT Debt 307,780 293,933 293,933 279,355 (14,578) (4.96%) 53104 Other Interest Expense (54,724) 0 0 0 0 N/A
53105 Costs of Issuance 0 0 0 0 0 N/A
SUBTOTAL 253,056 293,933 293,933 279,355 (14,578) (4.96%)

OTHER FINANCING USES
57011 Transfers Out - within a Fund 150,000 0 0 0 0 N/A 57012 Transfers Out - btw Govtl Fund 0 0 0 0 0 N/A
SUBTOTAL 150,000 0 0 0 0 N/A
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 276,808 291,571 291,571 306,334 14,763 5.06% 59005 Admin Control Acct Clearing (276,808) (291,571) (291,571) (306,334) (14,763) 5.06% SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 405,731 296,933 296,933 282,355 (14,578) (4.91%) Adjustments to Reserves/Encumbrances:

Unrealized Gains and Losses 0 0 0
Proceeds Bond Issuance 0 0 0
Deposit to Cost of Issuance Fund 0 0 0
Restricted Cash w/Fiscal Agent 0 0 0
Principal Payment (276,808) (291,571) (306,334)
Revenue Bonds Pay-Change in Current Bal 0 0 0
Amortization of Bond Premium (54,724) 0 0
Change in Reserved Fund Balance 0 0 0
Post Audit Adjustments - Closing COI 0 0 0
Loss on Refunding of Debt 0 0 0
Unrealized Gain/ Loss (GASB 31) 6,686 0 0
Changed in Reserved Fund Balance (115) 579,115 0
Rounding 0 0 0
ENDING FUND BALANCE $41,116 $708,986 $816,149
3/1/2023
53 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Sonoma Aqueduct Revenue Bonds 2019
Fund/Department No: 44315 33047900
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE $291,998 $124,939 $272,227

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 1,893 480 480 7,463 6,983 1454.71% 44003 Other Interest Earnings 47 0 0 0 0 N/A
44050 Unrealized Gains and Losses (11,120) 0 0 0 0 N/A SUBTOTAL (9,180) 480 480 7,463 6,983 1454.71%

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 239,626 240,577 240,577 240,651 75 0.03% 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 239,626 240,577 240,577 240,651 75 0.03%
TOTAL REVENUES 230,446 241,057 241,057 248,114 7,057 2.93%

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 1,213 1,500 1,500 1,500 0 0.00%
SUBTOTAL 1,213 1,500 1,500 1,500 0 0.00%

OTHER CHARGES
53103 Interest on LT Debt 109,179 104,267 104,267 99,096 (5,171) (4.96%) 53104 Other Interest Expense (19,412) 0 0 0 0 N/A 53105 Costs of Issuance 0 0 0 0 0 N/A
SUBTOTAL 89,767 104,267 104,267 99,096 (5,171) (4.96%)

OTHER FINANCING USES
57011 Transfers Out - within a Fund 200,000 90,000 90,000 90,000 0 0.00% SUBTOTAL 200,000 90,000 90,000 90,000 0 0.00%
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 98,192 103,430 103,430 108,666 5,236 5.06% 59005 Admin Control Acct Clearing (98,192) (103,430) (103,430) (108,666) (5,236) 5.06% SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 290,980 195,767 195,767 190,596 (5,171) (2.64%) Adjustments to Reserves/Encumbrances:

Unrealized Gains and Losses 0 0 0
Proceeds Bond Issuance 0 0 0
Restricted Cash w/Fiscal Agent 0 0 0
Accrual of Principal Payment - Revenue Bon (98,192) (103,430) 0 Principal Payment 0 0 0
Deposit to Cost of Issuance Fund 0 0 0
Bond Premium - Issuance of Revenue Bonds 0 0 0
Amortization of Bond Premium (19,412) 0 0
Unrealized Gain/ Loss (GASB 31) 11,120 0 0
Change in Reserved Fund Balance (41) 205,429 0
Rounding (1) 0 0
ENDING FUND BALANCE $124,939 $272,227 $329,745
3/1/2023
54 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Storage Facilities Revenue Bonds 2022
Fund/Department No: 44325 33048100
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEG. FUND BALANCE $0 $947,409 $232,908

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 923 0 0 2,915 2,915 N/A 44003 Other Interest Earnings 0 0 0 0 0 N/A
44050 Unrealized Gains and Losses (34,664) 0 0 0 0 N/A SUBTOTAL (33,741) 0 0 2,915 2,915 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 0 385,782 77,457 355,015 277,558 358.34% 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 0 385,782 77,457 355,015 277,558 358.34%

SPECIAL ITEMS
48004 Residual Equity Transfers 433,013 0 0 0 0 N/A SUBTOTAL 433,013 0 0 0 0 N/A
TOTAL REVENUES 399,272 385,782 77,457 357,930 280,473 362.10%

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 0 560 500 560 60 12.00%
SUBTOTAL 0 560 500 560 60 12.00%

OTHER CHARGES
53103 Interest on LT Debt 4,809 129,724 29,724 119,587 89,863 302.33% 53104 Other Interest Expense 0 0 0 0 0 N/A
53105 Costs of Issuance 44,018 0 0 0 0 N/A
SUBTOTAL 48,827 129,724 29,724 119,587 89,863 302.33%

SPECIAL ITEMS
56030 Residual Equity Transfers 2,476,439 0 0 0 0 N/A SUBTOTAL 2,476,439 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 970,000 900,000 288,000 (612,000) (68.00%) 57012 Transfers Out - btw Govtl Fund 0 0 0 0 0 N/A SUBTOTAL 0 970,000 900,000 288,000 (612,000) (68.00%)
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 0 180,131 37,131 188,562 151,431 407.83% 59005 Admin Control Acct Clearing 0 (180,131) (37,131) (188,562) (151,431) 407.83% SUBTOTAL 0 0 0 0 0 N/A
TOTAL EXPENDITURES 2,525,265 1,100,284 930,224 408,147 (522,077) (56.12%) Adjustments to Reserves/Encumbrances:

CBAs - Included in Est. Current Yr Expenses 0 0 0
Gain on Refunding 44,214 0 0
Issuance of Revenue Bonds 2,693,401 0 0
Accrual of Principal Payment - Revenue Bond 0 0 (179,472) Unrealized Gain/ Loss (GASB 31) 34,664 0 0
Bond Premium 301,517 0 0
Post Audit Adjustment (394) 0 0
Rounding 0 0 0
ENDING FUND BALANCE $947,409 $232,908 $3,219
3/1/2023
55 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Common Facilities Revenue Bonds 2022
Fund/Department No: 44335 33048300
Actual Estimated Adopted Requested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 D ifference Change BEG. FUND BALANCE $0 $13,985,191 $9,348,820

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 5,684 0 0 210,969 210,969 N/A 44003 Other Interest Earnings 0 0 0 0 0 N/A
44050 Unreal
ized Gains and Losses (485,301) 0 0 0 0 N /A
SUBTOT
AL (479,617) 0 0 210,969 210,969 N/A
O

THER FINANCING SOURCES
47101 Transfers In - within a Fund 0 1,562,860 1,080,953 1,378,983 298,031 27.57% 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBT
OT
AL 0 1,562,860 1,080,953 1, 378,983 298,031 27.57%

SPECIAL ITEMS
48004 Residual Equity Transfers 676,343 0 0 0 0 N/A SUBTOT
AL 676,343 0 0 0 0 N/A
TOTA
L REVENUES 196,726 1,562,860 1,080, 953 1,589,952 509,000 47.09%

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 0 4,000 4,000 4,000 0 0.00%
SUBTOT
AL 0 4,000 4,000 4,000 0 0. 00%

OTHER CHARGES
53103 Interest on LT Debt 27,279 696,130 416,130 666,486 250,356 60.16% 53104 Other Interest Expense 0 0 0 0 0 N/A
53105 Cost
s of Issuance 249,690 0 0 0 0 N/A
SU
BTOT
AL 276,969 696,130 416,130 666,486 250, 356 60.16%

SPECIAL ITEMS
56030 Residual Equity Transfers 3,467,653 0 0 0 0 N/A SUBTOTAL 3,467,653 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 5,000,000 5,800,000 2,000,000 (3,800,000) (65.52%) 57012 Transfers Out - btw Govtl Fund 0 0 0 0 0 N/A SUBT
OT
AL 0 5,000,000 5,800,000 2, 000,000 (3,800,000) (65.52%) ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 0 519,829 519,829 528,630 8,801 1.69% 59005 Admin Control Acct Clearing 0 (519,829) ( 519,829) (528,630) (8,801) 1.69% SUBTOT
AL 0 0 0 0 0 N/A
TOTA
L EXPENDITURES 3,744,622 5,700,130 6,220, 130 2,670,486 (3,549,644) (57.07%) Adju
stments to Reserves/Encumbrances:

CBAs - Included in Est. Current Yr Expenses 0 0 0
Proceeds
Bond Issuance 15,539,615 0 0
Gain on Refunding 61,911 0 0
Principal Payment 0 (499,101) (528,630)
Bond Premium - Issuance of Revenue Bonds 1,445,451 0 0
Unreali
zed Gain/ Loss (GASB 31) 485,301 0 0
Post Audit Adjustment 808 0 0
Rounding 1 0 0
ENDING FUND BALANCE $13,985,191 $9,348,820 $7,739,656
3/1/2023
56 DRAFT
FY 2023-24 BUDGET

BEGINNING AND ENDING CASH SUMMARY
Section Title: Sonoma Aqueduct Revenue Bonds 2022
Fund/Department No: 44330 33048200
Actual Estimated Adopted Re quested Percent
Account Title 2021-2022 2022-2023 2022-2023 2023-24 Difference Change BEGINNING FUND BALANCE $0 ($1,287) $47,762

REVENUES

USE OF MONEY / PROPERTY
44002 Interest on Pooled Cash 587 0 0 1,576 1,576 N/A 44003 Other Interest Earnings 0 0 0 0 0 N/A
44050 Unrealized Gains and Losses 0 0 0 0 0 N/A SUBTOTAL 587 0 0 1,576 1,576 N/A

OTHER FINANCING SOURCES
47101 Transfers In - within a Fund 0 253,827 0 234,526 234,526 N/A 47102 Transfers In - btw Govtl Funds 0 0 0 0 0 N/A SUBTOTAL 0 253,8 27 0 234,526 234,526 N/A

SPECIAL ITEMS
48004 Residual Equity Transfers 397,245 0 0 0 0 N/A SUBTOTAL 397,245 0 0 0 0 N/A

TOTAL REV
ENUES 397,831 253,8 27 0 236,103 236,103 N/A

EXPENDITURES

SERVICES AND SUPPLIES
51242 Bank Charges 0 350 0 350 350 N/A
SUBTOTAL 0 350 0 350 350 N/ A

OTHER CHARGES
53103 Interest on LT Debt 2,614 73,000 0 65,778 65,778 N/A 53104 Other Interest Expense 0 0 0 0 0 N/A
53105 Costs of Issuance 23,926 0 0 0 0 N/A
SUBTOTAL 26,541 73,000 0 6 5,778 65,778 N/A

SPECIAL ITEMS
56030 Residual Equity Transfers 2,036,697 0 0 0 0 N/A SUBTOTAL 2,036,697 0 0 0 0 N/A

OTHER FINANCING USES
57011 Transfers Out - within a Fund 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A
ADMIN. CONTROL ACCOUNT
59004 Administrative Control Account 0 132,000 0 137,808 137,808 N/A 59005 Admin Control Acct Clearing 0 (132,000) 0 (137,808) (137,808) N/A SUBTOTAL 0 0 0 0 0 N/A

TOTAL EX
PENDITURES 2,063,238 73,350 0 6 6,128 66,128 N/A Adjustments to Reserves/Encumbrances:

CBAs - Included in Est. Current Yr Expenses 0 0 0
Gain
on Refunding 36,363 0 0
Issuance of Revenue Bonds 1,446,984 0 0
Accrual of Principal Payment - Revenue Bon 0 (131,428) 0 Prin
cipal Payment 0 0 (137,808)
Bond Premium - Issuance of Revenue Bond 181,185 0 0
Post A
udit Adjustment (413) 0 0
Roun
ding 0 0 0
ENDING FUND BALANCE ($1,287) $47,762 $79,929
3/1/2023
57 DRAFT
A. ANNUAL DEBT SERVICE REQUIREMENTS
Sonoma
Common O&M Water Storage Pipeline
Facilities Fund Conservation Facilities Facilities
2012 A Revenue Bond 44275 TBD TBD 44280 44285
PRINCIPAL 0 0 0
INTEREST 0 0 0
OTHER INTEREST - DEFERRED REFUNDING CHARGE 0 0 0
FISCAL AGENT FEES 0 0 0

DEBT ISSUANCE COSTS
Total Individual Bond Payments 0 0 0 0
Bond Reserve 0 0 0 0
Total Individual Bond Debt Service 0 0 0 0
2015A Revenue Bond 44295 44290 44305
PRINCIPAL 637,375 263,876 18,750
INTEREST 424,044 144,521 13,768
OTHER INTEREST - DEFERRED REFUNDING CHARGE 4,516 5,058 0 FISCAL AGENT FEES 2,500 1,500 500
Total Individual Bond Payments 1,068,435 414,955 33,018 Bond Reserve 160,265 62,243 4,953
Total Individual Bond Debt Service 1,228,700 477,198 37,971 2019A Revenue Bond 44310 44320 44315
PRINCIPAL 306,334 108,666
INTEREST 279,355 99,096
FISCAL AGENT FEES 3,000 1,500

DEBT ISSUANCE COSTS
Total Individual Bond Payments 588,689 0 209,262
Bond Reserve 88,303 0 31,389
Total Individual Bond Debt Service 676,992 0 240,651
2022A Revenue Bond 44335 44325 44330
PRINCIPAL 528,630 188,562 137,808
INTEREST 666,486 119,587 65,778
FISCAL AGENT FEES 4,000 560 350
DEBT ISSUANCE COSTS 0
Total Individual Bond Payments 1,199,116 308,709 203,936 Bond Reserve 179,867 46,306 30,590
Total Individual Bond Debt Service 1,378,983 355,015 234,526 SRF LOAN 44265
PRINCIPAL 886,878 N.A N.A
INTEREST 153,355 N.A N.A
Total Individual Loan Payments 1,040,233
Reserve Requirement 156,035
Total SRF Debt Service 1,196,268

SRF LOAN RESERVE
RESERVE N.A N.A
Total SRF Debt Service 1,196,268
TOTAL DEBT SERVICE $4,480,944 $0 $0 $832,214 $513,148
494,028
$3,986,916 $0 $0 $832,214 $513,148
REVENUE BOND / STATE LOAN CHARGES - WATER RATES AND ESTIMATED REVENUES FOR FY23-24 LESS REV. FROM N. MARIN REV. BOND CHARGES

REMAINING REVENUE REQUIREMENT
58 DRAFT
A. ANNUAL DEBT SERVICE REQUIREMENTS
Sonoma
Common O&M Water Storage Pipeline
Facilities Fund Conservation Facilities Facilities
REVENUE BOND / STATE LOAN CHARGES - WATER RATES AND ESTIMATED REVENUES FOR FY23-24 B. CALCULATIONS OF WATER RATES FOR FY23-24
Sonoma
Common O&M Water Storage Pipeline
Facilities Fund Conservation Facilities Facilities
Debt Service Debt Service Debt Service Revenue Bonds Revenue Bonds Charge Charge Charge Charge Charge
REVENUE REQUIREMENT $3,986,915.53 $0 $0 $832,214 $513,148 APPLICABLE BASE WATER DELIVERIES IN A.F. 28,557.77 41,799.9 41,799.9 28,557.77 3,383.1 CHARGES PER ACRE-FEET $139.61 $0.00 $0.00 $29.14 $151.68 C. CALCULATIONS OF NORTH MARIN REVENUE BONDS CHARGE
$1,943,039
240,730
5,303

45.39 1,860,913
253,298
5,303

47.76 Remaining Facilities: SRF Loan, 2015A Revenue Bond Refunding, 2022 Revenue Bond Refunding Additional Facilities: 2015A Revenue Bond New Money, 2022 Revenue Bond New Money Excluded: 2019A Revenue Bond - NMWD Paid Cash
Principal Interest
Reserve
Requirement
Fiscal Agent Fee
+ Other Charges Total
SRF LOAN 886,878 153,355 156, 035 1,19 6,268 2015A Revenue Bond 637,375 424,044 160, 265 7,01 6 1,22 8,700 2015A Revenue Bond New Money 439,277 322,539 115,028 5,036 881,880 2015A Revenue Bond Refunding 198,098 101,505 45,237 1,980 346,821 2019A Revenue Bond 306,334 279,355 88,3 03 3,00 0 676, 992 2022A Revenue Bond 528,630 666,486 179, 867 4,00 0 1,37 8,983 2022A Revenue Bond New Money 294,000 554,493 127,700 2,840 979,033 2022A Revenue Bond Refunding 234,630 111,992 52,167 1,160 399,950 N. MARIN'S SHARE (REV. REQMT. FOR COMMON FAC. DEBT SERVICE X (11.2/90.4)) ESTIMATED WATER DELIVERIES TO NORTH MARIN (IN A.F.)

NORTH MARIN REVENUE BONDS CHARGE
REVENUE REQUIREMENT FOR COMMON FACILITIES DEBT SERVICE (Remaining Facilities per RA 4.3a2 ) FY23/24
REVENUE REQUIREMENT FOR COMMON FACILITIES DEBT SERVICE (Additional Facilities per RA 4.3b9 ) N. MARIN'S SHARE (REV. REQMT. FOR COMMON FAC. DEBT SERVICE X (19.9/146.2)) ESTIMATED WATER DELIVERIES TO NORTH MARIN (IN A.F.)

NORTH MARIN REVENUE BONDS CHARGE
59 DRAFT
Fund Index OT Out (57012) To OT In (47102) Fund Bal. (Stmt.) Fund Bal. (Cash) Diff.

Santa Rosa Aq. Capital Fund 44230 0 298,319 8,991,672 8,991,671 (0) Petaluma Aq. Capital Fund 44235 0 0 3,482,877 3,482,877 0 Sonoma Aq. Capital Fund 44240 0 282,572 253,125 253,125 0 Sonoma Rev Bond 2012 Fund 44285 0 Sonoma AQ 0 179 179 0 Sonoma Rev Bond 2015 Fund 44305 65,000 Sonoma AQ 37,971 19,728 19,728 0 Sonoma Rev Bond 2019 Fund 44315 90,000 Sonoma AQ 240,651 329,745 329,745 0 Sonoma Rev Bond 2022 Fund 44330 0 Sonoma AQ 234,526 79,929 79,929 0 Storage Rev Bond 2012 Fund 44280 0 Storage Facilities 0 142 142 0 Storage Rev Bond 2015 Fund 44290 117,000 Storage Facilities 477,198 702 702 (0) Storage Rev Bond 2022 Fund 44325 288,000 Storage Facilities 355,015 3,219 3,219 0 Common Rev Bond 2012 Fund 44275 0 Common Facilities 0 293 293 0 Common Rev Bond 2015 Fund 44295 180,000 Common Facilities 1,228,700 327,517 327,517 0 Common Rev Bond 2019 Fund 44310 0 Common Facilities 676,992 816,149 816,149 0 Common Rev Bond 2022 Fund 44335 2,000,000 Common Facilities 1,378,983 7,739,656 7,739,656 0 State Loan Debt Service 44265 120,000 Common Facilities 1,196,268 730,551 730,551 0 State Loan Reserve 44270 0 0 (0) (0) 0
Capital Lease Financing 0 0 0 0 0
Agency Fund (Discretionary) 44205 0 Common Facilities 0 9,675,550 9,675,550 0 Agency Fund (Charges) 44205 10,019,899 0
Pipeline Facilities 44255 0 0 0 0
Storage Facilities 44250 405,000 (24,271) (24,271) 0
Common Facilities 44260 2,300,000 546,468 546,467 (0)
North Marin 44300 0 0 28,884 28,884 0
Water Management Planning 44210 0 165,252 165,252 (0)
Watershed Planning/Restoration 44215 1,504,670 104,283 104,283 0 Recycled Water & Local Supply 44220 0 224,872 224,872 0 Water Conservation 44225 2,263,032 12,737 12,737 0
Total 12,879,899 12,879,899 33,509,258 33,509,257 (1)
Common Facilities OT - in 47101 From
Water Transmission (discretionary) -
Water Transmission (Charges) -
North Marin - O&M Rate Computation
2012 Bond Fund - Revenue Requirement - Transfers Out:
2015 Bond Fund 180,000 10,019,899
2019 Bond Fund -
2022 Bond Fund 2,000,000
State Loan Debt Service 120,000
2,300,000
Agency Fund (Charges) OT - Out To:

AQ Capital Funds Summary
Santa Rosa Aq. Capital Fund 298,319
Petaluma Aq. Capital Fund 0 AQ Capital Funds 425,892
Sonoma Aq. Capital Fund 127,572 Debt Service Funds 5,826,306 425,892 WT Subfunds 3,767,702
Debt Service Funds 10,019,899
Sonoma Rev Bond 2012 Fund 0
Sonoma Rev Bond 2015 Fund 37,971 Capital Funds and North Marin 0 Sonoma Rev Bond 2019 Fund 240,651
Sonoma Rev Bond 2022 Fund 234,526
Storage Rev Bond 2012 Fund 0 Total 10,019,899
Storage Rev Bond 2015 Fund 477,198
Storage Rev Bond 2022 Fund 355,015
Common Rev Bond 2012 Fund 0
Common Rev Bond 2015 Fund 1,228,700
Common Rev Bond 2019 Fund 676,992
Common Rev Bond 2022 Fund 1,378,983
State Loan Debt Service 1,196,268
State Loan Reserve 0
Capital Lease Financing 0
5,826,306
Capital Funds and North Marin
Pipeline Facilities 0
Storage Facilities 0
Common Facilities 0
North Marin 0
0 WT Subfunds
Water Management Planning 0
Watershed Planning/Restoration 1,504,670
Recycled Water & Local Supply 0
Water Conservation 2,263,032
3,767,702
Total 10,019,899
Agency Fund (Charges) OT - Out To:

FY 2023-24 BUDGET
Water Transmission System - Fund Balances and Operating Transfers 3/1/2023
60 DRAFT

← All documents from this meeting