Att_L-7_Prime_CCS.xlsx

XLSX spreadsheet 90 KB Posted Aug 5, 2013

Attached to: Naval Strike and Air Warfare Center (NSAWC) Contractor Logistics Support (CLS) Services
Solicitation number: N00019-12-R-0007
Issued by: Department of the Navy Naval Air Systems Command

About this file

From the source

Att L-7 Prime CCS

View the file

Other files

File	Type	Posted
Question_and_Answer_Log_07_October_2013.xlsx	XLSX spreadsheet	Oct 7, 2013
Amendment_N00019-12-R-0007-0005_30_September_2013.pdf	PDF	Sep 30, 2013
Question_and_Answer_Log_30_September_2013.xlsx	XLSX spreadsheet	Sep 30, 2013
NSAWC_DIRECT_MAINTENANCE_MAN_HR_PER_FH_PER_TMS_2011-2012_30_September_2013.pdf	PDF	Sep 30, 2013
Question_and_Answer_Log_27_September_2013.xlsx	XLSX spreadsheet	Sep 27, 2013
Amendment_N00019-12-R-0007-0004_25_September_2013.pdf	PDF	Sep 25, 2013
Amendment_N00019-12-R-0007-0003_18_September_2013.pdf	PDF	Sep 18, 2013
Att_L-6_Price_Matrix_13_September_2013.xlsx	XLSX spreadsheet	Sep 18, 2013
Question_and_Answer_Log_18_September_2013.xlsx	XLSX spreadsheet	Sep 18, 2013
Amendment_N00019-12-R-0007-0002_13_September_2013.pdf	PDF	Sep 13, 2013
Question_and_Answer_Log_12_September_2013.xlsx	XLSX spreadsheet	Sep 12, 2013
Question_and_Answer_Log_09_September_2013.xlsx	XLSX spreadsheet	Sep 9, 2013
Question_and_Answer_Log_05_September_2013.xlsx	XLSX spreadsheet	Sep 5, 2013
Att_L-2_Vol_1_ES_Tables_29_August_2013.xlsx	XLSX spreadsheet	Sep 4, 2013
Exhibit_A_Contract_Data_Requirements_List_(CDRL) _DD_Form_1423_04_September_2013.pdf	PDF	Sep 4, 2013
Amendment_N00019-12-R-0007-0001_04_September_2013.pdf	PDF	Sep 4, 2013
Att_L-8_Sub_CCS_30_August_2013.xlsx	XLSX spreadsheet	Sep 4, 2013
Attachment_5_Government_Furnished_Property_List_(Part_1)_03_September_2013.xls	XLS spreadsheet	Sep 4, 2013
Att_L-7_Prime_CCS_29_August_2013.xlsx	XLSX spreadsheet	Sep 4, 2013
Attachment_6_Area_Wage_Determination_14_August_2013.pdf	PDF	Sep 4, 2013
Attachment_1_Naval_Strike_and_Air_Warfare_Center_Aircraft_Maintenance_Performance_Work_Statement_(PWS)_28_August_2013.pdf	PDF	Sep 4, 2013
Attachment_5_Government_Furnished_Property_List_(Part_2)_03_September_2013.xls	XLS spreadsheet	Sep 4, 2013
Attachment_5_Government_Furnished_Property_List_(Part_3)_03_September_2013.xlsx	XLSX spreadsheet	Sep 4, 2013
Att_L-6_Price_Matrix_29_August_2013.xlsx	XLSX spreadsheet	Sep 4, 2013
NSAWC_Technical_Library_Content_29_August_2013.docx	DOCX document	Aug 29, 2013
Question_and_Answer_Log_29_August_2013.xlsx	XLSX spreadsheet	Aug 29, 2013
Question_and_Answer_Log_21_August_2013.xlsx	XLSX spreadsheet	Aug 21, 2013
NSAWC_Technical_Library_Content_21_August_2013.docx	DOCX document	Aug 21, 2013
Attachment_1_Naval_Strike_and_Air_Warfare_Center_Aircraft_Maintenance_Performance_Work_Statement_(PWS)_25_July_2013.pdf	PDF	Aug 5, 2013
Att_L-9_Direct_Parts_Material_and_Travel.xlsx	XLSX spreadsheet	Aug 5, 2013
Attachment_4_Quality_Assurance_Surveillance_Plan_22_July_2013.pdf	PDF	Aug 5, 2013
Att_L-3_Vol_2_T-1_SB_Goals.xlsx	XLSX spreadsheet	Aug 5, 2013
Att_L-1_GenInst_3.2_CRM.xlsx	XLSX spreadsheet	Aug 5, 2013
Attachment_7_Predecessor_Contract_Collective_Bargaining_Agreement_(CBA)_18_June_2013.pdf	PDF	Aug 5, 2013
N00019-12-R-0007_05_August_2013.pdf	PDF	Aug 5, 2013
Att_L-5_Vol_3_PP-1_PP_Cont_Data.xlsx	XLSX spreadsheet	Aug 5, 2013
Att_L-6_Price_Matrix.xlsx	XLSX spreadsheet	Aug 5, 2013
Att_L-2_Vol_1_ES_Tables.xlsx	XLSX spreadsheet	Aug 5, 2013
Attachment_5_Government_Furnished_Property_List_(Part_1)_29_July_2013.xls	XLS spreadsheet	Aug 5, 2013
Att_L-4_Vol_3_PPQ.docx	DOCX document	Aug 5, 2013
Att_L-10_Manpower_Chart.xlsx	XLSX spreadsheet	Aug 5, 2013
Attachment_8_DD_Form_254_DOD_Contract_Security_Classification_Specification_20_November_2012.pdf	PDF	Aug 5, 2013
Att_L-8_Sub_CCS.xlsx	XLSX spreadsheet	Aug 5, 2013
Attachment_5_Government_Furnished_Property_List_(Part_2)_29_July_2013.xls	XLS spreadsheet	Aug 5, 2013
Exhibit_A_Contract_Data_Requirements_List_(CDRL) _DD_Form_1423_29_July_2013.PDF	PDF	Aug 5, 2013
Attachment_6_Area_Wage_Determination_18_June_2013.pdf	PDF	Aug 5, 2013
Attachment_5_Government_Furnished_Property_List_(Part_3)_29_July_2013.xlsx	XLSX spreadsheet	Aug 5, 2013
DRAFT_Attachment_5_Government_Furnished_Property_List_(Part_2).xls	XLS spreadsheet	Jul 18, 2013
DRAFT_Attachment_4_QASP_NSAWC_Aircraft_Maintenance_13_May_2013.pdf	PDF	Jul 18, 2013
OT-13-20041.pdf	PDF	Jul 18, 2013

Show 40 more

Latest 50 of 73 listed here. See the rest on GovTribe.

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.

FFP Examples & Instructions

FIRM FIXED PRICE

EXAMPLE and INSTRUCTIONS

Examples:

FPRA

HAZMAT

CBA

Shift Differential

AWD

Lead Position

Exempt

Etc.

Effective Work Year (Hours)

1,920

LABOR RATE

DIRECT LABOR

INDIRECT LABOR

Direct + Indirect Labor Cost

COM $$

Direct + Indirect + COM Cost

Other Direct Costs

Material

Subcontractor Cost $$

Subcontractor Handling Fee

Fixed Fee $$ (5% used for INSTRUCTIONS)

Total Sell Price/Rate

COST ELEMENTS

CLIN

SLIN

Work Center

Shift

Maintenance Level (Organizational (O), Intermediate (I), or Depot (D))

Labor Category Title

Company

Labor Rate Source (see above)

Head Count

Base Rate

Additions to Base Rate (see above)

Total Labor Rate

Direct Labor Hours Per Manyear

Available Direct Labor Hours Per Manyear

Direct Labor Cost

Overhead $$

Fringe Benefit $$

G & A $$

Etc.

Indirect Labor Cost

CELL RESULT B C D F G H I J K L M N = L+M O P = K*O Q = N * P R S T U V = R + S + T + U W = Q + V X Y = W + X Z AA AB AC AD = Fixed Fee % * (Y + AB) AE = Y + AB + AD

	Prime Contractor Labor Cost
	Prime Contractor Direct Labor
REFERENCE
	0001 - NSAWC O&I Maintenance
		0001AA - O&I Maintenance Low Range
			Squadron 1
			Shop 1
			Inspection Manager	1	O	Manager	Prime Contractor X	FPRA	0.5	$ 36.95	$ - 0	$ 36.95	1,936	968.0	$ 35,767.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 35,773.60	$ 1.00	$ 35,774.60	$ 1,788.73	$ 37,563.33
			Washer	1	O	Aircraft Washer	Prime Contractor X	CBA	3.0	$ 20.99	$ 0.45	$ 21.44	1,920	5,760.0	$ 123,494.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 123,500.40	$ 1.00	$ 123,501.40	$ 6,175.07	$ 129,676.47
Note B			Schedule Maintenance Mechanic I	2	O	Mechanic I, Lead	Prime Contractor X	CBA	1.0	$ 25.62	$ 1.50	$ 27.12	1,920	1,920.0	$ 52,070.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 52,076.40	$ 1.00	$ 52,077.40	$ 2,603.87	$ 54,681.27
Note B			Schedule Maintenance Mechanic I	2	O	Mechanic I	Prime Contractor X	CBA	4.0	$ 25.62	$ 0.85	$ 26.47	1,920	7,680.0	$ 203,289.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 203,295.60	$ 1.00	$ 203,296.60	$ 10,164.83	$ 213,461.43
			Avionics Technician III	1	I	Avionics Tech III	Prime Contractor X	CBA	2.0	$ 31.28	$ - 0	$ 31.28	1,936	3,872.0	$ 121,116.16	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 121,122.16	$ 1.00	$ 121,123.16	$ 6,056.16	$ 127,179.32
			Avionics Technician II	1	I	Avionics Tech II, Lead	Prime Contractor X	CBA	3.0	$ 27.56	$ 1.50	$ 29.06	1,920	5,760.0	$ 167,385.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 167,391.60	$ 1.00	$ 167,392.60	$ 8,369.63	$ 175,762.23
			Avionics Technician II	2	I	Avionics Tech II	Prime Contractor X	CBA	4.0	$ 27.56	$ 0.45	$ 28.01	1,920	7,680.0	$ 215,116.80	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 215,122.80	$ 1.00	$ 215,123.80	$ 10,756.19	$ 225,879.99
			Aircraft Logs & Records Clerk	2	I	Logs & Records Clerk	Prime Contractor X	CBA	1.0	$ 25.62	$ 0.45	$ 26.07	1,920	1,920.0	$ 50,054.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 50,060.40	$ 1.00	$ 50,061.40	$ 2,503.07	$ 52,564.47
			Avionics Technician III	1	D	Avionics Tech III	Prime Contractor X	CBA	2.0	$ 31.28	$ - 0	$ 31.28	1,936	3,872.0	$ 121,116.16	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 121,122.16	$ 1.00	$ 121,123.16	$ 6,056.16	$ 127,179.32
			Avionics Technician II	1	D	Avionics Tech II, Lead	Prime Contractor X	CBA	3.0	$ 27.56	$ 1.50	$ 29.06	1,920	5,760.0	$ 167,385.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 167,391.60	$ 1.00	$ 167,392.60	$ 8,369.63	$ 175,762.23
			Avionics Technician II	2	D	Avionics Tech II	Prime Contractor X	CBA	4.0	$ 27.56	$ 0.45	$ 28.01	1,920	7,680.0	$ 215,116.80	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 215,122.80	$ 1.00	$ 215,123.80	$ 10,756.19	$ 225,879.99
			Aircraft Logs & Records Clerk	2	D	Logs & Records Clerk	Prime Contractor X	CBA	1.0	$ 25.62	$ 0.45	$ 26.07	1,920	1,920.0	$ 50,054.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 50,060.40	$ 1.00	$ 50,061.40	$ 2,503.07	$ 52,564.47

Note C		Etc.												$ - 0					$ - 0	$ - 0							$ - 0	$ - 0
Note D/E		SLIN TOTAL						28.5					54792.0	$ 1,521,967.92	$ 12.00	$ 24.00	$ 36.00	$ - 0	$ 72.00	$ 1,522,039.92	$ 12.00	$ 1,522,051.92	$ - 0	$ - 0	$ - 0	$ - 0	$ 76,102.60	$ 1,598,154.52
	0001AB - O&I Maintenance Normal Range
		Squadron 1
		shop 1
		Inspection Manager	1	O	Manager	Prime Contractor X	FPRA	0.5	$ 36.95	$ - 0	$ 36.95	1,936	968.0	$ 35,767.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 35,773.60	$ 1.00	$ 35,774.60					$ 1,788.73	$ 37,563.33
		Washer	1	O	Aircraft Washer	Prime Contractor X	CBA	3.0	$ 20.99	$ 0.45	$ 21.44	1,920	5,760.0	$ 123,494.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 123,500.40	$ 1.00	$ 123,501.40					$ 6,175.07	$ 129,676.47
Note B		Schedule Maintenance Mechanic I	2	O	Mechanic I, Lead	Prime Contractor X	CBA	1.0	$ 25.62	$ 1.50	$ 27.12	1,920	1,920.0	$ 52,070.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 52,076.40	$ 1.00	$ 52,077.40					$ 2,603.87	$ 54,681.27
Note B		Schedule Maintenance Mechanic I	2	O	Mechanic I	Prime Contractor X	CBA	4.0	$ 25.62	$ 0.85	$ 26.47	1,920	7,680.0	$ 203,289.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 203,295.60	$ 1.00	$ 203,296.60					$ 10,164.83	$ 213,461.43
		Avionics Technician III	1	I	Avionics Tech III	Prime Contractor X	CBA	2.0	$ 31.28	$ - 0	$ 31.28	1,936	3,872.0	$ 121,116.16	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 121,122.16	$ 1.00	$ 121,123.16					$ 6,056.16	$ 127,179.32
		Avionics Technician II	1	I	Avionics Tech II, Lead	Prime Contractor X	CBA	3.0	$ 27.56	$ 1.50	$ 29.06	1,920	5,760.0	$ 167,385.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 167,391.60	$ 1.00	$ 167,392.60					$ 8,369.63	$ 175,762.23
		Avionics Technician II	2	I	Avionics Tech II	Prime Contractor X	CBA	4.0	$ 27.56	$ 0.45	$ 28.01	1,920	7,680.0	$ 215,116.80	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 215,122.80	$ 1.00	$ 215,123.80					$ 10,756.19	$ 225,879.99
		Aircraft Logs & Records Clerk	2	I	Logs & Records Clerk	Prime Contractor X	CBA	1.0	$ 25.62	$ 0.45	$ 26.07	1,920	1,920.0	$ 50,054.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 50,060.40	$ 1.00	$ 50,061.40					$ 2,503.07	$ 52,564.47
		Avionics Technician III	1	D	Avionics Tech III	Prime Contractor X	CBA	2.0	$ 31.28	$ - 0	$ 31.28	1,936	3,872.0	$ 121,116.16	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 121,122.16	$ 1.00	$ 121,123.16					$ 6,056.16	$ 127,179.32
		Avionics Technician II	1	D	Avionics Tech II, Lead	Prime Contractor X	CBA	3.0	$ 27.56	$ 1.50	$ 29.06	1,920	5,760.0	$ 167,385.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 167,391.60	$ 1.00	$ 167,392.60					$ 8,369.63	$ 175,762.23
		Avionics Technician II	2	D	Avionics Tech II	Prime Contractor X	CBA	4.0	$ 27.56	$ 0.45	$ 28.01	1,920	7,680.0	$ 215,116.80	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 215,122.80	$ 1.00	$ 215,123.80					$ 10,756.19	$ 225,879.99
		Aircraft Logs & Records Clerk	2	D	Logs & Records Clerk	Prime Contractor X	CBA	1.0	$ 25.62	$ 0.45	$ 26.07	1,920	1,920.0	$ 50,054.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 50,060.40	$ 1.00	$ 50,061.40					$ 2,503.07	$ 52,564.47

Note C		Etc.												$ - 0					$ - 0	$ - 0							$ - 0	$ - 0
Note D/E		SLIN TOTAL						28.5					54792.0	$ 1,521,967.92	$ 12.00	$ 24.00	$ 36.00	$ - 0	$ 72.00	$ 1,522,039.92	$ 12.00	$ 1,522,051.92	$ - 0	$ - 0	$ - 0	$ - 0	$ 76,102.60	$ 1,598,154.52
	0001AC - O&I Maintenance Surge Range
		Squadron 1
		Shop 1
		Inspection Manager	1	O	Manager	Prime Contractor X	FPRA	0.5	$ 36.95	$ - 0	$ 36.95	1,936	968.0	$ 35,767.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 35,773.60	$ 1.00	$ 35,774.60					$ 1,788.73	$ 37,563.33
		Washer	1	O	Aircraft Washer	Prime Contractor X	CBA	3.0	$ 20.99	$ 0.45	$ 21.44	1,920	5,760.0	$ 123,494.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 123,500.40	$ 1.00	$ 123,501.40					$ 6,175.07	$ 129,676.47
Note B		Schedule Maintenance Mechanic I	2	O	Mechanic I, Lead	Prime Contractor X	CBA	1.0	$ 25.62	$ 1.50	$ 27.12	1,920	1,920.0	$ 52,070.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 52,076.40	$ 1.00	$ 52,077.40					$ 2,603.87	$ 54,681.27
Note B		Schedule Maintenance Mechanic I	2	O	Mechanic I	Prime Contractor X	CBA	4.0	$ 25.62	$ 0.85	$ 26.47	1,920	7,680.0	$ 203,289.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 203,295.60	$ 1.00	$ 203,296.60					$ 10,164.83	$ 213,461.43
		Avionics Technician III	1	I	Avionics Tech III	Prime Contractor X	CBA	2.0	$ 31.28	$ - 0	$ 31.28	1,936	3,872.0	$ 121,116.16	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 121,122.16	$ 1.00	$ 121,123.16					$ 6,056.16	$ 127,179.32
		Avionics Technician II	1	I	Avionics Tech II, Lead	Prime Contractor X	CBA	3.0	$ 27.56	$ 1.50	$ 29.06	1,920	5,760.0	$ 167,385.60	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 167,391.60	$ 1.00	$ 167,392.60					$ 8,369.63	$ 175,762.23
		Avionics Technician II	2	I	Avionics Tech II	Prime Contractor X	CBA	4.0	$ 27.56	$ 0.45	$ 28.01	1,920	7,680.0	$ 215,116.80	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 215,122.80	$ 1.00	$ 215,123.80					$ 10,756.19	$ 225,879.99
		Aircraft Logs & Records Clerk	2	I	Logs & Records Clerk	Prime Contractor X	CBA	1.0	$ 25.62	$ 0.45	$ 26.07	1,920	1,920.0	$ 50,054.40	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 50,060.40	$ 1.00	$ 50,061.40					$ 2,503.07	$ 52,564.47

Note C	Etc.			$ - 0					$ - 0	$ - 0							$ - 0	$ - 0
Note D/E	SLIN TOTAL	18.5	35560.0	$ 968,294.96	$ 8.00	$ 16.00	$ 24.00	$ - 0	$ 48.00	$ 968,342.96	$ 8.00	$ 968,350.96	$ - 0	$ - 0	$ - 0	$ - 0	$ 48,417.55	$ 1,016,768.51

Note D CLIN TOTAL 75.5 145144.0 $ 4,012,230.80 $ 32.00 $ 64.00 $ 96.00 $ - 0 $ 192.00 $ 4,012,422.80 $ 32.00 $ 4,012,454.80 $ - 0 $ - 0 $ - 0 $ - 0 $ 200,622.74 $ 4,213,077.54

Additional Instructions:
- The data inputs in this spreadsheet are shown for demonstration purposes ONLY.
- FFP CLINs: 0X01, 0X02 and 0X06
- Gray shading indicates cells where no data or formulae are expected.
- Include information to the lowest level appropriate for each CLIN (i.e. CLIN level, SLIN level).
- Total number of Available Direct Labor Hours Per Manyear must match the value stated in the Manning Attachment
Note B: Insert rows as necessary to accommodate all labor categories that fall under the specified Work Center. For calculation of Total Labor Rate, if personnel within the same labor category
have different additions to their respective Base Rate, the Offeror shall list personnel with identical labor categories/additions on separate rows for evaluation purposes. (SEE EXAMPLE BELOW)
EXAMPLE	Labor Category Title	Base Rate	Additions To Base Rate	Total Labor Rate
	Mechanic I, Lead	$ 25.62	$ 1.50	$ 27.12
	Mechanic I	$ 25.62	$ 0.85	$ 26.47
	Mechanic I	$ 25.62	$ 0.45	$ 26.07
Note C: Insert rows as necessary to accommodate all Work Centers that fall under the specified CLIN/SLIN.
- The "Labor Category Title" column should reflect the labor category title associated with the Labor Rate Source.
- The "Company" column should reflect the name of the company, union, etc. to which the labor rate is associated.
- The "Labor Rate Source" column should reflect the source of the labor rate (e.g. CBA, AWD, FPRA, etc.)
- The "Additions To Base Rate" is the sum of all differentials (e.g. Workshift Differential/Premium, Lead, HAZMAT, other Special Pay, etc.)
Note D (green highlight): The "Total Sell Price" for each CLIN/SLIN should match the proposed price submitted in Section B. Any deltas need to be explained and justified.
Note E (yellow highlight): Labor Categories that are Subcontracted should be included in Attachment L-8. The "Total Sell Price" for the Subcontracted labor should match inputs in
the "Subcontractor Cost $" column.
- Indirect Labor categories shall include at a minimum Overhead, Fringe Benefits and G&A. Additional columns can be added to include additional Indirect categories at the discretion
of the Offeror. All Indirect Labor costs shall be accounted for within the Overhead, Fringe Benefits, G&A, and Etc. categories. Indirect Labor costs shall be included at the Total CLIN/SLIN
level; however, it is at the discretion of the Offeror to include Indirect costs at a more detailed level (e.g. labor category).

ROLL-UP TABS
	Additional Instructions:
	- Gray shading indicates cells where no data or formulae are expected.
	- The ROLL-UP TABS shall include Total Head Count, Total Available Direct Labor Hours Per Manyear, and the Sell Price/Rate by CLIN/SLIN.
	The Total Head Count, Total Available Direct Labor Hours Per Manyear, and the Sell Price/Rate shall match the Total Head Count, Total Available
	Direct Labor Hours Per Manyear, and the Sell Price/Rate that is shown on the appropriate OPTION TAB within this workbook. Additionally,
	the Sell Price/Rate shall match the proposed Price/Rate submitted in Price Exhibit B.

&16L-7 Prime Contractor Cost Summary (CCS) &"Calibri,Bold"&14N00019-12-R-0007

&12&A, Pg. &P

FFP PRICE ROLL-UP

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE LABOR & SUPPORT

Prime Offeror Name:

DCAA Point of Contact Information:

Effective Work Year (Hours):

Fixed Price Roll-Up

Total for Option Base

Total for Option 1

Total for Option 2

Total for Option 3

Total for Option 4

Cost Elements

Head Count

Available Direct Labor Hours Per Manyear

Price

Head Count

Available Direct Labor Hours Per Manyear

Price

Head Count

Available Direct Labor Hours Per Manyear

Price

Head Count

Available Direct Labor Hours Per Manyear

Price

Head Count

Available Direct Labor Hours Per Manyear

Price

Prime Contractor Labor Cost

Prime Contractor Direct Labor

CLIN XXXA -

SLIN XXXXA -

SLIN XXXXB -

CLIN XXXB -

CLIN XXXC -

&16L-7 Prime Contractor Cost Summary (CCS) &"Calibri,Bold"&14N00019-12-R-0007

FFP BASE YEAR

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE LABOR & SUPPORT

Prime Offeror Name:

DCAA Point of Contact Information:

Base Period

Effective Work Year (Hours)

LABOR RATE

DIRECT LABOR

INDIRECT LABOR

Direct + Indirect Labor Cost

COM $$

Direct + Indirect + COM Cost

Other Direct Costs

Material

Subcontractor Cost $$

Subcontractor Handling Fee

Fixed Fee $$

Total Sell Price

COST ELEMENTS

CLIN

SLIN

Work Center

Shift

Maintenance Level (Organizational (O), Intermediate (I), or Depot (D))

Labor Category Title

Company

Labor Rate Source (see above)

Head Count

Base Rate

Additions to Base Rate (see above)

Total Labor Rate

Direct Labor Hours Per Manyear

Available Direct Labor Hours Per Manyear

Direct Labor Cost

Overhead $$

Fringe Benefit $$

G & A $$

Etc.

Indirect Labor Cost

Prime Contractor Labor Cost

Prime Contractor Direct Labor

XXXA
	XXXX
		Labor Category for each individual position
		Labor Category for each individual position
		Etc.
		SLIN TOTAL

XXXX
	Labor Category for each individual position
	Labor Category for each individual position
	Etc.
	SLIN TOTAL

	CLIN TOTAL
XXXB
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

	CLIN TOTAL
XXXC
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

CLIN TOTAL

&16L-7 Prime Contractor Cost Summary (CCS) &"Calibri,Bold"&14N00019-12-R-0007

FFP OPTION YEAR 1

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE LABOR & SUPPORT

Prime Offeror Name:

DCAA Point of Contact Information:

OPTION Period 1

Effective Work Year (Hours)

LABOR RATE

DIRECT LABOR

INDIRECT LABOR

Direct + Indirect Labor Cost

COM $$

Direct + Indirect + COM Cost

Other Direct Costs

Material

Subcontractor Cost $$

Subcontractor Handling Fee

Fixed Fee $$

Total Sell Price

COST ELEMENTS

CLIN

SLIN

Work Center

Shift

Maintenance Level (Organizational (O), Intermediate (I), or Depot (D))

Labor Category Title

Company

Labor Rate Source (see above)

Head Count

Base Rate

Additions to Base Rate (see above)

Total Labor Rate

Direct Labor Hours Per Manyear

Available Direct Labor Hours Per Manyear

Direct Labor Cost

Overhead $$

Fringe Benefit $$

G & A $$

Etc.

Indirect Labor Cost

Prime Contractor Labor Cost

Prime Contractor Direct Labor

XXXA
	XXXX
		Labor Category for each individual position
		Labor Category for each individual position
		Etc.
		SLIN TOTAL

XXXX
	Labor Category for each individual position
	Labor Category for each individual position
	Etc.
	SLIN TOTAL

	CLIN TOTAL
XXXB
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

	CLIN TOTAL
XXXC
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

CLIN TOTAL

&16L-7 Prime Contractor Cost Summary (CCS) &"Calibri,Bold"&14N00019-12-R-0007

FFP OPTION YEAR 2

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE LABOR & SUPPORT

Prime Offeror Name:

DCAA Point of Contact Information:

OPTION Period 2

Effective Work Year (Hours)

LABOR RATE

DIRECT LABOR

INDIRECT LABOR

Direct + Indirect Labor Cost

COM $$

Direct + Indirect + COM Cost

Other Direct Costs

Material

Subcontractor Cost $$

Subcontractor Handling Fee

Fixed Fee $$

Total Sell Price

COST ELEMENTS

CLIN

SLIN

Work Center

Shift

Maintenance Level (Organizational (O), Intermediate (I), or Depot (D))

Labor Category Title

Company

Labor Rate Source (see above)

Head Count

Base Rate

Additions to Base Rate (see above)

Total Labor Rate

Direct Labor Hours Per Manyear

Available Direct Labor Hours Per Manyear

Direct Labor Cost

Overhead $$

Fringe Benefit $$

G & A $$

Etc.

Indirect Labor Cost

Prime Contractor Labor Cost

Prime Contractor Direct Labor

XXXA
	XXXX
		Labor Category for each individual position
		Labor Category for each individual position
		Etc.
		SLIN TOTAL

XXXX
	Labor Category for each individual position
	Labor Category for each individual position
	Etc.
	SLIN TOTAL

	CLIN TOTAL
XXXB
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

	CLIN TOTAL
XXXC
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

CLIN TOTAL

&16L-7 Prime Contractor Cost Summary (CCS) &"Calibri,Bold"&14N00019-12-R-0007

FFP OPTION YEAR 3

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE LABOR & SUPPORT

Prime Offeror Name:

DCAA Point of Contact Information:

OPTION Period 3

Effective Work Year (Hours)

LABOR RATE

DIRECT LABOR

INDIRECT LABOR

Direct + Indirect Labor Cost

COM $$

Direct + Indirect + COM Cost

Other Direct Costs

Material

Subcontractor Cost $$

Subcontractor Handling Fee

Fixed Fee $$

Total Sell Price

COST ELEMENTS

CLIN

SLIN

Work Center

Shift

Maintenance Level (Organizational (O), Intermediate (I), or Depot (D))

Labor Category Title

Company

Labor Rate Source (see above)

Head Count

Base Rate

Additions to Base Rate (see above)

Total Labor Rate

Direct Labor Hours Per Manyear

Available Direct Labor Hours Per Manyear

Direct Labor Cost

Overhead $$

Fringe Benefit $$

G & A $$

Etc.

Indirect Labor Cost

Prime Contractor Labor Cost

Prime Contractor Direct Labor

XXXA
	XXXX
		Labor Category for each individual position
		Labor Category for each individual position
		Etc.
		SLIN TOTAL

XXXX
	Labor Category for each individual position
	Labor Category for each individual position
	Etc.
	SLIN TOTAL

	CLIN TOTAL
XXXB
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

	CLIN TOTAL
XXXC
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

CLIN TOTAL

&16L-7 Prime Contractor Cost Summary (CCS) &"Calibri,Bold"&14N00019-12-R-0007

FFP OPTION YEAR 4

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE LABOR & SUPPORT

Prime Offeror Name:

DCAA Point of Contact Information:

OPTION Period 4

Effective Work Year (Hours)

LABOR RATE

DIRECT LABOR

INDIRECT LABOR

Direct + Indirect Labor Cost

COM $$

Direct + Indirect + COM Cost

Other Direct Costs

Material

Subcontractor Cost $$

Subcontractor Handling Fee

Fixed Fee $$

Total Sell Price

COST ELEMENTS

CLIN

SLIN

Work Center

Shift

Maintenance Level (Organizational (O), Intermediate (I), or Depot (D))

Labor Category Title

Company

Labor Rate Source (see above)

Head Count

Base Rate

Additions to Base Rate (see above)

Total Labor Rate

Direct Labor Hours Per Manyear

Available Direct Labor Hours Per Manyear

Direct Labor Cost

Overhead $$

Fringe Benefit $$

G & A $$

Etc.

Indirect Labor Cost

Prime Contractor Labor Cost

Prime Contractor Direct Labor

XXXA
	XXXX
		Labor Category for each individual position
		Labor Category for each individual position
		Etc.
		SLIN TOTAL

XXXX
	Labor Category for each individual position
	Labor Category for each individual position
	Etc.
	SLIN TOTAL

	CLIN TOTAL
XXXB
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

	CLIN TOTAL
XXXC
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

CLIN TOTAL

&16L-7 Prime Contractor Cost Summary (CCS) &"Calibri,Bold"&14N00019-12-R-0007

FFP - Transition Period

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE LABOR & SUPPORT

Prime Offeror Name:

DCAA Point of Contact Information:

OPTION Transition Period

Effective Work Year (Hours)

LABOR RATE

DIRECT LABOR

INDIRECT LABOR

Direct + Indirect Labor Cost

COM $$

Direct + Indirect + COM Cost

Other Direct Costs

Material

Subcontractor Cost $$

Subcontractor Handling Fee

Fixed Fee $$

Total Sell Price

COST ELEMENTS

CLIN

SLIN

Work Center

Shift

Maintenance Level (Organizational (O), Intermediate (I), or Depot (D))

Labor Category Title

Company

Labor Rate Source (see above)

Head Count

Base Rate

Additions to Base Rate (see above)

Total Labor Rate

Direct Labor Hours Per Manyear

Available Direct Labor Hours Per Manyear

Direct Labor Cost

Overhead $$

Fringe Benefit $$

G & A $$

Etc.

Indirect Labor Cost

Prime Contractor Labor Cost

Prime Contractor Direct Labor

XXXA
	XXXX
		Labor Category for each individual position
		Labor Category for each individual position
		Etc.
		SLIN TOTAL

XXXX
	Labor Category for each individual position
	Labor Category for each individual position
	Etc.
	SLIN TOTAL

	CLIN TOTAL
XXXB
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

	CLIN TOTAL
XXXC
	XXXX

Labor Category for each individual position

Etc.

SLIN TOTAL

CLIN TOTAL

&16L-7 Prime Contractor Cost Summary (CCS) &"Calibri,Bold"&14N00019-12-R-0007

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