Loading...
HomeMy WebLinkAboutGrant Related - BOCC (003)I GRANT COUNTY BOARD OF COUNTY COMMISSIONERS To: Board of County Commissioners Janice Flynn, Administrative Services Coordinator Datem, March 23, 2023 Re: Authorization for Release of BOCC Approved Funds, Dept of Comm' erce, E -RAP 2.0 Grant #21-4619C-108, Opportunities Industrialization Center (O/C), Request #18 Opportunities Industrialization Center (OIC) has requested reimbursement for the above -referenced grant, per the contracted guidelines in the amount of $311,109-.70 The supporting documentation is attached for your review. I am requesting the release of funds for payment to OIC in the amount of $31,109.70 for April 2023 expenses. Thank you. APPROVEDI MAY 2 .1 2023 CONSENT 13RAAIT COUPTy Co Total dm :. 5 856.84 , _. 5 856 .84 .. .. : .. ... r i\': _. ..: . r • , G � L �. \. , ,. 7 ,, ., `, �„/ .. .. .. . , .. v»,.. , '. G c,.,t, 3 68 9 , Rent n el t Ass st . , _.,.. _. 2 157 7 B nd r Subcont act a Fo . \ �. ,. ..• _ ..,. ,..: ,,, r Rent/Utilities Advance 0.00 t o �m J A rya 'nT,. w 0 $0.00 Totals $31,109.70 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 _.w.. Invoice Total: $31,109.70 Contract 21-4619c-108 Submitted to GC by: OIC OF WASHINGTON Request for Reimbursement No.16 April 2023 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 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-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 Based on actual costs, not budgeted or projected amounts? X Applied uniformly to federal and non-federal activities (Le., 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 maybe in an electronic form. X Correctly charged to the proper account code and grant period? C:\Users\jflynn\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\FCQVG424\Subrecipient Checklist Month2022.doc Page 1 General Ledger System CHIC OF WASHINGTON For User: CHARLENE PARKS Page: Page 2 of 4 Fund Expenditure report for: 408 - ERAP 2.0 10/1/21-6130123 (Fund status: Active) Date: 5/16/2023 Report year: 101112021 thru 613012023 Period ending: April 2023 Time: 7:12:00 AM -----ll3of t ily- -To Date -- Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended 5311 SALARIES,WA.GES EXPENSE $411.00 $3,43£.32 836.09% $7,809.00 $12,631.17 161.75% $81646.88 {$3,984.29} 5351 FICA,OIC EXP $30.00 $254.18 847.27% $570.00 $941.22 165.13% $649.15 ($292.07) 5352 L AND I,OIC SHARE $1.00 $11.80 1180.00% $19.00 $37.52 197.47% $23.14 ($74.38) 5353 STATE UCl(ES),OIC EXP $5.00 $36.43 728.60% $95.00 $153.90 162.00% $113.52 ($40.38) 5355 PAID FAMILY MEDICAL LEAVE $2.00 $28.89 1444.50% $38.00 $86.14 226.68% $50.16 ($35.98) 5360 DISABILITY OIC EXPENSE $5.00 $39.55 791.00% $95.00 $153.67 161.76% $110.91 ($42.76) 5361 MEDICAL INSURANCE,OIC EXP $65.00 $535.03 823.12% $1,235.00 $1,975.30 159.94% $11370.17 ($605.13) 5362 LIFE INSURANCE,OIC EXP $2.00 $17.07 853.50% $38.00 $66.07 173.87% $47.77 ($18.30) 5363 PENSION,OIC EXP $30.00 $252.78 842.60% $570.00 $929.68 163.10% $646.35 ($283.33) 5364 ACCRUED PTO EXP $50.00 $294.89 589.78% $950.00 $1,306.12 137.49% $11054.19 ($251.93) 5602 DEPRECIATION EXP EQUIP $0.00 1 $0.00 0.00% $0.00 $3.15 0.00% $2.90 {$0.25} 5910 INSURANCE $0.00 $6.65 0.00% $0.00 $30.24 0.00% $19.44 ($10.80) 5960 COMMUNICATION $5.00 4 1. $0.00 0.00% $95.00 $87.24 91.83% $111.40 $24.16 Total for sub program $606.00 $4,913.59 810.82% $11,514.00 $187401.42 159.82% $12,845.98 ($5,555.44) Sub program. 50 FACILITY MAINT� 56031 DEPRECIATION EXP BLDG. $1.00 1. ?L $0.00 0.00% $19.00 $22.02 115.89% $23.41 $1.39 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0.17 0.00% $0.16 ($1:1.01) 5611 SPACE $23.00 $0.00 0.00% $437.00 $430.04 98.41% $485.40 $55.36 5630 UTILITIES $6.00 $0.00 0.00% $114.00 $111.83 98.10% $131.34 $19.51 5640 BUILD. REPAIRIMAINT. $10.00 $0.00 0.00% $190.00 $183.58 96.62% $213.16 $29.58 5910 INSURANCE $0.00 $0.00 0.00% $0.00 $0.88 0.00% $1.11 $0.23 5912 LIABILITY INSURANCE $2.00 $0.00 0.00% $38.00 $45.48 119.+68% $50.83 $5.35 Total for sub program 54 -----> $42.00 $0.00 0}.00% L,I• $798.00 $794.00 99.50% $905.41 $111.41 Total for program 82 $648.00 $4,913.59 758.27% $12,312.00 $197195.42 155.91% $131751.39 ($5,444.03) Total for department 008 -----> $884.00 $57851.26 661.91% $161796.00 $26,437.09 157.40% $181916.31 ($7,520.78) Department: 010 PROGRAM Program: 25 PROGRAM SUPPORT 5311 SALARIES,WAGES EXPENSE $1,893.00 $2,268.76 119.85% $35,967.00 $53,259.11 148.08% $39,753.20 ($13,505.91) General Ledger System OIC OF WASHINGTON For User: CHARLENE PARKS Fund Expenditure report for: 498 - ERAP 2.0 10/l/21-6/30/23 (Fund status: Active) Report year: 10/1/2021 thru 613012023 Period ending: April 2023 Page: Page 3 of 4 Date: 5/16/2023 Time: 7:12:01 AM Total for sub program ----> $3,513.00 $3,357.30 95.57% $66,660.00 $77,852.32 116.79% $73,823.18 ($4,029.14) lj� Total for program 25 ----> Program: 30 DIRECT SERVICES $3,513.00 $3,357.30 95.57% $6600.00 +10 ws My, $771852.32 116.79% -To Date— 5959 SERVICES $25,521.00 $21,571.37 84.52%67j484,899.00 Account . . . ...... . Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended 5351 FICA,01C EXP $136-00 $167.66 123.28% $2,584.00 $31930.57 152.11% $2,858.44 ($1,072.13) 5352 LAND I,OIC SHARE $9.00 $14.40 160-00% $171.00 $297.02 173.70% $202.74 ($94.28) 5353 STATE UCI(ES),OIC EXP $30.00 $24.05 80.17% $570.00 $664.91 116-65% $640.05 ($24.86) 5355 PAID FAMILY MEDICAL LEAVE $13.00 $20.50 157.69% $247.00 $366.25 148.28% $276.11 ($90.14) 5360 DISABILITY OIC EXPENSE $30.00 $35.30 117.67% $570.00 $680.89 119.45% $632.36 ($48.53) 5361 MEDICAL INSURANCE,OIC EXP $529.00 $380.78 71.98% $10,051.00 $8,298.83 82.57% $11,113.91 $21815.08 5362 LIFE INSURANCE,OIC EXP $11.00 $14.07 127.91% $209.00 $272.35 130.31% $251.04 ($21.31) 5363 PENSION,OIC EXP $153.00 $179-49 117.31% $2)907.00 $4,027.38 138.54% $3,219.81 ($807.57) 5364 ACCRUED PTO EXP $609.00 $236.10 38.77% $11,571.00 $4,977.79 43.02% $127797.29 $77819-50 5402 AUDIT COSTS $0.00 $0.00 0-00% $0.00 $51.14 0.00% $0.00 ($51.14) 5500 TRAVEL $29.00 $0.00 0.00% $464.00 $29.25 6.30% $535.20 $505.95 5602 DEPRECIATION EXP EQUIP $1.00 4,31 $0.00 0.00% $19.00 $40.19 211.53% $33.30 ($6.89) 5712 REPRODUCTION SUPPLIES $12.00 $0.00 0.00% $228.00 $19.66 8.62% $268.61 $248.95 5728 DRUG/ALCOHOL REHAB SCREE $0.00 $0.00 0.00% $0.00 $50.00 0.00% $0-00 ($50.00) 5910 INSURANCE $7.00 $16.19 231.29% $133.00 $193.96 145.83% $163.58 ($30.38) 5960 COMMUNICATION $51.00 • $0.00 0.00% $969.00 $652.86 67-37% $1,077.54 $424-68 5970 POSTAGE $0.00 tol $0.00 0.00% $0.00 $40.16 0.00% $0.00 ($40.16) Total for sub program ----> $3,513.00 $3,357.30 95.57% $66,660.00 $77,852.32 116.79% $73,823.18 ($4,029.14) lj� Total for program 25 ----> Program: 30 DIRECT SERVICES $3,513.00 $3,357.30 95.57% $6600.00 +10 ws My, $771852.32 116.79% $731823.18 5959 SERVICES $25,521.00 $21,571.37 84.52%67j484,899.00 $564,525.49 116.42% $535,954.95 Total for sub program $251,521.00 $21,571.37 �84.52% $484,899-00 $564,5.25.49 116.42% $5357954.95 Total for program 30 $25,521.00 $21,571.37 84.52% $484,899.00 $564,525.49 116.42% $535,954.95 ($4,029.14) 4 to 0 W> ,) V lb ($28,570.54) ($28,570.54) ($28,570.54) Program: 50 BLDG MAINT/FACILrTY 5601 DEPRECIATION EXP BLDG. $19.00 $0.00 o.00% $361.00 $219.82 60.89% $400.35 $180.53 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0-14 0.00% $0.00 ($0.14) 5611 SPACE $16-00 $0.00 0.00% $304.00 $489.58 161.05% $351.13 ($138.45) 5630 UTILITIES $20.00 71 $0.00 0.00% $380.00 $170.01 44.74% $436.21 $266.20 • General Ledger System - C[C OF WASHINGTON For User: CHARL.ENE PARKS Page: Page 4 of 4 Fund Expenditure report for: 498 - ERAP 2.0 1411121-6130123 (Fund status: Active) Date: 6116/2023 Report year. 101112021 thru 613012023 Period ending- April 2023 Time: 7:12:02 AM _--------- M0nt1,1y -----_.._-- __w_____ ..-To Date - Account Budget Budget Expenditures Pct Budget . Expenditures Pct Annual budget Unexpended 5840 BUILD. REPAI RIMAINT. $22.00 • $0.00 0.00% $418.00 $223.42 53.45%$465.87 $242.25 5910 INSURANCE $0.00 $0.00 0.00% $0.00 $0.73 0.00% $0.00 ($0.73 5912 LIABILITY INSURANCE $8.00 11.77 $0.00 0.00% $152.00 $87.24 57.39% $187.73 $100.49 5980 COMMUNICATION $0.00 $0.00 0.00% $0.00 $1.06 0.00% $0.00 ($1.06) Total for sub program----> $85.00 $rt0 0 011 $1,615.00 $1,192.00 73.81 °lQ $1,841.09 $649.09 4 .� ' Total for program 50 -----> $85.00 0.00% $1,615.00 $17192.00 73.81% $1,841.09 $549.09 Total for department 010 -----> $297119.00 $247928.67 85.61% $553,174.00 $6431569.81 116.34% $611,619.22 ($31,950.59) Fund Totals $30,003.00 $30,779.93 102.59% $569,970.00 $670,006.90 117.55% $630,535.53 {$39,471.37} 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) Page:: Page- I of 4 Date: 5/1612023 Report year'. 101112021 thru 6/3012023 Period ending: April 2023 Time.. 7:11:58 AM --------Monthly-- --To Date— Account Budget Expenditures 'Pet Budget Expenditures Pct Annual budget Unexpended Department: 008 DIRECT ADMIN Program: 80 CEO OFFICE 5311 SALARIES,WAGES EXPENSE $171.00 $682.50 399.12% $3,249.00 $37993.44 122.91% $3,608.26 ($385.18) 5351 FICA,01C, EXP $8.00 $50.42 630..25°l0 . $152.00 $232.96 153.26% $182.26 ($50.70) 5352 L AND IOIC SHARE $0.00 $1.55 0.00% $0.00 $9.17 0.00% $8-10 ($1.07) 5353 STATE UCI(ES),OIC EXP $1.00 $7.23 723.00% $19.00 $38.11 200.58% $32.19 ($5.92) 5355 PAID FAMILY MEDICAL LEAVE $0.00 $5.46 0.00% $0.00 $20-19 0.00% $13.67 ($6.52) 5360 DISABILITY OIC EXPENSE $1.00 $5.54 554.00% $19.00 $33.05 173-95% $29.99 ($3.06) 5361 MEDICAL INSURANCE,01C EXP $16.00 $82.57 516.06% $304.00 $424.88 139.76% $356.55 ($68.33) 5362 LIFE INSURANCE,OIC EXP $0.00 $2.84 0.00% $0.00 $15.54 0.00% $13.48 ($2.06) 5363 PENSION,OIG EXP $13.00 $47.78 367.54% $247.00 $307-51 124.50% $290.54 ($16.97) 5364 ACCRUED PTO EXP $18.00 $51.24 284.67% $342.00 $381.61 111.58% $382.17 $0.56 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0.72 0.00% $0.75 $0.03 5910 INSURANCE $0.00 $0.54 0.00% $0.00 $4.61 0.00% $3.23 ($1.38) 5960 COMMUNICATION $1.00 $0.00 0.00% $19.00 $38.25 201.32% $37.32 ($0.93) 5982 MISC. PROGRAM EXPENSE $0.00 $0.00 0.00% $0.00 $1,500.00 0.00% $0.00 ($1,500.00) Total for sub program $229.00 $937.67 409.46% $4,351.00 $7,000.04 160-88% $4,958.51 ($2,041.53) Sub program: 50 FACILITY MAINT 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% $95.00 $137.50 144.74% $116.54 ($20.96) 5630 UTILITIES $1.00 $0.00 0.00% $19.00 $33.22 174-84% $30.51 ($2.71) 5640 BUILD. REPAIR/MAINT. $1.00 $0.00 0.00% $19.00 $49.11 258.47% $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% $133.00 $241.63 181-68% $206.41 ($35.22) Total for program 80 $236.00 $937.67 397.32% $4,484.00 $77241-67 161.50% $5,164.92 ($2,076.75) Program-.,. 82 CFO / FISCAL 0% 1'hlashivtonSi�ate & a Die;�ament Of "Rao Coihmeive. Instructions: Eviction Rent Assistance Program 2.0 (ERAP 2.0) - Report Form -VERSION 4 'Report Period: Enter corresponding week or month that matches the invoice reimbursement request. Match all of the information below to the information collected on the ERAP2.OPayment Forms andHousehold Information and Eligibility Form. OIC of Washington :,April, 2023 11`111MR, FIR RM M. RIR IMP Household ID rental assistance Total no. of months of Total Rental Assistance utilities assistance Provided Head of Household is 18- Total Utilities 24 or Unaccompanied Assistance Provided Youth 16-17 Ethnicity RentalType EXAMPLE 080120200945 'American Indian/Alaska Native/Indigenous Non-Hispanic/Non- [eased lot space/mooring fee Latin(a)(o)(A 30% or less ����CisgenderMan 30% or less 'Cisgender Woman 30% or less Multiple Races Non-Hispanic/Non-Latin(a)(o)(x) 30% or less --- ����ilCisgenderWom.n 130% or less Cisgender Woman 130% or less Non-Hispanic/Non-Latin(a)(o)(x) 30% or less Hispanic/Latin(a)(o)(x) 30% or less Hispanic/Latin(a)(o)(x) leased rental unit 30% or less •Hispanic/Latin(a)(o)(x 30% or less leased rental unit 30% or less =,11M. 130% or less ... less 30% or less Non-Hispanic/Non-Latin(a)(oft) i 30% or less _Nonji.anic/Non-Latln(a)(offx) •CisgenderWoman Hispanic/Latin(a)(o)(x) 30% or less Cisgender Woman Non-Hispanic/Non-Latin(a)(o)(x) 30% or less Cisgender Man Non-Hispanic/Niin-Latin(a)(,t)(x) 30% or less Cisgender Man ... less Wcis enderWoman :30% or less CisgenderWoman 110MIR 11MIIIIIIIIIII1 30% or less Cisgender Woman 30% or less Cisgender Man Cisgender Woman Cisgender Woman 30% or -less Cisgender Woman ff-MIR 30% or less !CisgenderWoman 130% or -less I Cisgender Woman G, Cisgender Man Cisgender Wo an Cisgender Man 30% or less 30% or less Cisgender Woman ... less- Non-Hispanic/Non-Latin(a)(o)(x) 30% or less Cisgender Woman Fe ffl�Wlll �CisgenderWoman Hispanic/Latin x Aa KoAU 7 •Non-Hispanic/Non-Lat�nW(o)(x) 30% or less IM, U, Cisgender Woman 7CIsgender W*man Summary lNo. of Applications IT661 Households 'I Months of Utility Assistance 'ITotal Amount of Utility Assistance Months of Rental Assistance - 1Total Amount ofRental Assistance - 461 461 1461 21,571.37 01 0 ... .... . . .. .. . .... .ti T a Jb Hbuse 0 5".4 A A gender otherthan singul arly man or,_ Woman (e.g. non-. Transgender M binar' enderfluld/agencleir/culturally an or y/g CLsgender Woman Cisgender Man Transgender Woman specific gender) Questioning Client Doesn't Know Client Refused Data Not Collected 37 9 0 0 0 0 0 0 80%1 20%1 0%1 0%1 0%1 0%1 0%1 0% Ameri an Indian/Alaska -ican American/African Native/Indigenous White Client Doesn't Know Client Refused Data Not Collected Asian or Asian American Native Hawaiian or Pacific Islander Multiple Races 0 1 44 0 0 0 0 0 0% 2% 96% 0% 0% 0% 0% 0% 2% .......... ... . . E ion -His panic/Non-Latin(a)(o)(x) Hispanic/Latln(a)(o)(x) Client Doesn't Know Client Refused Data Not Collected 12 34 0 0 26% 74% 0% 0% 05 AMl�'9 Less than 301A 31-504A 51-80% 32 10 4 70% 22% 9%