|
County of Hawaii
<br /> SHOPO Bargaining Unit 12-Cost Increases
<br /> July 1,2021 (FY2022)through June 30,2025(FY2025)
<br /> Annual Effect on
<br /> Payroll Cost Base Pay
<br /> Base pay at 6/30/21 $ 43,324,488 $ 43,324,488
<br /> FY2022: Step movements,7/1/21-6/30/22 224,377 434,484
<br /> Total payroll cost in FY 2021-22 $ 43,548,865
<br /> Base pay at6/30/22 $ 43,758,972 C
<br /> Base pay at 6/30/22 $ 43,758,972 $ 43,758,972
<br /> FY2023: Across-the-board increase of 5.0%on July 1,2022 2,187,949 2,187,949
<br /> Step movements,7/1/22-6/30/23 237,755 407,124
<br /> Total payroll cost in FY 2022-23 $ 46,184,676
<br /> Base pay at 6/30/23 $ 46,354,045
<br /> Base pay at 6/30/23 $ 46,354,045 $ 46,354,045
<br /> FY2024: Across-the-board increase of 5.0%on July 1,2023 2,297,347 2,297,347
<br /> Step movements,7/1/23-6/30/24 310,962 566,532
<br /> Total payroll cost in FY 2023-24 $ 48,962,354
<br /> Base pay at 6/30/24 $ 49,217,924
<br /> i
<br /> Base pay at 6/30/24 $ 49,217,924 $ 49,217,924
<br /> FY2025: Across-the-board increase of 5.0%on July 1,2024 2,432,570 2,432,570 I
<br /> Step movements,7/1/24-6/30/25 304,513 562,236
<br /> One-time lump sum bonus on July 1,2024 783,050 -
<br /> Total payroll cost in FY 2024-25 $ 52,738,057
<br /> i
<br /> Base pay at 6/30/25 52,212,730 {
<br /> Less base pay at 6/30/21 (43,324,488)
<br /> Increase to base pay over term of contract $ 8,888,242
<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:
<br /> Total payroll cost for fiscal year as per above calculations $ 43,548,865 $ 46,184,676 $ 48,962,354 $ 52,738,057
<br /> Less base pay at beginning of fiscal year 43,324,488 43,758,972 46,354,045 49,217,924
<br /> Total additional cost 224,377 2,425,704 2,608,309 3,520,133 $ 8,778,523
<br /> Add affect of prior year increase in base pay - 434,484 3,029,557 5,893,436 9,357,477
<br /> Total increased cost subject to fringe benefits 224,377 2,860,188 5,637,866 9,413,569 18,136,000
<br /> Certain fringe benefit costs(65.68%) 147,371 1,878,571 3,702,950 6,182,832 11,911,724
<br /> Increased costs to be paid during fiscal years 2022 to 2025 371,748 4,738,759 9,340,816 15,596,401 30,047,724
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 47,119 600,639 1,183,952 1,976,849 3,808,559
<br /> Total increased costs 418,867 5,339,398 10,524,768 17,573,250 33,856,283
<br /> *Fringe benefits included are overtime,premium pay,hazard pay,standby,temporary assignment,compensatory time,
<br /> retirement system,workers'compensation,and unemployment compensation.
<br />
|