Att_L-7_Prime_CCS_130820.xlsx

XLSX spreadsheet 92 KB Posted Sep 16, 2013

Attached to: Adversary F-5 F/N Contractor Logistics Support (CLS) Services- N00019-13-R-0092 formally known as N00019-12-R-0008
Solicitation number: N00019-13-R-0092
Issued by: Department of the Navy Naval Air Systems Command

About this file

From the source

Attachment L-7

View the file

Other files

File	Type	Posted
Amendment_0005.pdf	PDF	Nov 22, 2013
Selected_Q A's_Posted_FBO_11-22-13.xlsx	XLSX spreadsheet	Nov 22, 2013
OT-13-20045.pdf	PDF	Nov 15, 2013
Selected_Q A's_Posted_FBO_11-15-13.xlsx	XLSX spreadsheet	Nov 15, 2013
OT_DID_Final_WIS_Archival_Data_F-5.pdf	PDF	Nov 15, 2013
OT-13-20042.pdf	PDF	Nov 15, 2013
OT-13-XXXXX_draft_Materials_Utilization_and_Forecasting_Report_F-5_CLS.pdf	PDF	Nov 15, 2013
OT_DID_Final_Monthly_Maintenance_Plan_F-5.pdf	PDF	Nov 15, 2013
OT_DID_Final_Phase_Out_Transition_Plan_F-5_rev_1.pdf	PDF	Nov 15, 2013
Att_L-9_Parts_Material_Travel_O A_131101.xlsx	XLSX spreadsheet	Nov 8, 2013
Selected_Q A's_Posted_FBO_11-08-13.xlsx	XLSX spreadsheet	Nov 8, 2013
Att_L-7_Prime_CCS_131104.xlsx	XLSX spreadsheet	Nov 8, 2013
F-5_ADVERSARY_PWS_131107.pdf	PDF	Nov 8, 2013
Att_L-6_Price_Matrix_131104.xlsx	XLSX spreadsheet	Nov 8, 2013
Amend_0004.pdf	PDF	Nov 8, 2013
CAC_Procedures.pdf	PDF	Nov 8, 2013
Amendment_0003.pdf	PDF	Nov 6, 2013
Selected_Q A's_Posted_FBO_11-05-13.xlsx	XLSX spreadsheet	Nov 5, 2013
List_of_F5_Tech_Library_Supplemental_Info_Oct_22_13.pdf	PDF	Oct 22, 2013
Selected_Q A's_Posted_FBO_10-22-13.xlsx	XLSX spreadsheet	Oct 22, 2013
Att_L-8_Sub_CCS_131010.xlsx	XLSX spreadsheet	Oct 15, 2013
Amendment_0002_10-15-13.pdf	PDF	Oct 15, 2013
Selected_Q A's_Posted_FBO_9-30-13.xlsx	XLSX spreadsheet	Sep 30, 2013
TPL_Listing.pdf	PDF	Sep 24, 2013
Att_L-8_Sub_CCS_130918.xlsx	XLSX spreadsheet	Sep 24, 2013
Amendment_0001_09-24-13.pdf	PDF	Sep 24, 2013
Att_L-9_Parts_Material_Travel_O A_130919.xlsx	XLSX spreadsheet	Sep 24, 2013
Att_L-7_Prime_CCS_130918.xlsx	XLSX spreadsheet	Sep 24, 2013
F-5_Draft_RFP_Q A's.xlsx	XLSX spreadsheet	Sep 18, 2013
Attachment_4A_FALLON_A004_2012.xlsx	XLSX spreadsheet	Sep 16, 2013
Attachment_5A_Fallon _NV_AWD_2005-2334.pdf	PDF	Sep 16, 2013
F-5_ADVERSARY__Draft_PWS_130821.docx	DOCX document	Sep 16, 2013
Attachment_10B_Yuma _AZ_CBA.pdf	PDF	Sep 16, 2013
Att_L-8_Sub_CCS_130820.xlsx	XLSX spreadsheet	Sep 16, 2013
Attachment_4C_KEY_WEST__A004_2012.xlsx	XLSX spreadsheet	Sep 16, 2013
Att_L-2_Vol_1_ES_Tables_Rev1.xlsx	XLSX spreadsheet	Sep 16, 2013
Attachment_8_F5_QASP_Final_130402.docx	DOCX document	Sep 16, 2013
Att_L-1_GenInst_3.2_CRM.xlsx	XLSX spreadsheet	Sep 16, 2013
Attachment_5B_Yuma _AZ_AWD_2005-2028.pdf	PDF	Sep 16, 2013
Att_L-10_Manpower_Chart.xlsx	XLSX spreadsheet	Sep 16, 2013
Att_L-6_Price_Matrix_130913.xlsx	XLSX spreadsheet	Sep 16, 2013
Attachment_5C_Key_West _FL_AWD_2005-2120.pdf	PDF	Sep 16, 2013
Att_L-4_Vol_3_PPQ_20130419.docx	DOCX document	Sep 16, 2013
Attachment_10A_Fallon _NV_CBA.pdf	PDF	Sep 16, 2013
Attachment_4B_YUMA_A004__2012.xlsx	XLSX spreadsheet	Sep 16, 2013
Att_L-5_Vol_3_PP-1_PP_Cont_Data.xlsx	XLSX spreadsheet	Sep 16, 2013
Att_L-3_Vol_2_T-1_SB_Goals.xlsx	XLSX spreadsheet	Sep 16, 2013
F-5_CDRL's_8-23-13.pdf	PDF	Sep 16, 2013
Att_L-9_Direct_Parts_Material_and_Travel.xlsx	XLSX spreadsheet	Sep 16, 2013
F-5_Final_RFP.doc	DOC document	Sep 16, 2013

Show 40 more

Latest 50 of 57 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.

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 - F-5 Fallon 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
			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
			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

	Etc.												$ - 0					$ - 0	$ - 0							$ - 0	$ - 0
	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
	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
	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

	Etc.												$ - 0					$ - 0	$ - 0							$ - 0	$ - 0
	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
	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
	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

Etc.			$ - 0					$ - 0	$ - 0							$ - 0	$ - 0
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

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: XX01 - XX05
- 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 A: 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 B: 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 C (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 D (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).

Cost Plus

EXAMPLE

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
	0006 - Fallon Limited Depot Maintenance (O&A)
		Maintenance Supervisor (Labor Only)
			Work Center XXX
			Maintenance Mechanic I	2	O	Mechanic I	Union	CBA	2.0	$ 25.62	$ 0.85	$ 26.47	1,920	3,840.0	$ 101,644.80	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 101,650.80	$ 1.00	$ 101,651.80					$ 5,082.59	$ 106,734.39
			Etc.		O
			SLIN TOTAL											3,840.0	$ 101,644.80	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 101,650.80	$ 1.00	$ 101,651.80	$ - 0	$ - 0	$ - 0	$ - 0	$ 5,082.59	$ 106,734.39
			SLIN FIXED RATE																										$ 27.80
		Aircraft Mechnic (Labor Only)
			NAMP Work Center XXX
			Maintenance Mechanic I	2	I	Mechanic I	Union	CBA	2.0	$ 25.62	$ 0.85	$ 26.47	1,920	3,840.0	$ 101,644.80	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 101,650.80	$ 1.00	$ 101,651.80					$ 5,082.59	$ 106,734.39
			Etc.		O
			SLIN TOTAL											3,840.0	101,644.8	1.0	2.0	3.0	0.0	6.0	101,650.8	1.0	101,651.8	0.0	0.0	0.0	0.0	5,082.6	106,734.4
			SLIN FIXED RATE																										$ 27.80
		QA Inspector (Labor Only)
			Work Center XXX
			Maintenance Mechanic I	2	I	Mechanic I	Union	CBA	2.0	$ 25.62	$ 0.85	$ 26.47	1,920	3,840.0	$ 101,644.80	$ 1.00	$ 2.00	$ 3.00	$ - 0	$ 6.00	$ 101,650.80	$ 1.00	$ 101,651.80					$ 5,082.59	$ 106,734.39
			Etc.		O

	CLIN TOTAL		3,840.0	101,644.8	1.0	2.0	3.0	0.0	6.0	101,650.8	1.0	101,651.8	0.0	0.0	0.0	0.0	5,082.6	106,734.4
	CLIN FIXED RATE																	$ 27.80
CLIN TOTAL		6.0

Additional Instructions:
- The data inputs in this spreadsheet are shown for demonstration purposes ONLY.
- CPFF CLINS: XX06, XX07, and XX08
- 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 Head Count must match the value stated in 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 F (green highlight): The "Total Sell Rate" 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-11. 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-13-R-0092

&12&A, Pg. &P

FFP- CP PRICE ROLL-UP

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE/COST 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

XX01

FFP

Fallon O&I Maintenance

XX01AA

Maintenance Low Range

XX01AB

Maintenance Low Range

XX01AC

Maintenance Surge Range

XX02	FFP	Yuma O&I Maintenance
XX02AA		Maintenance Low Range
XX02AB		Maintenance Low Range
XX02AC		Maintenance Surge Range

XX03	FFP	Key West O&I Maintenance
XX03AA		Maintenance Low Range
XX03AB		Maintenance Low Range
XX03AC		Maintenance Surge Range

XX04 FFP Fallon Aircraft Painting

XX05 FFP Key West Aircraft Painting

XX06 CPFF Fallon Limited Depot Maintenance (O&A)

XX07 CPFF Yuma Limited Depot Maintenance (O&A)

XX08 CPFF Key West Limited Depot Maintenance (O&A)

XX12 FFP Transition Phase-Out

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

FFP-CP BASE YEAR

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE/COST PLUS 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-13-R-0092

FFP -CP OPTION YEAR 1

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE/COST PLUS 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-13-R-0092

FFP -CP OPTION YEAR 2

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE/COST PLUS 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-13-R-0092

FFP -CP OPTION YEAR 3

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE/COST PLUS 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-13-R-0092

FFP - CP OPTION YEAR 4

PRIME CONTRACTOR COST SUMMARY FORMAT

FIRM FIXED PRICE/COST PLUS 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-13-R-0092

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