|
BU11
<br /> County of Hawaii
<br /> Bargaining Unit 11 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: l
<br /> Base pay at 6130121 $ 29,428,884 $ 29,428,884
<br /> FY22: Catch up step movements,711/21 $ 6,576 $ 6,576
<br /> Catch up step movements,711/21-6/30/22 $ 36,308 $ 66,780 j
<br /> Continue step movements,711/21-6/30122 80,785 183,348
<br /> Total payroll cost in FY22 $ 29,552,553
<br /> Base pay at 6/30122 $ 29,685,588
<br /> Base pay at 6/30/22 $ 29,685,588 29,685,588
<br /> FY23: 3.00%ATB effective July 1,2022 890,568 890,568
<br /> Catch up step movements,7/1/22-6/30/23 2,925 3,900
<br /> Continue step movements,7/1/22-6/30/23 277,618 456,672
<br /> Total payroll cost in FY23 $ 30,856,699
<br /> Base pay at 6/30/23 $ 31,036,728
<br /> Base pay at 6/30/23 $ 31,036,728 31,036,728
<br /> FY24: 4.00%ATB effective July 1,2023 1,241,470 1,241,470
<br /> Catch up step movements,7/1/23-6/30/24 - -
<br /> Continue step movements,7/1/23-6/30/24 242,994 490,788
<br /> Total payroll cost in FY24 $ 32,521,192
<br /> Base pay at 6/30/24 $ 32,768,986
<br /> i
<br /> Base pay at 6/30/24 $ 32,768,986 32,768,986
<br /> FY25: 4.00%ATB effective July 1,2024 1,310,760 1,310,760
<br /> Catch up step movements,7/1/24-6/30/25 - -
<br /> Continue step movements,7/1/24-6/30/25 95,487 95,487
<br /> Total payroll cost in FY25 $ 34,175,233
<br /> Base pay at 6/30/25 $ 34,175,233
<br /> Less base pay at 6/30/21 (29,428,884)
<br /> Increase to base pay due to this settlement $ 4,746,349
<br /> I
<br /> FY22 FY23 FY24 FY25 Total
<br /> (2021-2 20( 22-23� 24t 23.24) 20( 24-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 $ 29,552,553 $ 30,856,699 $ 32,521,192 $ 34,175,233
<br /> Less base pay at beginning of fiscal year 29,428,884 29,685,588 31,036,728 32,768,986
<br /> Total additional cost 123,669 1,171,111 1,484,464 1,406,247 $ 4,185,491
<br /> Add affect of prior year increase in base pay - 256,704 1,607,844 3,340,102 5,204,650
<br /> Total increased cost subject to fringe benefits 123,669 1,427,815 3,092,308 4,746,349 9,390,141
<br /> Certain fringe benefit costs(73.24%)* 90,575 1,045,732 2,264,806 3,476,226 6,877,339
<br /> Increased costs to be paid during fiscal years 2022-25 214,244 2,473,547 5,357,114 8,222,575 16,267,480
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 25,970 299,841 649,385 996,733 1,971,929
<br /> Total increased costs $ 240,214 $ 2,773,388 $ 6,006,499 $ 9,219,308 $ 18,239,409
<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 />
|