HomeMy WebLinkAboutStaff Report 14268
City of Palo Alto (ID # 14268)
Utilities Advisory Commission Staff Report
Meeting Date: 5/4/2022 Report Type: VII. NEW BUSINESS
City of Palo Alto Page 1
Title: Staff Recommendation That the Utilities Advisory Commission
Recommend the City Council Adopt the Proposed Operating and Capital
Budgets for the Utilities Department for Fiscal Year 2023
From: Director of Utilities
Lead Department: Utilities
Recommended Motion
Staff recommends the Utilities Advisory Commission recommend the City Council adopt the
Proposed Operating and Capital Budgets for the Utilities Department for Fiscal Year 2023.
Discussion
Attached are the FY 2023 Proposed Operating and Capital budgets for the Utilities Department.
Due to the number of pages of the CIP budget, staff only printed the CIP overview and five year
forecast of each utility for FY 2023– FY 2027.
The entire Utilities CIP budget for FY 2023 – FY 2027 with the individual project pages can be
downloaded and viewed in full from the link:
Preliminary Proposed Utilities Capital Budgets for FY 2023 - FY 2027
Preliminary Proposed Utilities Operating Budgets for FY 2023 – FY 2027
City Council will not be receiving their copies of the Operating and Capital Budgets until
Thursday, April 28, 2022. Please refrain from discussing the proposed budget materials with
Council or the public until Monday, May 2, 2022.
Attachments:
• Attachment: Presentation
5
Packet Pg. 22
MAY 4, 2022 www.cityofpaloalto.org
Utilities Advisory Commission
Proposed FY 2023 Utilities
Operating and Capital Budgets
Staff: Dave Yuan, Alex Harris, Anna Vuong
Attachment G
•
CITY OF
PALO ALTO
5.a
Packet Pg. 23
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
CHANGE REQUEST PROCESS
2
Submits
Request
DEPT HR OMB CMO UAC FC
Approves
Request
Council
Preliminary Requests Recommended Requests
General review process for staffing, budget, and project changes
~CITY OF
~PALO ALTO
• -■ •
5.a
Packet Pg. 24
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
PROPOSED NEW PROJECTS
3
•Technology projects
•Outage management system $350k -$500k
•Fiber management system $250k -$350k
•Master plan studies
•Electric distribution system $500k -$1,000k
•Wastewater Collection system $400k -$550k
~CITY OF
~PALO ALTO
5.a
Packet Pg. 25
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
Recommended FY 2023 RATES
4
1 Gas rate changes shown with commodity rates held constant. Actual gas commodity rates vary monthly.
2 Storm Drain fees and increases by CPI annually per approved 2017 ballot measure
3 Fiber EDF-1 rates increase by CPI, which is 4.2% for FY 2023
4 Based on FY 2022 monthly bill of $332.75.
FY 2022
(Took effect
July 1, 2021)
FY 2023
(Proposed for
July 1, 2022)FY 2024 FY 2025 FY 2026 FY 2027
$0.00 $2.87 $3.61 $3.83 $4.06 $4.30
0.0% 5.0% 6.0% 6.0% 6.0% 6.0%
$1.60 $2.62 $2.73 $2.84 $2.95 $2.30
3.0% 4.0% 4.0% 4.0% 4.0% 3.0%
$2.00 $1.30 $2.23 $2.34 $2.46 $2.58
3.0% 3.0% 5.0% 5.0% 5.0% 5.0%
$0.00 $8.05 $6.70 $2.42 $2.47 $0.00
0.0% 8.9% 6.8% 2.3% 2.3% 0.0%
$0.00 $0.00 $1.50 $1.55 $1.59 $1.64
0.0% 0.0% 3.0% 3.0% 3.0% 3.0%
$0.30 $0.64 $0.48 $0.49 $0.51 $0.52
2.5% 4.2% 3.0% 3.0% 3.0% 3.0%
$3.90 $15.48 $17.25 $13.47 $14.05 $11.35
1.2% 4.7% 4.9% 3.7% 3.7% 2.9%Monthly Bill Change 4
Electric Utility
Gas Utility 1
Wastewater
Water Utility
Refuse
Storm Drain 2, 3
~CITY OF
~PALO ALTO
5.a
Packet Pg. 26
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
Recommended FY 2023 RATES –RESIDENTIAL BILL IMPACT
5
Utility
Adjusted
FY2022
Bill
FY2023 Bill Bill Change
($)
Rate Change
(%)
Electric 57.31 60.17 2.87 5.0%
Gas 65.62 68.24 2.62 4.0%
Wastewater 43.32 44.62 1.30 3.0%
Water 90.42 98.47 8.05 8.9%
Refuse 50.07 50.07 - 0.0%
Storm Drain 15.34 15.98 0.64 4.2%
User Tax 1 10.67 11.34 0.68 6.3%
Total Monthly
Bill 332.75 348.90 16.16 4.9%
1 User Tax is additional 5 percent of electric, gas, and water bill
~CITY OF
~PALO ALTO
5.a
Packet Pg. 27
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
ELECTRIC
MAY 4, 2022 www.cityofpaloalto.org
5.a
Packet Pg. 28
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
ELECTRIC OPERATING PRELIMINARY PROPOSED EXPENSES
7
Allocated Charges
$10.64 M
5%
CIP
$26.14 M
12%
Contract Services
$12.82 M
6%
Equity Transfer
$14.64 M
7%
Other Expenses
$6.97 M
3%
Rent & Debt
Service
$15.65 M
8%
Salary & Benefits
$23.22 M
11%
Utility Purchase
$101.74 M
48%
ELECTRIC FUND PRELIMINARY PROPOSED BUDGET
~CITY OF
~PALO ALTO
5.a
Packet Pg. 29
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
ELECTRIC OPERATING EXPENSES FY22 BUDGET TO ACTUALS
8
GL Type Budget Group Adjusted Budget YTD Actuals Q3 FY22 Remaining Budget % of total
Revenues Net Sales $ 158,134,394 $ 112,855,755 $ 45,278,639 71.4%
Other Revenues $ 14,338,925 $ 7,667,259 $ 6,671,666 53.5%
Revenues Total $ 172,473,319 $ 120,523,014 $ 51,950,306 69.9%
Expenses Salary & Benefits $ 26,106,768 $ 17,533,478 $ 8,573,290 67.2%
Utility Purchase $ 105,329,457 $ 67,358,494 $ 37,970,963 64.0%
CIP/Contract Services $ 42,947,975 $ 6,428,286 $ 36,519,689 15.0%
Other Expenses $ 6,859,909 $ 3,073,950 $ 3,785,958 44.8%
Rent & Debt Service $ 14,579,750 $ 10,169,122 $ 4,410,628 69.7%
Allocated Charges $ 10,633,595 $ 5,922,461 $ 4,711,133 55.7%
Equity Transfer $ 14,138,000 $ 10,723,500 $ 3,414,500 75.8%
Expenses Total $ 220,595,453 $ 121,209,292 $ 99,386,161 54.9%
~CITY OF
~PALO ALTO
5.a
Packet Pg. 30
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
ELECTRIC 5-YR CIP 2023-27
9
$0.0M
$5.0M
$10.0M
$15.0M
$20.0M
$25.0M
$30.0M
$35.0M
$40.0M
2022 Estimated 2023 Proposed 2024 Forecast 2025 Forecast 2026 Forecast 2027 Forecast
523 - Electric Fund - Substation Improvements
523 - Electric Fund - 4/12 Conversion
523 - Electric Fund - UG Rebuild
523 - Electric Fund - Undergrounding Projects
523 - Electric Fund - Customer Connections
523 - Electric Fund - System Improvements
~CITY OF
~PALO ALTO
■
■
■
■
■
■
5.a
Packet Pg. 31
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
ELECTRIC HISTORICAL PROJECT ACTUALS
10
Proj. No.Project Title (No.) Start
Year
Original
Budget
FY15
ACTUALS
FY16
ACTUALS
FY17
ACTUALS
FY18
ACTUALS
FY19
ACTUALS
FY20
ACTUALS
FY21
ACTUALS
EL-06001 115 kV Electric Intertie (EL-06001)2013 50,000 46,155 1,008 745 508 - - -
EL-11006 Rebuild Underground District 18 (EL-11006)2013 475,000 49,413 364,384 -
EL-14005 Reconfigure Quarry Feeders (EL-14005)2013 400,000 69,169 129,887 169,279 - 101,121 9,681 40,649
EL-13006 Sand Hill / Quarry 12kV Tie (EL-13006)2013 157,259 4,374 1,023 82,982 -
EL-11010 UG District 47-Middlefield, Homer, Webster, Addison (EL-11010)2013 2,598,525 195,283 2,142,918 632,835 31,960 25,365 46,938 5,886
EL-14004 Maybell 1 & 2 4/12kV Conversion (EL-14004)2014 185,372 255,478 3,277 172 - 52,417
EL-15001 Electric Substation Battery Replacement (EL-15001)2015 400,000 - 293,869 21,991
EL-16003 Substation Physical Security (EL-16003)2015 200,000 1,910 46,992 75,778 88,039 103,072 659,123
EL-12001 Underground District 46 - Charleston/El Camino Real (EL-12001)2015 1,895,454 3,535 73,545 76,862 214,263 1,894,650 42,200 197,414
EL-14000 Coleridge/Cowper/Tennyson 4/12kV Conversion (EL-14000)2016 120,000 - 29,827 82,052 68,934
EL-11014 Smart Grid Technology Installation (EL-11014)2016 781,766 65,625 34,742 17,240 162,505 97,288 136,613 96,905
EL-17007 Facility Relocation for Caltrain Modernization Project (EL-17007)2017 1,700,000 - 20,299 83,287 207,484 2,088,718
EL-17005 Inter-substation Line Protection Relay (EL-17005)2017 167,000 51,503 159,057 94,563 24,102 37,127
EL-17002 Substation Breaker Replacement (EL-17002)2017 600,000 22,513 146,253 79,472 103,012 1,004,469
EL-17008 Utility Control Center Upgrades (EL-17008)2017 400,000 2,813 - 437,831 81,373
EL-19001 Colorado Power Station Equipment Upgrades (EL-19001)1 2018 900,000 - 922,316 3,126,755 232,954
EL-19002 Colorado Substation Site Improvements (EL-19002)2018 500,000 16,360 100,265 66,579
EL-21001 Foothills Rebuild (Fire Mitigation) (EL-21001)2020 2,000,000 185,384
Electric Capital Projects 689,032 3,046,563 1,125,927 810,623 3,922,536 4,063,548 4,684,142
1 Replaced instead of refurbished one of the 115kV transformers
~CITY OF
~PALO ALTO
5.a
Packet Pg. 32
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
GAS
MAY 4, 2022 www.cityofpaloalto.org
5.a
Packet Pg. 33
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
GAS OPERATING PRELIMINARY PROPOSED EXPENSES
12
Allocated Charges
$5.11 M
9%
CIP
$10.48 M
18%
Contract Services
$1.9 M
3%
Equity Transfer
$7.17 M
12%
Other Expenses
$3.21 M
6%
Rent & Debt Service
$1.44 M
2%
Salary & Benefits
$9.21 M
16%
Utility Purchase
$20.11 M
34%
GAS FUND PRELIMINARY PROPOSED BUDGET
~CITY OF
~PALO ALTO
5.a
Packet Pg. 34
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
GAS OPERATING EXPENSES FY22 BUDGET TO ACTUALS
13
GL Type Budget Group Adjusted Budget YTD Actuals Q3 FY22 Remaining Budget % of total
Revenues Net Sales $ 47,865,541 $ 36,391,916 $ 11,473,625 76.0%
Other Revenues $ 1,912,060 $ 939,136 $ 972,924 49.1%
Revenues Total $ 49,777,601 $ 37,331,052 $ 12,446,549 75.0%
Expenses Salary & Benefits $ 10,919,105 $ 7,208,715 $ 3,710,390 66.0%
Utility Purchase $ 23,780,287 $ 17,369,211 $ 6,411,076 73.0%
CIP/Contract Services $ 12,125,304 $ 3,972,958 $ 8,152,346 32.8%
Other Expenses $ 1,746,940 $ 1,206,403 $ 540,536 69.1%
Rent & Debt Service $ 1,422,532 $ 519,217 $ 903,315 36.5%
Allocated Charges $ 5,281,840 $ 2,798,527 $ 2,483,312 53.0%
Equity Transfer $ 7,240,000 $ 5,571,750 $ 1,668,250 77.0%
Expenses Total $ 62,516,008 $ 38,646,781 $ 23,869,227 61.8%
~CITY OF
~PALO ALTO
5.a
Packet Pg. 35
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
GAS 5-YR CIP 2023-27
14
$0.0M
$2.0M
$4.0M
$6.0M
$8.0M
$10.0M
$12.0M
2022 Estimated 2023 Proposed 2024 Forecast 2025 Forecast 2026 Forecast 2027 Forecast
524 - Gas Fund - Customer Connections
524 - Gas Fund - System Improvements
524 - Gas Fund - Gas Main Replacements
~CITY OF
~PALO ALTO
■
■
■
5.a
Packet Pg. 36
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
GAS HISTORICAL PROJECT ACTUALS
15
Proj. No.Project Title (No.) Start
Year
Original
Budget
FY15
ACTUALS
FY16
ACTUALS
FY17
ACTUALS
FY18
ACTUALS
FY19
ACTUALS
FY20
ACTUALS
FY21
ACTUALS
GS-09002 Gas Main Replacement - Project 19 (GS-09002)1 2013 5,800,000 1,821,628 68,899
GS-10001 Gas Main Replacement - Project 20 (GS-10001)1 2013 6,614,000 2,443,978 23,297
GS-11000 Gas Main Replacement - Project 21 (GS-11000)1 2013 6,150,000 1,447,686 678,845 - - -
GS-12001 Gas Main Replacement - Project 22 (GS-12001)2015 3,668,000 306,590 348,143 383,432 1,186,940 8,400,336 412,975 51,398
GS-15001 Security at City Gas Receiving Stations (GS-15001)2015 150,000 - 15,942 69,358 6,167 31,134
GS-13001 Gas Main Replacement - Project 23 (GS-13001)2016 3,588,150 - 42,500 22,082 90,291 59,329 770,610
GS-18000 Gas ABS/Tenite Replacement Project (GS-18000)2018 1,500,000 31,015 987,792 839,223
Gas Capital Projects 6,019,882 1,135,126 495,290 1,215,189 8,552,776 1,460,096 1,661,230
1 GMR 19, 20, and 21 were combined under one contract in FY13; $9.3M actuals in FY13 and FY14
~CITY OF
~PALO ALTO
5.a
Packet Pg. 37
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
FIBER
MAY 4, 2022 www.cityofpaloalto.org
5.a
Packet Pg. 38
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
FIBER OPERATING PRELIMINARY PROPOSED EXPENSES
17
Allocated Charges
$0.72 M
16%
CIP
$2.02 M
45%
Contract Services
$0.24 M
5%
Other Expenses
$0.12 M
3%
Rent & Debt Service
$0.06 M
1%
Salary & Benefits
$1.34 M
30%
FIBER FUND PRELIMINARY PROPOSED BUDGET
~CITY OF
~PALO ALTO
5.a
Packet Pg. 39
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
FIBER OPERATING EXPENSES FY22 BUDGET TO ACTUALS
18
GL Type Budget Group Adjusted Budget YTD Actuals Q3 FY22 Remaining Budget % of total
Revenues Net Sales $ 3,572,189 $ 2,532,639 $ 1,039,550 70.9%
Other Revenues $ 846,700 $ 282,656 $ 564,044 33.4%
Revenues Total $ 4,418,889 $ 2,815,295 $ 1,603,594 63.7%
Expenses Salary & Benefits $ 1,621,087 $ 860,558 $ 760,528 53.1%
CIP/Contract Services $ 3,151,519 $ 1,104,420 $ 2,047,099 35.0%
Other Expenses $ 123,176 $ 120,203 $ 2,973 97.6%
Rent & Debt Service $ 54,539 $ 39,750 $ 14,789 72.9%
Allocated Charges $ 725,232 $ 372,488 $ 352,744 51.4%
Expenses Total $ 5,675,553 $ 2,497,419 $ 3,178,134 44.0%
~CITY OF
~PALO ALTO
5.a
Packet Pg. 40
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
FIBER 5-YR CIP 2023-27
19
$0.0M
$0.5M
$1.0M
$1.5M
$2.0M
$2.5M
$3.0M
2022 Estimated 2023 Proposed 2024 Forecast 2025 Forecast 2026 Forecast 2027 Forecast
533 - Fiber Optics Fund - Customer Connections
533 - Fiber Optics Fund - Capacity Improvements
~CITY OF
~PALO ALTO
■
■
5.a
Packet Pg. 41
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
FIBER HISTORICAL PROJECT ACTUALS
20
Proj. No.Project Title (No.) Start
Year
Original
Budget
FY15
ACTUALS
FY16
ACTUALS
FY17
ACTUALS
FY18
ACTUALS
FY19
ACTUALS
FY20
ACTUALS
FY21
ACTUALS
FO-16000 Fiber Optics Network - System Rebuild (FO-16000) 1 2016 1,250,000 - 140,875 20,636 5,656 - 682 184,038
1 System Rebuild was place on hold until completion of fiber expansion study by Magellan; FY22 YTD is $1.0M
I I
~CITY OF
~PALO ALTO
I I
5.a
Packet Pg. 42
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WASTEWATER
MAY 4, 2022 www.cityofpaloalto.org
5.a
Packet Pg. 43
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WASTEWATER OPERATING PRELIMINARY PROPOSED EXPENSES
22
Allocated Charges
$2.86 M
12%
CIP
$3.59 M
15%
Contract Services
$0.25 M
1%
Other Expenses
$0.73 M
3%
Rent & Debt Service
$0.5 M
2%
Salary & Benefits
$3.76 M
16%
Utility Purchase
$11.85 M
51%
WASTEWATER FUND PRELIMINARY PROPOSED BUDGET
~CITY OF
~PALO ALTO
5.a
Packet Pg. 44
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WASTEWATER OPERATING EXPENSES FY22 BUDGET TO ACTUALS
23
GL Type Budget Group Adjusted Budget YTD Actuals Q3 FY22 Remaining Budget % of total
Revenues Net Sales $ 20,615,857 $ 14,959,360 $ 5,656,497 72.6%
Other Revenues $ 440,469 $ 208,020 $ 232,449 47.2%
Revenues Total $ 21,056,326 $ 15,167,381 $ 5,888,946 72.0%
Expenses Salary & Benefits $ 5,501,055 $ 3,568,069 $ 1,932,986 64.9%
Utility Purchase $ 11,153,615 $ 8,365,211 $ 2,788,404 75.0%
CIP/Contract Services $ 4,945,483 $ 101,612 $ 4,843,870 2.1%
Other Expenses $ 787,005 $ 546,101 $ 240,904 69.4%
Rent & Debt Service $ 485,791 $ 282,511 $ 203,280 58.2%
Allocated Charges $ 3,073,670 $ 1,703,452 $ 1,370,218 55%
Expenses Total $ 25,946,618 $ 14,566,956 $ 11,379,662 56.1%
~CITY OF
~PALO ALTO
5.a
Packet Pg. 45
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WASTEWATER 5-YR CIP 2023-27
24
$0.0M
$1.0M
$2.0M
$3.0M
$4.0M
$5.0M
$6.0M
$7.0M
$8.0M
2022 Estimated 2023 Proposed 2024 Forecast 2025 Forecast 2026 Forecast 2027 Forecast
527 - Wastewater Collection Fund - Customer
Connections
527 - Wastewater Collection Fund - System
Improvements
~CITY OF
~PALO ALTO
■
■
5.a
Packet Pg. 46
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WASTEWATER HISTORICAL PROJECT ACTUALS
25
Proj. No.Project Title (No.) Start
Year
Original
Budget
FY15
ACTUALS
FY16
ACTUALS
FY17
ACTUALS
FY18
ACTUALS
FY19
ACTUALS
FY20
ACTUALS
FY21
ACTUALS
WC-11000 Wastewater Collection System Rehabilitation Project 24 (WC-11000)1 2010 3,120,000 172,305 835,311 1,265,999 121,353 - 84,251
WC-12001 Wastewater Collection System Rehabilitation Project 25 (WC-12001)1 2011 3,212,000 168,802 834,017 1,383,387 346,954 - 128,619
WC-13001 Wastewater Collection System Rehabilitation Project 26 (WC-13001)1 2012 3,310,000 108,901 1,063,095 1,672,424 166,536 - 155,209
WC-14001 Wastewater Collection System Rehabilitation Project 27 (WC-14001)2015 3,410,000 103,583 203,558 2,988,313 741,531 -
WC-15001 Wastewater Collection System Rehabilitation Project 28 (WC-15001)2016 3,513,000 - - 47,557 430,621 2,200,390 117,224
WC-16001 Wastewater Collection System Rehabilitation Project 29 (WC-16001)2017 3,610,000 - 113,466 654,019 1,679,785
WC-17001 Wastewater Collection System Rehabilitation Project 30 (WC-17001)2018 3,712,000 - 42,317 191,055
Wastewater Capital Projects 553,591 2,935,981 7,310,123 1,423,931 544,087 3,264,803 1,988,063
1 SSR 24, 25, and 26 were combined under one contract in FY 2015
~CITY OF
~PALO ALTO
5.a
Packet Pg. 47
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WATER
MAY 4, 2022 www.cityofpaloalto.org
5.a
Packet Pg. 48
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WATER OPERATING BASE & PRELIM PROPOSALS
27
Allocated Charges
$5.23 M
9%
CIP
$13.73 M
23%
Contract Services
$0.86 M
2%
Other Expenses
$1.37 M
2%
Rent & Debt Service
$6.76 M
11%
Salary & Benefits
$9.59 M
16%
Utility Purchase
$21.85 M
37%
WATER FUND PRELIMINARY PROPOSED BUDGET
~CITY OF
~PALO ALTO
5.a
Packet Pg. 49
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WATER OPERATING EXPENSES FY22 BUDGET TO ACTUALS
28
GL Type Budget Group Adjusted Budget YTD Actuals Q3 FY22 Remaining Budget % of total
Revenues Net Sales $45,434,086 $33,098,917 $12,335,170 72.9%
Other Revenues $2,573,087 $1,903,443 $669,643 74.0%
Revenues Total $48,007,173 $35,002,360 $13,004,813 72.9%
Expenses Salary & Benefits $9,996,471 $7,253,483 $2,742,988 72.6%
Utility Purchase $21,408,998 $14,726,366 $6,682,632 68.8%
CIP/Contract Services $24,531,650 $3,911,368 $20,620,282 15.9%
Other Expenses $1,335,522 $1,167,834 $167,688 87.4%
Rent & Debt Service $6,663,395 $2,420,202 $4,243,193 36.3%
Allocated Charges $5,218,130 $3,032,176 $2,185,955 58%
Expenses Total $69,154,166 $32,511,429 $36,642,737 47.0%
~CITY OF
~PALO ALTO
5.a
Packet Pg. 50
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WATER 5-YR CIP 2023-27
29
$0.0M
$5.0M
$10.0M
$15.0M
$20.0M
$25.0M
$30.0M
2022 Estimated 2023 Proposed 2024 Forecast 2025 Forecast 2026 Forecast 2027 Forecast
522 - Water Fund - Water Main Replacements
522 - Water Fund - Customer Connections
522 - Water Fund - System Improvements
~CITY OF
~PALO ALTO
■
■
■
5.a
Packet Pg. 51
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
WATER HISTORICAL PROJECT ACTUALS
30
Proj. No.Project Title (No.) Start
Year
Original
Budget
FY15
ACTUALS
FY16
ACTUALS
FY17
ACTUALS
FY18
ACTUALS
FY19
ACTUALS
FY20
ACTUALS
FY21
ACTUALS
WS-11000 Water Main Replacement - Project 25 (WS-11000)2011 3,785,386 380,487 4,555,303 276,672 - -
WS-09000 Water Tank Seismic Upgrade and Rehabilitation (WS-09000)2014 2,230,000 714,139 643,014 747,065 602,721 752,256 171,875 1,019,663
WS-12001 Water Main Replacement - Project 26 (WS-12001)1 2015 5,904,489 22,005 68,497 218,686 4,547,950 4,574,968 215,513
WS-15004 Water System Master Plan (WS-15004)2015 155,520 192,207 106,005 358 -
WS-13001 Water Main Replacement - Project 27 (WS-13001)2016 6,206,216 - 42,500 862 105,524 3,972,049 301,700
WS-14001 Water Main Replacement - Project 28 (WS-14001)2017 585,107 - - 22,591 244,535
WS-19000 Mayfield Reservoir Subgrade and Venting Repair (WS-19000)2019 200,000 - 36,747 258,940
Water Capital Projects 1,308,838 5,372,819 1,285,281 5,151,533 5,432,748 4,418,774 1,824,837
1 Includes Upgrade Downtown Water Main Replacement
~CITY OF
~PALO ALTO
5.a
Packet Pg. 52
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
STAFFING
MAY 4, 2022 www.cityofpaloalto.org
5.a
Packet Pg. 53
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
STAFFING -Vacancies and Recruitments
Division Authorized FTE Vacancies Active
Recruitments % Vacancy
Administration 18.5 2 0 11%
Customer Support 23 0 0 0%
Electric Engineering 21 9 9 43%
Electric Operations 67 21 9 31%
Resource Management 23.5 2 2 9%
WGW Engineering 25 3 1 12%
WGW Operations 70 8 3 11%
Grand Total 248 45 25 18%
32~CITY OF
~PALO ALTO
5.a
Packet Pg. 54
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
STAFFING (continued)
Movement by Calendar Year (CY)
CY 2021 JAN -APR 2022
Hires 15 7
Promotions 19 8
Retirements 8 2
Separations 11 10
33~CITY OF
~PALO ALTO
5.a
Packet Pg. 55
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
STAFFING RECRUITMENT AND RETAINMENT STRATEGIES
34
•Departmental Reorganization for Engineering and Operations
•Electric and Fiber
•Water, Gas and Wastewater Collection
•Higher than Market Compensation
•Retention Bonus
•Flexible and Remote Work Schedule
•New Apprentice and Training Programs
•Cross Training
•Succession Planning
•Career Fairs
•Employee or Subsidized Housing
~CITY OF
~PALO ALTO
5.a
Packet Pg. 56
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
PROPOSED STAFFING REQUESTS
35
FY 2023 STAFFING REQUESTS (Net Change +5.5 regular FTEs and +2.6 hourly FTEs)
SCAP (Net Change +2.50 FTE)-Increase project management support to accelerate SCAP
•Associate Sustainability Program Administrator
•Principal Utilities Program Manager*
•Sustainability Program Administrator
•Senior Resource Planner (0.5 FTE)
Fiber Expansion (Net Change + 1.0 FTE) -Provide a dedicated engineer for fiber expansion and
customer projects
•Fiber Project Engineer
Keep Up (Net Change +2.00 FTE) -Increase staffing capacity to keep-up with current and new projects
•Equipment Operator
•Management Analyst
*New Classifications~CITY OF
~PALO ALTO
5.a
Packet Pg. 57
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
PROPOSED STAFFING REQUESTS
36
FY 2023 STAFFING REQUESTS (…continued)
AMI (Net Change +2.6 hourly FTEs)-Provide adequate staffing during AMI transition
•Meter reading function over the next 3 years (2023 –2025)
•Elimination of 6.0 regular FTEs post AMI deployment
Job Classification FY 2022 FY 2023 1st H FY
2024
2nd H FY
2024 FY 2025
Regular Meter Readers 7 5 4 3 1
Hourly Staff 2 3 3 2 0
Total 9 8 7 5 1
~CITY OF
~PALO ALTO
5.a
Packet Pg. 58
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
PROPOSED STAFFING REQUESTS
37
FY 2023 STAFFING REQUESTS (…continued)
Reclassifications
•Streetlight Fiber Technician to UTL Projects Coordinator
•SCADA Technician to Utilities System Analyst
•Electric Heavy Equipment Operator to Utilities System Operator
•Installer/Repairer Lead to Installer/Repairer Welding Lead
~CITY OF
~PALO ALTO
5.a
Packet Pg. 59
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
STAFF RECOMMENDATION TO UAC FOR APPROVAL
38
Staff requests that the Utilities Advisory Commission (UAC) recommend that the Council
approve proposed FY2023 Utilities Operating Budget.
Staff requests that the Utilities Advisory Commission (UAC) recommend that the Council
approve proposed FY2023 Utilities Capital Budget.
~CITY OF
~PALO ALTO
5.a
Packet Pg. 60
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
CITY OF
PALO
ALTO
5.a
Packet Pg. 61
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s
APPROVED STAFFING REQUESTS
FY 2022 MIDYEAR STAFFING CHANGES (Net Change +3.0 FTE)
•Increase project management support and engineering to
accelerate SCAP initiatives
•(+2.0 FTE) Electric Project Engineers to build in-house
expertise and increase engineering capacity
•(+1.0 FTE) UPS Manager to focus on SMB and
Commercial and integrate SCAP into existing programs
40~CITY OF
~PALO ALTO
5.a
Packet Pg. 62
At
t
a
c
h
m
e
n
t
:
A
t
t
a
c
h
m
e
n
t
:
P
r
e
s
e
n
t
a
t
i
o
n
(
1
4
2
6
8
:
P
r
o
p
o
s
e
d
O
p
e
r
a
t
i
n
g
a
n
d
C
a
p
i
t
a
l
B
u
d
g
e
t
s