|
i
<br /> I
<br /> BU63
<br /> i
<br /> County of Hawaii
<br /> Bargaining Unit 63 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 $ 3,091,356 $ 3,091,356
<br /> FY22: Lump sum payment effective July 1,2021 67,750 - j
<br /> i
<br /> Total payroll cost in FY22 $ 3,159,106
<br /> Base pay at 6(30122 $ 3,091,356
<br /> ,i
<br /> Base pay at 6/30122 $ 3,091,356 3,091,356
<br /> FY23: 3.72%ATB effective October 1,2022 86,249 114,999
<br /> Total payroll cost in FY23 $ 3,177,605
<br /> Base pay at 6(30123 $ 3,206,355
<br /> i
<br /> j
<br /> Base pay at 6130/23 $ 3,206,355 3,206,355
<br /> FY24: 5.00%ATB effective July 1,2023 160,318 160,318
<br /> Total payroll cost in FY24 $ 3,366,673
<br /> Base pay at 6/30(24 $ 3,366,673
<br /> Base pay at 6(30/24 $ 3,366,673 3,366,673
<br /> FY25: 5.00%ATB effective July 1,2024 168,334 168,334
<br /> Total payroll cost in FY25 $ 3,535,007
<br /> Base pay at 6130125 $ 3,535,007
<br /> Less base pay at 6130121 (3,091,356)
<br /> Increase to base pay due to this settlement $ 443,651
<br /> FY22 FY23 FY24 FY25 Total
<br /> (2021-22) 20( 22-23j 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 $ 3,159,106 $ 3,177,605 $ 3,366,673 $ 3,535,007
<br /> Less base pay at beginning of fiscal year 3,091,356 3,091,356 3,206,355 3,366,673
<br /> Total additional cost 67,750 86,249 160,318 168,334 $ 482,651
<br /> Add affect of prior year increase in base pay - - 114,999 275,317 390,316
<br /> Total increased cost subject to fringe benefits 67,750 86,249 275,317 443,651 872,967
<br /> Certain fringe benefit costs(39.26%)* 26,599 33,861 108,089 174,177 342,726
<br /> Increased costs to be paid during fiscal years 2022-25 94,349 120,116 383,406 617,828 1,215,693
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 14,228 18,112 57,817 93,167 183,324
<br /> Total increased costs $ 108,577 $ 138,222 $ 441,223 $ 710,995 $ 1,399,017
<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 5
<br />
|