|
County of Hawaii
<br /> HFFA Bargaining Unit 34-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,103,688 $ 1,103,688
<br /> FY2012: No increase - -
<br /> Total payroll cost in FY 2011-12 $ 1,103,688
<br /> Base pay at 6/30/12 $ 1,103,688
<br /> Base pay at 6/30/12 $ 1,103,688 $ 1,103,688
<br /> FY2013: No increase - -
<br /> Total payroll cost in FY 2012-13 $ 1,103,688
<br /> Base pay at 6/30/13 $ 1,103,688
<br /> Base pay at 6/30/13 $ 1,103,688 $ 1,103,688
<br /> FY2014: Across-the-board increase of 2.0%on July 1,2013 22,074 22,074
<br /> Across-the-board increase of 2.0%on January 1,2014 11,258 22,515
<br /> Step movements,7/1/13-6/30/14 557 3,336
<br /> Total payroll cost in FY 2013-14 $ 1,137,577
<br /> Base pay at 6/30/14 $ 1,151,613
<br /> Base pay at 6/30/14 $ 1,151,613 $ 1,151,613
<br /> FY2015: Across-the-board increase of 2.0%on July 1,2014 23,032 23,032
<br /> Across-the-board increase of 2.0%on January I,2015 11,902 23,803
<br /> Step movements,7/1/14-6/30/15 3,589 18,972
<br /> Total payroll cost in FY 2014-15 $ 1,190,136
<br /> Base pay at 6/30/15 1,217,420
<br /> Base pay at 6/30/15 $ 1,217,420 $ 1,217,420
<br /> FY2016: Across-the-board increase of 2.0%on July 1,2015 24,348 24,348
<br /> Across-the-board increase of 2.0%on January 1,2016 12,583 25,165
<br /> Step movements,7/1/15-6/30/16 3,823 20,196
<br /> Total payroll cost in FY 2015-16 $ 1,258,174
<br /> Base pay at 6/30/16 1,287,129
<br /> Base pay at 6/30/16 $ 1,287,129 $ 1,287,129
<br /> FY2017: Across-the-board increase of 5.0%on July 1,2016 64,356 64,356
<br /> Step movements,7/1/16-6/30/17 12,685 21,168
<br /> Total payroll cost in FY 2016-17 $ 1,364,170
<br /> Base pay at 6/30/17 1,372,653
<br /> Less base pay at 6/30/11 (1,103,688)
<br /> Increase to base pay over term of contract $ 268,965
<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 o/total increase in cost due to proposed contract:
<br /> Total payroll cost for fiscal year as per above calculations $ 1,103,688 $ 1,103,688 $ 1,137,577 $ 1,190,136 $ 1,258,174 $ 1,364,170
<br /> Less base pay at beginning of fiscal year 1,103,688 1,103,688 1,103,688 1,151,613 1,217,420 1,287,129
<br /> Total additional cost - - 33,889 38,523 40,754 77,041 $ 190,207
<br /> Add affect of prior year increase in base pay - - - 47,925 113,732 183,441 345,098
<br /> Total increase in regular pay - - 33,889 86,448 154,486 260,482 535,305
<br /> Non-wage cost items:
<br /> Continuation of Rank for Rank(12 shifts per year) - - - 177,738 188,140 201,542 567,420
<br /> Total increased cost subject to fringe benefits - - 33,889 264,186 342,626 462,024 1,102,725
<br /> Certain fringe benefit costs(48.95%) - - 16,589 129,319 167,715 226,161 539,784
<br /> Increased costs to be paid during fiscal years 2012 to 2017 - - 50,478 393,505 510,341 688,185 1,642,509
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) - - 7,117 55,479 71,951 97,025 231,572
<br /> Total increased costs - - 57,594 448,984 582,293 785,210 1,874,081
<br /> *Fringe benefits included are overtime,premium pay,hazard pay,standby,temporary assignment,compensatory time,
<br /> retirement system,workers'compensation,and unemployment compensation.
<br /> Exhibit
<br />
|