Tab-2_Attachment 2_to_ICR Supporting Statement_Spreadsheet

Tab-2_Attachment 2_to_ICR Supporting Statement_to_OMB-83-I.xlsx

Information Collection Requirements per (48 CFR) Chapter 7, AIDAR 701.106

Tab-2_Attachment 2_to_ICR Supporting Statement_Spreadsheet

OMB: 0412-0520

Document [zip]
Download: zip | pdf

Overview

Source Data
ICR details
summary
use of SBA


Sheet 1: Source Data

====== ID#AAABTXwyM3Y Nicole Thompson (2024-08-08 15:28:38) @marcusjohnson@usaid.gov This sheet was hidden and seems to include the previous GLAAS figures? Were you using anything from here? _Assigned to marcusjohnson@usaid.gov_ GLAAS DATA





PROC_INST_NM (Multiple Items)



SAP THRESHOLD >=$250K



OCEAN TRANS (Y/N) N









CONTRACT TYPE AWARD_IDV_TYPE Sum of OBL_AA_AMT Sum of TEC_AMT # OF CONTRACTS

Cost Reimbursable Cost No Fee Total




Cost Plus Award Fee




Cost Plus Fixed Fee



Cost Reimbursable Total Cost Plus Incentive Fee

1308

Fixed Price Fixed Award Fee




Fixed Price Incentive




Fixed Price LOE




Fixed Price EPA




Fixed Labor Hours



Fixed Price Total Time&Materials

1394

Grand Total


2702












GS Salary DATA





GS Step $/hr


13 8 66.42


7 5 28.94


13 5 61.03


11 5 42.82


15 5 84.84













Bureau Labor Statistics





Rate Position



56.24 Business and Financial Operations Occupation in the DC area as of May 2023














PROC_INST_NM (Multiple Items)



SAP THRESHOLD >=$250K



OCEAN TRANS (Y/N) (All)



P_OF_PERF_COUNTRY_NAME (All)



CO_BUS_SIZE S Small Business CR Contracts








CONTRACT TYPE AWARD_IDV_TYPE Sum of OBL_AA_AMT Sum of TEC_AMT # OF CONTRACTS
Cost Reimbursable DEFINITIVE CONTRACT 49935920.68 732901567.15 44

DELIVERY ORDER 92148050.75 1191682354.44


IDC 2459604 2285082556.87

Cost Reimbursable Total
144543575.43 4209666478.46 44












PROC_INST_NM (Multiple Items)



SAP THRESHOLD >=$250K



OCEAN TRANS (Y/N) (All)



P_OF_PERF_COUNTRY_NAME (All)



CO_BUS_SIZE (All)









CONTRACT TYPE AWARD_IDV_TYPE Sum of OBL_AA_AMT Sum of TEC_AMT # OF CONTRACTS
Cost Reimbursable DEFINITIVE CONTRACT $684,564,394.54 $9,635,719,261.24


DELIVERY ORDER $617,110,943.85 $16,442,652,695.07


IDC $51,442,161.29 $11,263,575,558.87

Cost Reimbursable Total
$1,353,117,499.68 $37,341,947,515.18 1308
Fixed Price BOA $0.00 $42,400,000.00


BPA CALL $24,640,076.93 $73,428,202.84


DEFINITIVE CONTRACT $149,735,279.00 $1,506,417,386.17


DELIVERY ORDER $48,760,282.61 $508,220,036.86


IDC $30,000.00 $18,052,975,000.00

Fixed Price Total
$223,165,638.54 $20,183,440,625.87 1394
Grand Total
$1,576,283,138.22 $57,525,388,141.05 2702


















Place of Performance OUTSIDE USA
PROC_INST_NM (Multiple Items)



SAP THRESHOLD >=$250K



OCEAN TRANS (Y/N) (All)



P_OF_PERF_COUNTRY_NAME (Multiple Items)









CONTRACT TYPE AWARD_IDV_TYPE Sum of OBL_AA_AMT Sum of TEC_AMT # OF CONTRACTS
Cost Reimbursable DEFINITIVE CONTRACT $650,855,425.32 $8,268,319,245.81


DELIVERY ORDER $500,794,160.33 $6,312,553,593.57


IDC $51,442,161.29 $11,263,575,558.87

Cost Reimbursable Total
$1,203,091,746.94 $25,844,448,398.25 841
Fixed Price BOA $0.00 $42,400,000.00


BPA CALL $0.00 $332,533.20


DEFINITIVE CONTRACT $104,510,373.06 $912,159,417.74


DELIVERY ORDER $23,406,555.82 $101,437,140.53


IDC $30,000.00 $18,052,975,000.00

Fixed Price Total
$127,946,928.88 $19,109,304,091.47 718
Grand Total
$1,331,038,675.82 $44,953,752,489.72 1559

Sheet 2: ICR details

ATTACHMENT I to the SUPPORTING STATEMENT FOR REQUEST FOR APPROVAL UNDER
THE PAPERWORK REDUCTION ACT AND 5 CFR 1320
====== ID#AAABTXwyM3c Nicole Thompson (2024-08-08 15:29:41) @marcusjohnson@usaid.gov This sheet was also hidden but seems to be the source for all the information that is pulled into the summary sheet. Seems to have all the info for explaining the calculations. Hoping you were using this? _Assigned to marcusjohnson@usaid.gov_ ------ ID#AAABTXwyM3k Marcus Johnson (2024-08-08 15:43:58) Great detective work! I would have never ever have thought of a hidden, 2018 original. 2024 Submission
THE PAPERWORK REDUCTION ACT AND 5 CFR 1320











Item # AIDAR citation for the info Collection Summary & Justification FAR or AIDAR Prescription Applicability Annual Federal Burden: Annual Public Burden:
A. Hours per submission Explanation of how the numbers are estimated A. Hours per submission Explanation of how the numbers are estimated
B. Number of Respondents per year B. Number of Respondents per year
C. Number of responses per respondent C. Number of responses per respondent
D. No. of submissions/year D. No. of submissions/year
E. Total hr burden (A x D) E. Total hr burden (A x B)
F. Hourly Rate F. Hourly Rate
G. Total cost burden (F x E) G. Total cost burden (C x D)




1 752.219-8 Utilization of Small Business Concerns and Small Disadvantaged Business Concerns Contractors must notify OSDBU at least 45 days before placing orders for supplies or equipment in excess of 100k financed by USAID. This provides USAID with the means to monitor and encourage small business participation FAR 19.708(a) and AIDAR 719.708 Above SAT, not PSC, not performed overseas. A. 0.75 based on our previous experience A. 1.00 based on our previous experience
B. 100 based on our previous experience B. 100 based on our previous experience
C. 1 C. 1
D. 100 D. 100
E. 75 Formula: (A*D) E. 100 Formula: (A*D)
F. $86.74 Composite rate (GS 13/8*1/3 % of the time+GS 7/5*2/3 % of the time) + burden rate of 110% F. $112.48 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%
G. $6,505 Formula: (F*E) G. $11,248 Formula: (F*E)









#2 752.245-70 Government Property -- USAID Reporting Requirements Requires an annual report (format provided) on government property. This is necessary to account for government property and was recommended by the GAO to solve a standing problem. FAR 45.107 FP, CR, T&M, L-H contracts. A. 0.50 based on our previous experience A. 0.50 based on our previous experience
B. 1621 60 % of all active contracts excluding those for FP ocean transportation and POs below SAT B. 1621 60 % of all active contracts excluding those for FP ocean transportation and POs below SAT
C. 1 C. 1
D. 1,621 D. 1,621
E. $810.60 Formula: (A*D) E. 810.6 Formula: (A*D)
F. $128.17 hourly rate for GS 13/5 plus a burden rate of 110% F. $112.48 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%
G. $103,894 Formula: (F*E) G. $91,176 Formula: (F*E)








#3 752.245-71 Title to and Care of Property Requires a final report on property acquired under the contract but titled to a foreign government. Contractor has control until the property is turned over to the Foreign Government. This is a normal and necessary administrative procedure, required to account for property. 745.107 In all contracts under which the contractor will acquire property for use overseas and the contract funds were obligated under a DOAG A. 0.50 based on our previous experience A. 1.00 based on our previous experience
B. 270 10 % of all active contracts excluding those for FP ocean transportation and POs below SAT B. 270 10 % of all active contracts excluding those for FP ocean transportation and POs below SAT
C. 1 C. 1
D. 270 D. 270
E. 135.1 Formula: (A*D) E. 270.2 Formula: (A*D)
F. $128.17 hourly rate for GS 13/5 plus a burden rate of 110% F. $112.48 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%
G. $17,316 Formula: (F*E) G. $30,392 Formula: (F*E)








#4 752.247-70 Preference for privately owned U.S.-flag commercial vessel Contractors must submit copies of Bills for lading for all shipments to USAID and MARAD. This is necessary to verify compliance with the Cargo Preference Act. 747.507 in solicitations and contracts solely for ocean transportation services, and in solicitations and contracts for goods and ocean transportation services when the ocean transportation will be fixed at the time the contract is awarded. A. 0.33 based on our previous experience A. 0.25 based on our previous experience
B. 200 Based on our previous experience, we estimate number of respondents per year - 200, number of responses per each respondent - 3, total number of responses per year - 600. B. 200 Based on our previous experience, we estimate number of respondents per year - 200, number of responses per each respondent - 3, total number of responses per year - 600.
C. 3 C. 3
D. 600 D. 600
E. 198 Formula: (A*D) E. 150 Formula: (A*D)
F. $98.75 Composite rate (GS 111/5*90% of the time+GS 15/5*10% of the time) + burden rate of 110% F. $112.48 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%
G. $19,552 Formula: (F*E) G. $16,872 Formula: (F*E)








#5 752.7001 Biographical Data Contractor employees working outside of the US and all key personnel are required to submit personal, employment, history, education and salary data. Personal data is necessary to permit estimation of overseas logistical support and allowances. Employment history and educational data is needed to assess qualifications. Salary data is used as a means of cost monitoring, to determine reasonableness of proposed salary. N/A in all USAID CR contracts. A. 0.50 based on our previous experience A. 0.50 based on our previous experience
B. 1308 Number of active CR contracts and orders recorded in a FY times 8 submissions per contract B. 1308 Number of active CR contracts and orders recorded in a FY times 8 submissions per contract
C. 8 C. 8
D. 10464 D. 10464
E. 5232 Formula: (A*D) E. 5232 Formula: (A*D)
F. $128.17 hourly rate for GS 13/5 plus a burden rate of 110% F. $112.48 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%
G. $670,584 Formula: (F*E) G. $588,495 Formula: (F*E)








#6 752.7002 Travel and Transportation Contractors are required to furnish a copy of their Chief of Party's written authorization for emergency/irregular travel to the contracting officer. This ensures that the contractor has reviewed and assessed the need for emergency travel and provides the contracting officer a means to review the reasonableness of the decision and allowability of costs. N/A In all CR contracts performed in whole or in part overseas. A. 0.50 based on our previous experience A. 1.00 based on our previous experience
B. 841 from GLAAS Report, CR contracts performed outside of USA B. 841 from GLAAS Report, CR contracts performed outside of USA
C. 1 C. 1
D. 841 D. 841
E. 420.5 Formula: (A*D) E. 841 Formula: (A*D)
F. $128.17 hourly rate for GS 13/5 plus a burden rate of 110% F. $112.48
G. $53,895 Formula: (F*E) G. $94,596 Formula: (F*E)








#7 752.7003 Documentation for Payment As authorized by FAR 52.216-7(a), AIDAR 752.7003 specifies the format and certification requirements for invoicing costs. This is essential to provide a uniform basis for tracking funds expended or remaining under the contract and to protect the government's right in case invoices costs are determined to be unallowable, unallocable or unreasonable. N/A in all USAID direct contracts, excluding fixed price contracts A. 1.00 based on our previous experience A. 2.00 based on our previous experience
B. 1308 Number of active awards excluding FP contracts and order multiplied by 24 (bi-weekly submissions) B. 1308 Number of active awards excluding FP contracts and order multiplied by 24 (bi-weekly submissions)
C. 24 C. 24
D. 31392 D. 31392
E. 31392 Formula: (A*D) E. 62784 Formula: (A*D)
F. $128.17 hourly rate for GS 13/5 plus a burden rate of 110% F. $112.48 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%
G. $4,023,502 Formula: (F*E) G. $7,061,944 Formula: (F*E)








#8 752.7004 Emergency locator information. All employees of contractors performing overseas are required to specify a person to be notified in case of an emergency. This allows USAID Missions to respond as necessary and contact individual's family. The information required is determined to be minimum necessary based on actual experience. N/A in all contracts requiring travel overseas. A. 0.50 based on our previous experience A. 0.5 based on our previous experience
B. 2702 All active contracts/orders excluding those for FP ocean transportation and Pos multipied by our estimate of 8 submissions per contract/order B. 2702 All active contracts/orders excluding those for FP ocean transportation and Pos multipied by our estimate of 8 submissions per contract/order
C. 8 C. 8
D. 21616 D. 21616
E. 10808 Formula: (A*D) E. 10808 Formula: (A*D)
F. $128.17 hourly rate for GS 13/5 plus a burden rate of 110% F. $112.48 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%


G. $1,385,258 Formula: (F*E) G. $1,215,684 Formula: (F*E)








#9 752.7032 International Travel Approval and Notification Requirements Contractor is required to provide itineraries for all proposed international travel, and advance notification of travel to the USAID missions overseas in order to warn of security threats or arrange for evacuation. In addition, USAID contractors are part of foreign assistance programs. Arrivals notification and travel approval authority are necessary to allow the missions overseas to properly conduct the political and administrative requirements of the program, such as notifying and coordinating with the host government to assure that planned arrival times are acceptable. This is also necessary for arranging timely logistics support personnel to be available if needed. N/A in any USAID contract requiring international travel. A. 0.50 based on our previous experience A. 2.00 based on our previous experience
B. 2702 All active contracts/orders excluding those for FP ocean transportation and POs multipied by our estimate of 3 submissions per contract/order B. 2702 All active contracts/orders excluding those for FP ocean transportation and POs multipied by our estimate of 3 submissions per contract/order
C. 3 C. 3
D. 8106 D. 8106
E. 4053 Formula: (A*D) E. 16212 Formula: (A*D)
F. $128.17 hourly rate for GS 13/5 plus a burden rate of 110% F. $112.48 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%
G. $519,472 Formula: (F*E) G. $1,823,526 Formula: (F*E)



















Highlighted in green columns do not need to be submitted to OMB/OIRA










Sheet 3: summary

ATTACHMENT I to the SUPPORTING STATEMENT FOR REQUEST FOR APPROVAL UNDER
THE PAPERWORK REDUCTION ACT AND 5 CFR 1320


2024 Submission
THE PAPERWORK REDUCTION ACT AND 5 CFR 1320








Item # AIDAR citation for the info Collection
Description of the estimates Annual Federal Burden Annual Public Burden

1 752.219-8 Utilization of Small Business Concerns and Small Disadvantaged Business Concerns A. Hours per submission 0.75 1.00
B. Number of respondents per year 100.00 100.00
C. Number of responses per respondent 1.00 1.00
D. Number of responses per year 100.00 100.00
E. Total Annual Burden Hours 75.00 100.00
F. Hourly rate 86.74 112.48
G. Total Annual Cost Burden 6,505.47 11,248.00
#2 752.245-70 Government Property -- USAID Reporting Requirements A. Hours per submission 0.50 0.50
B. Number of respondents per year 1,621.20 1,621.20
C. Number of responses per respondent 1.00 1.00
D. Number of responses per year 1,621.20 1,621.20
E. Total Annual Burden Hours 810.60 810.60
F. Hourly rate 128.17 112.48
G. Total Annual Cost Burden 103,894.33 91,176.29
#3 752.245-71 Title to and Care of Property A. Hours per submission 0.50 1.00
B. Number of respondents per year 270.20 270.20
C. Number of responses per respondent 1.00 1.00
D. Number of responses per year 270.20 270.20
E. Total Annual Burden Hours 135.10 270.20
F. Hourly rate 128.17 112.48
G. Total Annual Cost Burden 17,315.72 30,392.10
#4 752.247-70 Preference for privately owned U.S.-flag commercial vessel A. Hours per submission 0.33 0.25
B. Number of respondents per year 200.00 200.00
C. Number of responses per respondent 3.00 3.00
D. Number of responses per year 600.00 600.00
E. Total Annual Burden Hours 198.00 150.00
F. Hourly rate 98.75 112.48
G. Total Annual Cost Burden 19,552.18 16,872.00
#5 752.7001 Biographical Data A. Hours per submission 0.50 0.50
B. Number of respondents per year 1,308.00 1,308.00
C. Number of responses per respondent 8.00 8.00
D. Number of responses per year 10,464.00 10,464.00
E. Total Annual Burden Hours 5,232.00 5,232.00
F. Hourly rate 128.17 112.48
G. Total Annual Cost Burden 670,583.68 588,495.36
#6 752.7002 Travel and Transportation A. Hours per submission 0.50 1.00
B. Number of respondents per year 841.00 841.00
C. Number of responses per respondent 1.00 1.00
D. Number of responses per year 841.00 841.00
E. Total Annual Burden Hours 420.50 841.00
F. Hourly rate 128.17 112.48
G. Total Annual Cost Burden 53,895.34 94,595.68
#7 752.7003 Documentation for Payment A. Hours per submission 1.00 2.00
B. Number of respondents per year 1,308.00 1,308.00
C. Number of responses per respondent 24.00 24.00
D. Number of responses per year 31,392.00 31,392.00
E. Total Annual Burden Hours 31,392.00 62,784.00
F. Hourly rate 128.17 112.48
G. Total Annual Cost Burden 4,023,502.08 7,061,944.32
#8 752.7004 Emergency locator information. A. Hours per submission 0.50 0.50
B. Number of respondents per year 2,702.00 2,702.00
C. Number of responses per respondent 8.00 8.00
D. Number of responses per year 21,616.00 21,616.00
E. Total Annual Burden Hours 10,808.00 10,808.00
F. Hourly rate 128.17 112.48
G. Total Annual Cost Burden 1,385,257.72 1,215,683.84
#9 752.7032 International Travel Approval and Notification Requirements A. Hours per submission 0.50 2.00
B. Number of respondents per year 2,702.00 2,702.00
C. Number of responses per respondent 3.00 3.00
D. Number of responses per year 8,106.00 8,106.00
E. Total Annual Burden Hours 4,053.00 16,212.00
F. Hourly rate 128.17 112.48
G. Total Annual Cost Burden 519,471.65 1,823,525.76
TOTAL NUMBER OF RESPONDENTS PER YEAR (total of all "B" entries) 11,052.40 11,052.40
TOTAL NUMBER OF RESPONSES PER YEAR (total of all "D" entries) 75,010.40 75,010.40
TOTAL ANNUAL BURDEN HOURS (total of all "E" entries) 53,124.20 97,207.80
TOTAL ANNUAL COST BURDEN (total of all "G"entries) 6,799,978.16 10,933,933.34












TOTAL PUBLIC ANNUAL COST BURDEN NOT REIMBURSED THROUGH CONTRACTS (25% of public burden on item#5)
147,123.84
TOTAL FEDERAL ANNUAL COST BURDEN (total federal budren +all public burden except for 25% of public burden on item#5) 17,586,787.66






ANNUAL REPORTING AND RECORDKEEPING HOURS BURDEN PER FORM OMB 83-I


a. Number of respondents
11,052.40

b. Total annual responses
75,010.40

1. Percentage of these responses collected electronically
100.00

c. Total annual hours requested
97,207.80

d. Current OMB inventory
42,700.00

e. Difference


54,507.80

f. Explanation of difference
Fluctuates based on the number of active awards in USAID's inventory.

1. Program change
N/A

2. Adjustment
N/A

Sheet 4: use of SBA

Impact on small businesses or other small entities
THE PAPERWORK REDUCTION ACT AND 5 CFR 1320
2024 Submission
THE PAPERWORK REDUCTION ACT AND 5 CFR 1320





Item # AIDAR citation for the info Collection Description of the estimates Annual Public Burden Annual Public Burden on Small Businesses
#5 752.7001 Biographical Data Hours per submission 0.5 0.5
Number of respondents per year 1308.0 44.0
Number of responses per respondent 8.0 8.0
Number of responses per year 10464.0 352.0
Total Annual Burden Hours 5232.0 176.0
Hourly rate 112.5 $112.48
Total Annual Cost Burden 588495.4 $19,796
TOTAL PUBLIC ANNUAL COST BURDEN NOT REIMBURSED THROUGH CONTRACTS (25% of public burden)
$4,949
File Typeapplication/zip
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy