Spreadsheet

Spreadsheet-ARPA ERHC (1-12-2022).xlsx

American Rescue Plan Act Emergency Rural Health Care (ERHC) Grant Program

Spreadsheet

OMB: 0575-0200

Document [xlsx]
Download: xlsx | pdf

Overview

Public Burden - Summary
Staff Burden
Est. Appl & Grantees


Sheet 1: Public Burden - Summary





OMB No. 0575-0200













American Rescue Plan Act (ARPA) Emergency Rural Health Care (ERHC) Grant Program











































IDENTIFICATION OF REPORTING AND RECORDKEEPPING REQUIREMENTS




ANNUAL BURDEN





https://www.bls.gov/oes/current/oes_stru.htm#13-0000



FORM

REPORTS







hourly wage w/ benefits


NO(s) NO. OF NO. OF TOTAL HOURS TOTAL Wages Cost to Wage Cost to
11-3031 Financial Manager 72.84 Plan, direct, or coordinate accounting, investing, banking, insurance, securities, and other financial activities of a branch, office, or department of an establishment. Excludes "Financial Risk Specialists" (13-2054).
SECTION OF
(If "none" RESPON- RESPONSES ANNUAL PER HOURS Class the public incl benefits the public
11-1021 General and Operations Mgrs 60.45 Plan, direct, or coordinate the operations of public or private sector organizations, overseeing multiple departments or locations. Duties and responsibilities include formulating policies, managing daily operations, and planning the use of materials and human resources, but are too diverse and general in nature to be classified in any one functional area of management or administration, such as personnel, purchasing, or administrative services. Usually manage through subordinate supervisors. Excludes First-Line Supervisors.
REGULATIONS DESCRIPTION so state) DENTS PER RESPONSES RESPONSE (Col. f & g)

31% incl benefits
13-2098 Financial specialists 46.46




RESPON- (Col. d & e)

$ / hr (h) x (i) (i) x 1.31 (h) x (k)







DENT










(a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l)




NON FORM- COLLECTED AND ACCOUNTED FOR UNDER THIS COLLECTION














Summary Page & Table of Contents written 1,092 1 1,092 0.167 182 46.46 8,473 60.86 11,099




Evidence of Legal Existence and Authority written 1,092 1 1,092 0.25 273 46.46 12,684 60.86 16,615




Narrative - Project Proposal, Track I written 1,000 1 1,000 20 20,000 60.45 1,209,000 79.19 1,583,790



Narrative - Project Proposal, Track II written 92 1 92 120 11,040 60.45 667,368 79.19 874,252




Environmental Information in response to 7 CFR 1970 written 1,092 1 1,092 5 5,460 46.46 253,672 60.86 332,310




Preliminary Architectural Feasibility Report or Engineering Documentation written 279 1 279 10 2,786 60.45 168,438 79.19 220,653




Matching Funds Certification & Documentation written 1,092 1 1,092 1 1,092 46.46 50,734 60.86 66,462




Audits/Financial Statements written 1,092 1 1,092 7 7,644 46.46 355,140 60.86 465,234




CPA Certifications Regarding Funds Requested written 500 1 500 4 2,000 72.84 145,680 95.42 190,841




Intergovernmental Review Comments written 1,092 1 1,092 0.25 273 46.46 12,684 60.86 16,615




Documentation of Assistance Provided to Rural Development Employees written 1,092 1 1,092 0.25 273 46.46 12,684 60.86 16,615




Indirect Cost Rate Agreement written 819
819 1 819 46.46 38,051 60.86 49,846




Subtotal:


10,334
51,842
$2,934,608
$3,844,332




















APPLICATION SUBMISSIONS - FORM BURDEN ACCOUNTED FOR UNDER THIS COLLECTION














AD Form 1047 – “Certification Regarding Debarment, Suspension, and Other Responsibility Matters” AD-1047 765 1 765 0.25 191 46.46 8,881 60.86 11,634




Form RD 3570-3 , “Community Facilities Grant Agreement.” RD-3570 765 1 765 0.25 191 60.45 11,555 79.19 15,137




Form RD 442-2, "Statement of Budget, Income and Equity" RD 442-2 140 1 140 1 140 46.46 6,504 60.86 8,520




Form RD 442-3, "Balance Sheet" RD 442-3 140 1 140 1 140 46.46 6,504 60.86 8,520




Form RD 442-7, "Operating Budget" RD 442-7 140 1 140 1 140 46.46 6,504 60.86 8,520




Subtotal


1,950
802
$39,948
$52,331




















REPORTING REQs - NON FORMS -ACCOUNTED FOR UNDER THIS COLLECTION














Lease/Management Agreement written 253 1 253 5 1,267 46.46 58,844 60.86 77,085




Liens on real property written 279 1 279 1 279 46.46 12,946 60.86 16,959




Interim Financing written 279 1 279 4 1,115 46.46 51,782 60.86 67,835




Audits/Financial Statements written 765 3 2,294 7 16,056 46.46 745,973 60.86 977,225




Subtotal:


3,105
18,717
$869,545
$1,139,104




















ESTIMATED TOTAL FOR THIS COLLECTION
1,092
15,389
71,681
$3,844,101
$5,035,767




















REPORTING REQUIREMENTS – FORMS APPROVED UNDER OTHER OMB DOCKET NUMBERS














Form RD 400-1, “Equal Opportunity Agreement”  RD 400-1 765 1 765 0.167 128 60.45 7,719 79.19 10,111




Form RD 400-4, “Assurance Agreement” RD 400-4 140 1 765 0.25 191 60.45 11,555 79.19 15,137




Form SF 425 - “Federal Financial Report” (OMB No. 4040-0014) SF-425 765 12 9,180 1 9,180 46.46 426,503 60.86 25,956,969




Form SF 424 - “Application for Federal Assistance” (OMB No.4040-0004) SF-424 765 1 765 1 765 46.46 35,542 60.86 46,560




Total
2,435 15 11,475
10,264
481,319
26,028,777




















































































































































































Sheet 2: Staff Burden


Avg Grade Level # Staff Annual Salary % of Time Cost to Administer Note
National Office 14/5 1 138,866 75 111,093

13/5 5 117,516 75 470,064
State Office (rest of US) 13/5 47 104,429 75 3,926,530

11/5 47 73,271 75 2,754,990 Revised 5/10/21 to GS 11/5





7,262,677

Sheet 3: Est. Appl & Grantees

Estimated Awardees















Available Funding Avg Grant Size - Low Avg Grant Size - Hi Est. # Low Est. # High Est. # Total Awards Explanation
Track I 350,000,000 50,000 850,000 2800 247 750 Updated to more closely align with actual applications received and anticipated funded. Average application amounts are larger than initial estimates.
Track II 125,000,000 7,500,000 10,000,000 8.33333 6 15 No change

475,000,000



765
















Estimated Applicants

Track I 1,000 Updated to more closely align with actual applications received and expected to receive until funding is no longer available.
Track II 92 Updated to more closely align with actual applications received by Track Two application deadline of October 12, 2021.

1,092





File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy