|
BU03
<br /> County of Hawaii
<br /> Bargaining Unit 03 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/30/21 $ 24,639,300 $ 24,639,300
<br /> FY22: Lump sum payment effective July 1,2021 687,750 -
<br /> Total payroll cost in FY22 $ 25,327,050
<br /> Base pay at 6/30/22 $ 24,639,300
<br /> Base pay at 6/30/22 $ 24,639,300 24,639,300
<br /> FY23: 3.72%ATB effective October 1,2022 687,437 916,582
<br /> Total payroll cost in FY23 $ 25,326,737
<br /> Base pay at 6/30/23 $ 25,555,882
<br /> Base pay at 6/30/23 $ 25,555,882 25,555,882
<br /> FY24: 5.00%ATB effective July 1,2023 1,277,795 1,277,795
<br /> Total payroll cost in FY24 $ 26,833,677
<br /> Base pay at 6/30/24 $ 26,833,677
<br /> Base pay at 6/30/24 $ 26,8337677 26,833,677
<br /> FY25: 5.00%ATB effective July 1,2024 1,341,684 1,341,684
<br /> Total payroll cost in FY25 $ 28,175,361
<br /> Base pay at 6/30/25 $ 28,175,361
<br /> Less base pay at 6/30/21 (24,639,300}
<br /> Increase to base pay due to this settlement $ 3,536,061
<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: al
<br /> Total payroll cost for fiscal year as per above calculations $ 25,327,050 $ 25,326,737 $ 26,833,677 $ 28,175,361
<br /> Less base pay at beginning of fiscal year 24,639,300 24,639,300 25,555,882 26,833,677
<br /> Total additional cost 687,750 687,437 1,277,795 1,341,684 $ 3,994,666
<br /> Add affect of prior year increase in base pay - - 916,582 2,194,377 3,110,959 3
<br /> Total increased cost subject to fringe benefits 687,750 687,437 2,194,377 3,536,061 7,105,625
<br /> Certain fringe benefit costs(38.94%)* 267,810 267,688 854,490 1,376,942 2,766,930
<br /> 7
<br /> Increased costs to be paid during fiscal years 2022-25 955,560 955,125 3,048,867 4,913,003 9,872,555
<br /> !i
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 144,428 144,362 460,819 742,573 1,492,182
<br /> Total increased costs $ 1,099,988 $ 1,099,487 $ 3,509,686 $ 5,655,576 $ 11,364,737
<br /> i
<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 /> 'I
<br /> i
<br /> Page 2
<br />
|