EXHIBIT A
! "
#$
%
&'"
( ) %
&'"
( ) %
&'"
( )
*
#
!
#
( +,--+ , -.) +,/ 0/) +,/ 0)
($(1*
"
( -, -.,//+ -) -2,/+ 0) ,/+ 0)
('
*
+,// ,2 +) /,2 0) -,-2 0)
*
1
,.+ ,+ -/) , 0-) , 0-)
'$* '
3("'
#
(
-, ,2 2) , 0) , 0)
''
#$
4'
,-22 -,. -+) -, 0) -,- 0)
'
#
#
*5
'$
/,/22 ,/+ 2) ,+ 02) ,.+ 0)
#
6'
*('
(6(' ,- .,2 /) .,2 0) .,2 0)
#$ +-,+ /2-,- ) /-+,. 02) .+,/ 0)
4((
#
(
7.8 7,8 7,-.8 7,8
#$ +2,/-+ /2/,/-. ) /-,. 0.) .,+.- 0)
9(
:""
#$ +2,/-+ /2/,/-. ) /-,. 0.) .,+.- 0)
;
(4#
'(
##""
#$<#
(
7#$$ "#
(
6
#$'
:
1:='8
'> 5?@
#
":
'
'"#
A#
'
'3'$ !<1'
'
(4#
'
<#
' $ "#$#
#
'A('
'
$
,
#
A'$$#
'1( #$*#
( #$'" 4("
$ B
0
A
:6#"
"
('
:'!#'4("
'< ,(6$#
( #
!
'
'
,1' ! $(
("#$(4!#"
#A
B6
"'"
#(
0
'#
')(
("
#C<'"#4''66'"
(3'DD#6
'
'#
'0+)(
("
#C''DD0
>'6$'"
!#
(#$ '#
6'#
'E9# 6#(
D.(4!$'4'
#
( #
6FE#&
6
#C'6'
#$
!
1 #4
#'$# '!# 4'
0
D+D>-
!""#$$$
%&'()*+,-./
'() %
'!#
'>D+D >
3
$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
$450,743
$9,413
-$5,966
$995,616
&LW\RI*XDGDOXSH
&DOLIRUQLD-3,$&RQWULEXWLRQ6XPPDU\
5HSRUW'DWH
a(VWLPDWHa
/LDELOLW\
$QQXDO&RQWULEXWLRQ
5HWURVSHFWLYH$GMXVWPHQW
3D\PHQW3ODQ3ULQFLSDO
3D\PHQW3ODQ)HH
&ODLPV$GPLQLVWUDWLRQ
([FHVV3RRO'LVWULEXWLRQ
6XEWRWDO
:RUNHUV
&RPSHQVDWLRQ
$QQXDO&RQWULEXWLRQ
5HWURVSHFWLYH$GMXVWPHQW
3D\PHQW3ODQ3ULQFLSDO
3D\PHQW3ODQ)HH
7DLO&ODLPV$GPLQLVWUDWLRQ
6XEWRWDO
3URSHUW\
$OO5LVN
(DUWKTXDNH
2WKHU9HKLFOHV
(PHUJHQF\9HKLFOHV 0HFKDQLFDO%UHDNGRZQ
$GPLQDQG$SSUDLVDO)HH
0LG<HDU7,9&KDQJHV
6XEWRWDO
0LVFHOODQHRXV
&ULPH
SUHPLXPSDLGWR$OOLDQW
3ROOXWLRQ/HJDO/LDELOLW\
8QGHUJURXQG6WRUDJH7DQNV
6XEWRWDO *UDQG7RWDO
&KDQJH
7KH([FHVV3RRO'LVWULEXWLRQLVDUHWXUQRIFRQWULEXWLRQVWRPHPEHUVRIWKH3ULPDU\/LDELOLW\3URJUDPZKRSDUWLFLSDWHGEHWZHHQ DQG
'LVWULEXWLRQVFRPPHQFHGLQDQGZLOOEHSDLGRXWRYHU\HDUV
EXHIBIT C
Gen Gov
Based on Oper Budget 21Ͳ22 46.44%
Oper % of 119,585
Gen Fund Budget Total Liability
01 4145 2300 Bldg Maint 164,720 4.39% 5,251
01 4300 2300 Parks 212,530 5.67% 6,775
Sub total Gen Fund 12,026
Streets
71 4454 2300 Measure A 308,000 8.21% 9,818
Lighting/Landscape
60 4490 2300 Guad Assmt Dist 19,841 0.53% 632
65 4485 2300 Guad Light Dist 56,255 1.50% 1,793
Sub total Lighting 2,426
Enterprise
10 4420 2300 Water 1,918,200 51.13% 61,147
12 4425 2300 Sewer 1,071,880 28.57% 34,169
Sub total Enterprise 95,316
Total Gen Government 3,751,426 100.00% 119,585
Pub Safety
Based on Oper Budget for FY 21Ͳ22 53.56%
Oper % of 137,925
SafetyͲGen Fund Budget Total Liability
01 4200 2300 Police 2,437,300 68.02% 93,822
01 4220 2300 Fire 1,145,700 31.98% 44,103
Total Public Safety 3,583,000 100.00% 137,925
Total 21Ͳ22 Liability Premium 257,510
Gen Gov & Police Share per Liab Prgrm pg 12 A/P Distribution General Gov 95,338 46.4391% 01 1014 149,950
Police 109,959 53.5609% 71 1014 9,818
Total 205,297 60 1014 632
65 1014 1,793
10 1014 61,147
12 1014 34,169
Total 257,510
General Government
Public Safety
City of Guadalupe
Liability Premium Allocation
Fiscal Year 22Ͳ23 ESTIMATE
$257,510
N:\2022Ͳ2023 Budget\Workpapers\addressed\Gen Liab & WC Allocation 21Ͳ22 LZ ESTIMATE FOR FY23 6/8/2022
Gen Gov
Based on Budgeted P/R for FY 21Ͳ22 30.90%
Budgeted % of 98,018
Gen Fund Payroll Payroll W/C
01 4100 0350 Council 12,270 0.56% 548
01 4105 0350 Admin 462,680 21.10% 20,677
01 4120 0350 Finance 524,820 23.93% 23,454
01 4145 0350 Bldg Maint 33,440 1.52% 1,494
01 4300 0350 Parks 73,000 3.33% 3,262
01 4405 0350 Bldg Permits 123,700 5.64% 5,528
Sub total Gen Fund 54,964
Safety
57 4213 0350 Drug/Alcohol 0 0.00% 0
Streets
71 4454 0350 Meas A 217,300 9.91% 9,711
Enterprise
10 2253 Water 387,600 17.67% 17,322
12 2253 Sewer 358,500 16.35% 16,021
Sub total Enterprise 33,343
Total Gen Government 2,193,310 100.00% 98,018
0 Pub Safety
0 69.10%
Budgeted % of 219,206
SafetyͲGen Fund Payroll Payroll W/C
01 4200 0350 Police 2,241,500 68.16% 149,415
01 4220 0350 Fire 1,047,000 31.84% 69,791
Total Public Safety 3,288,500 100.00% 219,206
Total 21Ͳ22 W/C Premium 317,224
Gen Gov & Police Share per Liab Prgrm pg 12 A/P Distribution General Gov 86,270 30.8986% 01 1014 274,170
Police 192,934 69.1014% 57 1014 0
Total 279,204 71 1014 9,711
10 1014 17,322
12 1014 16,021
Total 317,224
City of Guadalupe
Workers Comp Premium Allocation
$317,224
Fiscal Year 22Ͳ23 ESTIMATE
Public Safety
N:\2022Ͳ2023 Budget\Workpapers\addressed\Gen Liab & WC Allocation 21Ͳ22 LZ ESTIMATE FOR FY23 6/8/2022
Admin Dept
Base 612.35 290.18
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 CostsBOD01 BODEM, TODD City Administrator N/A Contract N/A 72.231 2080 150,240.08 - - - 1,950.00 152,190.08 11,175.33 12,968.64 19,838.39 1,820.96 224.22 304.59 46,332.13 198,522.22MER01 ESCOBAR, JUANA Administrative Assistant SEIU 205/E 4/20/2024 41.943 2080 87,240.67 1,000.00 3,250.00 9,100.00 - 100,590.67 7,544.80 15,921.18 - 1,820.96 224.22 155.01 25,666.17 126,256.84 BUT01 BUTLER, TEGNEAR Human Resources Manager N/A N/A 36.264 2080 75,429.62 - - - - 75,429.62 5,472.81 5,634.59 16,844.26 1,127.13 136.14 219.93 29,434.86 104,864.48Paid for by Grants Grant Administrator - - - - - - - City Clerk N/A N/A N/A 1,800.00 - - - - 1,800.00 137.70 0 0 137.70 1,937.70 1,000.00 314,710.37 3,250.00 9,100.00 1, 330,010.37 950.00 24,330.63 34,524.41 36,682.65 4,769.05 584.58 679.54 101,570.86 431,581.24 Estimated Costs Unfunded Liab Total
Reg 001-4105-0100 306,386.10 306,386.10Reg (Royal Theater) 079-4542-0100 9,693.02 9,693.02Part Time 001-4105-0125 1,800.00 1,800.00 temp 001-4105-0150 - -OT 001-4105-0200 975.00 975.00
079-4542-0200 25.00 25.00
Retirement 001-4105-0250 33,477.95 27,891.33 61,369.28
079-4542-0250 1,046.46 1,046.46
Taxes 001-4105-0300 23,583.25 23,583.25
079-4542-0300 747.39 747.39
workers comp 001-4105-0350 16,759.32 16,759.32
079-4542-0350 530.21 530.21
Insurance 001-4105-0400 35,690.73 35,690.73
079-4542-0400 991.92 991.92
Other Benefits 001-4105-0450 1,852.50 1,852.50
079-4542-0450 97.50 97.50
Deferred Comp 001-4150-0545 8,872.50 8,872.50
079-4542-0545 227.50 227.50
Dental 001-4105-0560 4,632.48 4,632.48
079-4542-0560 136.57 136.57
Vision 001-4105-0570 567.77 567.77
079-4542-0570 16.82 16.82
Life 001-4105-0585 660.43 660.43
079-4542-0585 19.10 19.10
448,789.51 476,680.84
17,208.28
Employer Paid Benefits
1 EXHIBIT D
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 CostsDAV02 DAVIS, JANICE Finance Director N/A N/A 49.293 2080 102,528.84 - - - 102,528.84 7,376.24 7,658.90 19,838.39 1,820.96 224.22 127.56 37,046.28 139,575.11 PER01 PEREYRA-LEON, ANGELITA Accounting Supervisor SEIU 205/L2 45.422 2080 94,477.70 1,000.00 3,250.00 - 98,727.70 7,035.73 15,653.28 19,838.39 1,820.96 224.22 155.01 44,727.60 143,455.30 RIV01 RIVAS, ISAIAS Accounting Clerk SEIU 181/L1 35.705 2080 74,266.30 - 3,250.00 - 77,516.30 5,462.78 7,390.51 19,838.39 1,820.96 224.22 155.01 34,891.88 112,408.17FAB01 FABIAN, VERONICA Accounting Clerk SEIU 181/C 30.842 2080 64,152.03 - 3,250.00 53.04 67,455.07 5,146.71 11,300.08 9,951.66 587.73 85.23 135.85 27,207.25 94,662.32 RIC02 RICO, NEREIDA Accounting Clerk SEIU 20.165 2080 41,943.91 3,250.00 45,193.91 3,128.67 4,976.02 10,010.00 587.73 85.23 18,918.36 130.70 64,112.26 1,000.00 377,368.76 13,000.00 53.04 391,421.80 28,150.13 46,978.80 79,476.83 6,638.35 704.13 843.13 162,791.36 554,213.16 Estimated Costs Unfunded Liab Total Life 665.81
Reg 001-4120-0100 387,805.54 387,805.54 Vision 618.90
Reg (Royal Theater) 079-4542-0100 2,563.22 2,563.22
temp 001-4120-0150 - - Dental 4,117.26
OT 001-4120-0200 1,000.00 1,000.00 Med 73,965.89
Retirement 001-4120-0250 46,787.33 68,124.94 114,912.27 79,367.86 079-4542-0250 191.47 191.47
Taxes 001-4120-0300 27,965.72 27,965.72 234.9
079-4542-0300 184.41 184.41
workers comp 001-4120-0350 21,212.96 21,212.96
079-4542-0350 140.21 140.21
Insurance 001-4120-0400 78,980.87 78,980.87
079-4542-0400 495.96 495.96
def comp 001-4120-0545 53.04 53.04
Dental 001-4120-0560 6,592.82 6,592.82
079-4542-0560 45.52 45.52
Vision 001-4120-0570 837.52 837.52
079-4542-0570 5.61 5.61
Life 001-4120-0585 700.94 700.94
079-4542-0585 3.19 3.19
643,688.09 575,563.14
21,349.98
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 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 8,419.24 18,694.00 19,838.39 1,820.96 224.22 304.59 49,301.40 179,301.40 CRU01 CRUZ, DAYANIRA Engineering Technician SEIU 191/B 28.574 2080 59,434.46 - - 53.04 59,487.50 4,535.20 6,043.76 9,951.66 587.73 85.23 135.85 21,339.42 80,826.92 GUT01 GUTIERREZ, RUDY Maintenance Worker Leader SEIU 151/D 29.992 2080 62,382.40 - - - 62,382.40 4,583.30 6,260.01 10,010.00 1,820.96 224.22 138.42 23,036.91 85,419.32 BAT01 ESPARZA, JUAN Maintenance Worker SEIU 20.752 2080 43,165.08 - - - 43,165.08 2,473.69 4,824.47 19,838.39 1,129.70 136.14 - 28,402.39 71,567.46 MON01 MONTERO, JUAN Maintenance Worker 1 SEIU 21.791 2080 45,324.61 - - 53.04 45,377.65 3,423.99 4,989.75 9,951.66 1,820.96 224.22 135.85 20,546.44 65,924.09 - 340,306.55 - 106.08 340,412.63 23,435.42 40,811.98 69,590.09 7,180.32 894.04 714.71 142,626.56 483,039.19 Estimated Costs Unfunded Liab Total
Reg (GF Building Maint) 01-4145-0100 22,662.31 22,662.31 Reg (GF Parks & Rec) 01-4300-0100 22,662.31 22,662.31Reg (Measure A) 71-4454-0100 122,161.62 122,161.62Reg (Water) 10-4420-0100 69,381.93 69,381.93Reg (WasteWater) 12-4425-0100 69,381.93 69,381.93Reg (Trasit) 23-4461-0100 23,554.75 23,554.75Reg (Guad. Assess. Dist.) 60-4490-0100 5,277.37 5,277.37Reg (Pasa. L&L Dist.) 63-4472-0100 5,277.37 5,277.37Retirement 01-4145-0250 2,494.88 2,494.88 Retirement 01-4300-0250 2,494.88 2,494.88
Retirement 71-4454-0250 14,273.27 14,799.76 29,073.03
Retirement 10-4420-0250 8,731.03 8,731.03
Retirement 12-4425-0250 8,731.03 8,731.03
Retirement 23-4461-0250 2,977.85 4,861.97 7,839.82
Retirement 60-4490-0250 554.22 554.22Retirement 63-4472-0250 554.22 554.22Taxes 01-4145-0300 1,712.00 1,712.00 Taxes 01-4300-0300 1,712.00 1,712.00
Taxes 71-4454-0300 8,271.55 8,271.55
Taxes 10-4420-0300 4,743.05 4,743.05
Taxes 12-4425-0300 4,743.05 4,743.05
Taxes 23-4461-0300 1,547.62 1,547.62
Taxes 60-4490-0300 352.85 352.85Taxes 63-4472-0300 352.85 352.85Workers Comp 01-4145-0350 1,239.63 1,239.63 Workers Comp 01-4300-0350 1,239.63 1,239.63Workers Comp 71-4454-0350 6,682.24 6,682.24Workers Comp 10-4420-0350 3,795.19 3,795.19Workers Comp 12-4425-0350 3,795.19 3,795.19Workers Comp 23-4461-0350 1,288.44 1,288.44Workers Comp 60-4490-0350 288.67 288.67 Workers Comp 63-4472-0350 288.67 288.67Insurance 01-4145-0400 4,975.83 4,975.83 Insurance 01-4300-0400 4,975.83 4,975.83
Insurance 71-4454-0400 27,177.44 27,177.44
Insurance 10-4420-0400 12,253.24 12,253.24
Insurance 12-4425-0400 12,253.24 12,253.24
Insurance 23-4461-0400 4,968.68 4,968.68
Insurance 60-4490-0400 1,492.42 1,492.42
Insurance 63-4472-0400 1,492.42 1,492.42
Def Comp 01-4145-0545 26.52 26.52
Def Comp 01-4300-0545 26.52 26.52Def Comp 71-4454-0545 17.68 17.68Def Comp 10-4420-0545 17.68 17.68Def Comp 12-4425-0545 17.68 17.68Def Comp 23-4461-0545 - -Def Comp 60-4490-0545 - -Def Comp 63-4472-0545 - -Dental 01-4145-0560 910.48 910.48Dental 01-4300-0560 910.48 910.48Dental 71-4454-0560 2,512.58 2,512.58 Dental 10-4420-0560 1,037.25 1,037.25
Dental 12-4425-0560 1,037.25 1,037.25
Dental 23-4461-0560 477.16 477.16Dental 60-4490-0560 147.53 147.53Dental 63-4472-0560 147.53 147.53Vision 01-4145-0570 112.11 112.11Vision 01-4300-0570 112.11 112.11Vision 71-4454-0570 311.89 311.89Vision 10-4420-0570 131.71 131.71Vision 12-4425-0570 131.71 131.71Vision 23-4461-0570 58.46 58.46 Vision 60-4490-0570 147.53 147.53Vision 63-4472-0570 147.53 147.53Life 01-4145-0585 67.93 67.93 Life 01-4300-0585 69.21 69.21
Life 71-4454-0585 219.71 219.71Life 10-4420-0585 150.50 150.50Life 12-4425-0585 150.50 150.50Life 23-4461-0585 44.30 44.30 Life 60-4490-0585 6.92 6.92Life 63-4472-0585 6.92 6.92
521,629.81 501,968.08
18,928.89
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 CostsCA01 CASH, MICHAEL Public Safety Director N/A N/A 51.953 2080 108,061.57 - - - 2,136.00 - - 110,197.57 5,922.23 8,752.99 12,633.19 845. 102.10 34 228.23 28,484.08 138,681.66 BRI01 BRIBIESCA, NORMA Police Office Manager POA 171/D 39.160 2080 81,452.28 - 3,250.00 12,675.00 1,398.00 - 8,959.75 107,735.03 8,116.36 8,596.59 - 1,820.96 224.22 154.73 18,912.87 126,647.90 MEN01 MENDOSA, JOANA Records Technician POA 159/D 36.314 2080 75,533.64 - 3,250.00 - 1,398.00 - - 80,181.64 5,175.52 7,481.54 13,942.50 1,820.96 224.22 154.73 28,799.47 108,981.11 MER02 MERAZ, JOSUE Code Compliance Officer SEIU 32.103 2080 66,773.62 - 3,250.00 - 423.00 - - 70,446.62 4,921.95 11,403.35 19,838.39 1,820.96 224.22 155.01 38,363.88 108,810.50 LIM02 LIMON, CARLOS Police Lieutenant unrep Lieutenant/D 68.545 2080 142,573.70 - -- 1,398.00 9,855.41 12,194.33 166,021.44 12,211.31 31,232.26 19,838.39 1,820.96 224.22 260.83 65,587.97 231,609.41 MED01 MEDINA, FRANK Police Sergeant POA 202/D (sgt) 45.982 2080 95,641.73 38,256.69 3,250.00 1,720.94 1,398.00 6,611.23 8,180.24 155,058.83 11,794.10 22,063.02 12,049.47 1,129.70 85.23 135.85 47,257.36 202,316.19 BRE01 BREDA, ANDREW Police Officer POA 182/A 34.621 2080 72,010.85 28,804.34 - 518.44 1,398.00 4,977.75 - 107,709.38 8,224.17 9,914.81 13,481.18 587.73 85.23 - 32,293.12 140,002.50 ORO01 OROZCO, CHRISTOPHER Police Officer POA 182/B 36.351 2080 75,610.08 30,244.03 3,250.00 3,538.86 1,398.00 5,226.55 - 119,267.52 9,108.37 10,681.40 9,951.66 587.73 85.23 135.85 30,550.23 149,817.75 RAM03 RAMIREZ, JOSUE Police Officer POA 182/A 34.621 2080 72,010.85 28,804.34 3,250.00 3,442.14 1,398.00 4,977.75 2,808.00 116,691.08 8,911.27 10,569.07 12,049.47 587.73 85.23 135.85 32,338.62 149,029.70 RUI01 RUIZ, OMAR Police Officer POA 182/B 36.352 2080 75,612.26 30,244.91 3,250.00 3,627.78 1,398.00 5,226.70 10,844.68 130,204.32 9,945.04 11,852.87 9,951.66 587.73 85.23 135.85 32,558.37 162,762.70 JAI01 JAIMES, MIGUEL Police Officer POA 182/A On W/C 32.971 2080 68,579.78 27,431.91 3,250.00 - 1,398.00 4,878.84 2,203.76 107,742.30 - 10,122.58 13,942.50 1,820.96 85.23 154.73 26,125.99 133,868.29 NEG01 NEGRANTI, MARIA Police Officer POA 182/D On W/C 38.169 2080 79,390.58 31,756.23 3,250.00 - 1,398.00 5,487.87 - 121,282.69 - 11,117.91 13,942.50 1,820.96 136.14 155.01 148,455.22 27,172.52 KUH01 KUHBANDER, MICHAEL Police Officer POA 182/E Airport 42.080 2080 87,525.98 - - - 1,398.00 6,050.23 15,102.79 110,077.01 7,976.97 11,737.33 13,942.50 1,129.70 136.14 135.85 35,058.48 145,135.49 WRI01 WRIGHT, ROBERT Police Officer POA 182/E Airport 42.081 2080 87,528.17 - - 702.00 1,398.00 6,050.38 11,229.43 106,907.98 7,247.53 12,919.30 13,942.50 1,820.96 224.22 155.01 36,309.53 143,217.51 unfilled unfilled Police Officer POA 182/A 34.621 2080 72,010.85 28,804.34 - 518.44 1,398.00 4,977.75 - 107,709.38 8,224.17 9,914.81 13,481.18 587.73 85.23 - 32,293.12 140,002.50 unfilled unfilled Police Officer POA 218/A 34.621 2080 72,010.85 28,804.34 - 518.44 1,398.00 4,977.75 - 107,709.38 8,224.17 9,914.81 13,481.18 587.73 85.23 - 32,293.12 140,002.50 want want Police Officer POA 182/D 32.971 - - - - - - - TES01 TESORO, ROSANNE Temporary Clerk temp 20.175 520 10,491.00 - - - - - - 10,491.00 786.97 2,733.07 13,481.18 587.73 85.23 - 17,674.18 28,165.18 temp - - - - - - - - - 0 0 000 - -
273,151.13 1,342,817.80 29,250.00 27,262.04 22,131.00 69,298.22 71,522.97 1,835,433.16 116,790.13 201,007.70 219,949.44 19,965.59 2,262.55 2,097.52 562,072.93 2,397,506.09 Estimated Costs Unfunded Liab Total
Reg 01-4200-0100 1,502,397.99 1,502,397.99 3889.12
Part time 01-4200-0125 - - 3421.08
Temp 01-4200-0150 10,491.00 10,491.00 468.04
Overtime 01-4200-0200 273,151.13 273,151.13
Retirement 01-4200-0250 201,007.70 108,773.15 309,780.85 Taxes 01-4200-0300 116,790.13 116,790.13
Workers Com01-4200-0350 178,184.40 178,184.40
Insurance 01-4200-0400 219,949.44 219,949.44
Benefits 01-4200-0450 22,131.00 22,131.00
Def Comp 01-4200-0545 27,262.04 27,262.04
Dental 01-4200-0560 19,965.59 19,965.59
Vision 01-4200-0570 2,262.55 2,262.55
Life 001-4200-0585 2,097.52 2,097.52
Total 2,575,690.49 2,684,463.64
Diff 178,184.40
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 CostsCA01 CASH, MICHAEL Public Safety Director N/A N/A 17.318 2080 36,020.52 - - - 712.00 - - 36,732.52 569.06 972.55 4,211.06 281.78 34.03 76.08 6,144.57 42,877.09 GAR03 GARCIA, FERNANDO Fire Captain IAFF 184/L2 33.921 2756 93,486.28 37,394.51 3,250.00 - 1,495.00 7,408.35 5,506.88 148,541.02 10,071.67 21,334.97 19,838.39 1,820.96 224.22 154.73 53,444.94 201,985.96BON01 BONIFACIO, DAVID Fire Engineer IAFF 171/B 23.353 2756 67,021.94 26,808.78 3,250.00 375.70 1,495.00 5,100.30 104,051.71 7,957.46 9,740.24 12,049.47 587.73 85.23 135.85 30,555.98 134,607.69unfilled unfilled Fire Captain IAFF 184/D 33.921 2756 93,486.28 37,394.51 3,250.00 - 1,495.00 7,408.35 5,506.88 148,541.02 10,071.67 21,334.97 19,838.39 1,820.96 224.22 154.73 53,444.94 201,985.96NUN01 NUNO, JACOB Fire Engineer IAFF 171/A 24.521 2756 67,579.88 27,031.95 3,250.00 - 1,495.00 5,355.39 4,341.09 109,053.31 8,184.47 10,296.89 12,462.74 587.73 85.23 135.85 31,752.90 140,806.21 REY04 REYES, GUADALUPE Fire Engineer IAFF 171/B 25.747 2756 73,892.60 29,557.04 3,250.00 - 1,495.00 5,623.14 6,280.87 120,098.66 9,187.55 9,617.03 12,049.47 - - 135.85 30,989.90 151,088.56 SCH02 SCHMITZ, PATRICK Fire Captain IAFF 184/L1 33.921 2756 93,486.28 37,394.51 3,250.00 - 1,495.00 7,408.35 11,218.35 154,252.49 11,784.72 22,363.04 18,972.67 587.73 85.23 135.85 53,929.23 208,181.72 PCF's part time 25,000.00 1,912.50 25,000.00 0 0 0 0 1,912.50 26,912.50 what are PCF? temp - - - - - - - - - 0 0 00 - -
195,581.30 549,973.77 19,500.00 375.70 9,682.00 38,303.87 32,854.08 846,270.72 59,739.11 95,659.69 99,422.18 5,686.90 738.17 928.93 262,174.97 1,108,445.69 Estimated Costs Unfunded Liab Total
Reg 01-4220-0100 588,616.33 588,616.33
part time 01-4220-0125 25,000.00 25,000.00temp 01-4220-0150 - -overtime 01-4220-0200 195,581.30 195,581.30Retirement 01-4220-0250 94,930.28 52,645.98 147,576.26 Taxes 01-4220-0300 59,312.31 59,312.31
workers com 01-4220-0350 69,809.90 69,809.90
Insurance 01-4220-0400 96,263.88 96,263.88Benefits 01-4220-0450 8,970.00 8,970.00Def Comp 01-4220-0545 375.70 375.70Dental 01-4220-0560 5,475.56 5,475.56Vision 01-4220-0570 712.64 712.64 Life 001-4220-0570 928.93 928.93
Total 1,145,976.83 1,198,622.81
Diff 37,531.13
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 CostsFUE01 FUENTES, HANNAH Rec Services Manager unrep 35.521 2080 73,882.81 53.04 73,935.85 5,640.50 7,120.71 9,951.66 587.73 85.23 182.18 23,568.00 97,503.85 SCH03 SCHUBERT, EDWARD Lead Maint-Parks Facilities 28.563 2080 59,410.89 59,410.89 4,529.34 4,437.99 9,951.66 587.73 85.23 182.18 19,774.13 79,185.02 FIG01 FIGUEROA, MAYRA Facilities Coordinator SEIU part time 151/A 21.793 936 20,398.00 3,250.00 23,648.00 1,809.07 25,457.08 1,809.07Open Building Attendant 17.197 416 7,153.95 7,153.95 547.28 7,701.23 547.28 Open Building Attendant 17.197 416 7,153.95 7,153.95 547.28 7,701.23 547.28Open Building Attendant 17.197 416 7,153.95 7,153.95 547.28 7,701.23 547.28 - -
- 175,153.56 3,250.00 53.04 178,456.60 13,620.74 11,558.70 19,903.31 1,175.46 170.46 364.36 46,793.04 225,249.64 Estimated Costs Unfunded Liab Total
Reg 01-4300-0100 179,604.01 179,604.01 2760.92
Part 01-4300-0125 21,461.86 21,461.86 2,753.08TEMP 01-4300-0150 - - 7.84Overtime 01-4300-0200 - - Retirement 01-4300-0250 14,053.58 262.05 14,315.63Taxes 01-4300-0300 15,332.74 15,332.74 workerscomp 01-4300-0350 9,824.34 9,824.34Insurance 01-4300-0400 24,879.14 24,879.14Def Comp 01-4300-0545 79.56 79.56 Dental 01-4300-0560 2,085.94 2,085.94Vision 01-4300-0570 282.57 282.57 Life 001-4300-0585 433.58 433.58
Total 268,037.31 268,299.36
Diff 42,787.67
8,584.71
Employer
6 Permit Dept
Base 0100 0100 0545 0450 0100 0100
Current Next Hrly rate Annual 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 CostsSAU01 SAUCEDO, ALICE RUTH Permit Technician SEIU 181/L2 max 35.705 2080 74,266.30 - 53.04 - - - 74,319.34 5,669.84 12,287.16 9,951.66 587.73 85.23 135.85 28,717.46 103,036.80 unfilled unfilled Associate Planner N/A 218/C N/A 40.012 2080 83,224.96 6,325.44 83,224.96 6,216.90 9,951.66 587.73 85.23 135.85 23,302.81 106,527.77 - 157,491.26 - 53.04 - - - 157,544.30 18,504.07 11,995.27 19,903.31 1,175.46 170.46 271.70 52,020.27 209,564.56 Estimated Costs Unfunded Liab Total
Reg 01-4405-0100 157,491.26 157,491.26
Retirement 01-4405-0250 18,504.07 23,537.76 42,041.83Taxes 01-4405-0300 11,995.27 11,995.27workers comp 01-4405-0350 8,614.77 8,614.77Insurance 01-4405-0400 19,903.31 19,903.31Benefits 01-4405-0450 - - Def Comp 01-4405-0545 53.04 53.04
Dental 01-4405-0560 1,175.46 1,175.46
Vision 01-4405-0570 170.46 170.46
Life 001-4405-0585 271.70 271.70
Total 218,179.33 241,717.09
Diff 8,614.77
Employer
7 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 other ben Gross Payroll Taxes PERS Medical Dental Vision Life Total Benefits CostsSAG01 SAGISI, JOSE Water Maintenance Operator SEIU 162A/C 27.846 2080 57,919.78 7,420.00 - 6,000.00 71,339.78 4,990.28 6,929.12 19,838.39 1,820.96 224.22 155.01 33,957.99 105,297.77 Open Water Maintenance Operator SEIU 162A/C 27.846 2080 57,919.78 7,420.00 - 6,000.00 71,339.78 4,990.28 6,929.12 19,838.39 1,820.96 224.22 155.01 33,957.99 105,297.77 VID01 VIDALES, JAIME Water Dept Supervisor SEIU 205A/D 44.411 2080 92,373.86 12,900.00 3,250.00 108,523.86 7,834.86 13,387.34 6,036.60 1,820.96 224.22 155.01 29,459.00 137,982.86 27,740.00 208,213.43 3,250.00 12,000.00 251,203.43 17,815.41 27,245.58 45,713.38 5,462.89 672.67 465.04 97,374.97 348,578.40 Estimated Costs Unfunded Liab Total
Reg 10-4420-0100 280,845.36 280,845.36 4005.53
temp 10-4420-0150 71,339.78 71,339.78 3,770.63
OT 10-4420-0200 27,740.00 27,740.00 234.90
Retirement 10-4420-0250 35,976.62 42,427.82 78,404.44
Taxes 10-4420-0300 22,558.47 22,558.47
workers comp10-4420-0350 15,362.24 15,362.24
Insurance 10-4420-0400 57,966.62 57,966.62
other ben 10-4420-0450 12,000.00 12,000.00
Dental 10-4420-0560 6,500.13 6,500.13
Vision 10-4420-0570 804.38 804.38
Life 10-4420-0585 615.53 615.53
531,709.14 574,136.96183,130.74
82,889.16
Employer
8 Wastewater Dept
Base
Current Next Hrly rate Annual Regular pager Total Total ID Employee Position Union Step Increase at 7/1 Hours Cost OT Bilgl def comp other ben Gross Payroll Taxes PERS Medical Den Vis Life Total Benefits CostsVAL01 VALDIVIA, DEVIN WWTP Operator II SEIU 188A 31.487 2080 65,493.17 9,400.00 - - 6,000.00 80,893.17 6,176.79 6,492.38 9,951.66 587.73 85.23 135.85 23,429.63 104,322.80 MIK01 MIKLAS, DAVID WWTP Supervisor SEIU 205A/B 38.362 2080 79,793.69 16,500.00 - - 6,000.00 102,293.69 6,978.99 7,560.63 19,838.39 1,820.96 224.22 155.01 36,578.21 138,871.89 VAR01 VARGAS, EVERARDO WWTP Operator II SEIU 31.487 2080 65,493.17 9,400.00 - - 6,000.00 80,893.17 6,176.79 6,492.38 9,951.66 587.73 85.23 135.85 23,429.63 104,322.80 Want Unfilled WWTP Operator II 31.487 2080 65,493.17 9,400.00 - - 6,000.00 80,893.17 6,176.79 6,492.38 9,951.66 587.73 85.23 135.85 23,429.63 104,322.80 44,700.00 276,273.19 - - 24,000.00 344,973.19 25,509.36 27,037.77 49,693.36 479.91 3,584.15 562.56 106,867.11 451,840.30 remaining costs unfunded liab Total
Reg 12-4425-0100 345,655.12 345,655.12 1535.12
OT 12-4425-0200 44,700.00 44,700.00 1,529.32
Retirement 12-4425-0250 35,768.80 14,990.65 50,759.45 5.80 Taxes 12-4425-0300 30,252.41 30,252.41
workerscomp 12-4425-0350 18,907.34 18,907.34
Insurance 12-4425-0400 61,946.60 61,946.60
other ben 12-4425-0450 24,000.00 24,000.00
def comp 12-4425-0545 - -Dental 12-4425-0560 4,621.40 4,621.40 Vision 12-4425-0570 611.62 611.62
Life 12-4425-0585 713.06 713.06
582,167.00 567,176.35
115,336.05
15,094.47
total unfunded liab 358,315.41 total workers comp 346,463.64 workers comp council not in this workbook 29,239.64 Employer
9 EXHIBIT E
Base Pay Allocation Dept
Name Department % Amt as of % 196,659.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 91,546.86 15.09% 29,679.54 VERONICA FABIAN 01 4120 0250 60,799.54 10.02% 19,711.24 49,390.78 Police
MERAZ, JOSUE, I 01 4200 0250 100% 62,079.79 62,079.79 10.23% 20,126.30
0.00 0.00 0.00% 0.00
0.00 0.00 0.00% 0.00
62,079.79 Ͳ s/b zero
01 4105ͲAdmin
MERINOͲESCOBAR, JUANA 01 4105 0250 84,693.36 13.96% 27,457.63 Various
VIDALES, JAIME, N 10 4420 0250 85,408.92 14.08% 27,689.62 PENA, MICHAEL, R 10 4420 0250 30% 0.00 0.00 0.00% 0.00 71 4454 0250 30% 0.00 0.00 0.00% 0.00
12 4425 0250 30% 0.00 0.00 0.00% 0.00
01 4145 0250 5% 0.00 0.00 0.00% 0.00
01 4300 0250 5% 0.00 0.00 0.00% 0.00
SWEENEY, SHANNON 10 4420 0250 30% 44,990.40 44,990.40 7.42% 14,585.91 71 4454 0250 30% 44,990.40 44,990.40 7.42% 14,585.91 12 4425 0250 30% 44,990.40 44,990.40 7.42% 14,585.91 23 4461 0250 5% 7,498.40 7,498.40 1.24% 2,430.99
23 4461 0250 5% 7,498.40 7,498.40 1.24% 2,430.99
149,968.00 Ͳ s/b zero
12 4425ͲWastewater
12 4425 0250 0.00% 0.00
Fire
SAUCEDO, ALICE, R 01 4405 0250 100% 72,100.33 72,100.33 11.89% 23,374.96 01 4220 0250 0% 0.00 0.00 0.00% 0.00
72,100.33 Ͳ s/b zero
01 4200 Police
01 4200 0250 0.00% 0.00
Total 606,596.8 100.00% 196,659.00 Ͳ s/b zero 100.00% Ͳ s/b zero
Allocation
01 4105 0250 27,457.63 MOMS # Base Pay ESTIMATE ANNUAL
01 4120 0250 49,390.78 GUZ01 C. Guzman Ͳ
01 4145 0250 0.00
01 4200 0250 20,126.30 PER01 A. Leon 91,546.86 01 4220 0250 0.00
01 4300 0250 0.00 MER02 J. Meraz 62,079.79 01 4405 0250 23,374.96
10 4420 0250 42,275.53 MER01 J. Escobar 84,693.36 12 4425 0250 14,585.91 FAB01 V. Fabian 60,799.54 23 4461 0250 4,861.97
71 4454 0250 14,585.91 VID01 J. Vidales 85,408.92 Total 196,659.00 PEN01 M. Pena Ͳ
SWE01 S. Sweeney 149,968.00
0.00 SAU01 A Saucedo 72,100.33
TOTAL 606,596.80
340,056.00 3,654,282.39
City of Guadalupe
CalPers Monthly Employer Unfunded Liability Allocation
Class 1169 (ClassicͲMiscellaneous)
Fiscal Year 22Ͳ23 estimate
N:\2022-2023 Budget\Workpapers\addressed\Contribution Detail Report-Unfunded Liab est FY2023 6/8/2022
Base Pay Allocation Dept
Name Department Amt as of % 136,295.00 Total
MOMS # est 2022
LIMON, CARLOS, H 01 4200 0250 LIM02 123,160.15 25.22% 34,374.88 IWASKO, STEVEN, D 01 4200 0250 IWA02 85,860.96 17.58% 23,964.41 MEDINA, FRANK 01 4200 0250 MED01 94,991.21 19.45% 26,512.73 84,852.02 SCHMITZ, PATRICK, B 01 4220 0250 SCH02 89,909.51 18.41% 25,094.39 GARCIA, FERNANDO 01 4220 0250 GAR03 94,403.14 19.33% 26,348.59 51,442.98 Total 488,324.97 100.00% 136,295.00 ######
Allocation
01 4200 0250 84,852.02
01 4220 0250 51,442.98
Total 136,295.00
City of Guadalupe
CalPers Monthly Employer Unfunded Liability Allocation
Class 1170 (Classic-Safety)
Fiscal Year 22Ͳ23 estimate
N:\2022-2023 Budget\Workpapers\addressed\Contribution Detail Report-Unfunded Liab est FY2023 6/8/2022
Base Pay Allocation Dept
PEPRA Misc 26751 Amt as of % 2,559.00 Total
est 2023
% MOMS #
Bodem, Todd 01 4105 0250 BOD01 137,500.48 10.72% 274.21 HR 01 4105 0250 79,977.93 6.23% 159.49
Zarate, Lorena 01 4120 0250 ZAR01 108,003.10 8.42% 215.38 Rivas, Isaias 01 4120 0250 RIV01 68,666.06 5.35% 136.94 Gutierrez, Rudy 71 4454 0250 80% GUT01 48,258.79 3.76% 96.24 60,323.49 01 4145 0250 10% 6,032.35 0.47% 12.03
01 4300 0250 10% 6,032.35 0.47% 12.03
Batalla, james 71 4454 0250 80% bat01 38,176.51 2.98% 76.13 47,720.64 01 4145 0250 10% 4,772.06 0.37% 9.52
01 4300 0250 10% 4,772.06 0.37% 9.52
New eng tech 71 4454 0250 33% new 20,799.91 1.62% 41.48 62,405.97 10 4420 0250 33% 20,799.91 1.62% 41.48
12 4425 0250 33% 20,799.91 1.62% 41.48
Montero, Juan 01 4300 0250 50% new 21,739.51 1.69% 43.35 43,479.02 01 4145 0250 50% 21,739.51 1.69% 43.35
new lead 01 4300 0250 50% new 28,839.92 2.25% 57.51
57,679.84 01 4145 0250 50% 28,839.92 2.25% 57.51
Fuentes, Hannah 01 4300 0250 FUE01 70,022.58 5.46% 139.64 new assoc planner 01 4405 0250 new 81,638.29 6.36% 162.80 Sagisi, Jose 10 4420 0250 SAG01 55,566.28 4.33% 110.81
Miklas, David 12 4425 0250 MIK01 77,468.97 6.04% 154.49 Valdivia, Devin 12 4425 0250 VAL01 63,089.22 4.92% 125.81 Vargas 12 4425 0250 new 41,600.00 3.24% 82.96
Bribriesca, Norma 01 4200 0250 BRI01 77,996.11 6.08% 155.54 emergency 01 4200 0250 new 77,749.84 6.06% 155.05
Mendosa, Joana 01 4200 0250 MEN01 72,328.33 5.64% 144.24 Total ######### 100.0% 2,559.00
PEPRA Safety 25554 & 25555 Allocation
3,340.00
Police MOMS #
unfilled 01 4200 0250 new 67,273.50 6.89% 230.25
unfilled 01 4200 0250 new 70,637.07 7.24% 241.76
Wright 01 4200 0250 wri01 85,859.68 8.80% 293.86
Kuhbander 01 4200 0250 kuh01 85,178.25 8.73% 291.53
Cash, Michael 01 4200 0250 CAS01 137,207.87 14.06% 469.60 Lenehan, Cian 01 4200 0250 LEN01 76,026.33 7.79% 260.21 Miller, Heath 01 4200 0250 MIL03 81,123.32 8.31% 277.65 Negranti, Maria 01 4200 0250 NEG01 81,772.30 8.38% 279.87 Orozco, Chris 01 4200 0250 ORO01 73,876.84 7.57% 252.85 Ruiz, Edwin 01 4200 0250 RUI03 72,404.51 7.42% 247.81
Ruiz, Omar 01 4200 0250 RUI01 71,816.53 7.36% 245.80
Jaimes, Miguel 01 4200 0250 JAI01 72,698.84 7.45% 248.82 975,875.04 sub-total 3,340.00
Fire 1,203.00
Mack, Ryan 01 4220 0250 MAC01 89,908.43 29.94% 360.20
Garcia, Isaac 01 4220 0250 GAR07 71,062.67 23.67% 284.70 Nuno, Jacob 01 4220 0250 NUN01 68,241.90 22.73% 273.40
Reyes, Guadalupe 01 4220 0250 REY04 71,062.67 23.67% 284.70 300,275.67 sub-total 1,203.00
Total 1,276,150.71 200.0% 4,543.00
Allocation PEPRA Misc
01 4105 0250 433.70
01 4120 0250 352.32
71 4454 0250 213.85
01 4145 0250 122.41
01 4300 0250 262.05
01 4405 0250 162.80
10 4420 0250 152.29
12 4425 0250 404.74
01 4200 0250 454.83
Total 2,559.00
0.00 Allocation PEPRA Safety
01 4200 0250 3,340.00
01 4220 0250 1,203.00
Total 4,543.00
0.00 340,056.00
City of Guadalupe
CalPers Monthly Employer Unfunded Liability Allocation
Fiscal Year 22Ͳ23 estimate
Class 26751 and 25554/25555 (PEPRA)
N:\2022-2023 Budget\Workpapers\addressed\Contribution Detail Report-Unfunded Liab est FY2023 6/8/2022
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 358CCWA 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
GENERAL FUND REIMBURSEMENT TRANSFERS Table 7
2022-23
Per Cost
Per Estimate Allocation Imposed
Table 2 Plan Limitation* Variance Use
Special Revenue Funds
Street & Roads Funds 126,300 27,900 98,400 126,300
Lighting and Landscape Maintenance 9,800 12,700 2,900 12,700 CDBG - Microenterprise - - -
Enterprise Funds
Water Fund Operating 335,200 19,600 315,600 335,200
Wastewater Fund Operating 272,000 45,400 226,600 272,000 Transit Fund 35,000 76,200 41,200 76,200
Successor Agency per 22-23 ROPS 188,872 - 188,872 188,872 Total $874,272 $1,011,272 $137,000 $1,011,272* Not currently allowed by funding sources need approval by the Department of Transportation - 24 -
EXHIBIT G
Healthier communities through leadership, partnership & science MGT Analysis – Full Cost Recovery
EXHIBIT H