|
County of Hawaii 1
<br /> SHOPO Bargaining Unit 12-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 $ 36,328,896 $ 36,328,896
<br /> FY2018: Across-the-board increase of 2.0%on July 1,2017 726,578 726,578
<br /> Catch Up Step movements,7/1/17-6/30/18 808 3,876
<br /> Continue Step movements,7/1/17-6/30/18 268,065 464,448
<br /> Total payroll cost in FY 2017-18 $ 37,324,347
<br /> Base pay at 6/30/18 $ 37,523,798
<br /> Base pay at 6/30/18 $ 37,523,798 $ 37,523,798
<br /> FY2019: Across-the-board increase of 2.25%on July 1,2018 844,286 844,286
<br /> Step movements,7/1/18-6/30/19 248,109 477,336
<br /> Total payroll cost in FY 2018-19 $ 38,616,193
<br /> Base pay at 6/30/19 $ 38,845,420
<br /> Base pay at 6/30/19 $ 38,845,420 $ 38,845,420
<br /> FY2020: Across-the-board increase of 2.0%on July 1,2019 776,909 776,909
<br /> Step movements,7/1/19-6/30/20 244,180 427,656
<br /> One-time lump sum bonus(P07 to P015) 450,725 -
<br /> Total payroll cost in FY 2019-20 $ 40,317,234
<br /> Base pay at 6/30/20 $ 40,049,985
<br /> Base pay at 6/30/20 $ 40,049,985 $ 40,049,985
<br /> FY2021: Across-the-board increase of2.0%on July 1,2020 801,000 801,000
<br /> Step movements,7/1/20-6/30/21 282,439 488,820
<br /> One-time lump sum bonus(P07 to P015) 455,525 -
<br /> One-time lump sum bonus(28 yrs&L5) 11,000 -
<br /> Total payroll cost in FY 2020-21 $ 41,599,949
<br /> Base pay at 6/30/21 41,339,805
<br /> Less base pay at 6/30/17 (36,328,896)
<br /> Increase to base pay over term of contract $ 5,010,909
<br /> FY18 FY19 FY20 FY21 Total
<br /> (2017-18) (2018-19) (2019-20) (2020-21) FYI8-FY21
<br /> Determination of total increase in cost due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $ 37,324,347 $ 38,616,193 $ 40,317,234 $ 41,599,949
<br /> Less base pay at beginning of fiscal year 36,328,896 37,523,798 38,845,420 40,049,985
<br /> Total additional cost 995,451 1,092,395 1,471,814 1,549,964 $ 5,109,624
<br /> Add affect of prior year increase in base pay - 1,194,902 2,516,524 3,721,089 7,432,515
<br /> Total increase in regular pay 995,451 2,287,297 3,988,338 5,271,053 12,542,139
<br /> Non-wage cost items:
<br /> Increase firearm maintenance allowance from
<br /> $500 to$1,000 per fiscal year,7/01/17 241,000 241,000 241,000 241,000 964,000
<br /> Total increased cost subject to fringe benefits 1,236,451 2,528,297 4,229,338 5,512,053 13,506,139
<br /> Certain fringe benefit costs(40.12%) 496,064 1,014,353 1,696,810 2,211,436 5,418,663
<br /> Increased costs to be paid during fiscal years 2018 to 2021 1,732,515 3,542,650 5,926,148 7,723,489 18,924,802
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 259,655 530,942 888,161 1,157,531 2,836,289
<br /> Total increased costs 1,992,170 4,073,592 6,814,309 8,881,020 21,761,091
<br /> *Fringe benefits included are overtime,premium pay,hazard pay,standby,temporary assignment,compensatory time,
<br /> retirement system,workers'compensation,and unemployment compensation.
<br />
|