Guadalupe City Council
June 11, 2024

1,700,000.00 1,700,000.00
- -
-
- - -
- - -
- - -
- - -
(3,542.35)
- - (36,645.52)
5/21/2024 2:10:05 AM Page 1 of 1
999 - Pooled Cash - - - -
Report Total: 9,304,128.20 22,002,734.25
111 - Cal-Fire Urban Forest (State Grant) - - - -
120 - Cares Act (212,405.42) - - (212,405.42)
109 - Central Park xs (292,508.49) 230,962.00 - (61,546.49) 110 - Leroy II Bldg (625.00) - - (625.00)
106 - MICROENTERPRISE (41,112.66) - (4,467.14) (36,645.52) 107 - CV2-3 Food Dis (131,012.39) 43,495.67 (25,610.09) (61,906.63) 100 - CDBG 2017 AWARD (538,647.98) 432,885.52 563.88 (106,326.34) 105 - CDBG CV1 (3,542.35) - - (3,542.35)
098 - Gen.Fix Assets - - - -
099 - Cash Clearing - - - -
096 - Def.Comp.Fund - - - -
097 - Gen.L.T.Fund - - - -
091 - 2003 Bond Refi (1,097.46) - - (1,097.46)
094 - Sewer Bond Fund 35,611.16 - - 35,611.16
089 - CIP 8.53 - 621,282.31 (621,273.78)
090 - RDA-Afford.Hsg 422,703.35 - - 422,703.35
087 - Traffic Mitgtn 10,720.59 - - 10,720.59
088 - SB1 SRTS - - - -
083 - ATP Cycle 3 - - - -
086 - RMRA SB1 53,351.45 175,818.85 - 229,170.30
079 - OB 2019-3 Prjct 316,980.13 7,912,478.82 3,180,453.04 5,049,005.91 082 - ASHC Pedestrian (616,579.96) - - (616,579.96)
077 - CAL Trans GMRP - - - -
078 - City Hall Equip 35,290.58 - - 35,290.58
071 - MEASURE A 460,578.38 521,545.88 327,881.45 654,242.81 076 - Cap Fac Fund 553,690.93 - 13,961.66 539,729.27
065 - Guad.Light Dist 798,016.91 282,394.73 (110.88) 1,080,522.52 067 - EDGB 1971 3,919.16 - - 3,919.16
060 - Guad.Assmt.Dist 62,328.13 42,403.13 12,617.33 92,113.93 063 - Pas L&L Dist 291,766.99 244,265.57 40,491.55 495,541.01 057 - Alcohol & Drug 4,189.10 - - 4,189.10
058 - CDBG-STBG 1465 81,453.89 23,100.00 - 104,553.89
041 - Firehouse - 17,715.42 - 17,715.42
042 - Police Safety Fund 114,375.00 20,600.22 16,828.00 118,147.22 039 - Community Corrections Grant 573.12 2,494.95 (540.69) 3,608.76 040 - Fire Safety Fund 53,218.03 7,780.98 - 60,999.01
036 - Public Facilities Fund 29,052.97 4,029.30 - 33,082.27 038 - Park Developement Fund 786,336.05 7,200.00 - 793,536.05 031 - Payroll Clear - - - -
032 - Waste Water Capital Fund 6,575,799.68 - - 6,575,799.68 028 - Gdlp Library (29,127.23) - 15,000.00 (44,127.23)
030 - Wtr. Cap. Fund (209,449.28) 81,885.46 - (127,563.82) 023 - LTF - Transit 1,116,846.39 1,255,119.12 869,299.74 1,502,665.77 026 - RDA-Op.Fund (2,272,959.86) 447,202.87 146,274.36 (1,972,031.35) 020 - Gas Tax Fund 10,885.23 307,815.35 4,506.66 314,193.92 022 - Local Trans.Fun 195,847.01 14,106.53 - 209,953.54 014 - Wtr Storage Tnk - - - -
015 - Solid Waste - - - -
004 - FEMA - -
010 - Wtr. Oper. Fund 3,566,066.69 2,336,674.69 872,889.19 5,029,852.19 012 - Wst.Wtr.Op.Fund (3,171,121.24) 1,887,126.73 1,285,378.59 (2,569,373.10) Fund Balance Report
City of Guadalupe As Of 05/21/2024
Fund Beginning Balance Total Revenues
001 - General Fund 1,146,712.07 5,703,632.46
I - Fund Balances
ATTACHMENT 2
City of Guadalupe
Capital Improvement Projects
(CIP) Budget
Fiscal Year July 1, 2024 through June 30, 2025
Project
#
Account
# PROJECT DESCRIPTIONS General
Fund ARPA AHSC Grant EDA CAC Clean Air Grant 5339 LCTOP Gas Tax Capital Facilities
Impact Fees Traffic Mitigation Measure A SB1 State Parks Community
Facilities Grant
Lighting
District IRWM CDBG Transit Water Sewer 2024-25 TOTAL Comments Buildings
089-104 089-4444-3044 Financial Accounting Software 41,789 $ 41,789 089-106 089-4444-3077 Public Facilities Master Plan (includes parks and library) 90,000 $ 90,000 089-108 089-4444-3075 PD Electrical service upgrade $ - 089-109 089-4444-3050 Royal Theater 5,000,000 5,000,000 $ 10,000,000 089-112 089-4444-3075
Building improvements (painting, roof repair, locks,
utilities)AKA City Hall Improvements 840,000 $ 840,000
Parks
089-205 089-4444-3053 Central Park Renovation 3,820,000 300,000 $ 4,120,000 089-204 089-4444-3054 Leroy Park Phase II (Multipurpose room) 1,700,000 $ 1,700,000 Streets, Sidewalks, Bicycle Facilities
089-309 089-4444-3098 Sidewalk repairs 100,000 $ 100,000 089-307 089-4444-3067
PSHH Pedestrian Improvements (Gularte St., reimburse
Developer) aka La Guardia sidewalks 179,537 $ 179,537
089-311 089-4444-3092 Strorm drain Trash Amendments improvements 90,000 $ 90,000 089-312 089-4444-3069
Street Rehabilitation FY 24/25 (W. Main west of Pioneer, Obispo Street 37,000 80,483 150,000 50,000 500,000 150,000 $ 967,483 089-314 089-4444-3107 Guadalupe Jr. High Sidewalk Project 105,519 $ 105,519 $105,519 from 2023 Measure A SRTS 089-315 089-4444-3108 Downtown Street Light Improvement Project 400,000 $ 400,000 089-313 089-4444-3106 11th Street Safe Routes to School 2,018,413 114,710 $ 2,133,123 $114,710 from 2022 Measure A SRTS Water
089-406 089-4444-3093 Elevated Tank Painting 580,000 300,000 $ 880,000 089-407 089-4444-3094 AMI Phase 2 (base station and transmitter upgrades) 300,000 $ 300,000 089-408 089-4444-3089 SCADA Improvements 50,000 $ 50,000 Wastewater
089-504 089-4444-3084 Hwy 1 Lift Station 3,534,908 $ 3,534,908 089-514 089-4444-3105 WWTP Improvements 1,800,000 $ 1,800,000 Biolac repairs, dredging, Consolidation Grant application 089-511 089-4444-3082 Pioneer Lift Station 989,000 300,000 $ 1,289,000 089-512 089-4444-3078 Grit system parts replacement 130,000 $ 130,000 089-513 089-4444-3090 WWTP Equipment (Skid-steer, AIPS vault) 420,000 $ 420,000 Transit
089-603 089-4444-3094 EV Charging Stations 767,410 $ 767,410 089-602 089-4444-3097 Amtrak Transit Hub Rehab 494,553 1,004,000 100,000 $ 1,598,553 089-604 089-4444-3099 2 bus shelters - Transit Infrastructure 13,000 $ 13,000 089-605 089-4444-3102 Electric van 116,476 175,000 $ 291,476 089-606 089-4444-3103 2 new electric buses 1,005,072 975,000 172,000 $ 2,152,072 089-607 089-4444-3104 303 Obispo Street Site Improvements 767,410 250,000 44,118 $ 1,061,528 37,000 881,789 5,133,341 5,000,000 5,000,000 1,004,000 1,225,000 216,476 150,000 269,537 50,000 910,229 150,000 4,400,000 1,700,000 700,000 989,000 3,534,908 404,118 650,000 2,650,000 $ 35,055,398 Funding Allocation
City of Guadalupe
Capital Improvement Projects Budget - Fiscal Year 24-25 Project Categories FY 2024-25 General Fund ARPA AHSC Grant EDA CAC Clean Air 5339 LCTOP Gas Tax Capital Facilities Impact Fees Traffic Mitigation Measure A SB1 State Parks Community Facilities Grant Lighting District IRWM CDBG Transit Water Sewer 2024-25 TOTAL Buildings 10,971,789 - 881,789 - 5,000,000 5,000,000 - - - - 90,000 - - - - - - - - - - - 10,971,789 Parks 5,820,000 - - - - - - - - - - - - - 3,820,000 1,700,000 300,000 - - - - - 5,820,000 Streets, Sidewalks, Bicycle Facilities 3,975,662 37,000 - 2,098,896 - - - - - 150,000 179,537 50,000 910,229 150,000 - - 400,000 - - - - - 3,975,662 Water 1,230,000 - - - - - - - - - - - - - 580,000 - - - - - 650,000 - 1,230,000 Wastewater 7,173,908 - - - - - - - - - - - - - - - - 989,000 3,534,908 - - 2,650,000 7,173,908 Transit 5,884,039 - - 3,034,445 - - 1,004,000 1,225,000 216,476 - - - - - - - - - - 404,118 - - 5,884,039 Total CIP Expenditures 35,055,398 37,000 881,789 5,133,341 5,000,000 5,000,000 1,004,000 1,225,000 216,476 150,000 269,537 50,000 910,229 150,000 4,400,000 1,700,000 700,000 989,000 3,534,908 404,118 650,000 2,650,000 35,055,398 - - - - - - - - - - - - - - - - - - - - - - -
City of Guadalupe
Capital Improvement Projects Budget - Fiscal Year 24-25 Funding by Category and Funding Source
2024-25 Fund Allocation
Buildings
31%
Parks
17%
Streets, Sidewalks, Bicycle Facilities
11%
Water
4%
Wastewater
20%
Transit
17%
FY 2024-25 Projects By Catgegory
ATTACHMENT 3
City of Guadalupe
Capital Facilities Fund Program
of Projects Budget
Fiscal Year July 1, 2024 through June 30, 2025
Budget Capital Facilities Fund 76 - People's Self-Help Housing/Pasadera Impact FY2024-2025 Project Funds Required Reference to Budget Funded
Public Safety:

Fire Lexipol Contract $ 6,006 Equipment Capital Facilities impact Fees 4th Vehicle for PD $ 53,494 Equipment Capital Facilities impact Fees Uniforms GSST Group $ 2,000 Operating Expense Capital Facilities impact Fees $ 61,500
General Fund:

Termite repair American Legion $ 70,000 Capital Project Capital Facilities impact Fees Facilities master plan $ 90,000 Capital Project Capital Facilities impact Fees Auditorium Stage and Chambers Repairs $ 20,000 Capital Project Capital Facilities impact Fees City Hall fire suppression repair $ 10,000 Capital Project Capital Facilities impact Fees City Hall water/sewer repairs $ 30,000 Capital Project Capital Facilities impact Fees City Hall roof repairs $ 583,521 Capital Project ARPA
Senior Center mechanical repairs $ 10,000 Capital Project Capital Facilities impact Fees $ 813,521
Streets:

Pedestrian Improvements $ 179,539 Capital Project Capital Facilities impact Fees $ 179,539
$ 1,054,560
76 Fund Balance-Unreserved $ 553,691
ARPA $ 583,521
City of Guadalupe
ARPA
Fiscal Year July 1, 2024 through June 30, 2025
ATTACHMENT 4
APRA
1 2
3 4
5 8
9 12
13 16
17 21
24 26
27 28
29 30
31 32
34 35
36 37
38 40
44 45
46 47
48 49
50 51
52 53
54 55
56 57
58 A B C D E F P AH BA BB BC BD BE
ARPA Summary - Draft Capital Facilities -Fund 76
Treasury Report ACTUAL ACTUAL ACTUAL
Departments Project # Description Council Approved FY21-22 FY22-23 FY23-24 REMAINING Notes Roof Repair revenue General Fund loss of revenue $ 200,456 $ 30,000.00 - - 170,456.17 Move 73k in 2022-2023 to General Fund, move 97k to 2023-2024 GF 170,456.17 revenue-4130 Planning General Plan Environmental impact review $ 46,074 $ - 18,832.09 - 27,241.71 Roof and Wall repair - 27,241.71 revenue Cyber Sec Upgrades IT $ 75,000 $ 26,220.00 766.69 - 48,013.31 Roof and Wall repair - 48,013.31 Payroll Report Parks & Recs Rec Manager $ 168,865 $ 39,749.43 90,028.66 8,672.49 30,414.62 Roof and Wall repair - 30,414.62 01-4300-1550 Parks & Recs Recreational Programs $ 20,000 $ 876.18 3,790.98 11,218.03 4,114.81 4,114.81 01-4300-1550 Parks & Recs Tables and C Storage $ 8,900 $ - - 8,465.82 434.18 434.18 CIP-4130 (89) Planning Planning Software $ 73,000 $ - - 31,211.27 41,788.73 Use for Tyler Planning implementation 41,788.73 01-4140-2151 Admin Adobe $ 18,208 $ 10,589.21 - 4,857.84 2,760.67 2,760.67 01-4140-2151 Bldg Maint. Spanish/Mixteco Interpreting Services $ 7,500 $ - - - 7,500.00 add back per council 7/11 7,500.00 01-4140-2151 Admin Website Event Management Plugin $ 5,000 $ - - 5,575.00 (453.88) Need to pull from something else to cover (453.88) 01-4140-1550 Admin Surface Pro 7 w/Keyboard $ 19,682 $ - 2,033.18 13,353.29 (704.87) Need to pull from something else to cover (704.87) CIP (89) Bldg Maint. City hall painting $ 55,000 $ - 62,584.00 - 4,086.72 $1248.45 to cover the over spend / remaining to Roof and Wall repair 1,248.45 2,838.27 CIP (89) Bldg Maint. City hall roof repairs $ 266,000 $ - 27,325.00 14,400.00 224,275.00 Roof and Wall repair - 224,275.00 CIP (89) Parks & Recs Leroy Park Parking Lot $ 165,000 $ - - 1,150.00 163,850.00 ??? Might be Free to use depending on FEMA mitigation 94,357.00 69,493.00 CIP (89) Parks & Recs O'Connell Park gate $ 10,000 $ - - - 10,000.00 Roof and Wall repair 10,000.00 CIP (89) Parks & Recs O'connell irrigation renovation $ 54,000 $ - - 2,184.20 51,815.80 Roof and Wall repair 51,815.80 CIP 89-4444-3075 PD Generator (1)/Emergency declaration - electrical issues $ 50,000 $ - - 3,000.00 47,000.00 $47000 for Electrical/ $3000 for PD C-Train 47,000.00 01-4145-1550 Bldg Maint. PW Conference Room Upgrades $ 18,000 $ 4,331.43 11,618.92 650.10 1,399.55 Wastewater surface pro $1123.67 1,623.67 01-4120-1550 Finance Finance Office Upgrades $ - $ - 519.82 11,406.25 624.86 Floor repair/refinish in Finance Office 624.86 71-4454-2150 Streets Vegetation Maintenance $ 50,000 $ 19,124.00 17,960.00 - 12,916.00 Roof and Wall repair - 12,916.00 Payroll Report Bldg Maint. Maintenance Lead $ 85,500 $ - 7,713.63 1,273.43 76,512.94 Roof and Wall repair - 76,512.94 CIP (89) Bldg Maint. Library Relocation $ 30,000 $ - - - 30,000.00 Roof and Wall repair - 30,000.00 Admin BB1 SBCAG Broadband Contribution $ 5,223 $ 5,422.63 - - (89.70) Need to pull from something else to cover (89.70) CIP 89-4444-3075 Bldg Maint. Emergency declaration - electrical issues $ 50,000 $ 1,350.00 3,050.00 41,310.89 4,289.11 ???Might be free to use 4,289.11 $ 1,781,281 $ 341,326.75 334,200.19 159,689.90 958,245.73 374,949.20 583,520.65 Total ARPA awarded $ 1,860,000
Remaining to allocate $ 78,719 TOTAL Actual TOTAL Actual TOTAL Actual FY21-22 FY22-23 FY23-24
$ 212,623 $ 168,925 $ 71,617.74 related to General Fund $ 2,453 $ - $ - related to transit
$ 44,994 $ 34,006 $ - related to cdbg
$ 2,787 $ - $ - related to fund 60
$ 20,220 $ 85,809 $ 73,672.16 related to CIP
$ 33,250 $ - $ - related to water
$ 25,000 $ 1,940 $ - related to fund 71
$ 43,520 $ 14,400.00 related to fund 76
$ 341,327 $ 334,200 $ 159,690
$ - $ - $ -
FY24-25 Budget
958,469.85
ATTACHMENT 5
City of Guadalupe
Budget Exhibits
Fiscal Year July 1, 2024 through June 30, 2025

CITY OF GUADALUPE
3 YEAR SALES AND USE TAX BUDGET ESTIMATE
FY 2022-23 FY 2023-24 FY 2024-25 FY 2025-26
Industry Group Actuals Projection % Projection % Projection % Autos & Transportation 22,925 21,240 -7.3% 21,840 2.8% 22,640 3.7% Building & Construction 117,449 105,549 -10.1% 108,749 3.0% 113,049 4.0% Business & Industry 177,583 168,010 -5.4% 171,810 2.3% 176,410 2.7% Food & Drugs 46,095 46,675 1.3% 47,575 1.9% 48,575 2.1% Fuel & Service Stations 95,212 92,853 -2.5% 94,253 1.5% 96,153 2.0% General Consumer Goods 5,691 5,354 -5.9% 5,354 0.0% 5,454 1.9% Restaurants & Hotels 39,748 34,259 -13.8% 32,959 -3.8% 33,959 3.0% Transfers & Unidentified - N/A - - N/A - - N/A -
State & County Pools 108,377 96,760 -10.7% 101,560 5.0% 104,560 3.0% Total 613,080 570,701 -6.9% 584,101 2.3% 600,801 2.9%
Administration Cost (4,563) (4,750) (5,047) (5,191)
Total 608,517 565,952 -7.0% 579,055 2.3% 595,610 2.9%
With Accrual 608,517 565,952 -7.0% 579,055 2.3% 595,610 2.9% N2020 revenues (based on 145.0% of
1% Local Tax) 794,595 808,000 1.7% 829,000 2.6% 853,000 2.9% *Estimate is on an accrual basis (allocations for sales through June)

CONFIDENTIAL INFORMATION - DO NOT COPY OR DISTRIBUTE WITHOUT AUTHORIZATION 2/15/2024 8:58 AM HdL · 909.861.4335 · www.hdlcompanies.com Prepared: 2/15/2024 9:00:05 AM By: jdv

EXHIBIT A
$280,932,158 $304,733,077 $321,125,218 $338,190,853 $356,390,974 $238,116,918 $261,917,837 $278,309,978 $295,375,613 $313,575,734 $4,600,098 $4,646,607 $5,464,043 $5,836,325 $6,271,515
$18,085,392 $10,175,436 $11,111,256 $12,199,013 $12,950,678 $1,115,429 $1,570,097 $490,336 $164,783 $0
$261,917,837 $278,309,978 $295,375,613 $313,575,734 $332,797,926 $42,688,213 $42,688,213 $42,688,213 $42,688,213 $42,688,213 $0 $0 $0 $0 $0
$127,027 $127,027 $127,027 $127,027 $127,027
$0 $0 $0 $0 $0
$304,733,077 $321,125,218 $338,190,853 $356,390,974 $375,613,166

8.47% 5.38% 5.31% 5.38% 5.39%
$3,047,331 $3,211,252 $3,381,909 $3,563,910 $3,756,132
$427,735 $450,743 $474,697 $500,244 $527,225
$$ $$$
$0 $0 $0 $0 $0
$427,735 $450,743 $474,697 $500,244 $527,225
$412,764 $434,967 $458,083 $482,735 $508,772
$14,971 $15,776 $16,614 $17,509 $18,453
$$ $$$
Rev from Taxable Val* $427,735 $450,743 $474,697 $500,244 $527,225 $9,413 $9,413 $9,413 $9,413 $9,413
-$5,667 -$5,966 -$6,276 -$6,607 -$6,957
2022-23 2023-24 2024-25 2025-26 2026-27
$555,652,453 $564,198,068 $596,954,864 $631,681,971 $668,936,532 $518,423,502 $526,969,117 $559,725,913 $594,453,020 $631,707,581 $10,024,530 $9,685,331 $10,924,357 $11,673,004 $12,550,840 -$3,283,454 $20,374,134 $22,360,634 $24,596,090 $26,112,325 $1,804,539 $2,697,331 $1,442,116 $985,468 $304,480
$526,969,117 $559,725,913 $594,453,020 $631,707,581 $670,675,227 $25,145,540 $25,145,540 $25,145,540 $25,145,540 $25,145,540 $12,008,411 $12,008,411 $12,008,411 $12,008,411 $12,008,411 $75,000 $75,000 $75,000 $75,000 $75,000
$564,198,068 $596,954,864 $631,681,971 $668,936,532 $707,904,178

1.54% 5.81% 5.82% 5.90% 5.83%
$926,676 $940,947 $995,616 $1,053,561 $1,115,721
$14,271 $54,669 $57,945 $62,160 $65,047
VLFAA Estimate $940,947 $995,616 $1,053,561 $1,115,721 $1,180,767 NOTES:
● The revenue projection assumes 100% payment of taxes. Delinquency is not considered in the projection; however, rates of between 1% and 2.5% are typical. ● Estimated Assessor Prop 8 Adjustments: Prop 8 reductions in value are TEMPORARY reductions applied by the assessor that recognize the fact that the current market value of a property has fallen below its trended (Prop 13) assessed value. For 2022-23 and later, properties with prior Prop 8 reductions are not included in the CPI increase, they are projected flat until either the Assessor begins to recapture value as the economy improves and median sale prices begin to increase, they are further reduced, or they sell and are reset per Prop 13. ● CPI of Non Prop 8 Parcels is calculated at the following rates: 2022-23 @ 2.000%; 2023-24 @ 2.000%; 2024-25 @ 2.000%; 2025-26 @ 2.000%; 2026-27 @ 2.000%; ● Prop 8 restoration adjustments are based on projected median SFR home price growth. For this projection the following median year-to-year percentage changes are used: 2023-24: 11.4%; 2024-25: 12.1%; 2025-26: 12.7%; 2026-27: 12.7%
● Transfer of Ownership Assessed Value Change: For 2022-23, the projected increase from known 2021 transfers is used. For years 2023-24 and later a growth rate is applied that is representative of the historical average rate of real property growth due to properties that have transferred ownership. Value growth due to transfers is estimated as the following percentages of prior year real property value: 2023- 24 @ 3.8%; 2024-25 @ 4.0%; 2025-26 @ 4.1%; 2026-27 @ 4.1%; ● Base Year Values Entry: With the dissolution of redevelopment, base year values are unlikely to change and are budgeted flat. ● Secured personal property and unsecured values are projected to grow at the following rates 2022-23 @ 0.0%; 2023-24 @ 0.0%; 2024-25 @ 0.0%; 2025-26 @ 0.0%; 2026-27 @ 0.0%; . Unsecured escaped assessments may be included in the unsecured value. The value of escaped assessments is generally inconsistent and varies from year to year. ● Completed new construction entry: This data entry point allows for the inclusion of new construction projects completed annually. Due to processing delays we suggest that a time frame of November - October be selected. (e.g. Nov. 2020 - Oct. 2021 for the 2022-23 FY). If completed new construction has resulted in a sale of the property it is likely that the new value will appear in the value increase due to transfers of ownership entry and therefore should not be also included in the completed new construction value. ● Pooled Revenue Sources include supplemental allocations, redemptions for delinquent payments in Non-Teeter cities, tax payer refunds due to successful appeals, roll corrections and other adjustments applied after the release of the roll. The forecasting of these revenues should be developed based on historical averages over a minimum of 3 years. ● General Fund Revenue Estimate does not include any ad valorem voter approved debt service revenue. ● Pass through and residual revenues from former redevelopment agencies are not included in this estimate. ● SB 2557 Administration Fees are not deducted from the general fund projections. In this projection, SB2557 Administration fees are estimated by considering the jurisdiction's most recently reported fee amount as a percentage of its general fund revenue in that year, and applying that percentage to the updated revenue.

Prepared on 5/4/22 Using Sales Through 12/31/21
This report is not to be used in support of debt issuance or continuing disclosure statements without the written consent of HdL Coren & Cone Nonunitary Utility Value (0.0% growth)
Enter Completed New Construction
Estimated Net Taxable Value
Estimated Total Percent Change
Base Value of VLFAA
Estimated Change to VLFAA
Unsecured Personal Property Value (see notes)
Admin Fee (Not Deducted Above)
Enter Suppl. Apportionment - Avg 3 Yrs
Enter Delinquent Apportionment - Avg 3 Yrs
VLFAA
Citywide Net Taxable Value
Real Property Value (Incl. Prop 8 parcels)
CPI of Non Prop 8 Parcels (2022-23 @ 2.000%)
Transfer of Ownership Assessed Val Change
Est. SFR Prop 8 Adj Based on Recent SFR Price
Estimated Real Property Value
Secured Personal Property Value (see notes)
Unitary Revenue (Budgeted Flat)
Estimated Total Percent Change
Revenue Calculations
Net Taxable Value Tax @ 1%
City Share of 1% Tax @ 14.03637362%
Aircraft Value Tax @ 1%
City Share of Aircraft Tax @ 33.3%
Net GF Estimate
Taxable Value Revenue Categories
Secured Revenue
Unsecured Revenue
Aircraft Revenue
Estimated Net Taxable Value
General Fund and BY Values
Real Property Value (Incl. Prop 8 parcels)
CPI of Non Prop 8 Parcels (2022-23 @ 2.000%)
Transfer of Ownership Assessed Value Change
Est. SFR Prop 8 Adj Based on Recent Price
Estimated Real Property Value
Base Year Values
Secured Personal Property Value (see notes)
Unsecured Personal Property Value (see notes)
Nonunitary Utility Value (0.0% growth)
Enter Completed New Construction

THE CITY OF GUADALUPE
GENERAL FUND REVENUE ESTIMATE - DEFAULT SCENARIO 2022
2022-23 Through 2026-27 Revenue Estimate Based on 2021-22 Values and Estimated Changes General Fund 2022-23 2023-24 2024-25 2025-26 2026-27

EXHIBIT B
City of Guadalupe
California JPIA Contribution Summary
Report Date: 4/2/2024
~ Estimate ~
Liability
Annual Contribution $ 268,697 $ 335,871 $ 67,174 25.0%
Retrospective Adjustment (1,701) 97 1,798 105.7%
Payment Plan Principal - - -
Payment Plan Fee - - -
Claims Administration - - -
Excess Pool Distribution* - - -
Subtotal 266,996 335,968 68,972 25.8%
Workers' Compensation
Annual Contribution 344,195 354,437 10,242 3.0%
Retrospective Adjustment (3,470) 5,648 9,118 262.8%
Payment Plan Principal - - -
Payment Plan Fee - - -
Tail Claims Administration - - -
Subtotal 340,725 360,085 19,360 5.7%
Property
All-Risk 41,756 44,338 2,582 6.2%
Earthquake - - -
Other Vehicles 5,355 4,341 (1,014) -18.9%
Emergency Vehicles 1,255 1,038 (217) -17.3%
Mechanical Breakdown 1,435 1,506 72 5.0%
Admin and Appraisal Fee 2,679 2,997 318 11.9%
Mid Year TIV Changes 94 - (94) -100.0%
Subtotal 52,573 54,220 1,647 3.1%
Miscellaneous
Crime (premium paid to Alliant) 1,213 1,274 61 5.0%
Pollution Legal Liability - - -
Underground Storage Tanks - - -
Subtotal 1,213 1,274 61 5.0%
Grand Total $ 661,507 $ 751,547 $ 90,040 13.6%
* The Excess Pool Distribution is a return of contributions to members of the Primary Liability Program who participated between 1986 and 1997.

Distributions commenced in 2021-22 and will be paid out over 5 years. 2023-24 2024-25 Change %

EXHIBIT C
Department Salaries % #Employees
Admin 766,742.91 12.5% 4
Finance 544,340.07 8.9% 6
Bld & Maint 46,572.18 0.8% 3
Police 2,855,578.44 46.6% 16
Fire 1,270,715.49 20.7% 7
Parks & Rec 378,765.71 6.2% 6
Bldg & Safety 269,129.57 4.4% 2
6,131,844.38
Water 792,016.38 10
Wastewater 564,141.68 8
1,356,158.06
Fund 79-Royal Theater 4,186.59 0.1% 1
Fund 71-Measure A 204,647.05 3.3% 4
Fund 23 - Transit 36,990.51 0.6% 3
Fund 60-Guad.Assess. Dist 9,491.95 0.2% 2
Fund 63-Pasa. L&L Dist 157,541.97 2.6% 4
412,858.08
Admin, 12.5%
Finance, 8.9%
Bld & Maint, 0.8%
Police, 46.6%
Fire, 20.7%
Parks & Rec, 6.2%
Bldg & Safety, 4.4%
Salaries

EXHIBIT D
Admin Dept
Base 330.70 609.77
Current Next Hrly rate remaining Regular Total Total
ID Employee Position Union Step Increase at 7/1 total Hrs Cost OT Bilgl Def Comp Other Gross PR Taxes PERS Medical Dental Vision Life Total Benefits Costs BOD01 BODEM, TODD City Administrator N/A Contract N/A 83.238 2080 173,134.21 - - - 1,950.00 175,084.21 13,393.94 15,379.17 20,528.79 2,076.07 224.22 304.59 51,906.79 226,991.00 MER01 ESCOBAR, JUANA Administrative Assistant SEIU 205/L1 4/1/2026 47.138 2080 98,046.31 2,000.00 3,250.00 9,100.00 - 112,396.31 8,598.32 15,854.04 - 2,076.07 224.22 155.01 26,907.67 139,303.98 EST10 ESTRADA, SYLVIA Human Resources Manager N/A 3/18/2025 50.129 2080 104,267.80 - - - - 104,267.80 7,976.49 84,060.50 17,375.36 1,288.14 137.28 - 110,837.77 215,105.57 Paid for by Grants OPEN Grant Administrator N/A 40.206 2080 83,628.48 - - - - 83,628.48 6,397.58 8,181.60 17,375.36 2,076.07 224.22 155.01 34,409.85 118,038.33 459,076.80 2,000.00 3,250.00 9,100.00 1,950.00 475,376.80 36,366.33 123,475.31 55,279.51 7,516.37 809.95 614.61 224,062.07 699,438.87 Estimated Costs Unfunded Liab Total
Reg 001-4105-0100 462,326.80 462,326.80
Part Time 001-4105-0125 - -
temp 001-4105-0150 - -
OT 001-4105-0200 2,000.00 2,000.00
Retirement 001-4105-0250 123,475.31 42,014.76 165,490.06 Taxes 001-4105-0300 36,366.33 36,366.33
workers comp 001-4105-0350 25,289.28 25,289.28
Insurance 001-4105-0400 55,279.51 55,279.51
Other Benefits 001-4105-0450 1,950.00 1,950.00
Deferred Comp 001-4150-0545 9,100.00 9,100.00
Dental 001-4105-0560 7,516.37 7,516.37
Vision 001-4105-0570 809.95 809.95
Life 001-4105-0585 614.61 614.61
724,728.15 766,742.91
Employer Paid Benefits
2 Finance Dept
Base
Current Next Hrly rate remaining Regular Total Total
ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl Def Comp Gross Payroll Taxes PERS Medical Dental Vision Life Total Benefits Costs DAV02 DAVIS, JANICE Finance Director N/A FD/C 1/24/2025 56.717 2080 117,971.36 - - - 117,971.36 9,024.81 10,884.39 20,528.79 2,076.07 224.22 127.56 42,865.84 160,837.20 PER01 PEREYRA-LEON, ANGELITA Accounting Supervisor SEIU 215/L1 11/9/2026 51.051 2080 106,186.08 200.00 3,250.00 - 109,636.08 8,387.16 15,729.14 20,528.79 2,076.07 224.22 155.01 47,100.40 156,736.48 RIV01 RIVAS, ISAIAS Accounting Clerk SEIU 181/L1 1/21/2026 38.220 2080 79,497.60 200.00 3,250.00 - 82,947.60 6,345.49 8,128.02 20,528.79 2,076.07 224.22 155.01 37,457.61 120,405.21 FAB01 FABIAN, VERONICA Accounting Clerk SEIU 181/B 1/6/2025 35.486 2080 73,810.36 - 3,250.00 - 77,060.36 5,895.12 11,540.50 12,155.00 670.10 85.23 135.85 30,481.79 107,542.15 FIG01 FIGUEROA, MAYRA Accounting Clerk SEIU 153/A 9/20/2024 24.643 2080 51,256.92 700.00 3,250.00 657.28 55,864.20 4,273.61 5,996.55 12,155.00 2,076.07 85.23 135.85 24,722.32 80,586.52 Unfilled Unfilled Accounting Clerk SEIU 153/A 22.663 2080 47,139.46 3,250.00 50,389.46 3,854.79 5,565.69 12,155.00 2,076.07 85.23 135.85 23,872.64 74,262.09 475,861.78 1,100.00 16,250.00 657.28 493,869.06 37,780.98 57,844.28 98,051.38 11,050.47 928.36 845.13 206,500.60 700,369.65 Estimated Costs Unfunded Liab Total
Reg 001-4120-0100 319,175.47 319,175.47
Reg (Royal Theater) 079-4542-0100 2,949.28 2,949.28
Reg (Water) 10-4420-0100 169,987.02 169,987.02
temp 001-4120-0150 - -
OT 001-4120-0200 1,100.00 1,100.00
Retirement 001-4120-0250 39,679.23 78,523.64 118,202.86 079-4542-0250 272.11 4.34 276.45
10-4420-0250 17,892.94 250.05 18,142.99
Taxes 001-4120-0300 24,439.71 24,439.71
079-4542-0300 225.62 225.62
10-4420-0300 13,115.65 13,115.65
workers comp 001-4120-0350 17,458.90 17,458.90
079-4542-0350 161.33 161.33
10-4420-0350 9,298.29 9,298.29
Insurance 001-4120-0400 56,994.19 56,994.19
079-4542-0400 513.22 513.22
10-4420-0400 40,543.97 40,543.97
def comp 001-4120-0545 657.28 657.28
Dental 001-4120-0560 5,289.36 5,289.36
079-4542-0560 51.90 51.90
10-4420-0560 5,709.20 5,709.20
Vision 001-4120-0570 570.23 570.23
079-4542-0570 5.61 5.61
10-4420-0570 352.52 352.52
Life 001-4120-0585 452.07 452.07
079-4542-0585 3.19 3.19
10-4420-0585 389.88 389.88
727,288.17 806,066.19
Employer
2 Building Maint Dept
Base
Current Next Hrly rate remaining Regular Total Total
ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl Uniform Def Comp Gross Payroll Taxes PERS Medical Dental Vision Life Total Benefits Costs SCH03 SCHUBERT, EDWARD Lead Maint-Parks Facilities SEIU 188/A 5/9/2024 30.697 2080 63,850.45 300.00 64,150.45 4,907.51 6,648.68 13,260.00 670.10 85.23 135.85 25,707.37 89,857.82 RAM10 RAMIREZ, JUAN Maintenance Worker 1 SEIU 151/C 4/3/2025 22.566 2080 46,938.11 - - 300.00 53.04 47,291.15 3,617.77 5,321.85 13,260.00 670.10 85.23 135.85 23,090.80 70,381.95 OPEN UNFILLED Maintenance Worker 1 SEIU 151/C 22.608 2080 47,024.29 - - 300.00 - 47,324.29 3,620.31 5,324.46 13,260.00 670.10 85.23 135.85 23,095.95 70,420.23 110,788.57 - - 600.00 53.04 111,441.61 8,525.28 11,970.53 26,520.00 1,340.20 170.46 271.70 48,798.17 160,239.77 Estimated Costs Unfunded Liab Total
Reg (GF Building Maint) 01-4145-0100 31,925.23 31,925.23 Reg (GF Parks & Rec) 01-4300-0100 110,788.57 110,788.57 Reg (Pasa. L&L Dist.) 63-4472-0100 46,981.20 46,981.20
Retirement 01-4145-0250 3,324.34 46.96 3,371.30
Retirement 01-4300-0250 5,985.27 116.07 6,101.34
Retirement 63-4472-0250 5,323.16 69.11 5,392.27
Taxes 01-4145-0300 2,453.75 2,453.75
Taxes 01-4300-0300 4,262.64 4,262.64
Taxes 63-4472-0300 3,619.04 3,619.04
Workers Comp 01-4145-0350 1,746.31 1,746.31
Workers Comp 01-4300-0350 6,060.13 6,060.13
Workers Comp 63-4472-0350 2,569.87 2,569.87
Insurance 01-4145-0400 6,630.00 6,630.00
Insurance 01-4300-0400 13,260.00 13,260.00
Insurance 63-4472-0400 13,260.00 13,260.00
Def Comp 01-4145-0545 - -
Def Comp 01-4300-0545 26.52 26.52
Def Comp 63-4472-0545 26.52 26.52
Dental 01-4145-0560 335.05 335.05
Dental 01-4300-0560 670.10 670.10
Dental 63-4472-0560 670.10 670.10
Vision 01-4145-0570 42.61 42.61
Vision 01-4300-0570 85.23 85.23
Vision 63-4472-0570 85.23 85.23
Life 01-4145-0585 67.93 67.93
Life 01-4300-0585 135.85 135.85
Life 63-4472-0585 135.85 135.85
260,470.49 260,702.63
Employer
3 Police Dept
Base 0100 0100 0545 0450 0100 0100
Current Next Hrly rate remaining Regular Total Total
ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl Def Comp Uniform Holiday POST/EDU Gross Payroll Taxes PERS Medical Dental Vision Life Total Benefits Costs CA01 CASH, MICHAEL Public Safety Director N/A Contract 59.753 2080 124,285.57 - - - 2,136.00 - - 126,421.57 7,253.44 10,346.25 13,031.52 963.75 102.10 228.23 31,925.29 158,346.86 BRI01 BRIBIESCA, NORMA Police Office Manager POA 171/F MAX 39.160 2080 81,452.28 - 3,250.00 14,083.16 1,398.00 - 8,959.75 109,143.19 8,349.45 8,971.24 - 2,076.07 224.22 154.73 19,775.72 128,918.91 MEN01 MENDOSA, JOANA Records Technician POA 159/F MAX 43.019 2080 89,478.48 - 3,250.00 - 1,398.00 - - 94,126.48 7,200.68 8,894.13 15,491.76 2,076.07 224.22 154.73 34,041.59 128,168.07 MER02 MERAZ, JOSUE Code Compliance Officer SEIU 188/C 4/1/2025 35.396 2080 73,622.64 - 3,250.00 - 423.00 - - 77,295.64 5,913.12 11,522.97 20,528.79 2,076.07 224.22 155.01 40,420.19 117,715.83 LIM02 LIMON, CARLOS Police Lieutenant unrep Lieutenant/E 10/30/2024 74.263 2080 154,466.00 - - - 1,398.00 10,677.46 13,211.48 179,752.94 13,751.10 31,870.38 19,147.70 2,076.07 224.22 260.83 67,330.31 247,083.25 MED01 MEDINA, FRANK Police Sergeant POA 202/E (sgt) 1/20/2025 58.437 2080 121,548.96 48,619.58 3,250.00 - 1,398.00 8,402.07 10,396.08 193,614.70 14,811.52 25,932.48 15,491.76 1,288.14 85.23 135.85 57,744.99 251,359.69 Open Unfilled Police Officer POA 182/A 4/22/2024 33.732 2080 70,163.18 28,065.27 - - 1,398.00 4,850.03 - 104,476.49 7,992.45 9,889.00 11,431.99 670.10 85.23 155.01 30,223.78 134,700.27 ORO01 OROZCO, CHRISTOPHER Police Officer POA 182/C 8/26/2024 46.003 2080 95,685.89 38,274.36 3,250.00 14,083.16 1,398.00 6,614.29 - 159,305.70 12,186.89 13,263.33 - 587.73 85.23 135.85 26,259.03 185,564.73 CAS03 CASTELLANOS, LUIS Police Officer POA 182/A 1/8/2025 43.968 2080 91,452.40 36,580.96 - - 1,398.00 6,321.65 6,844.18 142,597.19 10,908.69 13,249.27 15,491.76 1,288.14 137.28 155.01 41,230.16 183,827.35 RUI01 RUIZ, OMAR Police Officer POA 182/D 3/4/2025 47.016 2080 97,792.50 39,117.00 3,250.00 3,690.70 1,398.00 6,759.91 - 152,008.11 11,628.62 13,512.21 11,431.99 670.10 85.23 135.85 37,463.99 189,472.10 WEL0001 WELKOM, LIA Police Officer POA 182/A 1/22/2025 41.087 2080 85,459.92 34,183.97 - 3,690.44 1,398.00 5,907.42 - 130,639.74 9,993.94 11,696.13 11,431.99 670.10 85.23 155.01 34,032.40 164,672.15 JAI01 JAIMES, MIGUEL Police Officer-LOA POA 182/A On W/C 38.220 2080 79,497.60 31,799.04 3,250.00 - 1,398.00 5,655.55 2,554.59 124,154.78 - 11,650.87 15,491.76 2,076.07 85.23 154.73 29,458.66 153,613.45 NEG01 NEGRANTI, MARIA Police Officer-LOA POA 182/D On W/C 44.247 2080 92,033.76 36,813.50 3,250.00 - 1,398.00 6,361.83 - 139,857.10 - 12,831.88 15,491.76 2,076.07 136.14 155.01 30,690.86 170,547.96 KUH01 KUHBANDER, MICHAEL Police Officer-Airport POA 182/F MAX 48.783 2080 101,468.64 - - - 1,398.00 7,014.02 17,115.16 126,995.82 9,715.18 15,478.60 15,491.76 1,288.14 136.14 135.85 42,245.67 169,241.49 WRI01 WRIGHT, ROBERT Police Officer-Airport POA 182/F MAX 48.783 2080 101,468.64 - - - 1,398.00 7,014.02 13,017.92 122,898.58 9,401.74 15,025.85 15,491.76 2,076.07 224.22 155.01 42,374.67 165,273.25 POA eliminated position +$5 Police Officer POA 182/A - - - - - - - - - - TES01 TESORO, ROSANNE Temporary Clerk temp 20.175 520 10,491.00 - - - - - 10,491.00 802.56 802.56 11,293.56 temp - - - - - - - - - - -
1,470,367.47 293,453.69 26,000.00 35,547.46 20,733.00 75,578.25 72,099.17 1,993,779.03 129,909.37 214,134.61 195,446.32 21,958.72 2,144.14 2,426.71 566,019.88 2,559,798.91 Estimated Costs Unfunded Liab Total
Reg 01-4200-0100 1,633,553.88 1,633,553.88
Part time 01-4200-0125 - -
Temp 01-4200-0150 10,491.00 10,491.00
Overtime 01-4200-0200 293,453.69 293,453.69
Retirement 01-4200-0250 214,134.61 102,040.04 316,174.65 Taxes 01-4200-0300 129,909.37 129,909.37
Workers Com01-4200-0350 193,739.49 193,739.49
Insurance 01-4200-0400 195,446.32 195,446.32
Benefits 01-4200-0450 20,733.00 20,733.00
Def Comp 01-4200-0545 35,547.46 35,547.46
Dental 01-4200-0560 21,958.72 21,958.72
Vision 01-4200-0570 2,144.14 2,144.14
Life 001-4200-0585 2,426.71 2,426.71
Total 2,753,538.40 2,855,578.44
Employer
4 Fire Dept
Base 0100 0100 0545 0450 0100 0100
Current Next Hrly rate remaining Regular Total Total
ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl Def Comp Uniform Holiday Incentives Gross Payroll Taxes PERS med Den Vis Life Total Benefits Costs CAS01 CASH, MICHAEL Public Safety Director N/A N/A 18.618 2080 38,724.52 - - - 712.00 - - 39,436.52 620.77 1,469.19 4,343.84 321.25 34.03 76.08 6,865.16 46,301.69 GAR03 GARCIA, FERNANDO Fire Captain IAFF 184/L2 MAX 37.313 2756 102,834.90 41,133.96 3,250.00 - 1,495.00 8,149.18 5,927.57 162,790.62 12,453.48 22,003.47 20,528.79 2,076.07 224.22 154.73 57,440.77 220,231.39 BON01 BONIFACIO, DAVID Fire Engineer IAFF 171/B 1/18/2025 26.269 2756 72,396.68 28,958.67 3,250.00 272.22 1,495.00 5,737.10 112,109.66 8,576.39 10,592.95 12,729.29 670.10 85.23 135.85 32,789.80 144,899.46 unfilled unfilled Fire Engineer IAFF 171/A 24.465 2756 67,426.71 26,970.68 3,250.00 - 1,495.00 5,343.25 4,334.20 108,819.84 7,033.00 10,479.17 21,641.88 1,820.96 224.22 154.73 41,353.97 150,173.81 NUN01 NUNO, JACOB Fire Captain IAFF 184/C 8/22/2024 31.748 2756 87,496.45 34,998.58 3,250.00 - 1,495.00 6,933.68 5,237.34 139,411.06 10,664.95 12,972.42 13,885.25 670.10 85.23 135.85 38,413.79 177,824.85 REY04 REYES, GUADALUPE Fire Engineer IAFF 171/D 9/5/2024 30.747 2756 84,737.70 33,895.08 3,250.00 - 1,495.00 6,715.06 7,202.70 137,295.55 10,503.11 11,260.55 13,886.50 - - 135.85 35,786.01 173,081.55 SCH02 SCHMITZ, PATRICK Fire Captain IAFF 184/L2 MAX 37.313 2756 102,834.90 41,133.96 3,250.00 272.22 1,495.00 8,149.18 12,340.19 169,475.45 12,964.87 23,031.34 12,729.29 670.10 85.23 135.85 49,616.68 219,092.13 PCF's part time 25,000.00 25,000.00 1,912.50 0 0 0 0 1,912.50 26,912.50 what are PCF? temp - - - - - - - - - 0 0 0 0 - -
581,451.87 207,090.94 19,500.00 544.44 9,682.00 41,027.45 35,042.01 894,338.70 64,729.07 91,809.10 99,744.83 6,228.58 738.17 928.93 264,178.68 1,158,517.38 unfilled unfilled Fire Fighter IAFF 163/A 22.593 2756 62,266.03 24,906.41 3,250.00 - 1,495.00 4,934.29 4,101.97 100,953.71 6,431.24 9,838.07 21,641.88 1,820.96 224.22 154.73 40,111.10 141,064.81 unfilled unfilled Fire Fighter IAFF 163/A 22.593 2756 62,266.03 24,906.41 3,250.00 - 1,495.00 4,934.29 4,101.97 100,953.71 6,431.24 9,838.07 21,641.88 1,820.96 224.22 154.73 40,111.10 141,064.81 unfilled unfilled Fire Fighter IAFF 163/A 22.593 2756 62,266.03 24,906.41 3,250.00 - 1,495.00 4,934.29 4,101.97 100,953.71 6,431.24 9,838.07 21,641.88 1,820.96 224.22 154.73 40,111.10 141,064.81 186,798.10 74,719.24 9,750.00 - 4,485.00 14,802.87 12,305.91 302,861.12 19,293.73 29,514.21 64,925.64 5,462.89 672.67 464.18 120,333.31 423,194.43 768,249.97 281,810.18 29,250.00 544.44 14,167.00 55,830.32 47,347.92 1,197,199.82 84,022.80 121,323.30 164,670.47 11,691.47 1,410.84 1,393.11 384,511.98 1,581,711.81 Estimated Costs Unfunded Liab Total
Reg 01-4220-0100 622,977.93 622,977.93 27.91 184/C
part time 01-4220-0125 25,000.00 25,000.00
temp 01-4220-0150 - -
overtime 01-4220-0200 207,090.94 207,090.94
Retirement 01-4220-0250 90,707.20 73,160.14 163,867.34
Taxes 01-4220-0300 64,263.49 64,263.49
workers comp01-4220-0350 73,885.18 73,885.18
Insurance 01-4220-0400 96,486.95 96,486.95
Benefits 01-4220-0450 8,970.00 8,970.00
Def Comp 01-4220-0545 544.44 544.44
Dental 01-4220-0560 5,987.64 5,987.64
Vision 01-4220-0570 712.64 712.64
Life 001-4220-0570 928.93 928.93
Total 1,197,555.35 1,270,715.49
Employer
5 Parks & Rec
Base 0125 0100 0545
Current Next Hrly rate Remaining Regular Total Total
ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl Def Comp Gross Payroll Taxes PERS med Den Vis Life Total Benefits Costs FUE01 BARAJAS, ANNIS Rec Services Manager unrep P&R/B 3/10/2025 40.396 2080 84,024.20 3,250.00 425.00 87,699.20 6,708.99 8,876.11 - - - 121.55 15,706.65 103,405.85 BRI02 BRITT, ESTHER Facilities Coordinator SEIU part time 151/B 9/27/2024 12.540 936 11,737.32 - 11,737.32 897.91 897.91 12,635.23 SAL01 SALINAS, ROBERT Building Attendant 18.060 416 7,512.96 7,512.96 574.74 574.74 8,087.70 Open Senior Community Center Activity Coordinator 27.820 2080 57,865.60 57,865.60 4,426.72 6,154.06 12,155.00 2,076.07 85.23 135.85 25,032.93 82,898.53 Open Building Attendant 17.197 416 7,153.95 7,153.95 547.28 547.28 7,701.23 Park & Rec Commissioner (5) 500.000 6,000.00 6,000.00
- -
174,294.04 - 3,250.00 425.00 177,969.04 13,155.63 15,030.17 12,155.00 2,076.07 85.23 257.40 42,759.50 214,728.54 Estimated Costs Unfunded Liab Total
Reg 01-4300-0100 198,062.77 198,062.77
Reg (CV2-3) 107-4018-2166 57,865.60 57,865.60
Part 01-4300-0125 32,404.24 32,404.24
TEMP 01-4300-0150 - -
Overtime 01-4300-0200 - -
Retirement 01-4300-0250 14,861.37 329.57 15,190.94
Retirement 107-4018-2166 6,154.06 6,154.06
Taxes 01-4300-0300 12,991.55 12,991.55
Taxes 107-4018-2166 4,426.72 4,426.72
workerscomp 01-4300-0350 16,894.17 16,894.17
workerscomp 107-4018-2166 5,735.12 5,735.12
Insurance 01-4300-0400 13,260.00 13,260.00
Insurance 107-4018-2166 12,155.00 12,155.00
Def Comp 01-4300-0545 451.52 451.52
Dental 01-4300-0560 670.10 670.10
Dental 107-4018-2166 2,076.07 2,076.07
Vision 01-4300-0570 85.23 85.23
Vision 107-4018-2166 85.23 85.23
Life 001-4300-0585 257.40 257.40
Life 107-4018-2166 135.85 135.85
Total 378,436.15 378,765.71
Employer
6 Permit Dept
Base 0100 0100 0545
Current Next Hrly rate Annual Regular Total Total
ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl Def Comp Gross Payroll Taxes PERS Medical Dental Vision Life Total Benefits Costs SAU01 SAUCEDO, ALICE RUTH Permit Technician SEIU 184/L2 MAX 39.375 2080 81,900.00 - - 81,900.00 6,265.35 12,171.64 12,155.00 670.10 85.23 135.85 31,483.17 113,383.17 unfilled unfilled Associate Planner N/A 218/C N/A 40.012 2080 83,224.96 83,224.96 6,366.71 8,149.84 12,155.00 2,076.07 85.23 135.85 28,968.71 112,193.67 165,124.96 - - - 165,124.96 12,632.06 20,321.48 24,310.00 2,746.17 170.46 271.70 60,451.87 225,576.83 Estimated Costs Unfunded Liab Total
Reg 01-4405-0100 165,124.96 165,124.96
Retirement 01-4405-0250 20,321.48 34,520.41 54,841.89
Taxes 01-4405-0300 12,632.06 12,632.06
workers comp 01-4405-0350 9,032.34 9,032.34
Insurance 01-4405-0400 24,310.00 24,310.00
Benefits 01-4405-0450 - -
Def Comp 01-4405-0545 - -
Dental 01-4405-0560 2,746.17 2,746.17
Vision 01-4405-0570 170.46 170.46
Life 001-4405-0585 271.70 271.70
Total 234,609.17 269,129.57
Employer
7 Building Maint Dept
Base
Current Next Hrly rate remaining Regular Total Total
ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl Uniform Def Comp Gross Payroll Taxes PERS Medical Dental Vision Life Total Benefits Costs Open Public Works Director N/A N/A 62.500 2080 130,000.00 - - - 130,000.00 9,945.00 11,831.04 21,641.88 1,820.96 224.22 304.59 45,767.70 175,767.70 CRU01 CRUZ, DAYANIRA Engineering Technician SEIU 191/B 3/8/2025 38.494 2080 80,068.30 - - 53.04 80,121.34 6,129.28 7,905.59 13,260.00 670.10 85.23 135.85 28,186.05 108,307.39 GUT01 GUTIERREZ, RUDY Maintenance Worker Leader SEIU 188/B 8/1/2024 35.176 2080 73,166.60 - - 300.00 - 73,466.60 5,620.19 7,358.25 13,260.00 2,076.07 224.22 138.42 28,677.17 102,143.77 BAT01 ESPARZA, JUAN Maintenance Worker SEIU 151/B 5/1/2025 22.296 2080 46,374.90 - - 300.00 - 46,674.90 3,570.63 5,249.74 20,888.40 1,288.14 136.14 135.85 31,268.90 77,943.80 329,609.80 - - 600.00 53.04 330,262.84 25,265.11 32,344.63 69,050.28 5,855.28 669.81 714.71 133,899.82 464,162.66 Estimated Costs Unfunded Liab Total
Reg (Measure A) 71-4454-0100 137,797.35 137,797.35
Reg (Water) 10-4420-0100 77,718.59 77,718.59
Reg (WasteWater) 12-4425-0100 77,718.59 77,718.59
Reg (Trasit) 23-4461-0100 25,014.15 25,014.15
Reg (Guad. Assess. Dist.) 60-4490-0100 6,007.08 6,007.08 Reg (Pasa. L&L Dist.) 63-4472-0100 52,988.27 52,988.27
Retirement 71-4454-0250 13,749.04 202.14 13,951.18
Retirement 10-4420-0250 7,445.04 114.21 7,559.25
Retirement 12-4425-0250 7,445.04 114.21 7,559.25
Retirement 23-4461-0250 2,443.90 36.71 2,480.61
Retirement 60-4490-0250 630.40 8.79 639.19
Retirement 63-4472-0250 5,953.56 77.90 6,031.46
Taxes 71-4454-0300 10,540.88 10,540.88
Taxes 10-4420-0300 5,945.47 5,945.47
Taxes 12-4425-0300 5,945.47 5,945.47
Taxes 23-4461-0300 1,913.58 1,913.58
Taxes 60-4490-0300 459.54 459.54
Taxes 63-4472-0300 4,078.58 4,078.58
Workers Comp 71-4454-0350 7,537.52 7,537.52
Workers Comp 10-4420-0350 4,251.21 4,251.21
Workers Comp 12-4425-0350 4,251.21 4,251.21
Workers Comp 23-4461-0350 1,368.27 1,368.27
Workers Comp 60-4490-0350 328.59 328.59
Workers Comp 63-4472-0350 5,468.33 5,468.33
Insurance 71-4454-0400 31,401.16 31,401.16
Insurance 10-4420-0400 14,326.96 14,326.96
Insurance 12-4425-0400 14,326.96 14,326.96
Insurance 23-4461-0400 5,579.03 5,579.03
Insurance 60-4490-0400 1,707.42 1,707.42
Insurance 63-4472-0400 14,967.42 14,967.42
Def Comp 71-4454-0545 17.68 17.68
Def Comp 10-4420-0545 17.68 17.68
Def Comp 12-4425-0545 17.68 17.68
Def Comp 23-4461-0545 - -
Def Comp 60-4490-0545 - -
Def Comp 63-4472-0545 26.52 26.52
Dental 71-4454-0560 2,788.16 2,788.16
Dental 10-4420-0560 1,106.05 1,106.05
Dental 12-4425-0560 1,106.05 1,106.05
Dental 23-4461-0560 518.52 518.52
Dental 60-4490-0560 168.21 168.21
Dental 63-4472-0560 838.31 838.31
Vision 71-4454-0570 311.89 311.89
Vision 10-4420-0570 131.71 131.71
Vision 12-4425-0570 131.71 131.71
Vision 23-4461-0570 58.46 58.46
Vision 60-4490-0570 168.21 168.21
Vision 63-4472-0570 253.44 253.44
Life 71-4454-0585 301.22 301.22
Life 10-4420-0585 164.08 164.08
Life 12-4425-0585 164.08 164.08
Life 23-4461-0585 57.89 57.89
Life 60-4490-0585 13.71 13.71
Life 63-4472-0585 149.56 149.56
557,819.47 558,373.43
Employer
3 Water Dept
Base
Current Next Hrly rate Annual Regular pager Total Total ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl Uniform other ben Gross Payroll Taxes PERS Medical Dental Vision Life Total Benefits Costs VID01 VIDALES, JAIME Water Dept Supervisor SEIU 205A/L1 4/8/2024 45.151 2080 93,913.43 12,900.00 3,250.00 300.00 110,363.43 7,975.59 13,644.88 6,585.38 1,820.96 224.22 155.01 30,406.05 140,769.47 SAG01 SAGISI, JOSE Water Maintenance Operator SEIU 162A/E 10/28/2023 28.774 2080 59,850.44 7,420.00 - 300.00 6,000.00 73,570.44 5,160.92 7,095.75 21,641.88 1,820.96 224.22 155.01 36,098.75 109,669.20 Open Water Maintenance Operator SEIU 153/A 27.846 2080 57,919.78 7,420.00 - 300.00 6,000.00 71,639.78 5,013.23 6,951.53 21,641.88 1,820.96 224.22 155.01 35,806.84 107,446.62 211,683.65 27,740.00 3,250.00 900.00 12,000.00 255,573.65 18,149.74 27,692.16 49,869.14 5,462.89 672.67 465.04 102,311.64 357,885.29 Estimated Costs Unfunded Liab Total
Reg 10-4420-0100 462,639.26 462,639.26 4005.53
temp 10-4420-0150 - 3,770.63
OT 10-4420-0200 27,740.00 27,740.00 234.90
Retirement 10-4420-0250 53,030.15 41,346.11 94,376.27
Taxes 10-4420-0300 37,210.86 37,210.86
workers com 10-4420-0350 38,855.86 38,855.86
Insurance 10-4420-0400 104,740.08 104,740.08
other ben 10-4420-0450 12,000.00 12,000.00
Dental 10-4420-0560 12,278.14 12,278.14
Vision 10-4420-0570 1,156.91 1,156.91
Life 10-4420-0585 1,018.99 1,018.99
750,670.26 792,016.38
Employer
8 Wastewater Dept
Base
Current Next Hrly rate Annual Regular pager Total Total Salary for ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl Uniform def comp other ben Gross Payroll Taxes PERS Medical Den Vis Life Total Benefits Costs Unfunded Liabil MIK01 MIKLAS, DAVID WWTP Supervisor SEIU 205A/C 7/27/2023 43.113 2080 89,675.04 16,500.00 - 300.00 - 6,000.00 112,475.04 8,145.34 8,681.08 22,395.05 2,076.07 224.22 155.01 41,676.77 154,151.81 89,675.04 VAL01 VALDIVIA, DEVIN WWTP Operator II SEIU 188/C 9/7/2023 32.799 2080 68,222.05 9,400.00 - 300.00 - 6,000.00 83,922.05 5,961.04 6,992.73 10,856.35 587.73 85.23 135.85 24,618.92 108,540.97 68,222.05 COS0001 COSTA, JOHN WWTP Operator I SEIU 1/16/2024 23.188 2080 48,230.52 9,400.00 - 300.00 - 6,000.00 63,930.52 4,431.68 5,419.39 12,729.29 670.10 85.23 135.85 23,471.54 87,402.06 48,230.52 RAM0001 RAMOS, DANIEL WWTP Operator I SEIU 1/16/2024 22.217 2080 46,211.57 9,400.00 - 300.00 - 6,000.00 61,911.57 4,277.23 5,260.50 13,260.00 670.10 85.23 135.85 23,688.91 85,600.48 46,211.57 252,339.18 44,700.00 - 1,200.00 - 24,000.00 322,239.18 22,815.30 26,353.69 59,240.69 4,004.00 479.91 562.56 113,456.15 435,695.33 remaining costs unfunded liab Total
Reg 12-4425-0100 330,057.77 330,057.77 1535.12
OT 12-4425-0200 44,700.00 44,700.00 1,529.32
Retirement 12-4425-0250 33,798.74 485.39 34,284.13 5.80 Taxes 12-4425-0300 28,760.77 28,760.77
workerscomp 12-4425-0350 22,305.37 22,305.37
Insurance 12-4425-0400 73,567.65 73,567.65
other ben 12-4425-0450 24,000.00 24,000.00
def comp 12-4425-0545 17.68 17.68
Dental 12-4425-0560 5,110.05 5,110.05
Vision 12-4425-0570 611.62 611.62
Life 12-4425-0585 726.65 726.65
563,656.29 564,141.68
Employer
9 Home ›  Employers ›  Employer Contributions ›  Public Agency Employer Contribution Rate Public Agency Required Employer Contributions
Employer contributions are determined by annual actuarial valuations. These valuations are based on the benefit formulas the agency provides and the employee groups covered.

Find your agency's employer contribution requirements below or view the List of Public Agency Required Employer Contributions (PDF, 2.01 MB).

Download
About Contributions 

Show 10 entries Search Search
Empty
Cell CalPERS Employer ID Employer Name
Empty
Cell
CalPERS Employer ID
1966164745
Employer Name Search Employer Name

EXHIBIT E
Empty
Cell CalPERS Employer ID Employer Name
1966164745 City of Guadalupe
Employer Plan FY 2024-25 UAL 2024-25 FY 2023-24 UAL 2023-24 FY 2022-23 UAL 2022-23 Miscellaneous 12.52% $228,366 12.47% $188,414 10.87% $196,659 PEPRA Miscellaneous 7.87% $2,855 7.68% $0 7.47% $2,559
PEPRA Safety Fire 11.05% $1,600 10.85% $659 10.80% $1,203 PEPRA Safety Police 11.05% $8,391 10.85% $4,766 10.80% $3,340 Safety 16.56% $164,935 16.45% $131,533 14.74% $136,295
Showing 1 to 1 of 1 entries (filtered from 1,505 total entries) Previous 1 Next
Base Pay Allocation Dept
Name Department % Amt as of % 228,366.00 Alloc
Alloc ESTIMATE ANNUAL
01 4300 Parks & Rec
PARKS & REC POSITION 01 4300 0250 - 0.00% 0.00
01 4120 - Finance
PEREYRA-LEON, ANGELITA 01 4120 0250 109,436.08 20.13% 45,963.13 VERONICA FABIAN 01 4120 0250 77,060.36 14.17% 32,365.34 78,328.47 Police
MERAZ, JOSUE, I 01 4200 0250 100% 76,872.64 14.14% 32,286.49 01 4105 - Admin
MERINO-ESCOBAR, JUANA 01 4105 0250 97.5% 98,763.90 18.16% 41,480.82 079-4542-0250 2.5% 2,532.41 0.47% 1,063.61
Various
VIDALES, JAIME, N 10 4420 0250 100% 97,163.43 17.87% 40,808.62 12 4425 - Wastewater
12 4425 0250 0.00% 0.00
Building and Safety
SAUCEDO, ALICE, R 01 4405 0250 100% 81,900.00 15.06% 34,397.98 Total 543,728.81714667 100.00% 228,366.00 - s/b zero
Allocation
01 4105 0250 41,480.82 MOMS # Base Pay ESTIMATE ANNUAL
01 4120 0250 78,328.47
01 4200 0250 32,286.49 PER01 A. Leon 109,436.08
01 4405 0250 34,397.98 MER02 J. Meraz 76,872.64
10 4420 0250 40,808.62 MER01 J. Escobar 101,296.31
12 4425 0250 0.00 FAB01 V. Fabian 77,060.36
079-4542-0250 1,063.61 VID01 J. Vidales 97,163.43
Total 228,366.00 SAU01 A Saucedo 81,900.00

0.00 TOTAL 543,728.82 -
4,506,924.03
406,147.00
City of Guadalupe
CalPers Monthly Employer Unfunded Liability Allocation
Class 1169 (Classic-Miscellaneous)
Fiscal Year 24-25 estimate
N:\01-Finance (Janice)\Payroll\Unfunded Liability\Contribution Detail Report-Unfunded Liab est FY24-25 5/21/2024
Base Pay Allocation Dept
Name Department Amt as of % 164,935.00 Total
MOMS # est 2024
LIMON, CARLOS, H 01 4200 0250 LIM02 178,354.94 31.36% 51,727.79 MEDINA, FRANK 01 4200 0250 MED01 143,597.11 25.25% 41,647.07 93,374.86 SCHMITZ, PATRICK, B 01 4220 0250 SCH02 126,574.27 22.26% 36,709.99 GARCIA, FERNANDO 01 4220 0250 GAR03 120,161.66 21.13% 34,850.15 71,560.14 Total 568,687.98 100.00% 164,935.00 164,935.00
Allocation
01 4200 0250 93,374.86
01 4220 0250 71,560.14
Total 164,935.00
City of Guadalupe
CalPers Monthly Employer Unfunded Liability Allocation
Class 1170 (Classic-Safety)
Fiscal Year 24-25 estimate
N:\01-Finance (Janice)\Payroll\Unfunded Liability\Contribution Detail Report-Unfunded Liab est FY24-25 5/21/2024
Base Pay Allocation Dept
PEPRA Misc 26751 Amt as of % 2,855.00 Total
est 2024
ADMIN % MOMS #
Bodem, Todd 01 4105 0250 100% BOD01 175,084.21 9.02% 257.55 Estrada, Sylvia 01 4105 0250 100% EST10 104,267.80 5.37% 153.38 Unfilled Grant Administrator 01 4105 0250 100% NEW 83,628.48 4.31% 123.02 533.94 01 4105 0250

FINANCE
Davis, Janice 01 4120 0250 97.5% DAV02 115,022.08 5.93% 169.20 079-4542-0250 2.5% DAV02 2,949.28 0.15% 4.34
Rivas, Isaias 01 4120 0250 15% RIV01 12,412.14 0.64% 18.26 10-4420-0250 85% RIV01 70,335.46 3.62% 103.46
Figueroa, Mayra 01 4120 0250 5% RIC02 2,725.35 0.14% 4.01 10-4420-0250 95% RIC02 51,781.57 2.67% 76.17 195.17 01 4120 0250 Accounting Clerk-Unfilled 01 4120 0250 5% New 2,519.47 0.13% 3.71 4.34 079-4542-0250 10-4420-0250 95% New 47,869.98 2.47% 70.42 250.05 10-4420-0250 Building Main
Schubert, Edward 01 4300 0250 50% SCH03 31,925.23 1.64% 46.96 01 4145 0250 50% SCH03 31,925.23 1.64% 46.96
Ramirez, Juan (Johnny) 01 4300 0250 50% RAM10 23,469.06 1.21% 34.52 63-4472-0250 50% RAM10 23,469.06 1.21% 34.52 46.96 01 4145 0250 Unfilled Maintenance Worker 01 4300 0250 50% NEW 23,512.14 1.21% 34.59 116.07 01 4300 0250 63-4472-0250 50% NEW 23,512.14 1.21% 34.59 69.11 63-4472-0250 Park & Rec
Barajas, Annis 01 4300 0250 100% FUE01 87,274.20 4.50% 128.38 Unfilled Senior Community Ce 01 4300 0250 100% SCH03 57,865.60 2.98% 85.12 213.50 01 4300 0250 Streets
Unfilled Public Works Director 71-4454-0250 30% New 39,000.00 2.01% 57.37 10-4420-0250 30% New 39,000.00 2.01% 57.37
12-4425-0250 30% New 39,000.00 2.01% 57.37
23-4461-0250 10% New 13,000.00 0.67% 19.12
Cruz, Dayanira 71 4454 0250 33% CRU01 26,694.77 1.38% 39.27 10-4420-0250 33% CRU01 26,686.76 1.37% 39.26
12-4425-0250 33% CRU01 26,686.76 1.37% 39.26
Gutierrez, Rudy 71-4454-0250 60% GUT01 43,899.96 2.26% 64.58 10-4420-0250 10% GUT01 7,316.66 0.38% 10.76
12-4425-0250 10% GUT01 7,316.66 0.38% 10.76
23-4461-0250 10% GUT01 7,316.66 0.38% 10.76
60-4490-0250 5% GUT01 3,658.33 0.19% 5.38
63-4472-0250 5% GUT01 3,658.33 0.19% 5.38
Esparza, Juan 71-4454-0250 60% ESP02 27,824.94 1.43% 40.93 202.14 71-4454-0250 10-4420-0250 10% ESP02 4,637.49 0.24% 6.82 114.21 10-4420-0250 12-4425-0250 10% ESP02 4,637.49 0.24% 6.82 114.21 12-4425-0250 23-4461-0250 10% ESP02 4,637.49 0.24% 6.82 36.71 23-4461-0250 60-4490-0250 5% ESP02 2,318.75 0.12% 3.41 8.79 60-4490-0250 63-4472-0250 5% ESP02 2,318.75 0.12% 3.41 8.79 63-4472-0250 Bldg & Safety
Associate Planner-Unfilled 01 4405 0250 100% New 83,224.96 4.29% 122.42 122.42 01 4405 0250 WATER
Sagisi, Jose 10 4420 0250 100% SAG01 59,850.44 3.08% 88.04 Water Maintenance Oper - Un 10 4420 0250 100% New 57,919.78 2.98% 85.20 173.24 10 4420 0250

WASTEWATER
Miklas, David 12 4425 0250 100% MIK01 89,675.04 4.62% 131.91 Valdivia, Devin 12 4425 0250 100% VAL01 68,222.05 3.52% 100.35 Costa, John 12 4425 0250 100% COS0001 48,230.52 2.48% 70.95 Ramos, Daniel 12 4425 0250 100% RAM0001 46,211.57 2.38% 67.98 371.19 12 4425 0250

PD ADMIN
Bribriesca, Norma 01 4200 0250 100% BRI01 93,662.03 4.83% 137.77 Mendosa, Joana 01 4200 0250 100% MEN01 92,728.48 4.78% 136.40 274.18 01 4200 0250 Total ######## 100.0% 2,855.00
PEPRA Safety 25554 & 25555 Allocation
8,391.00
Police MOMS #
CASH, MICHAEL 01 4200 0250 100% CA01 124,285.57 11.86% 994.79 Unfilled Police Officer 01 4200 0250 100% NEW 75,013.21 7.16% 600.41 OROZCO, CHRISTOPHER 01 4200 0250 100% ORO01 105,550.18 10.07% 844.83 CASTELLANOS, LUIS 01 4200 0250 100% CAS03 104,618.23 9.98% 837.37 RUIZ, OMAR 01 4200 0250 100% RUI01 107,802.41 10.28% 862.86 WELKOM, LIA 01 4200 0250 100% WEL0001 91,367.34 8.72% 731.31 JAIMES, MIGUEL 01 4200 0250 100% JAI01 90,957.74 8.68% 728.03 NEGRANTI, MARIA 01 4200 0250 100% NEG01 101,645.59 9.70% 813.58 KUHBANDER, MICHAEL 01 4200 0250 100% KUH01 125,597.82 11.98% 1,005.30 WRIGHT, ROBERT 01 4200 0250 100% WRI01 121,500.58 11.59% 972.50 1,048,338.68 sub-total 8,391.00
Fire 1,600.00
CASH, MICHAEL 01 4220 0250 100% CAS01 38,724.52 9.55% 152.88 BONIFACIO, DAVID 01 4220 0250 100% BON01 81,383.77 20.08% 321.29 unfilled Fire Engineer 01 4220 0250 100% NEW 80,354.16 19.83% 317.22 NUNO, JACOB 01 4220 0250 100% NUN01 102,917.48 25.39% 406.30 REYES, GUADALUPE 01 4220 0250 100% REY04 101,905.47 25.14% 402.31 405,285.40 sub-total 1,600.00
Total ######## 200.0% 9,991.00
Allocation PEPRA Misc
01 4105 0250 533.94
01 4120 0250 195.17
079-4542-0250 4.34
01 4145 0250 46.96
01 4300 0250 329.57
71-4454-0250 202.14
10-4420-0250 537.49
12-4425-0250 485.39
23-4461-0250 36.71
60-4490-0250 8.79
63-4472-0250 77.90
01 4405 0250 122.42
01 4200 0250 274.18
Total 2,855.00

0.00 Allocation PEPRA Safety
01 4200 0250 8,391.00
01 4220 0250 1,600.00
Total 9,991.00

0.00 ######
City of Guadalupe
CalPers Monthly Employer Unfunded Liability Allocation
Fiscal Year 24-25 estimate
Class 26751 and 25554/25555 (PEPRA)
N:\01-Finance (Janice)\Payroll\Unfunded Liability\Contribution Detail Report-Unfunded Liab est FY24-25 5/21/2024
Water Deliveries‐Fiscal Year Basis (AF) (1) FY 22/23 FY 23/24 FY 24/25 FY 25/26 FY 26/27 FY 27/28 FY 28/29 FY 29/30 FY 30/31 FY 31/32 Water Deliveries‐1st Quarter 3 3 77 77 77 77 77 77 77 77 Water Deliveries‐2nd Quarter 3 3 87 87 87 87 87 87 87 87 Water Deliveries‐3rd Quarter 3 3 102 102 102 102 102 102 102 102 Water Deliveries‐4th Quarter 3 3 92 92 92 92 92 92 92 92 Total FY Water Deliveries (acre‐feet) 12 12 358 358 358 358 358 358 358 358 CCWA Variable Cost per AF Assumptions $ 128 $ 135 $ 142 $ 149 $ 156 $ 164 $ 172 $ 181 $ 190 $ 199 DWR Variable Cost per AF Assumptions $ 275 $ 303 $ 318 $ 334 $ 351 $ 369 $ 387 $ 406 $ 427 $ 448 CCWA Costs
CCWA Fixed O&M Costs (2) $ 115,601 $ 119,069 $ 122,641 $ 126,321 $ 130,110 $ 134,014 $ 138,034 $ 142,175 $ 146,440 $ 146,440 CCWA Variable O&M Costs (5) 1,540 1,618 50,725 53,261 55,925 58,721 61,657 64,740 67,977 71,375 CCWA(Credits) Amount Due (20,705)
Subtotal: CCWA Costs 96,437 120,687 173,367 179,582 186,035 192,734 199,691 206,915 214,417 217,816 DWR Costs (7)
Transportation Capital 283,361 310,559 321,294 321,222 321,206 321,113 320,923 320,849 320,759 320,428 Coastal Branch Extension ‐ ‐                 ‐  ‐  ‐  ‐  ‐  ‐ ‐  ‐ Water System Revenue Bond Surcharge ‐ 13,654 12,825 11,672 10,976 13,185 8,412 11,284 916 19,069 Transportation Minimum OMP&R 62,037 157,554 158,613 160,199 160,410 163,419 165,053 166,704 168,371 170,055 Delta Water Charge 59,518 68,984 72,526 76,244 80,149 84,249 88,554 93,074 97,820 99,668 DWR Variable Costs (5) (6) 2,849 3,638 114,096 119,800 125,790 132,080 138,684 145,618 152,899 160,544 Subtotal: DWR Costs 407,766 $ $ 554,389 $ 679,353 $ 689,138 $ 698,531 $ 714,046 $ 721,626 $ 737,528 $ 740,765 $ 769,763 Total Projected State Water Costs $ 504,203 $ 675,076 $ 852,720 $ 868,720 $ 884,566 $ 906,780 $ 921,317 $ 944,443 $ 955,182 $ 987,579 Projected Payments by Due Date
June 1st Fixed Payment (3) $ 499,814 $ 669,821 $ 687,899 $ 695,658 $ 702,851 $ 715,980 $ 720,977 $ 734,086 $ 734,306 $ 755,660 July 1st Variable Payment (4) 1,097 1,314 35,319 37,085 38,939 40,886 42,930 45,077 47,330 49,697 October 1st Variable Payment 1,097 1,314 40,010 42,010 44,110 46,316 48,632 51,063 53,617 56,297 January 1st Variable Payment 1,097 1,314 47,000 49,350 51,817 54,408 57,128 59,985 62,984 66,133 April 1st Variable Payment 1,097 1,314 42,493 44,617 46,848 49,191 51,650 54,233 56,944 59,792 Central Coast Water Authority
City of Guadalupe
State Water Cost Ten‐Year Projections
Fiscal Year 2022/23 Final Proposed Budget

EXHIBIT F

EXHIBIT B

PAYMENT ARRANGEMENTS

CITY OF GUADALUPE
A. City shall pay for services rendered under this Agreement for FYs 22-23 through 26-27 in the amounts shown in the table below, billed in four equal quarterly payments. Quarterly payments to COUNTY shall be made within thirty (30) days of receipt of invoice.

B. Payment for services shall be made based upon the scope contained in EXHIBIT A as determined by County.

C. In the event of early termination of this Agreement in accordance with Section 16, CITY shall reimburse the outstanding COUNTY General Fund contribution that would have been recovered in subsequent years had the Agreement not been terminated. CITY's allocation of COUNTY General Fund reimbursement is $14,200 to be repaid over 5 years.

Annual Amounts for Fiscal Years July 1, 2022 through June 30, 2027 Annual Quarterly
Fiscal Year Amount Invoices
Year1 July 1, 2022- June 30, 2023 $ 64,740 $ 16,185
Year2 July 1, 2023- June 30, 2024 $ 69,272 $ 17,318
J"ufy !, 2024- June 30, 2025
-s 73;9!6 $�
Year4 July 1, 2025- June 30, 2026 $ 78,676 $ 19,669
Year 5 July 1, 2026- June 30, 2027 $ 83,556 $ 20,889
Animal Services Revenue Agreement - City of Guadalupe Page 11

EXHIBIT G
Transmitted via e-mail
March 15, 2024
Todd Bodem, City Administrator
City of Guadalupe
918 Obispo Street
Guadalupe, CA 93434
2024-25 Annual Recognized Obligation Payment Schedule
Pursuant to Health and Safety Code (HSC) section 34177 (o) (1), the City of Guadalupe Successor Agency (Agency) submitted an annual Recognized Obligation Payment Schedule for the period July 1, 2024 through June 30, 2025 (ROPS 24-25) to the California Department of Finance (Finance) on January 29, 2024. Finance has completed its review of the ROPS 24-25.

Based on a sample of line items reviewed and application of the law, Finance made the following determinations:
• Item No. 35 – Arbitrage Services in the total outstanding amount of $20,000 is no longer needed. The Agency inadvertently requested funding for this item and asked to withdraw the funding request. Therefore, the requested amount of $5,000 in Redevelopment Property Tax Trust Fund (RPTTF) is not needed. In addition, this line has been retired.
• The administrative costs claimed are within the fiscal year administrative cap pursuant to HSC section 34171 (b) (3). However, Finance notes the Oversight Board (OB) approved an amount that appears excessive, given the number and nature of the obligations listed on the ROPS. HSC section 34179 (i) requires the OB to exercise a fiduciary duty to the taxing entities. Therefore, Finance encourages the OB to apply adequate oversight when evaluating the administrative resources necessary to successfully wind-down the Agency.

Pursuant to HSC section 34186, successor agencies are required to report differences between actual payments and past estimated obligations (prior period adjustments) for the July 1, 2021 through June 30, 2022 (ROPS 21-22) period. The ROPS 21-22 prior period adjustment (PPA) will offset the ROPS 24-25 RPTTF distribution. The amount of RPTTF authorized includes the PPA resulting from the County Auditor-Controller’s review of the PPA form submitted by the Agency.

EXHIBIT H
Todd Bodem
March 15, 2024

The Agency’s maximum approved RPTTF distribution for the reporting period is $490,714, as summarized in the Approved RPTTF Distribution table (see Attachment).

RPTTF distributions occur biannually, one distribution for the July 1, 2024 through December 31, 2024 period (ROPS A period), and one distribution for the January 1, 2025 through June 30, 2025 period (ROPS B period), based on Finance's approved amounts.

Since this determination is for the entire ROPS 24-25 period, the Agency is authorized to receive up to the maximum approved RPTTF through the combined ROPS A and B period distributions.

Except for the adjusted item, Finance approves the remaining items listed on the ROPS 24-25 at this time. If the Agency disagrees with our determination with respect to any items on the ROPS 24-25, except items which are the subject of litigation disputing our previous or related determinations, the Agency may request a Meet and Confer within five business days from the date of this letter. The Agency must use the RAD App to complete and submit its Meet and Confer request form. The Meet and Confer process and guidelines are available on our website:
http://dof.ca.gov/Programs/Redevelopment/Meet_And_Confer/ Absent a Meet and Confer, this is our final determination regarding the obligations listed on the ROPS 24-25. This determination only applies to items when funding was requested for the 12-month period. If a determination by Finance in a previous ROPS is currently the subject of litigation, the item will continue to reflect the determination until the matter is resolved.

The ROPS 24-25 form submitted by the Agency and this determination letter will be posted on our website:
http://dof.ca.gov/Programs/Redevelopment/ROPS/
This determination is effective for the ROPS 24-25 period only and should not be conclusively relied upon for future ROPS periods. All items listed on a future ROPS are subject to Finance's review and may be adjusted even if not adjusted on this ROPS or a preceding ROPS. The only exception is for items that have received a Final and Conclusive determination from Finance pursuant to HSC section 34177.5 (i). Finance’s review of Final and Conclusive items is limited to confirming the scheduled payments as required by the obligation.

The amount available from the RPTTF is the same as the amount of property tax increment available prior to the enactment of the redevelopment dissolution law.

Therefore, as a practical matter, the ability to fund the items on the ROPS with property tax increment is limited to the amount of funding available to the Agency in the RPTTF.

Guadalupe
Trevor Lysek, Division Chief, Property Tax Division, Santa Barbara County Ed Price, Countywide Oversight Board Representative
Todd Bodem
March 15, 2024

Please direct inquiries to [email protected].

Sincerely,
Cheryl L. McCormick, CPA
Chief, Office of State Audits and Evaluations
cc: Joy Heuser Otsuki, Legal Counsel, Leibold McClendon & Mann, P.C., City of Attachment
Approved RPTTF Distribution
July 2024 through June 2025
ROPS A ROPS B Total
RPTTF Requested $ 366,869 $ 1,175 $ 368,044
Administrative RPTTF Requested 63,985 63,985 127,970
Total RPTTF Requested 430,854 65,160 496,014
RPTTF Requested 366,869 1,175 368,044
Adjustment(s)
Item No. 35 (5,000) 0 (5,000)
RPTTF Authorized 361,869 1,175 363,044
Administrative RPTTF Authorized 63,985 63,985 127,970
ROPS 21-22 prior period adjustment (PPA) (300) 0 (300)
Total RPTTF Approved for Distribution $ 425,554 $ 65,160 $ 490,714 Todd Bodem
March 15, 2024

EXHIBIT I
For: City of Guadalupe - Rudy G.
[email protected]
918 Obispo St
Guadalupe, CA, 93434
805-249-0950
Job Address Guadalupe St. Between 10th and Olivera - 47 Podocarpus Trees Equipment HD chipper and chipper truck
Description Amount
Tree Pruning
46 Podocarpus and 1 Holly - Thin and reduce the size by about 1/3 to keep them from getting too big and to keep them looking nice.

Make sure they are off the buildings by about 2 feet.

Make sure each tree is trimmed so that street light coming from any street lights is not osbstructed. Trim to at least 2 feet away from any street light.

All debris cleaned up and hauled away.
$ 275.00 each.

We only charge for trees done. This is a per tree estimate. $12,925.00

REMARKS
This price is about 15% savings over the last trimming, which was 2 and a half years ago, and was done for about $ 325.00 per tree.

The savings over the last time is about $ 2,200.00. The reasons are that the interval is regular, we are familiar with the trees and the job, and we have a good relationship with the City Staff.

Please make payment to: ACE Certified Tree Care
Bank Account Number: 40630141468678773
40630108443510346
Routing Number:121000248 121000248
Subtotal $12,925.00
Total $12,925.00
Total $12,925.00
Estimate No: 20222918
Date: 05/28/2024
ACE Certified Tree Estimate/Work Order
Care
PO Box 414
Arroyo Grande, CA 93421
[email protected]
www.acecertifiedtreecare.com
805-474-8013
1 / 2

EXHIBIT J
Comments
Thank you very much for your business. Our owner is a Certified Arborist and our tree work and recommendations are education, experience and Certified Arborist Standards based. They are the best course of action for your particular trees and the way they are used on the property.

ACE Certified Tree Care Client's signature
ACE Certified Tree Care - Estimate/Work Order 20222918 - 05/28/2024 2 / 2

EXHIBIT K
RESOLUTION NO. 2024-38

A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF GUADALUPE, CALIFORNIA, ADOPTING THE 2024-25 FISCAL YEAR BUDGET
WHEREAS, City Staff prepared and presented a preliminary draft budget to the City Council during a budget workshop at a City Council meeting on May 28, 2024; and WHEREAS, the City Council assisted in the development of the proposed budget and further direction was provided to City Staff; and
WHEREAS, City Staff updated the expenditures per the preliminary draft based on the direction received from City Council to arrive at a balanced budget; and WHEREAS, the proposed City Budget, Capital Improvements Project, Capital Facilities Fund Program of Projects, and American Rescue Plan Act Allocation for Fiscal Year 2024-2025 for the City of Guadalupe have been submitted to the City Council, have been considered, and are in final form and substance acceptable to the City Council.

NOW, THEREFORE, BE IT RESOLVED, by the City Council of the City of Guadalupe as follows:

SECTION 1. The Fiscal Year 2024-2025 City Budget (attached to the staff report for this item) is approved;
SECTION 2. The Fiscal Year 2024-2025 Capital Improvements Projects (attached to the staff report for this item) is approved;
SECTION 3. The Fiscal Year 2024-2025 Capital Facilities Fund Program of Projects (attached to the staff report for this item) is approved;
SECTION 4. The Fiscal Year 2024-2025 American Rescue Plan Act Allocation (attached to the staff report for this item) is approved;
SECTION 5. All encumbrances as of June 30, 2024, as represented by outstanding purchase orders and approved capital projects in process, are hereby authorized to be carried forward and appropriated into the 2024-2025 fiscal year budget as determined by the Finance Director along with any excess general fund revenue; SECTION 6. The City Administrator, or his delegee, is authorized to take all necessary actions to implement the provisions of said budget, capital improvement projects, and capital facilities fund program of projects as adopted on this date, including future ATTACHMENT 6
adjustments for unanticipated expenditures offset by revenues, and transfers of budget amounts within a fund;
SECTION 7. That the City Administrator, or his delegee, is also authorized, until otherwise directed, to underfill position classifications by existing classifications when warranted to address operational demands; and
SECTION 8. The City Clerk is hereby authorized to make minor changes herein to address clerical errors, so long as substantial conformance of the intent of this document is maintained. In doing so, the City Clerk shall consult with the City Administrator and City Attorney concerning any changes deemed necessary.

PASSED AND ADOPTED at a regular meeting on the 11th of June 2024 by the following vote:

MOTION:

AYES:

NOES:

ABSENT:

ABSTAINED:

I, Todd Bodem, Deputy City Clerk of the City of Guadalupe, DO HEREBY CERTIFY that the foregoing Resolution, being Resolution No. 2024-38 has been duly signed by the Mayor and attested by the City Clerk, all at a regular meeting of the City Council, held June 11, 2024 and that same was approved and adopted.

ATTEST:
___________________________________ ____________________________________ Todd Bodem, Deputy City Clerk Ariston Julian, Mayor
APPROVED AS TO FORM:
_________________________________
Phillip F. Sinco, City Attorney