HomeMy WebLinkAboutGrant Related - BOCC (002)GRANT COUNTY
BOARD OF COUNTY COMMISSIONERS
Memo
To: Board of County Commissioners
From: Janice Flynn, Administrative Services Coordinat
Dabn February 25, 2021 OqA
Re: Authorization for Release of Funds, Dept of Commerce, CDBG PSG #20-
62210-005, Reimbursement #2, Subrecipient 01C Request #2
01C has requested reimbursement regarding the above -referenced grant in the amount
of $17,457.70 for January 2021 expenses. Their documentation is attached for review.
I am requesting the release of funds for payment to 01C, in the amount of $17,457.70.
Thank you.
day of 2
Dw,c-(l this
cominiss , iollers
13ward of CountV
Uant CountNf, WAshington
D i 1.pprov e �Abs t a Lit i
D est 4 1
Dist -9 I
Dist # 2
Dist #12 D 1 st # 2
—i—) Dist # 3
Dist # 3
Dist P*3 -------------
-7=1
MWE D
FEB 25 2021
I "L
10CLI, T C
n�
I
STATE OFWASHINGTON 2020 CONIMUNITY DEVELOPMENT BLOCK GRANT- PUBLIC SERVICES GRANTS
DEI TOPCOMMERCE
.TTN: CDBG PROGRAM
PO BOX 42525 CERTIFICATION: I certify that the hkforninuon on this form is A
OLYMPIA, WA 98504-2525 true and accurate report of the cash status and that all reported
expendittires are properly chargeable to the referenced grant.
COMMUNITV ACTION AGENCY SUBRECIPIE NT:
CONTRACT NO: Signature: ..........
01C OF WASHINGTON 20-62210-005
815 1' ' RU ITVALE BLVD REPORTPERIOD:Printed Name:.D# 6. Mektiria
YAKIMA WA 99902 Jan -21
REPORT NUMBER: Title: Chief Financial Officer
7
Date: 2/[8/2021
TATA L ANIOUNT REQUESTED THIS PERIOD! S17,457.70..
vg
.'00 q yi A �
Lit. it. 4tildilliCt" 4.1.4i I max
Description of service program how low- and moderate -income (L I) persons were served this period.: 'Housing
counseling, credit coaching, foreclosure services, business start-up, financial education workshops and high school
classes. Free tax -prep,
- - ------- -
th
N
I �!, 4 in d(id
P
Description of service program how low- and moderate -income (ILMI) persons were serVed this perioa: Energy
assistance and conservAtion education.
------ ------
IWIle 0 P. V er Yoss 3( C lit a
Hy:. Asset
i ' Admin -Indic CtMin' IFC2151,-�Cj,- this Is PC
Description of service program how ow- and moderate -income (LMI) persons were served this period- General
administration expenses associated with managing energy assistance and asset development activities oversight and
assessments, Indirect admin.
WASHINGTON STATE
E fi DEPARTME T OF COMMERCE
VOUCHED DISTRIBUTION
AGENCY NUMBER
1 030
IDIS PROJECT NUMBER
46
Commerce Contract Number
20-62210-005
AGENCY NAME
DEPARTMENT OF COMMERCE
ATTN: CDBG
PO BOX 42525
OLYMPIA, WA 98504-2525
INSTRUCTION TO VENDOR OR CLAIMANT:
Submit this form to claim payment for materials, merchandise or services.
Show complete detail for each item.
Vendor's Certificate: I hereby certify under perjury that the items and totals listed herein are
proper charges for materials, merchandise or services furnished to the State of Washington,
and that all Dods urnished and/or se ices re .Ved have been provided without
discrimifro ecause-of age, sex, ital statce, creed, color, national origin, handicap,
religionVi t erarlisabled v e��ns sta
VENDOR OR CLAIMANT (Warrant is to be payable to:)
GRANT COUNTY
PO BOX 37
EPHRATA, WA 98823-0037
REPORTING PERIOD: JANUARY 2021
fit
I ail
By: o; . \U A,
(S I GWYK BLUE I N K)
Cindy Carter Chair
(TITLE) (DATE)
Description QUANTITY AMOUNT
IDIS
Activity ID
PREVIOUSLY AMOUNT REMAINING
BUDGET REQUESTED THIS INVOICE BALANCE
8189
05 Public Services $1175184.00 11328.77 175457.70 $989397.53
$0.00
$0.00
8190
2 1 A General Admin 351500.00 0.00 $35500.00
$0.00
$0.00
$0.00
$0.00
$0.00
TOTAL PAYMENT REQUEST $1205684.00 $1,328.77 17,457.70 $101,897.53
F- Everything below this line is for Dept of Commerce
FED TAX ID #
PROGRAM APPROVAL (The individual signing this voucher warrants they have the authority to sign this voucher.)
PRINTED NAME: Jeff Hinckle SIGNATURE:
DATE
DOC DATE
CURRENT DOC. NO.
REFERENCE DOC NO.
VENDOR NUMBER
SWV # 0002426-03
ACCOUNT NO.
ASD NUMBER
33243
VENDOR MESSAGE
CDBG #
TRANS
CODE
M
0
D
MASTER
INDEX
SUB
OBJ
SUB
SUB
OBJ
GL ACCT
SUBSID
AMOUNT
INVOICE
NUMBER
620F0320
NZ
20-62210-005
SIGNATURE OF ACCOUNTING PREPARER FOR PAYMENT
DATE
WARRANT TOTAL
ACCOUNTING APPROVAL FOR PAYMENT
DATE
Contract 20-62210-005
Submitted to GC by: OIC OF WASHINGTON
Request for Reimbursement No. 7
JANUARY 2021
Grant County's Subreckpient Checklisq
State Auditor's Office Audit Procedures for Testing Activities Allowed
And Not Allowed, As Published In 2007
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-122?
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 used 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?
1:\DATANONSHARED\ACCOUNTINGIingrid's stuff\CDBG\CDBG ML 266 2020-21\Subrecipient Checklist 2020-21,docPage
1
OIC OF WASHINGTON
For User: INGRID FRANK
RW Expenditure report for: 266 - 266 CDBG
Page:
Page 1 of 1
Date:
2118/2021
Report year: 711/2020 th ru 6/30/2021
Period ending: January 2021
Time: 1.15. 1
1 -TPM
Monthly-
Date—.
---
Account
Budget
Expenditures
Pct
Budget
Expenditures
Pct
Annual budget
Unexpended
Admn Admin -Asset DevIEnergy Asst
$11951.00
$2,419.39
124.01%
$13,657.80
$2,670.10
19.5510
$237436.80
$20,766.70
Asst Asset Development
$6,068.00
$15V038.31
247-83%
$421476.70
$151038.31
35.40%
$721872.70
$57,834.39
Ener Energy Assistance
$1,402.00
$0.00
0.00%
$9,814.50
$1,078-06
10.98%
$16,874.50
$15,796.44
Othe Other Asset Development
$331.00
$0.00
0.00%
$2,317.00
$0.00
0.00%
$4,000-00
$4,000.00
Report Totals $91752.00 $171457.70 179.02% $680266.00 $18,786.47 27.52% $1171184.00 $981397.53
=77111
OIC OF WASHINGTON
For User: INGRID FRANK
Fund Expenditure report for: 266 - CDBG PS 711/20-6130/21 (Fund status: A
4
Report year: 7/1/2020 thru 6130/2021 Period endir
---Monthly-
Budget Expenditures Pct
Department: 009 INDIRECT ADMIN
-I U .safe --
Budget
Program: 02 ADMIN.POOL-BASE
644:z�
Qcpkfl n
$8,470.80
5312 SALARY ADM. ALLOCATION
$1,210-00
$17460-98
120.74%
5354 RJR TAX & BEN. ADM ALLOC.
$507.00
$698.81
137.83%
5999 NON PERSONNEL ADM- ALLOC.
$234.00
$259-60
110.94%
Total for sub program
$1,951.00
$2,419.39
124.01%
Total for program 02 ----->
$11951.00
$2,419.39
124.01%
Total for department 009
$1,951-00
$2,419.39
124-01%
Department: 010 PROGRAM
30.49%
$13,361.00
A
Program:• 25 PROGRAM SUPPORT
$49.43
ry%W-4
$254.00
5311 SALARIESNAGES EXPENSE
$31837.00
$9,756-67
254-28%
5351 FICA,OIC EXP
$278.00
$711.37
255.89%
5352 LAND I,OIG SHARE
$36.00
$61.80
171.67%
5353 STATE UCI(ES),OIC EXP
$85.00
$280.02
329.44%
5355 PAID FAMILY MEDICAL LEAVE
$15.00
$39.03
260.20%
5360 DISABILITY OIC EXPENSE
$53.00
$125.07
235.98%
5361 MEDICAL INSURANCE,OIC EXP
$1,113.00
$2,375.44
213.43%
5362 LIFE INSURANGE,OIC EXP
$21.00
$49.43
235-38%
5363 PENSION,OIC EXP
$277-00
$682.97
246.56%
5364 ACCRUED PTO EXP
$353.00
$956.51
270.97%
5500 TRAVEL
$83.00
$0.00
0.00%
5700 CONSUMABLES
$83.00
$0.00
0.00%
5949 STAFF TRAINING
$83.00
$0.00
0.00%
5950 TESTING CHARGES
$41.00
$0.00
0.00%
5970 POSTAGE
$41.00
$0.00
0.00%
Total for sub
$15,038.31
235.01%
Sub program 4 -ENERGY ASSISTANCE
Page: Page I of 2
Date: 2/1 8/2021
Time: 11:24:00 AM
Annual budget
Unexpended
...... ..... . ..
$14,531.80
-I U .safe --
Budget
Expenditures Pct
.... ........
644:z�
Qcpkfl n
$8,470.80
$1,617.05 19.09%
$31549.00
$768.58 21.66%
$1,638.00
$284-47 17.37%
$13,657.80
$2,670.10 19.55%
$13,657.80
$2,670.10 19.5510
$13,657.80
$2,670.10 19.55%
Page: Page I of 2
Date: 2/1 8/2021
Time: 11:24:00 AM
Annual budget
Unexpended
...... ..... . ..
$14,531.80
$12,914.75
$6,093.00
$5,324.42
$2)812.00
$2,527.53
$23;436-80
$20,766-70
$23,436.80
$20,766.70
$23,436.80
$20,766.70
$267859.00
$9,756.67
36.33%
$46,053.00
$36,296.33
$1,946.00
$711.37
36.56%
$37341.00
$2,629.63
$252.00
$61.80
24.52%
$440.00
$378.20
$595.00
$280.02
47.06%
$11027.00
$746-98
$105.00
$39-03
37-17%
$187.00
$147.97
$371.00
$125.07
33.71%
$639.00
$513.93
$7,791-00
$2,375.44
30.49%
$13,361.00
$101985.56
$147.00
$49.43
33.63%
$254.00
$204.57
$11939.00
$682.97
35.22%
$3,328.00
$2,645-03
$2,471.70
$956.51
38.70%
$4,242.70
$3,286.19
$581.00
$0.00
0.00%
$1,000.00
$1,000-00
$581.00
$0.00
0-00%
$1,000.00
$1,000-00
$581.00
$0.00
0.00%
$1,000.00
$11000.00
$287.00
$0.00
0.00%
$500.00
$500.00
$287.00
$0.00
0.00%
$500.00
$500.00
$44,793.70
$15,038.31
33,57%.
$76,872.70
$61,834.39
OIC OF WASHINGTON
For User: INGRID FRANK Page: Page 2 of 2
Fund Expenditure report for: 266 - CDBG PS 7/1120-6/30/21 (Fund status: Active) Date: 2/18/2021
Report year: 7/1/2020 thru 613012021 Period ending: January 2021 Time: 11:24:03 AM
. . .......... ..
. ............
Fund Totals $9,752.00 $17,457.70 179.02% $68,266-00
Unexpended
$11,453.38
$863.85
$116.27
$255.78
$45.63
$136.44
$1,005.07
$54.00
$806.52
$11059.50
$15,796.44
$771630.83
$77,630.83
$18,786.47 27.52% $1171184.00 $98,397.53
-Monthly-
Date -------
Account . ..
. . ...... ......
Budge t
Expenditures
Pct
Budget
Expenditures
Pot
Annualbudget
5311
SALARIES WAGES EXPES
$1,003.00
$0.00
0-00%$7,021.00
$592.62
8.44%
$12,046.00
5351
FIGA,01C EXP
$75.00
$0-00
0.00%
$525.00
$41.15
7.84%
$905.00
5352
LAND I 01C. SHARE
$10.00
$0.00
0.00%
$70.00
$3.73
5-33%
$120.00
5353
STATE UCI(ES),01C EXP
$22.00
$0.00
0.00%
$154.00
$13.22
8.58%
$269-00
5355
PAID FAMILY MEDICAL LEAVE
$4-00
$0.00
0.00%
$28.00
$2.37
8.46%
$48.00
5360
DISABILITY OIC EXPENSE
$12-00
$0.00
0.00%
$84.00
$7.56
9.00%
$144.00
5361
MEDICAL INSURANCE,01C EXP
$114.00
$0.00
0.00%
$798.00
$372.93
46-73%
$1,378.00
5362
LIFE INSURANCE,01C EXP
$4.00
$0.00
0.00%
$28.00
$3.00
10.71%
$57.00
5363
PENSION,01C EXP
$70.00
$0.00
0.00%
$490.00
$41.48
8.47%
$848.00
5364
ACCRUED PTO EXP
$38-00
$0.00
0.00%
$616.50
$0.00
0.00%
$11059.50
Total
for sub program 54 >
$1,402.00
$0-00
0.00%
$9,814.50
$1,078.06
10.98%
$16,874-50
Total for program 25
$7,801.00
$151038.31
192.77%
$54,608.20
$16,116.37
29-51%
$93,747.20
Total for
department 010
$7,801.00
$15,038.31
192.77%
$54,608.20
$16,116.37
29.51%
$931,747.20
Fund Totals $9,752.00 $17,457.70 179.02% $68,266-00
Unexpended
$11,453.38
$863.85
$116.27
$255.78
$45.63
$136.44
$1,005.07
$54.00
$806.52
$11059.50
$15,796.44
$771630.83
$77,630.83
$18,786.47 27.52% $1171184.00 $98,397.53