|
BU13
<br /> County of Hawaii
<br /> Bargaining Unit 13 Settlement Costs
<br /> July 1,2013(FY14)through June 30,2017(FY17)
<br /> Annual Affect on
<br /> Payroll Cost Base Pay
<br /> Effect on payroll:
<br /> Base pay at 6/30/13 $15,331,176 $15,331,176
<br /> FY14: 4.0%across-the-board(ATB)increase on July 1,2013 613,247 613,247
<br /> Total payroll cost in FY14 15,944,423
<br /> Base pay at 6/30/14 15,944,423
<br /> Base pay at 6/30/14 15,944,423 15,944,423
<br /> FY15: Place on appropriate step on July 1,2014 813,108 813,108
<br /> Step movements from July 1,2014 to June 30,2015 93,854 176,304
<br /> Lump sum payment for those with no step movement 9,000 9,000
<br /> Total payroll cost in FY15 $16,860,385
<br /> Base pay at 6/30/15 $16,942,835
<br /> Base pay at 6/30/15 16,942,835 16,942,835
<br /> FY16: Step movements from July 1,2015 to June 30,2016 108,702 193,404
<br /> 3.5%ATB increase on January 1,2016 299,884 599,768
<br /> Total payroll cost in FY16 17,351,421
<br /> $17,736,007
<br /> Base pay at 6/30/16 17,736,007 17,736,007
<br /> FY17: Step movements from July 1,2016 to June 30,2017 110,042 208,008
<br /> 3.5%ATB increase on January 1,2017 314,020 628,041
<br /> Total payroll cost in FY17 18,160,069
<br /> Base pay at 6/30/17 $18,572,056
<br /> Less base pay at 6/30/13 (15,331,176)
<br /> Increase to base pay due to this settlement $ 3,240,880
<br /> FY14 FY15 FY16 FY17 Total
<br /> (2013-14) (2014-15) (2015-16) (2016-17) FY14-FY17
<br /> Determination of total increase in cost due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $15,944,423 $16,860,385 $ 17,351,421 $ 18,160,069
<br /> Less base pay at beginning of fiscal year 15,331,176 15,944,423 16,942,835 17,736,007
<br /> Total additional cost 613,247 915,962 408,586 424,062 $ 2,361,857
<br /> Add affect of prior year increase in base pay - 613,247 1,611,659 2,404,831 4,629,737
<br /> Total increased cost subject to fringe benefits 613,247 1,529,209 2,020,245 2,828,893 6,991,594
<br /> Certain fringe benefit costs(27.97%)* 171,525 427,720 565,063 791,241 1,955,549
<br /> Increased costs to be paid during fiscal years 2014-17 784,772 1,956,929 2,585,308 3,620,134 8,947,143
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 128,782 321,134 424,251 594,068 1,468,235
<br /> Total increased costs $ 913,554 $ 2,278,063 $ 3,009,559 $ 4,214,202 $ 10,415,378
<br /> * Fringe benefits include estimates for overtime,premium pay,hazard pay,standby,temporary assignment,
<br /> compensatory time,retirement system,workers'compensation,and unemployment compensation.
<br /> Page 2
<br />
|