Spreadsheet

0572-0154 Spreadsheet 05212024.xlsx

Rural Broadband Loans, Loan/Grant Combination, and Loan Guarantees

Spreadsheet

OMB: 0572-0154

Document [xlsx]
Download: xlsx | pdf

Overview

Burden
Federal Cost
Current Sheet
Sheet3
Old


Sheet 1: Burden

2024 - 7 CFR part 1738, Rural Broadband Access Loan and Loan Guarantee Program
USDA Rural Utilities Service
OMB No. 0572-0154
Section of Regulations Title Form No. (if any) Estimated
No. of
Respondents
Reports
Filed
Annually
Total
Annual
Reponses
(D) X (E)
Estimated
No. of
Man Hours
per
Reponse
Estimated
Total Man
Hours
(F) X (G)
Wage Class*
$/hr
Total Cost
to the
Public
(H) X (I)
(A) (B) (C) (D) (E) (F) (G) (H) (I) (J)











7 CFR 1738 Sams Registration and Maintenance SAM.gov 1 1 1 2 2 52.44 $104.88
7 CFR 1738 Pre-Loan data collected and online submission (Including Guide RUS Bulletin and uploaded documentation) Online Application System & 1738-I 1 1 1 400.00 400.00 $52.44 $20,976.00































Broadband
1 3 3 1.50 4.50 $52.44 $235.98

Telecom Infrastructure (remaining burden covered under 0572-0079)
16 3 48 1.50 72.00 $52.44 $3,775.68

Community Connect (remaining burden covered under 0572-0127)
73 3 219 1.50 328.50 $52.44 $17,226.54









$-

Preparation of Loan Documents
1 1 1 24.00 24.00 $52.44 $1,258.56











GRAND TOTAL FOR THIS COLLECTION:


273
831.00
$43,577.64











Respondents
90






Total Estimated Annual Responses


273




Total Estimated Annual Burden Hours




831.00


Total Annual Burden Cost






$43,577.64

Total Estimated Burden Hours per Response




3.044


Sheet 2: Federal Cost

Job title Wage Category Wages Hours Cost of Burden
National Office Loan Specialist GS 13, Step 5 82.88 623 51,634.24
National Office Branch Chief or Attorney GS 14, Step 1 86.42 445 38,456.90
National Office Administrative Assistant GS 7, Step 1 34.68 445 15,432.60





Totals

1,513 105,523.74

Sheet 3: Current Sheet

USDA - RUS





OMB No.




7 CFR Part 1738, Broadband Access




0572-0154
SUMMARY OF INFORMATION COLLECTION






Date Prepared







2024
INSTRUCTIONS: Use this form when a single information collection document involves multiple reporting and recordkeeping requirements.
> (f) TOTAL
(h) TOTAL
(k) TOTAL



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


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

IDENTIFICATION OF REPORTING AND RECORDKEEPING 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- HOURS 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)
7 CFR 1738 Pre-Loan data collected and RDApply submission (Including Guide RUS Bulletin and uploaded documentation) RDApply & 1738-I 1 1 1 400.00 400.00








Public Notice Filing responses:









Broadband
1 3 3 1.5 4.50



Telecom Infrastructure (remaining burden covered under 0572-0079)
16 3 48 1.5 72.00



Community Connect (remaining burden covered under 0572-0127)
73 3 219 1.5 328.50














Preparation of Loan Documents
1 1 1 24.00 24.00














TOTALS
90
272
829


































Sheet 4: Sheet3

Collection Number
Expiration Date
Formula Check for Information Collections
A = Respondents (given) c ÷ b = a 90
B = Responses Per Respondent (?) c ÷ a = b 3.02222222222222
C = Annual Responses (given) a x b = c 272
D = Total Burden (given) c x (.xxxx) = d 829
Estimate of Burden d ÷ c = (.xxxx) 3.04779411764706





Sheet 5: Old

USDA - RUS





OMB No.




7 CFR Part 1738, Broadband Access




0572-0154
SUMMARY OF INFORMATION COLLECTION






Date Prepared







2020
INSTRUCTIONS: Use this form when a single information collection document involves multiple reporting and recordkeeping requirements.
> (f) TOTAL
(h) TOTAL
(k) TOTAL



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


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

IDENTIFICATION OF REPORTING AND RECORDKEEPING 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- HOURS 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)
7 CFR 1738 Pre-Loan data collected and RDApply submission (Including Guide RUS Bulletin and uploaded documentation) RDApply & 1738-I 50 1 50 400.00 20,000.00








Public Notice Filing responses:









Broadband
50 3 150 1.5 225.00



Telecon Infrastructure (remaining burden covered under 0572-0079)
36 3 108 1.5 162.00



Community Connect (remianing burden covered under 0572-0127)
70 3 210 1.5 315.00














Preparation of Loan Documents
10 1 10 24.00 240.00














TOTALS
156 5 528 134 20,942.00






















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

© 2024 OMB.report | Privacy Policy