J-5_Cost_Summary_07.24.2019.A0004.xls

XLS spreadsheet 537 KB Posted Jul 24, 2019

Attached to: P-3 Aircraft Maintenance and Logistics Support Services
Solicitation number: 70B02C19R00000013
Issued by: Department of Homeland Security Customs and Border Protection

About this file

From the source

J-5

View the file

Other files

File	Type	Posted
70B02C19R00000013-A0004_SF+L_Section.07.24.2019.V5.1.pdf	PDF	Jul 24, 2019
J-14_Government_Furnished_Equipment_(GFE)_07.24.2019.A0004.pdf	PDF	Jul 24, 2019
J-7_MPA_PWS_FINAL_06242019_A0003.pdf	PDF	Jun 24, 2019
70B02C19R00000013-A0003_SF.pdf	PDF	Jun 24, 2019
Foreign_National_Visitor_Form.doc	DOC document	Jun 17, 2019
RFP_A0002_06172019_CBP_P-3_RFP_Questions_and_Answers.pdf	PDF	Jun 17, 2019
J-7_Appendices__CDRLs_FINAL_05302019_.pdf	PDF	Jun 17, 2019
70B02C19R00000013-A0002_SF+RFP.06.17.2019.pdf	PDF	Jun 17, 2019
J-7_MPA_PWS_FINAL_06122019.pdf	PDF	Jun 17, 2019
J-19_Tank_5A.docx	DOCX document	Jun 6, 2019
J-12_Notational__Inspection__Document_.xlsx	XLSX spreadsheet	Jun 6, 2019
J-14_Government_Furnished_Equipment_(GFE)_A0001_05302019.pdf	PDF	Jun 6, 2019
J-7_MPA_PWS_FINAL_06062019.docx	DOCX document	Jun 6, 2019
RFP_A0001_06062019_CBP_P-3_RFP_Questions_and_Answers_V.2_FINAL.pdf	PDF	Jun 6, 2019
J-5_Cost_Summary_LINKED_FILES_05302019.xls	XLS spreadsheet	Jun 6, 2019
J-1_Offerors_and_Subcontractors_SummaryTables_and_Business_Systems_05312019.xlsx	XLSX spreadsheet	Jun 6, 2019
J-18.ZIP.zip	ZIP file	Jun 6, 2019
70B02C19R00000013-A0001_SF+RFP.06.06.2019.pdf	PDF	Jun 6, 2019
J-17.ZIP.zip	ZIP file	Jun 6, 2019
J-11_Solicitation_DD_Form_254_70B02C19R00000013.pdf	PDF	May 13, 2019
J-12_Notational__Inspection__Document_.xlsx	XLSX spreadsheet	May 13, 2019
J-6_USCBP_TRD_for_Post_MLU-LEK_Depot_DLM_TRD_dated_10-31-17_Revision_2.1_....pdf1.pdf	PDF	May 13, 2019
J-8_QASP.pdf	PDF	May 13, 2019
J-16_DOLs_Wage_Determination.pdf	PDF	May 13, 2019
J-5_04182019.xls	XLS spreadsheet	May 13, 2019
J-1_Offerors_and_Subcontractors_SummaryTables_and_Business_Systems.xlsx	XLSX spreadsheet	May 13, 2019
J-7_Appendices__CDRLs_FINAL_.docx	DOCX document	May 13, 2019
J-9_(DHS_Form_11000-6).pdf	PDF	May 13, 2019
J-7_MPA_PWS_FINAL_04192019.pdf	PDF	May 13, 2019
70B02C19R00000013_SF33+RFP.05.13.2019_FINAL.pdf	PDF	May 13, 2019
J-14_Government_Furnished_Equipment_(GFE).pdf	PDF	May 13, 2019
J-13_CBP_SB_Subk_Plan_Outline_FY19.doc	DOC document	May 13, 2019
J-10_(DHS_Mgmt_Directive_11042.1).pdf	PDF	May 13, 2019
J-2_Staffing_041819.xlsx	XLSX spreadsheet	May 13, 2019

Show all 34

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.

J-5 CostPrice Summary

Attachment J-5 Cost and Price Summary
Contract Title:		P-3 Maintenance Contract						2.5%	Escalation Rate
Expected Contract Type:		Hybrid - FFP, CR, CPIF, CPFF						1.25	OY1 to Phase-Out Factor
									NUMBERS ARE ONLY PROVIDED AS GUIDANCE - THEY DO NOT REPRESENT A GOVERNMENT EST.
		Phase-In (4 months)		Base Year (12 Months)		Option Year 1		Option Year 2		Option Year 3		Option Year 4		Option Year 5		Option Year 6		Option Year 7		Option Year 8		Option Year 9		6 Month Extension		Total Cost all Periods
WBS	Labor Categories	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost	Total Hours	Total Cost
1.00	Program Office
1.10	PMO Labor (FFP)	2,559	$5,318.10	7,200	$15,048.00	7,200	$15,424.20	7,200	$15,809.81	7,200	$16,205.05	7,200	$16,610.18	7,200	$17,025.43	7,200	$17,451.07	7,200	$17,887.34	7,200	$18,334.53	7,200	$18,792.89	3,600	$9,631.36	$183,537.94
2.00	Facilties (FFP)
2.10	Office and Wearhouse Space		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00		$0.00	$0.00
3.00	Labor (CPIF)
3.10	Site Labor - Jacksonville, FL	5,119	$10,494.10	7,200	$15,048.00	7,200	$15,424.20	7,200	$15,809.81	7,200	$16,205.05	7,200	$16,610.18	7,200	$17,025.43	7,200	$17,451.07	7,200	$17,887.34	7,200	$18,334.53	7,200	$18,792.89	3,600	$9,631.36	$188,713.94
3.20	Site Labor - Corpus Christi, TX	2,559	$5,318.10	7,200	$15,048.00	7,200	$15,424.20	7,200	$15,809.81	7,200	$16,205.05	7,200	$16,610.18	7,200	$17,025.43	7,200	$17,451.07	7,200	$17,887.34	7,200	$18,334.53	7,200	$18,792.89	3,600	$9,631.36	$183,537.94
3.30	Labor - Material Mgmt/IHR	2,559	$5,318.10	6,720	$13,680.00	6,720	$14,022.00	6,720	$14,372.55	6,720	$14,731.86	6,720	$15,100.16	6,720	$15,477.66	6,720	$15,864.61	6,720	$16,261.22	6,720	$16,667.75	6,720	$17,084.45	3,360	$8,755.78	$746,762.04
3.40	Engineering	2,559	$5,318.10	5,119	$10,638.10	5,119	$10,904.05	5,119	$11,176.65	5,119	$11,456.07	5,119	$11,742.47	5,119	$12,036.03	5,119	$12,336.93	5,119	$12,645.36	5,119	$12,961.49	5,119	$13,285.53	2,560	$6,808.83	$131,309.63
4.00	ODC
	ILS - CR
4.10	ILS -Transportation (CR)				$321,350.00		$329,384.00		$337,618.00		$346,059.00		$354,710.00		$363,578.00		$372,667.00		$381,984.00		$391,534.00		$401,322.00		$210,694.00	$3,810,900.00
4.20	ILS - Parts (CR)				$10,832,213.00		$11,103,018.00		$11,380,594.00		$11,665,109.00		$11,956,736.00		$12,255,655.00		$12,562,046.00		$12,876,097.00		$13,198,000.00		$13,527,950.00		$7,102,174.00	$128,459,592.00
4.30	ILS - Equipment (CR)				$266,775.00		$273,445.00		$280,281.00		$287,288.00		$294,470.00		$301,832.00		$309,378.00		$317,112.00		$325,040.00		$333,166.00		$174,912.00	$3,163,699.00
4.40	Travel (CR)
4.41	PMO (CR)		$173,321.00		$101,715.00		$104,258.00		$106,865.00		$109,536.00		$112,275.00		$115,082.00		$117,959.00		$120,908.00		$123,930.00		$127,029.00		$32,551.00	$1,345,429.00
4.42	All Labor Travel (CR)				$1,191,181.00		$1,220,961.00		$1,251,485.00		$1,282,772.00		$1,314,841.00		$1,347,712.00		$1,381,405.00		$1,415,940.00		$1,451,339.00		$1,487,622.00		$762,406.00	$14,107,664.00
4.50	OTHER ODC (CR)
4.51	Relocation (CR)		$1,135,214.00		$101,034.00		$103,560.00		$106,149.00		$108,803.00		$111,523.00		$114,311.00		$117,169.00		$120,098.00		$123,101.00		$126,178.00		$0.00	$2,267,140.00
4.52	IT Equipment (CR)		$438,701.00		$159,723.00		$163,717.00		$167,809.00		$172,005.00		$173,305.00		$180,712.00		$185,230.00		$189,861.00		$194,608.00		$199,473.00		$102,229.00	$2,327,373.00
4.53	Training (CR)		$15,777.00		$32,342.00		$33,150.00		$33,979.00		$38,828.00		$35,699.00		$36,592.00		$37,506.00		$38,444.00		$39,405.00		$40,390.00		$20,700.00	$402,812.00
4.54	Uniforms, safety etc. (CR)				$327,926.00		$336,124.00		$344,528.00		$353,141.00		$361,969.00		$371,018.00		$380,294.00		$389,801.00		$399,546.00		$409,535.00		$209,886.00	$3,883,768.00
4.60	ILS - CPFF
4.61	ILS - Repairs & Services (CPFF)				$103.00		$105.58		$108.21		$110.92		$113.69		$116.54		$119.45		$122.43		$125.50		$128.63		$65.92	$1,219.87
4.62	ILS - Major Subs (services) (CPFF)
	Rotodome				103.00		$105.58		$108.21		$110.92		$113.69		$116.54		$119.45		$122.43		$125.50		$128.63		$65.92	$1,219.87
	Engines				103.00		$105.58		$108.21		$110.92		$113.69		$116.54		$119.45		$122.43		$125.50		$128.63		$65.92	$1,219.87
	Props				103.00		$105.58		$108.21		$110.92		$113.69		$116.54		$119.45		$122.43		$125.50		$128.63		$65.92	$1,219.87
5.00	Depot
5.11	CBP Depot Maintenance (FFP)		$0.00		$20.00		$20.50		$21.01		$21.54		$22.08		$22.63		$23.19		$23.77		$24.37		$24.98		$0.00	$224.07
5.12	Fuselage Inspection (FFP)		$0.00		$20.00		$20.50		$10.51		$0.00		$22.08		$11.31		$0.00		$0.00		$0.00		$12.49		$0.00	$96.89
5.13	Tank 5A (FFP)		$0.00		$20.00		$10.25		$0.00		$10.77		$11.04		$22.63		$11.60		$23.77		$12.18		$24.98		$0.00	$147.22
5.14	DLM Over and Aboves (CPFF)		$0.00		$20.00		$20.50		$21.01		$21.54		$22.08		$22.63		$23.19		$23.77		$24.37		$24.98		$0.00	$224.07
5.15	Drop-In Maintenance (CPFF)		$0.00		$20.00		$20.50		$21.01		$21.54		$22.08		$22.63		$23.19		$23.77		$24.37		$24.98		$0.00	$224.07
6.00	Other Government Agencies
6.10	OGA - Depot Maintenance (CPFF)				$0.00		$20.50		$10.51		$0.00		$0.00		$11.31		$0.00		$0.00		$12.18		$0.00		$0.00	$54.50
6.20	OGA - Over and Aboves (CPFF)				$0.00		$20.50		$10.51		$0.00		$0.00		$11.31		$0.00		$0.00		$12.18		$0.00		$0.00	$54.50
6.30	OGA - ODC (CR)				$250,000.00		$250,000.00		$250,000.00		$250,000.00		$250,000.00		$250,000.00		$250,000.00		$250,000.00		$250,000.00		$250,000.00		$125,000.00	$2,625,000.00
	TOTAL CONTRACT PER YEAR=	15,355	$1,794,779.50	33,439	$13,654,233.10	33,439	$13,989,371.20	33,439	$14,332,814.03	33,439	$14,688,863.15	33,439	$15,042,755.28	33,439	$15,415,672.59	33,439	$15,794,767.71	33,439	$16,183,398.44	33,439	$16,581,747.46	33,439	$16,990,040.57	16,720	$8,785,274.38	$163,833,143.31
	Estimate Prepared by:
	Date Prepared:													TOTAL CONTRACT ESTIMATE:
	Signature:													$163,833,143.31

&C&"Arial,Bold"&22P-3 Aircraft Maintenance Contract &L&"Arial,Bold"&14&F&C&"Arial,Bold"&14&A

J-5A Labor PMO(FFP)

J-5A Labor - PMO
						NUMBERS ARE ONLY PROVIDED AS GUIDANCE - THEY DO NOT REPRESENT A GOVERNMENT EST.																	FFP should be last column
Annual percentage labor increase =	2.50%
WBS Element 1.10
Phase-In (4 months)																								Phase-In Totals
	Position Information						Hours			Rates		Unburdened Total			Burdens, Overheads, etc.
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	Location	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Profit	Total cost	Hours
Example - Position 1	XX-XXX					1	693	160	853	$ 1.00	$ 1.50	$693.00	$240.00	$933.00	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$1,772.70	853
Example - Position 2	XX-XXX					2	1386	320	1706	$ 1.00	$ 1.50	$1,386.00	$480.00	$1,866.00	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$3,545.40	1,706
Insert All Positions
																								$5,318.10	2,559
Base Year (12 months)																								Base Year Totals
	Position Information						Hours			Rates		Unburdened Total			Burdens, Overheads, etc.
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	Location	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Profit	Total cost	Hours
Example - Position 1	XX-XXX					1	1920	480	2400	$ 1.00	$ 1.50	$1,920.00	$720.00	$2,640.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$5,016.00	2,400
Example - Position 2	XX-XXX					2	3840	960	4800	$ 1.00	$ 1.50	$3,840.00	$1,440.00	$5,280.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$10,032.00	4,800
Insert All Positions
																								$15,048.00	7,200

J-5B Labor JAX (CPIF)

J-5B Labor - Jacksonville
						NUMBERS ARE ONLY PROVIDED AS GUIDANCE - THEY DO NOT REPRESENT A GOVERNMENT EST.
Annual percentage labor increase =	2.50%
Rate from DOL WD 15-4539 (Rev. 8), File name: DOL Wage Determination
WBS element 3.10
Phase-In (4 months)																							Phase-In Totals
	Position Information					Hours			Rates		Unburdened Total			Burdens, Overheads, etc
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Fee	Labor Cost	OT Labor Cost	Hours
Example - Position 1	XX-XXX				1	1386	320	1706	$ 1.00	$ 1.50	$1,386.00	$480.00	$1,866.00	$ 138.60	$ 138.60	$ 138.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$3,401.40	$5,102.10	1,706
Example - Position 2	XX-XXX				2	2773	640	3413	$ 1.00	$ 1.50	$2,773.00	$960.00	$3,733.00	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$7,092.70	$10,639.05	3,413
Insert All Positions
																							$10,494.10	$15,741.15	5,119
Base Year (12 months)																							Base Year Totals
	Position Information					Hours			Rates		Unburdened Total			Burdens, Overheads, etc
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Fee	Labor Cost	OT Labor Cost	Hours
Example - Position 1	XX-XXX				1	1920	480	2400	$ 1.00	$ 1.50	$1,920.00	$720.00	$2,640.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$5,016.00	$7,524.00	2,400
Example - Position 2	XX-XXX				2	3840	960	4800	$ 1.00	$ 1.50	$3,840.00	$1,440.00	$5,280.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$10,032.00	$15,048.00	4,800
Insert All Positions
																							$15,048.00	$22,572.00	7,200

J-5C Labor CRP (CPIF)

J-5C Labor - Corpus Christi
						NUMBERS ARE ONLY PROVIDED AS GUIDANCE - THEY DO NOT REPRESENT A GOVERNMENT EST.
Annual percent labor rate increase =	2.50%
Rate from CBA with International Association of Machinists and Aerospace Workers and it's District Lodge 776, Local Lodge 2916, File name: 2015 CONTRACT BOOK_IAM LOCAL LODGE 2916_CORPUS CHRISTI.pdf
WBS Element 3.20
Phase-In (4 months)																							Phase-In Totals
	Position Information					Hours			Rates		Unburdened Total			Burdens, Overheads, etc
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Fee	Labor Cost	OT labor Cost	Hours
Example - Position 1	XX-XXX				1	693	160	853	$ 1.00	$ 1.50	$693.00	$240.00	$933.00	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$1,772.70	$2,659.05	853
Example - Position 2	XX-XXX				2	1386	320	1706	$ 1.00	$ 1.50	$1,386.00	$480.00	$1,866.00	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$3,545.40	$5,318.10	1,706
Insert All Positions
																							$5,318.10	$7,977.15	2,559
Base Year (12 months)																							Base Year Totals
	Position Information					Hours			Rates		Unburdened Total			Burdens, Overheads, etc
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Fee	Labor Cost	OT Labor Cost	Hours
Example - Position 1	XX-XXX				1	1920	480	2400	$ 1.00	$ 1.50	$1,920.00	$720.00	$2,640.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$ 264.00	$5,016.00	$7,524.00	2,400
Example - Position 2	XX-XXX				2	3840	960	4800	$ 1.00	$ 1.50	$3,840.00	$1,440.00	$5,280.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$ 528.00	$10,032.00	$15,048.00	4,800
Insert All Positions
																							$15,048.00	$22,572.00	7,200

J-5D Labor MM & IHR (CPIF)

J-5D Labor - Material Management & Inhouse Repair Major
										NUMBERS ARE ONLY PROVIDED AS GUIDANCE - THEY DO NOT REPRESENT A GOVERNMENT EST.
Annual percent labor rate increase =	2.50%
Rates to be based on employee location
WBS Element 3.30
Phase-In (4 months)																								Phase-In Totals
	Position Information						Hours			Rates		Unburdened Total			Burdens, Overheads, etc
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	Location	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Fee	Labor Cost	OT Labor Cost	Hours
Example - Position 1	XX-XXX					1	693	160	853	$ 1.00	$ 1.50	$693.00	$240.00	$933.00	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$1,772.70	$2,659.05	853
Example - Position 2	XX-XXX					2	1386	320	1706	$ 1.00	$ 1.50	$1,386.00	$480.00	$1,866.00	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$3,545.40	$5,318.10	1,706
Insert All Positions
																								$5,318.10	$7,977.15	2,559
Base Year (12 months)																								Base Year Totals
	Position Information						Hours			Rates		Unburdened Total			Burdens, Overheads, etc
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	Location	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Fee	Labor Cost	OT Labor Cost	Hours
Example - Position 1	XX-XXX					1	1920	320	2240	$ 1.00	$ 1.50	$1,920.00	$480.00	$2,400.00	$ 240.00	$ 240.00	$ 240.00	$ 240.00	$ 240.00	$ 240.00	$ 240.00	$ 240.00	$ 240.00	$4,560.00	$6,840.00	2,240
Example - Position 2	XX-XXX					2	3840	640	4480	$ 1.00	$ 1.50	$3,840.00	$960.00	$4,800.00	$ 480.00	$ 480.00	$ 480.00	$ 480.00	$ 480.00	$ 480.00	$ 480.00	$ 480.00	$ 480.00	$9,120.00	$13,680.00	4,480
Insert All Positions
																								$13,680.00	$20,520.00	6,720

J-5E Labor Engineering(CPIF)

J-5E Labor - Engineering (CPIF)
										NUMBERS ARE ONLY PROVIDED AS GUIDANCE - THEY DO NOT REPRESENT A GOVERNMENT EST.
Annual percent labor rate increase =	2.50%
WBS Element 3.40
Phase-In (4 months)																								Phase-In Totals
	Position Information						Hours			Rates		Unburdened Total			Burdens, Overheads, etc
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	Location	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Fee	Labor Cost	OT Labor Cost	Hours
Example - Position 1	XX-XXX					1	693	160	853	$ 1.00	$ 1.50	$693.00	$240.00	$933.00	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$ 93.30	$1,772.70	$2,659.05	853
Example - Position 2	XX-XXX					2	1386	320	1706	$ 1.00	$ 1.50	$1,386.00	$480.00	$1,866.00	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$3,545.40	$5,318.10	1,706
Insert All Positions
																								$5,318.10	$7,977.15	2,559
Base Year (12 months)																								Base Year Totals
	Position Information						Hours			Rates		Unburdened Total			Burdens, Overheads, etc
Labor Categories (Must Match Attachment J-2 Manning)	Occupation Code	Location	SCA Y/N	CBA Y/N	E&Q Level	# of Employees	Total Hours	OT Hours	Total Hours	Hourly Rate	OT Rate	Total Regular Dollars	Total OT	Total Dollars	Overhead (X%)	SUTA (X%)	FUTA (X%)	Workers Comp. (X%)	FICA (X%)	DOL Benefits (X%)	G&A (X%)	FCCM (X%)	Fee	Labor Cost	OT Labor Cost	Hours
Example - Position 1	XX-XXX					1	1386	320	1706	$ 1.00	$ 1.50	$1,386.00	$480.00	$1,866.00	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$ 186.60	$3,545.40	$5,318.10	1,706
Example - Position 2	XX-XXX					2	2773	640	3413	$ 1.00	$ 1.50	$2,773.00	$960.00	$3,733.00	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$ 373.30	$7,092.70	$10,639.05	3,413
Insert All Positions
																								$10,638.10	$15,957.15	5,119

J-5F Facilities(FFP)

Attachment J-5F Facility Cost Detail
Annual Escalation Rate =	2.5%
WBS Element 2.10
		Phase-In (4 months)	Base Year (12 Months)	Option Year 1	Option Year 2	Option Year 3	Option Year 4	Option Year 5	Option Year 6	Option Year 7	Option Year 8	Option Year 9	6 Month Extension
PWS C1.2.9.1 - Office and Wearhouse Space
Facility Location: XXXXX		Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost
Lease/Rent Cost		0	0	0	0	0	0	0	0	0	0	0	0
Total Per Year		0	0	0	0	0	0	0	0	0	0	0	0
Notes:
Rows provided are only for example purposes. Offerors shall propose facilities to meet PWS requirements
Insert rows as necessary to provide additional detail
If more than one faclity, please provide one chart per facility
All faclities shall meet CBP physical security requirements

J-5G Depot FFP CPFF

Attachment J-5G Depot Pricing Per Event Per Year
Annual Escalation Rate =	2.5%
CBP (FFP & CPFF)
		Phase-In			Base Year (12 Months)			Option Year 1			Option Year 2			Option Year 3			Option Year 4			Option Year 5			Option Year 6			Option Year 7			Option Year 8			Option Year 9			6 Month Extension
WBS Element 5.10
CBP - Depot Event	Note	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price
Depot Level Maintance (DLM) - FFP	A	0	0	0	2	10	20	2	10	21	2	11	21	2	11	22	2	11	22	2	11	23	2	12	23	2	12	24	2	12	24	2	12	25	0	13	0
DLM Over and Above Estimate - CPFF	B	0	0	0	2	10	20	2	10	21	2	11	21	2	11	22	2	11	22	2	11	23	2	12	23	2	12	24	2	12	24	2	12	25	0	13	0
Fuselage Inspection (FI) - FFP	C	0	0	0	2	10	20	2	10	21	1	11	11	0	11	0	2	11	22	1	11	11	0	12	0	0	12	0	0	12	0	1	12	12	0	13	0
Tank 5A (T5A) - FFP	C	0	0	0	2	10	20	1	10	10	0	11	0	1	11	11	1	11	11	2	11	23	1	12	12	2	12	24	1	12	12	2	12	25	0	13	0
Drop-In Maintenance - CPFF	D	0	0	0	2	10	20	2	10	21	2	11	21	2	11	22	2	11	22	2	11	23	2	12	23	2	12	24	2	12	24	2	12	25	0	13	0
Total				0			100			92			74			75			99			102			81			95			85			112			0
Notes:
Vendor shall provide a cost for each Depot event for each option year of this contract
Quantities provided represent the anticipited depot events. Other Governemnt Agencies are broken out in a separate chart
A = Cost and required number of events per option year is based on attachment J -6 USCBP TRD and appendices 1.7.19
B = Contractor shall provide an estimated O&A for each DLM event schedule
C = These events shall be priced for each option year as fixed price and will be selected per the 90 day report recommendation.
D = This is the Government est. for Drop - In events per opt year
Drop-in Maintenance Examples:
Vendor shall use the following two examples to price out the Drop-in Maintenance line
1. Replace #2 Vertical Stab Plank - Right Side
2. Replace pilot side front conner post windshield frame
OGA - CPFF
		Phase-In			Base Year (12 Months)			Option Year 1			Option Year 2			Option Year 3			Option Year 4			Option Year 5			Option Year 6			Option Year 7			Option Year 8			Option Year 9			6 Month Extension
WBS Ewlement 6.10
OGA - Depot Event	Note	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price	QTY	Unit Price	Price
Depot Level Maintance (DLM)	A	0	0	0	0	10	0	2	10	21	1	11	11	0	11	0	0	11	0	1	11	11	0	12	0	0	12	0	1	12	12	0	12	0	0	13	0
DLM Over and Above Estimate	B	0	0	0	0	10	0	2	10	21	1	11	11	0	11	0	0	11	0	1	11	11	0	12	0	0	12	0	1	12	12	0	12	0	0	13	0
Total OGA Per OY				0			0			41			21			0			0			23			0			0			24			0			0
Notes:
Vendor shall provide a cost for each Depot event for each option year of this contract
Quantities provided in the chart above represent the anticipited depot events for OGA.
A = Cost are based on attachment J -6 USCBP TRD
B = Contractor shall provide an estimated O&A for each DLM event schedule

J-5H Repairs & Services (CPFF)

J-5H Repairs and Services
ILS	CPFF	Cost	Fee	Total
4.61	Repairs and Services
	Base Year	$ 100.00	$ 3.00	$ 103.00
4.62	Major Sub- Contractors	Cost	Fee	Total
	Rotodome	$ 100.00	$ 3.00	$ 103.00
	Engines	$ 100.00	$ 3.00	$ 103.00
	Props	$ 100.00	$ 3.00	$ 103.00
	Base Year	$ 300.00	$ 9.00	$ 309.00

File details come from the government source that posted it.