HomeMy WebLinkAboutCOM 0907.001 2018-2020 •
��tv 0F'h.''+ Phone No.: (808)961-8272
Aaron S. Y. Chung ••(� • >>y�ls
Chair and Presiding Officer "' Fax No.: (808)961-8912
* J2 :*, aaron.chun hawaiicoun ov
Joire.rHawaii County Council g@ ty.g
Council Member District 2 r
TE OF 148'' .-'
HA WAI I COUNTY COUNCIL
County of Hawai`i
Hawai`i County Building
25 Aupuni Street
Hilo,Hawai`i 96720 u.
Date: May 19, 2020
To: Members of the Hawai`i County Council _
From: Aaron S. Y. Chung, Chair
Hawai`i County Counciliod
rka
Re: Resolution 614-20, Exhibit A
This is to inform you that the attached Exhibit A was inadvertently not included with Resolution
61.+20.
Thank you for your attention in this matter.
ASYC:awm
Com*,No. Q tYl.
;def:°,To. -.A,
Rif.Pate
Hawai`i County Is An Equal Opportunity Provider And Employer
Recap Bu14, 74
Summary- Cost of IIGEA Settlement,
July 1,2019 through June 30, 2021
Recap of Additional Costs
Bargaining Increased cost Certain Total increase
unit FY20-FY21 fringes FY20-FY21
14 $ 392,371 $ 155,733 $ 548,104
74 29,351 13,584 42,935
$ 421,722 $ 169,317 $ 591,039
Recap of Increase to Base Pay Due to Settlement
Bargaining •Increase to
unit base(JIB)
14 $ 285,490
74 19,712
$ 305,202
Page 1
BU14
County of Hawaii
Bargaining Unit 14 Settlement Costs
July 1,2019(FY20)through June 30,2021 (FY21)
Annual Affect on
Payroll Cost Base Pay
Effect on payroll:
Base pay at 6/30/19 2,526,720 2,526,720
FY20: 4.5%across-the-board(ATB)increase on July 1,2019 113,703 113,703
Step movements from July 1,2019 to June 30,2020 8,896 22,719
Total payroll cost in FY20 2,649,319
Base pay at 6/30/20 $ 2,663,142
Base pay at 6/30/20 2.663,142 2,663,142
FY21: 4.5%across-the-board(ATB)increase on July 1,2020 119,842 119,842
Step movements from July 1,2020 to June 30,2021 13,508 29,226
Total payroll cost in FY21 $ 2,796,492
Base pay at 6/30/21 $ 2,812,210
Less base pay at 6/30/19 (2,526,720)
Increase to base pay due to this settlement $ 285,490
FY20 FY21 Total
c2,0 I 9-2 0 I (2020-21) FY20-FY21
Determination of total increase in cost due to proposed contract:
Total payroll cost for fiscal year as per above calculations $ 2,649,319 $ 2,796,492
Less base pay at beginning of fiscal year 2,526,720 2,663,142
Total additional cost 122,599 133,350 $ 255,949
Add affect of prior year increase in base pay 136,422 136,422
Total increase in regular pay 122,599 269,772 392,371
Non-wage cost items:
Change stand-by calculation to allow for up to two(2)25%
daily portions
Total increased cost subject to fringe benefits 122,599 269,772 392,371
Certain fringe benefit costs(39.69%)* 48,660 107,073 155,733
Increased costs to be paid during fiscal years 2020-21 171,259 376,845 548,104
Vacation,sick leave and holidays(21%of total increased cost subject
to fringe benefits) 25,746 56,652 82,398
Total increased costs $ 197,005 $ 433,497 $ 630,502
* Fringe benefits include estimates for overtime,premium pay, hazard pay,standby,temporary assignment,
compensatory time,retirement system,workers'compensation,and unemployment compensation.
Page 2
BU74
County ofHawaii
Bargaining Unit 74 Settlement Costs
July 1,20:19 (FY20)through June 30,2021 (FY21)
Annual Affect on
Troll Cost .Base Pity
Efikt on payroll.
Base pay at 6/30/19 21.4,200 214,200
FY20: 4.5%across-the-board(ATB)increase on July 1,2019 9,639 9,639
Step movements.from July 1,2019 to June 30,2020 - -
Total payroll cost in FY20 223,839
Base pay at 6/30/20 $ 223,839 •
Base pay at 6/30/20 223,839 223,839
FY21: 4.5%across-the-board(ATB) increase on July 1,2020 10,073 10,073
Step movements from July 1.,2020 to June 30,2021 -
Total payroll cost in FY21 $ 233,91/
Base pay at 6/30/21 S 233,912
Less base pay at 6/30/19 (214,200)
Increase to base pay due to this settlement S :19,71.2
FY20 FY21 Total
t2 019-20) (2020-21) FY20-FY21
Determination()Dotal increase in cost due to proposed!contract.
Total payroll cost for fiscal year as per above calculations S 223,839 $ 233,912
Less base pay at beginning of fiscal year 214,200 223,839
Total additional cost 9,639 10,073 $ 19,712
Add affect of prior year increase in base pay - 9,639 9,639
Total increase in regular pay 9,639 19,712 29,351
Non-wage cost items:
" Change stand-by calculation to allow for up to two(2)25%
daily portions
Total increased cost subject to fringe benefits 9,639 19,712 29,351
Certain fringe benefit costs(46.28%)* 4,461 9,123 13,584
Increased costs to be paid during fiscal years 2020-21 14,100 28,835 42,935
Vacation,sick leave and holidays(21%of total increased cost subject
to fringe benefits) 2,024 4,140 6,164
Total increased costs S 16,124 $ 32,975 $ 49,099
* Fringe benefits include estimates for overtime,premium pay,hazard pay,standby,temporary assignment,
compensatory time,retirement system,workers'compensation,and unemployment compensation.
•
Page 3