|
County of Hawaii
<br /> SHOPO Bargaining Unit 12-Cost Increases
<br /> July 1,2011(FY2012)through June 30,2017(FY2017)
<br /> Annual Effect on
<br /> Payroll Cost Base Pay
<br /> Base pay at 6/30/11 $ 29,117,412 $ 29,117,412
<br /> FY2012: No increase - -
<br /> Total payroll cost in FY 2011-12 $ 29,117,412
<br /> Base pay at 6/30/12 $ 29,117,412
<br /> Base pay at 6/30/12 $ 29,117,412 $ 29,117,412
<br /> FY2013: No increase - -
<br /> Total payroll cost in FY 2012-13 $ 29,117,412
<br /> Base pay at 6/30/13 $ 29,117,412
<br /> Base pay at 6/30/13 $ 29,117,412 $ 29,117,412
<br /> FY20I4: Across-the-board increase of 1.75%on July 1,2013 509,555 509,555
<br /> Across-the-board increase of 1.75%on January 1,2014 259,236 518,472
<br /> Step movements,7/1/13-6/30/14 545,246 1,009,980
<br /> Total payroll cost in FY 2013-14 $ 30,431,449
<br /> Base pay at 6/30/14 $ 31,155,419
<br /> Base pay at 6/30/14 $ 31,155,419 $ 31,155,419
<br /> FY2015: Across-the-board increase of 1.75%on July 1,2014 545,220 545,220
<br /> Across-the-board increase of 1.75%on January I,2015 277,381 554,761
<br /> Step movements,7/1/14-6/30/15 215,150 411,456
<br /> Total payroll cost in FY 2014-15 $ 32,193,170
<br /> Base pay at 6/30/15 32,666,856
<br /> Base pay at 6/30/15 $ 32,666,856 $ 32,666,856
<br /> FY2016: Across-the-board increase of 2.00%on July 1,2015 653,337 653,337
<br /> Across-the-board increase of 2.00%on January 1,2016 333,202 666,404
<br /> Step movements,7/1/15-6/30/16 212,777 386,076
<br /> Total payroll cost in FY 2015-16 $ 33,866,172
<br /> Base pay at 6/30/16 34,372,673
<br /> Base pay at 6/30/16 $ 34,372,673 $ 34,372,673
<br /> FY2017: Across-the-board increase of 2.50%on July 1,2016 859,317 859,317
<br /> Across-the-board increase of 3.30%on January 1,2017 581,328 1,162,656
<br /> Step movements,7/1/16-6/30/17 187,762 187,762
<br /> Total payroll cost in FY 2016-17 $ 36,001,080
<br /> Base pay at 6/30/17 36,582,408
<br /> Less base pay at 6/30/11 (29,117,412)
<br /> Increase to base pay over term of contract $ 7,464,996
<br /> FY12 FY13 FY14 FY15 FY16 FY17 Total
<br /> (2011-12) (2012-13) (2013-14) (2014-15) (2015-16) (2016-17) FY12-FY17
<br /> Determination gftotal increase in cost due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $ 29,117,412 $ 29,117,412 $ 30,431,449 $32,193,170 $33,866,172 $36,001,080
<br /> Less base pay at beginning of fiscal year 29,117,412 29,117,412 29,117,412 31,155,419 32,666,856 34,372,673
<br /> Total additional cost - - 1,314,037 1,037,751 1,199,316 1,628,407 $ 5,179,511
<br /> Add affect of prior year increase in base pay - - - 2,038,007 3,549,444 5,255,261 10,842,712
<br /> Total increase in regular pay - - 1,314,037 3,075,758 4,748,760 6,883,668 16,022,223
<br /> Non-wage cost items:
<br /> Increase firearm maintenance allowance from
<br /> $420 to$500 per fiscal year,7/01/13 - - 37,680 37,680 37,680 37,680 150,720
<br /> Increase SOCD from$1.00 to$2.00/hour for P0-8&below,7/01/13 - - 559,520 559,520 559,520 559,520 2,238,080
<br /> Increase SOCD from$1.20 to$2.20/hour for P0-9&above,7/01/13 - - 420,160 420,160 420,160 420,160 1,680,640
<br /> Increase SOCD from$2.00 to$2.60/hour for P0-8&below,7/01/14 - - - 335,712 335,712 335,712 1,007,136
<br /> Increase SOCD from$2.20 to$2.80/hour for P0-9&above,7/01/14 - - - 252,096 252,096 252,096 756,288
<br /> Increase SOCD from$2.60 to$3.60/hour for P0-8&below,7/01/15 - - - - 559,520 559,520 1,119,040
<br /> Increase SOCD from$2.80 to$3.80/hour for P0-9&above,7/01/15 - - - - 420,160 420,160 840,320
<br /> Increase SOCD from$3.60 to$3.80/hour for P0-8&below,7/01/16 - - - - - 111,904 111,904
<br /> Increase SOCD from$3.80 to$4.00/hour for P0-9&above,7/01/16 - - - - - 84,032 84,032
<br /> Total increased cost subject to fringe benefits - - 2,331,397 4,680,926 7,333,608 9,664,452 24,010,383
<br /> Certain fringe benefit costs(37.86%) - - 882,667 1,772,199 2,776,504 3,658,962 9,090,332
<br /> Increased costs to be paid during fiscal years 2012 to 2017 - - 3,214,064 6,453,125 10,110,112 13,323,414 33,100,715
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) - - 489,593 982,994 1,540,058 2,029,535 5,042,180
<br /> Total increased costs - - 3,703,657 7,436,119 11,650,170 15,352,949 38,142,895
<br /> *Fringe benefits included are overtime,premium pay,hazard pay,standby,temporary assignment,compensatory time,
<br /> retirement system,workers'compensation,and unemployment compensation.
<br />
|