|
County of Hawaii
<br /> SHOPO Bargaining Unit 36-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 $ 1,791,096 $ 1,791,096
<br /> FY2012: No increase - -
<br /> Total payroll cost in FY 2011-12 $ 1,791,096
<br /> Base pay at 6/30/12 $ 1,791,096
<br /> Base pay at 6/30/12 $ 1,791,096 $ 1,791,096
<br /> FY2013: No increase - -
<br /> Total payroll cost in FY 2012-13 $ 1,791,096
<br /> Base pay at 6/30/13 $ 1,791,096
<br /> Base pay at 6/30/13 $ 1,791,096 $ 1,791,096
<br /> FY2014: Across-the-board increase of 1.75%on July 1,2013 31,344 31,344
<br /> Across-the-board increase of 1.75%on January 1,2014 15,946 31,893
<br /> Step movements,7/1/13-6/30/14 4,043 8,844
<br /> Total payroll cost in FY 2013-14 $ 1,842,429
<br /> Base pay at 6/30/14 $ 1,863,177
<br /> Base pay at 6/30/14 $ 1,863,177 $ 1,863,177
<br /> FY2015: Across-the-board increase of 1.75%on July 1,2014 32,606 32,606
<br /> Across-the-board increase of 1.75%on January 1,2015 16,588 33,176
<br /> Step movements,7/1/14-6/30/15 12,659 29,160
<br /> Total payroll cost in FY 2014-15 $ 1,925,030
<br /> Base pay at 6/30/15 1,958,119
<br /> Base pay at 6/30/15 $ 1,958,119 $ 1,958,119
<br /> FY2016: Across-the-board increase of 2.00%on July 1,2015 39,162 39,162
<br /> Across-the-board increase of 2.00%on January 1,2016 19,973 39,946
<br /> Step movements,7/1/15-6/30/16 6,216 9,624
<br /> Total payroll cost in FY 2015-16 $ 2,023,470
<br /> Base pay at 6/30/16 2,046,851
<br /> Base pay at 6/30/16 $ 2,046,851 $ 2,046,851
<br /> FY2017: Across-the-board increase of 2.50%on July 1,2016 51,171 51,171
<br /> Across-the-board increase of 3.30%on January I,2017 34,617 69,235
<br /> Step movements,7/1/16-6/30/17 3,601 3,601
<br /> Total payroll cost in FY 2016-17 $ 2,136,240
<br /> Base pay at 6/30/17 2,170,858
<br /> Less base pay at 6/30/11 (1,791,096)
<br /> Increase to base pay over term of contract $ 379,762
<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 of total increase in cost due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $ 1,791,096 $ 1,791,096 $ 1,842,429 $ 1,925,030 $ 2,023,470 $ 2,136,240
<br /> Less base pay at beginning of fiscal year 1,791,096 1,791,096 1,791,096 1,863,177 1,958,119 2,046,851
<br /> Total additional cost - - 51,333 61,853 65,351 89,389 $ 267,926
<br /> Add affect of prior year increase in base pay - - - 72,081 167,023 255,755 494,859
<br /> Total increase in regular pay - - 51,333 133,934 232,374 345,144 762,785
<br /> Non-wage cost items:
<br /> Increase firearm maintenance allowance from
<br /> $420 to$500 per fiscal year,7/01/13 - - 1,440 1,440 1,440 1,440 5,760
<br /> Increase SOCD from$1.20 to$2.20/hour for P0-9&above,7/01/13 - - 37,440 37,440 37,440 37,440 149,760
<br /> Increase SOCD from$2.20 to$2.80/hour for P0-9&above,7/01/14 - - - 22,464 22,464 22,464 67,392
<br /> Increase SOCD from$2.80 to$3.80/hour for P0-9&above,7/01/15 - - - - 37,440 37,440 74,880
<br /> Increase SOCD from$3.80 to$4.00/hour for P0-9&above,7/01/16 - - - - - 7,488 7,488
<br /> Total increased cost subject to fringe benefits - - 90,213 195,278 331,158 451,416 1,068,065
<br /> Certain fringe benefit costs(31.27%) - - 28,210 61,063 103,553 141,158 333,984
<br /> Increased costs to be paid during fiscal years 2012 to 2017 - - 118,423 256,341 434,711 592,574 1,402,049
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) - - 18,945 41,008 69,543 94,797 224,293
<br /> Total increased costs - 137,368 297,349 504,254 687,371 1,626,342
<br /> *Fringe benefits included are overtime,premium pay,hazard pay,standby,temporary assignment,compensatory time,
<br /> retirement system,workers'compensation,and unemployment compensation.
<br />
|