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