Document
Tab-2_Attachment 2_to_ICR Supporting Statement_Spreadsheet
ICR 202411-0412-001 · OMB 0412-0520 · Object 149846300.
Document Viewer [xlsx]
Status: The document is viewable through fallback artifacts while conversion repair continues in the background.
Queue: A repair attempt failed. The document remains flagged for retry and verification. (priority 90 · attempts 1 · next 2026-06-30 14:19:12)
Missing: html
Download: Source copy (xlsx) | pdf
Loading document viewer…
Document Metadata
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
|---|---|
| File Title | Tab-2_Attachment 2_to_ICR Supporting Statement_Spreadsheet |
| Author | Bond, Lyudmila (M/OAA/P) |
| Last Modified By | Calc |
| File Created | 2026-06-30 |
| Conversion State | failed_conversion |
Extracted Text
GLAAS DATA PROC_INST_NM SAP THRESHOLD OCEAN TRANS (Y/N) (Multiple Items) >=$250K N CONTRACT TYPE Cost Reimbursable AWARD_IDV_TYPE Sum of TEC_AMT Cost No Fee Total Cost Plus Award Fee Cost Plus Fixed Fee Cost Plus Incentive Fee Fixed Award Fee Fixed Price Incentive Fixed Price LOE Fixed Price EPA Fixed Labor Hours Time&Materials Cost Reimbursable Total Fixed Price Fixed Price Total Grand Total GS Salary DATA GS Step 13 7 13 11 15 Bureau Labor Statistics Rate Sum of OBL_AA_AMT $/hr 8 5 5 5 5 66.42 28.94 61.03 42.82 84.84 Position 56.24 Business and Financial Operations Occupation in the DC area as of May 2023 PROC_INS (Multiple Items) SAP THRES>=$250K OCEAN TRA(All) P_OF_PER (All) CO_BUS_SIS Small Business CR Contracts CONTRACTAWARD_IDV_TYPE Cost ReimbDEFINITIVE CONTRACT DELIVERY ORDER IDC Cost Reimbursable Total Sum of OBL_AA_AMT Sum of TEC_AMT # OF CONTRACTS 49935920.68 732901567.15 44 92148050.75 1191682354.44 2459604 2285082556.87 144543575.43 4209666478.46 44 PROC_INS (Multiple Items) SAP THRES>=$250K OCEAN TRA(All) P_OF_PER (All) CO_BUS_SI(All) CONTRACTAWARD_IDV_TYPE Cost ReimbDEFINITIVE CONTRACT DELIVERY ORDER IDC Cost Reimbursable Total Fixed PriceBOA BPA CALL DEFINITIVE CONTRACT DELIVERY ORDER IDC Fixed Price Total Grand Total Sum of OBL_AA_AMT Sum of TEC_AMT # OF CONTRACTS $684,564,394.54 $9,635,719,261.24 $617,110,943.85 $16,442,652,695.07 $51,442,161.29 $11,263,575,558.87 $1,353,117,499.68 $37,341,947,515.18 1308 $0.00 $42,400,000.00 $24,640,076.93 $73,428,202.84 $149,735,279.00 $1,506,417,386.17 $48,760,282.61 $508,220,036.86 $30,000.00 $18,052,975,000.00 $223,165,638.54 $20,183,440,625.87 1394 $1,576,283,138.22 $57,525,388,141.05 2702 Place of Performance OUTSIDE USA PROC_INS (Multiple Items) SAP THRES>=$250K OCEAN TRA(All) P_OF_PER (Multiple Items) CONTRACTAWARD_IDV_TYPE Cost ReimbDEFINITIVE CONTRACT DELIVERY ORDER IDC Cost Reimbursable Total Fixed PriceBOA BPA CALL DEFINITIVE CONTRACT DELIVERY ORDER IDC Fixed Price Total Grand Total Sum of OBL_AA_AMT Sum of TEC_AMT # OF CONTRACTS $650,855,425.32 $8,268,319,245.81 $500,794,160.33 $6,312,553,593.57 $51,442,161.29 $11,263,575,558.87 $1,203,091,746.94 $25,844,448,398.25 841 $0.00 $42,400,000.00 $0.00 $332,533.20 $104,510,373.06 $912,159,417.74 $23,406,555.82 $101,437,140.53 $30,000.00 $18,052,975,000.00 $127,946,928.88 $19,109,304,091.47 718 $1,331,038,675.82 $44,953,752,489.72 1559 # OF CONTRACTS C area as of May 2023 1308 1394 2702 ATTACHMENT I to the SUPPORTING STATEMENT FOR REQUEST FOR APPROVAL UNDER THE PAPERWORK2024 REDUCTION ACT AND 5 CFR 1320 Submission THE PAPERWORK REDUCTION ACT AND 5 CFR 1320 Item # AIDAR citation for the info Collection 752.219-8 Utilization of Small Business Concerns and Small 1 Disadvantaged Business Concerns #2 #3 #4 Summary & Justification Applicability Annual Federal Burden: Hours per submission Number of Respondents per year Number of responses per respondent No. of submissions/year Explanation of how the numbers are estimated Total hr burden (A x D) Hourly Rate Total cost burden (F x E) A. 0.75 B. 100 Contractors must notify OSDBU at least 45 days before C. placing orders for supplies or equipment in excess of FAR 19.708(a) and Above SAT, not PSC, not D. 100k financed by USAID. This provides USAID with the AIDAR 719.708 performed overseas. means to monitor and encourage small business E. participation 1 100 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% G. $6,505 Formula: (F*E) A. B. C. 0.50 1621 1 based on our previous experience D. 752.245-70 Requires an annual report (format provided) on Government Property -- government property. This is necessary to account for USAID Reporting government property and was recommended by the GAO Requirements to solve a standing problem. 752.245-71 Title to and Care of Property FAR or AIDAR Prescription A. B. C. D. E. F. G. 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. 752.247-70 Preference Contractors must submit copies of Bills for lading for all for privately owned shipments to USAID and MARAD. This is necessary to U.S.-flag commercial verify compliance with the Cargo Preference Act. vessel FAR 45.107 745.107 747.507 FP, CR, T&M, L-H contracts. Hours per submission Number of Respondents per year Number of responses per respondent No. of submissions/year Total hr burden (A x B) Hourly Rate Total cost burden (C x D) Explanation of how the numbers are estimated A. 1.00 B. 100 C. 1 D. 100 E. 100 Formula: (A*D) F. $112.48 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100% G. $11,248 Formula: (F*E) 0.50 1621 1 based on our previous experience 1,621 A. B. 60 % of all active contracts excluding those for FP C. ocean transportation and POs below SAT D. 1,621 E. F. G. $810.60 $128.17 $103,894 Formula: (A*D) E. hourly rate for GS 13/5 plus a burden rate of 110% F. Formula: (F*E) G. 810.6 $112.48 $91,176 (A*D) based on estimatedFormula: income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%(F*E) Formula: A. 0.50 A. 1.00 based on our previous experience B. 270 B. 270 1 10 % of all active contracts excluding those for FP C. ocean transportation and POs below SAT 1 270 D. 270 In all contracts under which the contractor will acquire C. property for use overseas and the contract funds were D. obligated under a DOAG E. F. G. 75 135.1 $128.17 $17,316 A. 0.33 B. in solicitations and contracts solely for ocean C. transportation services, and in solicitations and contracts D. for goods and ocean transportation services when E. the ocean transportation will be fixed at the time the contract is awarded. 200 3 600 198 based on our previous experience Annual Public Burden: A. B. C. D. E. F. G. based on our previous experience Formula: (A*D) based on our previous experience Formula: (A*D) E. hourly rate for GS 13/5 plus a burden rate of 110% F. Formula: (F*E) G. based on our previous experience based on our previous experience 60 % of all active contracts excluding those for FP ocean transportation and POs below SAT 10 % of all active contracts excluding those for FP ocean transportation and POs below SAT 270.2 $112.48 $30,392 (A*D) based on estimatedFormula: income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%(F*E) Formula: A. 0.25 based on our previous experience B. Based on our previous experience, we estimate number of respondents per year - 200, number of C. responses per each respondent - 3, total number of responses per year - 600. D. 200 based on our previous experience Formula: (A*D) E. 600 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. 150 Formula: (A*D) 3 #4 #5 #6 #7 #8 752.247-70 Preference Contractors must submit copies of Bills for lading for all for privately owned shipments to USAID and MARAD. This is necessary to U.S.-flag commercial verify compliance with the Cargo Preference Act. vessel 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 752.7001 Biographical overseas logistical support and allowances. Employment Data 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. 752.7002 Travel and Transportation 752.7003 Documentation for Payment 752.7004 Emergency locator information. 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. 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. 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. 747.507 N/A N/A N/A N/A 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 F. contract is awarded. in all USAID CR contracts. In all CR contracts performed in whole or in part overseas. $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 G. $19,552 Formula: (F*E) G. $16,872 based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100% Formula: (F*E) A. 0.50 based on our previous experience A. 0.50 based on our previous experience B. 1308 B. 1308 C. 8 C. 8 D. 10464 D. 10464 Number of active CR contracts and orders recorded in a FY times 8 submissions per contract E. 5232 Formula: (A*D) E. 5232 F. $128.17 hourly rate for GS 13/5 plus a burden rate of 110% F. $112.48 G. $670,584 Formula: (F*E) G. $588,495 Formula: (A*D) based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100% Formula: (F*E) A. 0.50 based on our previous experience A. 1.00 based on our previous experience B. 841 B. 841 C. 1 C. 1 D. 841 D. 841 E. 420.5 Formula: (A*D) E. 841 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) A. 1.00 based on our previous experience A. 2.00 based on our previous experience B. 1308 B. 1308 C. 24 Number of active awards excluding FP contracts C. and order multiplied by 24 (bi-weekly submissions) 24 from GLAAS Report, CR contracts performed outside of USA in all USAID direct contracts, excluding fixed D. price contracts 31392 E. 31392 Formula: (A*D) F. in all contracts requiring travel overseas. Number of active CR contracts and orders recorded in a FY times 8 submissions per contract from GLAAS Report, CR contracts performed outside of USA Formula: (A*D) Number of active awards excluding FP contracts and order multiplied by 24 (bi-weekly submissions) D. 31392 E. 62784 $128.17 hourly rate for GS 13/5 plus a burden rate of 110% F. $112.48 G. $4,023,502 Formula: (F*E) G. $7,061,944 Formula: (A*D) based on estimated income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100% Formula: (F*E) A. 0.50 based on our previous experience A. 0.5 based on our previous experience B. 2702 2702 C. 8 B. All active contracts/orders excluding those for FP ocean transportation and Pos multipied by our C. estimate of 8 submissions per contract/order 8 All active contracts/orders excluding those for FP ocean transportation and Pos multipied by our estimate of 8 submissions per contract/order #8 #9 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. 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 752.7032 International programs. Arrivals notification and travel approval Travel Approval and authority are necessary to allow the missions overseas to Notification properly conduct the political and administrative Requirements 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. Highlighted in green columns do not need to be submitted to OMB/OIRA N/A N/A in all contracts requiring travel overseas. in any USAID contract requiring international travel. All active contracts/orders excluding those for FP ocean transportation and Pos multipied by our estimate of 8 submissions per contract/order D. E. F. G. 21616 10808 $128.17 $1,385,258 A. 0.50 B. 2702 C. 3 D. 8106 E. 4053 Formula: (A*D) F. G. All active contracts/orders excluding those for FP ocean transportation and Pos multipied by our estimate of 8 submissions per contract/order D. Formula: (A*D) E. hourly rate for GS 13/5 plus a burden rate of 110% F. Formula: (F*E) G. based on our previous experience 21616 10808 $112.48 $1,215,684 (A*D) based on estimatedFormula: income per hour from the Bureau of Labor Statistics x weighted wage multiplier of 100%(F*E) Formula: A. 2.00 based on our previous experience B. 2702 All active contracts/orders excluding those for FP C. ocean transportation and POs multipied by our estimate of 3 submissions per contract/order 3 All active contracts/orders excluding those for FP ocean transportation and POs multipied by our estimate of 3 submissions per contract/order D. 8106 E. 16212 Formula: (A*D) $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% $519,472 Formula: (F*E) $1,823,526 Formula: (F*E) G. 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 0.75 1.00 100.00 100.00 1.00 1.00 Number of responses per year 100.00 100.00 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 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 A. Hours per submission 0.50 1.00 B. Number of respondents per year 270.20 270.20 1.00 1.00 Number of responses per year 270.20 270.20 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 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 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 A. Hours per submission B. Number of respondents per year 752.219-8 Utilization of Small C. Business Concerns and Small D. 1 Disadvantaged Business Concerns E. #2 #3 #4 #5 752.245-70 Government Property -- USAID Reporting Requirements C. 752.245-71 Title to and Care D. of Property E. 752.247-70 Preference for privately owned U.S.-flag commercial vessel 752.7001 Biographical Data Number of responses per respondent Number of responses per respondent #5 #6 #7 #8 #9 752.7001 Biographical Data 5,232.00 5,232.00 128.17 112.48 670,583.68 588,495.36 0.50 1.00 841.00 841.00 1.00 1.00 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 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 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 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 752.7002 Travel and Transportation 752.7003 Documentation for Payment 752.7004 Emergency locator information. 752.7032 International Travel Approval and Notification Requirements E. Total Annual Burden Hours F. Hourly rate G. Total Annual Cost Burden A. Hours per submission B. Number of respondents per year C. Number of responses per respondent D. 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 b. Total annual responses 1. Percentage of these responses collected electronically c. Total annual hours requested d. Current OMB inventory e. Difference f. Explanation of difference 1. Program change 2. Adjustment 11,052.40 75,010.40 100.00 97,207.80 42,700.00 Fluctuates based 54,507.80 on the number of active awards in USAID's inventory. N/A N/A Impact on small businesses or other small entities THE PAPERWORK2024 REDUCTION ACT AND 5 CFR 1320 Submission THE PAPERWORK REDUCTION ACT AND 5 CFR 1320 Item # AIDAR citation for the info Collection Description of the estimates Hours per submission 0.5 1308.0 44.0 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 588495.4 $19,796 Number of responses per respondent 752.7001 Biographical Data Annual Public Burden on Small Businesses 0.5 Number of respondents per year #5 Annual Public Burden TOTAL PUBLIC ANNUAL COST BURDEN NOT Total Annual Cost Burden REIMBURSED THROUGH CONTRACTS (25% of public burden) $4,949