|
BU13
<br /> County of Hawaii
<br /> Bargaining Unit 13 Settlement Costs
<br /> July 1,2021(FY22)through June 30,2025(FY25)
<br /> Annual Affect on
<br /> Payroll Cost Base Pay
<br /> Effect on payroll:
<br /> Base pay at 6130121 $ 23,577,300 $ 23,577,300
<br /> FY22: 2%Lump sum payment effective July 1,2021 for those
<br /> on Step M or SRNA 3,476
<br /> Total payroll cost in FY22 $ 23,580,776
<br /> Base pay at 6130122 $ 23,577,300
<br /> Base pay at 6130/22 $ 23,577,300 23,577,300
<br /> FY23: Step movements effective July 1,2022 254,076 254,076
<br /> 2.00%ATB effective July 1,2022 476,628 476,628
<br /> Step movements from July 1,2022 to June 30,2023 157,413 298,038
<br /> Total payroll cost in FY23 $ 24,465,417
<br /> Base pay at 6130123 $ 24,606,042
<br /> Base pay at 6/30123 $ 24,606,042 24,606,042
<br /> FY24: 4.00%ATB effective July 1,2023 984,242 984,242
<br /> Step movements from July 1,2023 to June 30,2024 158,602 315,792
<br /> Total payroll cost in FY24 $ 25,748,886
<br /> Base pay at 6130124 $ 25,906,076
<br /> Base pay at 6130124 $ 25,906,076 25,906,076
<br /> FY25: 3.59%ATB effective July 1,2024 930,029 930,029
<br /> Step movements from July 1,2024 to June 30,2025 149,630 294,060
<br /> Total payroll cost in FY25 $ 26,985,735
<br /> Base pay at 6130125 $ 27,130,165
<br /> Less base pay at 6130121 (23,577,300)
<br /> Increase to base pay due to this settlement $ 3,552,865
<br /> FY22 FY23 FY24 FY25 Total
<br /> (2021-22) 20( 24-25) FY22-FY25
<br /> Determination of total increase to cost due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $ 23,580,776 $ 24,465,417 $ 25,748,886 $ 26,985,735
<br /> Less base pay at beginning of fiscal year 23,577,300 23,577,300 24,606,042 25,906,076
<br /> Total additional cost 3,476 888,117 1,142,844 1,079,659 $ 3,114,096
<br /> Add affect of prior year increase in base pay - - 1,028,742 2,328,776 3,357,518
<br /> Total increased cost subject to fringe benefits 3,476 888,117 2,171,586 3,408,435 6,471,614
<br /> Certain fringe benefit costs(38.54%)* 1,340 342,280 836,929 1,313,611 2,494,160
<br /> Increased costs to be paid during fiscal years 2022-25 4,816 1,230,397 3,008,515 4,722,046 8,965,774
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 730 186,505 456,033 715,771 1,359,039
<br /> Total increased costs $ 5,546 $ 1,416,902 $ 3,464,548 $ 5,437,817 $ 10,324,813
<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 4
<br />
|