2. Pricing Worksheet_Revised 30AUG23.xlsx

XLSX spreadsheet 36 KB Posted Aug 31, 2023

Attached to: CBRND Countermeasures Portfolio Support
Solicitation number: W911QY-23-R-1022
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

Written by GovTribe AI · Dec 20, 2023

This pricing worksheet template provides instructions and tables for contractors to propose labor categories, rates, escalation factors, materials, travel, and other direct costs for the CBRN Defense Countermeasure Portfolio Support solicitation from the Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground. Contractors should enter proposed labor categories and loaded rates for the base year as well as escalation rates for the four option years, and populate CLIN tables with sample labor categories, hours, and rates to calculate pricing for the base year and option years. The total evaluated price across the base year and option years should be provided.

View the file

Other files

File	Type	Posted
MCM Portfolio Combined Syn_Sol_Revised 26OCT23.pdf	PDF	Oct 26, 2023
2. Pricing Worksheet_Revised 30AUG23 adjusted 15SEP2023.xlsx	XLSX spreadsheet	Sep 15, 2023
2. Pricing Worksheet_Revised 30AUG23 adjusted 14SEP2023.xlsx	XLSX spreadsheet	Sep 14, 2023
RFP_W911QY23R1022_Questions_Answers_14SEP23.pdf	PDF	Sep 14, 2023
2. Pricing Worksheet_Revised 30AUG23 adjusted 11SEP2020.xlsx	XLSX spreadsheet	Sep 11, 2023
RFP_W911QY23R1022_Questions_Answers_11SEP23.pdf	PDF	Sep 11, 2023
W911QY23R1022_Questions_Answers_05SEP23.pdf	PDF	Sep 5, 2023
Medical Countermeasure Portfolio Combined Syn_Sol_Revised 30AUG23.pdf	PDF	Aug 31, 2023
1. SOO JPEO-Countermeasure Portfolio Support_Revised 30AUG23.pdf	PDF	Aug 31, 2023
W911QY23R1022_Questions_Answers_30AUG23.pdf	PDF	Aug 31, 2023
3. Small Business Participation Commitment Document Worksheet Template.xlsx	XLSX spreadsheet	Aug 3, 2023
2. Pricing Worksheet.xlsx	XLSX spreadsheet	Aug 3, 2023
Exhibit A - Contract Data Requirement List_CDRLs.pdf	PDF	Aug 3, 2023
1. SOO JPEO-Countermeasure Portfolio Support.pdf	PDF	Aug 3, 2023
Medical Countermeasure Portfolio Combined Syn_Sol_03Aug23.pdf	PDF	Aug 3, 2023

Show all 15

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.

Instructions

Sheet:
	Labor Categories. Enter all proposed labor categories and loaded rate for the base year.

Enter the Escilation Rate for Years 2 thru 5. The Escilated Labor rate is calculated based on the prior years rate. Escalation factor. For years beyond the first year, include escalation factor based on a reputable source, such as Global Insights, for each option year, if applicable.

CLIN 1001: Select the Labor Category from the list populated from the Labor Category Tab Input the number of hours Select the Labor rate from the list populated from the Labor Category Tab

CLIN 1002: Select the Labor Category from the list populated from the Labor Category Tab Input the number of hours Select the Labor rate from the list populated from the Labor Category Tab

Materials. Itemize all items needed to perform the contract, if applicable.

Travel. Use an overall estimated cost for travel, combining such elements as air fare, per diem, and local travel multiplied by the number of trips, if applicable.

Other Direct Costs. Itemize any additional Direct Costs, if applicable. These items may include special test equipment, packaging and packing, telephone charges, etc.

	Reference Material: Attach supportive documentation for support preparation, historical data, assumptions, etc.
Prepared by:

_____________________________________

Preparer's Name, Position, Telephone number and Date

Labor Categories

Labor Category Pricing Worksheet

Company Name
Project Title:	CBRN Defense Countermeasure Portfolio Support
Point of Contact
Date:
	Base	Year 2	Year 3	Year 4	Year 5
Escalation	0%	3%	3%	3%	3%
Labor Category	Rate	Rate	Rate	Rate	Rate
Sample	$ 100.00	$ 103.00	$ 106.09	$ 109.27	$ 112.55
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0

CLIN 1001

CLIN 1001 Pricing Worksheet

Company Name
Project Title:	CBRN Defense Countermeasure Portfolio Support
Point of Contact
Date:
	Base Year			Year 2			Year 3			Year 4			Year 5
Labor Category	Hours	Rate	Total	Escalated Rate	3.00%	Total	Escalated Rate	3.00%	Total	Escalated Rate	3.00%	Total	Escalated Rate	3.00%	Total
Sample	20	100.00	$2,000.00		103.00	$2,060.00		106.09	$2,121.80		109.27	$2,185.45		112.55	$2,251.02
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
Labor Total	20		$2,000.00			$2,060.00			$2,121.80			$2,185.45			$2,251.02
Materials
Travel
Other Direct Cost
Total			$2,000.00			$2,060.00			$2,121.80			$2,185.45			$2,251.02

Evaluated Price $10,618.27

CLIN 1002

CLIN 1002 Pricing Worksheet

Company Name
Project Title:	CBRN Defense Countermeasure Portfolio Support
Point of Contact
Date:
	Base Year			Year 2			Year 3			Year 4			Year 5
Labor Category	Hours	Rate	Total	Escalated Rate	3.00%	Total	Escalated Rate	3.00%	Total	Escalated Rate	3.00%	Total	Escalated Rate	3.00%	Total
Sample	10	100.00	$1,000.00		103.00	$1,030.00		106.09	$1,060.90		109.27	$1,092.73		112.55	$1,125.51
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
			$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00		0.00	$0.00
Labor Total	10		$1,000.00			$1,030.00			$1,060.90			$1,092.73			$1,125.51
Materials
Travel
Other Direct Cost
Total			$1,000.00			$1,030.00			$1,060.90			$1,092.73			$1,125.51

Evaluated Price $5,309.14

Total Evaluated Price

Total Evaluated Price Worksheet

Company Name
Project Title:	CBRN Defense Countermeasure Portfolio Support
Point of Contact
Date:
		Base Year	Year 2	Year 3	Year 4	Year 5	Task Total
Sample Task
Portfolio Strategy, Management, and Communications		$2,000.00	$2,060.00	$2,121.80	$2,185.45	$2,251.02	$10,618.27
CBRN Defense Community Alignment		$1,000.00	$1,030.00	$1,060.90	$1,092.73	$1,125.51	$5,309.14
Total		$3,000.00	$3,090.00	$3,182.70	$3,278.18	$2,251.02
					Evaluated Price	$14,801.90

File details come from the government source that posted it. Updated Aug 31, 2023.