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