|
County of Hawaii
<br /> HFFA Bargaining Unit 11-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 $ 22,355,832 $ 22,355,832
<br /> FY2012: No increase - -
<br /> Total payroll cost in FY 2011-12 $ 22,355,832
<br /> Base pay at 6/30/12 $ 22,355,832
<br /> Base pay at 6/30/12 $ 22,355,832 $ 22,355,832
<br /> FY2013: No increase - -
<br /> Total payroll cost in FY 2012-13 $ 22,355,832
<br /> Base pay at 6/30/13 $ 22,355,832
<br /> Base pay at 6/30/13 $ 22,355,832 $ 22,355,832
<br /> FY2014: Across-the-board increase of 2.0%on July 1,2013 447,117 447,117
<br /> Across-the-board increase of 2.0%on January 1,2014 228,029 456,059
<br /> Step movements,7/1/13-6/30/14 382,844 808,764
<br /> Total payroll cost in FY 2013-14 $ 23,413,822
<br /> Base pay at 6/30/14 $ 24,067,772
<br /> Base pay at 6/30/14 $ 24,067,772 $ 24,067,772
<br /> FY2015: Across-the-board increase of 2.0%on July 1,2014 481,355 481,355
<br /> Across-the-board increase of 2.0%on January 1,2015 247,018 494,035
<br /> Step movements,7/1/14-6/30/15 90,563 285,708
<br /> Total payroll cost in FY 2014-15 $ 24,886,708
<br /> Base pay at 6/30/15 25,328,870
<br /> Base pay at 6/30/15 $ 25,328,870 $ 25,328,870
<br /> FY2016: Across-the-board increase of 2.00%on July 1,2015 506,577 506,577
<br /> Across-the-board increase of 2.00%on January 1,2016 259,371 518,741
<br /> Step movements,7/1/15-6/30/16 59,684 223,860
<br /> Total payroll cost in FY 2015-16 $ 26,154,502
<br /> Base pay at 6/30/16 26,578,048
<br /> Base pay at 6/30/16 $ 26,578,048 $ 26,578,048
<br /> FY2017: Across-the-board increase of 5.0%on July 1,2016 1,328,902 1,328,902
<br /> Step movements,7/1/16-6/30/17 195,873 355,812
<br /> Total payroll cost in FY 2016-17 $ 28,102,823
<br /> Base pay at 6/30/17 28,262,762
<br /> Less base pay at 6/30/11 (22,355,832)
<br /> Increase to base pay over tern of contract $ 5,906,930
<br /> FY12 FY13 FY14 FY15 FY16 FY17 Total
<br /> (2011-12) (2012-13) (2013-14) (2014-15) (2015-16) (2016-17) FY12-FYI7
<br /> Determination of total increase in cost due to proposed contract-.
<br /> Total payroll cost for fiscal year as per above calculations $ 22,355,832 $ 22,355,832 $ 23,413,822 $24,886,708 $26,154,502 $28,102,823
<br /> Less base pay at beginning of fiscal year 22,355,832 22,355,832 22,355,832 24,067,772 25,328,870 26,578,048
<br /> Total additional cost - - 1,057,990 818,936 825,632 1,524,775 $ 4,227,333
<br /> Add affect of prior year increase in base pay - - - 1,711,940 2,973,038 4,222,216 8,907,194
<br /> Total increase in regular pay - - 1,057,990 2,530,876 3,798,670 5,746,991 13,134,527
<br /> Non-wage cost items:
<br /> Temporary Change in Station Pay - - - 219,000 219,000 219,000 657,000
<br /> Continuation of Rank for Rank(12 shifts per year) - - - 2,391,404 2,513,268 2,689,862 7,594,534
<br /> Total increased cost subject to fringe benefits - - 1,057,990 5,141,280 6,530,938 8,655,853 21,386,061
<br /> Certain fringe benefit costs(48.87%) - - 517,040 2,512,544 3,191,669 4,230,115 10,451,368
<br /> Increased costs to be paid during fiscal years 2012 to 2017 - - 1,575,030 7,653,824 9,722,607 12,885,968 31,837,429
<br /> Vacation,sick leave and holidays(21%of total increased cost subject
<br /> to fringe benefits) - - 222,178 1,079,669 1,371,497 1,817,729 4,491,073
<br /> Total increased costs - - 1,797,208 8,733,492 11,094,104 14,703,697 36,328,502
<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 />
|