Attach_7_-_Pricing_Template_(Amend_2).xlsx

XLSX spreadsheet 42 KB Posted Apr 13, 2016

Attached to: Requirements Management System (RMS) Suite and Logistics Management Data Bank (LMDB) Programs Federal contract opportunity
Solicitation number: FA8770-16-R-0002
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Maxwell Air Force Base

About this file

From the source

Attachment 7 Amendment 2

View the file

Other files for this federal contract opportunity

Other files attached to Requirements Management System (RMS) Suite and Logistics Management Data Bank (LMDB) Programs, newest first.
File	Type	Posted
RFP_Amendment_3.pdf	PDF	Apr 20, 2016
RFP_Q A__5_(4-20-16).pdf	PDF	Apr 20, 2016
Attach_1_-_PWS_Amend.pdf	PDF	Apr 20, 2016
SIGNED_1423_CDRL_List_Copy_Redacted.pdf	PDF	Apr 20, 2016
RFP_Questions_and_Answers__5_(4-19-16).docx	DOCX document	Apr 19, 2016
RFP_Amendment_2_Cover_Letter.pdf	PDF	Apr 13, 2016
RFP_Questions_and_Answers__4_through_13_April_2016.pdf	PDF	Apr 13, 2016
RFP_Questions_and_Answers__3.pdf	PDF	Apr 6, 2016
RFP_Questions_and_Answers__2_(4-4-16).pdf	PDF	Apr 4, 2016
RMS_and_LMDB_RFP_Questions_and_Answers_(3-30-16).pdf	PDF	Mar 31, 2016
Attach_8_-_Past_Performance_Letter.pdf	PDF	Mar 30, 2016
Attach_3_-_Section_L_-_Amend_1.pdf	PDF	Mar 30, 2016
RFP_Amendment_1_Cover_Letter.pdf	PDF	Mar 30, 2016
Alternate_Attach_5_-_Model_Contract.docx	DOCX document	Mar 30, 2016
Attach_7_-_Pricing_Template.xlsx	XLSX spreadsheet	Mar 30, 2016
Attach_1_-_PWS.pdf	PDF	Mar 30, 2016
Attach_2_-_Quality_Assurance_Surveillance_Plan.pdf	PDF	Mar 23, 2016
Attach_13_-_Skill_Matrix.docx	DOCX document	Mar 23, 2016
Attach_5_-_Model_Contract.pdf	PDF	Mar 23, 2016
Attach_7_-_Pricing_Template.xlsx	XLSX spreadsheet	Mar 23, 2016
Attach_3_-_Section_L.pdf	PDF	Mar 23, 2016
Attach_12_-_OCI_Mitigation_Memo.pdf	PDF	Mar 23, 2016
Attach_8_-_Past_Performance_Letter.docx	DOCX document	Mar 23, 2016
Attach_14_-_Cross_Reference_Matrix.xlsx	XLSX spreadsheet	Mar 23, 2016
Attach_9_-_Past_Performance_Questionnaire.docx	DOCX document	Mar 23, 2016
Exhibit_A_-_1423_CDRLs.pdf	PDF	Mar 23, 2016
Attach_1_-_PWS.pdf	PDF	Mar 23, 2016
Attach_6_-_Solicitation_Provisions.pdf	PDF	Mar 23, 2016
Attach_10_-_Bidders_Library_Table_of_Contents.pdf	PDF	Mar 23, 2016
Attach_4_-_Section_M.pdf	PDF	Mar 23, 2016
RFP_Letter.pdf	PDF	Mar 23, 2016
Attach_11_-_ppi_tool.accdb	—	Mar 23, 2016

Show all 32

On GovTribe

Work with this file on GovTribe

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-CLIN STRUCTURE

Proposed RMS/LMDB CLIN Structure:
Base Period
CLIN NUMBER	TYPE OF EFFORT	CLIN TYPE
0001	Maintenance/Sustainment Labor (RMS)	FFP
0002	Maintenance/Sustainment Labor (LMDB)	FFP
0003	Data NSP	NSP
0004	Travel	Cost
0005	Other Direct Costs	Cost

Option 1
CLIN NUMBER	TYPE OF EFFORT	CLIN TYPE

1001	Maintenance/Sustainment Labor (RMS)	FFP
1002	Maintenance/Sustainment Labor (LMDB)	FFP
1003	Data NSP	NSP
1004	Travel	Cost
1005	Other Direct Costs	Cost

Option 2
CLIN NUMBER	TYPE OF EFFORT	CLIN TYPE
2001	Maintenance/Sustainment Labor (RMS)	FFP
2002	Maintenance/Sustainment Labor (LMDB)	FFP
2003	Data NSP	NSP
2004	Travel	Cost
2005	Other Direct Costs	Cost

Option 3
CLIN NUMBER	TYPE OF EFFORT	CLIN TYPE
3001	Maintenance/Sustainment Labor (RMS)	FFP
3002	Maintenance/Sustainment Labor (LMDB)	FFP
3003	Data NSP	NSP
3004	Travel	Cost
3005	Other Direct Costs	Cost

Option 4
CLIN NUMBER	TYPE OF EFFORT	CLIN TYPE
4001	Maintenance/Sustainment Labor (RMS)	FFP
4002	Maintenance/Sustainment Labor (LMDB)	FFP
4003	Data NSP	NSP
4004	Travel	Cost
4005	Other Direct Costs	Cost
Extension of Services (6 Months)
CLIN NUMBER	TYPE OF EFFORT	CLIN TYPE
5001	Maintenance/Sustainment Labor (RMS)	FFP
5002	Maintenance/Sustainment Labor (LMDB)	FFP
5003	Data NSP	NSP
5004	Travel	Cost
5005	Other Direct Costs	Cost
	`

&9Attachment 7 - Pricing Template

2-CLIN x001-FFP

	FIRM FIXED PRICE CLINS	BASE YEAR
	Maintenance/Sustainment Labor (RMS)	Hours	Fully Burdened Rates	Base Year Total
	0001 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0

		OPTION YEAR 1
	Maintenance/Sustainment Labor (RMS)	Hours	Fully Burdened Rates	Option 1 Total
	1001 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0

		OPTION YEAR 2
	Maintenance/Sustainment Labor (RMS)	Hours	Fully Burdened Rates	Option 2 Total
	2001 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0
		OPTION YEAR 3
	Maintenance/Sustainment Labor (RMS)	Hours	Fully Burdened Rates	Option 3 Total
	3001 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0

		OPTION YEAR 4
	Maintenance/Sustainment Labor (RMS)	Hours	Fully Burdened Rates	Option 4 Total
	4001 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0

	CALCULATED AUTOMATICALLY	EXTENSION OF SERVICES - 6 MONTHS
	Maintenance/Sustainment Labor (RMS)	Hours	Fully Burdened Rates	Extension Total
	5001 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A	0	0	$0
2	Labor Category B	0	0	$0
3	Labor Category C	0	0	$0
4	Labor Category D	0	0	$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E	0	0	$0
6	Labor Category F	0	0	$0
7	Labor Category G	0	0	$0
8	Labor Category H	0	0	$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I	0	0	$0
10	Labor Category J	0	0	$0
11	Labor Category K	0	0	$0
12	Labor Category L	0	0	$0
	Subcontractor Subtotal	0		$0

1. Offeror shall enter their labor categories, hours for each labor category and total price

for On-Site WPAFB, Ktr Site and Subcontractor labor.

2. All formulas in template add automatically, and flow to the Total Price Sheet.

3. Offerors may add labor categories, but it is the responsibility of Offeror to check

formulas based on template changes.

4. Offerors must explain inflation changes in rates from one contract period to the next.

5. Offeror should assume 1880 hours per FTE per year.

6. Round (and truncate) all burdened prices to the nearest dollar.

7. Extension of Services prices are calculated at 50% of Option 4 hours and 50% of

Option 4 FFP prices.

8. Requirement: Sections identified below. All subparagraphs are included in the following

sections unless noted by an exception:

PWS sections 1.2 thru 1.7

PWS Section 1.9, 1.9.1

Exceptions (PWS Section 1.9.2 Future Environment Support & PWS Section 1.8 System Revitalization Support)

&F &A

3-CLIN x002-FFP

	FIRM FIXED PRICE CLINS	BASE YEAR
	Maintenance/Sustainment Labor (LMDB)	Hours	Fully Burdened Rates	Base Year Total
	0002 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0

		OPTION YEAR 1
	Maintenance/Sustainment Labor (LMDB)	Hours	Fully Burdened Rates	Option 1 Total
	1002 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0

		OPTION YEAR 2
	Maintenance/Sustainment Labor (LMDB)	Hours	Fully Burdened Rates	Option 2 Total
	2002 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0
		OPTION YEAR 3
	Maintenance/Sustainment Labor (LMDB)	Hours	Fully Burdened Rates	Option 3 Total
	3002 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0

		OPTION YEAR 4
	Maintenance/Sustainment Labor (LMDB)	Hours	Fully Burdened Rates	Option 4 Total
	4002 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A			$0
2	Labor Category B			$0
3	Labor Category C			$0
4	Labor Category D			$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E			$0
6	Labor Category F			$0
7	Labor Category G			$0
8	Labor Category H			$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I			$0
10	Labor Category J			$0
11	Labor Category K			$0
12	Labor Category L			$0
	Subcontractor Subtotal	0		$0

	CALCULATED AUTOMATICALLY	EXTENSION OF SERVICES - 6 MONTHS
	Maintenance/Sustainment Labor (LMDB)	Hours	Fully Burdened Rates	Extension Total
	5002 - Maintenance/Sustainment Labor	0		$0
	On-Site WPAFB
1	Labor Category A	0	0	$0
2	Labor Category B	0	0	$0
3	Labor Category C	0	0	$0
4	Labor Category D	0	0	$0
	On-Site WPAFB Subtotal	0		$0
	Ktr Site
5	Labor Category E	0	0	$0
6	Labor Category F	0	0	$0
7	Labor Category G	0	0	$0
8	Labor Category H	0	0	$0
	Ktr Site Subtotal	0		$0
	Subcontractor
9	Labor Category I	0	0	$0
10	Labor Category J	0	0	$0
11	Labor Category K	0	0	$0
12	Labor Category L	0	0	$0
	Subcontractor Subtotal	0		$0

1. Offeror shall enter their labor categories, hours for each labor category and total price

for On-Site WPAFB, Ktr Site and Subcontractor labor.

2. All formulas in template add automatically, and flow to the Total Price Sheet.

3. Offerors may add labor categories, but it is the responsibility of Offeror to check

formulas based on template changes.

4. Offerors must explain inflation changes in rates from one contract period to the next.

5. Offeror should assume 1880 hours per FTE per year.

6. Round (and truncate) all burdened prices to the nearest dollar.

7. Extension of Services prices are calculated at 50% of Option 4 hours and 50% of

Option 4 FFP prices.

8. Requirement: Sections identified below. All subparagraphs are included in the following

sections unless noted by an exception:

PWS sections 1.2 thru 1.7

PWS Section 1.9, 1.9.1

Exceptions (PWS Section 1.9.2 Future Environment Support & PWS Section 1.8 System Revitalization Support)

&F &A

4-TOTAL PRICE

TOTAL PRICE	Base Year	Option Year 1	Option Year 2	Option Year 3	Option Year 4	Extension Of Services (6 months)	Contract Total
x001 - Maintenance/Sustainment Labor (RMS)

MeekshDD: MeekshDD:

x001 should be RMS X002 should be LMDB x008 should be x003 x010 should be x004

x011 should be x005	$0	$0	$0	$0	$0	$0	$0
	x002 - Maintenance/Sustainment Labor (LMDB)	$0	$0	$0	$0	$0	$0	$0
	x003 - Data	NSP	NSP	NSP	NSP	NSP	NSP	$0
	x004 - Travel (Cost)	$2,750	$2,750	$2,750	$2,750	$2,750	$1,375	$15,125
	x005 - Other Direct Costs (Cost)	$25,000	$25,000	$25,000	$25,000	$25,000	$12,500	$137,500
	TOTAL	$27,750	$27,750	$27,750	$27,750	$27,750	$13,875	$152,625
	1. All formulas in template add automatically, using information provided on CLIN tabs
	2. It is the responsibility of Offeror to check formulas based on template changes.
	3. Travel and ODC values are provided. Any changes to these values must be explained by the Offeror.
	4. Data CLIN is not separately priced.

Values for:
ODCs	$25,000
Travel	$2,750

NSP - Not Separately Priced

Cost - Cost Reimbursable

FFP - Firm Fixed Price

CPFF - Cost Plus Fixed Fee

&F &A

5-Cross Reference Matrix

Pricing Template / CLIN Cross Reference Matrix
CLIN NUMBER	TYPE OF EFFORT	CLIN TYPE	PWS Reference
x001	Maintenance/Sustainment Labor (RMS)	FFP	Paragraphs 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9

MeekshDD: MeekshDD:

Technical Team--must be prepared to Review the ALL Referenced Paragraphs instead of Overall Maintenance and Sustainment

x002	Maintenance/Sustainment Labor (LMDB)	FFP	Paragraphs 1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9
x003	Data NSP	Data NSP	N/A
x004	Travel	Cost Reimbursable	N/A
x005	Other Direct Costs	Cost Reimbursable	N/A

File details come from the government source that posted it. Updated Nov 14, 2017.