Exhibit C OMSAS_IV_Pricing_Model.xlsx

XLSX spreadsheet 36 KB Posted Apr 23, 2021

Attached to: OFFENSIVE MISSILE SYSTEM ANALYSIS SUPPORT Amendment 02
Solicitation number: HHM402-21-R-0016
Issued by: Defense Intelligence Agency

View the file

Other files

File	Type	Posted
Past Performance Questionnaire OMSAS IV fillable.pdf	PDF	May 25, 2021
HHM402-21-R-0016 OMSAS IV RFP Amendment_02.pdf	PDF	May 11, 2021
HHM402-21-R-0016 OMSAS IV RFP Amendment_01.pdf	PDF	Apr 30, 2021
Exhibit C OMSAS_IV_Pricing_Model AM 01.xlsx	XLSX spreadsheet	Apr 30, 2021
OMSAS Contractor Questions Apr 2021.xlsx	XLSX spreadsheet	Apr 30, 2021
RFP HHM402-21-R-0016 OMSAS IV 22 Apr 2021.pdf	PDF	Apr 23, 2021
Past Performance Questionnaire OMSAS IV fillable.pdf	PDF	Apr 23, 2021

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 Exhibit C

Instructions

1. Offeror shall enter fully burdened hourly labor rates without Fixed Fee into cells under Columns E and G (Tan Colored Cells Only). The rates will roll up to the other tabs in the spreadsheet.

2. ALL Labor Hours/Labor Categories/Travel/Material values are provided and Offeror shall NOT adjust or change formulas in the spreadsheet.

3. Offeror shall enter proposed Labor Fixed Fee Percentage, Column H (Tan Colored Cell Only).

4. Total of ten (10) Ordering Years shall be included in the Offeror's proposal.

OMSAS IV

Offensive Missile Analysis and Support (OMSAS) IV

BASE ORDERING PERIOD YEAR ONE (1)
	Fully Burdened Rates
Ordering Year 1	Govt. Site Hours*	Govt. Site Rate	CTR Site Hours**	CTR Site Rate	Total
Program Manager	4680.00		1560.00		$ - 0
Engineer 5	15600.00		5200.00		$ - 0
Engineer 4	28080.00		9360.00		$ - 0
Engineer 3	18720.00		6240.00		$ - 0
Engineer 2	18720.00		6240.00		$ - 0
Engineer 1	6240.00		2080.00		$ - 0
Junior Engineer	6240.00		2080.00		$ - 0
Research Specialist 1	6240.00		2080.00		$ - 0
Research Specialist 2	4680.00		1560.00		$ - 0
Technician 2	12480.00		4160.00		$ - 0
Technician 1	4680.00		1560.00		$ - 0
Technical Writer	3120.00		1040.00		$ - 0
Technical Editor	3120.00		1040.00		$ - 0
Technical Illustrator	3120.00		1040.00		$ - 0
Analyst 2	15600.00		5200.00		$ - 0
Analyst 1	3120.00		1040.00		$ - 0
Assistant Program Manager	4680.00		1560.00		$ - 0
Security	1560.00		520.00		$ - 0
214,240	160680.00		53560.00		$ - 0
				Fixed Fee (%)
			Ordering Year 1 Total Labor		$ - 0
Travel ODC (Plug Number)	$1,500,000.00
Material/ODC (Plug Number)	$1,750,000.00
			Ordering Year 1 TOTAL		$ 3,250,000.00

BASE ORDERING PERIOD YEAR TWO (2)
	Fully Burdened Rates
Ordering Year 2	Govt. Site Hours	Govt. Site Rate	CTR Site Hours	CTR Site Rate	Total
Program Manager	5148.00		1716.00		$ - 0
Engineer 5	17160.00		5720.00		$ - 0
Engineer 4	30888.00		10296.00		$ - 0
Engineer 3	20592.00		6864.00		$ - 0
Engineer 2	20592.00		6864.00		$ - 0
Engineer 1	6864.00		2288.00		$ - 0
Junior Engineer	6864.00		2288.00		$ - 0
Research Specialist 1	6864.00		2288.00		$ - 0
Research Specialist 2	5148.00		1716.00		$ - 0
Technician 2	13728.00		4576.00		$ - 0
Technician 1	5148.00		1716.00		$ - 0
Technical Writer	3432.00		1144.00		$ - 0
Technical Editor	3432.00		1144.00		$ - 0
Technical Illustrator	3432.00		1144.00		$ - 0
Analyst 2	17160.00		5720.00		$ - 0
Analyst 1	3432.00		1144.00		$ - 0
Assistant Program Manager	5148.00		1716.00		$ - 0
Security	1716.00		572.00		$ - 0
235,664	176,748.00		58,916.00		$ - 0
				Fixed Fee (%)
			Ordering Year 2 Total Labor		$ - 0
Travel ODC (Plug Number)	$1,650,000
Material/ODC (Plug Number)	$1,925,000
			Ordering Year 2 TOTAL		$ 3,575,000.00
BASE ORDERING PERIOD YEAR THREE (3)
	Fully Burdened Rates
Ordering Year 3	Govt. Site Hours	Govt. Site Rate	CTR Site Hours	CTR Site Rate	Total
Program Manager	5662.80		1887.60		$ - 0
Engineer 5	18876.00		6292.00		$ - 0
Engineer 4	33976.80		11325.60		$ - 0
Engineer 3	22651.20		7550.40		$ - 0
Engineer 2	22651.20		7550.40		$ - 0
Engineer 1	7550.40		2516.80		$ - 0
Junior Engineer	7550.40		2516.80		$ - 0
Research Specialist 1	7550.40		2516.80		$ - 0
Research Specialist 2	5662.80		1887.60		$ - 0
Technician 2	15100.80		5033.60		$ - 0
Technician 1	5662.80		1887.60		$ - 0
Technical Writer	3775.20		1258.40		$ - 0
Technical Editor	3775.20		1258.40		$ - 0
Technical Illustrator	3775.20		1258.40		$ - 0
Analyst 2	18876.00		6292.00		$ - 0
Analyst 1	3775.20		1258.40		$ - 0
Assistant Program Manager	5662.80		1887.60		$ - 0
Security	1887.60		692.20		$ - 0
259,293	194,422.80		64,870.60		$ - 0
				Fixed Fee (%)
			Ordering Year 3 Total Labor		$ - 0
Travel ODC (Plug Number)	$1,815,000.00
Material/ODC (Plug Number)	$2,117,500.00
			Ordering Year 3 TOTAL		$ 3,932,500.00

BASE ORDERING PERIOD YEAR FOUR (4)
	Fully Burdened Rates
Ordering Year 4	Govt. Site Hours	Govt. Site Rate	CTR Site Hours	CTR Site Rate	Total
Program Manager	6229.08		2076.36		$ - 0
Engineer 5	20763.60		6921.20		$ - 0
Engineer 4	37374.48		12458.16		$ - 0
Engineer 3	24916.32		8305.44		$ - 0
Engineer 2	24916.32		8305.44		$ - 0
Engineer 1	8305.44		2768.48		$ - 0
Junior Engineer	8305.44		2768.48		$ - 0
Research Specialist 1	8305.44		2768.48		$ - 0
Research Specialist 2	6229.08		2076.36		$ - 0
Technician 2	16610.88		5536.96		$ - 0
Technician 1	6229.08		2076.36		$ - 0
Technical Writer	4152.72		1384.24		$ - 0
Technical Editor	4152.72		1384.24		$ - 0
Technical Illustrator	4152.72		1384.24		$ - 0
Analyst 2	20763.60		6921.20		$ - 0
Analyst 1	4152.72		1384.24		$ - 0
Assistant Program Manager	6229.08		2076.36		$ - 0
Security	2076.36		692.12		$ - 0
285,153	213,865.08		71,288.36		$ - 0
				Fixed Fee (%)
			Ordering Year 4 Total Labor		$ - 0
Travel ODC (Plug Number)	$1,996,500.00
Material/ODC (Plug Number)	$2,329,250.00
			Ordering Year 4 TOTAL		$ 4,325,750.00
BASE ORDERING PERIOD YEAR FIVE (5)
	Fully Burdened Rates
Ordering Year 5	Govt. Site Hours	Govt. Site Rate	CTR Site Hours	CTR Site Rate	Total
Program Manager	6851.99		2284.00		$ - 0
Engineer 5	22839.96		7613.32		$ - 0
Engineer 4	41111.93		13703.98		$ - 0
Engineer 3	27407.95		9135.98		$ - 0
Engineer 2	27407.95		9135.98		$ - 0
Engineer 1	9135.98		3045.33		$ - 0
Junior Engineer	9135.98		3045.33		$ - 0
Research Specialist 1	9135.98		3045.33		$ - 0
Research Specialist 2	6851.99		2284.00		$ - 0
Technician 2	18271.97		6090.66		$ - 0
Technician 1	6851.99		2284.00		$ - 0
Technical Writer	4567.99		1522.66		$ - 0
Technical Editor	4567.99		1522.66		$ - 0
Technical Illustrator	4567.99		1522.66		$ - 0
Analyst 2	22839.96		7613.32		$ - 0
Analyst 1	4567.99		1522.66		$ - 0
Assistant Program Manager	6851.99		2284.00		$ - 0
Security	2284.00		761.33		$ - 0
313,669	235251.58		78417.20		$ - 0
				Fixed Fee (%)
			Ordering Year 5 Total Labor		$ - 0

Travel ODC (Plug Number)	$2,196,150.00
Material/ODC (Plug Number)	$2,562,175.00
			Ordering Year 5 TOTAL		$ 4,758,325.00
0PTION ORDERING PERIOD YEAR ONE (1)
	Fully Burdened Rates
Ordering Year 6	Govt. Site Hours	Govt. Site Rate	CTR Site Hours	CTR Site Rate	Total
Program Manager	7537.19		2512.40		$ - 0
Engineer 5	25123.96		8374.65		$ - 0
Engineer 4	45223.12		15074.37		$ - 0
Engineer 3	30148.75		10049.58		$ - 0
Engineer 2	30148.75		10049.58		$ - 0
Engineer 1	10049.58		3349.86		$ - 0
Junior Engineer	10049.58		3349.86		$ - 0
Research Specialist 1	10049.58		3349.86		$ - 0
Research Specialist 2	7537.19		2512.40		$ - 0
Technician 2	20099.16		6699.72		$ - 0
Technician 1	7537.19		2512.40		$ - 0
Technical Writer	5024.79		1674.93		$ - 0
Technical Editor	5024.79		1674.93		$ - 0
Technical Illustrator	5024.79		1674.93		$ - 0
Analyst 2	25123.96		8374.65		$ - 0
Analyst 1	5024.79		1674.93		$ - 0
Assistant Program Manager	7537.19		2512.40		$ - 0
Security	2512.40		837.47		$ - 0
345,036	258776.76		86258.92		$ - 0
				Fixed Fee (%)
			Ordering Year 6 Total Labor		$ - 0
Travel ODC (Plug Number)	$2,415,765.00
Material/ODC (Plug Number)	$2,818,392.50
			Ordering Year 6 TOTAL		$ 5,234,157.50
0PTION ORDERING PERIOD YEAR TWO (2)
	Fully Burdened Rates
Ordering Year 7	Govt. Site Hours	Govt. Site Rate	CTR Site Hours	CTR Site Rate	Total
Program Manager	8290.91		2763.64		$ - 0
Engineer 5	27636.35		9212.12		$ - 0
Engineer 4	49745.43		16581.81		$ - 0
Engineer 3	33163.62		11054.54		$ - 0
Engineer 2	33163.62		11054.54		$ - 0
Engineer 1	11054.54		3684.85		$ - 0
Junior Engineer	11054.54		3684.85		$ - 0
Research Specialist 1	11054.54		3684.85		$ - 0
Research Specialist 2	8290.91		2763.64		$ - 0
Technician 2	22109.08		7369.69		$ - 0
Technician 1	8290.91		2763.64		$ - 0
Technical Writer	5527.27		1842.42		$ - 0
Technical Editor	5527.27		1842.42		$ - 0
Technical Illustrator	5527.27		1842.42		$ - 0
Analyst 2	27636.35		9212.12		$ - 0
Analyst 1	5527.27		1842.42		$ - 0
Assistant Program Manager	8290.91		2763.64		$ - 0
Security	2763.64		921.21		$ - 0
379,539	284654.43		94884.82		$ - 0
				Fixed Fee (%)
			Ordering Year 7 Total Labor		$ - 0
Travel ODC (Plug Number)	$2,657,341.50
Material/ODC (Plug Number)	$3,100,237.75
			Ordering Year 7 TOTAL		$ 5,757,579.25
0PTION ORDERING PERIOD YEAR THREE (3)
	Fully Burdened Rates
Ordering Year 8	Govt. Site Hours	Govt. Site Rate	CTR Site Hours	CTR Site Rate	Total
Program Manager	9120.00		3040.00		$ - 0
Engineer 5	30399.99		10133.33		$ - 0
Engineer 4	54719.98		18239.99		$ - 0
Engineer 3	36479.98		12159.99		$ - 0
Engineer 2	36479.98		12159.99		$ - 0
Engineer 1	12159.99		4053.33		$ - 0
Junior Engineer	12159.99		4053.33		$ - 0
Research Specialist 1	12159.99		4053.33		$ - 0
Research Specialist 2	9120.00		3040.00		$ - 0
Technician 2	24319.99		8106.66		$ - 0
Technician 1	9120.00		3040.00		$ - 0
Technical Writer	6080.00		2026.67		$ - 0
Technical Editor	6080.00		2026.67		$ - 0
Technical Illustrator	6080.00		2026.67		$ - 0
Analyst 2	30399.99		10133.33		$ - 0
Analyst 1	6080.00		2026.67		$ - 0
Assistant Program Manager	9120.00		3040.00		$ - 0
Security	3040.00		1013.33		$ - 0
417,493	313119.88		104373.29		$ - 0
				Fixed Fee (%)
			Ordering Year 8 Total Labor		$ - 0
Travel ODC (Plug Number)	$2,923,075.65
Material/ODC (Plug Number)	$3,410,254.93
			Ordering Year 8 TOTAL		$ 6,333,330.58
0PTION ORDERING PERIOD YEAR FOUR (4)
	Fully Burdened Rates
Ordering Year 9	Govt. Site Hours	Govt. Site Rate	CTR Site Hours	CTR Site Rate	Total
Program Manager	10032.00		3344.00		$ - 0
Engineer 5	33439.99		11146.66		$ - 0
Engineer 4	60191.97		20063.99		$ - 0
Engineer 3	40127.98		13375.99		$ - 0
Engineer 2	40127.98		13375.99		$ - 0
Engineer 1	13375.99		4458.66		$ - 0
Junior Engineer	13375.99		4458.66		$ - 0
Research Specialist 1	13375.99		4458.66		$ - 0
Research Specialist 2	10032.00		3344.00		$ - 0
Technician 2	26751.99		8917.33		$ - 0
Technician 1	10032.00		3344.00		$ - 0
Technical Writer	6688.00		2229.33		$ - 0
Technical Editor	6688.00		2229.33		$ - 0
Technical Illustrator	6688.00		2229.33		$ - 0
Analyst 2	33439.99		11146.66		$ - 0
Analyst 1	6688.00		2229.33		$ - 0
Assistant Program Manager	10032.00		3344.00		$ - 0
Security	3344.00		1114.67		$ - 0
459,242	344431.87		114810.59		$ - 0
				Fixed Fee (%)
			Ordering Year 9 Total Labor		$ - 0
Travel ODC (Plug Number)	$3,215,383.22
Material/ODC (Plug Number)	$3,751,280.42
			Ordering Year 9 TOTAL		$ 6,966,663.64
0PTION ORDERING PERIOD YEAR FIVE (5)
	Fully Burdened Rates
Ordering Year 10	Govt. Site Hours	Govt. Site Rate	CTR Site Hours	CTR Site Rate	Total
Program Manager	11035.20		3678.40		$ - 0
Engineer 5	36783.98		12261.33		$ - 0
Engineer 4	66211.17		22070.39		$ - 0
Engineer 3	44140.78		14713.59		$ - 0
Engineer 2	44140.78		14713.59		$ - 0
Engineer 1	14713.59		4904.53		$ - 0
Junior Engineer	14713.59		4904.53		$ - 0
Research Specialist 1	14713.59		4904.53		$ - 0
Research Specialist 2	11035.20		3678.40		$ - 0
Technician 2	29427.19		9809.06		$ - 0
Technician 1	11035.20		3678.40		$ - 0
Technical Writer	7356.80		2452.27		$ - 0
Technical Editor	7356.80		2452.27		$ - 0
Technical Illustrator	7356.80		2452.27		$ - 0
Analyst 2	36783.98		12261.33		$ - 0
Analyst 1	7356.80		2452.27		$ - 0
Assistant Program Manager	11035.20		3678.40		$ - 0
Security	3678.40		1226.13		$ - 0
505,167	378875.05		126291.69		$ - 0
				Fixed Fee (%)
			Ordering Year 10 Total Labor		$ - 0
Travel ODC (Plug Number)	$3,536,921.54
Material/ODC (Plug Number)	$4,126,408.46
			Ordering Year 10 TOTAL		$ 7,663,330.00
FAR 52.217-8 OPTION TO EXTEND THE TERM OF THE CONTRACT NTE 6 MONTHS, see DARSI 5552.217-9001 for pricing evaluation of the option.
TOTAL Base Ordering Period Years 1-5 plus Option Ordering Years 5-10					$ 51,796,635.97

OMSAS_Pricing_ Model

Use or disclosure of data contained on this sheet is subject to the restriction on the title page of this proposal.

SOURCE SELECTION INFORMATION - See FAR 2.101 and 3.104 &P

Summary CLIN Breakdown

SCOAA CLIN Breakdown
		Base Ordering Period					Optional Ordering Periods
CLIN #	Description	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10	6 month extension	CLIN SubTotal
CLIN 0001	Direct Labor for SCOAA	$0.00	$0.00	$0.00	$0.00	$0.00							$0.00
CLIN 0003	Other Direct Costs (ODC) - Travel	$1,500,000.00	$1,650,000.00	$1,815,000.00	$1,996,500.00	$2,196,150.00							$9,157,650.00
CLIN 0004	Other Direct Costs (ODC) - Materials	$1,750,000.00	$1,925,000.00	$2,117,500.00	$2,329,250.00	$2,562,175.00							$10,683,925.00
CLIN 0005	Contract Data Reporting/Deliverables	NSP	NSP	NSP	NSP	NSP							NSP
CLIN 1001	Option: Direct Labor for SCOAA						$0.00	$0.00	$0.00	$0.00	$0.00		$0.00
CLIN 1003	Option: Other Direct Costs (ODC) - Travel						$2,415,765.00	$2,657,341.50	$2,923,075.65	$3,215,383.22	$3,536,921.54		$14,748,486.91
CLIN 1004	Option: Other Direct Costs (ODC) - Materials						$2,818,392.50	$3,100,237.75	$3,410,254.93	$3,751,280.42	$4,126,408.46		$17,206,574.06
CLIN 1005	Option: Contract Data Reporting/Deliverables						NSP	NSP	NSP	NSP	NSP		NSP
CLIN 2001	Option: Direct Labor for SCOAA											$0.00	$0.00
CLIN 2003	Option: Other Direct Costs (ODC) - Travel											$1,768,460.77	$1,768,460.77
CLIN 2004	Option: Other Direct Costs (ODC) - Materials											$2,063,204.23	$2,063,204.23
CLIN 2004	Option: Contract Data Reporting/Deliverables											NSP	NSP
Yearly SubTotal		$3,250,000.00	$3,575,000.00	$3,932,500.00	$4,325,750.00	$4,758,325.00	$5,234,157.50	$5,757,579.25	$6,333,330.58	$6,966,663.64	$7,663,330.00	$3,831,665.00
Ordering Period Total		$19,841,575.00					$31,955,060.97					$3,831,665.00
SCOAA TOTAL													$55,628,300.97

File details come from the government source that posted it. Updated Apr 23, 2021.