Loading...
HomeMy WebLinkAboutGrant Related - BOCC (003)Cu�; WPLZ, �� � GRANT COUNTY BOARD OF COUNTY COMMISSIONERS X11 ��.•. To: Board of County Commissioners Janice Flynn, Administrative Services Coordinator, Data. May 20, 2021 Re: Authorization for Release of Funds, Dept of Commerce, CDBG PSG #20- 62210-005, Reimbursement #5, Subrecipient O/C Request #5 01C has requested reimbursement regarding the above -referenced grant in the amount of $27,378.59 for April 2021 expenses. Their documentation is attached for review. I am requesting the release of funds for payment to 01C in the amount of$27,378.59. Thank you. Dated this day of ..20 Board of County Commissloncis C ran t COUnty, Washington AwMV4rovg ard MOW Dist # I Dist # I Dist #I Di: -t #2' ¢ Dist Dist #2 Dist Pr3 Dist 43 Dist 0' ti MAY 2 2021 STATE OF WASHINGTON DEPT OF COMMERCE ATTN: CD13C PROGRAM PO BOX 42525 OLYMPIA, WA 98504-2525 COMMUNITY ACTION AGENCY SUBRECIPIENT: OTC OF WASHING'PON 815 FRUITVALE BLVD YAKIMA WA 98902 2020 COMMUNITY DEVELOPMENT BLOCK GRANT - PUBLIC SERVICES GRANTS CERTIFICATION: I cerlify flint the informatio[I on this form is 11 froic oud accurate report off.lio, cash slahis and flint all reported expenditures are properly.v. q;-gv;5P1e-to the referenced grant. CONTRACT NO: Signature: - --------- lot— 201-622,10-005 REPORT PERIOD: Printed Name: DeErsic Nm"4*1,11 Rt. Apr -21 REPORT NUMBER: Title. -,Chief Financial Officer - - -------- DHte:-- 5/19/2021 TOTAL AMOUNT REQUESTED THIS PERIOD: X2'7 37g,S1 :-:.:...MOO WASHINGTON NATE ' ,IL DEPARTMENT OF COMMERCE AGENCY NUMBER 101`8 F ROJECTNUMSE"R Cam tc�a Ir fittU ber a VOUCHER I�ITiIlJT'III 1 030 246 042210-005 FNAME, , _ _ _ DEPARTMENT INSTRUCTION To VENDOR' OR CLAIMANT ...... .,... } , OF COMMERCE Submit this form to claim payment far materials, p Y merchandise or services U:rA'ii"IV: ,:. (�DG Shaw complete detail for each item: IA PQ BOX 42525 _............. . ' OL'YMP1A*'A'8504-2525 Vendor's Certificate: I hereby certify under perjury that the items and totals listed herein are proper charges for materials, ( t' __ __.. _ ....... _:.... "00 VENDOR OR CLAIMANT (Warrant is to be /payable to:) merchandise or services furnished to the State of Washington, and that all goods furnished and/or services rendered have been provided without r_ discrimination because of age, sex, marital status, race, creed, color, national origin, handicap, religion or Vietnam era or disabled veterans status, r:. GRANT COUNTY .. . ................. . --------------------------- I PCS BO 37 :. r "y7 E PH RA TA, WA 98823-0037 ............... .... . l l F � ��" 4CY PERIOD APRIL 2021 TITLE} .......- :_ -------------- (DATE) Description - QUANTITY AMOUNT IDIS Alw i+ t ID _ _ PREVIOUSLY AMOUNT REMAINING 8189 05 Public Services BUDGET tWETHIS INVOICE BALANCE ._- - ------- $117,184.00 54,477.15 275378.59 $355328.26 _$0.00 8190 21 A General Admin _................:::. 3,500.00 3,500.00 $0.00 $0.00 ........ $0.00 _ ........... _.. __ _ $0.00 $120,64.00 $57,977.15. 27,378.59 $0.00 $35,328.26 TOTAL PAYMENT REQUEST .. Everything below this line is for Dept of +�c�mi�ner+�e I:ED"TA7C117�"fi _ .._._. . l Fib/ �1f �lppRO A....Thi"Indtvf6al signing"this"voucher warrants they have the authority to sign thk voucher.') PRINTED NAME: Jeff Hlnckle [TATE SIGNATURE: OC DATE .... ..... _ _. _ __ ct+RRr roc. N©. REFERENCE DOC NO. __ ........................ VENDOR _ _ ___. NUMBER - .._.. _ _ _ WV 0002426--03 aCGOUNT NO-. � ASD NUMBER VENDOR _ ... _ _. 'MESSAGE _:::. :.:..: ��rr+� qq rr�� TRANS CODE M: 0 0INVOICE MASTER INDEX _. 5U8 ...... 213 $us SUB t�E,F Gl. ACCT SUBSI[} - 620.F0320 N - _. - AMOUNT NliMBF-R __ _ 20 -62210 -OGS Contract 20-62210-005 Submitted to GC by: OIC OF WASHINGTON Request for Reimbursement No.10 APRIL 2021 Grant County's Subrecipient Checklist: State Auditor's Office Audit Procedures for Testing Activities Allowed And Not Allowed, As Published In 2007 Questions to ask before submitting a pay . ment request 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 13, 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 federalgrantor 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 samepurpose, 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 priorperiod? 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 andgrant period? 1:\DATANONSHARED\ACCOUNTING\ingrid's stuff\CDBG\CDBG ML 266 2020-21\Subrecipient Checklist 2020-21.docPage 1 General Ledger System OIC OF WASHINGTON For User: INGRID FRANK RW Expenditure report for: 266 - 266 CDBG Page: Page 1 of I Report year: 7/1/2020 thru 6/3012021 Period ending: April 2021 Date: 5119/2021 ........................ . ........... . . ..... . ...... Time- ..... . . ..... 1:35:08 PM --Monthly--- --To Date— Account . . ... .... .. .... . ..... Budget Admn A Admin - Asset Dev/Energy Asst Expenditures Pct Budget Expenditures Pct Annualbudget Unexpended . . . ....... $1 r951.00 $4 533.86 232.39% $19,510.80 $1311166-53 67.48% $23,436.80 $10,270.27 Asst Asset Development $6,068.00 0, 1$14 351.36 236.51 % f $60,680-70 $58,700.71 96.74% $74,872.70 $161171.99 Ener Energy Assistance $1,402.00 $6,257.14 588.95% $14,020.50 $9,335.20 66-58% $16,874.50 $7,539-30 Othe Other Asset Development $165.00 t $254.40 154.18% $1,650.00 $653-30 39.59% $2?000.00 $1,346.70 Report Totals $9,586-00 $27,396.76 285.80% $95,862.00 _�s Cg9 9-:z � $81,855.74 85-39% $117,184.00 $357328.26 1Y4 0 CL, General Ledger System OIC OF WASHINGTON For User: INGRID FRANK Fund Expenditure report for: 200 - CDBG PS 711120-0130121 (Fund status: Active) Page: Page I of 2 Report year: 71112020 thru 613012021 Period ending: April 2021 Date: 511012021 .._...... ---._._�.�� .:ryn,.� .,�.:..._�.._ Time: 12:56:55 PM _.- Monthly---__----- ___..__-----.-TO Date - Account udg Expenditures Pct Budget pend ure Pc _:...__._. _._...._ ......... �:.... _ Unexpended s Annual budget Department: 049 INDIRECT ADMINd6o P rc�gram. 02 ADMIN. POOL - BASE 5312 SALARY ADM. ALLOCATION 5354 PIR TAX & BEN. ADM ALLOC. 5999 NON PERSONNEL ADM_ ALLOC. Total for sub program ---> Total for p rog ram 02 -----> Total for department 009 ---> Department: 010 PROGRAM Program: 25 PROGRAM SUPPORT 5311 SALARIES,WAGES EXPENSE 5351 FICA,OIC EXP 5352 LAND I,01C SHARE - 5353 STATE UCI(ES),OIC EXP 5355 PAID FAMILY MEDICAL LEAVE 5350 DISABILITY OIC EXPENSE 5361 MEDICAL INSURANCE,OIC EXP 5362 LIFE INSURANCE,OIC EXP 5363 PENSION,OIC EXP 5,364 ACCRUED PTCA EXP 5700 CONSUMABLES 5800 EQUIPMENT 5949 STAFF TRAINING 5950 TESTING CHARGES 5960 COMMUNICATION 5970 POSTAGE Total for sub program -----> $1,210.00 $21766.80 228.66% $12,100.80 $7,915.21 65.41% $14,531.80 $6,616.59 $507.00 $1,254.84 247.50% $5,070.00 $3,737.68 73.72% $6,093.00 $2,355.32 $234.00 $512.22 218.90% $2,340.00 $1,513.64 64.69% $2,812.00 $17298.36 $1,951.00 $4,533.86 232.39°l° $19,510.80 _ $13,166.53 .......... _�.......... 67.481° . $23,436.80 _._ $10,270.27 $1,951.00 $41533.86 232.39% $19,510.80 $13,166.53 67.48% $23,436.80 $14,270.27 $1,951.00 $4,533.86 232.3906 $19,510.80 $13,166.53 67.48% $237436.80 $10,270.27 $3,837.00 $9,175.32 239.13% $387370.00 $37,885.31 98.74% $46,053.00 $8,167.69 $278.00 $669.26 240.74% $2,780-00 $27763.76 99.42% $3,341.00 $577.24 $36.00 $66.53 184.81% $360.00 $265.02 73.62°10 $440.00 $174.98 $85.00 $200.02 235.32% $850.00 $825.90 97.16°l0 $11027-00 $201.10 $15.00 $39.99 266.60% $150.00 $159.96 106.64°1° $187.00 $27.04 $53.00 $125.07 235.98% $530.00 $500.28 94.39% $639.00 $138.72 $1,113.00 $2,375.44 213.43% $11,130.00 $9,501.76 85-37% $13t361.00 $3,859.24 $21.00 $49.43 235.38% $210.00 $197.72 94.15% $254.00$56.28 8 $277.00 $699.77 252.62% $21770.00 $2,799.08 101.05°1° $3,328.00 $528.92 $353.00 $950.53 269.27% $3,530.70 $31801.92 107.68% $4,242.70 $440.78 $83.00 $10.00 0.00% $830.00 $0.00 0.00°l0 $1,000.00 $1,000.04 $0.00 $0.00 0.00% $0.00 $0.00 0.00°l0 $2,000.00 $2,000.00 $0.00 $60.00 0.00% $0.00 $60.00 01.00°la $0.00 ($60.00 $41.00 $0.00 0.00% $410.00 $0.00 0.00°l0 $500.00 $500.00 $0.00 $194.40 0.00% $0.00 $593.30 0.00°l0 $0.00 ($593.30) .... ...... ...... . ... . ........ . .$41.00 $4.00 0.00% $410.. $0.00 0.00% $500.00 $500.00 $6,233-00 $14,605.76 234.33% .........00 $621330.70 ,w -_ _. ....__ .� r $59,354.01 _. ..._........ a 95.221° $76,872.70 _ ..., , ..... 11-- $17,518.69 - E, Clo Ci OIC OF WASHINGTON For User: INGRID FRANK Fund Expenditure report for.- 266 - CDBG PS 7/1/20-6/30/21 (Fund status: Active) Page-* Page 2 of 2 Report year: 7/1/2020 thru 6/3012021 Period ending: April 2021 Date: 5/19/2021 Time: 12:56:57 PM Account To Date -.... ... . ..... Sub progra.MA/ 54 ENERGY ASSISTANCE . ..... Expendftures Pct . . . ..... Budget Expenditures Pct Annual budget Unexpended . . .... ..... 5311 5351. 11003-00 $5,592.29 557-56% $10,030.00 $6,184.91 61.66% $12,046-00 $5,861,09 EXP 5352 LAND $75.00 $413.65 551-53% $750.00 $454-80 60.64% $905.00 $450.20 I $10.00 $39-58 395.80 °70 $100-00 4 3 31 31 -% $120.00 $76-695353 STATE U I(ES), . $22.00 $121.91 554.14% $220.00 $135.13 61.42% $269-00 $133.87 5355 PAID FAMILY MEDICAL LEAVE $4.00 $22-82 570.50% $40.00 $25.19 62.98% $48,00 $22.81 5360 DISABILITY OIC EXPENSE $12.00 $62-09 517.42% $120.00$69.65 58.04% $144.00 $74.35 5361 MEDICAL INSURANCE,01C EXP $114.00 $995.80 873.51% $11140-00$1,368.73 120.06% $1,378.00 $9.27 5362 LIFE INSURANCE,01C EXP $4.00' $24.68 617.00% $40.00$27.68 69.20% $57.00 $29-32 5363 PENSION,011C EXP $70.00 $399.37 570.53% $700.00$440-85 62.98% $848.00 $407.15 5364 ACCRUED PTO EXP $88.00 $584-95 664.72% $880.50$584-95 66.43% $1,059-50 $474-55 Total for sub program 54 $1,402.00 $8,257.14 588.95% $14,020.50 . . . ........ $9,335.20 66.58% $16,874-50 ......... $7,539-30 Total for program 25 $7,635.00 $22,862-90 299.45% $76,351.20 $68,689.21 89.96% $93,747.20 $25,057.99 Total for department 010 $7,635.00 $22,862.90 299.45% $76,351.20 $68,689.21 89.96% $93,747-20 $25,057.99 Fund Totals $9,586.00 $27,396.76 285.80% $95,862.00 $811855-74 85.39% $117,184.00 $35,328.26 General Leder ysterr� OIC OF WASHINGTON For User: INGRID FRANK Page 1 of 1 Transaction warn file luting Date: Qat: X1191202 Time. 1:17: 37 PM Number Pared Date Description p Journal Account Debit Arra Credit Ami 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 266_ - 0090 INTER 18.17 adj to ui rate 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 266 - 2161 CONT adj to u l rate 18.17 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 266 2211 CO NT 18.17 adj to u i rate :... p` ., .._,, to vec acc�ai der e to adj to u rate Prod . ,..:. r,. _ =202:..26'= .. X64 ACf 0. 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 313 -: 0090 INTER 1.21 adj to u i rate 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 313 w M 2161 CONT 1.21 adj to u l rate 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 313 - M 2211 CONT 1.21 adj touirate 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 313 a 010 25- - 5364 ACCR 1.21 adj to ui rate 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 332 - a- 0090 INTER 15.16 adj to u I rate 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 332 - - 2161 CONT 15.16 adj to u i rate 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 332 - - 2211 CONT 15.16 adj to ui rate 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 332 - 010 - 25- - 5364 ACCR 6,7 0 adj to u i rate 138694 3 27 -Apr -21 adj to vac accrual due to Payroll 2021- 332 - 010 - 25-53 - 5364 ACCR &46 adj to u i rate Total number of transactions: 13 Agency Totals: 69.08 69,08