Attachment D, Exhibit 1
Fund Department/Fund Title Revenue Expense Comments
GENERAL FUND
General Fund Administrative Services Retiree Health Adjustment $ - $ 135,892 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund City Attorney Retiree Health Adjustment $ - $ 32,971 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund City Clerk Retiree Health Adjustment $ - $ (2,083) Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund City Council Retiree Health Adjustment $ - $ 3,361 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund City Manager Retiree Health Adjustment $ - $ 38,164 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund Community Services Retiree Health Adjustment $ - $ 192,818 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund Development Services Retiree Health Adjustment $ - $ 97,619 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund Fire Retiree Health Adjustment $ - $ 332,566 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund Human Resources Retiree Health Adjustment $ - $ 13,933 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund Library Retiree Health Adjustment $ - $ 51,003 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund Office of Emergency Services Retiree Health Adjustment $ - $ 11,424 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund Office of Transportation Retiree Health Adjustment $ - $ 17,277 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund
Planning & Community
Services Retiree Health Adjustment $ - $ 62,823
Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund Police Retiree Health Adjustment $ - $ 500,199 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
General Fund Public Works Retiree Health Adjustment $ - $ 162,690 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
GENERAL FUND SUBTOTAL $ - $ 1,650,657
SPECIAL REVENUE FUNDS
236 - University Avenue Parking Permits Administrative Services Retiree Health Adjustment $ - $ 536 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
236 - University Avenue Parking Permits Office of Transportation Retiree Health Adjustment $ - $ 144 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
236 - University Avenue Parking Permits Public Works Retiree Health Adjustment $ - $ 1,733 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
237 - California Avenue Parking Permits Administrative Services Retiree Health Adjustment $ - $ 244 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
City of Palo Alto
Central Other Post-Employment Benefits (OPEB) Adjustments in Various Funds 237 - California Avenue Parking Permits Office of Transportation Retiree Health Adjustment $ - $ 144 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
237 - California Avenue Parking Permits Public Works Retiree Health Adjustment $ - $ 187 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
239 - Residential Parking Permit Programs Office of Transportation Retiree Health Adjustment $ - $ 1,000 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
SPECIAL REVENUE FUNDS SUBTOTAL $ - $ 3,987
CAPITAL FUNDS
471 - Capital Improvement Fund Administrative Services Retiree Health Adjustment $ - $ 2,039 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
471 - Capital Improvement Fund Community Services Retiree Health Adjustment $ - $ 1,699 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
471 - Capital Improvement Fund Office of Transportation Retiree Health Adjustment $ - $ 13,611 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
471 - Capital Improvement Fund Public Works Retiree Health Adjustment $ - $ 36,760 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
CAPITAL FUNDS SUBTOTAL $ - $ 54,109
ENTERPRISE FUNDS
513 - Electric Supply Fund Utilities $ - $ 19,110 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
514 - Gas Supply Fund Utilities $ - $ 5,030
Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
521 - Utilities Administration Fund Utilities $ - $ (3,364) Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
522 - Water Fund Utilities $ - $ 75,809
Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
523 - Electric Fund Utilities $ - $ 258,632
Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
524 - Gas Fund Utilities $ - $ 131,896
Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
525 - Refuse Fund Public Works $ - $ 47,695
Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
526 - Wastewater Treatment Fund Public Works $ - $ 295,490 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
527 - Wastewater Collection Fund Utilities $ - $ (74,921) Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
528 - Stormwater Management Fund Public Works $ - $ 36,272 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
530 - Airport Enterprise Fund Public Works $ - $ 9,345 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
533 - Fiber Optics Fund Utilities $ - $ (3,028)
Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
ENTERPRISE FUNDS SUBTOTAL $ - $ 797,965
Attachment D, Exhibit 1
INTERNAL SERVICE FUNDS
681 - Vehicle Replacement & Maintenance Fund Public Works Retiree Health Adjustment $ - $ 20,134 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
682 - Technology Fund Information Technology Retiree Health Adjustment $ - $ 71,067 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
683 - Printing & Mailing Services Fund Administrative Services Retiree Health Adjustment $ - $ 5,296 Adjustments to align OPEB costs with the June 30, 2023 Valuation (CMR 2402-2673)
687 - General Benefits & Insurance Fund
687 - General Benefits &
Insurance Fund Retiree Health Adjustment $ - $ (254,500) Transfer for Implied Subsidy 694 - Retiree Health Benefits Fund - AB702
Retiree Health Benefits Fund -
AB702 Retiree Health Adjustment $ 2,603,214 $ - OPEB Funding from City Funds 694 - Retiree Health Benefits Fund - AB702
Retiree Health Benefits Fund -
AB702 Retiree Health Adjustment $ (254,500) $ - Transfer for Implied Subsidy 694 - Retiree Health Benefits Fund - AB702
Retiree Health Benefits Fund -
AB702 Retiree Health Adjustment $ - $ 2,348,714 OPEB costs for increased Actuarial Determined Contribution (ADC) INTERNAL SERVICE FUNDS SUBTOTAL $ 2,348,714 $ 2,190,711 TOTAL ADJUSTMENT $ 2,348,714 $ 4,697,429
Attachment D, Exhibit 1