|
County of Hawaii
<br />Bargaining Unit 61 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 FYI 8
<br />Base pay at 6/30/18
<br />Base pay at 6/30/18
<br />FY 19: $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 (32.33%)*
<br />Increased costs to be paid during fiscal years 2018-21
<br />Vacation, sick leave and holidays (21 % of total increased cost subject
<br />2018-21 BU61
<br />Annual Affect on
<br />Payroll Cost Base Pay
<br />$ 450,144 $ 450,144
<br />10,000 -
<br />1,201 14,405
<br />461,345
<br />464,549
<br />464,549 464,549
<br />10,000 -
<br />2,672 16,027
<br />$ 477,221
<br />$ 480,576
<br />480,576 480,576
<br />9,612 9,612
<br />$ 490,188
<br />$ 490,188
<br />490,188 490,188
<br />9,804 9,804
<br />$ 499,992
<br />$ 499,992
<br />(450,144)
<br />$ 49,848
<br />FY18
<br />FY19
<br />FV20
<br />FY21
<br />Total
<br />2017-18
<br />2018-19
<br />2019-20
<br />20( 20-21)
<br />FY18-FY21
<br />$ 461,345
<br />$ 477,221
<br />$ 490,188
<br />$ 499,992
<br />450,144
<br />464,549
<br />480,576
<br />490,188
<br />11,201
<br />12,672
<br />9,612
<br />9,804
<br />$ 43,289
<br />-
<br />14,405
<br />30,432
<br />40,044
<br />$ 84,881
<br />11,201
<br />27,077
<br />40,044
<br />49,848
<br />$ 128,170
<br />3,621
<br />8,754
<br />12,946
<br />16,116
<br />41,437
<br />14,822
<br />35,831
<br />52,990
<br />65,964
<br />169,607
<br />to fringe benefits) 3,113 7,525 11,128 13,852 35,617
<br />Total increased costs $ 17,935 $ 43,356 $ 64,118 $ 79,816 $ 205,225
<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 />
|