J-5_Cost_Summary_LINKED_FILES_05302019.xls

XLS spreadsheet 551 KB Posted Jun 6, 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-5_Cost_Summary_07.24.2019.A0004.xls	XLS spreadsheet	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-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,774.10	7,200	$16,416.00	7,200	$16,826.40	7,200	$17,247.06	7,200	$17,678.24	7,200	$18,120.19	7,200	$18,573.20	7,200	$19,037.53	7,200	$19,513.47	7,200	$20,001.30	7,200	$20,501.33	3,600	$10,506.93	$200,195.75
																										$0.00
2.00	Facilties (FFP)																									$0.00
2.10	Office and Wearhouse Space		$285.00		$215.00		$215.00		$215.00		$215.00		$215.00		$215.00		$215.00		$215.00		$215.00		$285.00		$215.00	$2,720.00
3.00	Labor (CPIF)
3.10	Site Labor - Jacksonville, FL	5,119	$11,358.10	7,200	$16,416.00	7,200	$16,826.40	7,200	$17,247.06	7,200	$17,678.24	7,200	$18,120.19	7,200	$18,573.20	7,200	$19,037.53	7,200	$19,513.47	7,200	$20,001.30	7,200	$20,501.33	3,600	$10,506.93	$205,779.75
3.20	Site Labor - Corpus Christi, TX	2,559	$5,774.10	7,200	$16,416.00	7,200	$16,826.40	7,200	$17,247.06	7,200	$17,678.24	7,200	$18,120.19	7,200	$18,573.20	7,200	$19,037.53	7,200	$19,513.47	7,200	$20,001.30	7,200	$20,501.33	3,600	$10,506.93	$200,195.75
3.30	Labor - Material Mgmt/IHR	2,559	$5,774.10	6,720	$14,592.00	7,680	$17,761.20	7,680	$18,205.23	7,680	$18,660.36	7,680	$19,126.87	7,680	$19,605.04	7,680	$20,095.17	7,680	$20,597.55	7,680	$21,112.49	7,680	$21,640.30	3,840	$11,090.65	$786,318.85
3.40	Engineering	2,559	$5,774.10	5,119	$11,550.10	7,680	$17,761.20	7,680	$18,205.23	7,680	$18,660.36	7,680	$19,126.87	7,680	$19,605.04	7,680	$20,095.17	7,680	$20,597.55	7,680	$21,112.49	7,680	$21,640.30	3,840	$11,090.65	$205,219.05
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)				$100.00		$100.00		$102.50		$105.06		$107.69		$110.38		$113.14		$115.97		$118.87		$121.84		$62.44	$1,157.90
4.62	ILS - Major Subs (services) (CPFF)
	Rotodome				100.00		$100.00		$102.50		$105.06		$107.69		$110.38		$113.14		$115.97		$118.87		$121.84		$62.44	$1,157.90
	Engines				100.00		$100.00		$102.50		$105.06		$107.69		$110.38		$113.14		$115.97		$118.87		$121.84		$62.44	$1,157.90
	Props				100.00		$100.00		$102.50		$105.06		$107.69		$110.38		$113.14		$115.97		$118.87		$121.84		$62.44	$1,157.90
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		$0.00		$10.51		$0.00		$0.00		$11.31		$0.00		$0.00		$12.18		$0.00		$0.00	$34.00
6.20	OGA - Over and Aboves (CPFF)				$0.00		$0.00		$10.51		$0.00		$0.00		$11.31		$0.00		$0.00		$12.18		$0.00		$0.00	$34.00
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=		$1,797,752.50		$13,660,364.10		$14,004,325.85		$14,348,179.20		$14,704,607.06		$15,058,887.42		$15,432,202.65		$15,811,705.66		$16,200,754.46		$16,599,532.01		$17,008,334.36		$8,794,718.88	$163,999,422.04
	Estimate Prepared by:
	Date Prepared:													TOTAL CONTRACT ESTIMATE:
	Signature:													$163,999,422.04

&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	$ 2.00	$693.00	$320.00	$1,013.00	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$1,924.70	853
Example - Position 2	XX-XXX					2	1386	320	1706	$ 1.00	$ 2.00	$1,386.00	$640.00	$2,026.00	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$3,849.40	1,706
Insert All Positions
																								$5,774.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	$ 2.00	$1,920.00	$960.00	$2,880.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$5,472.00	2,400
Example - Position 2	XX-XXX					2	3840	960	4800	$ 1.00	$ 2.00	$3,840.00	$1,920.00	$5,760.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$10,944.00	4,800
Insert All Positions
																								$16,416.00	7,200
						Escalation Rate from Base Year to Option Year 1					2.5%
Option Year 1																								Option Year One 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.03	$ 2.05	$1,968.00	$984.00	$2,952.00	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$5,608.80	2,400
Example - Position 2	XX-XXX					2	3840	960	4800	$ 1.03	$ 2.05	$3,936.00	$1,968.00	$5,904.00	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$11,217.60	4,800
Insert All Positions
																								$16,826.40	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	$ 2.00	$1,386.00	$640.00	$2,026.00	$ 138.60	$ 138.60	$ 138.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$3,657.40	$5,486.10	1,706
Example - Position 2	XX-XXX				2	2773	640	3413	$ 1.00	$ 2.00	$2,773.00	$1,280.00	$4,053.00	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$7,700.70	$11,551.05	3,413
Insert All Positions
																							$11,358.10	$17,037.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	$ 2.00	$1,920.00	$960.00	$2,880.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$5,472.00	$8,208.00	2,400
Example - Position 2	XX-XXX				2	3840	960	4800	$ 1.00	$ 2.00	$3,840.00	$1,920.00	$5,760.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$10,944.00	$16,416.00	4,800
Insert All Positions
																							$16,416.00	$24,624.00	7,200
						Escalation Rate from Base Year to Option Year 1	2.5%
Option Year 1																							Option Year One 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	Total cost	OT Labor Cost	Hours
Example - Position 1	XX-XXX				1	1920	480	2400	$ 1.03	$ 2.05	$1,968.00	$984.00	$2,952.00	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$5,608.80	$8,413.20	2,400
Example - Position 2	XX-XXX				2	3840	960	4800	$ 1.03	$ 2.05	$3,936.00	$1,968.00	$5,904.00	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$11,217.60	$16,826.40	4,800
Insert All Positions
																							$16,826.40	$25,239.60	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	$ 2.00	$693.00	$320.00	$1,013.00	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$1,924.70	$2,887.05	853
Example - Position 2	XX-XXX				2	1386	320	1706	$ 1.00	$ 2.00	$1,386.00	$640.00	$2,026.00	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$3,849.40	$5,774.10	1,706
Insert All Positions
																							$5,774.10	$8,661.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	$ 2.00	$1,920.00	$960.00	$2,880.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$ 288.00	$5,472.00	$8,208.00	2,400
Example - Position 2	XX-XXX				2	3840	960	4800	$ 1.00	$ 2.00	$3,840.00	$1,920.00	$5,760.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$ 576.00	$10,944.00	$16,416.00	4,800
Insert All Positions
																							$16,416.00	$24,624.00	7,200
						Escalation Rate from Base Year to Option Year 1				2.5%
Option Year 1																							Option Year One 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.03	$ 2.05	$1,968.00	$984.00	$2,952.00	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$ 295.20	$5,608.80	$8,413.20	2,400
Example - Position 2	XX-XXX				2	3840	960	4800	$ 1.03	$ 2.05	$3,936.00	$1,968.00	$5,904.00	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$ 590.40	$11,217.60	$16,826.40	4,800
Insert All Positions
																							$16,826.40	$25,239.60	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	$ 2.00	$693.00	$320.00	$1,013.00	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$1,924.70	$2,887.05	853
Example - Position 2	XX-XXX					2	1386	320	1706	$ 1.00	$ 2.00	$1,386.00	$640.00	$2,026.00	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$3,849.40	$5,774.10	1,706
Insert All Positions
																								$5,774.10	$8,661.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	$ 2.00	$1,920.00	$640.00	$2,560.00	$ 256.00	$ 256.00	$ 256.00	$ 256.00	$ 256.00	$ 256.00	$ 256.00	$ 256.00	$ 256.00	$4,864.00	$7,296.00	2,240
Example - Position 2	XX-XXX					2	3840	640	4480	$ 1.00	$ 2.00	$3,840.00	$1,280.00	$5,120.00	$ 512.00	$ 512.00	$ 512.00	$ 512.00	$ 512.00	$ 512.00	$ 512.00	$ 512.00	$ 512.00	$9,728.00	$14,592.00	4,480
Insert All Positions
																								$14,592.00	$21,888.00	6,720
							Escalation Rate from Base Year to Option Year 1				2.5%
Option Year 1																								Option Year One Totals
12/31/99	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	2080	480	2560	$ 1.03	$ 2.05	$2,132.00	$984.00	$3,116.00	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$5,920.40	$8,880.60	2,560
Example - Position 2	XX-XXX					2	4160	960	5120	$ 1.03	$ 2.05	$4,264.00	$1,968.00	$6,232.00	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$11,840.80	$17,761.20	5,120
Insert All Positions
																								$17,761.20	$26,641.80	7,680

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	$ 2.00	$693.00	$320.00	$1,013.00	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$ 101.30	$1,924.70	$2,887.05	853
Example - Position 2	XX-XXX					2	1386	320	1706	$ 1.00	$ 2.00	$1,386.00	$640.00	$2,026.00	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$3,849.40	$5,774.10	1,706
Insert All Positions
																								$5,774.10	$8,661.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	$ 2.00	$1,386.00	$640.00	$2,026.00	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$ 202.60	$3,849.40	$5,774.10	1,706
Example - Position 2	XX-XXX					2	2773	640	3413	$ 1.00	$ 2.00	$2,773.00	$1,280.00	$4,053.00	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$ 405.30	$7,700.70	$11,551.05	3,413
Insert All Positions
																								$11,550.10	$17,325.15	5,119
							Escalation Rate from Base Year to Option Year 1				2.5%
Option Year 1																								Option Year One Totals
12/31/99	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	2080	480	2560	$ 1.03	$ 2.05	$2,132.00	$984.00	$3,116.00	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$ 311.60	$5,920.40	$8,880.60	2,560
Example - Position 2	XX-XXX					2	4160	960	5120	$ 1.03	$ 2.05	$4,264.00	$1,968.00	$6,232.00	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$ 623.20	$11,840.80	$17,761.20	5,120
Insert All Positions
																								$17,761.20	$26,641.80	7,680
							Rate Adjustment Factor from OY1 to Phase-Out				1.25

J-5F Facilities(FFP)

Attachment J-5F Facility Cost Detail
Annual Escalation Rate =	Contractor Determined
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	Note
Facility Location: XXXXX		Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost	Cost
Facility Modification / De-Mod	A	70	0	0	0	0	0	0	0	0	0	70	0
Equipment/Supplies	B	60	60	60	60	60	60	60	60	60	60	60	60
Lease		50	50	50	50	50	50	50	50	50	50	50	50
Utilities	C	40	40	40	40	40	40	40	40	40	40	40	40
Maintaince / Landscaping		30	30	30	30	30	30	30	30	30	30	30	30
Phone/Internet		20	20	20	20	20	20	20	20	20	20	20	20
Security/Fire Monitoring System	D	10	10	10	10	10	10	10	10	10	10	10	10
Profit		5	5	5	5	5	5	5	5	5	5	5	5
Total Per OY		285	215	215	215	215	215	215	215	215	215	285	215
Facility Square Footage	100
Cost/SQ Ft.		2.85	2.15	2.15	2.15	2.15	2.15	2.15	2.15	2.15	2.15	2.85	2.15
Notes:
Rows provided are only for example purposes, offerors should include all costs to meet PWS requirements
Insert rows as necessary to provide additional detail
If more than one faclity, please provide one chart per facility
A = All costs associated meeting CBP physical security requirements
B = Include all necessary office furniture, safty equipment, office supplies, etc
C = Include all utilities for operating facility
D = Reoccuring costs for Security and Fire monitoring systems

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
Phase-In Costs - FFP	E	1	10	10	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 CBP Per OY				10			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 Aencies, 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 = O&A Estimate is based on attachment J-6 USCBP TRD - Contractor shall provide an estimated O&A for each DLM event schedule
C = This 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
E= Insert rows as necessary to provide detail on Phase-In Costs.
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	0	10	0	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	0	10	0	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			0			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 represent the anticipited depot events. Other Governemnt Aencies, 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 = O&A Estimate is based on attachment J-6 USCBP TRD - Contractor shall provide an estimated O&A for each DLM event schedule

J-5H Repairs & Services (CPFF)

J-5H Repairs and Services
ILS	CPFF
4.61	Repairs and Services
	Government Provided estimate - Base Year	$100.00
	Government Provided estimate - OY1	$100.00
4.62	Major Sub- Contractors
	Rotodome	100.00
	Engines	100.00
	Props	100.00
	Government Provided estimate - Base Year	$300.00
	Rotodome	100.00
	Engines	100.00
	Props	100.00
	Government Provided estimate - OY1	$300.00

File details come from the government source that posted it.