|
2014-17 BU1
<br /> County of Hawaii
<br /> Bargaining Unit 01 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 $ 23,207,592 $ 23,207,592
<br /> FY14: 2.00%across-the-board(ATB)increase on October 1,2013 348,114 464,152
<br /> 2.00%across-the-board(ATB)increase on April 1,2014 118,359 473,435
<br /> Total payroll cost in FY14 23,674,065
<br /> Base pay at 6/30/14 24,145,179
<br /> Base pay at 6/30/14 24,145,179 24,145,179
<br /> FY15: 2.00%across-the-board(ATB)increase on October 1,2014 362,178 482,904
<br /> 2.00%across-the-board(ATB)increase on April 1,2015 123,140 492,562
<br /> Total payroll cost in FY15 $ 24,630,497
<br /> Base pay at 6/30/15 $ 25,120,645
<br /> Base pay at 6/30/15 25,120,645 25,120,645
<br /> FYI6: 2.00%across-the-board(ATB)increase on October 1,2015 376,810 502,413
<br /> 2.00%across-the-board(ATB)increase on April 1,2016 128,115 512,461
<br /> Total payroll cost in FY16 $ 25,625,570
<br /> Base pay at 6/30/16 $ 26,135,519
<br /> Base pay at 6/30/16 26,135,519 26,135,519
<br /> FY17: 2.00%across-the-board(ATB)increase on October 1,2016 392,033 522,711
<br /> 2.00%across-the-board(ATB)increase on April 1,2017 133,291 533,165
<br /> Total payroll cost in FY17 $ 26,660,843
<br /> Base pay at 6/30/17 $ 27,191,395
<br /> Less base pay at 6/30/13 (23,207,592)
<br /> Increase to base pay due to this settlement $ 3,983,803
<br /> FY14 FY15 FY16 FY17 Total
<br /> (2013-14) (2014-15) (2015-16) (2016-17) FY13-FY17
<br /> Determination of total increase in cost due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $ 23,674,065 $ 24,630,497 $ 25,625,570 $ 26,660,843
<br /> Less base pay at beginning of fiscal year 23,207,592 24,145,179 25,120,645 26,135,519
<br /> Total additional cost 466,473 485,318 504,925 525,324 $ 1,982,040
<br /> Add affect of prior year increase in base pay - 937,587 1,913,053 2,927,927 5,778,567
<br /> Total increase in regular pay 466,473 1,422,905 2,417,978 3,453,251 7,760,607
<br /> Non-wage cost items:
<br /> Change stand-by work compensation from$2.00 per hour to 25%of
<br /> daily rate,7/1/13 62,507 63,757 65,032 66,333 257,629
<br /> Total increased cost subject to fringe benefits 528,980 1,486,662 2,483,010 3,519,584 8,018,236
<br /> Certain fringe benefit costs(36.25%)* 191,755 538,915 900,091 1,275,849 2,906,610
<br /> Increased costs to be paid during fiscal years 2014-17 720,735 2,025,577 3,383,101 4,795,433 10,924,846
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) 111,086 312,199 521,432 739,113 1,683,830
<br /> Total increased costs $ 831,821 $ 2,337,776 $ 3,904,533 $ 5,534,546 $ 12,608,676
<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 1
<br />
|