Attachment_7__Price_Proposal_Workbook.xlsx

XLSX spreadsheet 39 KB Posted Jun 7, 2019

Attached to: MC-12 Mission Aircrew Support for JAVAMAN Tactical System Operators (TSOs)
Solicitation number: FA002119RA004
Issued by: Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

From the source

Attachment 7 Price Proposal Workbook

View the file

Other files

File	Type	Posted
Conformed_Solicitation_Amendment_-_FA002119RA0040003.pdf	PDF	Jun 7, 2019
Solicitation_Amendment_FA002119RA0040003_SF_30.pdf	PDF	Jun 7, 2019
Conformed_Solicitation_Amendment_-_FA002119RA0040002.pdf	PDF	Jun 5, 2019
Attachment_1_PWS_5_June_19.pdf	PDF	Jun 5, 2019
Questions_and_Answers_5_June_19.pdf	PDF	Jun 5, 2019
Solicitation_Amendment_FA002119RA0040002.pdf	PDF	Jun 5, 2019
Attachment_2_Editable_DD_Form_254.pdf	PDF	May 30, 2019
Attachment_1_PWS_23_May_19.pdf	PDF	May 23, 2019
Solicitation_Amendment_FA002119RA0040001.pdf	PDF	May 23, 2019
Conformed_Solicitation_to_Amendment_01.pdf	PDF	May 23, 2019
Questions_and_Answers_23_May_19.pdf	PDF	May 23, 2019
MC-12_Questions_and_Answers_22_May_19.docx	DOCX document	May 22, 2019
MC-12_Questions_and_Answers_14_May_19.pdf	PDF	May 14, 2019
Attachment_5_Subcontractor_Consent_Letter.pdf	PDF	May 8, 2019
Attachment_4_Financial_Responsibility_Questionnaire.pdf	PDF	May 8, 2019
Attachment_2_DD_Form_254.pdf	PDF	May 8, 2019
Attachment_7__Price_Proposal_Workbook.xlsx	XLSX spreadsheet	May 8, 2019
Attachment_6_Past_Performance_Questionnaire_6_May_19.rtf	RTF text file	May 8, 2019
Attachment_1_PWS.pdf	PDF	May 8, 2019
Attachment_3_Wage_Determination_2019-5319.pdf	PDF	May 8, 2019
FA002119RA004_SF33.pdf	PDF	May 8, 2019

Show all 21

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.

TP-TEP Summary

MC-12 AIRCREW SUPPORT SERVICES

AFICA/765 SCONF

TOTAL PROPOSED PRICE/ TOTAL EVALUATED PRICE WORKSHEET

Note(s) and Instruction(s): This table is for evaluation purposes only. Information presented here are automatically filled based on information provided in the "Summary" sheet/tab. Offeror is to complete the fill-in fields on this sheet. This sheet may be modified to reflect the offeror's technical proposal

This table is color coded as defined below

- Fill-in Field(s)

- Auto-calculated Field(s)

TOTAL PROPOSED PRICE (BASE PLUS ALL OPTION YEARS 1 AND 2)

LABOR CATEGORY

Start Date

BASE YEAR

OPTION YEAR 1

OPTION YEAR 2

TOTAL BASE PLUS OPTION YEARS 1 &2

% Subcontracted

# Full Time Employees

Total # Hours for all FTEs

Fully Burdened Labor Rate

Per Hour

Total

(B*C)

Fully Burdened Labor Rate

Per Hour

Total

(B*E)

Fully Burdened Labor Rate

Per Hour

Total

(B*G)

Sum (D,F,H)

X	FULL YEAR HOURS
1	MC-12 Pilots	$ - 0	$ - 0	$ - 0	$ - 0
2	MC-12 Sensor Operator/CSO	$ - 0	$ - 0	$ - 0	$ - 0
3	OPFOR/MRT Support	$ - 0	$ - 0	$ - 0	$ - 0
4	Registrar	$ - 0	$ - 0	$ - 0	$ - 0
5	Scheduler	$ - 0	$ - 0	$ - 0	$ - 0
	TOTAL COSTS	$ - 0	$ - 0	$ - 0	$ - 0

CONTRACT CLIN QUANTITY U/I UNIT PRICE TOTAL

		CLIN0001 (BASE) MOBILIZATION	1	MONTHLY		$ - 0	$ - 0
		CLIN0002 (BASE) MC -12 AIRCREW SUPPORT SVS	11	MONTHLY		$ - 0	$ - 0
		CLIN1001 (OY1) MC -12 AIRCREW SUPPORT SVS	12	MONTHLY		$ - 0	$ - 0
		CLIN2001 (OY2) MC -12 AIRCREW SUPPORT SVS
Includes labor, flight gear, and vehicles	12	MONTHLY		$ - 0	$ - 0
				TOTAL PROPOSED PRICE			$ - 0
		***FAR 52.217-8 OPTION (6 MOS EXT.)
Includes labor, flight gear, and vehicles	6	MONTHLY		$ - 0	$ - 0
				TOTAL EVALUATED PRICE			$ - 0
	*	Offerors shall round each unit price and total prices to no more than two places after the decimal point.
	**The price for CLIN 0001 shall include all costs to MOBILIZE and provide all personnel, supervision, transportation, and all other items and services necessary to provide Air Force Special Operations Command (AFSOC) MC-12 Mission Aircrew Support for JAVAMAN Tactical System Operators (TSO) in accordance with this Performance Work Statement (PWS).
	***The price for CLIN 0002 shall include all costs to provide all personnel, supervision, transportation, and alal other items and services necessary to provide AFSOC MC-12 Mission Aircrew Support for JAVAMAN TSOs in accordance with the PWS
	****The price for Option Years 1 and 2 (CLINS 1001 and 2001) shall include all costs to provide all personnel, supervision, transportation, and all other items and services necessary to provide Air Force Special Operations Command (AFSOC) MC-12 Mission Aircrew Support for JAVAMAN Tactical System Operators (TSO) in accordance with this Performance Work Statement (PWS).
	*****52.217-8, Option to Extend Services. The clause allows for up to six (6) months of extended services. The option price is calculated by multiplying the unit price for option year two (2) by a quantity of six (6) months. This establishes the Total Evaluated Price (TEP) for Government consideration.

FA002119RA004

Amendment 03 Attachment 7

&P of &N

Year 1

Fully Burdened Labor Rates and Premium Rates

ERROR:#REF!

AFICA / 765 SCONF

BASE YEAR (YEAR 1)

This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)

NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.

RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT

		BASE YEAR (YEAR 1)
		A	B	C	D	E	F	G	H
#	Labor Category	Base Rate	Fringe	OH	G & A	Profit or Fee	FCCOM	FBLR	NOTES
			A * B	Sum(A:B)*C	Sum(A:C)*D	Sum(A:D)*E	Sum(A:E)*F	Sum(A:F)
	Identify Fringe, G&A, Profit Rates
1	MC-12 Pilot	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	A
2	MC-12 Sensor Operator/CSO	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	B
3	OPFOR/MRT Support	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4	Registrar	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
5	Scheduler	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Notes to Fully Burdened Labor Rates and Premium Rates for Base Year (Year 1)
A	Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly."

B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."

FA0021-16-R-0040

Attachment 3 7 September 2016

&P of &N

Year 2

Fully Burdened Labor Rates and Premium Rates

ERROR:#REF!

AFICA / 765 SCONF

OPTION 1 (YEAR 2)

This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)

RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT

		OPTION 1 (YEAR 2)
		A	B	C	D	E	F	G	H
#	Labor Category	Base Rate	Fringe	OH	G & A	Profit or Fee	FCCOM	FBLR	NOTES
			A * B	Sum(A:B)*C	Sum(A:C)*D1	Sum(A:D)*E1	Sum(A:E)*F1	Sum(A:F)
	Identify Fringe, G&A, Profit Rates
1	MC-12 Pilot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	A
2	MC-12 Sensor Operator/CSO		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3	OPFOR/MRT Support		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4	Registrar		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
5	Scheduler		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Notes to Fully Burdened Labor Rates and Premium Rates for Option 2 (Year 2)
A	Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly."

&P of &N

Year 3

Fully Burdened Labor Rates and Premium Rates

ERROR:#REF!

AFICA / 765 SCONF

OPTION 2 (YEAR 3)

This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)

RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT

		OPTION 2 (YEAR 3)
		A	B	C	D	E	F	G	H
#	Labor Category	Base Rate	Fringe	OH	G & A	Profit or Fee	FCCOM	FBLR	NOTES
			A * B	Sum(A:B)*C	Sum(A:C)*D	Sum(A:D)*E	Sum(A:E)*F	Sum(A:F)
	Identify Fringe, G&A, Profit Rates
1	MC-12 Pilot		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	A
2	MC-12 Sensor Operator/CSO		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3	OPFOR/MRT Support		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4	Registrar		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
5	Scheduler		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Notes to Fully Burdened Labor Rates and Premium Rates for Option 2 (Year 3)
A	Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly."

&P of &N

File details come from the government source that posted it.