Att P4 SubCost Breakout Spreadsheet_.xlsx

XLSX spreadsheet 92 KB Posted

Attached to
Operational and Technical Support for Atlantic Target and Marine Operations (ATMO), Key West Detachment Federal contract opportunity
Solicitation number
N0042122R0185
Issued by
Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

This document provides an attachment template for a cost-plus-fixed-fee contract solicitation. The template includes instructions for contractors to provide a cost breakdown by labor category, rates, and hours for operational, logistics and technical services supporting the Naval Air Warfare Center - Aircraft Division Atlantic Targets and Marine Operations facility in Key West, Florida. Contractors must submit the completed template with direct labor rates, indirect rates including overhead and G&A, fee, and fully burdened labor rates for the base year and four option years. The template also requires contractors to provide an itemized cost breakdown for other direct costs including travel, materials, dry docking and vessel leasing.

View the file

Other files for this federal contract opportunity

Other files attached to Operational and Technical Support for Atlantic Target and Marine Operations (ATMO), Key West Detachment, newest first.
File Type Posted
N00421-22-R-0185 Amd 0002 Final RFP Responses.pdf PDF
N00421-22-R-0185 Amend. 0002 Conformed Copy (SF33).pdf PDF
N00421-22-R-0185 Amendment 0002 (SF30).pdf PDF
N00421-22-R-0185 Final RFP Responses.pdf PDF
Att P3 Cost Breakout Spreadsheet_v2.xlsx XLSX spreadsheet
N00421-22-R-0185 Amendment 0001.pdf PDF
Attachment 5_WD2015-4583-Rev21.pdf PDF
N00421-22-R-0185 Final RFP.pdf PDF
Attachment P1_Past Peformance Information Form.pdf PDF
Attachment 3_ Peculiar Maint Equip.xlsx XLSX spreadsheet
Attachment 2_DD254.pdf PDF
Attachment 4_ATMO Vessel Management Plan.pdf PDF
Attachment 1_Surveillance Activity Checklist (SAC).pdf PDF
Attachment P2_Contractor Performance Assessment Questionnaire (CPAQ).pdf PDF
Att P3 Cost Breakout Spreadsheet_.xlsx XLSX spreadsheet
Attachment 6_ WD2015-0213-Rev29.pdf PDF
Exhibit A_CDRLs A001-A012.pdf PDF
Show all 17

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

Text version

Instructions

Instructions

Contractor:
1On Header Tab the attachment file name should be automatically populated.
2On Footer Tab for the worksheet, insert the firm's name after colon.
3Every worksheet should have items 1 and 2 completed.
4The worksheets of the workbook should all be formatted for printing on legal-size paper, landscpe orientation, without requiring formatting adjustments.
5All dollar figures shall be carried out no further than two decimal places.
6Offerors shall NOT add additional worksheets/tabs to this workbook. Any additional tabs will not be evaluated. Additionally, links to outside workbooks will not be evaluated.
7All Direct rates must be entered per year and may only link to other worksheets as originally provided within this file to show escalation. If links are to worksheets that were not originally provided in the Governments template they will not be considered valid.
8Do not change the color shading or add shading to this template. Follow the format and ensure consistency as needed.
9In column A, starting at row 5, the Government labor category is provided. The Offeor shall begin to enter the rates proposed for each person addressing all labor categories. DO NOT DELETE UNUSED ROWS OR COLUMNS AS IT WILL IMPACT THE TOTAL COLUMNS AND ROWS. If necessary, you may insert additional rows to account for multiple rates/personnel in the same category--but ensure integrity of formulas through all tabs. Labor categories with more than one person providing the service shall be listed individually for each person performing work. For example, if the offeror proposes two people to perform one Administrative Assistant position, then the labor category Administrative Assistant shall be listed twice along with their applicable rates, hours, and any other information. Same goes for labor categories where there are multiple full-time equivalents.

*Key Personnel

10Labor Categories shall remain in order and like categories remain together within each offerors section. For example if the Offeror proposes 2 Administrative Assistants, they should be listed in consecutive rows.
11In column C, the Offeror should insert a "K" if the worker will be performing at the Contractor's facility, a KA for Contractor - Alternate site if the contractor will be using an "off-site" rate for personnel that will be working at another contractor's facility, or a "G" if it will be performing the work in Government spaces.
12In column D, the field is colored "green" indicating no input needed.
13In column E, identify for each individual proposed whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
14In column F, enter the name of the proposed individual for that position, if the individual is a prospective hire this shall be entered here.
15In column G:
16(a) enter the unburdened labor rate for each individual
17(b) In Cell G32 insert the offerors fringe rate for full time, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
18(c) In Cell G33 the offeror should insert its fringe rate for part-time, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. If no part-time employees are proposed this should also be left blank.
19(d) In Cell G36, the offeror should insert its overhead rate for work performed at the contractor's facility.
20(e) In Cell G37 the offeror should insert its overhead rate for work performed at the Client/Government's facility.
21(f) In Cell G39, theofferor should insert its indirect rate for the G&A rate being applied.
22(i) In Cell G88, the offeror should insert the fixed fee rate applied to its cost
23In column H, and then similarly for Columns J, L, and N:
24(a) enter the hours/days associated with individual labor category for CLIN XX00 (e.g., rows 5-29, 45-47, and so on). Also make sure you plug in the hours for columns J, L and N.
25(b) In Cell H32, insert the "labor base" the Offerors fringe rate for full time is being applied to, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
26(c) In Cell H33, insert the "labor base" the Offerors fringe rate for part time is being applied to, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
27(d) In Cell H36, insert the "labor base" the Offerors overhead rate is being applied to for work performed at the contractor's facility.
28(e) In Cell H37, insert the "labor base" the Offerors overhead rate is being applied to for work performed at the Client/Gov't site rate is being applied to
29(f) In Cell H39, insert the base the Offerors G&A rate is being applied to.
30(g) In Cell H48, insert the labor base the Offerors fixed fee rate is being applied to (excluding subcontractor labor).
31(i) In G61 and G62 the Prime shall enter its material handling and G&A rate that will be used on the Travel, Material and ODC by CLIN. If not applying a material handling, cell should be left blank.
32Column "Q" automatically calculates the total hours for all the CLINS.
33Column "H" automatically calculates the total days for all the CLINS.
34Column "T" is a summation of the costs.
35If there is not going to be any data entry in a row or group of rows, please just hide the rows. Do not delete.
36When submitting this file, the instructions tab may be deleted.
Fully Burdened CPFF Labor Rates Worksheet:
1In Column A, enter the Proposed Government Labor category for each proposed individual. Spell and format entries the same every time it is used on the template.
2In Column B, For each individual Contractor employee proposed; enter a different identifying title in the form of FTE## (e.g. FTE01, FTE02, etc.) for each individual to distinguish them from one another. Rows should be added to account for multiple FTEs at one location and/or FTEs at various locations. Do not enter the individual's name into the template.
3In Columns C-L, Enter the Annual Fully-Burdened Labor proposed for the applicable performance period (e.g. Base or Year_#) for personnel associated with the Proposed Labor Category and Individual Designator by linking back to the applicable performance period direct and indirect rates. This formula should show the Government how an Offeror develops its fully burdened rates in accordance with its disclosure statement so that the Government has a full understanding of how fully burdened rates were developed. The Government should be able to trace this formula back for each labor category for each period of performance. The first orange highlighted row is an EXAMPLE of the type of formula the Government expects to see here in accordance with an Offerors disclosure statement, and SHOULD BE DELETED prior to proposal submission. Offerors are expected to use a similar formula demonstrating how indirect rates are applied to each direct labor rate in order to formulate a fully burdened rate. Numbers should reflect U.S. Dollar format $###.## rounded to the nearest cent. Annual Fully-Burdened Labor shall include fringe, overhead, G&A, and fee on total cost, but should not include Fully-Burdened Other Direct Costs (ODCs) such as Materials, Travel, and Cost of Money costs. Annual Fully-Burdened Labor shall be the Fully-Burdened Labor Rate times the amount of hours proposed for the applicable performance period.

Base Year

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:CLINXXXXCLINXXXXCLINXXXXCLINXXXX
Services - PrimehrssubtotalhrssubtotalDayssubtotalDayssubtotalHrsDays
Government Labor CategoryLocationsitesubf/pEmployee NameRateLaborLabor - OTLabor - NAWC-38Labor - RetrieverSUMSUMTotal
Administrative Assistant$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Engineering Technichan II$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan III$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan V*$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Financial Analyst, Journeyman$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Materials Coordinator$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Program Manager, Journeyman*$ - 01920$ - 0$ - 0$ - 0$ - 01,920.0- 0$ - 0
General Vessel Asst (Captain)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Captain)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Chief Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Second Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Chief Engineer)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Bosn/Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Steward)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
subtotal17280$ - 0310$ - 03240$ - 0720$ - 017,590.03,960.0$ - 0
FringeBaseBaseBaseBase
fringe fulltime0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
OverheadBaseBaseBaseBase
Contractor site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0

Fee/Profit - prime 0.0% $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Fee/Profit Pool $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Cost Plus Fee/Profit17,280.0$ - 0310.0$ - 03,240.0$ - 0720.0$ - 017,590.03,960.0$ - 0
Other Direct CostsCLINXXXX - XXXX
Subtotal
SubtotalTotal
Travel$ - 0
Material$ - 0
Dry Docking$ - 0
Vessel Leasing$ - 0
ODC$ - 0
ODC subtotal$ - 0$ - 0
Material handling0.00%$ - 0$ - 0
G&A on ODC0.00%$ - 0$ - 0
Total ODC$ - 0$ - 0

Grand Total $ - 0

Attachment_P4_SubCost_Breakout_Spreadsheet (RFP# N00421-22-R-0185) &A

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104

Option Year 1

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:CLINXXXXCLINXXXXCLINXXXXCLINXXXX
Services - PrimehrssubtotalhrssubtotalDayssubtotalDayssubtotalHrsDays
Government Labor CategoryLocationsitesubf/pEmployee NameRateLaborLabor - OTLabor - NAWC-38Labor - RetrieverSUMSUMTotal
Administrative Assistant$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Engineering Technichan II$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan III$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan V*$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Financial Analyst, Journeyman$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Materials Coordinator$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Program Manager, Journeyman*$ - 01920$ - 0$ - 0$ - 0$ - 01,920.0- 0$ - 0
General Vessel Asst (Captain)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Captain)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Chief Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Second Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Chief Engineer)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Bosn/Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Steward)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
subtotal17280$ - 0310$ - 03240$ - 0720$ - 017,590.03,960.0$ - 0
FringeBaseBaseBaseBase
fringe fulltime0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
OverheadBaseBaseBaseBase
Contractor site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0
BaseBaseBaseBase
Fee/Profit - prime0.0%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Fee/Profit Pool $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Cost Plus Fee/Profit17,280.0$ - 0310.0$ - 03,240.0$ - 0720.0$ - 017,590.03,960.0$ - 0
Other Direct CostsCLINXXXX - XXXX
Subtotal
SubtotalTotal
Travel$ - 0
Material$ - 0
Dry Docking$ - 0
Vessel Leasing$ - 0
ODC$ - 0
ODC subtotal$ - 0$ - 0
Material handling0.00%$ - 0$ - 0
G&A on ODC0.00%$ - 0$ - 0
Total ODC$ - 0$ - 0

Grand Total $ - 0

Attachment_P4_SubCost_Breakout_Spreadsheet (RFP# N00421-22-R-0185)

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104

Option Year 2

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:CLINXXXXCLINXXXXCLINXXXXCLINXXXX
Services - PrimehrssubtotalhrssubtotalDayssubtotalDayssubtotalHrsDays
Government Labor CategoryLocationsitesubf/pEmployee NameRateLaborLabor - OTLabor - NAWC-38Labor - RetrieverSUMSUMTotal
Administrative Assistant$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Engineering Technichan II$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan III$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan V*$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Financial Analyst, Journeyman$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Materials Coordinator$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Program Manager, Journeyman*$ - 01920$ - 0$ - 0$ - 0$ - 01,920.0- 0$ - 0
General Vessel Asst (Captain)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Captain)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Chief Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Second Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Chief Engineer)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Bosn/Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Steward)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
subtotal17280$ - 0310$ - 03240$ - 0720$ - 017,590.03,960.0$ - 0
FringeBaseBaseBaseBase
fringe fulltime0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
OverheadBaseBaseBaseBase
Contractor site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0
BaseBaseBaseBase
Fee/Profit - prime0.0%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.0%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Cost Plus Fee/Profit17,280.0$ - 0310.0$ - 03,240.0$ - 0720.0$ - 017,590.03,960.0$ - 0
Other Direct CostsCLINXXXX - XXXX
Subtotal
SubtotalTotal
Travel$ - 0
Material$ - 0
Dry Docking$ - 0
Vessel Leasing$ - 0
ODC$ - 0
ODC subtotal$ - 0$ - 0
Material handling0.00%$ - 0$ - 0
G&A on ODC0.00%$ - 0$ - 0
Total ODC$ - 0$ - 0

Grand Total $ - 0

Attachment_P4_SubCost_Breakout_Spreadsheet (RFP# N00421-22-R-0185)

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104

Option Year 3

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:CLINXXXXCLINXXXXCLINXXXXCLINXXXX
Services - PrimehrssubtotalhrssubtotalDayssubtotalDayssubtotalHrsDays
Government Labor CategoryLocationsitesubf/pEmployee NameRateLaborLabor - OTLabor - NAWC-38Labor - RetrieverSUMSUMTotal
Administrative Assistant$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Engineering Technichan II$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan III$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan V*$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Financial Analyst, Journeyman$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Materials Coordinator$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Program Manage, Journeymanr*$ - 01920$ - 0$ - 0$ - 0$ - 01,920.0- 0$ - 0
General Vessel Asst (Captain)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Captain)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Chief Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Second Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Chief Engineer)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Bosn/Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Steward)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
subtotal17280$ - 0310$ - 03240$ - 0720$ - 017,590.03,960.0$ - 0
FringeBaseBaseBaseBase
fringe fulltime0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
OverheadBaseBaseBaseBase
Contractor site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0
BaseBaseBaseBase
Fee/Profit - prime0.0%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.0%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Cost Plus Fee/Profit17,280.0$ - 0310.0$ - 03,240.0$ - 0720.0$ - 017,590.03,960.0$ - 0
Other Direct CostsCLINXXXX - XXXX
Subtotal
SubtotalTotal
Travel$ - 0
Material$ - 0
Dry Docking$ - 0
Vessel Leasing$ - 0
ODC$ - 0
ODC subtotal$ - 0$ - 0
Material handling0.00%$ - 0$ - 0
G&A on ODC0.00%$ - 0$ - 0
Total ODC$ - 0$ - 0

Grand Total $ - 0

Attachment_P4_SubCost_Breakout_Spreadsheet (RFP# N00421-22-R-0185)

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104

Option Year 4

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:CLINXXXXCLINXXXXCLINXXXXCLINXXXX
Services - PrimehrssubtotalhrssubtotalDayssubtotalDayssubtotalHrsDays
Government Labor CategoryLocationsitesubf/pEmployee NameRateLaborLabor - OTLabor - NAWC-38Labor - RetrieverSUMSUMTotal
Administrative Assistant$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Engineering Technichan II$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan III$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan IV$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Engineering Technichan V*$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Financial Analyst, Journeyman$ - 01920$ - 05$ - 0$ - 0$ - 01,925.0- 0$ - 0
Materials Coordinator$ - 01920$ - 050$ - 0$ - 0$ - 01,970.0- 0$ - 0
Program Manager, Journeyman*$ - 01920$ - 0$ - 0$ - 0$ - 01,920.0- 0$ - 0
General Vessel Asst (Captain)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Captain)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Chief Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Second Mate)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Chief Engineer)*$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Asst Engineer)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Bosn/Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Able Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 060$ - 0$ - 0- 060.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Ordinary Seaman)$ - 0$ - 0$ - 0$ - 060$ - 0- 060.0$ - 0
General Vessel Asst (Steward)$ - 0$ - 0$ - 0312$ - 0$ - 0- 0312.0$ - 0
subtotal17280$ - 0310$ - 03240$ - 0720$ - 017,590.03,960.0$ - 0
FringeBaseBaseBaseBase
fringe fulltime0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
OverheadBaseBaseBaseBase
Contractor site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0
BaseBaseBaseBase
Fee/Profit - prime0.0%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.0%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Cost Plus Fee/Profit17,280.0$ - 0310.0$ - 03,240.0$ - 0720.0$ - 017,590.03,960.0$ - 0
Other Direct CostsCLINXXXX - XXXX
Subtotal
SubtotalTotal
Travel$ - 0
Material$ - 0
Dry Docking$ - 0
Vessel Leasing$ - 0
ODC$ - 0
ODC subtotal$ - 0$ - 0
Material handling0.00%$ - 0$ - 0
G&A on ODC0.00%$ - 0$ - 0
Total ODC$ - 0$ - 0

Grand Total $ - 0

Attachment_P4_SubCost_Breakout_Spreadsheet (RFP# N00421-22-R-0185)

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104

Summary

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:CLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXXCLINXXXX-XXXX
Services - PrimehrssubtotalhrssubtotalDayssubtotalDayssubtotalHrsDays
Government Labor CategoryLocationsitesubf/pEmployee NameRateLaborLabor - OTLabor - NAWC-38Labor - RetrieverSUMSUMTotal
Administrative Assistant9600$ - 025$ - 00$ - 00$ - 09,625.0- 0$ - 0
Engineering Technichan II9600$ - 0250$ - 00$ - 00$ - 09,850.0- 0$ - 0
Engineering Technichan III9600$ - 0250$ - 00$ - 00$ - 09,850.0- 0$ - 0
Engineering Technichan IV9600$ - 0250$ - 00$ - 00$ - 09,850.0- 0$ - 0
Engineering Technichan IV9600$ - 0250$ - 00$ - 00$ - 09,850.0- 0$ - 0
Engineering Technichan V*9600$ - 0250$ - 00$ - 00$ - 09,850.0- 0$ - 0
Financial Analyst, Journeyman9600$ - 025$ - 00$ - 00$ - 09,625.0- 0$ - 0
Materials Coordinator9600$ - 0250$ - 00$ - 00$ - 09,850.0- 0$ - 0
Program Manager, Journeyman*9600$ - 00$ - 00$ - 00$ - 09,600.0- 0$ - 0
General Vessel Asst (Captain)*0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
General Vessel Asst (Captain)0$ - 00$ - 00$ - 01500$ - 0- 01,500.0$ - 0
General Vessel Asst (Chief Mate)0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
General Vessel Asst (Second Mate)0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
General Vessel Asst (Chief Engineer)*0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
General Vessel Asst (Asst Engineer)0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
General Vessel Asst (Asst Engineer)0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
General Vessel Asst (Asst Engineer)0$ - 00$ - 00$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Bosn/Able Seaman)0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
General Vessel Asst (Able Seaman)0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
General Vessel Asst (Ordinary Seaman)0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
General Vessel Asst (Ordinary Seaman)0$ - 00$ - 0300$ - 00$ - 0- 0300.0$ - 0
General Vessel Asst (Ordinary Seaman)0$ - 00$ - 0300$ - 00$ - 0- 0300.0$ - 0
General Vessel Asst (Ordinary Seaman)0$ - 00$ - 00$ - 01500$ - 0- 01,500.0$ - 0
General Vessel Asst (Ordinary Seaman)0$ - 00$ - 00$ - 0300$ - 0- 0300.0$ - 0
General Vessel Asst (Steward)0$ - 00$ - 01560$ - 00$ - 0- 01,560.0$ - 0
subtotal86400$ - 01550$ - 016200$ - 03600$ - 087,950.019,800.0$ - 0
Fringe
fringe fulltime$ - 0$ - 0$ - 0$ - 0$ - 0
fringe part time$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead
Contractor site$ - 0$ - 0$ - 0$ - 0$ - 0
Client site$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
G&A$ - 0$ - 0$ - 0$ - 0$ - 0
COM$ - 0$ - 0$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0
Fee/Profit - prime$ - 0$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor$ - 0$ - 0$ - 0$ - 0`
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Cost Plus Fee/Profit86,400.0$ - 01,550.0$ - 016,200.0$ - 03,600.0$ - 087,950.019,800.0$ - 0
Other Direct CostsCLINXXXX - XXXX
Subtotal
Total
Travel$ - 0$ - 0
Material$ - 0$ - 0
Dry Docking$ - 0$ - 0
Vessel Leasing$ - 0$ - 0
ODC$ - 0$ - 0
ODC subtotal$ - 0$ - 0
Material handling$ - 0$ - 0
G&A on ODC$ - 0$ - 0
Total ODC$ - 0$ - 0

Grand Total $ - 0

Attachment_P4_SubCost_Breakout_Spreadsheet (RFP# N00421-22-R-0185)

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104

Fully Burdened CPFF Labor Rates

ATTACHMENT P3Individual Designator*Proposed Fully Burdened Rates
Proposed Labor CategoryBaseYear 1Year 2Year 3Year 4
EXAMPLE TO BE DELETED: Adminstrative AssistantFTE01$0.00$0.00$0.00$0.00$0.00
Administrative Assistant
Engineering Technichan II
Engineering Technichan III
Engineering Technichan IV
Engineering Technichan IV
Engineering Technichan V*
Financial Analyst, Journeyman
Materials Coordinator
Program Manager, Journeyman*
General Vessel Asst (Captain)*
General Vessel Asst (Captain)
General Vessel Asst (Chief Mate)
General Vessel Asst (Second Mate)
General Vessel Asst (Chief Engineer)*
General Vessel Asst (Asst Engineer)
General Vessel Asst (Asst Engineer)
General Vessel Asst (Asst Engineer)
General Vessel Asst (Bosn/Able Seaman)
General Vessel Asst (Able Seaman)
General Vessel Asst (Ordinary Seaman)
General Vessel Asst (Ordinary Seaman)
General Vessel Asst (Ordinary Seaman)
General Vessel Asst (Ordinary Seaman)
General Vessel Asst (Ordinary Seaman)
General Vessel Asst (Steward)

Attachment_P4_SubCost_Breakout_Spreadsheet (RFP# N00421-22-R-0185)

KTR:(insert name) Source Selection Information See: FAR 2.101 & 3.104

File details come from the government source that posted it. Updated .