Spreadsheet

REAP Spreadsheet.xlsx

Rural Energy for America Program

Spreadsheet

OMB: 0570-0067

Document [xlsx]
Download: xlsx | pdf

Overview

EA REDA ASSUMPTIONS
EA-REDA
RES EEI Assumptions
RES-EEI >$200K
RES-EEI <$200K
RES_EEI<$80K
Grant Cost2Gov


Sheet 1: EA REDA ASSUMPTIONS

4280-B, REAP BURDEN PACKAGE ASSUMPTIONS-EA/REDA

GENERAL ASSUMPTIONS:

Updates were made to "REAP Burden Table final 0570-0067Final" document as compiled by Venus Welch-White.

EA/REDA funding packages for 2017-2019 were reviewed and the average number of applications submitted, in-eligible applications and awards was utilized to create this burden package.

Time recorded in 5 minute intervals. 5 min = .08; 10 min=.16; 15 min =.25; 30 min = .50; 1 hour = 1

Former Burden table (per info from VWW) derived external customer hourly rate using average of: BLS Occupation Code 11-9013 for Farmers and Ranchers (see http://www.bls.gov/oes/2011/may/oes_nat.htm#b11-0000.), rest of US GS-9 Step 5 rate for rural small businesses (see http://www.opm.gov/oca/12tables/pdf/rus_h.pdf), and average rates of NAICS 54169 and 54162 found on table B-3b (see http://www.bls.gov/opub/ee/2012/ces/table3b_201207.pdf). Average wage used was $39.47/hr per plus 36.25% for benefits, or $53.77/hr.

1 Bureau of Labor Statistics, May 2019 National Occupational Employment and Wage Estimates United States. External customer hourly rate using average of: BLS Occupation Code, median average wage, 11-9013 for Farmers and Rancher - $34.21, and Code 11-0000 Management Occupations for rural small business owners-$50.80, average is $42.51/hr. https://www.bls.gov/oes/current/oes_nat.htm#11-0000

For Civilians - Data provided by the Bureau of Labor Statistics, Employer Cost for Employee Compensation – September 2019 is utilized to calculate the total cost of benefits. Benefits as a percentage of total compensation for Private trade, transportation and utilities industry workers were 29.6% of total hourly compensation. See, https://www.bls.gov/news.release/pdf/ecec.pdf. Benefits of 36.25% is added to arrive at total wage rate of $57.91/hr.


LINE # SPECIFIC ASSUMPTIONS:
2 Notifications include: Eligible, in-eligible, and award notification. 28 determinations either eligible/in-eligible, and 22 award/non-award notification. Total of 50 notifications. (Previous burden package used 188 with no notes on assumptions used to derive at total.)
3&4 Burden for DUNS number and SAM registration was seperated. These are two processes with different requirements and different burden on applicants. 1 hour estimated for applicant to get a DUNS number. SAM registration has become more complex with the need for letterhead, a letter, notarization, input into system, and time to sort through any issues that arise after initial submission. An average of 8 hours for SAM registration is being utilized taking into account approximately 30% of applicants face issues getting properly registered in SAM. This does not include the wait time between submission and final issuance of a SAM registration which may add burden on applicant given their REAP application is not considered complete until SAM registration is finalized and therefore they cannot move forward with their project.
5,6,7,18, 25,26 Another office reports burden for the SF forms and therefore there is no dollar amount associated with these forms for this package.
13 SAM registration must be renewed annually.
21 & 39 Previous burden applied hours for Awardee Documents and Certifications, and Reporting and Other, to all Applicants versus just those awarded. This burden modifies the formulas to reflect responses only from those offered an award.

Transfer of obligation provision was removed from rule and therefore removed from award burden section.

Sheet 2: EA-REDA

Section of

Percent of respondents
Reports Total Annual Est. No. of Est. Total
Total
Final Rule
Form No. line item is Est. No. of Filed Responses Hours Hours Wage Cost
4280.XXX Title (if Any) applicable to Respondents Annually (D) x (E) Per Response (F) x (G) Class (H) x (I)











(A) (B) (C)
(D) (E) (F) (G) (H) (I) (J)

Est. No. of Total Respondents (Applicants)

28






Est. No. of Total Awards (Awardees)

22





OTHER REQUIREMENTS









105 Reviews and appeals written 0.50% 0 1.00 0.00 12.00 0.00 $57.91 $0.00
108(e) Discrimation Complaints written 0.50% 0 1.00 0.00 1.00 0.00 $57.91 $0.00

Other Requirements




13 0.00
$0.00
Application









110(f) Application Withdrawal written 1% 0.00 1.00 0.00 0.50 0.00 $57.91 $0.00
111 Notifications written 100% 50.00 1.00 50.00 0.25 12.50 $57.91 $723.88
149(d)(3) DUNS number written 100% 28.00 1.00 28.00 1.00 28.00 $57.91 $1,621.48
149(d)(1) SAM number written 100% 28.00 1.00 28.00 8.00 224.00 $57.91 $12,971.84
153 (b)(1) Application for Federal Assistance SF 424 (4040-0004) 100% 28.00 1.00 0.00 1.00 0.00 $57.91 $0.00
153 (b)(2) Budget Information - Non-Construction Programs SF 424A (4040-0006) 100% 28.00 1.00 0.00 3.00 0.00 $57.91 $0.00
153 (b)(3) Assurances - Non-Construction Program SF 424B (4040-0007) 100% 28.00 1.00 0.00 0.25 0.00 $57.91 $0.00
153 (b)(4) Data to Assist in Assessment of USDA Compliance with Civil Rights Laws None 100% 28.00 1.00 28.00 0.08 2.24 $57.91 $129.72
153 (b)(5) Certification for legal entity written 100% 28.00 1.00 28.00 0.08 2.32 $57.91 $134.58
153 (b)(6) Association or Relationship with Rural Development Employees written 100% 28.00 1.00 28.00 0.08 2.24 $57.91 $129.72
153 (b)(7) Scope of work written 100% 28.00 1.00 28.00 20.00 560.00 $57.91 $32,429.60

Application Burden




34 831.30
$48,140.81
Awardee Documents and Certifications









149(d)(2) SAM Renewal written 100% 22.00 1.00 22.00 1.00 22.00 $57.91 $1,274.02
158 (a) Insurance requirement assignment 100% 22.00 1.00 22.00 0.50 11.00 $57.91 $637.01
123(c)(1) Letter of Intent RD 1942-46 100% 22.00 1.00 22.00 1.00 22.00 $57.91 $1,274.02
123(c)(2) Request for Obligation of Funds RD 1940-1 100% 22.00 1.00 22.00 0.25 5.50 $57.91 $318.51

Assurance Agrement RD 400-4 100% 22.00 1.00 22.00 0.25 5.50 $57.91 $318.51
123(c)(4) Disclosure of Lobbying Activities SF LLL (4040-0013) 100% 22.00 1.00 0.00 0.16 0.00 $0.00 $0.00
123 (c)(8) Certification Regarding Debarment, Suspension, Ineligibility, and Voluntary Exclusion - Lower Tier Covered Transactions AD-1048 (0505-0027) 100% 22.00 1.00 22.00 0.25 5.50 $57.91 $318.51

Certification Regarding Debarment, Suspension, and Other Responsibility Matters - Primary Covered Transactions. (Captured in SAMS Certs and Reps) AD-1047 (0505-0027) 100% 22.00 1.00 22.00 0.25 0.00 $57.91 $0.00

Certification Regarding Drug-Free Workplace Requirements (Grants) Alternative I - For Grantees Other Than Individuals AD-1049 (0505-0027) 100% 22.00 1.00 22.00 0.25 0.00 $57.91 $0.00
123(d) Evidence of matching funds written 100% 22.00 1.00 22.00 1.00 22.00 $57.91 $1,274.02
123(f) Rural Business Cooperative Service Financial Assistance Agreement RD 4280-2 100% 22.00 1.00 22.00 1.00 22.00 $57.91 $1,274.02
124(b) Programmatic changes written 100% 22.00 1.00 22.00 0.50 11.00 $57.91 $637.01
159 (a) Request for Advance or Reimbursement SF-270 (4040-00120004) 100% 22.00 5.00 0.00 1.00 0.00 $0.00 $0.00
124(i)(1) Federal Financial Report SF 425 (4040-0014) 100% 22.00 2.00 0.00 1.50 0.00 $0.00 $0.00
159 (b) Semiannual Project Performance Report written 100% 22.00 2.00 44.00 1.00 44.00 $57.91 $2,548.04
159 ( c) Final Project Performance Report written 100% 22.00 1.00 22.00 1.00 22.00 $57.91 $1,274.02

Award Burden




11 192.50
$11,147.68
Reporting & Other









124(c) Transfer of ownership written 1% 0.00 1.00 0.00 0.50 0.00 $57.91 $0.00
124(f) Audit requirements written 2% 0.00 1.00 0.00 24.00 0.00 $57.91 $0.00
159(d) Outcome Project Performance Reports 4280-3D 100% 22.00 1.00 22.00 1.00 22.00 $57.91 $1,274.02
124 (e) Recordkeeping written 100% 22.00 1.00 22.00 1.00 22.00 $57.91 $1,274.02

Servicing Burden




27 44.00
$2,548.04





Total 570.00
1,067.80
$61,836.53

Sheet 3: RES EEI Assumptions

4280-B, REAP BURDEN PACKAGE ASSUMPTIONS-RES/EEI

GENERAL ASSUMPTIONS:

Updates were made to "REAP Burden Table final 0570-0067Final" document as compiled by Venus Welch-White.

Package removes 3 guaranteed loan only tabs as loan only guarantee requests will no longer be a part of the OneRD regulation. Removed combo tabs as combos will be combined and reported as grants, with the loan portion of combinations reflected in the OneRD burden.

Combined FY19 obligations and FY19 unfunded applications to determine estimate total number of respondents for FY2020. Estimate participation will be the same so kept same respondent numbers.

Estimate total awards to be down by 10% given we funded more projects in FY19 than is typical given loan dollars were converted to grant dollars. Awards in FY19 were: Over$200K-202 More$80KLess$200K-438; $80k or less-663. Reduced awards by 10%.

Time recorded in 5 minute intervals. 5 min = .08; 10 min=.16; 15 min =.25; 30 min = .50; 1 hour = 1

Transfer of ownership provision was removed from rule and therefore from award burden.

Former Burden table (per info from VWW) derived external customer hourly rate using average of: BLS Occupation Code 11-9013 for Farmers and Ranchers (see http://www.bls.gov/oes/2011/may/oes_nat.htm#b11-0000.), rest of US GS-9 Step 5 rate for rural small businesses (see http://www.opm.gov/oca/12tables/pdf/rus_h.pdf), and average rates of NAICS 54169 and 54162 found on table B-3b (see http://www.bls.gov/opub/ee/2012/ces/table3b_201207.pdf). Average wage used was $39.47/hr per plus 36.25% for benefits, or $53.77/hr.

1 Bureau of Labor Statistics, May 2019 National Occupational Employment and Wage Estimates United States. External customer hourly rate using average of: BLS Occupation Code, median average wage, 11-9013 for Farmers and Rancher - $34.21, and Code 11-0000 Management Occupations for rural small business owners-$50.80, average is $42.51/hr. https://www.bls.gov/oes/current/oes_nat.htm#11-0000. For Civilians - Data provided by the Bureau of Labor Statistics, Employer Cost for Employee Compensation – September 2019 is utilized to calculate the total cost of benefits. Benefits as a percentage of total compensation for Private trade, transportation and utilities industry workers were 29.6% of total hourly compensation. See, https://www.bls.gov/news.release/pdf/ecec.pdf. Benefits of 36.25% is added to arrive at total wage rate of $57.91/hr.

Formulas in Column F for "Award Documents and Certification" and "Servicing" in previous package were tied to total applicants. Corrected to tie the formula to only awarded applications.

If form/document/action is applicable to all awardees, percentage should be 100%, versus previous burden listing 35%. Made correction.

Used historical obligations from FY15-FY19 to determine the estimated need for feasibility studies, technical reports, energy audits, etc. Broke down percent by application thresholds.(Spreadsheet FY15-19 Obligation report 11.12.19)


LINE # SPECIFIC ASSUMPTIONS:

Reviews and appeals were included in other reporting requirements in previous burden packages for the grant requests of $200,000 or greater.

Discrimination complaints were included in other reporting requirements in previous burden packages for the grant requests of $200,000 or greater.
2 Notifications include: Eligible or in-eligible, and award or non-award notification. (Previous burden package used 311 with no notes on assumptions used to derive at total notifications.)
3&4 Burden for DUNS number and SAM registration was seperated. These are two processes with different requirements and different burden on applicants. 1 hour estimated for applicant to get a DUNS number. SAM registration has become more complex with the need for letterhead, a letter, notarization, input into system, and time to sort through any issues that arise after initial submission. An average of 8 hours for SAM registration is being utilized taking into account approximately 30% of applicants face issues getting properly registered in SAM. This does not include the wait time between submission and final issuance of a SAM registration which may add burden on applicant given their REAP application is not considered complete until SAM registration is finalized and therefore they cannot move forward with their project.

Regulatory language encourages self-certification but does not require it. Removed self-scoring documentation from application burden.
5 FY19 Award data indicates about 13% of $200K or greater, 1% of more than $80K less than $200K, and 1% of $80K or less applications, are filed for technologies other than wind, solar, gethermal or EEI. These techologies will likely need to submit a feasibility study under the new rule and therefore these %'s are used in projections. (Note: Previous regulation required a feasibility study for all RES projects with TPC of $200,000 or greater, regardless of technology.)
6 4280-3 A,B, C application forms will be revised as applicants can now certify their eligibility as a rural small business or agricultural producers versus submitting documentation of such. Pulled hours for technical report and energy audit as separate line items in burden so reduced hours on 4280-A,B, C form.
10 Added AD3030 to burden package BUT REMOVED LATER GIVEN CERTIFICATIONS WILL BE IN SAM
12 Documenting match with application is not required to be eligible. 75% provide information to receive points under scoring.
14 All applications must show technical feasibility. The level of detail provided varies by threshold and by type of technology. Using FY19 award numbers, all EEI and those RES that are less common in the market place were assumed to provide a detailed technical report. Level of detail decreases and thus number of hours to complete decreases as application threshold decreases.
15 Based on FY2019 info EEI applications are approximately 22% of total $200K or greater applications, 29% of middle threshold applications, 39% of applications $80K or less. If TPC are $200K or less, an audit or assessment may be provided, therefore total hours per response are less in bottom two tiers given some file energy assessments versus energy audits.

Increased extension requests from 2% to 5%.
23 Added AD3031 to burden package BUT REMOVED LATER GIVEN CERTIFICATIONS WILL BE IN SAM
28 SAM registration must be updated annually.
30 Looked at FY19 data to determine percent of technologies funded that typically utilize power purchase agreements (solar, wind, hydro, hybrid, hydroelectric) and took 1/2 of the total percent to account for self-use/replacement projects.
32 Assume that 75% of projects with TPC of $200,000 or greater have construction contracts in place and therefore need to execute form. 50% for other thresholds.
33 Assume that 75% of projects with TPC of $200,000 or greater have construction contracts in place and therefore need to execute form. 50% for other thresholds. Last burden indicated form was required for all awardees and contractors. It is not needed for awardees, they sign AD-1047.
34 Assume that 75% of projects with TPC of $200,000 or greater have construction contracts in place and therefore need to execute form. 50% for other thresholds, although $80,000 or less would not require the 1940-Q, Exhibit A-1.
35 All grantees need to make statement. Last burden did not include this.
36 All need contractor to sign off on project, RES must show 30 day operational status prior to sign off. Last burden did not include this.
37 Assume that 75% of projects with TPC of $200,000 or greater have construction contracts in place and therefore need to execute form. 50% for other thresholds
38 Assume that 75% of projects with TPC of $200,000 or greater have construction contracts in place and therefore need to execute form. 50% for other thresholds. Last burden indicated form was required for all awardees and contractors. It is not needed for a
40 Review total development costs on historical caseload, approx. 40% over $1MM. 4 certifications required by PE: design, installation monitoring, testing prior to commercial operation, and project completion certification.
39-42 Assuming 10% of largest threshold, 5% of middle threshold and 0% of applications 80K or less will need surety, final plans and specs, and construction contracts. Smaller applications typically work off a bid with one contractor and utilize the single disbursment method. NOTE: These items were not listed on the last burden package even though they were required by regulation. Adding to ensure complete accounting of time.
45 A Final Project Performance Report is needed with last SF425 report. This was not on last burden package even though required by regulation. Adding to ensure complete accounting of time.
46 Site inspections are optional. Assume 25% have inspections.
47 Most projects do one payout at end of construction so utilized one submission of SF271.
48 Added Electronic Funds Transfer form, SF 3881. Burden for this form is reported elsewhere.

NOTE AWARD BURDEN RESPONSE HOURS MAY HAVE INCREASED OVER LAST PACKAGE AS NUMEROUS ITEMS WERE NOT LISTED THAT SHOULD BE ACCOUNTED FOR. See notes in individual lines.
50 If grant funds were used to purchase assets with a unit value of $5,000 or greater, the assets must be monitored bi-annually. Assume 50% of grants with TPC of $200,000 or greater must be monitored; 25% 80-200K; 10% 80K or under. This was a change from the last time the burden package was completed. At that time assets did not require bi-annual monitoring.
51 Last package had 35% reporting. All grantees must meet reporting requirements.
52 Added annual outcome project performance certification-RES. Grantees with RES projects can certify that systems were installed and are performing as intended versus submitting actual annual output numbers. Assume 90% will utilize certification. Valued at .5 with other .5 given to RES report.
52 Added annual outcome project performance certification-EEI. Grantees with EEI projects can certify that systems were installed and are performing as intended versus submitting actual annual output numbers. Assume 90% will utilize certification. Valued at .5 with other .5 given to EEI report.
54 Assume 10% will file reports.Valued at .5 with other .5 given to certification.
55 Assume 10% will file reports. Valued at .5 with other .5 given to certification.



Sheet 4: RES-EEI >$200K

Section of Projects with TPC $200,000 and Greater
Percent of respondents
Reports Total Annual Est. No. of Est. Total
Total
Final Rule
Form No. line item is Est. No. of Filed Responses Hours Hours Wage Cost
4280.XXX Title (if Any) applicable to Respondents Annually (D) x (E) Per Response (F) x (G) Class (H) x (I)











(A) (B) (C)
(D) (E) (F) (G) (H) (I) (J)

Est. No. of Total Respondents (Applicants)

218






Est. No. of Total Awards (Awardees)

181





OTHER REQUIREMENTS









105 Reviews and appeals written 0.50% 1 1.00 1.00 12.00 12.00 $57.91 $694.92
108(e) Discrimation Complaints written 0.50% 1 1.00 1.00 1.00 1.00 $57.91 $57.91

Other Requirements




13 13.00
$752.83
APPLICATION









110(f) Application Withdrawal written 1% 2 1.00 2.00 0.50 1.00 $57.91 $57.91
111 Notifications written 100% 218 1.00 218.00 0.25 54.50 $57.91 $3,156.10
112(e) DUNS number written 100% 218 1.00 218.00 1.50 327.00 $57.91 $18,936.57
112(f) SAM Registration written 100% 218 1.00 218.00 8.00 1,744.00 $57.91 $100,995.04
116(b) Feasibility study - RES Feasibility Study 13% 28 1.00 28.00 40.00 1,120.00 $57.91 $64,859.20
118 (a)(4); 118(a)(6)-(9); 18(b)(1)-(2); 18(b)(4); 18(c) Application for Renewable Energy Systems and Energy Efficiency Improvements Projects, Total Project Costs of $200,000 and greater. RD 4280-3C 100% 218 1.00 218.00 10.00 2,180.00 $57.91 $126,243.80
118(a)(1) Application for Federal Assistance SF 424 (4040-0004) 100% 218 1.00 218.00 1.00 218.00 $0.00 $0.00
118(a)(2) Budget Information - Construction Programs SF 424C (4040-0008) 100% 218 1.00 218.00 3.00 654.00 $0.00 $0.00
118(a)(3) Assurances - Construction Programs SF 424D (4040-0009) 100% 218 1.00 218.00 0.25 54.50 $0.00 $0.00











118(a)(5) Environmental Report written 100% 218 1.00 218.00 6.00 1,308.00 $57.91 $75,746.28
118(c )(4) Matching funds documentation Statements or letter 75% 164 1.00 164.00 1.00 164.00 $57.91 $9,497.24
118(b)(3) Financial information (historical, current, projected) Balance sheets; income statements; cash flows 100% 218 1.00 218.00 20.00 4,360.00 $57.91 $252,487.60
118(d) Technical Report written 36% 78 1.00 78.00 16.00 1,248.00 $57.91 $72,271.68
118(d) Energy Audit written 22% 48 1.00 48.00 16.00 768.00 $57.91 $44,474.88

Application Burden



RES 108 14,201.00
$768,726.30
EEI 84
AWARDEE DOCUMENTS AND CERTIFICATIONS









110(g)(2) Technical Report Modifications written 1% 2 1.00 2.00 1.00 2.00 $57.91 $115.82
110(h)(1) Time Extensions written 5% 9 1.00 9.00 0.50 4.50 $57.91 $260.60
123(b) Insurance requirements assignment 100% 181 1.00 181.00 1.00 181.00 $57.91 $10,481.71
123(c)(1) Letter of Intent RD 1942-46 100% 181 1.00 181.00 1.00 181.00 $57.91 $10,481.71
123(c)(2) Request for Obligation of Funds RD 1940-1 100% 181 1.00 181.00 0.25 45.25 $57.91 $2,620.43
123(c)(4) Disclosure of Lobbying Activities SF LLL (4040-0013) 100% 181 1.00 181.00 0.25 45.25 $0.00 $0.00
123(c)(6) Equal Opportunity Agreement RD 400-1 100% 181 1.00 181.00 0.25 45.25 $57.91 $2,620.43
123(d) Evidence of matching funds written 100% 181 1.00 181.00 1.00 181.00 $57.91 $10,481.71
123(e) SAM Renewal written 100% 181 1.00 181.00 1.00 181.00 $57.91 $10,481.71
123(f) Rural Business Cooperative Service Financial Assistance Agreement RD 4280-2 100% 181 1.00 181.00 1.00 181.00 $57.91 $10,481.71
123(h) Power purchase agreement written 32% 58 1.00 58.00 1.50 87.00 $57.91 $5,038.17
124(b) Programmatic changes written 0.50% 1 1.00 1.00 0.50 0.50 $57.91 $28.96

Assurance Agreement RD 400-4 75.00% 136 1.00 136.00 0.25 34.00 $57.91 $1,968.94
119(c )(3)(i); 120(c )(3)(i) Compliance Statement (Contract in excess of $10,000) RD-400-6 75% 136 1.00 136.00 0.25 34.00 $57.91 $1,968.94
119(c )(3)(ii); 120(c)(3)(ii); 123(c)(8); Certification Regarding Debarment, Suspension, Ineligibility, and Voluntary Exclusion - Lower Tier Covered Transactions (Contract in excess of $25,000) AD-1048 (0505-0027) 75% 136 1.00 136.00 0.25 34.00 $57.91 $1,968.94

Certification Regarding Debarment, Suspension, and Other Responsibility Matters - Primary Covered Transactions. (Captured in SAMS Certs and Reps) AD-1047 (0505-0027) 75% 136 1.00 136.00 0.25 0.00 $57.91 $0.00

Certification Regarding Drug-Free Workplace Requirements (Grants) Alternative I - For Grantees Other Than Individuals AD-1049 (0505-0027) 75% 136 1.00 136.00 0.25 0.00 $57.91 $0.00
119(c )(3)(iii); 120(c )(3)(iii) Certification for Contracts,Grants and Loans (grants over $100,000) 1940-Q, Exh. A-1 75% 136 1.00 136.00 0.25 34.00 $57.91 $1,968.94
119(d)(1) Grantee acceptance of contractor work Grantee certification 100% 181 1.00 181.00 0.25 45.25 $57.91 $2,620.43
119(d)(1) & (2) Contractor Certification -final completion & 30 days (RES) Contractor certification 100% 181 1.00 181.00 1.00 181.00 $57.91 $10,481.71
119 (d)(3); 120 (d)(3) Certificate of Contractor's Release RD 1924-9 75% 136 1.00 136.00 0.25 34.00 $57.91 $1,968.94
119 (d)(3); 120 (d)(3) Release by Claimants RD 1924-10 75% 136 1.00 136.00 1.00 136.00 $57.91 $7,875.76
125(a)(3) Surety
10% 18 1.00 18.00 1.00 18.00 $57.91 $1,042.38
125( c) Technical services (TPC $1,000,000 or greater) PE certification 40% 72 4.00 288.00 1.00 288.00 $57.91 $16,678.08
125(d) Final plans and specs Plans and specs 10% 18 1.00 18.00 2.00 36.00 $57.91 $2,084.76
125(e ) Contruction Contract written contract 10% 18 1.00 18.00 2.00 36.00 $57.91 $2,084.76
124(i)(1) Federal Financial Report SF 425 (4040-0014) 100% 181 2.00 362.00 0.50 181.00 $0.00 $0.00
124(i)(2)(i) Semiannual Project Performance Report written 100% 181 2.00 362.00 0.50 181.00 $57.91 $10,481.71
124(i)(2)(ii) Final Project Performance Report written 100% 181 1.00 181.00 0.50 90.50 $57.91 $5,240.86
124(a) Inspection site visit 25% 45 1.00 45.00 0.50 22.50 $57.91 $1,302.98
124(g)(4) Outlay Report and Request for Reimbursement for Construction Programs SF 271 (4040-0011) 100% 181 1.00 181.00 1.00 181.00 $0.00 $0.00

Award Burden



RES 22 2,701.00
$132,831.06
EEI 21
SERVICING









124(c) Transfer of ownership written 1% 1 1.00 1.00 0.50 0.50 $57.91 $28.96
124(d) Disposition/bi-annual check of acquired property written 50% 91 1.00 91.00 1.00 91.00 $57.91 $5,269.81
124 ( e ) Recordkeeping written 100% 181 1.00 181.00 1.00 181.00 $57.91 $10,481.71
124(i)(3)(i) Annual outcome project performance certification-RES 4280-3D 90% 163 0.50 81.50 0.25 20.38 $57.91 $1,179.92
124(i)(3)(i) Annual outcome project performance certification-EEI 4280-3D 90% 163 0.50 81.50 0.25 20.38 $57.91 $1,179.92
124(i)(3)ii) Annual outcome project performance report -RES 4280-3D 10% 18 0.50 9.00 2.00 18.00 $57.91 $1,042.38
124(i)(3)ii) Annual outcome project performance report-EEI 4280-3D 10% 18 0.50 9.00 1.00 9.00 $57.91 $521.19

Servicing Burden



RES 5 3,244.75
$153,837.92
EEI 4





Total Annual Responses 7,179








Total Est.Hours

20,159.75






Total Burden



$1,056,148.10

Sheet 5: RES-EEI <$200K


Section of Projects with TPC <$200,000 but more than $80,000
Percent of respondents
Reports Total Annual Est. No. of Est. Total
Total

Final Rule
Form No. line item is Est. No. of Filed Responses Hours Hours Wage Cost

4280.XXX Title (if Any) applicable to Respondents Annually (D) x (E) Per Response (F) x (G) Class (H) x (I)













(A) (B) (C)
(D) (E) (F) (G) (H) (I) (J)


Est. No. of Total Respondents (Applicants)

430







Est. No. of Total Awards (Awardees)

394





LINE # APPLICATION









1 110(f) Application Withdrawal written 1% 4 1.00 4.00 0.50 2.00 $57.91 $115.82
2 111 Notifications written 100% 430 1.00 430.00 0.25 107.50 $57.91 $6,225.33
3 112(e) DUNS number written 100% 430 1.00 430.00 1.50 645.00 $57.91 $37,351.95
4 112(f) SAM Registration written 100% 430 1.00 430.00 8.00 3,440.00 $57.91 $199,210.40
5 116(b) Feasibility study - RES Feasibility Study 1% 4 1.00 4.00 40.00 160.00 $57.91 $9,265.60
6 118 (a)(4); 118(a)(6)-(9); 18(b)(1)-(2); 18(b)(4); 18(c) Application for Renewable Energy Systems and Energy Efficiency Improvements Projects, Total Project Costs of Less than $200,000 but greater than $80,000. RD 4280-3B 100% 430 1.00 430.00 10.00 4,300.00 $57.91 $249,013.00
7 118(a)(1) Application for Federal Assistance SF 424 (4040-0004) 100% 430 1.00 430.00 1.00 430.00 $0.00 $0.00
8 118(a)(2) Budget Information - Construction Programs SF 424C (4040-0008) 100% 430 1.00 430.00 3.00 1,290.00 $0.00 $0.00
9 118(a)(3) Assurances - Construction Programs SF 424D (4040-0009) 100% 430 1.00 430.00 0.25 107.50 $0.00 $0.00
11 118(a)(5) Environmental Report written 100% 430 1.00 430.00 6.00 2,580.00 $57.91 $149,407.80
12 118(c )(4) Matching funds documentation Statements or letter 75% 323 1.00 323.00 1.00 323.00 $57.91 $18,704.93
13 118(b)(3) Financial information (historical, current, projected) Balance sheets; income statements; cash flows 0% 0 1.00 0.00 0.00 0.00 $57.91 $0.00
14 118(d) Technical Report written 30% 129 1.00 129.00 8.00 1,032.00 $57.91 $59,763.12
15 118(d) Energy Audit written 29% 125 1.00 125.00 8.00 1,000.00 $57.91 $57,910.00


Application Burden



RES 80 15,417.00
$786,967.95
EEI 48

AWARDEE DOCUMENTS AND CERTIFICATIONS









16 110(g)(2) Technical Report Modifications written 1% 4 1.00 4.00 1.00 4.00 $57.91 $231.64
17 110(h)(1) Time Extensions written 5% 20 1.00 20.00 0.50 10.00 $57.91 $579.10
18 123(b) Insurance requirements assignment 100% 394 1.00 394.00 1.00 394.00 $57.91 $22,816.54
19 123(c)(1) Letter of Intent RD 1942-46 100% 394 1.00 394.00 1.00 394.00 $57.91 $22,816.54
20 123(c)(2) Request for Obligation of Funds RD 1940-1 100% 394 1.00 394.00 0.25 98.50 $57.91 $5,704.14
22 123(c)(4) Disclosure of Lobbying Activities SF LLL (4040-0013) 100% 394 1.00 394.00 0.25 98.50 $0.00 $0.00
25 123(c)(6) Equal Opportunity Agreement RD 400-1 100% 394 1.00 394.00 0.25 98.50 $57.91 $5,704.14
26
Assurance Agreement RD 400-4 100% 394 1.00 394.00 0.25 98.50 $57.91 $5,704.14
27 123(d) Evidence of matching funds written 100% 394 1.00 394.00 1.00 394.00 $57.91 $22,816.54
28 123(e) SAM Renewal written 100% 394 1.00 394.00 1.00 394.00 $57.91 $22,816.54
29 123(f) Rural Business Cooperative Service Financial Assistance Agreement RD 4280-2 100% 394 1.00 394.00 1.00 394.00 $57.91 $22,816.54
30 123(h) Power purchase agreement written 34% 134 1.00 134.00 1.50 201.00 $57.91 $11,639.91
31 124(b) Programmatic changes written 0.50% 2 1.00 2.00 0.50 1.00 $57.91 $57.91
32 119(c )(3)(i); 120(c )(3)(i) Compliance Statement (Contract in excess of $10,000) RD-400-6 50% 197 1.00 197.00 0.25 49.25 $57.91 $2,852.07
33 119(c )(3)(ii); 120(c)(3)(ii); 123(c)(8); Certification Regarding Debarment, Suspension, Ineligibility, and Voluntary Exclusion - Lower Tier Covered Transactions (Contract in excess of $25,000) AD-1048 (0505-0027) 50% 197 1.00 197.00 0.25 49.25 $57.91 $2,852.07


Certification Regarding Debarment, Suspension, and Other Responsibility Matters - Primary Covered Transactions. (Captured in SAMS Certs and Reps) AD-1047 (0505-0027) 50% 197 1.00 197.00 0.25 0.00 $57.91 $0.00


Certification Regarding Drug-Free Workplace Requirements (Grants) Alternative I - For Grantees Other Than Individuals AD-1049 (0505-0027) 50% 197 1.00 197.00 0.25
$57.91 $0.00
34 119(c )(3)(iii); 120(c )(3)(iii) Certification for Contracts,Grants and Loans (grants over $100,000) 1940-Q, Exh. A-1 50% 197 1.00 197.00 0.25 49.25 $57.91 $2,852.07
35 119(d)(1) Grantee acceptance of contractor work Grantee certification 100% 394 1.00 394.00 0.25 98.50 $57.91 $5,704.14
36 119(d)(1) & (2) Contractor Certification -final completion & 30 days (RES) Contractor certification 100% 394 1.00 394.00 1.00 394.00 $57.91 $22,816.54
37 119 (d)(3); 120 (d)(3) Certificate of Contractor's Release RD 1924-9 50% 197 1.00 197.00 0.25 49.25 $57.91 $2,852.07
38 119 (d)(3); 120 (d)(3) Release by Claimants RD 1924-10 50% 197 1.00 197.00 1.00 197.00 $57.91 $11,408.27
39 125(a)(3) Surety
5% 20 1.00 20.00 1.00 20.00 $57.91 $1,158.20
40 125( c) Technical services (TPC $1,000,000 or greater) PE certification 0% 0 4.00 0.00 0.00 0.00 $57.91 $0.00
41 125(d) Final plans and specs Plans and specs 5% 20 1.00 20.00 2.00 40.00 $57.91 $2,316.40
42 125(e ) Contruction Contract written contract 5% 20 1.00 20.00 2.00 40.00 $57.91 $2,316.40
43 124(i)(1) Federal Financial Report SF 425 (4040-0014) 100% 394 2.00 788.00 0.50 394.00 $0.00 $0.00
44 124(i)(2)(i) Semiannual Project Performance Report written 100% 394 2.00 788.00 0.50 394.00 $57.91 $22,816.54
45 124(i)(2)(ii) Final Project Performance Report written 100% 394 1.00 394.00 0.50 197.00 $57.91 $11,408.27
46 124(a) Inspection site visit 25% 99 1.00 99.00 0.50 49.50 $57.91 $2,866.55
47 124(g)(4) Outlay Report and Request for Reimbursement for Construction Programs SF 271 (4040-0011) 100% 394 1.00 394.00 1.00 394.00 $0.00 $0.00


Award Burden



RES 21 4,995.00
$237,923.24
EEI 20

SERVICING









49 124(c) Transfer of ownership written 1% 2 1.00 2.00 0.50 1.00 $57.91 $57.91
50 124(d) Disposition/bi-annual check of acquired property written 25% 99 1.00 99.00 1.00 99.00 $57.91 $5,733.09
51 124 ( e ) Recordkeeping written 100% 394 1.00 394.00 1.00 394.00 $57.91 $22,816.54
52 124(i)(3)(i) Annual outcome project performance certification-RES 4280-3D 90% 355 0.50 177.50 0.25 44.38 $57.91 $2,569.76
53 124(i)(3)(i) Annual outcome project performance certification-EEI 4280-3D 90% 355 0.50 177.50 0.25 44.38 $57.91 $2,569.76
54 124(i)(3)ii) Annual outcome project performance report -RES 4280-3D 10% 39 0.50 19.50 2.00 39.00 $57.91 $2,258.49
55 124(i)(3)ii) Annual outcome project performance report-EEI 4280-3D 10% 39 0.50 19.50 1.00 19.50 $57.91 $1,129.25


Servicing Burden



RES 5 641.25
$37,134.79
EEI 4






Total Annual Responses 13,310









Total Est.Hours

21,053.25







Total Burden



$1,062,025.97

Sheet 6: RES_EEI<$80K

Section of Projects with TPC $80,000 or less
Percent of respondents
Reports Total Annual Est. No. of Est. Total
Total
Final Rule
Form No. line item is Est. No. of Filed Responses Hours Hours Wage Cost
4280.XXX Title (if Any) applicable to Respondents Annually (D) x (E) Per Response (F) x (G) Class (H) x (I)











(A) (B) (C)
(D) (E) (F) (G) (H) (I) (J)

Est. No. of Total Respondents (Applicants)

758






Est. No. of Total Awards (Awardees)

596





APPLICATION









110(f) Application Withdrawal written 1% 8 1.00 8.00 0.50 4.00 $57.91 $231.64
111 Notifications written 100% 758 1.00 758.00 0.25 189.50 $57.91 $10,973.95
112(e) DUNS number written 100% 758 1.00 758.00 1.50 1,137.00 $57.91 $65,843.67
112(f) SAM Registration written 100% 758 1.00 758.00 8.00 6,064.00 $57.91 $351,166.24
116(b) Feasibility study - RES Feasibility Study 1% 8 1.00 8.00 40.00 320.00 $57.91 $18,531.20
118 (a)(4); 118(a)(6)-(9); 18(b)(1)-(2); 18(b)(4); 18(c) Application for Renewable Energy Systems and Energy Efficiency Improvements Projects, Total Project Costs of $80,000 or less. RD 4280-3A 100% 758 1.00 758.00 10.00 7,580.00 $57.91 $438,957.80
118(a)(1) Application for Federal Assistance SF 424 (4040-0004) 100% 758 1.00 758.00 1.00 758.00 $0.00 $0.00
118(a)(2) Budget Information - Construction Programs SF 424C (4040-0008) 100% 758 1.00 758.00 3.00 2,274.00 $0.00 $0.00
118(a)(3) Assurances - Construction Programs SF 424D (4040-0009) 100% 758 1.00 758.00 0.25 189.50 $0.00 $0.00
118(a)(5) Environmental Report written 100% 758 1.00 758.00 6.00 4,548.00 $57.91 $263,374.68
118(c )(4) Matching funds documentation Statements or letter 75% 569 1.00 569.00 1.00 569.00 $57.91 $32,950.79
118(b)(3) Financial information (historical, current, projected) Balance sheets; income statements; cash flows 0% 0 1.00 0.00 0.00 0.00 $57.91 $0.00
118(d) Technical Report written 40% 303 1.00 303.00 4.00 1,212.00 $57.91 $70,186.92
118(d) Energy Audit written 39% 296 1.00 296.00 4.00 1,184.00 $57.91 $68,565.44

Application Burden



RES 76 26,029.00
$1,320,782.33
EEI 40
AWARDEE DOCUMENTS AND CERTIFICATIONS









110(g)(2) Technical Report Modifications written 1% 6 1.00 6.00 1.00 6.00 $57.91 $347.46
110(h)(1) Time Extensions written 5% 30 1.00 30.00 0.50 15.00 $57.91 $868.65
123(b) Insurance requirements assignment 100% 596 1.00 596.00 1.00 596.00 $57.91 $34,514.36
123(c)(1) Letter of Intent RD 1942-46 100% 596 1.00 596.00 1.00 596.00 $57.91 $34,514.36
123(c)(2) Request for Obligation of Funds RD 1940-1 100% 596 1.00 596.00 0.25 149.00 $57.91 $8,628.59
123(c)(4) Disclosure of Lobbying Activities SF LLL (4040-0013) 100% 596 1.00 596.00 0.25 149.00 $0.00 $0.00
123(c)(6) Equal Opportunity Agreement RD 400-1 100% 596 1.00 596.00 0.25 149.00 $57.91 $8,628.59
123(d) Evidence of matching funds written 100% 596 1.00 596.00 1.00 596.00 $57.91 $34,514.36
123(e) SAM Renewal written 100% 596 1.00 596.00 1.00 596.00 $57.91 $34,514.36
123(f) Rural Business Cooperative Service Financial Assistance Agreement RD 4280-2 100% 596 1.00 596.00 1.00 596.00 $57.91 $34,514.36
123(h) Power purchase agreement written 29% 173 1.00 173.00 1.50 259.50 $57.91 $15,027.65
124(b) Programmatic changes written 0.50% 3 1.00 3.00 1.00 3.00 $57.91 $173.73

Assurance Agreement RD-400-4 50% 298 1.00 298.00 0.25 74.50 $57.91 $4,314.30
119(c )(3)(i); 120(c )(3)(i) Compliance Statement (Contract in excess of $10,000) RD-400-6 50% 298 1.00 298.00 0.25 74.50 $57.91 $4,314.30
119(c )(3)(ii); 120(c)(3)(ii); 123(c)(8); Certification Regarding Debarment, Suspension, Ineligibility, and Voluntary Exclusion - Lower Tier Covered Transactions (Contract in excess of $25,000) AD-1048 (0505-0027) 50% 298 1.00 298.00 0.25 74.50 $57.91 $4,314.30

Certification Regarding Debarment, Suspension, and Other Responsibility Matters - Primary Covered Transactions. (Captured in SAMS Certs and Reps) AD-1047 (0505-0027) 50% 298 1.00 298.00 0.25 0.00 $57.91 $0.00

Certification Regarding Drug-Free Workplace Requirements (Grants) Alternative I - For Grantees Other Than Individuals AD-1049 (0505-0027) 50% 298 1.00 298.00 0.25 0.00 $57.91 $0.00
119(d)(1) Grantee acceptance of contractor work Grantee certification 100% 596 1.00 596.00 0.25 149.00 $57.91 $8,628.59
119(d)(1) & (2) Contractor Certification -final completion & 30 days (RES) Contractor certification 100% 596 1.00 596.00 1.00 596.00 $57.91 $34,514.36
119 (d)(3); 120 (d)(3) Certificate of Contractor's Release RD 1924-9 50% 298 1.00 298.00 0.00 0.00 $57.91 $0.00
119 (d)(3); 120 (d)(3) Release by Claimants RD 1924-10 50% 298 1.00 298.00 1.00 298.00 $57.91 $17,257.18
125(a)(3) Surety
0% 0 1.00 0.00 1.00 0.00 $57.91 $0.00
125( c) Technical services (TPC $1,000,000 or greater) PE certification 0% 0 4.00 0.00 0.00 0.00 $57.91 $0.00
125(d) Final plans and specs Plans and specs 0% 0 1.00 0.00 2.00 0.00 $57.91 $0.00
125(e ) Contruction Contract written contract 0% 0 1.00 0.00 2.00 0.00 $57.91 $0.00
124(i)(1) Federal Financial Report SF 425 (4040-0014) 100% 596 2.00 1192.00 0.50 596.00 $0.00 $0.00
124(i)(2)(i) Semiannual Project Performance Report written 100% 596 2.00 1192.00 0.50 596.00 $57.91 $34,514.36
124(i)(2)(ii) Final Project Performance Report written 100% 596 1.00 596.00 0.50 298.00 $57.91 $17,257.18
124(a) Inspection site visit 25% 149 1.00 149.00 0.50 74.50 $57.91 $4,314.30
124(g)(4) Outlay Report and Request for Reimbursement for Construction Programs SF 271 (4040-0011) 100% 596 1.00 596.00 1.00 596.00 $0.00 $0.00

Award Burden



RES 21 7,137.50
$335,675.32
EEI 20
SERVICING









124(c) Transfer of ownership written 1% 3 1.00 3.00 0.50 1.50 $57.91 $86.87
124(d) Disposition/bi-annual check of acquired property written 10% 60 1.00 60.00 1.00 60.00 $57.91 $3,474.60
124 ( e ) Recordkeeping written 100% 596 1.00 596.00 1.00 596.00 $57.91 $34,514.36
124(i)(3)(i) Annual outcome project performance certification-RES 4280-3D 90% 536 0.50 268.00 0.25 67.00 $57.91 $3,879.97
124(i)(3)(i) Annual outcome project performance certification-EEI 4280-3D 90% 536 0.50 268.00 0.25 67.00 $57.91 $3,879.97
124(i)(3)ii) Annual outcome project performance report -RES 4280-3D 10% 60 0.50 30.00 2.00 60.00 $57.91 $3,474.60
124(i)(3)ii) Annual outcome project performance report-EEI 4280-3D 10% 60 0.50 30.00 1.00 30.00 $57.91 $1,737.30

Servicing Burden



RES 5 8,689.50
$51,047.67
EEI 4





Total Annual Responses 20,486








Total Est.Hours

41,856.00






Total Burden



$1,707,505.31

Sheet 7: Grant Cost2Gov

Cost to the Federal Government - REAP Grants
Activity
Number
# of Hours-Baseline
# of Hours New Rule
Total # of Hours-Baseline
Total # of Hours-New Rule
Rate
TOTAL $ Baseline TOTAL $ New Rule
Applications: Application Review















RES/EEI Application review - greater than 200,000
243
20
18
4,860
4,374
$55.19
$268,223.40 $241,401.06
RES/EEI Application review - 200,000 to greater than 80,000
471
15
13
7,065
6,123
$55.19
$389,917.35 $337,928.37
RES/EEI Application review - $80,000 and less
721
10
8
7,210
5,768
$55.19
$397,919.90 $318,335.92
RES/EEI Technical merit review - greater than 200,000
243
8
8
1,944
700
$55.19
$107,289.36 $38,624.17
RES/EEI Technical merit review - 200,000 to greater than 80,000
471
4
4
1,884
565
$55.19
$103,977.96 $31,193.39
RES/EEI Technical merit review - $80,000 and less
721
2
2
1,442
577
$55.19
$79,583.98 $31,833.59
EA/REDA Application review
22
10
10
220
220
$55.19
$12,141.80 $12,141.80
Awards: Approval, Obligation, Servicing













$-
Approve and obligate funds - RES/EEI & EA/REDA
1,333
8
8
10,664
10,664
$55.19
$588,546.16 $588,546.16
Servicing actions other than monitoring
87
4
4
348
348
$55.19
$19,206.12 $19,206.12
Planning and Performance
1,333
16
16
21,328
21,328
$55.19
$1,177,092.32 $1,177,092.32
Reporting and Grant Disbursement - RES/EEI & EA/REDA
1,333
16
10
21,328
13,330
$55.19
$1,177,092.32 $735,682.70












$55.19

$-
Appeals
1
16
16
16
16
$55.19
$883.04 $883.04
ANNUALIZED TOTAL:






78,309
64,013


$4,321,873.71 $3,532,868.64 $789,005.07

















Number of applications and awards based on FY2019 Actuals and applied to both baseline and new rule.















The reviews are typically completed by GS-11 & 12 State Loan Specialists and GS-13 State Program Directors.
Rate used was a GS 12-5, Rest of US, at rate of $40.51/hour, found at: https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/2019/general-schedule/
36.25% is Federal employee benefit cost factor, found at: (https://www.whitehouse.gov/sites/whitehouse.gov/files/omb/memoranda/2008/m08-13.pdf )
Total rate = $55.19
























*Assume 2 hours saved on applicant eligibility review in each threshold due to applicant being able to certify















Assume same TR review time, however only applied to % that will submit TR's under new rule as noted in tab for each threshold.















EA/REDA reviews remain unchanged.















Only significant change in Awards was in reporting area due to certification which applicants can use versus supplying annual performance reports. Reduced by 5 hours.















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

© 2024 OMB.report | Privacy Policy