|
BU15
<br /> County of Hawaii
<br /> Bargaining Unit 15 Settlement Costs
<br /> July 1,2021(FY22)through June 30,2425(FY25)
<br /> Annual Affect on
<br /> Payroll Cost Base Pav
<br /> Effect on payroll.-
<br /> Base
<br /> ayroll:Base pay at 6130/21 $ 2,917,680 $ 2,917,680
<br /> FY22: 1%Lump sum payment effective July 1,2021 29,177 -
<br /> Step Movement 7/01121-6/30122 19,070 50,148
<br /> Total payroll cost in FY22 $ 2,965,927
<br /> Base pay at 6/30122 $ 2,967,828
<br /> Base pay at 6130122 $ 2,967,828 2,967,828
<br /> FY23: Step Movement 7101122-6130123 15,317 24,324
<br /> Total payroll cost in FY23 $ 2,983,145
<br /> Base pay at 6130123 $ 2,992,152
<br /> Base pay at 6130123 $ 2,992,152 2,992,152
<br /> FY24: 3.00%ATB effective July 1,2023 89,765 89,765
<br /> Step Movement 7101123-6/30124 24,615 34,728
<br /> Total payroll cost in FY24 $ 3,106,532
<br /> Base pay at 6130124 $ 3,116,645
<br /> Base pay at 6/30/24 $ 3,116,645 3,116,645
<br /> FY25: 4.00%ATB effective July 1,2024 124,666 124,666
<br /> Step Movement 7/01/24-6/30/25 6,190 61,704
<br /> Total payroll cost in FY25 $ 3,247,501
<br /> Base pay at 6/30/25 $ 3,303,015
<br /> Less base pay at 6/30/21 (2,917,680)
<br /> Increase to base pay due to this settlement $ 385,335
<br /> FY22 FY23 FY24 FY25 Total
<br /> 2021-22 2022-23 2023-24 2024-25 FY22-FY25
<br /> Determination of total increase in cost due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $ 2,965,927 $ 2,983,145 $ 3,106,532 $ 3,247,501
<br /> Less base pay at beginning of fiscal year 2,917,680 2,967,828 2,992,152 3,116,645
<br /> Total additional cost 48,247 15,317 114,380 130,856 $ 308,800
<br /> Add affect of prior year increase in base pay 50,148 74,472 198,965 323,585
<br /> Total increased cost subject to fringe benefits 48,247 65,465 188,852 329,821 632,385
<br /> Certain fringe benefit costs(38.70%)* 18,672 25,335 73,086 127,641 244,734
<br /> Increased costs to be paid during fiscal years 2022-25 66,919 90,800 261,938 457,462 877,119
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 10,132 13,748 39,659 69,262 132,801
<br /> Total increased costs $ 77,051 $ 104,548 $ 301,597 $ 526,724 $ 1,009,920
<br /> * Fringe benefits include estimates for overtime,premium pay,hazard pay,standby,temporary assignment,
<br /> compensatory time,retirement system,workers'compensation,and unemployment compensation.
<br /> Page 1
<br />
|