Loading...
HomeMy WebLinkAboutGrant Related - BOCCGRANT COUNTY II "!I BOARD OF COUNTY COMMISSIONERS Memo To: Board of County Commissioners From: Janice Flynn, Administrative Services Coordinator P t Date March 16, 2023 Re: Authorization for Release of BOCC Approved Funds, Dept of Commerce, E -RAP 2.0 Grant #21-4619C-108, Opportunities Industrialization Center (OIC), Request # 16 Opportunities Industrialization Center (OIC) has requested reimbursement for the above -referenced grant, per the contracted guidelines in the amount of $50,355.80 The supporting documentation is attached for your review. am requesting the release of funds for payment to OIC in the amount of $50,355.80 for February 2023 expenses. Thank you. MAR 12 1 2023 4 Lead Grantee Name: OIC OF WASHINGTON I list Sub Grantee Names Below ITota I Report Week or Month/Year: FEBRUARY 2023 I I I_ I I I Admin $448.47 $448.47 Operations $1,728.71 $1,728.71 Rent and Utility Assistance $48,178.62 $48,178.62 By and For Subcontracting $0.00 Rent/Utilities Advance $0.00 By and For Advance $0.00 Totals $50,355.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Invoice Total: $50,355.80 Summary I s No. of Applications Total Households Months of Utility Assistance ITotal Amount of utility Assistance Month of Rental Assistance Total Amount ofRentalAssMance 921 921 3221 $ 48,178.62 01 0 Head 11 OT14ousenoidA.1..1 ' A gender other than singularly man or q woman (e.g. non- Transgender Man or binary/genderfluid/agefider/c6lturally ,CisgenderWoman Cisgender Man Transgender Woman specific gender) Questioning Client Doesn't Know Client Refused Data Not Collected 72 20 0 0 0 0 01 78%F- 22%1 0%1 0%1 0%1 0%, 0%1 0% eaa oouseno julsace T ti Ame rican Indian/Alaska lack/African American/African Native/Indigenous White Client Doesn'tKrow, Client Refused, Data Not Collected Asian or Asian American Native Hawaiian or Pacific Islander Multiple Races 0 0 90 1 1 0 0 0 0 0% 0% 98% 1% 1% 0% 0% 0% 0% . . . . . . . . . . . . Head o o0teh6l Et hic 4on-Hispanic/Non-Latin(a)(o)(x) HiSpanIc/Latjn(a)(o)(x)' Client Doesn't Know : Client Refused Data'Not Collected 29 60 0 2 32% 65% 0% 2% 15 7� Less than 30% 31-500A 51_80% 57 24 11 62% 26% 12% Contract 21-4619c-108 Submitted to GC by: OIC OF WASHINGTON Request for Reimbursement No.14 February 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 (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\jflynn\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\FCQVG424\Subrecipient Checklist Month2022.doc Page 1 (3.�erierc­,,,fl Ledger System OIC OF WASHINGTON For User.- CHARLENE PARKS Page: Page 3 of 4 Fund Expenditure report for: 498 - ERAP 2.0 10/l/21-6/30/23 (Fund status: Active) Date: 3/16/2023 Report year: 10/1/2021 thr"U 6130/2023 Period ending: February 2023 Time: 9:09:53 AM . .............. . .. . . .. . .............. ............ . . ... . ............ . ..... . ..... . . . . .......... . ............ ­­_­ . . ....... . . ................ ...... . . ..... 1_­-­11___­_­ . . ......... . .............. . . ....... . ....... . . .... . ...... Account Budget Expenditures Pct Budget Expenditures PCt Annual budget Unexpended ... ....... .... . . ....... . . ........ . ...... . ...... . . . ....... .... ­,_ .. . .... . ......... ­ .............. ............... ................ . ............ . ................................... ............................. . ... . ...... . . ......... .. . . . . . ........... - I .. . . . ............. - . .. ........ ........... - 1.11 1.."..,..... 1.1.1-111.1- .......... I ''I I'll 5351 FICA, A1C EXP $136.00 $46-59 3426% $2,312,00 $3,477.52 150.41% $2,858.44 ($619-08) 5352 L AND I, IC SHARE $9.00 $4.26 47.33% $153.00 $256.80 167.84% $202.74 ($54.06) 5353 STATE UCI(ES),QIC EXP $30.00 $6.89 22.97% $510.00 $599-58 117.56% $640.05 $40.47 5355 PAID FAMILY MEDICAL LF-AVE $13.00 $5.99 46,08% $221.00 $313.46 141.84% $276.11 ($37.35) 5360 DISABILIT)4 OIC EXPENS3E $30.00 $13.83 4& "10% $510.00 $594.46 116,56% $632.36 $37.90 5361 MEDICAL INSURANCE,01C EXP $529.00 $213.76 40.4'I% $81993.00 $7,264.40 80,78% $111113.91 $3,849.51 5362 LIFE INSURANCE,01C EXP $,.11.00 $5.47 49.73% $187.00 1$237.92 127.23% $251.04 $13.12 5363 PENSION, IC EXP $153.00 $52,38 34.24% $2,601.00 $3*565.12 137.07% $3,219.81 ($345.31) 5364 ACCRUED PTO EXP $609-00 $98-14 16.11% $10,353.00 $4,388.71 42.3i9% $12,797.29 $8,408.58 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% $406.00 $29.25 7.20% $535.20 $505.95 5602 DEPRECIATION EXP EQUIP $1.00 $0.00 0.0010 $1700 $20.28 119.29% $33.30 $13.02 5712 REPRODUCT ION SUPPLIES $12.00 $0.00 0.00% $204.00 $19.66 9,64% $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 $2.63 37.57% $119.00 $164.53 138.26% $163.58 ($0.95) 5960 COMMUNICATION $51.00 $0,00 0.00% $867.00 $318.53 :36,74% $1,077.54 $759.01 Total for sub program $3,513.00 $1,099.60 31.30% $59,634.00 $68,447.13 114.78% $73,823.18 $51376.05 Total for program 25 ----- > $3,513.00 $1,099,60 3 634.00 $68,447.13 114.78% $73;823.18 $5,376.05 14 Prograrn: 30 DIRECT SERVICES d 0 5959 SERVICES $25,521.00 $,48,178.2 188.78% $4331857.00 $473,920.20 109.2310 $5351954.95 $621034.75 . .. .............. Total for stjb program $25,521.00 $48,178.62 188.78% $433,857.00 $473,920,20 109.23% $535,954.95 $62,034.75 Total for program 30 -----> $25,521.00 �18 :11 -S 188.78% $433,857.00 $473,920.20 109.23% $535,954.95 $62,034.75 Prograrn 50 BLDG NIAINT/FACILITY 5601 DEPRECIATION EXP BLDG. $19,00 141,31 0. 0 0 0.00% $323.00 $144-21 44.65% $400.35 $256.14 5602 DEPRECIATION EXP EQUIP $0,00 $0.0 0 0,00% $0.00 $0.13 0,00% $0.00 ($0.13) 5611 SPACE $1&00 $0.00 0.00% $272,00 $424.26 155-98% $351.13 ($73.13) 5630 UTILITIES $20.00 30.00 0,00% $340,00 $111.30 32.74% $436.21 $324.91 5640 BUILD. REPAIR./rVIAINT. $22.00 $0.00 0.00% $374.00 $154.06 41.19% $465.67 $311.61 General Ledger System OIC OF WASHINGTON For User: CHARLENE PARKS Page: Page 1 of 4 Fund Expenditure report for: 498 - ERAP 2.0 10/1/21-6/30123 (Fund status: Active) Date: 3/16/2023 Report year: 10/1/2021 thru 6/30/2023 Period ending: February 2023 Time: 9:09:48 AM ---To Date - Account Budget Expenditures Pct Budget Expenditures Pct Annua[budget Unexpended . ... ... .... . . . ...... .......... Department: 008 DIRECT ADMIN Program: 80 CEO OFFICE 5311 SALARIES,WAGES EXPENSE $171,00 $0.00 0.00% $2,907.00 $21940.02 101.14% $3,608.26 $668.24 5351 FICA,OIC EXP $8.00 $0.00 0-00% $136.00 $155.14 114.07% $182.26 $27.12 5352 L AND I,OIC SHARE $0.00 $0.00 0-00% $0.00 $6.65 0.00% $8.10 $1.45 5353 STATE UCI(ES),OIC EXP $1.00 $0.00 0.00% $17.00 $26.95 158.53% $32.19 $5.24 5355 PAID FAMILY MEDICAL LEAVE $0.00 $0.00 0.00% $0.00 $11.76 0.00% $13.67 $1.91 5360 DISABILITY OIC EXPENSE $1.00 $0.00 0.00% $17.00 $24.50 144.12% $29.99 $5.49 5361 MEDICAL INSURANCEIOIC EXP $16.00 $0.00 0.00% $272.00 $297.44 109.35% $356.55 $59.11 5362 LIFE INSURANCE,01C EXP $0.00 $0.00 0-00% $0.00 $11.16 0.00% $1148 $2.32 5363 PENSION,OIC EXP $13.00 $0.00 0.00% $221.00 $233.77 105.78% $290.54 $56.77 5364 ACCRUED PTO EXP $18.00 $0-00 0.00% $306.00 $302.52 98.86% $382.17 $79.65 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.00 0.00% $0.00 $3.75 0.00% $3.23 ($0.52) 5960 COMMUNICATION $1.00 $0.00 0.00% $17.00 $36.36 213.88% $37.32 $0.96 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 $0.00 0.00% $3,893.00 $5,550.74 142.58% $4,958.51 ($592.23) 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 r $0.00 0-00% $0.00 $0.07 0.00% $0.04 ($0.03) 5611 SPACE $5.00 $0.00 0.00% $85-00 $137.50 161.76% $116.54 ($20.96) 5630 UTILITIES $1.00 $0.00 0.00% $17.00 $33.22 195.41% $30.51 ($2-71) 5640 BUILD. REPAIR/MAINT. $1.00 $0.00 0.00% $17.00 $49.11 288.88% $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% $119.00 $241.63 203.05% $206.41 ($35.22) Total for program 80 -----> $236.00 $0.00 0.0010 $4,012.00 $51792.37 144.38% $5,164.92 ($627.45) Program: 82 CFO/ FISCAL Mimr= OIC OF WASHINGTON For User: CHARLENE PARKS Page: Page 2 of 4 Fund Expenditure report for: 498 - ERAP 2.0 10/1121-6/30123 (Fund status: Active) Date: 3/1612023 Report year: 10/1/2021 thru 6130/2023 Period ending: February 2023 Time: 9:09:51 AM To Date Account Budget Expenditures Pct Budget Expenditures Pct Annual budget Unexpended .... ...... 5311 SALARIES,WAGES EXPENSE $411.00 $310-87 75.64% $6,987.00 $7,996.71 114.45% $8,646.88 $650.17 5351 FICA,01C EXP $30-00 $23.04 76.80% $510.00 $598.23 117-30% $649.15 $50.92 5352 L AND 1,01C SHARE $1.00 $0.8.1 81.00% $17.00 $22.13 130-18% $23.14 $1.01 5353 STATE UCI(ES),OIC EXP $5.00 $3.30 66.00% $85.00 $104.77 123.26% $113.52 $8.75 5355 PAID FAMILY MEDICAL LEAVE $2.00 $2.54 127,00% $34.00 $47.47 139-62% $50.16 $2.69 5360 DISABILITY OIC EXPENSE $5.00 $4.37 87.40% $85.00 $101.53 119.45% $110.91 $9.38 5361 MEDICAL INSURANCE,OIC EXP $65.00 $45.17 69.49% $1,105.00 $11273.47 115.25% $11370.17 $96.70 5362 LIFE INSURANCE,01C EXP $2.00 $1.74 87.00% $34.00 $43.44 127.76% $47-77 $4.33 5363 PENSION,OIC EXP $30.00 $22.25 74.17% $510.00 $591.41 115.96% $646.35 $54.94 5364 ACCRUED PTO EXP $50.00 '$33-82 67.64% $850-00 $890.81 104.80% $1,054.19 $163.38 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $3.04 0.00% $2.90 ($0.14) 5910 INSURANCE $0.00 $0.56 0.00% $0.00 $21.74 0.00% $19.44 ($2.30) 5960 COMMUNICATION $5.00 $0.00 0.00% $85.00 $84.98 99.98% $111.40 $26.42 Total for sub program $606,00 $448.47 74.00% $10,302.00 $117779.73 114.34% $121845-98 $1,066.25 Sub program: 50 FACILITY MAINT 5601 DEPRECIATION EXP BLDG. $1.00 $0.00 0.00% $17.00 $20.70 121.76% $23.41 $2.71 5602 DEPRECIATION EXP EQUIP $0.00 $0.00 0.00% $0.00 $0.17 0.00% $0.16 ($0.01) 5611 SPACE $23.00 $0.00 0.00% $391.00 $430.04 109.98% $485.40 $55.36 5630 UTILITIES $6.00 $0.00 0.00% $102.00 $111-83 '109.64% $131.34 $19.51 5640 BUILD. REPAIR/MAINT. $10.00 $0.00 0.00% $170,00 $183.58 107.99% $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% $34.00 $45.48 133.76% $50.83 $5.35 Total for sub program 50 $42.00 $0.00 0.00% $714.00 $792.68 111.02% $905.41 $112.73 Total for program 82 ----> $648.00 $448.47 69.21% $11,016.00 $121572.41 114.13% $131751.39 $11178.98 Total for department 008 ---> $884.00 $448.47 50.73% $15,023.00 $18,364.78 122.20% $181916.31 $551.53 Department: 010 PROGRAM Program: 25 PROGRAM SUPPORT 5311 SALARIESOAGES EXPENSE $1,893.00 $649.66 34.32% $327131.00 $47,095.77 146.35% $39753.20 ($7,342.57) General Ledger System OIC OF WASHINGTON For User.- CHARLENE PARKS Fund Expenditure report for: 498 - ERA 2.0 10/l/21-6/30/2/3 (FLInd status: Active) Page: Page 4 of 4 Date- 3/16/2023 Report year: 10/1/2021 thou 6/30/2023 Period ending.- February 2023 Time: 9:09:55 AM -To Date -------- Account Budget Expenditures Pct BUdget Expenditures Pct Annual budget Unexpended 5910 INSURANCE $0.00 $0.00 0.00% $0.00 $0.69 ....... 0.00% ..... $0.00 ($0.69) 5912 LIABILITY INSURANCE 111;8.00 0.00 0.00% $136.00$187.73 $69.97 51.45% $117.76 5960 COMMUNICATION $0.00 $0.00 OM% $0.00 $1,06 0.00% $0.00 ($1.06) Total for sub prog'am $85.00 $0.00 0.00% $1?,445.00 $905.68 62.68% $1,641.09 ............ $935.41 4 -- Total for proani 50 $85M —som 0,00% $1,445.00 $905.68 62.68% $10841.09 $935.41 Total for departi"nent 010 ----- > $29,119.00 $49,278.22 169.23% $49e,$i936,00 $543273.01 109.77% $611,619.22 $68,346.21 Fund Totais $30,003.00 $49,726-69 165.74% 1$509,9614M $5611637,79 110.13% $630,535.53 $68,897.74 141p, 60 �SS.gf 43o.ab WasningrNoYnG Slat )17iiFTiercv C Eviction Rent Assistance Program 2.0 (ERAP -.. •- .. - • - •• . -- . . - - . - - . 2.0) - Report Form -VERSION 4 - -. - . WIIML7�El 11 ME I RIM. .- . . - .KILU910. - -• . - I • i LZLIJ WAGAUfig If Total. Applications Received EXAMPLE: 080120200945 30% or less CisgenderW0n1dn_ 30". or less .. .. .. . .or less • • or less .• .. ... . .. • . . •--CisgenderWonian Hispa 0% or less .... or less .•Cisgender Woman Hispanic/Latin(a)(o)(x).•. . �. ,� •• . . Cisgender Woman .. . •Cisgend His .. :. . Cisgender Woman Hispanic/Latin(a)(o)(x):. . Cisgender Woman .. . Cisgender Woman Latin aV&jjx) Cisgender Woman WTAM� Data Not Collected Cisgender Woman 1=1111M Hispanic/Lati (a)(s)(x) 301,'. or less Cisgender Man Cisgender Man Cisgender Woman :• •Cisgender Woman.. Cisgender Woman Cisgender Man Cisgender Woman FIT .: . .Cisgender Woman.. ,., Cisgender Wtman.. . ,.IDIOM Cisgender W*man• ' Cisg�±ni6r Man.. . • .. ., . - Ci5gender Woman .. . . • .•Cisgender Woman His.anic/Latin(.. Cisgeniki Woman.. Ci5gender Woman .. �• Cisgender Woman .. • . .Cigenier W#man• . Cisgender Woman :..:.Ci5gender Woman.. • .. .. . ..Cisgender Woman.. ,; .. .• . 554 4 665.67 no Cis ender Man White Non-His .panic/Non-Latin(a)(o)(x) 30% or less 554 3 241.01 no Cis ender Man White Non-His panic/Non-Latin(a)(o)(x) 30% or less 359 5 511.07 no Cis ender Woman White His panic/Latin(a)(o)(x) 51-80% 520 3 324.16 no Cis ender Man White His panic/Latin(a)(o)(x) 30% or less 544 3 459.00 no Cis ender Woman White His panic/Latin(a)(o)(x) 31-50% 544 2 212.78 no Cis ender Woman White His panic/Latin(a)(o)(x) 31-50% 577 1 277.26 no Cis ender Woman �White His panic/Latin(a)(o)(x) 31-50% 562 12 $ 2,983.47 no Cis ender Man White His panic/Latin(a)(o)(x) 30% or less 578 3 $ 123.34 no Cis ender Woman White His panic/Latin(a)(o)(x) 30% or less 578 2 $ 313.19 no Cis ender Woman White His panic/Latin(a)(o)(x) 30% or less 579 2 $ 349.46 no Cis ender Woman White Non-His panic/Non-Latin(a)(o)(x) 31-50% 557 5 $ 1,683.98 no Cis ender Man White His panic/Latin(a)(o)(x) 31-50% 595 3 $ 543.00 no Cis ender Woman White His panic/Latin(a)(o)(x) 30% or less 596 4 $ 1,036.68 no Cis ender Woman White His panic/Latin(a)(o)(x) 30% or less PA DEV 3 $ 1,534.17 no Cis ender Woman White Non-His pdnic/Non-Latin(a)(o)(x) 31-501/'. 582 4 $ 758.52 no Cis ender Man White Non-His panic/Non-Latin(a)(o)(x) 30% or less 524 4 $ 367.79 no Cis ender Woman White His pariic/Latin(a)(o)(x) 51-80% 524 3 $ 853.70 no Cis ender Woman White His pan ic/Latin(a)(o)(x) 51-80% 493 4 $ 349.16 no Cis ender Woman White Non-H is pan ic/Non-Latin(a)(o)(> leased rental unit 30% or less 588 3 $ 689.73 no Cis ender Woman White His panic/Latin(a)(o)(x) 30% or less 555 2 $ 1,343.27 no Cis ender Man White His panic/Latin(a)(o)(x) 30% or less 2583 4 $ 228.00 no Cis ender Man White Non-His panic/Non-Latin(a)(o)(x) 30% or less 2583 2 $ 205.26 no Cis ender Man White Non-His panic/Non-Latin(a)(o)(x) 30% or less 552 5 $ 293.60 no Cis ender Woman White His pan ic/Latin(a)(o)(x) 31-501,/. 552 3 $ 591.10 no Cis ender Woman White His pan ic/Latin(a)(o)(x) 31-501. 558 2 $ 735.59 no Cis ender Man White His pan ic/Latin(a)(o)(x) 30% or less 601 9 $ 1,494.56 no Cis ender Man Client Refused Client Refused 51-80% 601 3 $ 418.76 no Cis ender Man Client Doesn't Know Client Refused 51-801/. 584 2 $ 467.32 no Cis ender Woman White His pan ic/Latin(a)(o)(x) 30% or less 570 3 $ 784.27 no Cis ender Woman White His panic/Latin(a)(o)(x) 30% or less 567 1 $ 264.27 no Cis ender Woman White His panic/Latin(a)(o)(x) 31-50% 549 3 $ 171.08 no Cis ender Woman White His panic/Latin(a)(o)(x) 30%. or less 564 1 $ 238.36 no Cis ender Woman White His panic/Latin(a)(o)(x) 30%or less 564 3 $ 629.44 no Cis ender Woman White His panic/Latin(a)(o)(x) 30% or less 492 2 $ 466.41 no Cis ender Man White His panic/Latin(a)(o)(x) 31-50% 568 2 $ 160.00 no Cis ender Woman White Non-His panic/Non-Latiji(a)(o)(x) 30% or less 575 5 $ 360.31 no Cis ender Woman White His panic/Latin(a)(o)(X) 30% or less