|
i
<br /> i
<br /> I
<br /> BU04
<br /> County of Hawaii
<br /> Bargaining Unit 04 Settlement Costs
<br /> July 1,2021 (FY22)through June 30,2025(FY25)
<br /> Annual Affect on
<br /> Payroll Cost Base Pav
<br /> Effect on payroll:
<br /> Base pay at 6/30121 $ 2,971,896 $ 2,971,896
<br /> FY22: Lump sum payment effective July 1,2021 29,719 -
<br /> Total payroll cost in FY22 $ 3,001,615
<br /> Base pay at 6130122 $ 2,971,896
<br /> I
<br /> Base pay at 6/30122 $ 2,971,896 2,971,896
<br /> FY23: 3,72%ATB affective July 1,2022
<br /> 110,556 110,556 i
<br /> Total payroll cost in FY23 $ 3,082,452
<br /> Base pay at 6/30/23 $ 3,082,452
<br /> Base pay at 6/30/23 $ 3,082,452 3,082,452
<br /> FY24: 4.96%ATB effective July 1,2023 152,892 152,892
<br /> Total payroll cost in FY24 $ 3,235,344
<br /> Base pay at 6/30/24 $ 3,235,344
<br /> Base pay at 6/30/24 $ 3,235,344 3,235,344
<br /> FY25: 5.00%ATB effective July 1,2024 161,772 161,772
<br /> Total payroll cost in FY25 $ 3,397,116
<br /> Base pay at 6/30/25 $ 3,397,116
<br /> Less base pay at 6/30121 (2,971,896}
<br /> Increase to base pay due to this settlement $ 425,220
<br /> i
<br /> FY22 FY23 FY24 FY25 Total
<br /> a
<br /> 2021-22 2022-23 2023-24 20j 24-25) FY22-FY25
<br /> Determination of total increase in cast due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $ 3,001,615 $ 3,082,452 $ 3,235,344 $ 3,397,116
<br /> Less base pay at beginning of fiscal year 2,971,896 2,971,896 3,082,452 3,235,344
<br /> Total additional cost 29,719 110,556 152,892 161,772 $ 454,939
<br /> Add affect of prior year increase in base pay - - 110,556 263,448 374,004
<br /> Total increase in regular pay 29,719 110,556 263,448 425,220 828,943
<br /> Non-wage cost items subject to fringe benefits:
<br /> Increase in uniform allowances 60 60 60 60 240
<br /> Increase in overtime meal rates 3,488 3,488 3,488 3,488 13,952
<br /> Total increased cost subject to fringe benefits 33,267 114,104 266,996 428,768 843,135
<br /> Certain fringe benefit costs(48.66%)* 16,188 55,523 129,920 208,639 410,270
<br /> Increased costs to be paid during fiscal years 2022-25 49,455 169,627 396,916 637,407 !,253,405
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 6,986 23,962 56,069 90,041 177,058
<br /> Total increased costs $ 56,441 $ 193,589 $ 452,985 $ 727,448 $ 1,430,463
<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 3
<br />
|