|
2018-21 BU1
<br /> County of Hawaii
<br /> Bargaining Unit 01 Settlement Costs
<br /> July 1,2017(FY18)through June 30,2021(FY21) •
<br /> Annual Affect on
<br /> Payroll Cost Base Pay
<br /> Effect on payroll:
<br /> Base pay at 6/30/17 $ 28,608,876 $ 28,608,876
<br /> FY18: $1,000 Lump Sum effective November 1,2017 610,100 -
<br /> 3.20%across-the-board(ATB)increase effective June 1,2018 76,291 915,485
<br /> Total payroll cost in FY18 29,295,267
<br /> Base pay at 6/30/18 29,524,361
<br /> Base pay at 6/30/18 29,524,361 29,524,361
<br /> FY19: $1,000 Lump Sum effective November 1,2018 610,100 -
<br /> 3.45%across-the-board(ATB)increase effective May 1,2019 169,766 1,018,591
<br /> Total payroll cost in FY19 $ 30,304,227
<br /> Base pay at 6/30/19 $ 30,542,952
<br /> Base pay at 6/30/19 30,542,952 30,542,952
<br /> FY20: 2.00%across-the-board(ATB)increase effective July 1,2019 610,860 _ 610,860
<br /> Total payroll cost in FY20 $ 31,153,812
<br /> Base pay at 6/30/20 $ 31,153,812
<br /> Base pay at 6/30/20 31,153,812 31,153,812
<br /> FY21: 2.00%across-the-board(ATB)increase effective July 1,2020 _ 623,077 623,077
<br /> Total payroll cost in FY21 $ 31,776,889
<br /> Base pay at 6/30/21 $ 31,776,889
<br /> Less base pay at 6/30/17 (28,608,876)
<br /> Increase to base pay due to this settlement $ 3,168,013
<br /> FY18 FY19 FY20 FY21 Total
<br /> (2017-18) (2018-19) (2019-20) (2020-21) FY18-FY21
<br /> Determination of total increase in cost due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $ 29,295,267 $ 30,304,227 $ 31,153,812 $ 31,776,889
<br /> Less base pay at beginning of fiscal year 28,608,876 29,524,361 30,542,952 31,153,812
<br /> Total additional cost 686,391 779,866 610,860 623,077 $ 2,700,194
<br /> Add affect of prior year increase in base pay _ - 915,485 1,934,076 2,544,936 5,394,497
<br /> Total increased cost subject to fringe benefits 686,391 1,695,351 2,544,936 3,168,013 8,094,691
<br /> Certain fringe benefit costs(41.84%)* 287,186 709,335 1,064,801 1,325,497 3,386,819
<br /> Increased costs to be paid during fiscal years 2018-21 973,577 2,404,686 3,609,737 4,493,510 11,481,510
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 204,451 _ 504,984 758,045 943,637 2,411,117
<br /> Total increased costs $ 1,178,028 $ 2,909,670 $ 4,367,782 $ 5,437,147 $ 13,892,627
<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 /> •
<br /> Page 1
<br />
|