11 - Atch 6-Cost Proposal Workbook Version 1.1.xls

XLS spreadsheet 114 KB Posted Aug 21, 2012

Attached to: Joint Terminal Attack Controller and Small Unmanned Aerial Systems (JTAC/SUAS) Program Management Federal contract opportunity
Solicitation number: FA0021-12-R-0014
Issued by: Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

From the source

Revised Attachment 6 - Cost Proposal Workbook

View the file

Other files for this federal contract opportunity

Other files attached to Joint Terminal Attack Controller and Small Unmanned Aerial Systems (JTAC/SUAS) Program Management, newest first.
File	Type	Posted
FA0021-12-R-0014 Q As 10.pdf	PDF	Aug 27, 2012
FA0021-12-R-0014 Q As 9.pdf	PDF	Aug 24, 2012
FA0021-12-R-0014 P0005.pdf	PDF	Aug 21, 2012
FA0021-12-R-0014 Q As 8.pdf	PDF	Aug 21, 2012
FA0021-12-R-0014 Q As 7.pdf	PDF	Aug 15, 2012
FA0021-12-R-014 P0004.pdf	PDF	Aug 15, 2012
FA0021-12-R-0014 Q As 6.pdf	PDF	Aug 10, 2012
13 - Atch 8.1-Relevancy Matrix.pdf	PDF	Aug 10, 2012
FA0021-12-R-0014 P0003.pdf	PDF	Aug 10, 2012
FA0021-12-R-0014 Q As 5.pdf	PDF	Aug 9, 2012
FA0021-12-R-0014 Q As 4.pdf	PDF	Aug 8, 2012
FA0021-12-R-0014 P0002.pdf	PDF	Aug 8, 2012
FA0021-12-R-0014 Q As 1.pdf	PDF	Aug 7, 2012
FA0021-12-R-0014 Q As 3.pdf	PDF	Aug 6, 2012
FA0021-12-R-0014 Q As 2.pdf	PDF	Aug 6, 2012
Amendment 1.pdf	PDF	Aug 6, 2012
1 - Atch 1-Labor Descriptions.doc	DOC document	Aug 1, 2012
4 - Atch 2-App B - LOI.doc	DOC document	Aug 1, 2012
6 - Atch 2 - App D CDRLs Final.pdf	PDF	Aug 1, 2012
7 - Atch 2-App E - Acronyms.doc	DOC document	Aug 1, 2012
12 - Atch 7-PPQ and Cvr Ltr.doc	DOC document	Aug 1, 2012
8 - Atch 3 -WD 2005-3033.pdf	PDF	Aug 1, 2012
3 - Atch 2-App A - Mission Description.doc	DOC document	Aug 1, 2012
15 - Atch 10-Consent Ltr.doc	DOC document	Aug 1, 2012
13 - Atch 8-Relevancy Matrix.doc	DOC document	Aug 1, 2012
10 - Atch 5 -WD-2005-2567.pdf	PDF	Aug 1, 2012
14 - Atch 9-P PP Citation List.doc	DOC document	Aug 1, 2012
2 - Atch 2 - PWS.doc	DOC document	Aug 1, 2012
16 - Atch 11-PPQ Recipient List.doc	DOC document	Aug 1, 2012
11 - Atch 6-Cost Proposal Workbook.xls	XLS spreadsheet	Aug 1, 2012
5 - Atch 2 App C - DD254 - Signed.pdf	PDF	Aug 1, 2012
9 - Atch 4-WD-2005-2393.pdf	PDF	Aug 1, 2012
FA0021-12-R-0014.pdf	PDF	Aug 1, 2012

Show all 33

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.0 INSTRUCTION-PRIME

Worksheet 1.0
INSTRUCTIONS TO OFFERORS
(PRIME CONTRACTOR)
1. Worksheets contained in this workbook shall be used to form the core of your cost proposal. As stated in Section L of the RFP, all COST AREA information shall be submitted in electronic format, plus the number of paper copies indicated.
2. This workbook is designed to make the proposal process less confusing for offerors and to make the evaluation of the cost area easier for the Government. Please provide the information required on the worksheets in the format provided. "PLEASE DO NOT ADJUST THE FORMAT.*
*Note: If you need additional cost categories that are not included in the FBLRs worksheet (Sheet 4.0), you may insert additional columns only in the GREEN COLUMNS - to accommodate the added indirect categories. DO NOT delete any columns. If you don't propose Fringe or COM, for example, leave them blank.
The following worksheets are for the Prime Contractor.
1.0 INSTRUCTIONS TO OFFERORS (PRIME CONTRACTOR) - Provides general instructions/directions to the
Prime Contractor
2.0 INSTRUCTIONS TO OFFERORS (MAJOR SUBCONTRACTORS) - Provides general instructions/directions to
Major Subcontractors (Defined in Para 10 below).
3.0 GENERAL INFORMATION -JTAC- Identifies administrative information that is required for reasonableness analysis.
4.0 GENERAL INFORMATION -SUAS- Identifies administrative information that is required for reasonableness analysis.
5.0 Offeror Calculations - Provides worksheet to input offeror's charges.
3. In the worksheets themselves, the following color codes are used:
	Yellow Cells:	Offeror enters cost data.
	Blue Cells:	Totals usually referenced from other worksheets.
	Green Cells:	Cells containing specific information.
4. Please use the following filename when submitting the Cost Volume: "COMPANYNAMECOST."
5. The Prime Contractor shall complete and submit all Worksheets.
6. Additional comments / directions may be provided in the "Comments" section of individual cells.
7. For the purposes of cost evaluation only, MAJOR SUBCONTRACTOR is defined as any subcontractor providing
20% or more of any given labor category.

&CJTAC/SUAS PROPOSAL WORK BOOK&RSolicitation No.: FA0021-12-R-0014 &CAtch 6 Page &P of &[11

2.0 INSTRUCTION-SUBS

Worksheet 2.0
INSTRUCTIONS TO OFFERORS
(MAJOR SUBCONTRACTORS)
1. Major Subcontractor is defined as any subcontractor who is expected to provide 20% or more of any given labor category. (See Para 7, Worksheet 1.0.)
2. For those firms proposing as Major Subcontractors to a Prime, Worksheet 4.0 Offeror Calculations shall be completed as appropriate for those labor categories provided by the sub. A copy of the sub's completed Worksheet 4.0 shall be provided to the Government by the proposal due date, either through the Prime or under separate cover to the Government.
3. The following worksheets shall form the core of your cost proposal. As requested in Section L of the RFP, all COST AREA information should be presented in electronic format plus the number of paper copies indicated.
4. This workbook is designed to make the proposal process less confusing for offerors and to make the evaluation of the cost area easier for the Government. Please provide the information required on the worksheets in the format provided. PLEASE DO NOT ADJUST THE FORMAT.
*If you need additional cost categories that are not included in the FBLRs worksheet, you may insert additional columns only in the GREEN COLUMNS - to accommodate the added indirect categories. DO NOT delete any columns. If you don't propose Fringe or COM, for example, leave them blank.
5. Subcontractors are requested to complete and submit the following completed Worksheets:
2.0 INSTRUCTIONS TO OFFERORS - (MAJOR SUBCONTRACTORS) - Provides general instructions/directions to Subcontractors.
3.0 GENERAL INFORMATION -JTAC- Identifies administrative information that is required for reasonableness analysis.
4.0 GENERAL INFORMATION -SUAS- Identifies administrative information that is required for reasonableness analysis.
5.0 Offeror Calculations - Provides worksheet to input offeror's charges.
6. As discussed previously and under Sections L & M of the RFP, Subcontractors may submit their detailed proposals under separate cover by the proposal due date as identified in the RFP.
7. In the worksheets themselves, the following color codes are used:
	Yellow Cells:	Offeror enters cost data.
	Blue Cells:	Totals usually referenced from other worksheets.
	Green Cells:	Cells containing specific information.
8. Please use the following filename when submitting the Cost Volume: "COMPANYNAMECOST."
9. Major subcontractors are required to complete Worksheets 3.0 and 4.0. If they desire, they may provide their calculations directly to the Government under separate cover by the proposal date as identified in the RFP.
10. Additional comments / directions may be provided in the "Comments" section of individual cells.

&CJTAC/SUAS PROPOSAL WORK BOOK&RSolicitation No.: FA0021-12-R-0014 &L &CAttachment 6 Page &Pof &N

3.0 GENERAL INFORMATION

Worksheet 3.0: General Information
Prime:	_________________________		(if proposing as a Subcontractor)
		GENERAL REQUIRED INFORMATION			The following General Information
					Tab continues through line 69
To the Offerors: Please provide the information requested below:
1.	Offeror	ABC CORP
	St. Address	PO Box 100
	City,State	ANYWHERE, USA
	Zip	XXXXXX
	Telephone	XXXXXX
2.0 Profit Rate
3. Cognizant DCAA Auditor
	Name	Mr. John Doe
	Office	Cognizant DCAA
	St. Address	Anywhere
	City,State	USA
	Zip	XXXXXX
	Telephone	XXXXXX
	e-mail	XXXXXX
	FAX	XXXXXX
4. Are you Proposing using FPRAs?
		YES		Provide Copy of FPRA
		NO		Provide Support/Justification for Rates Used
		Partly		(explain)
5. Escalation: Identify the escalation used to generate the Direct Labor Rates
	Year 1
	Year 2
	Year 3
	Year 4
	Year 5
	Escalation Index Used:
	Other Method of
	Escalation:
6. Uncompensated Overtime (UOT): Note: The Government does not encourage the use of UOT
	Are the proposed rates generated assuming UOT?				NO
					YES
	If Yes, Answer the following:
		a. UOT discount directed by DCAA? _______________________
		b. Go To Tab "UOT"

&CJTAC PROPOSAL WORK BOOK&RSolicitation No.: FA0021-12-R-0014 &C Attachment 6 Page &Pof &N

4.0 Offeror Calculations - JTAC

Worksheet 4.0: Offeror Calculations JTAC
Calculates the Average/Maximum FBLR for the Prime (or Subcontractor)
			Insert columns only in the green area
Note: Offerors have the option of either using the offered formulae or direct inputing values for the indirect columns.
				YEAR 1
	Yearly	Base						Prime Ktr
Disciplines/Skill Levels	Salary	Rate	Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
Year 1 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0
			Insert columns only in the green area
				YEAR 2
		Base						Prime Ktr
Disciplines/Skill Levels		Rate	Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
ESCALATION
Year 2 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0
			Insert columns only in the green area
		Base		YEAR 3
Disciplines/Skill Levels		Rate						Prime Ktr
ESCALATION			Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
Year 3 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0
			Insert columns only in the green area
		Base		YEAR 4
Disciplines/Skill Levels		Rate						Prime Ktr
ESCALATION			Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
Year 4 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0
			Insert columns only in the green area
		Base		YEAR 5
Disciplines/Skill Levels		Rate						Prime Ktr
ESCALATION			Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
Year 5 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0

&CJTAC PROPOSAL WORK BOOK&RSolicitation No.: FA0021-12-R-0014 &CAttachment 6 Page &Pof &N ramirez:

Composite COM rate generated against total costs.

SmithJF:

Fully Burdened Labor Rate SmithJF:

Fully Burdened Labor Rate PetersoL:

Insert escalation rate to be applied to Year 1 Base Rate PetersoL:

Insert escalation rate to be applied to Year 2 Base Rate PetersoL:

Insert escalation rate to be applied to Year 3 Base Rate PetersoL:

Insert escalation rate to be applied to Year 4 Base Rate

5.0 Offeror Calculations - SUAS

Worksheet 5.0: Offeror Calculations SUAS
Calculates the Average/Maximum FBLR for the Prime (or Subcontractor)
			Insert columns only in the green area
Note: Offerors have the option of either using the offered formulae or direct inputing values for the indirect columns.
				YEAR 1
	Yearly	Base						Prime Ktr
Disciplines/Skill Levels	Salary	Rate	Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
Year 1 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0
			Insert columns only in the green area
				YEAR 2
		Base						Prime Ktr
Disciplines/Skill Levels		Rate	Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
ESCALATION
Year 2 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0
			Insert columns only in the green area
		Base		YEAR 3
Disciplines/Skill Levels		Rate						Prime Ktr
ESCALATION			Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
Year 3 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0
			Insert columns only in the green area
		Base		YEAR 4
Disciplines/Skill Levels		Rate						Prime Ktr
ESCALATION			Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
Year 4 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0
			Insert columns only in the green area
		Base		YEAR 5
Disciplines/Skill Levels		Rate						Prime Ktr
ESCALATION			Fringe	Overhead	G&A	C.O.M.	Profit	FBLR
Year 5 Proposed Indirect Rates
Labor Category
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
	$ - 0							$ - 0
							Total	$ - 0

&CSUAS PROPOSAL WORK BOOK&RSolicitation No.: FA0021-12-R-0014 &CAttachment 6 Page &Pof &N ramirez:

Composite COM rate generated against total costs.

SmithJF:

Fully Burdened Labor Rate PetersoL:

Insert escalation rate to be applied to Year 1 Base Rate PetersoL:

Insert escalation rate to be applied to Year 2 Base Rate SmithJF:

Fully Burdened Labor Rate PetersoL:

Insert escalation rate to be applied to Year 3 Base Rate SmithJF:

Fully Burdened Labor Rate PetersoL:

Insert escalation rate to be applied to Year 4 Base Rate SmithJF:

Fully Burdened Labor Rate

6.0 CLIN Totals

Worksheet 6.0: CLIN Totals
Calculates the Entire Proposed Cost for Solicitation FA0021-12-R-0014
CLIN Number	CLIN Description
Note: Offerors have the option of either using the offered formulae or direct inputing values into Column C.
CLIN 0001	Labor (JTAC)	$ - 0
CLIN 0002	Labor (SUAS)	$ - 0
CLIN 1001	Labor (JTAC)	$ - 0
CLIN 1002	Labor (SUAS)	$ - 0
CLIN 2001	Labor (JTAC)	$ - 0
CLIN 2002	Labor (SUAS)	$ - 0
CLIN 3001	Labor (JTAC)	$ - 0
CLIN 3002	Labor (SUAS)	$ - 0
CLIN 4001	Labor (JTAC)	$ - 0
CLIN 4002	Labor (SUAS)	$ - 0
	Total Proposed Cost	$ - 0

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