Attachment_P3_-_Cost_Breakout_Spreadsheet.xls

XLS spreadsheet 266 KB Posted

Attached to
Atlantic Targets and Marine Operations Key West Support Services
Solicitation number
N00421-17-R-0022
Issued by

About this file

Updated Attachment P3-dated 28 February 2018

View the file

Other files

File Type Posted
Industry_Questions_Pt._4.pdf PDF
Industry_Questions_3-6-18.pdf PDF
WD_2015-0213_Rev_10.docx DOCX document
N00421-17-R-0022-Amendment_0002.docx DOCX document
Offeror_Questions_on_Attachment_P3.docx DOCX document
Attachment_P3_-_Cost_Breakout_Spreadsheet.xls XLS spreadsheet
Exhibit_A__CDRL_A001-A013.doc DOC document
N00421-17-R-0022-0001_Conformed.docx DOCX document
N00421-17-R-0022-Amendment_0001.docx DOCX document
Offeror_Question_4.docx DOCX document
Govt_responses_to_questions_on_RFP_N00421-17-R-0022.docx DOCX document
Attachment_3-_Peculiar_Maintenance_Equipment.xlsx XLSX spreadsheet
Attachment_8_-_Scheduled_GFP_(Excel).xlsx XLSX spreadsheet
Attachment_1_-_Surveillance_Activity_Checklist.doc DOC document
Attachment_7_-_SGFP_(PDF).pdf PDF
Attachment_5_-_RGFP_incorporated_pursuant_to_DFARS_245.103-72_(PDF).pdf PDF
Attachment_9_-_WD2015-4584_Rev_6.docx DOCX document
Attachment_11_-_COR_Designation_Form.docx DOCX document
Instructions_for_CPAQ_Rev_1.docx DOCX document
Attachment_2_-_DD254.pdf PDF
Attachment_6_-_RGFP_(XLSX).xlsx XLSX spreadsheet
Exhibit_A__CDRL_A001-A013.doc DOC document
Attachment_P1_-_Past_Performance_Information_Form.pdf PDF
Attachment_4-_Rolling_Stock_and_Deck_Equipment.xlsx XLSX spreadsheet
Attachment_10_-_WD2015-0213_Rev7.txt TXT text file
Attachment_P2_-_Contractor_Performance_Assessment_Questionnaire.pdf PDF
Attachment_P3_-_Prime_Cost_Breakout_Spreadsheet_1-31-18.xls XLS spreadsheet
N00421-17-R-0022_dated_31_Jan_2018.docx DOCX document
Show all 28

On GovTribe

Work with this file

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

Text version

Instructions for Tabs 1-5

Instructions
Contractor:
1The Contract Line Item Numbers (CLINs) at Cells I2, L2, O2, R2, and U2 have been included in Tabs 1-5. Please propose all labor costs in accordance with their Tab and associated CLIN. The labor categories and hours have been identified under their respective Tab and CLIN references. Tab 1 is for Regular Labor (CLINs 0001), Tab 2 for Overtime Costs (CLINs 0004 ), Tab 3 for costs associated with the NAWC-38 (CLIN 0007), Tab 4 is Reserved, and Tab 5 for costs associated with the Retriever (CLIN 0009). ODCs are located at the bottom of Tab 1 in accordance with the ODC cost estimates provided by the Government in Section L of the RFP. The base costs for each ODC listed in the RFP have been inserted into Tab 1. These ODCs are associated with CLINs 0010, 0013, 0016, 0017 and 0018. Offerors must input any indirect rates that apply to the base ODCs that have been entered in to Tab 1.
2On the Header Tab for each worksheet, insert the proposal number.
3On the Footer Tab for the worksheet, insert the firm's name and the RFP number.
4Tabs 1 -5. Columns I, L, O, R and U are columns that relate to each year of the ordring period. As an example, Column I represents the costs associated with Year 1 of the ordering period, Column L represent the costs associated with Year 2, etc.. The total proposed costs for each of those years is shown at the bottom of each of those columns.
5The worksheets of the workbook should all be formatted for printing on legal-size paper, without requiring "adjustments." The file shall be formatted for landscape.
6Within the work sheet any cell colored "blue" contains a formula and should not be edited, unless there is an error in the formula. It is the Contractor's responsibility to verify all formulas and to correct them, if necessary. The Government does not warrant that the formulas are correct.
7All dollar figures shall be carried out no further than two decimal places.
8Section B is structured so that one set of CLINs is used for the entire five year ordering period of the IDIQ contract. Some priced CLINs in Section B have two "NSP" CLINs listed right after the priced CLIN to account for the possibility of different types of funding used during execution of the contract and task order issuance. When the total dollar values associated with Tab 1 -5 are inserted into Section B, the dollar value shall only be applied to the priced CLIN. As an example, the Total Estimated Cost and Fixed Fee associated with Tab 1 (Regular Labor) should only be applied to CLIN 0001. CLINs 0002 and 0003 will remain NSP for purposes of Section B of the IDIQ contract so no dollar value shall be applied to those CLINs
9Tabs 1 through 5 - In column A, (starting at row 5), the Government Labor Categories from Section L of the RFP have been inserted. The Offeror shall insert their subcontractors (company's name) in this column for rows 29 to 45. In column B, the Offeror shall insert the title of the labor category it will be utilizing. This applies to the Prime Contractor's section and those sections for its subcontractors. If necessary, insert additional rows--but ensure integrity of formulas. The Offeror shall utilize the Government's labor categories as shown in Section L of the RFP. The Offeror's proposal will be compared to the required labor categories and hours as well as the ODC dollar values from Section L of the RFP. Labor categories with more than one person providing the service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with the name of the proposed individual (if current employee or contingent hire), and their proposed applicable rates, hrs, etc.
10Tabs 1-5 - In column C, the Offeror should insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing at a Government site. Based on the requirements in the RFP, it is anticpated that an overwhelming majority of the contractor personnel will be performing on a Government work site.
11Tabs 1-5 - In column D, for the prime contractor's own workforce, the field is colored "green" indicating no input. (This reflects that the prime contractor is proposing its own employees or contingency hires--it does not include any subcontractors.) For proposed subcontractors, their fields are in yellow. No input is required by the Offeror in this column. Please note if more subcontractors are being proposed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
12Tabs 1-5 - In column E, the prime contractor's own workforce, identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
13Tabs 1-5 - In column F, enter the name of the proposed individual for that position if a current employee or contingent hire is proposed.
14Tabs 1-5 - In columns G, J, M, P, and S in Tabs 1-5, provide the following:
(a) for the prime contractor, enter the unburdened labor rate for each proposed individual (e.g. rows 5-15)
(b) In row 18 the prime contractor shall insert its fringe rate for full time, if fringe is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. Note: Any indirect rate(s) that are required by an associated Wage Determination for SCA labor categories shall be utilized in the cost spreadsheet , if applicable.
(c) In row 19 the prime contractor shall insert its fringe rate for proposed part-time individuals (if applicable), 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 cell should also be left blank.
(d) In row 22, the prime contractor shall insert its Overhead rate for work performed at the contractor's facility, if applicable.
(e) In row 23, the prime contractor shall insert its Overhead rate for work performed at the Client/Government's facility.
(f) In row 25, the prime contractor shall insert its proposed G&A rate.
(g) In rows 29 to 45, the Offeror shall insert their subcontractors information including name of subcontractor, labor category being fulfilled by the subcontractor, the hours worked by the subcontractor and the fully burdened labor rate being proposed by the subcontractor.
(h) In row 47, the prime should insert the subcontractor handling charge/rate, if any.
(i) In row 51, the prime should insert the fixed fee rate applied to its proposed costs excluding subcontractor labor.
(j) In row 52, the prime should insert the proposed fixed fee rate it is applying to the subcontractor labor, if any. This is proposed Prime Fee on subcontractor labor costs.
15Tabs 1-5 - In columns H, K, N, Q, and T offerors shall in Tabs 1-5, provide the following:
(a) for the prime contractor, enter the hours associated with each individual labor category starting at row 5. For the subcontractor, enter the total hours associated with each subcontractor at row 29 - 45. The total number of proposed labor hours per labor category (prime plus any subs) must equal the total number of hours required for each CLIN provided in Section L of the RFP.
(b) In Cell H18, the prime contractor shall insert the base cost that its fringe rate for proposed full time personnel is being applied to, if fringe is not included in its Overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
(c) In Cell H19, the prime contractor should insert the base cost that its fringe rate for part time personnel 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.
(d) In Cell H22, the prime contractor should insert the base cost that its overhead rate is being applied to for work performed at the contractor's facility. If no work is proposed at the contractor's facility, the cell should be left blank.
(e) In Cell H23, the prime contractor should insert the base cost that its overhead rate is being applied to for work performed at the Client/Government's facility.
(f) In Cell H25, the prime contractor should insert the base cost that its G&A rate is being applied to.
(g) In Cell H51, the prime should insert the prime labor base that its fixed fee rate is being applied to (excluding subcontractor labor).
(h) In Cell H52, the prime should insert the subcontractor labor base its fixed fee rate is being applied to, if any.
(i) Under Other Direct Costs, the prime contractor should insert the Travel, Material, Dry Docking, Vessel Leasing, and ODCs by year as listed in Section L of the RFP.
16In row 70 enter the rate for material handling if it is being applied to ODCs. If material handling is not being proposed on ODCs, the cell should be left blank.
17In row 71 enter the rate for G&A if it is being applied to ODCs. If G&A on ODCs is not being proposed, the cell should be left blank.
18When submitting this file, the instructions may be deleted.
19Column V should automatically calculate the total dollars for all rows and is a summation of the costs spread across all 5 years of the order period.

Summary Tab

DO NOT TYPE IN ANY COLORED AREASYear 1Year 2Year 3Year 4Year 5Total $
CPFF
Services
CostsCostsCostsCostsCosts
Total Labor Costs from Tab 1 (Regular Labor (CLIN 0001))$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Costs from Tab 2 (Overtime - CLIN 0004)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Costs from Tab 3 (NAWC38 - CLIN 0007)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Costs from Tab 4 (Reserved)$ - 0
Total Labor Costs from Tab 5 (Retriever - CLIN 0009)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal Labor Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Fee (Tabs 1-5)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Cost Plus Fee/Profit$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs
Total ODC costs including burdens (CLINs 0010, 0013, 0016, 0017 and 0018)$ 2,556,543.00$ 2,671,589.00$ 7,705,219.00$ 2,826,276.00$ 2,922,369.00$ 18,681,996.00
Grand Total Services & ODC$ 2,556,543.00$ 2,671,589.00$ 7,705,219.00$ 2,826,276.00$ 2,922,369.00$ 18,681,996.00

Tab 1 Regular Labor CLIN 0001

DO NOT TYPE IN ANY COLORED AREASOrdering PeriodYear 1Year 2Year 3Year 4Year 5Total $
CPFF10 Nov 2018 - 09 Nov 2023CLINs0001CLINs0001CLINs0001CLINs0001CLINs0001
Services (Regular Labor)Contractorhrssubtotalhrssubtotalhrssubtotalhrssubtotalhrssubtotal
Government Labor CategoryProposed Categorysitesubf/pEmployee NameRateLaborRateLaborRateLaborRateLaborRateLabor
*Program Manager$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0
*Financial Analyst$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0
**Engineering Tech V$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0
**Engineering Tech IV$ - 03840$ - 0$ - 03840$ - 0$ - 03840$ - 0$ - 03840$ - 0$ - 03840$ - 0$ - 0
**Administrative Assistant$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0
** Operator$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0
**Materials Coordinator$ - 03840$ - 0$ - 03840$ - 0$ - 03840$ - 0$ - 03840$ - 0$ - 03840$ - 0$ - 0
**General Maintenance Worker$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
*Key Personnel
**Service Contract Act category
subtotal19200$ - 019200$ - 019200$ - 019200$ - 019200$ - 0$ - 0
fringe fulltime0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead
Contractor site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Subtotal Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontractorshrs$hrs$hrs$hrs$hrs$Total $
Sub: 1:
sub total on Sub 100000$ - 0
Sub: 2:
sub total on Sub 200000$ - 0
Sub: 3
sub total on Sub 300000$ - 0
Sub: 4:
sub total on Sub 400000$ - 0
Sub: 5:
sub total on Sub 500000$ - 0
Sub: 6:
sub total on Sub 600000$ - 0
Sub: 7
sub total on Sub 700000$ - 0
Sub: 8:
sub total on Sub 800000$ - 0
Total of all Subcontractors0$ - 00$ - 00$ - 00$ - 00$ - 0$ - 0
subcontractor handling0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor for Prime and Subcontractors$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit - prime0.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor costs0.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Subcontractor Cost Plus Fee/Profit19,200.0$ - 019,200.0$ - 019,200.0$ - 019,200.0$ - 019,200.0$ - 0$ - 0
Other Direct Costs
SubtotalSubtotalSubtotalSubtotalSubtotalSubtotal
(description)(description)(description)(description)(description)(description)
Material (CLIN 0010)$ 1,447,992.00$ 1,497,224.00$ 1,548,130.00$ 1,600,766.00$ 1,655,192.00$ 7,749,304.00
Travel (CLIN 0013)$ 62,416.00$ 64,538.00$ 66,733.00$ 69,002.00$ 71,348.00$ 334,037.00
Dry Docking (CLIN 0016)$ 800,000.00$ 855,324.00$ 5,827,200.00$ 884,405.00$ 914,475.00$ 9,281,404.00
Vessel Leasing (CLIN 0017)$ 125,000.00$ 129,250.00$ 133,644.00$ 138,188.00$ 142,886.00$ 668,968.00
ODCs (CLIN 0018)$ 121,135.00$ 125,253.00$ 129,512.00$ 133,915.00$ 138,468.00$ 648,283.00
ODC subtotal$ 2,556,543.00$ 2,671,589.00$ 7,705,219.00$ 2,826,276.00$ 2,922,369.00$ 18,681,996.00
material handling0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
G&A on ODC0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
Total ODC$ 2,556,543.00$ 2,671,589.00$ 7,705,219.00$ 2,826,276.00$ 2,922,369.00$ 18,681,996.00
Grand Total for Regular Labor CLIN 0001 & ODCs$ 2,556,543.00$ 2,671,589.00$ 7,705,219.00$ 2,826,276.00$ 2,922,369.00$ 18,681,996.00

&LAttachment_P6_CLIN_Breakout_Spreadsheet&R(insert proposal number) &A &LKTR:(insert name)&C Source Selection Information See: FAR 2.101 & 3.104&RRFP:N00421-11-R-0045 &L&F &R(insert proposal number) &A &LKTR:(insert name)&CSource Selection Information See: FAR 3.104&RRFP:N00024-09-R-3185

Tab 2 Overtime CLIN 0004

DO NOT TYPE IN ANY COLORED AREASOrdering PeriodYear 1Year 2Year 3Year 4Year 5Total $
CPFF10 Nov 2018 - 09 Nov 2023CLINs0004CLINs0004CLINs0004CLINs0004CLINs0004
Services (Overtime Hours)Contractorhrshrshrshrshrs
Government Labor CategoryProposed Categorysitesubf/pEmployee NameRateLaborRateLaborRateLaborRateLaborRateLabor
*Financial Analyst OT$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0
**Engineering Tech V OT$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0
**Engineering Tech IV OT$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0
**Administrative Assistant OT$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0
**Forklift Operator OT$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0
**Materials Coordinator OT$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0
**General Maintenance Worker OT$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0288$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
*Key Personnel
**Service Contract Act category
subtotal2016$ - 02016$ - 02016$ - 02016$ - 02016$ - 0$ - 0
fringe fulltime0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead
Contractor site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Subtotal Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontractorshrs$hrs$hrs$hrs$hrs$Total $
Sub: 1:
sub total on Sub 100000$ - 0
Sub: 2:
sub total on Sub 200000$ - 0
Sub: 3
sub total on Sub 300000$ - 0
Sub: 4:
sub total on Sub 400000$ - 0
Sub: 5:
sub total on Sub 500000$ - 0
Sub: 6:
sub total on Sub 600000$ - 0
Sub: 7
sub total on Sub 700000$ - 0
Sub: 8:
sub total on Sub 800000$ - 0
Total of all Subcontractors0$ - 00$ - 00$ - 00$ - 00$ - 0$ - 0
subcontractor handling0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor for Prime and Subcontractors$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit - prime0.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Subcontractor Cost Plus Fee/Profit2,016.0$ - 02,016.0$ - 02,016.0$ - 02,016.0$ - 02,016.0$ - 0$ - 0
Other Direct Costs
See tab (CPFF Regular Labor)SubtotalSubtotalSubtotalSubtotalSubtotalSubtotal
(description)(description)(description)(description)(description)(description)
ODC subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
material handling0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
G&A on ODC0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
Total ODC$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total for Overtime CLIN 0004$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Tab 3 NAWC-38 CLIN 0007)

DO NOT TYPE IN ANY COLORED AREASOrdering PeriodYear 1Year 2Year 3Year 4Year 5Total $
CPFF10 Nov 2018 - 09 Nov 2023CLIN0007CLIN0007CLIN0007CLIN0007CLIN0007
Services (NAWC-38)Contractordaysdaysdaysdaysdays
Government Labor CategoryProposed Categorysitesubf/pEmployee NameRateLaborRateLaborRateLaborRateLaborRateLabor
**General Vessel Assistant (Captain/Master)$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0
**General Vessel Assistant (Chief Engineer)$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0
**General Vessel Assistant (Assistant Engineer)$ - 0624$ - 0$ - 0624$ - 0$ - 0624$ - 0$ - 0624$ - 0$ - 0624$ - 0$ - 0
**General Vessel Assistant (Chief Mate)$ - 0624$ - 0$ - 0624$ - 0$ - 0624$ - 0$ - 0624$ - 0$ - 0624$ - 0$ - 0
**General Vessel Assistant (Bosn/Able Seaman)$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0
**General Vessel Assistant (Able Seaman)$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0
**General Vessel Assistant (Ordinary Seaman)$ - 0936$ - 0$ - 0936$ - 0$ - 0936$ - 0$ - 0936$ - 0$ - 0936$ - 0$ - 0
**General Vessel Assistant (Steward)$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0312$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
*Key Personnel
**Service Contract Act category
subtotal3744$ - 03744$ - 03744$ - 03744$ - 03744$ - 0$ - 0
fringe fulltime0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead
Contractor site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Subtotal Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontractors$$$$$Total $
Sub: 1:
sub total on Sub 100000$ - 0
Sub: 2:
sub total on Sub 200000$ - 0
Sub: 3
sub total on Sub 300000$ - 0
Sub: 4:
sub total on Sub 400000$ - 0
Sub: 5:
sub total on Sub 500000$ - 0
Sub: 6:
sub total on Sub 600000$ - 0
Sub: 7
sub total on Sub 700000$ - 0
Sub: 8:
sub total on Sub 800000$ - 0
Total of all Subcontractors0$ - 00$ - 00$ - 00$ - 00$ - 0$ - 0
subcontractor handling0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor for Prime and Subcontractors$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit - prime0.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Subcontractor Cost Plus Fee/Profit3,744.0$ - 03,744.0$ - 03,744.0$ - 03,744.0$ - 03,744.0$ - 0$ - 0
Other Direct Costs
See tab (CPFF Regular Labor)SubtotalSubtotalSubtotalSubtotalSubtotalSubtotal
(description)(description)(description)(description)(description)(description)
ODC subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
material handling0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
G&A on ODC0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
Total ODC$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total for NAWC-38 CLIN 0007$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Tab 4-Reserved No data entry on this sheet.

Tab 5 Retriever CLIN 0009

DO NOT TYPE IN ANY COLORED AREASOrdering PeriodYear 1Year 2Year 3Year 4Year 5Total $
CPFF10 Nov 2018 - 09 Nov 2023CLIN0009CLIN0009CLIN0009CLIN0009CLIN0009
Services (Retriever)Contractordaysdaysdaysdaysdays
Government Labor CategoryProposed Categorysitesubf/pEmployee NameRateLaborRateLaborRateLaborRateLaborRateLabor
**General Vessel Assistant (Captain/Master)$ - 0280$ - 0$ - 0280$ - 0$ - 0280$ - 0$ - 0280$ - 0$ - 0280$ - 0$ - 0
**General Vessel Assistant (Ordinary Seaman)$ - 0280$ - 0$ - 0280$ - 0$ - 0280$ - 0$ - 0280$ - 0$ - 0280$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
*Key Personnel
**Service Contract Act category
subtotal560$ - 0560$ - 0560$ - 0560$ - 0560$ - 0$ - 0
fringe fulltime0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
fringe part time0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead
Contractor site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Client site0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
COM0.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 0$ - 0
Subtotal Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontractors$$$$$Total $
Sub: 1:
sub total on Sub 100000$ - 0
Sub: 2:
sub total on Sub 200000$ - 0
Sub: 3
sub total on Sub 300000$ - 0
Sub: 4:
sub total on Sub 400000$ - 0
Sub: 5:
sub total on Sub 500000$ - 0
Sub: 6:
sub total on Sub 600000$ - 0
Sub: 7
sub total on Sub 700000$ - 0
Sub: 8:
sub total on Sub 800000$ - 0
Total of all Subcontractors0$ - 00$ - 00$ - 00$ - 00$ - 0$ - 0
subcontractor handling0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor for Prime and Subcontractors$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit - prime0.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0$ - 0
prime's fee/profit on subcontractor0.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 00.0%$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee/Profit Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor and Subcontractor Cost Plus Fee/Profit560.0$ - 0560.0$ - 0560.0$ - 0560.0$ - 0560.0$ - 0$ - 0
Other Direct Costs
See tab (CPFF Regular Labor)SubtotalSubtotalSubtotalSubtotalSubtotalSubtotal
(description)(description)(description)(description)(description)(description)
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ODC subtotal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
material handling0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
G&A on ODC0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0
Total ODC$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Grand Total for Retriever CLIN 0009$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Instructions for Tab 6 Instructions to Prime Contractors for completing Attachment P3, Tab 6 Fully Burdened Labor Rates N00421-15-R-0014

COLUMNCOLUMN HEADINGDESCRIPTION OF DATA UNDER THIS COLUMN HEADING
BProposed Labor Category (Furnished by Government)Enter the Proposed Labor Category, as recorded in the Prime or Subcontractor's accounting system, that correlates to each of the Government solication Labor Category on that row. Spell and format entry the same every time it is used on the template (for example, when it relates to the Prime Offeror's rates on one row and to a Subcontractor's rates on another row). If the Offeror determines that no personnel will be proposed to perform work defined by one of the Government Estimate Labor Categories listed, enter "NA".
CIndividual Designator*For each individual Contractor employee proposed; enter a different Identifing title in the form of FTE## (e.g. FTE01, FTE02, etc.) for each individual to distinguish them from one another. Do not enter the individual's name into the template; rather, provide that information separately in accordance with the requirements of NAVAIR Clause 5252.232-9529. Enter one FTE# for EACH indiviual proposed. (The number of FTE's must coordinate with the submitted P-3 for evaluation purposes.)
D-HProposed Fully-Burdened RatesEnter the Fully-Burdened Labor Price proposed for the applicable performance period (e.g. Base or Year_#) for personnel associated with the Proposed Labor Category. Enter numbers only, in U.S. Dollar format $###.## rounded to the nearest cent. Fully-Burdened Labor Rates shall include fringe, overhead, G&A, subcontractor pass-through rate, and fee on total cost, but should not include Fully-Burdened Other Direct Costs (ODCs) such as Materials, Travel, and Cost of Money costs.

Fully Burdened Rates (Tab 6)

ATTACHMENT P3Individual Designator*Proposed Fully Burdened RatesFully Burdened Functional Labor Rate Tripwire
Government Labor CategoryProposed Labor CategoryYear 1Year 2Year 3Year 4Year 5Year 1Year 2Year 3Year 4Year 5
*Program Manager$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
*Financial Analyst$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**Engineering Tech V$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**Engineering Tech IV$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**Administrative Assistant$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
** Operator$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**Materials Coordinator$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Maintenance Worker$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
OT Personnel
*Financial Analyst OT$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**Engineering Tech V OT$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**Engineering Tech IV OT$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**Administrative Assistant OT$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**Forklift Operator OT$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**Materials Coordinator OT$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Maintenance Worker OT$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
NAWC38
**General Vessel Assistant (Captain/Master)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Vessel Assistant (Chief Engineer)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Vessel Assistant (Assistant Engineer)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Vessel Assistant (Chief Mate)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Vessel Assistant (Bosn/Able Seaman)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Vessel Assistant (Able Seaman)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Vessel Assistant (Ordinary Seaman)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Vessel Assistant (Steward)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
Retriever
**General Vessel Assistant (Captain/Master)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00
**General Vessel Assistant (Ordinary Seaman)$300,000.00$300,000.00$300,000.00$300,000.00$300,000.00

&RAttachment P6 N00421-15-R-0014

File details come from the government source that posted it.