HomeMy WebLinkAbout*Other - BOCC (002)GRANT COUNTY AUDITOR
Cash Transfer Request
Date: 12/20/22
To: Katie Smith, Accounting
From: ARPA Committee
Subject: ARPA funding transfer — BOCC Admin Services
Please perform the following transfer request:
Disbursing fund: 191 — ARPA Local Fiscal Recovery
Transfer from: 191.001.00.0000.597000010 (ABPA transfers -out)
Transfer to: 001.000.00.9101.397000010 (BOCC Admin Services transfer -in)
Amount: $ 57,989.00
Description: 2022 ARPA/COVID Admin Services
I have authority for the disbursing fund, and I authorize the above disbursement.
Approval Name: Danny E Stone
Approval Signature: � � Date:
July 1, 2007
"COMPOSITE HOURLY RATE" WORKSHEET
Use this sheet for FULL TIME EMPLOYEES ONLY
This worksheet can be used for all full-time employees. Calculated on a monthly cost, the "Composite Hourly Rate" is an estimated rate that includes all payroll costs paid by the
employer for the return of services provided by the employee.
Department
Employee/ID: 5835 Janice Flynn Effective Date:
Employee is: Exempt from overtime pay.
Non -Exempt from overtime pay -- Employee may either be paid for, or offered compensation time for, overtime hours at a rate of 11/2 times the
hourly pay rate for every 1 hr worked over 40 hrs in any work week.
1. REIMBURSABLE HOURS INAYEAR:
a. Paid Hours in a Year = (52 wks/yr X 5 work days/wk = 260 days) X 8 hrs/day 1 a. 2080.00 hrs
b. Total hours of Paid Leave Hours Per Year
Annual Leave: 8.67 hrs/mo X 12 mos = 104 hrs
Sick Leave: 8.00 hrs/mo X 12 mos = 96 hrs
Holidays: 12.00 days/yr X 8.00 hours = 96 hrs
1 b. 296.04 hrs
Average # of hours worked: 1.
1,783.96
2. Enter the amount of monthly gross salary
(Subtract
line 1 b from line 1 a)
. 2.
$
5,066.12
3. a. Social Security Rate: 6.2% X Line 1 (wages) = 3a. $
314.10
b. Medicare Rate: 1.45% X Line 1 (wages) = 3b. $
73.46 3.
$
387.56
Total 7.65%
(Total 3a + 3b)
4. L & I Benefit - Employer's Portion - (Based on an average of the number of office hrs
and field hrs per month).
The total number of hours may not exceed 160.00 hrs/mo
a. Office Code Rate $: 1.24895 X 160.00 hrs
= 4a. $ 199.83
(average # office hrs worked/mo)
(office Benefit)
b. Field Code Rate $: o.00000 X 0.00 hrs
= 4b. $ - 4.
$
199.83
(average # field hrs worked/mo)
(Field Benefit)
(Total 4a + 4b)
5. Unemployment Insurance Rate: 1.0000 % X LINE 2 (wages)
5.
$
50.66
Lf 9I
6. Paid Family & Medical Leave (FMLA)
6.
$
8.14
7. Medical Benefits, per month
8. Retirement contribution, per month
.4s C, co1 �� � ��� 7
$
1,064.66
8.
$
526.37
9. Other Life
� � � f� �-��" ���'"`��"'
9 •
$
4.24
10. TOTAL MONTHLY COSTS (add lines 2 through 8)
14 10.
$
7,299.44
11. TOTAL YEARLY COST (Multiply line 9 X 12 months)',"1Al.
$
87,593.29
12. COMPOSITE HOURLY RATE ( Divide line 10 byline 1)
_---- V�, 0
$
49.10
13.
12.
NON-EXEMPT OVERTIME COMPOSITE HOURLY RATE (Step 1: add lines 2 through
6 an �8;Stepp 2: ultiply Step 1 13.
$
70.14
APPENDIX E
U
Cash Transfer Request
Date: 12/07/22
To: Katie Smith, Accounting
From: ARPA Committee
Subject: ARPA funding transfer — BOCC Admin Services
Please perform the following transfer request:
Disbursing fund: 191 — ARPA Local Fiscal Recovery
Transfer from: 191-001-00-0000.597000010 (ARPA transfers -out)
Transfer to: 001-000-00-9101.397000010 (BOCC Admin Services transfer -in)
Amount: $ 0.00
Description: 2022 ARPA Admin Services
I have authority for the disbursing fund, and I authorize the above disbursement.
Approval Name: Danny E Stone
Approval Signature: MC Date: