2. Pricing Worksheet_Revised 30AUG23 adjusted 15SEP2023.xlsx

XLSX spreadsheet 38 KB Posted Sep 15, 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 labor categories and rates for a potential federal contract to provide CBRN Defense Countermeasure Portfolio Support services to the Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground. The five-year contract includes two tasks: Sample Task Portfolio Strategy, Management, and Communications; and CBRN Defense Community Alignment. For each year, the template requires entering labor categories and hours to calculate extended pricing for the tasks. Escalation rates of 3% are included for years two through five. The total evaluated price for all years is $15,927.41.

The related federal contract opportunity is solicitation number W911QY-23-R-1022 for CBRND Countermeasures Portfolio Support services. The solicitation is from the Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground.

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 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
1. SOO JPEO-Countermeasure Portfolio Support_Revised 30AUG23.pdf	PDF	Aug 31, 2023
Medical Countermeasure Portfolio Combined Syn_Sol_Revised 30AUG23.pdf	PDF	Aug 31, 2023
W911QY23R1022_Questions_Answers_30AUG23.pdf	PDF	Aug 31, 2023
2. Pricing Worksheet_Revised 30AUG23.xlsx	XLSX spreadsheet	Aug 31, 2023
Medical Countermeasure Portfolio Combined Syn_Sol_03Aug23.pdf	PDF	Aug 3, 2023
2. Pricing Worksheet.xlsx	XLSX spreadsheet	Aug 3, 2023
3. Small Business Participation Commitment Document Worksheet Template.xlsx	XLSX spreadsheet	Aug 3, 2023
1. SOO JPEO-Countermeasure Portfolio Support.pdf	PDF	Aug 3, 2023
Exhibit A - Contract Data Requirement List_CDRLs.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
Labor Total		$3,000.00	$3,090.00	$3,182.70	$3,278.18	$3,376.53
Materials		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Travel		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Other Direct Cost		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Total		$0.00	$0.00	$0.00	$0.00	$0.00

Evaluated Price $15,927.41

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