Tab-2_Attachment 2_to_ICR Supporting Statement_Spreadsheet

---

Overview

Source Data
ICR details
summary
use of SBA

---

Sheet 1: Source Data

====== ID#AAABTXwyM3Y Nicole Thompson (2024-08-08 15:28:38) @[email protected] This sheet was hidden and seems to include the previous GLAAS figures? Were you using anything from here? _Assigned to [email protected]_ 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) @[email protected] 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 [email protected]_ ------ 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