Appendix C - Pricing Tabs 21SEP2023.xlsx

XLSX spreadsheet 53 KB Posted Sep 21, 2023

Attached to: Worldwide Conventional Weapons Destruction, PM/WRA
Solicitation number: 19AQMM23R0037
Issued by: Department of State Office of Acquisition Management

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains a pricing template for an indefinite delivery, indefinite quantity (IDIQ) contract to provide worldwide conventional weapons destruction support services to the Department of State. Key details include:

The template includes six tabs for proposing provisional and ceiling indirect rates by fiscal year, not-to-exceed profit percentages, composite indirect rates blended with the IDIQ period of performance, an illustrative task order for Iraq with fixed hourly labor rates by category and location, and a corresponding price schedule. The illustrative task order includes requirements for clearance teams, community liaison teams, project coordination, security, a program management office, DBA insurance, travel, and other direct costs. The template is to be used for proposal preparation in response to solicitation number 19AQMM23R0037 for worldwide conventional weapons destruction support from the Department of State's Office of Acquisition Management.

View the file

Other files

File	Type	Posted
Section M-001 - Evaluation (AMD 0002).pdf	PDF	Oct 13, 2023
Appendix A - QA AMD 0002_Partial Answers.xlsx	XLSX spreadsheet	Oct 13, 2023
19AQMM23R0037 0002 (Partial Answers).pdf	PDF	Oct 13, 2023
Appendix D - Bidder DD254 02OCT2023.pdf	PDF	Oct 11, 2023
19AQMM23R0037 0001 (Security).pdf	PDF	Oct 11, 2023
Appendix A - Qustion and Answer Template.xlsx	XLSX spreadsheet	Sep 21, 2023
Section M-001 - Evaluation.pdf	PDF	Sep 21, 2023
Section C-001 - IDIQ PWS 20 JUL 2023.pdf	PDF	Sep 21, 2023
Attachment H - Sample Progress Report.doc	DOC document	Sep 21, 2023
Appendix D - Bidder DD254.pdf	PDF	Sep 21, 2023
Attachment G - CWD Metrics Table.xlsx	XLSX spreadsheet	Sep 21, 2023
Section L-001 - Instructions.pdf	PDF	Sep 21, 2023
Attachment 1 - PWS for Iraq 7-27-23.pdf	PDF	Sep 21, 2023
Attachment B - To Walk the Earth in Safety_22 Edition.pdf	PDF	Sep 21, 2023
Attachment F - Equipment Commodities Inventory.doc	DOC document	Sep 21, 2023
Appendix B - Past Performance Questionnaire.docx	DOCX document	Sep 21, 2023
Attachment 2 - QASP for Iraq 7-21-23.pdf	PDF	Sep 21, 2023
Attachment A - List of Acronyms.docx	DOCX document	Sep 21, 2023
19AQMM23R0037 Conventional Weapons Destruction.pdf	PDF	Sep 21, 2023
Attachment E - List of Applicable Documents.doc	DOC document	Sep 21, 2023

Show all 20

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

1. Provisional Billing Rates Pricing Tab 1

Proposed Provisional Billing Indirect Cost Rates

	Indirect Cost Rate Description (e.g., Fringe Benefits, Overhead, G&A)	Proposed Provisional Billing Rate	Basis of Estimate of Proposed Provisional Billing Rate
(e.g., Negotiated Indirect Cost Rate Agreement with Cognizant FAO)	Allocation Base
(e.g., Direct Labor Dollars, Total Cost Input)	Contractor Fiscal Year Period

(e.g., January 1, 2023 - December 31, 2024) 1)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:
Indirect Cost Rate Description	Proposed Provisional Billing Rate	Basis of Estimate of Proposed Provisional Billing Rate	Allocation Base
Contractor Fiscal Year Period

G&A 6.27% December 1, 2022 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2023 - December 31, 2024 G&A 6.25% December 1, 2022 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2024 - December 31, 2025 G&A 6.00% December 1, 2022 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2025 - December 31, 2026 G&A 5.95% December 1, 2022 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2026 - December 31, 2027 G&A 5.80% December 1, 2022 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2027 - December 31, 2028 G&A 5.80% December 1, 2022 Forward Pricing Rate Agreement with Cognizant Federal Agency Official Total Cost Input January 1, 2028 - December 31, 2029

2. Ceiling Indirect Cost Rates Pricing Tab 2

Proposed Ceiling Indirect Cost Rates

	Indirect Cost Rate Description (e.g., Fringe Benefits, Overhead, G&A)	Proposed Ceiling Indirect Cost Rate	Basis of Estimate of Proposed Ceiling Indirect Cost Rate
(e.g., Negotiated Indirect Cost Rate Agreement with Cognizant FAO)	Allocation Base
(e.g., Direct Labor Dollars, Total Cost Input)	Contractor Fiscal Year Period

(e.g., January 1, 2023 - December 31, 2024) 1)

THE FOLLOWING IS FOR ILLUSTRATION PURPOSES ONLY:
Indirect Cost Rate Description	Proposed Ceiling Indirect Cost Rate	Basis of Estimate of Proposed

Ceiling Indirect Cost Rate Allocation Base Contractor Fiscal Year Period

3. Sample Composite Ind Rates

Pricing Tab 3

Composite G&A Rate by IDIQ Period

		FOR ILLUSTRATION PURPOSES ONLY
Sample Offeror Fiscal Year	Sample Ceiling G&A Rate Proposed in Pricing Table 2	Period 1	Period 2	Period 3	Period 4	Period 5	Six Mo. Option to Extend
January 1, 2023 - December 31, 2024	7.18%	7.16%
January 1, 2024 - December 31, 2025	7.10%		7.09%
January 1, 2025 - December 31, 2026	7.05%			7.05%
January 1, 2026 - December 31, 2027	7.03%				7.00%
January 1, 2027 - December 31, 2028	6.90%					6.89%
January 1, 2028 - December 31, 2029	6.84%						6.84%

This example blends the sample offeror fiscal year with the IDIQs contract periods of performance.

4. Profit and Fee Percentages Pricing Tab 4

Proposed Not-to-Exceed (NTE) Profit Percentages and Not-to-Exceed (NTE) Fee Percentages
		Proposed Not-to-Exceed (NTE) Profit Percentages
Period 1	Period 2	Period 3	Period 4	Period 5	Six-Month Option to Extend

(see FAR 52.217-8)

		Proposed Not-to Exceed (NTE) Fee Percentages
Period 1	Period 2	Period 3	Period 4	Period 5	Six-Month Option to Extend

(see FAR 52.217-8)

5. IDIQ Prices Pricing Tab 5

19AQMM23R0037 IDIQ Order Prices

1 Pricing Tab 7 Iraq Task Order $ 815,000.00

IDIQ Overall Proposed Price $ 815,000.00

6. Iraq Supporting Labor Rates Pricing Tab 6 Iraq Task Order Proposed Prices

Labor Costs to Support Iraq Order

																					Six-Month Option to Extend
						Base Year			Option Year 1			Option Year 2			Option Year 3			Option Year 4			(see FAR 52.217-8)
CLIN	RFP Reference	RFP-specified Labor Category	Entity	Nationality	FTE	Fixed Rate	Hours	Subtotal	Fixed Rate	Hours	Subtotal	Fixed Rate	Hours	Subtotal	Fixed Rate	Hours	Subtotal	Fixed Rate	Hours	Subtotal	Fixed Rate	Hours	6 Month Subtotal	Total
		Location: Iraq
X001	H.6.4.4.1	Program Manager (AN) (Secret) (Key)	OFF/SUB/OTH	AN	0.4		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X002	H.6.4.4.2	Task Order Leader (AN) (Secret) (Key)	OFF/SUB/OTH	AN	1.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X003	H.6.4.4.3	AXO/IED Task Order Leader (AN) (Secret) (Key)	OFF/SUB/OTH	AN	1.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X004	H.6.4.4.4	Business Finance Manager (Key)	OFF/SUB/OTH	AN/LN/TCN	0.4		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X005	H.6.4.4.5	Senior Logistics Manager (Key)	OFF/SUB/OTH	AN/LN/TCN	0.4		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X006	H.6.4.4.6	Host Country Technical Advisor (Key)	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X007	H.6.4.4.7	Senior HMA Operations Manager (AN) (Secret) (Key)	OFF/SUB/OTH	AN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X008	H.6.4.4.8	Senior Destruction Operations Manager (Key)	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X009	H.6.4.4.9	K-9 Supervisor (Key)	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X010	H.6.4.4.10	Senior Emergency Medical Technician (Key)	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X011	H.6.4.4.11	Security Manager (Key)	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X012	H.6.4.4.12	Senior Mine Detection Dog Handler	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X013	H.6.4.4.13	UXO/AXO/IED Operations Manager	OFF/SUB/OTH	AN/LN/TCN	4.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X014	H.6.4.4.14	UXO/AXO/IED Team Leader	OFF/SUB/OTH	AN/LN/TCN	30.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X015	H.6.4.4.15	UXO/AXO/IED Deputy Search Team Leader	OFF/SUB/OTH	AN/LN/TCN	26.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X016	H.6.4.4.16	UXO/AXO/IED Search Specialist	OFF/SUB/OTH	AN/LN/TCN	225.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X017	H.6.4.4.17	UXO/AXO/IED Technician I	OFF/SUB/OTH	AN/LN/TCN	14.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X018	H.6.4.4.18	UXO/AXO/IED Technician II	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X019	H.6.4.4.19	UXO/AXO/IED Technician III	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X020	H.6.4.4.20	Senior Instructor IEHR	OFF/SUB/OTH	AN/LN/TCN	2.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X021	H.6.4.4.21	High Risk Search Instructor (HRSI)	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X022	H.6.4.4.22	Explosive Hazard IED Instructor	OFF/SUB/OTH	AN/LN/TCN	4.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X023	H.6.4.4.23	Fusion Senior Analyst	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X024	H.6.4.4.24	Compliance and Coordination Supervisor	OFF/SUB/OTH	AN/LN/TCN	1.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X025	H.6.4.4.25	Liaison Officer (LO)	OFF/SUB/OTH	AN/LN/TCN	1.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X026	H.6.4.4.26	Community Liaison	OFF/SUB/OTH	AN/LN/TCN	8.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X027	H.6.4.4.27	Logistics Manager	OFF/SUB/OTH	AN/LN/TCN	4.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X028	H.6.4.4.28	Logistics Assistant	OFF/SUB/OTH	AN/LN/TCN	2.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X029	H.6.4.4.29	ATLS Medic	OFF/SUB/OTH	AN/LN/TCN	17.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X030	H.6.4.4.30	Translator	OFF/SUB/OTH	AN/LN/TCN	16.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X031	H.6.4.4.31	Program Geophysicist	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X032	H.6.4.4.32	Geophysicist	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X033	H.6.4.4.33	Environmental Engineer	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X034	H.6.4.4.34	Surveyor	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X035	H.6.4.4.35	Ammunition Supervisor	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X036	H.6.4.4.36	Ammunition Technician	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X037	H.6.4.4.37	Ammunition Handler	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X038	H.6.4.4.38	Ammunition Quality Control Inspector	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X039	H.6.4.4.39	Transportation and Disposal Coordinator	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X040	H.6.4.4.40	Hazardous Materials Transportation Specialist	OFF/SUB/OTH	AN/LN/TCN	0.1		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X041	H.6.4.4.41	Motor Vehicle Operator / Driver	OFF/SUB/OTH	AN/LN/TCN	60.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X042	H.6.4.4.42	Cook	OFF/SUB/OTH	AN/LN/TCN	1.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X043	H.6.4.4.43	Assistant Cook	OFF/SUB/OTH	AN/LN/TCN	3.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X044	H.6.4.4.44	Cleaner	OFF/SUB/OTH	AN/LN/TCN	5.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0
X045	H.6.4.4.45	Camp Manager	OFF/SUB/OTH	AN/LN/TCN	1.0		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		1,880	0.00		940	0.00	0

Total	Subtotal	Subtotal	Subtotal	Subtotal	Subtotal	Subtotal
429	0	0	0	0	0	0

Notes

FTE = RFP-specified estimated number of full-time equivalent (FTE) employees

Fixed Rate = Proposed fixed fully-loaded hourly labor rate

Hours = RFP-specified estimated number of productive hours

Subtotal (Labor) = FTE x Fixed Rate x Hours

Dir $ = RFP-specified estimated direct costs

Ind $ = Estimated ceiling indirect costs

Subtotal (Materials) = Direct $ + Ind $

Total Proposed Price = Sum of Totals

&"Times New Roman,Regular"&12&P

7. Iraq Price Schedule

	Price Schedule for Iraq Task Order
	ENTER CONTRACTOR NAME							EDIT ORANGE CELLS ONLY AND DO NOT ADJUST FORMULAS:
								Base		OY1		OY2		OY3		OY4
	CLIN #/Type	PWS Task	Description		Unit of Issue	QTY		Unit Price	Base Year Total	Unit Price	OY1 Total	Unit Price	OY2 Total	Unit Price	OY3 Total	Unit Price	OY4 Total		52.217-8 (up to 6 months)
																			Monthly Price
	X001 -
Firm Fixed Price	1	LN Clearance Team		EA	6		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0
		2	Community Liaison Team		EA	3		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0
		3	Project Coordination and Team Support		JOB	1			$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		4	Security		JOB	1			$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		5	PMO		JOB	1			$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
								Subtotals	$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0

	X002 -
Cost No Fee		DBA Insurance		JOB	1		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
			Travel - PMO and Field included		JOB	1		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
			ODCs		JOB	1		$ 145,000.00		$ 155,000.00		$ 165,000.00		$ 170,000.00		$ 180,000.00		$ 15,000.00
							Subtotals	$ 145,000.00		$ 155,000.00		$ 165,000.00		$ 170,000.00		$ 180,000.00		$ 15,000.00

	x003 -
Firm Fixed Price	6	Transition (only occurs once)	JOB	1	$ - 0	$ - 0

		Iraq TO Total Evaluated Price
(SUM of CLINs X001, X002, X003; does not include value of 52.217-8)	$ 815,000.00

File details come from the government source that posted it. Updated Sep 21, 2023.