|
County of Hawaii
<br /> SHOPO Bargaining Unit 36-Cost Increases
<br /> July 1,2017(FY2018)through June 30,2021 (FY2021)
<br /> Annual Effect on
<br /> Payroll Cost Base Pay
<br /> Base pay at 6/30/17 $ 2,289,276 $ 2,289,276
<br /> FY2018: Across-the-board increase of 2.0%on July 1,2017 45,786 45,786
<br /> WIRP 7/1/17-6/30/18 7,511 14,340
<br /> Total payroll cost in FY 2017-18 $ 2,342,573
<br /> Base pay at 6/30/18 $ 2,349,402
<br /> Base pay at 6/30/18 $ 2,349,402 $ 2,349,402
<br /> FY2019: Across-the-board increase of 2.25%on July 1,2018 52,862 52,862
<br /> WIRP 7/1/18-6/30/19 4,852 10,188
<br /> Total payroll cost in FY 2018-19 $ 2,407,116
<br /> Base pay at 6/30/19 $ 2,412,452
<br /> Base pay at 6/30/19 $ 2,412,452 $ 2,412,452
<br /> FY2020: Across-the-board increase of 2.0%on July 1,2019 48,250 48,250
<br /> WIRP 7/1/19-6/30/20 767 1,416
<br /> One-time lump sum bonus(P07 to P015) 36,000 -
<br /> Total payroll cost in FY 2019-20 $ 2,497,469
<br /> Base pay at 6/30/20 $ 2,462,118
<br /> Base pay at 6/30/20 $ 2,462,118 $ 2,462,118
<br /> FY2021: Across-the-board increase of 2.0%on July 1,2020 49,243 49,243
<br /> WIRP 7/1/20-6/30/21 2,526 4,524
<br /> One-time lump sum bonus(P07 to P015) 36,000 -
<br /> One-time lump sum bonus(28 yrs&L5) 7,000 -
<br /> Total payroll cost in FY 2020-21 $ 2,556,887
<br /> Base pay at 6/30/21 2,515,885
<br /> Less base pay at 6/30/17 (2,289,276)
<br /> Increase to base pay over term of contract $ 226,609
<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 $ 2,342,573 $ 2,407,116 $ 2,497,469 $ 2,556,887
<br /> Less base pay at beginning of fiscal year 2,289,276 2,349,402 2,412,452 2,462,118
<br /> Total additional cost 53,297 57,714 85,017 94,769 $ 290,797
<br /> Add affect of prior year increase in base pay - 60,126 123,176 172,842 356,144
<br /> Total increase in regular pay 53,297 117,840 208,193 267,611 646,941
<br /> Non-wage cost items:
<br /> Increase firearm maintenance allowance from
<br /> $500 to$1,000 per fiscal year,7/01/17 9,000 9,000 9,000 9,000 36,000
<br /> Total increased cost subject to fringe benefits 62,297 126,840 217,193 276,611 682,941
<br /> Certain fringe benefit costs(32.13%) 20,016 40,754 69,784 88,875 219,429
<br /> Increased costs to be paid during fiscal years 2018 to 2021 82,313 167,594 286,977 365,486 902,370
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 13,082 26,636 45,611 58,088 143,417
<br /> Total increased costs 95,395 194,230 332,588 423,574 1,045,787
<br /> *Fringe benefits included are overtime,premium pay,hazard pay,standby,temporary assignment,compensatory time,
<br /> retirement system,workers'compensation,and unemployment compensation.
<br />
|