Loading...
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