HomeMy WebLinkAboutGrant Related - BOCC(36RANT COUNTY
BOARD OF COUNTY COMMISSIONERS
1' I l �_11_.�
To: Board of County Commissioners
From: Janice Flynn, Administrative Services Coordinator
Datem. January 19, 2023
Re: Authorization for Release of BOCC Approved Funds, Dept of Commerce,
E -RAP 2.0 Grant #21-4619C-108, Opportunities Industrialization Center (O/C),
Request #14
Opportunities Industrialization Center (OIC) has requested reimbursement for the
above -referenced grant, per the contracted guidelines in the amount of $23,951.87 The
invoice and supporting documentation are attached for review.
I am requesting the release of funds for payment to OIC in the amount of $23,951.87 for
December 2022 expenses.
Thank you.
Lead Grantee Name: OIC OF WASHINGTON
List Sub Grantee Names Below
Report Week or Month/Year: DECEMBER 2022 I I I I I I
Total
.. , _ _ . _., , , _ _ ..
A .,,....,. ,,..,. ,.. _,. ,,.
1500:00:
( 3
Oera.. ... ,.. .,.. .. - .�.. .. .. -..-
6643t 7
and. Ut I t A srstance 127 7. 0
127
87.50Rent,
.
4
B �'F r'� �b'c n ra tin
y: and` o Su o t c g_
.0
00
Rent/Utilities Advance
$0.0
c o .✓ , .., . "!. _, a: - r. v. . .... - rr ., v_ - -.v s. e -s.., t r `�-. k, ..-s!. ut. � . a .. !v -� -t4 . 9 ,�( i'' h. t•'
... -
,•Sa. rl = .�... 4' - S^' x n t; "Y�2j' y� e`er �" .,-s2ia. 1
-0s?', or,� 1 ,...?a,` x ^y�. •aT, o i6ri�' 1 A�`N.s�, ,a '�` �"..�" `Y
rc�� .:ate•. _k:,�:-, G »� u:v,;.(,
a
. �, . ' '3,' :.-3'•1..4 _ .,'i,F �:: la
a`a.. .�. �`:e G. ..=t �J a ::'�i 2" .1+.,�, r:C„? a - 3•,. ..0 . Y,e- . Niv' � 'N' _ 4 ,±
4 ?n'<,sa Vit;. z .w w. ..;n,a �� .� - s,.. 1.. .a �7•T
.- -. a .... .. .5 E ,..., .. 1 . �. `si. .1•,. e :.. ',e..� '•.. ..,'.e .. s� n�.v:.. t a-,. .n .. ..ve `� N -+F. F a `G 'faJ+"- "3 S .";St A ,+. _ '+
.. _.. ... .. ... „- .,. .. _.. .,.a: .a. .¢¢♦.. -e,iw _., ... .,a .t,a`.,a.?o. .o .. �''S`, .. to .av- ..i aa,.� `7,..
.. ,a . ..._ ^:.r.. "v. -. .. .r. x n .. _Y .:- F _� ... ._ _ r _ . h .. .. s, .-..` � .- =J ,� .� :,3 r,G- ..7�.# `Y:•"e. .u. ,,, ^l.. :5 ,�5:r
..v_,.., .., ;,.. -k. max.. ,-_...,. .. ... ..... e3 ., arc. ,... ,.�, ,.. mow. F , ., ..5:. ,.�.,�.,,. ,... .�_.. _.-u. .�• _0 1 �.st-. .rN' .�b .�. �.
Totals $23,951.87 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Invoice Total: $23,951.87
Contract 21-4619c-108
Submitted to GC by: OIC OF WASHINGTON
Request for Reimbursement No.12
DECEMBER 2022
State Auditor's Office Audit Procedures for Testing Activities Allowed
And Not Allowed, As Published In 2007
Questions to ask before submitting a payment request
Was the expenditure or cost:
X Made for an allowable activity under the grant guidelines?
X Authorized (or not prohibited) under state or local laws or regulations?
X Approved by the federal awarding agency, if required?
N/A Allowable per Circular A-87 (June 2004 version), Attachment B, items 1-43?
For payroll transactions:
X Does the employee's time and effort documentation meet the requirements of
Circular A-1 22?
X Allocable to the program? (i.e., was the dollar amount charged to the program
relative to the benefits received by the program? Is the federal grantor being
charged its fair share of the cost?)
X Based on actual costs, not budgeted or projected amounts?
X Applied uniformly to federal and non-federal activities (i.e., is the federal
government being charged the same amount as if non-federal funds were being
used to pay the cost)?
X Given consistent accounting treatment within and between accounting periods?
(Consistency in accounting requires that costs incurred for the same purpose, in
like circumstances, be treated as either direct costs only or indirect costs only
with respect to final cost objectives).
X Calculated in conformity with generally accepted accounting principles, or
another comprehensive basis of accounting, when required under the applicable
cost principles?
X Not included as a cost (or used to meet cost sharing requirements) of other
federally -supported activities of the current or a prior period?
X Net of all applicable credits? (e.g., volume or cash discounts, insurance
recoveries, refunds, rebates, trade-ins, adjustments for checks not cashed, and
scrap sales).
N/A Not included as both a direct billing and as a component of indirect costs?
N/A Properly classified (e.g., some costs may be incorrectly claimed as a direct cost
instead of being incorporated as part of the indirect cost rate).
X Supported by appropriate documentation? (e.g., approved purchase orders,
receiving reports, vendor invoices, canceled checks, and time and attendance
records.) Documentation may be in an electronic form.
X Correctly charged to the proper account code and grant period?
C:\Users\blutz\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\3TL427HQ\Subrecipient Checklist Month2022
(002).doc Page 1
General Ledger System
OIC OF WASHINGTON
For User: CHARLENE PARKS
Fund Expenditure report for: 498 - ERAP 2.0 10/1/21-6/30/23 (Fund status: Active)
Report year: 10/112021 thru 6/30/2023 Period ending: December 2022
Total for sub program $229.00 $17500.00 655.02% $31435.00 $5,550-74 161.59%
Sub program: 50 FACILITY MAINT
Page: Page 21 of 36
Date: 1/17/2023
Time: 11:16,42 AM
Annual budget Unexpended
$3,608.26
$668.24
$182.26
$27.12
$8.10
-To Date --
$32.19
Account
$13.67
Budg- et
Expenditures
Pct
Budget
Expenditures
Pct
Department: 008 DIRECT ADMIN
$290,54
$5617
$38217
$79.65
$0.75
$0.03
Program:
80 CEO OFFICE
$37.32
$0.96
$0.00
($1,500.00)
$1.00
$0.00
5311
SALARIESPAGES EXPENSE
$171.00
$0.00
0.00%
$2,565.00
$2,940.02
114.62%
5351
FICA,OIC EXP
$8.00
$0.00
0.00%
$120.00
$155.14
129.28%
5352
L AND I,OIC SHARE
$0.00
$0.00
0.00%
$0.00
$6.65
0-00%
5353
STATE UCI(ES),OIC EXP
$1.00
$0.00
0.00%
$15.00
$26.95
179.67%
5355
PAID FAMILY MEDICAL LEAVE
$0.00
$0.00
0.00%
$0.00
$11.76
0.00%
5360
DISABILITY OIC EXPENSE
$1-00
$0-00
0.00%
$15.00
$24.50
163.33%
5361
MEDICAL INSURANCE,OIC EXP
$16.00
$0.00
0.00%
$240.00
$297.44
123.93%
5362
LIFE INSURANCE,OIC EXP
$0.00
$0.00
0.00%
$0.00
$11.16
0.00%
5363
PENSION,OIC EXP
$13.00
$0.00
0,00%
$195.00
$233.77
119.88%
5364
ACCRUED PTO EXP
$18.00
$0.00
0.00%
$270.00
$302,52
112.04%
5602
DEPRECIATION EXP EQUIP
$0.00
$0.00
0.00%
$0.00
$0.72
0.00%
5910
INSURANCE
$0.00
$0.00
0.00%
$0.00
$3.75
0.00%
5960
COMMUNICATION
$1.00
$0.00
0.00%
$15.00
$36.36
242.40%
5982
MISC. PROGRAM EXPENSE
$0.00
$11500.00
0.00%
$0.00
$1,500.00
0.00%
Total for sub program $229.00 $17500.00 655.02% $31435.00 $5,550-74 161.59%
Sub program: 50 FACILITY MAINT
Page: Page 21 of 36
Date: 1/17/2023
Time: 11:16,42 AM
Annual budget Unexpended
$3,608.26
$668.24
$182.26
$27.12
$8.10
$1.45
$32.19
$5.24
$13.67
$1.91
$29.99
$5.49
$356.55
$59.11
$13.48
$2.32
$290,54
$5617
$38217
$79.65
$0.75
$0.03
$3.23
($0.52)
$37.32
$0.96
$0.00
($1,500.00)
$4,958.51 ($592.23)
5601 DEPRECIATION EXP BLDG.
$0.00
$0.00
0.00%
$0.00
$6.67
0.00%
$5.71
($0.96)
5602 DEPRECIATION EXP EQUIP
$0.00
$0.00
0.00%
$0.00
$0.07
0.00%
$0.04
($0.03)
5611 SPACE
$5.00
$0.00
0.00%
$75-00
$137.50
183.33%
$116.54
($20.96)
5630 UTILITIES
$1.00
$0.00
0.00%
$15.00
$33-22
221.47%
$30.51
($2.71)
5640 BUILD. REPAIR/MAINT.
$1.00
$O.00
0-00%
$15.00
$49.11
327.40%
$41.00
($8.11)
5910 INSURANCE
$0.00
$0.00
0.00%
$0.00
$0.24
0-00%
$0.26
$0.02
5912 LIABILITY INSURANCE
$0.00
$0.00
0.00%
$0.00
$14.82
0.00%
$12.35
($2.47)
Total for sub program 50
$7.00
$0.00
0.00%
$105.00
$241.63
230.12%
$206.41
($35.22)
Total for program 80 --->
$236,00
$1,500.00
635.59%
$3,540.00
$5,792.37
163-63%
$5,164.92
($627.45)
Program: 82 CFO I FISCAL
General Ledger System
CIC OF WASHINGTON
For User: CHARLENE PARKS Page: Page 22 of 36
Fund Expenditure report for: 498 - ERAP 2.0 10/1%21-6130123 (Fund status: Active) Date: 1117/2023
Report year.- 10/1/2021 thru 6/3012023 Period ending: December 2022 Time: 11:16:43 AM
---To Date ----
Account
5601
Budget
Expenditures
Pct
Budget
Expenditures
Pct
Annual budget
5311
SALARIES,WAGES EXPENSE
$411.00
$0.00
0.00%
$6,165.00
$7,685.84
124-67%
$81646.88
5351
FICA,OIC EXP
$30.00
$0.00
0.00%
$450.00
$575.19
127.82%
$649.15
5352
L AND I,O IC SHARE
$1.00
$0.00
0.00%
$15.00
$21.32
142.13%
$23.14
5353
STATE UCI(ES),O}IC EXP
$5.00
$0.00
0.00%
$75.00
$101.47
135.29%
$113.52
5355
PAID FAMILY MEDICAL LEAVE
$2.00
$0.00
0.00%
$30-00
$44.93
149.77%
$50.16
5360
DISABILITY OIC EXPENSE
$5.00
$0.00
0.00%
$75.00
$97.16
129.55%
$110.91
5361
MEDICAL INSURANCE,01C EXP
$65.00
$0.00
0.00%
$975.00
$11228.30
125.98%
$11370.17
5362
LIFE INSURANCE,O)IC EXP
$2.00
$0.00
0.00%
$30.00
$41.70
139.00%
$47.77
5353
PENSION,01C EXP
$30.00
$0.00
0.00%
$450.00
$569.16
126-48%
$646.35
5364
ACCRUED PTO EXP
$50.00
$0.00
0.00%
$750.00
$856.99
114.27%,
$1 054.9 9
5602
DEPRECIATION EXP EQUIP
$0.00
$0.00
0.00%
$0.00
$3.04
0.00%
$2.90
5910
INSURANCE
$0.00
$0.00
0.00%
$0.00
$21.18
0.00%
$19.44
5960
COMMUNICATION
$5.00
$0.00
0.00%
$75.00
$84.98
113.31%
$111.40
Total
for sub program ---->
$606.00
$0-00
0.00%
$9,090.40
$11,331.26
124.66%
$121845.98
Sub program: 50 FACILITY MAINT
5601
DEPRECIATION EXP BLDG.
5602
DEPRECIATION EXP EQUIP
5611
SPACE
5630
UTILITIES
5640
BUILD. REPAI R/MAI NT.
5910
INSURANCE
5912
LIABILITY INSURANCE
Total for sub program 50 ----->
Total for program 82 ----->
Total for department 008 --- ->
Department: 010 PROGRAM
Program: 25 PROGRAM SUPPORT
5311 SALARIES,WAGES EXPENSE
$1.00
$0.00
0.00%
$15.00
$20.70
138.00%
$23.41
$0.00
$0.00
0.00%
$0.00
$0.17
0.00%
$0.16
$23.00
$0.00
0.00%
$345.00
$430.04
124.65%
$485.40
$6.00
$0.00
0.00%
$90.00
$111.83
124.26%
$131.34
$10.00
$0.00
0.00%
$150.00
$183.58
122.39%
$213.16
$0.00
$0.00
0.00%
$0.00
$0.88
0.00%
$1.11
$2.00
$0.00
0.00%
$30.00
$45.48
151.60%
$50.83
$42.00
$0.00
0.00%
$630.00
$792.68
125.82%
$905.41
$648.00
$0.00
0.00%
$93720.00
$12,123.94
124.73%
$13,751.39
$884.00
$1,500.00
169.68%
$13,260.00
$17,916.31
135.12%
$18,916.31
$1,893.00
$7,018.82
370.78%
$28,395.00
$43,458-27
153.05%
$39,753.20
Unexpended
$961.04
$73.96
$1.82
$12.05
$5.23
$13.75
$141.87
$6.07
$77.19
$197.20
($0.14)
($1.74)
$26.42
$1,514-72
$2.71
($0.01)
$55.36
$19.51
$29.58
$0.23
$5.35
$112.73
$1,627.45
$1,000.00
($3,705.07)
General Ledger System
OIC OF WASHINGTON
For User: CHARLENE PARKS
Page:
Page 23 of 30
9
Fund Expenditure report for: 498 - ERAP 2.0 1011/21-0/30123 (Fund status: Active)
Date:
1117/202712023
Report year: 101112021 thru 0130/2023
Period ending: December 2022
Time:
11 AM
Account
Budget.
Expenditures
Pct
Budget
Expenditures
Pct
Annual budget
Unexpended
5351 F1CA,OIC EXP
$136.00
$519.69
382.13%
$2,040.00
$31212.37
157.47%
$2,858.44
($353.93)
5352 LAND 1,010. SHARE
$9.00
.$33.74
374.89%
$135.00
$234.14
173.44%
$202.74
{$31.40}
5353 STATE UCI(ES),OIC EXP
$30.00
$86.82
289.40%
$450.00
$561.01
124.67%
$640.05
$79.04
5355 PAID FAMILY MEDICAL LEAVE
$13.00
$46.58
358.31%
$195.00
$281.98
144.61%
$276.11
($5.87)
5360 DISABILITY OIC EXPENSE
$30.00
$72.13
240.43%
$450.00
$539.69
119.93%
$632.36
$92.67
5361 MEDICAL INSURANCE,01C EXP
$529.00
$814.26
153.92%
$7,935.00
$61408.97
80.77%
$11,113.91
$41704.94
5362 LIFE INSURANCE,01C EXP
$11.00
$29.05
264.09%
$165.00
$216.17
131.01%
$251.04
$34.87
5363 PENSION,OIC EXP
$153.00
$543.95
355.52%
$2,295.00
$31289.71
143.34%
$3,219.81
($69.90)
5364 ACCRUED PTO EXP
$609.00
$428.41
70.35%
$9,135.00
$3,963.08
43.38%
$121797.29
$81834.21
5500 TRAVEL
$29.00
$0.00
0.00%
$348.00
$29.25
8.41%
$535.20
$505.95
5602 DEPRECIATION EXP EQUIP
$1.00
- $0.00
0.00%
$15.00
$7.48
49.87%
$33.30
$25.82
5712 REPRODUCTION SUPPLIES
$12.00
$0.00
0.00%
$180.00
$15.01
8.34%
$268.61
$253.60
5728 DRUGIALCOHOL REHAB SCREE
$0.00
50;90 $0.00
0.00%
$0.00
$50.00
0.00%
$0.00
{$50.00}
5910 INSURANCE
$7.00
$0.00
0.00%
$105.00
$134.29
127.90%
$163.58
$29.29
5960 COMMUNICATION
$51.00
1110 $0.00
0.00010
$765.00
$169.79
22.19%
$1,077.54
$907.75
Total for sub program ----->
$3,513.00
$9593.45
27308%
$52,608.00
$621571.21
118.94%
$731823.18
$11,251.97
Total for program 25 --___>
$3,513.00
$91593.45
273.08%
$52,608.00
$62,571.21
118.94%
$73,823.18
$11,251.97
Program: 30 DIRECT SERVICES
5959 SERVICES
$25,521.00
$121787.50
50.11%
$382,815.00
$395,773.05
103.38%
$535,954.95
$140,181.90
Total for sub program ----->
$25,521.00
$122787.50
50.11%
$3821815.00
$395,773.05
103.38%
$5351954.95
$140,181.90
Total for program 30 ----->
$25,521.00
$12,787.50
50.11%
$382,815.00
$3951773.05
103.38%
$5357954.95
$1401181.90
Program: 50 BLDG MAINT/FACILITY
5601 DEPRECIATION EXP BLDG.
$19.00'..
�' $0.00
0.00°100
$285.00
$71.26
25.0010
$400.35
$329.09
5602 DEPRECIATION ECP EQUIP
$0.00
$0.00
0.00%
$0.00
$0.04
0.00%
$0.00
($0.04)
5611 SPACE
$16.00
$0.00
0.00%
$240.00
$140.87
58.70%
$351.13
$210.26
5630 UTILITIES
$20.00
$0.00
0.00%
$300.00
$76.02
25.34%
$436.21
$360.19
5640 BUILD. REPAIRIMAINT.
$22.00
$0.00
0.00%
$330.00
$72.96
22.11%
$465.67
$392.71
5010 INSURANCE
$0.00
$0.00
0.00%
$0.00
$0.15
0.00%
$0.00
{$0.15}
I
General Ledger system
OIC OF WASHINGTON
For User: CHARLENE PARKS
Page:
Page 24 of 36
Fund Expenditure report for; 498 - ERAP 2.0 1011121-0130123
(Fund status: Active)
Date:
1/17/2023
Report year: 101112021 thria
613012023
Period ending: December 2022
Time:
-11:16.*45 AM
11 wity-
To Date -
Account
Budget
Expenditures
Pct
Budget
Expenditures
Pct
Annual budget
Unexpended
5912 LIABILITY INSURANCE
$8.00
$0.00
0.00010
$120.00
$41.17
34.3110
$187.73
$146.55
Total for sub program ->
$85.00
$0.00
0.00%
$1,275.00
$402.47
31.57%
$1,841.09
$1,438.62
Total for program 50 ----->
$85-00
$0.00
AAnj tit
0.00%
$1,275.00
$402.47
31.57%
$1,841.09
$1,438.62
Total for department 010 --->
$29,119.00
$22,380.95
76.86%
$436,698.00
$458?746.73
105.05%
$611,619.22
$152,872.49
Fund Totals
$30,003.00
$23,,880.95
$4491958.00
$476,663.04
105.94%
$630,535.53
$153,872.49
4-
M79.60%
23
N