Attachment_10_Cost_Summary_(Amendment_0004).xls

XLS spreadsheet 191 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 (Amendment 0004)

View the file

Other files

File Type Posted
Attachment_12_NAVSEA_Pre-Award_Accounting_System_Adequacy_Checklist.docx DOCX document
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_10_Cost_Summary.xls XLS spreadsheet
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 7.5%, 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 Offeror shall complete a separate Worksheet 10B, Sample Task 3 (Production), for a quantity of one (1) each, for every FY19/20 shipset variant for TI-20 and for every FY20/21 shipset variant for TI-22 identified in Worksheet 10G (total of 19 worksheets). The Target Cost for one (1) each on Worksheet 10B must match the stepladder unit price for 1 each in TI-20 (FY19/20) and TI-22 (FY20/21) 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: ________Variant: _______________________________________
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 FY19/20 and TI-22 FY20/21 stepladder prices for the quantity 1 each on Worksheet 10G.

(c) The Offeror shall identify a Target Fee percentage between 0% and 7.5%, 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.

Amendment 0004 changes are in red.

&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 (%)
≤ 7.5%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%
100179,832$ - 0$ - 0$ - 0$ - 0$ - 00.0%
1002146,462$ - 0$ - 0$ - 0$ - 0$ - 00.0%
1003185,749$ - 0$ - 0$ - 0$ - 0$ - 00.0%
1004154,298$ - 0$ - 0$ - 0$ - 0$ - 00.0%
1005106,930$ - 0$ - 0$ - 0$ - 0$ - 00.0%
100918,309$ - 0$ - 0$ - 0$ - 0$ - 00.0%
101016,038$ - 0$ - 0$ - 0$ - 0$ - 00.0%
101117,957$ - 0$ - 0$ - 0$ - 0$ - 00.0%
101213,487$ - 0$ - 0$ - 0$ - 0$ - 00.0%
101313,386$ - 0$ - 0$ - 0$ - 0$ - 00.0%
10171,954$ - 0$ - 0$ - 0$ - 0$ - 00.0%
10181,954$ - 0$ - 0$ - 0$ - 0$ - 00.0%
10197,814$ - 0$ - 0$ - 0$ - 0$ - 00.0%
102013,024$ - 0$ - 0$ - 0$ - 0$ - 00.0%
10217,814$ - 0$ - 0$ - 0$ - 0$ - 00.0%
200151,712$ - 0$ - 0$ - 0$ - 0$ - 0
200511,505$ - 0$ - 0$ - 0$ - 0$ - 0
20093,256$ - 0$ - 0$ - 0$ - 0$ - 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 7.5%
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$ 312,567,890$ - 0$ 312,567,890$ -0
1016$ 25,797,020$ - 0$ 25,797,020$ -0
1024$ 15,149,869$ - 0$ 15,149,869$ -0
2004$ 7,987,558$ - 0$ 7,987,558$ -0
2008$ 3,748,442$ - 0$ 3,748,442$ -0
2012$ 1,514,987$ - 0$ 1,514,987$ -0
$ - 0$ 733,435,661$ - 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$ 11,269,006$ - 0$ 11,269,006
1014$ 1,984,386$ - 0$ 1,984,386
1022$ 996,702$ - 0$ 996,702
2002$ 4,340,856$ - 0$ 4,340,856
2006$ 288,342$ - 0$ 288,342
2010$ 99,670$ - 0$ 99,670
$ 32,701,049$ - 0$ 32,701,049

&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 USN shipsets 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 modernization variants ordered within a given category. NEWCON variants will not be combined with modernization variants, and TI-20 and TI-22 will not be combined with each other, for purposes of determing the cumulative quantity unit price for each delivery order. For example only, assume the following stepladder pricing and incentive fee:
BYG-1 VA TI-12to TI-20

Unit Price 1 each is $50 Unit Price 2-3 each is $45 Unit Price 4+ is $40

ARCI VA TI-14 to TI-20 Unit Price 1 each is $48 Unit Price 2-3 each is $43 Unit Price 4+ is $38 BYG-1 LA TI-14 to TI-22 Unit Price 1 each is $52 Unit Price 2-3 each is $50 Unit Price 4+ each is $47

ARCI SSBN TI-16 to 22 Unit Price 1 each is $45 Unit Price 2-3 each is $44 Unit Price 4+ each is $43 BYG-1 NEWCON COLUMBIA Unit Price 1 each is $49 Unit Price 2-3 each is $47 Unit Price 4+ is $45

BYG-1 NEWCON VIRGINIA

Unit Price 1 each is $49 Unit Price 2-3 each is $46 Unit Price 4+ is $44 Incentive Fee (from Wkst 10E):

5.0% Based on the assumed stepladder pricing and incentive fee shown above, a single delivery order for the following shipsets is priced as shown below based on the cummulative quantities identified:

1 each VA TI-12 to TI-20 @ $45 each 1 each VA TI-14 to TI-20 @ $43 each 1 each LA TI-14 to TI-22 @ $50 each 1 each SSBN TI-16 to 22 @ $44 each 1 each NEWCON COLUMBIA @ $47 each 2 each NEWCON VIRGINIA @ $46 each Target Cost: $323.00 + Target Fee: $16.15 Total Target Cost Plus Fee: $339.15

TI-20 BYG-1
TI-20 Variants & Stepladder QtysFY 19/20FY 20/21FY 21/22FY 22/23FY 23/24
Variant VA TI-10 to TI-20 is deleted.
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 19/20FY 20/21FY 21/22FY 22/23FY 23/24
Variant VA TI-10 to TI-20 is deleted.
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+
Variant NEWCON COLUMBIA to TI-20 is deleted.
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 20/21FY 21/22FY 22/23FY 23/24FY 24/25FY25/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 20/21FY 21/22FY 22/23FY 23/24FY 24/25FY25/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+
Amendment 0004 changes are in red.

&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 Cummulative quantity of 2 each Cummulative quantity of 2 each Cummulative quantity of 3 each Cummulative quantity of 3 each

File details come from the government source that posted it.