|
BU35
<br /> County of Hawaii
<br /> Bargaining Unit 35 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 $ 4,512,516 $ 4,512,516
<br /> FY14: 4.0%across-the-board(ATB)increase on July 1,2013 180,501 180,501
<br /> Total payroll cost in FY14 4,693,017
<br /> Base pay at 6/30/14 4,693,017
<br /> Base pay at 6/30/14 4,693,017 4,693,017
<br /> FY15: Place on appropriate step on July 1,2014 187,721 187,721
<br /> Step movements from July 1,2014 to June 30,2015 107,376 107,376
<br /> Total payroll cost in FY15 $ 4,988,114
<br /> Base pay at 6/30/15 $4,988,114
<br /> Base pay at 6/30/15 4,988,114 4,988,114
<br /> FY16: Step movements from July 1,2015 to June 30,2016 109,739 109,739
<br /> 3.5%ATB increase on January 1,2016 89,212 178,425
<br /> Total payroll cost in FY16 5,187,065
<br /> $5,276,278
<br /> Base pay at 6/30/16 5,276,278 5,276,278
<br /> FY17: Step movements from July 1,2016 to June 30,2017 116,078 116,078
<br /> 3.5%ATB increase on January 1,2017 94,366 188,732
<br /> Total payroll cost in FY17 5,486,722
<br /> Base pay at 6/30/17 $5,581,088
<br /> Less base pay at 6/30/13 (4,512,516)
<br /> Increase to base pay due to this settlement $1,068,572
<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 $4,693,017 $4,988,114 $ 5,187,065 $ 5,486,722
<br /> Less base pay at beginning of fiscal year 4,512,516 4,693,017 4,988,114 5,276,278
<br /> Total additional cost 180,501 295,097 198,951 210,444 $ 884,993
<br /> Add affect of prior year increase in base pay - 180,501 475,598 763,762 1,419,861
<br /> Total increased cost subject to fringe benefits 180,501 475,598 674,549 974,206 2,304,854
<br /> Certain fringe benefit costs(31.06%)* 56,064 147,721 209,515 302,588 715,888
<br /> Increased costs to be paid during fiscal years 2014-17 236,565 623,319 884,064 1,276,794 3,020,742
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 37,905 99,876 141,655 204,583 484,019
<br /> Total increased costs $ 274,470 $ 723,195 $ 1,025,719 $ 1,481,377 $ 3,504,761
<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 4
<br />
|