Attachment_10_Cost_Summary.xls

XLS spreadsheet 171 KB Posted

Attached to
N00253-18-R-0002 Amendment 0004
Solicitation number
N00253-17-R-0002
Issued by

About this file

Attachment 10 Cost Summary - changes incorporated

View the file

Other files

File Type Posted
Attachment_12_NAVSEA_Pre-Award_Accounting_System_Adequacy_Checklist.docx DOCX document
Attachment_10_Cost_Summary_(Amendment_0004).xls XLS spreadsheet
N00253-18-R-0002_Amendment_0004.pdf PDF
Attachment_10_Cost_Summary_(Amendment_0003).xls XLS spreadsheet
N00253-18-R-0002_Amendment_0003.pdf PDF
Attachment_10_Cost_Summary_(Amendment_0002).xls XLS spreadsheet
N00253-18-R-0002_Amendment_0002.pdf PDF
N00253-18-R-0002_Amendment_0001.pdf PDF
Attachment_4_Labor_Hour_Breakdown_(Amendment_0001).xls XLS spreadsheet
Attachment_3_Clause_Applicability_Matrix_(Amendment_0001).pdf PDF
Attachment_10_Cost_Summary_(Amendment_0001).xls XLS spreadsheet
Attachment_8_Past_Performance_Questionnaire.docx DOCX document
Attachment_11_BYG-1_TI-APB_USN_Build_Schedule.pptx PPTX presentation
Attachment_5_Government_Furnished_Information_(NAVSEA_Form_4340-2).pdf PDF
Attachment_7_Standard_Labor_Category_Descriptions.pdf PDF
N00253-18-R-0002_RFP.pdf PDF
Attachment_1_SOW.pdf PDF
Exhibit_B_CDRL_B001.pdf PDF
Attachment_9_Small_Business_Participation_Commitment_Document.docx DOCX document
Q&A_Regarding_Draft_RFP.pdf PDF
Attachment_3_Clause_Applicability_Matrix.pdf PDF
Exhibit_C_CDRL_C001.pdf PDF
Attachment_4_Labor_Hour_Breakdown.xls XLS spreadsheet
Attachment_2_DD254.pdf PDF
Attachment_6_Consolidated_GFP_Attachment_v1.0.pdf PDF
Exhibit_A_CDRL_A001_-_A036.pdf PDF
N00253-18-R-0002_RFP_DRAFT.pdf PDF
Attachment_3_Clause_Applicability_Matrix.pdf PDF
Attachment_6_Consolidated_GFP_Attachment_v1.0.pdf PDF
Attachment_2_DD254.pdf PDF
Attachment_5_Government_Furnished_Information_(NAVSEA_Form_4340-2).pdf PDF
Attachment_7_Standard_Labor_Category_Descriptions.pdf PDF
Attachment_11_BYG-1_TI-APB_USN_Build_Schedule.pdf PDF
Attachment_4_Labor_Hour_Breakdown.xls XLS spreadsheet
Exhibit_B_CDRL_B001.pdf PDF
Attachment_8_Past_Performance_Questionnaire.docx DOCX document
Attachment_9_Small_Business_Participation_Commitment_Document.docx DOCX document
Attachment_1_SOW-DRAFT.pdf PDF
Exhibit_C_CDRL_C001.pdf PDF
Show all 39

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

Wkst 10A ST 1, 2 (LOE) Scope of the information for this worksheet: Sample Tasks 1 and 2 for TI-20.

Complete a separate worksheet for each Sample Task and each contract year of performance where cost and/or hours are proposed. Offeror is to identify its own specific labor categories. If the Offeror’s titles and job descriptions differ from Attachment 7, Standard Labor Category Descriptions, the Offeror shall provide the company’s equivalent titles and description in a cross-referenced matrix. Offeror to complete all GREEN cells.

See Section L, Table L-3, Hours for Sample Task 1, and Table L-4, Hours for Sample Task 2.

Offeror's Company Name: _______________________________________________________________________________
Subcontractor Submitting Directly to Government to identify the Prime Company: ______________________________________
Sample Task: __________Contract Year of Performance (e.g. 1, 2, 3, etc.): __________
Prime Contractor Direct LaborHoursHourly RateAmount*
Labor Category (e.g. Program Manager)$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
(Insert labor category lines as necessary)$ - 0
Prime Contractor Direct Labor Subtotal- 0$0
Prime Contractor Indirect Labor CostsRateAmount*
Overhead (O/H) (%)
Fringe Benefits (%)
General & Administrative (G&A) (%)
(Insert lines as necessary)
Prime Contractor Indirect Labor Subtotal$0
Prime Contractor Labor Total (Direct and Indirect)$0
Prime Contractor Facilities Capital Cost of Money (FCCOM)
PRIME CONTRACTOR TOTAL LABOR COST

(Direct, Indirect, FCCOM)

SUBCONTRACTOR 1 : INSERT NAME
Direct LaborHoursHourly RateAmount*
Subcontractor labor category$ - 0
Subcontractor labor category$ - 0
(Insert lines as necessary)$ - 0
Direct Labor Subtotal- 0$ - 0
Indirect Labor CostsRateAmount*
Overhead (O/H)
Fringe Benefits
General & Administrative (G&A)
(Insert lines as necessary)
Indirect Labor Subtotal$0
TOTAL SUBCONTRACOT LABOR COST
(Direct and Indirect)$ - 0
Insert additional Subcontractors as needed. Use the same format as shown above (Subcontractor 1).
TOTAL LABOR HOURS & COST

(PRIME & ALL SUBCONTRACTORS)

RateAmount*
Target Cost (a)
Target Cost Hourly Rate (Composite Rate)$ - 0
Target Cost less Cost of Money$0
Target Fee % (b)$ - 0
TOTAL TARGET COST PLUS TARGET FEE$ - 0
Max Fee % (c)$ - 0
*Rounded to nearest whole dollar.
NOTES:

(a) Target Cost consists of Prime and Subcontractor Total Labor Costs (including FCCOM).

(b) The Offeror shall identify a Target Fee percentage between 0% and 6%, which is contractually binding. This fee percentage shall be applied to Target Cost less FCCOM. The fee percentage identified in this worksheet must match the fee percentage identified in Worksheet 10D, LOE Rates.

(c) The Offeror shall identify a Maximum Fee percentage not to exceed 10%. Fee percentage is contractually binding. Fee percentage shall be applied to Target Cost less FCCOM. The fee percentages identified in this worksheet must match the fee percentages identified in Worksheet 10D, LOE Rates.

&LN00253-18-R-0002&C&"Times New Roman,Regular"Section J - Attachment 10, Cost Summary &A &C&"Times New Roman,Regular"Page &P of &N

Wkst 10B ST 3 (Production) Scope of the information for this worksheet: Sample Task 3 for TI-20 and TI-22.

The Offer shall complete a separate Worksheet 10B, Sample Task 3 (Production), for a quantity of one (1) each, for every FY20 shipset variant for TI-20 and for every FY22 shipset variant for TI-22 identified in Worksheet 10G (total of twenty-two (22) worksheets). The Target Cost for one (1) each on Worksheet 10B must match the stepladder unit price for 1 each in TI-20 (FY20) and TI-22 (FY22) on Worksheet 10G.

Offeror is to identify its own specific labor categories. If the Offeror’s titles and job descriptions differ from Attachment 7, Standard Labor Category Descriptions, the Offeror shall provide the company’s equivalent titles and description in a cross-referenced matrix. Offeror to complete all GREEN cells.

Offeror's Company Name: ____________________________________________________________________________
Subcontractor Submitting Directly to Government to identify the Prime Company: ______________________________________
Sample Task: 3 Contract Performance Year: 1Variant: _______________________________________
Prime Contractor Direct LaborHoursHourly RateAmount*
Labor Category (e.g. Program Manager)$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
(Insert lines as necessary)$ - 0
Prime Contractor Direct Labor Subtotal- 0$0
Prime Contractor Indirect Labor CostsRateAmount*
Overhead (O/H) (%)
Fringe Benefits (%)
General & Administrative (G&A) (%)
(Insert lines as necessary)
Prime Contractor Indirect Labor Subtotal$0
Prime Contractor Labor Total (Direct and Indirect)$0
Prime Contractor Facilities Capital Cost of Money (FCCOM)
Prime Contractor Labor Total (Direct, Indirect, FCCOM)$0
Prime Material Costs (a)RateMaterial CostAmount*
Prime Material Overhead Costs$ - 0
Prime Material Total (Cost and Overhead)$ - 0
PRIME CONTRACTOR TOTAL COST
(Direct, Indirect, FCCOM, Material)$0
SUBCONTRACTOR 1 : INSERT NAME
Direct LaborHoursHourly RateAmount*
Subcontractor labor category$ - 0
Subcontractor labor category$ - 0
(Insert lines as necessary)$ - 0
Direct Labor Subtotal- 0$ - 0
Indirect Labor CostsRateAmount*
Overhead (O/H) (%)
Fringe Benefits (%)
General & Administrative (G&A) (%)
(Insert lines as necessary)
Indirect Labor Subtotal$ - 0
Labor Total (Direct and Indirect)$ - 0
Material Costs (a)RateMaterial CostAmount*
Material Overhead Costs$ - 0
Material Total (Cost and Overhead)$ - 0
Subcontractor Costs Subtotal (Direct, Indirect, Material)$ - 0
Profit/Fee (%)
SUBCONTRACTOR TOTAL COST

(Direct, Indirect, Material, Profit/Fee)

Insert additional Subcontractors as needed. Use the same format as shown above (Subcontractor 1).
TOTAL OF ALL SUBCONTRACTORS
Target Cost (b)
Target Fee % (c)- 0
TOTAL TARGET COST PLUS TARGET FEE- 0
*Rounded to nearest whole dollar.
NOTES:

(a) Offeror shall provide its individual BOMs using Worksheet 10C, Sample Task 3 Bill of Materials.

(b) Target Cost consists of Prime and Subcontractor Total Cost (including FCCOM). The Target Cost must match the TI-20 FY20 and TI-22 FY22 stepladder prices for the quantity 1 each on Worksheet 10G.

(c) The Offeror shall identify a Target Fee percentage between 0% and 6%, which is contractually binding. Fee percentage shall be applied to Target Cost less FCCOM. The fee percentage identified in this worksheet must match the fee percentage identified in Worksheet 10E, Production Rates.

&LN00253-18-R-0002&CSection J - Attachment 10, Cost Summary &A &CPage &P of &N

Wkst 10C ST 3 BOM

Offeror to complete all GREEN cells.
#DescriptionManufacturerMfr Part NumberQuantityUnit PriceExtended PriceDelivery Lead Time
1$ - 0
2$ - 0
3$ - 0
4$ - 0
5$ - 0
6$ - 0
7$ - 0
8$ - 0
9$ - 0
10$ - 0
11$ - 0
12$ - 0
13$ - 0
14$ - 0
15$ - 0
16$ - 0
17$ - 0
18$ - 0
19$ - 0
20$ - 0
21$ - 0
22$ - 0
23$ - 0
24$ - 0
25$ - 0
26$ - 0
27$ - 0
28$ - 0
29$ - 0
30$ - 0
31$ - 0
32$ - 0
33$ - 0
34$ - 0
35$ - 0
36$ - 0
37$ - 0
38$ - 0
39$ - 0
40$ - 0
41$ - 0
42$ - 0
43$ - 0
44$ - 0
45$ - 0
46$ - 0
47$ - 0
48$ - 0
49$ - 0
50$ - 0
51$ - 0
52$ - 0
53$ - 0
54$ - 0
55$ - 0
56$ - 0
Insert lines as necessary$ - 0
SAMPLE TASK 3 TOTAL (80% Cost Drivers) MATERIAL:$ - 0

&L&"Times New Roman,Regular"N00253-18-R-0002&C&"Times New Roman,Regular"Section J - Attachment 10, Cost Summary &A &CPage &P of &N

Wkst 10D LOE Rates

Offeror to complete all GREEN cells.
CLINMaximum Hours (Section B)Target Cost Hourly Rate (Composite)1Target Cost2Cost of MoneyTarget Fee Hourly Rate3Target Fee4 (%) ≤ 6%Target Fee5 ($)Total Target Cost plus Target Fee Hourly Rate6Total Target Cost plus Target FeeMin Fee (%)Max Fee (%) ≤ 10%
Example10,000$ 100.00$ 1,000,0000.0014$ 5.005.0%$ 50,000$ 105.00$ 1,050,0000.0%8.0%
0001172,280$ - 0$ - 0$ - 0$ - 0$ - 00.0%
0002193,723$ - 0$ - 0$ - 0$ - 0$ - 00.0%
0003257,657$ - 0$ - 0$ - 0$ - 0$ - 00.0%
0004131,546$ - 0$ - 0$ - 0$ - 0$ - 00.0%
000524,478$ - 0$ - 0$ - 0$ - 0$ - 00.0%
000934,754$ - 0$ - 0$ - 0$ - 0$ - 00.0%
001036,619$ - 0$ - 0$ - 0$ - 0$ - 00.0%
001128,869$ - 0$ - 0$ - 0$ - 0$ - 00.0%
001216,879$ - 0$ - 0$ - 0$ - 0$ - 00.0%
00131,499$ - 0$ - 0$ - 0$ - 0$ - 00.0%
100128,629$ - 0$ - 0$ - 0$ - 0$ - 00.0%
1002148,339$ - 0$ - 0$ - 0$ - 0$ - 00.0%
1003220,298$ - 0$ - 0$ - 0$ - 0$ - 00.0%
1004156,849$ - 0$ - 0$ - 0$ - 0$ - 00.0%
1005106,623$ - 0$ - 0$ - 0$ - 0$ - 00.0%
10093,208$ - 0$ - 0$ - 0$ - 0$ - 00.0%
101019,034$ - 0$ - 0$ - 0$ - 0$ - 00.0%
101113,487$ - 0$ - 0$ - 0$ - 0$ - 00.0%
101213,386$ - 0$ - 0$ - 0$ - 0$ - 00.0%
101311,505$ - 0$ - 0$ - 0$ - 0$ - 00.0%
10176,164$ - 0$ - 0$ - 0$ - 0$ - 00.0%
10187,763$ - 0$ - 0$ - 0$ - 0$ - 00.0%
10197,358$ - 0$ - 0$ - 0$ - 0$ - 00.0%
102022,105$ - 0$ - 0$ - 0$ - 0$ - 00.0%
10212,658$ - 0$ - 0$ - 0$ - 0$ - 00.0%
NOTES:

1. Target Cost Hourly Rate (Composite Rate) is derived using Worksheet 10A, Sample Task 2 (LOE). This rate includes all Subcontractor costs and FCCOM. This Target Cost Hourly Rate is contractually binding.

2. Target Cost is calculated by multiplying Maximum Hours (Section B) by Target Cost Hourly Rate.

3. Target Fee Hourly Rate is calculated by dividing Target Fee by Maximum Hours (Section B). This fee excludes FCCOM.

4. Target Fee Percentage must match the Target Fee Percentage identified on Worksheet 10A.

5. Target Fee is calculated by multiplying Target Cost (excluding FCCOM) by Target Fee Percentage.

6. Total Target Cost plus Target Fee Hourly Rate is calculated by adding Target Cost Hourly Rate and Target Fee Hourly Rate.

&LN00253-18-R-0002&CSection J - Attachment 10, Cost Summary &A &CPage &P of &N

Wkst 10E Production CPIF

Offeror to complete all GREEN cells.
Rate DescriptionProposed

Incentive Fee

Target Fee (%) - Not to exceed 6%
Minimum Fee (%) - Government Established0.0%
Maximum Fee (%) - Not to exceed 10%
Note: The fee percentages proposed above are contractually binding for all contract performance years.
Production CLINs CPIF
CLINs
(Production, Surge & Spares)Target Cost
(Section B)Target Fee ($)
(AutoCalc)Total Target Cost

+ Target Fee (AutoCalc) Maximum Fee (AutoCalc)

0008$ 328,021,998$ - 0$ 328,021,998$ -0
0016$ 38,647,897$ - 0$ 38,647,897$ -0
1008$ 304,113,306$ - 0$ 304,113,306$ -0
1016$ 19,750,682$ - 0$ 19,750,682$ -0
1024$ 14,252,837$ - 0$ 14,252,837$ -0
$ - 0$ 704,786,720$ -0

&LN00253-18-R-0002&CSection J - Attachment 10 Cost Summary &A &CPage &P of &N

Wkst 10F FF & Indirect Rates

Offeror to complete all GREEN cells.
INDIRECT RATES
Rate DescriptionYear 1Year 2Year 3Year 4Year 5Year 6Year 7
Overhead
Fringe
General & Administrative
Facilities Capital Cost of Money
Subcontractor Handling Fee
Material Handling Fee
Insert lines as necessary
NOTES:

(a) The columns identified by "Year #" represent contract year of performance.

(b) Unless otherwise specified, the rates proposed in this Worksheet apply to all CLINs.

FIXED FEE
CLINs
(Non-Production Material)Max Cost
(Section B)Fixed Fee (%) ≤ 5%Fixed Fee ($)
(AutoCalc)Max Cost + Fixed Fee

(AutoCalc)

0006$ 10,749,172$ - 0$ 10,749,172
0014$ 2,972,915$ - 0$ 2,972,915
1006$ 12,759,112$ - 0$ 12,759,112
1014$ 1,519,283$ - 0$ 1,519,283
1022$ 1,096,372$ - 0$ 1,096,372
$ 29,096,854$ - 0$ 29,096,854

&LN00253-18-R-0002&CSection J - Attachment 10, Cost Summary Wkst 10F Fixed Fee and Indirect Rates &CPage &P of &N

Wkst10G ShipsetStepladderPrices Scope of the information for this worksheet: Sample Task 3 for TI-20 and TI-22.

The unit price for a quantity of 1 each for each TI-20 variant in FY20 and TI-22 variant in FY22 on this Worksheet must match the associated Worksheet 10B Target Cost. The unit prices herein reflect COST only; the applicable incentive fee will be applied at the time the order is placed. The Offeror must complete all GREEN cells.

The unit prices proposed herein are contractually binding for use during contract performance to place orders under all the Production, Surge, & Spares CLINs

Based on the significant commonality of components between variants, the economic order quantity at time of delivery order placement will reflect the cumulative quantity of all variants ordered. For example, assume the following stepladder pricing and incentive fee:
VA TI-10 to TI-20

Unit Price 1 each is $50 Unit Price 2-3 each is $45 Unit Price 4+ is $40 VA TI-14 to TI-20 Unit Price 1 each is $48 Unit Price 2-3 each is $43 Unit Price 4+ is $38 NEWCON COLUMBIA Unit Price 1 each is $49 Unit Price 2-3 each is $44 Unit Price 4+ is $39 Incentive Fee (from Wkst 10E):

5.0% Based on the assumed pricing and fee, a single delivery order for the following shipsets is priced as shown below based on the cummulative quantity of 3 each:

1 each VA TI-10 to TI-20 @ $45 each 1 each VA TI-14 to TI-20 @ $43 each 1 each NEWCON COLUMBIA @ $44 each Target Cost: $132.00 + Target Fee: $6.60 Total Target Cost Plus Fee: $138.60

TI-20 BYG-1
TI-20 Variants & Stepladder QtysFY 20FY 21FY 22FY 23FY 24
VA TI-10 to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
VA TI-12 to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
VA TI-14 to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
VA TI-16 to TI-20:
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
NEWCON COLUMBIA to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
NEWCON VA to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
TI-20 ARCI
TI-20 Variants & Stepladder QtysFY 20FY 21FY 22FY 23FY 24
VA TI-10 to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
VA TI-12 to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
VA TI-14 to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
VA TI-16 to TI-20:
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
NEWCON COLUMBIA to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
NEWCON VA to TI-20
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
TI-22 BYG-1
TI-22 Variants & Stepladder QtysFY 22FY 23FY 24FY 25FY 26
LA TI-14 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
LA TI-18 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
SSBN TI-16 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
SSBN TI-18 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
SEAWOLF TI-16 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
TI-22 ARCI
TI-22 Variants & Stepladder QtysFY 22FY 23FY 24FY 25FY 26
LA TI-14 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
LA TI-18 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
SSBN TI-16 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
SSBN TI-18 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+
SEAWOLF TI-16 to TI-22
Unit Price for 1 each
Unit Price for 2-3 each
Unit Price for 4+

&L&"Times New Roman,Regular"N00253-18-R-0002&C&"Times New Roman,Regular"Section J - Attachment 10, Cost Summary Wkst 10G Shipset Stepladder Pricing Table &C&"Times New Roman,Regular"Page &P of &N

File details come from the government source that posted it.