Attachment_L-4_Amendment3_costpropformat_20190912.xlsx

XLSX spreadsheet 65 KB Posted Sep 12, 2019

Attached to: Follow-on Technical Support (FOTS) Request for Proposal (RFP) Federal contract opportunity
Solicitation number: N0002418R4200
Issued by: Department of the Navy Naval Sea Systems Command

About this file

Written by GovTribe AI · Dec 31, 2023

This solicitation requests proposals for a Follow-on Technical Support contract to provide eligible foreign customers with sustainment materials, system upgrades, system integration support, training, and other related efforts associated with the transfer and acquisition, operation, and maintenance of naval vessels, systems, and ship support infrastructure. Offerors must submit proposals using the specified templates, with labor rates in the Attachment L-4 format and responses by September 24, 2019 to be considered. The resulting contract will be a single-award Indefinite-Delivery/Indefinite-Quantity contract valued at a maximum of $1.2 billion over five years from date of award, with fixed composite labor rates and indirect rates for each contract year. The Naval Sea Systems Command seeks to meet Foreign Military Sales Program requirements through this solicitation.

From the source

Attachment L-4 updated

View the file

Other files for this federal contract opportunity

Other files attached to Follow-on Technical Support (FOTS) Request for Proposal (RFP), newest first.
File	Type	Posted
Attachment_L-5_LaborRateBackup_20190912.xlsx	XLSX spreadsheet	Sep 12, 2019
Amendment_4_18R4200_20190912.docx	DOCX document	Sep 12, 2019
Attachment_L-5_LaborRateBackup_20190910.xlsx	XLSX spreadsheet	Sep 11, 2019
Attachment_L-4_Amendment3_costpropformat_20190910.xlsx	XLSX spreadsheet	Sep 11, 2019
Amendment_3_Questions_Attachment_L-1_bidderquesttemp_FINAL_20190910.pdf	PDF	Sep 11, 2019
Amendment3_18R4200_20190911.pdf	PDF	Sep 11, 2019
Conformed_copy_thru_Amend3_18R4200_20190911.pdf	PDF	Sep 11, 2019
Amendment_2_CDRLSportf_A0001thruA0012_20190813.pdf	PDF	Aug 14, 2019
Amendment_2_Attachment_4_listkeypersandreqs_20190806.pdf	PDF	Aug 14, 2019
Conformed_copy_Amendment2_N0002418R4200_20190814.pdf	PDF	Aug 14, 2019
Attachment_L-4_Amendment2_costpropformat_20190806.xlsx	XLSX spreadsheet	Aug 14, 2019
Amendment_2_Attachment_L-3_RIS_20190806.doc	DOC document	Aug 14, 2019
Amendment_2_N0002418R4200_20190814.pdf	PDF	Aug 14, 2019
Attachment_L-1_biddersquestANSWER_FINAL_20190814.pdf	PDF	Aug 14, 2019
Amendment_2_Attachment_L-2_samptasktemp_20190813.docx	DOCX document	Aug 14, 2019
Attachment_L-1_biddersquestANSWER_20190708.xlsx	XLSX spreadsheet	Jul 8, 2019
Amendment1_20190708.pdf	PDF	Jul 8, 2019
Attachment_3_list_of_coutries_20190618.pdf	PDF	Jul 5, 2019
Attachment_L-3_RIS_20190618.doc	DOC document	Jul 5, 2019
Attachment_L-1_bidderquesttemp_20190618.xlsx	XLSX spreadsheet	Jul 5, 2019
CDRLSportf_A0001thruA0013_20190624.pdf	PDF	Jul 5, 2019
Attachment_2_acronymlist_20190618.pdf	PDF	Jul 5, 2019
Attachment_1_DRAFTDD254_20190529.pdf	PDF	Jul 5, 2019
Attachment_4_listkeypersandreqs_20190618.pdf	PDF	Jul 5, 2019
Attachment_L-4_costpropformat_20190618.xlsx	XLSX spreadsheet	Jul 5, 2019
Attachment_L-2_samptasktemp_20190618.docx	DOCX document	Jul 5, 2019
FOTS_RECOMPETE_20190624.pdf	PDF	Jul 5, 2019

Show all 27

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Instructions for completing Attachment L-4 Cost Proposal Format

1. For CLIN tabs 0001 - 0005, offers are to insert FULLY BURDENED rates for each labor category for each

year only. The composite rate fields are self-calculating and should not be adjusted.

2. If the offeror recommends a different labor mix for any of the CLINs, each change shall be noted

under the "Notes" cell. The rationale for the changes shall be provided in the cost narrative of the

proposal submission, as identified in Section L of the solicitation.

3. For CLIN tab 0006-0008, offerors are to identify and insert the applicable proposed indirect rates for each item

identified for each year. Please be advised that the figures provided in section L of the solicitation (4.5.3, 4.5.4,

and 4.5.5) are final figures (e.g. the given values for those lines will be inclusive of all applicable indirects).

4. The summary tab is self-explanatory.

5. Offerors are reminded that all rates identified in this workbook must be supported by documentation in their

proposal submission, as stated in Section L of the solicitation.

6. On the summary tab, offerors are to insert the composite rates for the labor table only (the total column is self-calculating)

and the applicable indirect rates for all other CLINs (as noted).

N0002418R4200 Attachment L-4 - Cost Proposal Format 20190618

&P of &N

CLIN 0001

FMS MANAGEMENT SUPPORT									Annual Composite Rate					Annual Hours					Annual Ceiling					CLIN Ceiling
CLIN	Labor Category Name	Cumulative Hours	Percentage of Total	Labor Category Rate (Y1)	Labor Category Rate (Y2)	Labor Category Rate (Y3)	Labor Category Rate (Y4)	Labor Category Rate (Y5)	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5
0001	Program Manager (PM)	15,300	1%						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	509,127	509,127	509,128	509,128	509,128	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0001	Assistant PM	8,007	0%
0001	Program Analyst	149,580	6%
0001	Logistics PM	10,334	0%
0001	Sr Logistics Analyst	24,038	1%
0001	Logistics Analyst	191,818	8%
0001	Configuration Manager	10,000	0%
0001	Equipment/Technical Data Analyst	15,366	1%
0001	Instructor	55,000	2%
0001	Curriculum Developer/Instructional Technologist	31,161	1%
0001	Purchasing Agent	111,336	4%
0001	Planner/Estimator	128,520	5%
0001	Support Personnel	1,787,127	70%
0001	QA Specialist	733	0%
0001	Waterfront Mgr	2,437	0%
0001	Data Mgr	3,252	0%
0001	Data Entry Clerk	1,629	0%

NOTES:

N0002418R4200 Attachment L-4 - Cost Proposal Format 20190618

CLIN 0002

FMS ENGINEERING SUPPORT									Composite Rate					Annual Hours					Annual Ceiling					CLIN Ceiling
CLIN	Labor Category Name	Cumulative Hours	Percentage of Total	Labor Category Rate (Y1)	Labor Category Rate (Y2)	Labor Category Rate (Y3)	Labor Category Rate (Y4)	Labor Category Rate (Y5)	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5
0002	Sr Eng	100,318	5%						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	400,214	400,214	400,214	400,213	400,213	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0002	Field Eng	1,059,385	53%
0002	Designer/Eng Tech	30,474	2%
0002	NDT Specialist	17,932	1%
0002	Engineer	447,849	22%
0002	Support Engineer	100,000	5%
0002	Sr Computer Prog/Sr Software Engineer	84,165	4%
0002	Computer Prog/Software Engineer	149,917	7%
0002	Test Eng	1,982	0%
0002	Weapons Tech	1,930	0%
0002	Calibration Tech	648	0%
0002	Sr Combat Sys Eng	6,468	0%

NOTES:

N0002418R4200 Attachment L-4 - Cost Proposal Format 20190618

CLIN 0003

FOTS TECHNICAL SUPPORT (CONUS)									Composite Rate					Annual Hours					Annual Ceiling					CLIN Ceiling
CLIN	Labor Category Name	Cumulative Hours	Percentage of Total	Labor Category Rate (Y1)	Labor Category Rate (Y2)	Labor Category Rate (Y3)	Labor Category Rate (Y4)	Labor Category Rate (Y5)	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5
0003	Supply Technician	4,099	0%						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	210,021	210,021	210,021	210,022	210,022	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0003	Electronic Technician	46,579	4%
0003	Marine Machinist	262,700	25%
0003	Pipefitter	64,708	6%
0003	Marine Electrician	108,140	10%
0003	Boiler Tech	6,184	1%
0003	Shipfitter	61,983	6%
0003	Welder	82,487	8%
0003	Lagger	79,053	8%
0003	Painter	12,444	1%
0003	Rigger	39,977	4%
0003	Firewatch	4,000	0%
0003	Sheet Metal Technician	2,000	0%
0003	Shipwright	2,000	0%
0003	Helper/Laborer/Cleaner	137,750	13%
0003	Warehouseman	123,763	12%
0003	Material Handlers	2,023	0%
0003	Packing Specialist	2,057	0%
0003	General Foreman	2,252	0%
0003	Shop/Field Foreman	2,564	0%
0003	Driver	2,785	0%
0003	Fire Control Tech	559	0%

NOTES:

N0002418R4200 Attachment L-4 - Cost Proposal Format 20190618

CLIN 0004

FOTS MAINTENANCE SUPPORT (OCONUS-EG)									Composite Rate					Annual Hours					Annual Ceiling					CLIN Ceiling
CLIN	Labor Category Name	Cumulative Hours	Percentage of Total	Labor Category Rate (Y1)	Labor Category Rate (Y2)	Labor Category Rate (Y3)	Labor Category Rate (Y4)	Labor Category Rate (Y5)	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5
0004	Engineer	44,300	22%						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	40,420	40,420	40,420	40,420	40,420	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0004	Site Manager	10,000	5%
0004	Field Engineer	7,000	3%
0004	Helper/Laborer/Tank Cleaner	28,000	14%
0004	Lagger	12,000	6%
0004	Logistic Analyst	14,000	7%
0004	Marine Electrician	14,000	7%
0004	Marine Machinist	19,000	9%
0004	Welder	21,000	10%
0004	Pipefitter	3,000	1%
0004	Rigger	2,400	1%
0004	Shipfitter	2,400	1%
0004	Support Personnel	25,000	12%

NOTES:

N0002418R4200 Attachment L-4 - Cost Proposal Format 20190618

CLIN 0005

FOTS MAINTENANCE SUPPORT (OCONUS-PI)									Composite Rate					Annual Hours					Annual Ceiling					CLIN Ceiling
CLIN	Labor Category Name	Cumulative Hours	Percentage of Total	Labor Category Rate (Y1)	Labor Category Rate (Y2)	Labor Category Rate (Y3)	Labor Category Rate (Y4)	Labor Category Rate (Y5)	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5	Y1	Y2	Y3	Y4	Y5
0005	Site Mgr	3,086	3%						$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	20,000	20,000	20,000	20,000	20,000	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
0005	Engineer	200	0%
0005	Field Engineer	2,840	3%
0005	Marine Machinist	200	0%
0005	Rigger	220	0%
0005	Support Personnel	93,454	93%

NOTES:

N0002418R4200 Attachment L-4 - Cost Proposal Format 20190618

CLINS 0006 - 0008

Indirect Rate	CLIN 0006 MATERIALS
	Y1	Y2	Y3	Y4	Y5
Indirect Rate Category 1
Indirect Rate Category 2
Indirect Rate Category 3

Indirect Rate	CLIN 0007 ODCS
	Y1	Y2	Y3	Y4	Y5
Indirect Rate Category 1
Indirect Rate Category 2
Indirect Rate Category 3

Indirect Rate	CLIN 0008 TRAVEL
	Y1	Y2	Y3	Y4	Y5
Indirect Rate Category 1
Indirect Rate Category 2
Indirect Rate Category 3

N0002418R4200 Attachment L-4 - Cost Proposal Format 20190618

SUMMARY

SUMMARY COST PROPOSAL INFORMATION
CLIN	Fully Burdened RATE Y1	Fully Burdened RATE Y2	Fully Burdened RATE Y3	Fully Burdened RATE Y4	Fully Burdened RATE Y5	TOTAL	Ordering Period	Definition
0001 Composite Rate						$ - 0	Y1	Date of Award - 12 Months
0002 Composite Rate						$ - 0	Y2	12 months - 24 months
0003 Composite Rate						$ - 0	Y3	24 months - 36 months
0004 Composite Rate						$ - 0	Y4	36 months - 48 months
0005 Composite Rate						$ - 0	Y5	48 months - 60 months

CLIN 0006 Indirect Rate Category	Y1	Y2	Y3	Y4	Y5	CLIN	Estimated Hours
Profit						CLIN 0001	2,545,638
Indirect Rate Category 1						CLIN 0002	2,001,068
Indirect Rate Category 2						CLIN 0003	1,050,107
Indirect Rate Category 3						CLIN 0004	202,100
Indirect Rate Category 4						CLIN 0005	100,000
Indirect Rate Category 5

CLINS 0007 Indirect Rate Category	Y1	Y2	Y3	Y4	Y5
Indirect Rate Category 1
Indirect Rate Category 2
Indirect Rate Category 3
Indirect Rate Category 4
Indirect Rate Category 5

CLINS 0008 Indirect Rate Category	Y1	Y2	Y3	Y4	Y5
Indirect Rate Category 1
Indirect Rate Category 2
Indirect Rate Category 3
Indirect Rate Category 4
Indirect Rate Category 5

N0002418R4200 Attachment L-4 - Cost Proposal Format 20190618

File details come from the government source that posted it. Updated Dec 31, 2023.