Burden Hours Workbook

Burden Hours PACE 2023 09 29.xlsm

Powering Affordable Clean Energy Program

Burden Hours Workbook

OMB: 0572-0159

Document [xlsx]
Download: xlsx | pdf

Overview

12 Burden Hours
12 Not Inc in Burden Hours
12 Est Prof Wage Rate
14 Annual Cost to Fed Gov Est


Sheet 1: 12 Burden Hours

USDA RURAL UTILITIES SERVICE
POWERING AFFORDABLE CLEAN ENERGY (ACE) PROGRAM
INFORMATION COLLECTION BURDEN HOURS
OMB # 0572-0159
September 29, 2023











Estimated No. of Total Respondents (Applicants)
250





Estimated No. of Total Awards (Awardees) 70
Average hours per response
10.712





Number of responses per respondent 8.71
Gray Columns have automatic formulas. DO NOT input numbers in these columns.



TOTAL 2,178
23,333
$1,451,613
(A) (B) (C)
(D) (E) (F) (G) (H) (I) (J)
NOFO
Section
Title Form No.
(If Any)
% of Respondents Line Item is Applicable To Estimated # of Respondents Reports Filed Annually Total Responses
(D) x (E)
Estimated # of Hours Per Response Estimated Total Hours
(F) x (G)
Prof. Wage Rate Total Cost
(H) x (I)
LOI AND APPLICATION CONTENT
D.3 SAM Registration written 100% 250 1 250 2.00 500 $62.21 $31,107
D.2(a) Step 1: Letter of Interest written 100% 250 1 250 5.00 1,250 $62.21 $77,766
D.2(b) Step 2: Application








D.2(b)(1) Loan Application Letter written 100% 70 1 70 1.00 70 $62.21 $4,355
D.2(b)(2) Articles of Incorporation and Bylaws and Other Governing and Organizational Documents (New Borrowers or Current Borrowers with Organizational Changes) written 88% 61 1 61 0.50 31 $62.21 $1,905
D.2(b)(3) Environmental - Categorical Exclusion without Report written 9% 6 1 6 1.00 6 $62.21 $392
D.2(b)(3) Environmental - Categorical Exclusion with Report written 16% 11 1 11 20.00 224 $62.21 $13,936
D.2(b)(3) Environmental - Environmental Assessment written 70% 49 1 49 50.00 2,450 $62.21 $152,422
D.2(b)(3) Environmental - Environmental Impact Statement written 5% 4 1 4 150.00 525 $62.21 $32,662
D.2(b)(4) Financial Forecast written 100% 70 1 70 40.00 2,800 $62.21 $174,197
D.2(b)(5) Power Purchase Agreement (Applicable) written 50% 35 1 35 40.00 1,400 $62.21 $87,098
D.2(b)(6) Power Resources Owned, Co-Owned or Leased (Applicable) written 50% 35 1 35 10.00 350 $62.21 $21,775
D.2(b)(7) Power Purchase Contracts (Applicable) written 50% 35 1 35 10.00 350 $62.21 $21,775
D.2(b)(8) Power Sales Contracts (Applicable) written 50% 35 1 35 2.00 70 $62.21 $4,355
D.2(b)(9) Engineering Report written 100% 70 1 70 40.00 2,800 $62.21 $174,197
D.2(b)(10) Project Contracting (Listing) written 100% 70 1 70 8.00 560 $62.21 $34,839
D.2(b)(10) Project Contracting (Applicable Selected Contracts) written 50% 35 1 35 8.00 280 $62.21 $17,420
D.2(b)(11) Interconnection Agreements (Applicable) written 50% 35 1 35 6.00 210 $62.21 $13,065
D.2(b)(12) System Impact Studies (Applicable) written 90% 63 1 63 6.00 378 $62.21 $23,517
D.2(b)(13) Transmission Service Arrangements (Applicable) written 90% 63 1 63 6.00 378 $62.21 $23,517
D.2(b)(14) Other Major Agreements (Applicable) written 50% 35 1 35 20.00 700 $62.21 $43,549
D.2(b)(15) Meteorological Data and Studies (Applicable) written 85% 60 1 60 6.00 357 $62.21 $22,210
D.2(b)(16) Fuel and Fuel Transportation Strategies (Applicable) written 10% 7 1 7 6.00 42 $62.21 $2,613
D.2(b)(17) Sources and Uses of Water (Applicable) written 10% 7 1 7 6.00 42 $62.21 $2,613
D.2(b)(18) Real Estate Matters (Applicable) written 50% 35 1 35 15.00 525 $62.21 $32,662
D.2(b)(19) Commuity Benefit Plan written 100% 70 1 70 40.00 2,800 $62.21 $174,197
D.2(b)(20) Tribal Government Resolution of Consent (Applicable) written 25% 18 1 18 10.00 175 $62.21 $10,887
D.2(b)(21) Estimated Costs written 100% 70 1 70 1.00 70 $62.21 $4,355
AWARD CLOSING, SERVICING AND REPORTING
F.1 Commitment Letter written 100% 70 1 70 8.00 560 $62.21 $34,839
F.1(j) Award Agreement written 100% 70 1 70 10.00 700 $62.21 $43,549
F.1(h) Opinion of Counsel written 100% 70 1 70 8.00 560 $62.21 $34,839
F.1(i) Cypersecurity written 100% 70 1 70 2.00 140 $62.21 $8,710
F.1(j) Request for Advances written 100% 70 1 70 3.00 210 $62.21 $13,065
F.1(j) Request for Loan Forgiveness Information written 100% 70 1 70 2.00 140 $62.21 $8,710
F.3(a) Performance Reporting written 100% 70 1 70 12.00 840 $62.21 $52,259
F.3(c) Audit Requirements written 100% 70 1 70 11.00 770 $62.21 $47,904
D.3 SAM Registration Maintenance written 100% 70 1 70 1.00 70 $62.21 $4,355

Sheet 2: 12 Not Inc in Burden Hours

USDA RURAL UTILITIES SERVICE
POWERING AFFORDABLE CLEAN ENERGY (ACE) PROGRAM
INFORMATION COLLECTION NOT INCLUDED IN BURDEN HOURS
OMB # 0572-0159
September 29, 2023











Estimated No. of Total Respondents (Applicants)
250





Estimated No. of Total Awards (Awardees) 30
Average hours per response
1.000





Number of responses per respondent 1.00
Gray Columns have automatic formulas. DO NOT input numbers in these columns.



TOTAL 250
250
15,553
(A) (B) (C)
(D) (E) (F) (G) (H) (I) (J)
NOFO
Section
Title Form No.
(If Any)
% of Respondents Line Item is Applicable To Estimated # of Respondents Reports Filed Annually Total Responses
(D) x (E)
Estimated # of Hours Per Response Estimated Total Hours
(F) x (G)
Prof. Wage Rate Total Cost
(H) x (I)
LOI AND APPLICATION CONTENT - Step 1: Letter of Interest
Notice to Open Portal Window Application for Federal Assistance - grants.gov SF 424 (4040-00004) 100% 250 1 250 1.00 250 $62.21 $15,553

Sheet 3: 12 Est Prof Wage Rate

USDA RURAL UTILITIES SERVICE
POWERING AFFORDABLE CLEAN ENERGY (ACE) PROGRAM
ESTIMATED PROFESSIONAL WAGE RATE
OMB # 0572-0159
September 29, 2023







Profession Bureau of Labor Occupation Code 1 Mean Wage 1 Benefits 2 Total Hourly Wage % Time Spent on Burden Weighted Hourly Salary
Senior Manager 10-2021 $55.41 $16.35 $71.76 20% $14.35
Attorney 23-1011 $71.17 $21.00 $92.17 10% $9.22
Electrical Engineer 17-2071 $51.87 $15.30 $67.17 30% $20.15
Accountant/Auditor 13-2011 $40.37 $11.91 $52.28 30% $15.68
Bookkeeping, Accounting, and Auditing Clerk 43-3031 $21.70 $6.40 $28.10 10% $2.81
TOTAL



100% $62.21
1. U.S. Bureau of Laobr Statistics Occupational Employment and Wage Statistics


[Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: How to navigate to obtain Prof. Wage Rate: 1) Click the website 2) Under the latest Month Year choose Occupation Profiles 3) Select 11-0000 Management Occupations 4) Select 11-1021 General Operations Managers 5) Use the Mean Hourly Wage https://www.bls.gov/oes/tables.htm

2. U.S. Bureau of Labor Statistics Economic News Release, Employer Costs for Employee Compensation - December 2022, Private Industry Workers Benefits %


[Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: How to obtain the Benefits %: 1) Click the website 2) Choose "The PDF version of the news release" 3) The current release is dated March 2023 and the reported % is in the 3rd paragraph on page 1 and it is 29.5%



[Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: How to obtain the Benefits %: 1) Click the website 2) Choose "The PDF version of the news release" 3) The current release is dated March 2023 and the reported % is in the 3rd paragraph on page 1 and it is 29.5% https://www.bls.gov/news.release/ecec.toc.htm


29.50%

Sheet 4: 14 Annual Cost to Fed Gov Est

USDA RURAL UTILITIES SERVICE
POWERING AFFORDABLE CLEAN ENERGY (ACE) PROGRAM
ANNUALIZED COST TO THE FEDERAL GOVERNMENT
OMB # 0572-0159
September 29, 2023











OPM GS Pay Tables - Table 2023 DCB
https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/2023/general-schedule







OPM SES Schedules - Table 2023-ES
Executive Senior Level (opm.gov)







Benefit % (OMB Memo M-08 13) https://www.whitehouse.gov/wp-content/uploads/legacy_drupal_files/omb/memoranda/2008/m08-13.pdf







36.25%











Gray & Blue Columns have automatic formulas. DO NOT input numbers in these columns.




Total 417.00 $41,660.86
$3,224,561.70
Staff
Position
GS Grade GS Step GS
Salary
Hourly Rate Calc Benefits Calc Total Salary Rate Calc Hours Required Cost Subtotals # of Entities Total Costs
Step 1 - Letter of Interest Review 18.00 $1,712.79 250 $428,196.90
Policy Advisor 15 5 $176,458 $84.84 $30.75 $115.59 2.00 $231.18

Senior Level Engineer 15 5 $176,458 $84.84 $30.75 $115.59 3.00 $346.77

Senior Loan Specialist 13 5 $126,949 $61.03 $22.12 $83.16 6.00 $498.95

Engineer 13 5 $126,949 $61.03 $22.12 $83.16 5.00 $415.79

Assistant Administrator (Electric) SES SES $168,011 $80.77 $29.28 $110.06 2.00 $220.11

Step 2 - Pre-Application - 70 Entities 179.00 $17,614.18 70 $1,232,992.46
Policy Advisor 15 5 $176,458 $84.84 $30.75 $115.59 45.00 $5,201.48

Senior Level Engineer 15 5 $176,458 $84.84 $30.75 $115.59 30.00 $3,467.65

Senior Loan Specialist 13 5 $126,949 $61.03 $22.12 $83.16 30.00 $2,494.73

General Field Representative 13 5 $126,949 $61.03 $22.12 $83.16 64.00 $5,322.09

Deputy Assistant Administrator (OLOA) 15 5 $176,458 $84.84 $30.75 $115.59 5.00 $577.94

Assistant Administrator (Electric) SES SES $168,011 $80.77 $29.28 $110.06 5.00 $550.28

Step 3 - Application Review & Loan Approval - 70 Entities 195.00 $19,634.00 70 $1,374,379.90
Policy Advisor 15 5 $176,458 $84.84 $30.75 $115.59 16.00 $1,849.42

Senior Level Engineer 15 5 $176,458 $84.84 $30.75 $115.59 40.00 $4,623.54

Senior Loan Specialist 13 5 $126,949 $61.03 $22.12 $83.16 80.00 $6,652.62

Financial Branch Chief 15 5 $176,458 $84.84 $30.75 $115.59 20.00 $2,311.77

Consultant




$100.00 15.00 $1,500.00

Deputy Assistant Administrator (OLOA) 15 5 $176,458 $84.84 $30.75 $115.59 10.00 $1,155.88

Assistant Administrator (Electric) SES SES $168,011 $80.77 $29.28 $110.06 10.00 $1,100.55

Assistant Administrator (WEP) SES SES $168,011 $80.77 $29.28 $110.06 1.00 $110.06

Assistant Administrator (TELECOM) SES SES $168,011 $80.77 $29.28 $110.06 1.00 $110.06

RUS Administrator ES ES $168,011 $80.77 $29.28 $110.06 2.00 $220.11

Step 4 - Post Award - 70 Entities 25.00 $2,699.89 70 $188,992.44
Senior Level Engineer 15 5 $176,458 $84.84 $30.75 $115.59 5.00 $577.94

Senior Loan Specialist 13 5 $126,949 $61.03 $22.12 $83.16 5.00 $415.79

Financial Branch Chief 15 5 $176,458 $84.84 $30.75 $115.59 5.00 $577.94

Deputy Assistant Administrator (OLOA) 15 5 $176,458 $84.84 $30.75 $115.59 5.00 $577.94

Assistant Administrator (Electric) SES SES $168,011 $80.77 $29.28 $110.06 5.00 $550.28

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

© 2024 OMB.report | Privacy Policy