0572-0107 Summary Spreadsheet

0572-0107 - Spreadsheet 2020-final.xlsx

7 CFR 1726, Electric System Construction Policies and Procedures- Electric

0572-0107 Summary Spreadsheet

OMB: 0572-0107

Document [xlsx]
Download: xlsx | pdf

Overview

Updated Spreadsheet
Previous Electric
Inputs


Sheet 1: Updated Spreadsheet

USDA - RUS
Electric System Construction Policies and Procedures




OMB No.


Electric

Broadband/Telecom













0572-0107

2017 number of borrowers 568
2017 number of borrowers N/A




SUMMARY OF INFORMATION COLLECTION






Date Prepared


2020 number of borrowers 601
2020 number of borrowers N/A












9/15/2020











INSTRUCTIONS:

> (f) TOTAL
(h) TOTAL
(k) TOTAL

Notes:

Telecom & Broadband





Use this form when a single information collection document involves multiple reporting and


> - = (e) Average - = (g) Average - = (j) Average
Change in electric program numbers are based on the number of respondents. The addition of the certification for submission is not expected to reduce burden hours for borrowers since RUS Forms must still be completed. The certification for submission is expected to greatly reduce the burden hours RUS spends reviewing each contract. This is reflected in the statement.

9.17





recordkeeping requirements.


> (d) TOTAL
(f) TOTAL
(i) TOTAL










IDENTIFICATION OF REPORTING AND RECORDKEEPPING REQUIREMENTS




ANNUAL BURDEN















FORM

REPORTS


RECORDS












NO(s) NO. OF NO. OF TOTAL HOURS TOTAL NO. OF ANNUAL TOTAL









SECTION OF
(If "none" RESPON- RESPONSES ANNUAL PER HOURS RECORD- MINUTES PER RECORD-









REGULATIONS DESCRIPTION so state) DENTS PER RESPONSES RESPONSE (Col. f & g) KEEPERS RECORD- KEEPING













RESPON- (Col. d & e)


KEEPER HOURS













DENT




(Col. i & j)









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





















2014 Numbers







1726.27(a), 1726.304(c)(1) Contractor's Bond RUS 168b * 168 1.00 168 0.02 3.36



180








Telecom & Broadband
60 2.06 124 0.02 2.47



90

































0
0.00












1726.27(b), 1726.304(c)(2) Contractor's Bond (less than $1 million) RUS 168c * 2 1.00 2 0.02 0.04














Telecom & Broadband
0 0.00 0 0.00 0.00








































0
0.00













1726.304(c)(5), 1726.404(c)(1)(i) Certificate of Completion - Contract Construction RUS 187 * 477 4.00 1,908 0.02 38.16














Telecom & Broadband
0 0.00 0 0.00 0.00








































0
0.00











1726.50(a)(1), 1726.76, 1726.125(a)(1), 1726.175, 1726.304(c)(6) Equipment Contract RUS 198 33 1.00 33 0.08 2.64



electric 1.0580985915493












0
0.00




102







1726.125(a)(2), 1726.304(c)(7) Construction Contract - Generating RUS 200 12 1.00 12 0.08 0.96



Hours Electric:













0
0.00



72.98 1







1726.304(c)(10), 1726.401(b), 1726.402(b)(1)(iii), 1726.403(c)(1)(ii) Certificate (Buy American) RUS 213 * 24 1.00 24 0.02 0.48




0








Telecom & Broadband
0 0.00 0 0.00 0.00




1










































513








Contract Certification for Standard RUS Contract Forms
11 1.00 11 0.02 0.22




0




















1







1726.304(c)(11), 1726.401(b), 1726.403(c)(1)(iii) Waiver and Release of Lien RUS 224 * 29 1.00 29 0.02 0.58














Telecom & Broadband
60 2.06 124 0.02 2.47




35










































12







1726.304(c)(12), 1726.403(c)(1)(iv) Certificate of Contractor RUS 231 * 168 1.00 168 0.02 3.36














Telecom & Broadband
1 1.00 1 0.02 0.02




25




















94




















105







1726.24(b), 1726.304(c)(13), Construction or Equipment Contract Amendment RUS 238 * 9 1.00 9 0.02 0.18














Telecom & Broadband
34 1.83 62 0.02 1.24
















































30







1726.304(c)(15), 1726.404(c)(1)(v) Construction Inventory RUS 254 * 168 1.00 168 0.04 6.72




100




















102







1726.150, 1726.304(c)(16) Contract to Construct Buildings RUS 257 25 1.00 25 0.08 2.00














Telecom & Broadband
1 1.00 1 0.08 0.08




180




















100




















102







1726.304(c)(17) Bid Bond RUS 307 * 168 1.00 168 0.02 3.36














Telecom & Broadband
70 2.06 144 0.02 2.88




8




















28




















31







1726.176, 1726.304(c)(19) Electric System Communications and Control Equipment Contract RUS 786 3 1.00 3 0.08 0.24


















0




180







1726.51(a), 1726.304(c)(20) Electric System Construction Contract Non-Site Specific Construction (Notice and Instructions to Bidders) RUS 790 8 1.00 8 0.08 0.64


















0






26







1726.404(c)(1)(I), 1726.304(c)(22) Certificate of Construction and Indemnity Agreement RUS 792b * 2 1.00 2 0.02 0.04




5












0






6







1726.51(a), 1726.304(c)(24) Electric System Construction Contract - Lump Sum RUS 830 125 1.00 125 0.08 10.00

























171 180








TOTALS
827
3,319
82




67








Electric
601




76








Telecom & Broadband
226






























2










































7










































1










































134








Sheet 2: Previous Electric

USDA - RUS
Electric System Construction Policies and Procedures




OMB No.












0572-0107



SUMMARY OF INFORMATION COLLECTION






Date Prepared












11/13/2017



INSTRUCTIONS:

> (f) TOTAL
(h) TOTAL
(k) TOTAL



Use this form when a single information collection document involves multiple reporting and


> - = (e) Average - = (g) Average - = (j) Average


recordkeeping requirements.


> (d) TOTAL
(f) TOTAL
(i) TOTAL



IDENTIFICATION OF REPORTING AND RECORDKEEPPING REQUIREMENTS




ANNUAL BURDEN








FORM

REPORTS


RECORDS





NO(s) NO. OF NO. OF TOTAL HOURS TOTAL NO. OF ANNUAL TOTAL


SECTION OF
(If "none" RESPON- RESPONSES ANNUAL PER HOURS RECORD- MINUTES PER RECORD-


REGULATIONS DESCRIPTION so state) DENTS PER RESPONSES RESPONSE (Col. f & g) KEEPERS RECORD- KEEPING






RESPON- (Col. d & e)


KEEPER HOURS






DENT




(Col. i & j)


(a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k)
Hours Electric 68.34














1726.27(a), 1726.304(c)(1) Contractor's Bond RUS 168b * 158 1 158 0.02 3.16



Hours telecom and broadband: 9.92

Telecom & Broadband
60 2 124 0.02 2.47
























0
0.00




1726.27(b), 1726.304(c)(2) Contractor's Bond (less than $1 million) RUS 168c * 1 1 1 0.02 0.02






Telecom & Broadband
0 1 0 0.02 0.00
























0
0.00





1726.304(c)(5), 1726.404(c)(1)(i) Certificate of Completion - Contract Construction RUS 187 * 450 4 1,800 0.02 36.00






Telecom & Broadband
1 1 1 0.02 0.02
























0
0.00



1726.50(a)(1), 1726.76, 1726.125(a)(1), 1726.175, 1726.304(c)(6) Equipment Contract RUS 198 31 1 31 0.08 2.48










0
0.00





1726.125(a)(2), 1726.304(c)(7) Construction Contract - Generating RUS 200 11 1 11 0.08 0.88










0
0.00





1726.304(c)(10), 1726.401(b), 1726.402(b)(1)(iii), 1726.403(c)(1)(ii) Certificate (Buy American) RUS 213 * 22 1 22 0.02 0.44






Telecom & Broadband
0 1 0 0.02 0.00


































Contract Certification for Standard RUS Contract Forms
10 1 10 0.02 0.20



















1726.304(c)(11), 1726.401(b), 1726.403(c)(1)(iii) Waiver and Release of Lien RUS 224 * 27 1 27 0.02 0.54






Telecom & Broadband
60 2 124 0.02 2.47

































1726.304(c)(12), 1726.403(c)(1)(iv) Certificate of Contractor RUS 231 * 158 1 158 0.02 3.16






Telecom & Broadband
3 1 3 0.02 0.06

































1726.24(b), 1726.304(c)(13), Construction or Equipment Contract Amendment RUS 238 * 8 1 8 0.02 0.16






Telecom & Broadband
64 2 117 0.02 2.34

































1726.304(c)(15), 1726.404(c)(1)(v) Construction Inventory RUS 254 * 158 1 158 0.04 6.32



















1726.150, 1726.304(c)(16) Contract to Construct Buildings RUS 257 23 1 23 0.08 1.84






Telecom & Broadband
1 1 1 0.08 0.08

































1726.304(c)(17) Bid Bond RUS 307 * 158 1 158 0.02 3.16






Telecom & Broadband
60 2 124 0.02 2.47

































1726.176, 1726.304(c)(19) Electric System Communications and Control Equipment Contract RUS 786 2 1 2 0.08 0.16










0





1726.51(a), 1726.304(c)(20) Electric System Construction Contract Non-Site Specific Construction (Notice and Instructions to Bidders) RUS 790 7 1 7 0.08 0.56










0







1726.404(c)(1)(I), 1726.304(c)(22) Certificate of Construction and Indemnity Agreement RUS 792b * 1 1 1 0.02 0.02










0







1726.51(a), 1726.304(c)(24) Electric System Construction Contract - Lump Sum RUS 830 118 1 118 0.08 9.44




















TOTALS
817
3,186
78






Electric
568






Telecom & Broadband
249




















































Sheet 3: Inputs





Table 1:





Total Respondents: 827










previous
Professional time
20.5 hours @ $64.43 = $1,320.82
Burden hours: 82 78
Clerical time
61.5 hours @ $27.86 = $1,713.39







Total
= $3,034.21
Change in hours: 4



















Total responses: 3319

Table 2:
















Burden hours not in bold: 82 82
Professional time
333.6 hours @ $73.31 = $24,456.63




Clerical time
83.4 hours @ $31.27 = $2,607.98
Electric Respondents 2017 568

Overhead 18%




$4,871.63







Total
= $31,936.24
Electric Respondents 2020 601



















Telecom Respondents 2020 226

Note: Yellow boxes require manual input. All others are calculated and included for refernce on the word doc.


previous
Telecom Burden Hours 9.17 9.92




Total cost estimate $3,034.21





Percent Professional of industry workers 25% updated as of 9/30/2020


















Professional hours 20.5



















Clerical hours 61.5



















Mean hourly professional $49.75 https://www.bls.gov/oes/current/oes172071.htm updated as of 9/30/2020

















mean hourly clerical $21.51 https://www.bls.gov/oes/current/oes433099.htm updated as of 9/30/2020

















percent benefits 29.5% https://www.bls.gov/news.release/ecec.t04.htm updated as of 9/30/2020

















hourly wage and benefits professional $64.43



















hourly wage and benefits clerical $27.86











current over past responses past RUS processing hours





Hours of RUS processing time 417 updated as of 9/30/2020 1.04165201888309 400 417















percent professional of RUS employees 80% updated as of 9/30/2020


















hours professional 333.6



















hours clerical 83.4



















gs 13 step 5 $55.75 https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/salary-tables/pdf/2020/GS_h.pdf 116353

















gs 6 step 5 $23.78 https://www.opm.gov/policy-data-oversight/pay-leave/salaries-wages/salary-tables/pdf/2020/GS_h.pdf 49639

















percent benefits feds 31.50% https://www.bls.gov/news.release/ecec.t02.htm used to estimate

















gs 13 step 5 with benefits $73.31



















gs 6 step 5 with benefits $31.27



















Overhead 18%



















Decrease hours electric -4.64



















Decrease hours telecom 0.75








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

© 2024 OMB.report | Privacy Policy