HomeMy WebLinkAboutItem 6b. 2025-26 Whale Rock Reservoir Budget
Whale Rock Commission Report
Whale Rock Commission Meeting – May 8, 2025
Agenda Item 7 – 2025-26 Whale Rock Reservoir Budget
FROM: Aaron Floyd, Utilities Director
PREPARED BY: Mychal Boerman, Utilities Deputy Director - Water
SUBJECT: 2025-26 W hale Rock Reservoir Budget
RECOMMENDATION
Adopt the 2025-26 Whale Rock Reservoir Budget.
DISCUSSION
Summary
Pursuant to the Supplemental Agreement for the Construction and Operation of the
Whale Rock Project, San Luis Obispo County (February 1961), the Whale Rock
Commission has the powers and duties to consider and approve the annual budget
(Attachment E - Section C3). In alignment with this agreement, staff have developed
a proposed budget and proposed member agency contributions that considers
Operating, Salaries and Benefits, Capital, and Electrical Pumping expenditures.
These member agency contributions are summarized in the tables below.
Table 1 – 2025-26 Agency Contributions
City of San Luis
Obispo (55.05%)
Cal Poly State
University
(33.71%)
California Men’s
Colony (11.24%)
Total
Contribution
$1,626,461 $995,967 $332,088
O&M Allocation1 $770,597 $471,877 $157,339
CIP Contribution $93,507 $57,259 $19,092
CIP Reserve
Contribution
$762,357 $466,831 $155,657
Table 2 – 2025-26 Forecasted Pumping Charges
City of San
Luis Obispo
(1,100 AF)
Cal Poly State
University
(1,100 AF)
California Men’s
Colony
(300 AF)
Dairy
Creek
(50 AF)
Forecasted
Pumping
Charges
$306,306 $306,306 $83,538 $13,923
1 O&M Allocation does not include electricity costs associated with pump station operation. Participants
should budget for the total of “Total Contribution” (Table 1) plus “Forecasted Pumping Charges” (Table 2).
Page 119 of 141
The next sections describe the detailed budgets from which the recommendations
above are derived. Additional sections on recommending capital reserve
contributions are also included.
Detailed Budgets
Table 3 contains budget totals organized by cost categories and subcategories.
Table 3 – Detailed
Budgets
2024-25
Adopted
Budget
2025-26
Proposed
Budget
2026-27
Forecasted
Budget
Capital Asset
Expenses
$2,451,801 $1,554,704 $2,394,845
Capital Expenses $1,236,506 $169,859 $1,010,000
Legacy Projects $1,720,295
Transfers to/from Capital
Reserves
$(505,000) $1,384,845 $1,384,845
Salaries and Benefits $706,958 $795,293 $768,900
Salaries $504,086 $554,675 $514,770
Benefits $202,873 $240,618 $254,130
Operating Budget $1,370,294 $1,321,593 $1,324,290
Office Expenses $2,000 $8,466 $8,466
Operating Materials &
Supplies
$93,100 $93,050 $93,250
Services and Supplies $194,980 167,828 $182,853
Travel, Meeting, and Dues $9,350 $8,200 $8,200
Utilities – Electrical
Pumping
$760,225 $710,073 $687,100
Utilities – Other $28,036 $32,400 $33,000
General Government $282,603 $301,576 $311,421
Revenues $2,808,758 $3,671,589 $4,488,036
Charges for Services $2,070,252 $1,399,812 $1,399,091
Charges for Electricity $760,255 $710,073 $687,100
Charges for Contribution
to Capital Reserves
$0 $1,554,704 $2,394,845
Other Revenue $7,000 $7,000 $7,000
Net Revenue (Revenue
minus Expenditures)1
$1,720,295 $0 $0
Ending Year Balance 2024-25 2025-26 2026-27
Capital Reserve
Balance
$2,017,683 $3,402,528 $4,787,373
Unreserved Fund
Balance
$1,280,168 $1,280,168 $1,280,168
Tables including descriptions of the subcategories, more granular budget data, and
detailed capital projects forecasts are included as attachments A, B, and C. A copy
of the Whale Rock Fund Analysis is included as attachment D.
Page 120 of 141
Capital Reserve Balances and Recommendations
Capital reserve balance and staff recommendations for capital reserves in 2025-26
are outlined in Table 4. These recommendations will be reviewed annually to ensure
that reserve balances are sufficient to cover capital needs and to try to reduce the
frequency of large year-to-year variations in capital costs. Staff are recommending
increasing capital reserve contributions over the next two fiscal years in anticipation
of 200549-Whale Rock Pump Station Electrical Repairs (A and B), which is scheduled
for construction in 2027-28. Staff anticipate recommending a $4,000,000 utilization
of capital reserves across all partner agencies for 200549-Whale Rock Pump Station
Electrical Repairs (A and B) in 2027-28.
Table 4 – Capital
Reserves and
Recommendations
City of San Luis
Obispo (55.05%)
Cal Poly State
University
(33.71%)
California Men’s
Colony (11.24%)
2024-25 Capital
Reserve Balance
$1,189,754 $585,005 $242,922
2025-26 Capital
Reserve
Contributions
$762,357 $466,831 $155,657
2025-26 Capital
Reserve Balance
$1,952,112 $1,051,837 $398,579
This would result in the net capital contributions for 2025-26 outlined in Table 5.
Table 5 – Net
Capital
Contributions
City of San Luis
Obispo (55.05%)
Cal Poly State
University
(33.71%)
California Men’s
Colony (11.24%)
2025-26 Net
Capital
Contributions
$855,865 $524,091 $174,749
Staff will evaluate capital reserve levels and contributions on an annual basis to
reassess for sufficiency. Staff will continue to research best practices relative to
capital reserve levels and will present finding to the Whale Rock Commission a t a
future meeting.
Agency Contributions
The Whale Rock Commission members’ contributions are summarized in Table 1 and
Table 2. The largest expenditure increases, relative to the previous year, are primarily
related to increased contributions to capital reserves for 200549-Whale Rock Pump
Station Electrical Repairs (A and B).
A year-over-year summary of Whale Rock Commission members’ contributions are
included in Table 6.
Page 121 of 141
Table 6 – Year-Over- Year
Agency Contributions
2023-24
Actual
Contributions
2024-25
Adopted
Budget
2025-26
Proposed
Budget
City of San Luis Obispo
(55.05%)
$1,202,058 $1,476,364 $1,932,767
O&M Allocation $684,116 $721,170 $770,597
CIP Contribution $339,862 $402,694 $855,865
Pumping Charges $178,080 $352,500 $306,306
Cal Poly State University
(33.71%)
$952,015 $970,201 $1,302,273
O&M Allocation $418,920 $441,610 $471,877
CIP Contribution $284,695 $246,591 $524,091
Pumping Charges $248,400 $282,000 $306,306
California Men’s Colony
(11.24%)
$317,994 $355,193 $415,626
O&M Allocation $139,681 $147,247 $157,339
CIP Contribution $69,393 $82,221 $174,749
Pumping Charges $108,920 $125,725 $83,538
Total Member Contributions $2,472,067 $2,801,758 $3,650,666
ENVIRONMENTAL REVIEW
The California Environmental Quality Act does not apply to the recommended action,
because the action does not constitute a “Project” under CEQA Guidelines Sec.
15278.
ALTERNATIVES
The Whale Rock Commission members may elect not to approve the budget as
proposed or may elect to modify elements of the proposed budget. This
alternative is not recommended as the proposed budget allocates funding for staffing,
electrical costs, Capital Improvement Projects, and costs for other essential functions
related to the safety of Whale Rock Reservoir and delivery of raw water from the
reservoir for basic health and safety needs.
ATTACHMENT
A – Descriptions of Account Subcategories
B – Detailed Budgets (Account Level Detail)
C – Capital Project Forecast
D – Whale Rock Fund Analysis
E – Supplemental Agreement for the Construction and Operation of the Whale
Rock Project, San Luis Obispo County (February 1961)
Page 122 of 141
Item 7 - Attachment A
Subcategory Descriptions
Capital Expenses This subcategory describes project budgets proposed to be
allocated in the corresponding fiscal year.
Legacy Projects This subcategory describes project budgets that were approved in a
prior fiscal year but are still allocated for the current fiscal year.
Expenses for capital projects may be incurred in multiple fiscal years
due to the timing of the project.
Capital Reserves This subcategory describes agency contributions to a reserve
account for future capital projects. These funds are reserved and
can only be utilized as authorized by member agencies.
Salaries This subcategory describes all direct payment for salaries related to
operating the Whale Rock Reservoir. This includes regular salaries,
standby, and call back.
Benefits This subcategory describes all benefits for staff related to operating
the Whale Rock Reservoir. This includes retirement contributions,
CalPERS, and insurance.
Office Expenses This subcategory describes expenses such as paper, toner, binders,
and other miscellaneous office supplies.
Operating Materials and
Supplies
This subcategory describes all materials related to operating the
Whale Rock Reservoir. Some of the specific items covered by this
cost category include valves, pump repair materials, water meters,
fencing materials, etc.
Services and Supplies This subcategory describes expenses such as annual dam
inspections through the California Department of Water Resources,
minor pump and motor rebuilds, and other contract services.
Travel, Meeting, and Supplies This subcategory describes expenses related to education and
training such as AWWA conferences and other pertinent educations
opportunities.
Utilities – Electrical Pumping This subcategory describes the expenses related to pumping water
from the Whale Rock Reservoir to the Whale Rock Commission
members. While staff provided forecasted budget for this expense,
pumping charges are not collected through agency contributions,
and are billed separately based on proportional share of water
delivered.
Utilities – Other This subcategory describes utility expenses not related to pumping
water. This includes utilities like communications, garbage, and
facility and office electricity.
General Government This subcategory describes expenses related to internal support
services provided by the City, including the Finance, Human
Resources, and City Clerk’s Office Departments.
Charges for Services This subcategory includes all Whale Rock Commission Member
contributions, and any revenues related the fishing program.
Other General Government
Revenue
This subcategory describes all other revenue. It includes any sort of
interest on investments, rental revenues, etc.
Page 123 of 141
Page 124 of 141
Attachment B - Detailed Budgets (Account Level Details)
2025-26 Budget Data by Account Fiscal Year
Concat Account 2025 Budgeted 2026 Proposed 2027 Forecasted
31022-Whale Rock CIP Reserve Contribution - City (1,189,754.81)$ (762,357.17)$ (762,357.17)$
31023-Whale Rock CIP Reserve Contribution - Cal Poly (585,005.62)$ (466,831.25)$ (466,831.25)$
31024-Whale Rock CIP Reserve Contribution - CA Men's Colony (242,922.07)$ (155,656.58)$ (155,656.58)$
44101-Interest on Investment 1,000.00$ 1,000.00$ 1,000.00$
44310-Miscellaneous Revenue 6,000.00$ 6,000.00$ 6,000.00$
46706-Whale Rock Operating Charges 1,310,027.24$ 1,399,812.31$ 1,399,090.69$
46707-Whale Rock CIP Contributions 731,505.82$ 1,554,704.00$ 2,394,845.00$
46711-Water Distribution (Pumping) Charges 760,225.00$ 710,073.00$ 687,100.05$
51001-Salaries - Regular (461,660.77)$ (471,415.14)$ (474,159.10)$
51003-Salaries - Contract (10,179.78)$ -$ -$
51004-Salaries - Temporary -$ -$ -$
51010-Overtime (4,000.00)$ (3,000.00)$ (3,000.00)$
51017-Standby (22,245.00)$ (22,245.00)$ (22,245.00)$
51018-Call Back (6,000.00)$ (4,000.00)$ (4,000.00)$
52001-Retirement Contributions (40,810.22)$ (38,552.56)$ (38,775.36)$
52002-Retirement PARS - 401 (218.20)$ (222.38)$ (222.38)$
52003-PERS Unfunded Liability (117,571.53)$ (131,432.05)$ (142,168.73)$
53001-Employee Group Insurance (57,428.40)$ (57,449.40)$ (59,792.40)$
53002-Retiree Healthcare (7,528.74)$ (6,180.44)$ (6,350.50)$
55001-Medicare (6,639.43)$ (6,780.71)$ (6,820.49)$
56003-Contingency Expense (54,014.63)$ (11,366.20)$
61005-Data Processing Services (6,400.00)$ -$ -$
61007-Legal Services (20,000.00)$ (20,000.00)$ (20,000.00)$
61011-Maintenance (19,400.00)$ (16,200.00)$ (16,200.00)$
61013-Other Contract Services (140,130.91)$ (118,650.00)$ (134,000.00)$
61027-Control Systems (10,830.00)$ (12,978.00)$ (12,653.00)$
61503-Electric Service (773,161.00)$ (723,373.00)$ (700,400.05)$
61505-Communication Service (12,100.00)$ (15,500.00)$ (16,100.00)$
61506-Solid Waste Service (3,000.00)$ (3,600.00)$ (3,600.00)$
62002-Office Supplies (1,500.00)$ (1,500.00)$ (1,500.00)$
62007-Employee Recognition (500.00)$ (500.00)$ (500.00)$
62009-Software Licensing and Maint Agreements (6,466.00)$ (6,466.00)$
62501-Chemicals (500.00)$ (700.00)$ (700.00)$
62502-Construction Materials and Supplies (5,906.50)$ (5,900.00)$ (6,000.00)$
62503-Equipment Maintenance Supplies (5,000.00)$ (5,500.00)$ (5,500.00)$
62505-Machinery and Equipment (60,000.00)$ (60,000.00)$ (60,000.00)$
62506-Safety Materials and Supplies (2,150.00)$ (2,150.00)$ (2,150.00)$
62509-Misc Materials and Supplies (19,650.00)$ (18,800.00)$ (18,900.00)$
63001-Membership and Certifications (950.00)$ (600.00)$ (600.00)$
63002-Education and Training (6,900.00)$ (6,100.00)$ (6,100.00)$
63003-Trips and Meetings (1,500.00)$ (1,500.00)$ (1,500.00)$
71006-Project Expenditures (1,236,505.82)$ (169,859.00)$ (1,010,000.00)$
71999-Legacy Project Expenses (1,720,295.55)$
75002-Reimbursement Transfers Out (282,603.16)$ (301,576.00)$ (311,421.53)$
Grand Total (4,272,189.46)$ -$ -$
Page 125 of 141
Page 126 of 141
2025-26 Capital Projects Forecast Fiscal Year
Item Description Notes 2025 Budgeted 2026 Proposed 2027 Forecasted 2028 Forecasted 2029 Forecasted 2030 Forecasted 2031 Forecasted 2032 Forecasted 2033 Forecasted 2034 Forecasted 2035 Forecasted
1000074-IT Replacements - Annual Asset Maintenance Account 1000074-02-Asset Management (Cityworks - Utilities Integration) 5,980.00$
1000074-IT Replacements - Annual Asset Maintenance Account 1000074-12-Firewall Replacement 841.82$
1000074-IT Replacements - Annual Asset Maintenance Account 1000074-15-Network Security Upgrade 421.00$
1000074-IT Replacements - Annual Asset Maintenance Account 1000074-25-Radios, Mobiles and stations not replaced - EF & PW Only 10,000.00$
1000074-IT Replacements - Annual Asset Maintenance Account 1000074-27-Uninterruptible Power Supplies (UPS’s Servers and Storage) 1,962.00$
1000074-IT Replacements - Annual Asset Maintenance Account 1000074-29-Virtual Private Network Replace 2,341.00$
1000074-IT Replacements - Annual Asset Maintenance Account 1000074-30-VMware Infrastructure Upgrade -$
1000074-IT Replacements - Annual Asset Maintenance Account 1000074-31-VoIP Telephone System -$
1000521-Fleet Replacement: Utilities 1000521-40-Whale Rock Sevice Truck (1637) 100,000.00$
1000521-Fleet Replacement: Utilities 2000521-03.01 - Whale Rock 1/2 Ton Truck (1630) 82,500.00$
1000521-Fleet Replacement: Utilities 2000521-34-Fleet Services Vehicle Lift (1000181) -$ -$ -$ -$
1000521-Fleet Replacement: Utilities 2000521-35-Fleet - F150 4x4 Pick-up -$ -$ -$ -$
1000521-Fleet Replacement: Utilities 2000521-36-Fleet - 4x4 3/4 Ton Truck w/Utility Box & Crane -$ -$ -$ -$
1000521-Fleet Replacement: Utilities 2000521-37-Fleet - 4x4 SUV - Jeep (1738) -$ -$ -$ -$ 76,000.00$
1000521-Fleet Replacement: Utilities 2000521-38-Fleet - Boston Whaler -$ -$ -$ -$ 40,000.00$
1000521-Fleet Replacement: Utilities 2000521-39-Boat Trailer -$ -$ -$ -$ 10,000.00$
1000521-Fleet Replacement: Utilities 2000521-40-Fleet Services Vehicle Lift -$ -$ -$ -$
1000521-Fleet Replacement: Utilities 2000521-40-Whale Rock Portable Generator (1302) 200,000.00$
1000521-Fleet Replacement: Utilities 2000521-40-Whale Rock UTV w/ Dump Bed (1509) 30,000.00$
2000075-Major Facilities Maintenance [1000075]Carryover: 09.01-Corp Yard Fuel Island Siding / Recoating of Fuel Island and Dispensers 15,997.31$
2000176-Whale Rock Intake Valve Replacement [1000176]Carryover: 00-BASE 200,000.00$
2000181-Fleet Services Vehicle Lift [1000181]Carryover: 02-Whale Rock Fund Vehicle Lift -$
2000521-Fleet Replacement: Utilities [1000521]Carryover: 03.02-Whale Rock Utility Tractor 75,000.00$
2000521-Fleet Replacement: Utilities [1000521]Carryover: 03.03-Whale Rock Trailer 6,346.00$
2000521-Fleet Replacement: Utilities [1000521]Carryover: 03.04-Whale Rock Dump Trailer 8,438.75$
2000602-Utilities IT Replacements [1000074]1000074-02-Asset Management (Cityworks - Utilities Integration) -$ -$ -$
2000602-Utilities IT Replacements [1000074]1000074-12-Firewall Replacement -$ -$ -$ 975.90$ 1,131.34$
2000602-Utilities IT Replacements [1000074]1000074-15-Network Security Upgrade -$ -$ 460.04$ 502.70$ 549.31$
2000602-Utilities IT Replacements [1000074]1000074-25-Radios, Mobiles and stations not replaced - EF & PW Only -$ -$ -$ 12,298.74$
2000602-Utilities IT Replacements [1000074]1000074-27-Uninterruptible Power Supplies (UPS’s Servers and Storage) -$ -$ 2,143.93$ 2,342.73$ 2,559.96$
2000602-Utilities IT Replacements [1000074]1000074-29-Virtual Private Network Replace -$ -$ -$ 2,713.86$ 3,146.11$
2000602-Utilities IT Replacements [1000074]1000074-30-VMware Infrastructure Upgrade 8,301.00$ -$ -$ 9,070.73$ 9,911.83$ 10,830.92$
2000602-Utilities IT Replacements [1000074]1000074-31-VoIP Telephone System 1,558.00$ -$ -$ 2,032.84$
2000602-Utilities IT Replacements [1000074]1000074-Network Switching Infrastructure Equipment 724.55$ 839.95$
2000602-Utilities IT Replacements [1000074]1000074-Wireless System Citywide 1,299.55$ 1,506.53$
2000602-Utilities IT Replacements [1000074]Carryover: 01.03-Asset Management Cityworks Integration (Whale Rock Fund) 630.00$
2000603-Enterprise IT Replacements [1000074]Carryover: 09-Wireless System Citywide -$
2000604-Network IT Replacements [1000074]Carryover: 04.03-Network Switching Infratstructure Equipment (Whale Rock Fund Contributions) 625.00$
2001009-Whale Rock Major Maintenance [91335]02-Reservoir Fencing 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$ 20,000.00$
2001009-Whale Rock Major Maintenance [91335]03-Advanced Instrumentation and Safety Monitoring of Critical Infrastructure 250,000.00$ -$ -$ -$
2001009-Whale Rock Major Maintenance [91335]05-Evaporation/Weather Stations -$ -$ -$ -$
2001009-Whale Rock Major Maintenance [91335]07-Valve Replacement -$ -$ -$ 200,000.00$
2001009-Whale Rock Major Maintenance [91335]08-Roadway Pavement 520,000.00$
2001009-Whale Rock Major Maintenance [91335]08-Roadway Pavement (adjusted based on NE and MB feedback) (105,040.00)$
2001009-Whale Rock Major Maintenance [91335]Carryover: 00-BASE 184,030.40$
2001009-Whale Rock Major Maintenance [91335]Carryover: 01-Spillway Drain Repairs 263,929.90$
2001009-Whale Rock Major Maintenance [91335]Carryover: 02-Reservoir Fencing 20,000.00$
2001009-Whale Rock Major Maintenance [91335]Carryover: 04-Stilling Basin 216,332.47$
2001009-Whale Rock Major Maintenance [91335]Carryover: 06-Whale Rock Reroof of Shop and Residence 7,333.92$
2001009-Whale Rock Major Maintenance [91335]Carryover: 07-Inventory for Emergency Pipeline Repairs 2,593.50$
2001009-Whale Rock Major Maintenance [91335]Carryover: 08-Roadway Pavement 120,000.00$
2001009-Whale Rock Major Maintenance [91335]Shop Pavement Replacement 50,000.00$
2001009-Whale Rock Major Maintenance [91335]Stilling Basin 20,000.00$
2001009-Whale Rock Major Maintenance [91335]Water Dam Spillway Wall Concrete Profiling -$
2001017-Whale Rock Pipe Assessment and Repairs [91617]Carryover: 00-BASE 528,497.26$
2001017-Whale Rock Pipe Assessment and Repairs [91617]Carryover: 01-2001017-01 - Pipeline Replacement Alternatives Study 51,000.00$
2001019-Whale Rock Auto Control Valves [91718]Carryover: 00-BASE 19,541.04$
200549-Whale Rock Pump Station Electrical Repairs (A and B) [1000549]1000549-01-Whale Rock Pump Station Rehab (A and B) 500,000.00$ -$ 7,000,000.00$
200xxx-Emergency pipeline repair 00-BASE (moved from operating to CIP 2024-25) 30,000.00$ 30,000.00$ 30,000.00$ 30,000.00$ 30,000.00$ 30,000.00$ 30,000.00$ 30,000.00$
91617-Whale Rock Transmission Pipeline 91617-01-Pipeline Creek Crossings - point repairs 30,000.00$
91617-Whale Rock Transmission Pipeline 91617-01-Transmission Pipeline Repairs CM -$ -$ 60,000.00$ -$
91617-Whale Rock Transmission Pipeline 91617-01-Transmission Pipeline Repairs Design -$ 60,000.00$ -$ -$
91617-Whale Rock Transmission Pipeline 91617-01-Transmission Pipeline Repairs Inspection -$ -$ -$ 550,000.00$
91617-Whale Rock Transmission Pipeline 91617-01-Transmission Pipeline Repairs Repair -$ -$ 900,000.00$ -$
91617-Whale Rock Transmission Pipeline 91617-01-Transmission Pipeline Replacement 1,800,000.00$ 1,800,000.00$ 1,800,000.00$
xxxxxxx-Placeholder project (blank) -$ -$ -$ -$ 100,000.00$ 100,000.00$ 100,000.00$
Page 127 of 141
Page 128 of 141
Net Revenue
Account Category 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29 2029-30 2030-31 2031-32 2032-33
Capital Asset Expense($84,591)($168,494)($76,025)($176,959)($577,105)($2,956,801)($169,859)($1,010,000)($7,833,904)($259,795)($2,036,190)($1,952,845)($1,948,211)($121,50
Capital Reserves ($2,017,683)($1,384,845)($1,384,845)$4,000,000 ($345,000)($345,000)($345,000)($345,000)($345,00
General Government($160,203)($183,978)($186,211)($190,488)($274,372)($282,603)($301,576)($311,422)($320,764)($330,387)($340,299)($350,508)($361,023)($371,85
Operations($337,039)($414,989)($309,075)($568,828)($1,094,505)($1,089,578)($1,020,017)($1,012,869)($898,246)($958,078)($977,214)($1,041,903)($1,063,479)($1,133,44
Revenue$1,868,814 $2,161,494 $2,394,658 $2,376,183 $3,046,366 $2,808,758 $3,671,589 $4,488,036 $5,851,642 $2,715,308 $4,544,769 $4,561,062 $4,614,001 $2,894,3
Salaries and Benefits($550,117)($545,122)($695,766)($664,555)($677,123)($734,282)($795,292)($768,900)($798,728)($822,048)($846,067)($870,806)($896,288)($922,53
Total $736,864 $848,912 $1,127,581 $775,353 $423,261 ($4,272,189)$0 $0 $0 ($0)($0)($0)($0)
Unreserved Fund Balance
$0M $5M
2019-20
2020-21
2021-22
2022-23
2023-24
2024-25
2025-26
2026-27
2027-28
2028-29
2029-30
2030-31
2031-32
2032-33
2033-34
2034-35
$2.4M
$3.2M
$4.4M
$5.1M
$5.6M
$1.3M
$1.3M
$1.3M
$1.3M
$1.3M
$1.3M
$1.3M
$1.3M
$1.3M
$1.3M
$1.3M
Whale Rock Fund Financial Position
Days of Cash on Hand
0K 1K 2K
2019-20
2020-21
2021-22
2022-23
2023-24
2024-25
2025-26
2026-27
2027-28
2028-29
2029-30
2030-31
2031-32
2032-33
2033-34
2034-35
976
1,226
1,581
1,518
1,144
256
257
262
275
262
256
244
238
227
222
211
Capital Reserve Contributions by Agency Member
($4M)
($3M)
($2M)
($1M)
$0M
$1M
$2M
2024-25 2025-26 2026-27 2027-28 2028-29 2029-30 2030-31 2031-32 2032-33 2033-34 2034-35
$2,017,683
$1,384,845
($4,000,000)
$345,000 $345,000 $345,000 $345,000
31022-Whale Rock CIP Reserve Contri…31023-Whale Rock CIP Res…31024-Whale Rock CI…
2025-26 Ending CIP Reserves
Balance - City of San Luis Obispo
$1,952,112
2025-26 Ending CIP Reserves
Balance - Cal Poly
$1,051,837
2025-26 Ending CIP Reserves
Balance - California Men's Colony
$398,579
CIP Reserve
Balance
Forecasted CIP
Contributions
Forecasted OpEx
Contributions
Forecasted
Pumping Charges
Page 129 of 141
Concat Account 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29 2029-30 2030-31 203
44002-Rental Fees $5,049 $1,122
44101-Interest on Investment $71,545 $818 $39,588 $78,159 $183,176 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
44107-Investment FMV Adjustment ($146,953)($17,408)$84,677
44201-Other Rent & Leasse Revenue $4,862 $3,366 $4,488 $5,895
44305-Damage to City Property $7,613
44310-Miscellaneous Revenue $743 $743 $1,091 $743 $742 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
45307-Federal Stimulus Grant $260
46703-Utilities Base Charges ($3,034)
46706-Whale Rock Operating Charges $979,351 $1,015,607 $949,126 $1,126,924 $1,242,781 $1,310,027 $1,399,812 $1,399,091 $1,427,435 $1,491,043 $1,513,487 $1,580,970 $1
46707-Whale Rock CIP Contributions $576,621 $887,938 $1,401,424 $810,312 $693,550 $731,506 $1,554,704 $2,394,845 $3,833,904 $604,795 $2,381,190 $2,297,845 $2
46710-Fishing Program Revenues $2,095 $2,871 $1,933 $970 $1,471Total$1,868,814 $2,161,494 $2,394,658 $2,376,183 $3,046,366 $2,808,758 $3,671,589 $4,488,036 $5,851,642 $2,715,308 $4,544,769 $4,561,062 $4,
Account Category
All
Whale Rock Fund Revenue Details
Account Subcategory
All
Concat Account
All
Item Description
All
Assigned Member Agency
All
Revenue Actuals & Forecast
$0M
$2M
$4M
$6M
2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29 2029-30 2030-31 2031-32 2032-33 2033-34 2034-35
$1.87M $2.16M $2.39M $2.38M
$3.05M $2.81M
$3.67M
$4.49M
$5.85M
$2.72M
$4.54M $4.56M $4.61M
$2.89M $2.96M $3.09M
Actual Budgeted Forecasted
Page 130 of 141
Concat Account 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29 2029-30
31022-Whale Rock CIP Reserve Contribution - City $1,189,755 $762,357 $762,357 ($2,202,000)$189,923 $189,923
31023-Whale Rock CIP Reserve Contribution - Cal Poly $585,006 $466,831 $466,831 ($1,348,400)$116,300 $116,300
31024-Whale Rock CIP Reserve Contribution - CA Men's Colony $242,922 $155,657 $155,657 ($449,600)$38,778 $38,778
51001-Salaries - Regular $343,044 $346,208 $370,480 $430,867 $434,659 $461,661 $471,415 $474,159 $500,424 $515,436 $530,899
51003-Salaries - Contract $6,310 $3,109 $10,180 $0 $0 $0 $0 $0
51004-Salaries - Temporary $157 $0 $0 $0 $0 $0 $0
51010-Overtime $7,734 $1,342 $1,661 $1,044 $791 $4,000 $3,000 $3,000 $3,090 $3,183 $3,278
51017-Standby $19,663 $19,167 $18,972 $18,539 $16,152 $22,245 $22,245 $22,245 $22,912 $23,600 $24,308
51018-Call Back $687 $871 $2,709 $5,037 $6,000 $4,000 $4,000 $4,120 $4,244 $4,371
52001-Retirement Contributions $33,020 $31,035 $31,662 $33,752 $40,619 $40,810 $38,553 $38,775 $39,939 $41,137 $42,371
52002-Retirement PARS -401 $143 $159 $173 $200 $220 $218 $222 $222 $238 $246 $253Total$1,131,950 $1,312,583 $1,267,077 $1,600,830 $2,623,105 $7,080,948 $3,671,589 $4,488,036 $5,851,642 $2,715,308 $4,544,769
Account Category
All
Whale Rock Fund Expenditure Details
Account Subcategory
All
Concat Account
All
Item Description
All
Assigned Member Agency
All
Expenditure Actuals & Forecast
$0M
$2M
$4M
$6M
2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29 2029-30 2030-31 2031-32 2032-33 2033-34 2034-35
$1.13M $1.31M $1.27M $1.60M
$2.62M
$7.08M
$3.67M
$4.49M
$5.85M
$2.72M
$4.54M $4.56M $4.61M
$2.89M $2.96M $3.09M
Actual Budgeted Forecasted
Page 131 of 141
Charge Account 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033
705.0000.44002 ($561)
705.1101.51001$9 $41 $81
705.1101.51017$490 $434 $370
705.1101.52001$39 $34 $31 $11
705.1101.53002 $1
705.1101.55001$6 $6 $5 $2
705.2001.75002$160,203 $183,978 $186,211
705.2007.44002 ($4,488)($1,122)
705.2007.44101($71,545)($818)($4,603)($75,127)($183,176)
705.2007.44107 $39,198 $17,408 ($84,677)
705.2007.44204($4,862) ($3,366)($4,488)($5,895)
705.6003.51001 $54
705.6003.52001 $4 $3
705.6003.55001 $1 $0
705.6005.52001($0)
705.6201.31022 $1,189,755 $762,357 $762,357 ($2,202,000)$189,923 $189,923 $189,923 $189,923 $189,92
705.6201.31023 $585,006 $466,831 $466,831 ($1,348,400)$116,300 $116,300 $116,300 $116,300 $116,30
705.6201.31024 $242,922 $155,657 $155,657 ($449,600)$38,778 $38,778 $38,778 $38,778 $38,77
705.6201.44101 ($34,985)($3,032) ($1,000)($1,000)($1,000)($1,000)($1,000)($1,000)($1,000)($1,000)($1,000
705.6201.44107 $107,755
705.6201.44305($7,613)
705.6201.44310($743)($743)($1,091)($743)($742)($6,000)($6,000)($6,000)($6,000)($6,000)($6,000)($6,000)($6,000)($6,000
705.6201.45307 ($260)
705.6201.46703$3,034
705.6201.46706($979,351)($1,015,607)($949,126)($1,126,924)($1,242,781)($1,310,027)($1,399,812)($1,399,091)($1,427,435)($1,491,043)($1,513,487)($1,580,970)($1,604,781)($1,676,373
Total ($736,864)($848,912)($1,127,581)($775,353)($423,261)$4,272,189 ($0)($0)($0)$0 $0 ($0)$0 ($0
General Ledger & Forecast Detail
Concat Account
All
Item Description
All
Fiscal Year
All
Account Category
All
Account Subcategory
All
Page 132 of 141
Item Description 2020 2021 2022 2023 2024
1000047-Fleet Replacements - Annual Asset Maintenance$0 $0 $0 $0
1000074-IT Replacements - Annual Asset Maintenance Account$2,624 $1,637 $3,035 $243
1000075-Major Facilities Maintenance - Annual Asset Maintenance Account$0 $0 $0 $0
1000176-Whale Rock Intake Valve Replacement$0 $0 $0 $0
1000181-Fleet Services Vehicle Lift$0 $0 $0 $0
1000521-Fleet Replacement: Utilities$0 $0 $0 $0
1000542-Water Treatment Plant Major Facility Maintenance$0 $0 $0 $0
2000075-Major Facilities Maintenance [1000075]
2000176-Whale Rock Intake Valve Replacement [1000176]
2000181-Fleet Services Vehicle Lift [1000181] $2,000
2000521-Fleet Replacement: Utilities [1000521] $20,215
2000602-Utilities IT Replacements [1000074]
2000603-Enterprise IT Replacements [1000074] $0
2000604-Network IT Replacements [1000074]
2001009-Whale Rock Major Maintenance [91335]$19,210 $125,511 $72,990 $89,897 $544,663
2001017-Whale Rock Pipe Assessment and Repairs [91617] $3,000
2001019-Whale Rock Auto Control Valves [91718] $7,227
200549-Whale Rock Pump Station Electrical Repairs (A and B) [1000549]
200xxx-Emergency pipeline repair
90069-Whale Rock Old Creek Habitat Plan (90069)$0 $0 $0 $0
90490-Water Distribution Telemetry System Upgrade (90490)$8,432 $0 $0 $0
91617-Whale Rock Pipe Assessment and Repairs (91617)$30,000 $0 $289 $83,753
91617-Whale Rock Transmission Pipeline
91675-Whale Rock Boathouse Replacement (91675)$2,928 $7,575 $0 $0
91716-Whale Rock Boat Dock (91716)$2,093 $0 $0 $0
Total $84,591 $168,494 $76,025 $176,959 $577,105
Capital Projects Details
Item Description
All
Notes
All
Fiscal Year
All
Page 133 of 141
Repor t Owner : Shane Whittington
Description: To analyze current fund position, forecast long term fund position, and present the information in a way that is easily understood by internal staff.
Last Updated: 03/31/2025
3/31/2025
Updated with finalized Operating and Capital Expenses. Rebalanced revenue accounts accordingly. Assumes a $4M draw on Capital Reserves in FY28 for 1000549-01-Whale Rock Pump Station Rehab (A and B).
Updated unreserved fund balance to include an additional 20%--this amount was previously backed out as part of a operating reserve.
2/2/2025
Updated FY24 with actuals, FY25 with modified budgeted, and FY26-FY35 with forecasted.
Updated Lookup tables to include 2033-2035.
This may change as better information is made available--for example, IT projects are not validated, salaries and benefits need to be finalized, various operating accounts need to be confirmed, and a CIP reserve
contributions/drawdowns need to be established. All table rows needing review contain the text "Needs Additional Review" in the Item Description.
1/22/2025
Updated query to unpivot 2033-2035. Deleted 2036-2039 for simplicity.
Add carryover projects to FY2025.
Fixed calcs in Lookup worksheet.
Add carryover POs (may not be complete?).
5/03/2024
Added audited financials for Audited Year End Fund Balance on the lookup page. This should equal the unrestricted net position in the audited financials. There was only a variance of $1.82 relative to what was
calculated. This is immaterial.
3/26/2024
Adjusted 2001009-08 Roadway Pavement to revised construction totals as determined by MB and NE. Reduced the 2024-25 allocation from $520,000 to $414,960.
3/20/2024
Added budget changes relative to Council Consent Item 6f (3/19/2024). This action added funding to 2000075-09.01 Corp Yard Fuel Island Rehabilitation and pulled from completed projects.
3/12/2024
Changed the source data to include anticipated budget changes for 2024-25. The changes are listed below:
1. Added $15,000 to as an ongoing expense for non-member legal representation (61007).
2. Removed $20,000 from emergency pipeline repairs (61013). This was added as a CIP and increased to $30,000 (200xxx-Emergency Pipeline Repair).
3. Increased the machinery and equipment budget from $20,000 to $60,000 to reflect inflation and aging assets (62505).
4. Changed the allocation for 1000549-Whale Rock Pump Station Electrical Repairs (A and B) from $1,960,620 to $500,000 for study and design. $2,000,000 was added to 2025-26 for construction.
5. Added $520,000 for 2001009-08 Roadway Pavement.
6. Increased 2001009-03 Advanced Instrumentation and Safety Monitoring of Critical Infrastructure from $108,923 to $250,000.
7. Adjusted the City of SLO's pumping charges to reflect changes in water use strategies (61503 and 46711).
8. Adjusted Capital Reserve accounts to reflect a $505,000 drawdown in 2024-25 and a $1,455,000 drawdown in 2025-26 (31022, 31023, and 31024).
9. Rebalanced agency contributions to reflect proportional share relative to these changes (46706, 46707, 46711).
2/7/2024
Page 134 of 141
Page 135 of 141
Page 136 of 141
Page 137 of 141
Page 138 of 141
Page 139 of 141
Page 140 of 141
Page 141 of 141