Spreadsheet

0575-0042 Spreadsheet 05212024.xlsx

7 CFR 1924-A, Planning and Performing Construction and Other Development

Spreadsheet

OMB: 0575-0042

Document [xlsx]
Download: xlsx | pdf

Overview

Corrected
Federal Cost (Wages)
Sheet3


Sheet 1: Corrected

2019 7 CFR 1924-A, PLANNING AND PERFORMING CONSTRUCTION AND OTHER DEVELOPMENT











OMB No. 0575-0042






** using 36,364 as # of respondents (determined from partial payment estimate, since everyone has to do one)










Section of Title Form No. Estimated Reports Total Est. No. Estimated Wage Total
Regulations
(if any) No. of Filed Annual Man-hrs/ Total Class Cost



Respondents Annually Responses Response Manhours
(H) x (I)





(D) x (E)
(F) x (G)


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

REPORTING REQUIREMENTS - FORMS








1924.5(b) Development Plan 1924-1 5,772 on 5,772 0.25 1,443 59.90 $86,436
1924.5(g)(1)


occasion





1924.5(f)(2)(iv) Description of 1924-2 3,752 on 3,752 0.25 938 59.90 $56,186

Materials

occasion





1924.5(f)(2)(iv) Service Building 1924-3 1,924 on 1,924 0.25 481 59.90 $28,812

Specifications

occasion





1924.6(a)(10)(v) Invitation for Bid 1924-5 3,463 on 3,463 0.25 866 59.90 $51,858

(Construction Contract)

occasion





1924.10(a)(4) Contract Change Order 1924-7 7,138 on 7,138 0.25 1,785 59.90 $106,922




occasion





1924.6(a)(1) Construction Contract 1924-6 13,201 on 13,201 0.25 3,300 59.90 $197,670




occasion





1924.6(a)(12)(vi)(B) Certificate of 1924-9 11,351 on 11,351 0.25 2,838 59.90 $169,996

Contractor's Release

occasion





1924.6(a)(12)(vi)(B) 57839820 1924-10 11,351 on 11,351 0.5 5,676 59.90 $339,992




occasion





1924.6(b)(3)(i) Statement of Labor 1924-11 288 on 288 0.5 144 59.90 $8,626

Performed

occasion





1924.6(e)(1)(iv) Estimate and Certificate 1924-13 1,154 2 2,308 2 4,616 59.90 $276,498

of Actual Cost








1924.13(e)(1)(vi) Partial Payment 1924-18 36,364 3 109,092 0.5 54,546 59.90 $3,267,305
1924.13(e)(1)(ix) Estimate








1924.6(a)(1) Builder's Warranty 1924-19 10,678 1 10,678 0.25 2,670 59.90 $159,933











1924.5(f)(a)(iii)(F) Plan Certification 1924-25 3,848 1 3,848 0.167 643 59.90 $38,516












SUBTOTAL
110,284
184,166
79,946
$4,788,750












REPORTING REQUIREMENTS - NON FORMS








1924.5(d)(2) Drawings and
7,455 on 7,455 0.5 3,728 59.90 $223,307
1924.5(e)(1) Specifications

occasion





1924.5(f)(1)(ii)









1924.5(d)(2) Cost Estimate
11,547 on 11,547 0.5 5,774 59.90 $345,863
1924.13(e)(1)(iv)


occasion





1924.5(f)(1)(ii) Narrative Description
3,607 on 3,607 0.5 1,804 59.90 $108,060

of Work Items

occasion





1924.5(f)(1)(iii) Certification of Drawings
7,311 on 7,311 0.25 1,828 59.90 $109,497

and Specifications

occasion





1924.5(g)(3) Written Consent of Prior
489 on 489 0.25 122 59.90 $7,308

Lien Holders

occasion





1924.5(i) Agreement to Pay with
193 on 193 0.25 48 59.90 $2,875

Personal Funds

occasion





1924.6(a)(1),(2)&(7) Agreement between Borrower
164 on 164 0.25 41 59.90 $2,456

and Builder

occasion





1924.6(a)(3)(i)(C) Request for Surety Bond
674 on 674 0.25 169 59.90 $10,123




occasion





1924.6(a)(3)(ii) Payment Bond
674 on 674 0.5 337 59.90 $20,186
Exhibit F


occasion





1924.6(a)(3)(ii) Performance Bond
674 on 674 0.5 337 59.90 $20,186
Exhibit G


occasion





1924.6(a)(3)(iii)(A) Letter of Credit
29 on 29 1 29 59.90 $1,737




occasion





1924.6(a)(3)(iii)&(iv) Documents for Exception
384 on 384 0.5 192 59.90 $11,501
1924.6(e)(1)(iii)&(B) to Surety Requirements

occasion





1924.6(a)(10)(ii) Construction Contract
48 on 48 0.25 12 59.90 $719

Bidding Documents

occasion





1924.6(a)(12)(iv)&(v) Application for Payment
54 6 324 0.25 81 59.90 $4,852
1924.6(e)(2)(ix)(B)









1924.6(a)(12)(vi)(B) Notification of Delays
576 on 576 0.25 144 59.90 $8,626

in Construction

occasion





1924.6(b)(1)(ii) Lump-sum Agreements for
729 5 3,645 0.5 1,823 59.90 $109,198

Labor or Material








1924.8(c) Manufacturer's and
476 on 476 0.5 238 59.90 $14,256
Exhibit B, atch. 5 Builder's Certification

occasion





1924.6(b)(3)(i)&(ii) Documents for 10 Year
476 on 476 0.5 238 59.90 $14,256
1924.9(d) Warranty

occasion





Exhibit L









1924.9(b)(5) Complaints of
25 on 25 0.25 6 59.90 $359
1924.9(b)(4) Construction Defects

occasion





1924.9(b)(7) Irrigation System
35 on 35 0.5 18 59.90 $1,078

Inspection Report

occasion





1924.10(a)(4) Contract Change Order
539 2 1,078 0.25 270 59.90 $16,173











1924.13(a)(4)&(5) Agreement Between
183 on 183 0.25 46 59.90 $2,755

Borrower & Architect

occasion





1924.13(b)(2) Project Representative's
11 on 11 0.25 3 59.90 $180

Resume

occasion





1924.13(b)(2)(v) Project Representative's
11 on 11 0.25 3 59.90 $180

Diary

occasion





1924.13(e)(1)(v) Audit Report
96 on 96 1 96 59.90 $5,750
1924.13(e)(1)(viii)


occasion





1924.13(e)(1)(vii) Documents for Exception
48 on 48 0.25 12 59.90 $719
(A)(B)&(C) to Competitive Bidding

occasion





1924.13(e)(1)(viii)(C) Documents for Exception
6 on 6 4 24 59.90 $1,438

to Contract Method

occasion





1924.6(e)(2)(i) Owner-Builder
8 on 8 4 32 59.90 $1,917

Construction Proposal

occasion





Exhibit B,V,D,1,2 & 3 Prerequisites for
15 on 15 0.5 8 59.90 $479
Exhibit B, atch. 1 Modular/Panelized

occasion






Housing Unit Mfrs.








Exhibit B,V,E Letter of Conditions
15 on 15 0.25 4 59.90 $240
Exhibit B, atch. 2


occasion





Exhibit B,V,E Approval of Modular/
62 on 62 0.25 16 59.90 $958
Exhibit B, atch. 3 Panelized Housing Units

occasion





Exhibit B, V, G Evidence of a HUD
117 2 234 0.5 117 59.90 $7,008
Exhibit B, atch. 4 Review Process








Exhibit B, V, G Notification of
33 on 33 0.25 8 59.90 $479
Exhibit B, atch. 4 Manufacturer

occasion





Exhibit B, XI, B HUD Bulletins
33 on 33 0.25 8 59.90 $479




occasion





Exhibit B, XI, C Installation
33 on 33 0.25 8 59.90 $479

Instructions

occasion





Exhibit C, V, A Individual Water Sewer
384 on 384 0.5 192 59.90 $11,501

System Proposal Docs.

occasion





Exhibit E, 12 Notification for an
14,786 3 44,358 0.08 3,549 59.90 $212,585

Inspection









SUBTOTAL
52,000
85,414
21,365
$1,279,764












REPORTING REQUIREMENTS - RECORDKEEPING








1924.5(f)(1)(ii) Retain copy of approved
3,944
3,944 0.08 316 59.90 $18,928

drawing & specs.








1924.6(c)(2)&(4) TA Grantee Bookkeeping
24
24 0.5 12 59.90 $719

System








1924.13(a)(5)(v)&(C) Keep Construction
193
193 0.5 97 59.90 $5,810
1924.13(e)(1)(ii)(C) Accounts








1924.13(b)(2) Maintain Construction
11
11 0.25 3 59.90 $180

Diary








1924.13(e)(1)(v)(C) Construction Accounting
96
96 0.5 48 59.90 $2,875

SUBTOTAL
4,268
4,268
476
$28,512












REPORTING TOTALS
162,284
269,580
101,311
$6,068,514












RECORDKEEPING TOTALS
4,268
4,268
476
$28,512












DOCKET TOTALS
166,552
273,848
101,787
$6,097,026

Sheet 2: Federal Cost (Wages)


Job Title Hourly Wage Hours Total
MFH Nat'l Office Loan Technician, GS 7, Step 5 $41.52 282 $11,708.64
Nat'l Office Finance and Loan Analyst, GS 12, Step 5 $73.49 5687 $417,937.63




Totals
5969 $429,646.27





CF Community Programs Specialists/Architects, GS 12, Step 5 $73.49 11473 $843,150.77
Asset Risk Management Specialists, GS 13, Step 5 $87.28 2691 $234,870.48






14164 $1,078,021.25





SFH Nat'l Office Finance and Loan Analyst, GS 11, Step 5 $61.23 14000 $857,220.00













34133 $2,364,887.52

Sheet 3: Sheet3

Collection Number
Expiration Date
Formula Check for Information Collections
A = Respondents (given) c ÷ b = a 36364
B = Responses Per Respondent (?) c ÷ a = b 7.53074469255308
C = Annual Responses (given) a x b = c 273848
D = Total Burden (given) c x (.xxxx) = d 101787
Estimate of Burden d ÷ c = (.xxxx) 0.371691595337559




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

© 2024 OMB.report | Privacy Policy