Attachment 0023 - IBCS LRIP FRP DO 0001 Pricing Template_22Oct2020.xlsx

XLSX spreadsheet 94 KB Posted

Attached to
RFP for Integrated Battle Command System (IBCS) LRIP/FRP Federal contract opportunity
Solicitation number
W31P4Q-20-R-0015
Issued by
Department of the Army Materiel Command Contracting Command Redstone Arsenal

About this file

This attachment is a pricing template for an Integrated Battle Command System (IBCS) Low Rate Initial Production/Full Rate Production (LRIP/FRP) delivery order solicitation. The solicitation requires production of IBCS hardware end items in accordance with supplied technical data packages and specifications, and may include engineering changes for obsolescence, new capabilities, and export considerations. The pricing template includes worksheets for offerors to propose Firm Fixed Price Incentive Fee, Cost Plus Incentive Fee, and Cost No Fee prices. It specifies including direct labor rates, indirect rates, subcontractor rates, and fully burdened labor rates. Offerors must apply rates to proposed costs and hours to calculate total proposed prices for CLINs for hardware, collaborative environments, networking relays, and engineering services. The template also includes sections for travel and material costs. Questions are due by December 10, 2020 and the solicitation is only open to contractors approved by the Integrated Fires Mission Command Project Office.

View the file

Other files for this federal contract opportunity

Other files attached to RFP for Integrated Battle Command System (IBCS) LRIP/FRP, newest first.
File Type Posted
W31P4Q-20-R-0015- LRIP FRP - 25NOV2020.pdf PDF
Exhibit B - LRIP FRP TO 0001 DD1423 CDRLs_24NOV2020.pdf PDF
Attachment 0001 - IBCS LRIP FRP Statement of Work - 24NOV2020.docx DOCX document
Attachment 0010a.1 – R001 HRFU-FMECA.xlsx XLSX spreadsheet
Attachment 0010a.2 – R002 BPU-FMECA.xlsx XLSX spreadsheet
Attachment 0010a.6 – R006 TIMING UNIT-FMECA.xlsx XLSX spreadsheet
Attachment 0010a.12 – R030 PFPU SSHD-1—FMECA.xlsx XLSX spreadsheet
Attachment 0010a.14 – R032 Media Converter Module 11-FMECA.xlsx XLSX spreadsheet
Attachment 0010b.1 – E001 28VDC Pwr Supply Shelter Power-FMECA.xlsx XLSX spreadsheet
Attachment 0010b.10 – E034 R112 Shelter – Server Stack – 04-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.6 – E051 IGRM-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.11 – E061 Isolation Router Red-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.12 – E062 Shelter Router-Red-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.16 – E069 Media Converter 03 - FMECA.xlsx XLSX spreadsheet
Attachment 0010d.1 – E123 TMSS – ECU-FMECA.xlsx XLSX spreadsheet
Attachment 0010d.4 – E151 – Media Converter 04-FMECA.xlsx XLSX spreadsheet
Attachment 0010d.6 – E153 RS112 Server -05 Shelter with PT-FMECA.xlsx XLSX spreadsheet
Attachment 0010e.3 – E092 thru E101 Wkstn Display-FMECA.xlsx XLSX spreadsheet
Attachment 0010e.5 – E122 – EMI Tent PDU-FMECA.xlsx XLSX spreadsheet
Attachment 0010e.6 – E143 – ICE UPS-FMECA.xlsx XLSX spreadsheet
Attachment 0010e.10 – E148 – Table 4 Assembly-FMECA.xlsx XLSX spreadsheet
Attachment 0013a -A293-004 ETM 60 Percent Draft_redacted.pdf PDF
Attachment 0013b - IBCS-A301-003 Vol I Student Guide_redacted.pdf PDF
Attachment 0015 - Skill Classification Crosswalk.xlsx XLSX spreadsheet
Attachment 0017 - Pre-Award Survey Accounting System Checklist.pdf PDF
Attachment 0019 - Section L - Instructions - Conditions - and Notices to Offerors - 23NOV2020.docx DOCX document
Attachment 0022a.1.a - ALH-208670 05 IBCS SHELTER INTERC.pdf PDF
Attachment 0022a.1.f - EOC Shelter views.pptx PPTX presentation
Attachment 0022a.1.i - PL-ALH-213030 00 CABLE ASSEMBLY C.pdf PDF
Attachment 0022a.2 - PDRS Support information for integration task.pptx PPTX presentation
Attachment 0026 - Use of Existing Government-Furnished Property.xlsx XLSX spreadsheet
Attachment 0027 - CLIN and SOW Crosswalk - 28OCT2020.docx DOCX document
Attachment 0003 - GFP LRIP FRP - 3SEP2020.xlsx XLSX spreadsheet
Attachment 0007 - AIAMD Requirements Prioritization 1-n table.docx DOCX document
Attachment 0010 - FMECA.docx DOCX document
Attachment 0010a.16 – R034 Media Converter Power Supply-FMECA.xlsx XLSX spreadsheet
Attachment 0010b.3 – E005 Blower Assembly-FMECA.xlsx XLSX spreadsheet
Attachment 0010b.8 – E032 R112 Shelter – Server Stack – 02-FMECA.xlsx XLSX spreadsheet
Attachment 0010b.9 – E033 R112 Shelter – Server Stack – 03-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.1 – E043 Firewall Red-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.4 – E049 BPU-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.7 – E052 SCIM-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.14 – E064 Shelter Router Black – FMECA.xlsx XLSX spreadsheet
Attachment 0010d.2 – E144 RWS Bkup Batteries-FMECA.xlsx XLSX spreadsheet
Attachment 0010d.5 – E152 – Media Converter 05-FMECA.xlsx XLSX spreadsheet
Attachment 0010d.9 - E156 UPS - FMECA.xlsx XLSX spreadsheet
Attachment 0010e.2 – E082 thru E091 Wkstn Laptop-FMECA.xlsx XLSX spreadsheet
Attachment 0010e.4 – E102d thru E111 Vid Extender-FMECA.xlsx XLSX spreadsheet
Attachment 0010e.8 – E146 – Table 2 Assembly-FMECA.xlsx XLSX spreadsheet
Attachment 0013 - Training Documentation.docx DOCX document
Show all 50

RFP for Integrated Battle Command System (IBCS) LRIP/FRP has more files on GovTribe.

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

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 1 OF 11

IBCS LRIP/FRP DO 0001 Pricing Template Instructions: Enter the requested data in the yellow shaded cells. Do not hard key calculated numbers. Input formulas to show the calculation of the total DO 0001 proposed price. The offeror shall complete the worksheets in accordance with the offeror's normal accounting practice. It may be necessary for the offeror to revise the number of rows and columns to reflect differences or nuances in the offeror's accounting system. However, it is requested that the general format be maintained as much as possible for evaluation and contract administration purposes.

The offeror shall complete the worksheets in the following order:

STEP 1: COMPLETE THE "1. DIRECT LABOR RATES" WORKSHEET.

STEP 2: COMPLETE THE "2. INDIRECT RATES" WORKSHEET.

STEP 3: COMPLETE THE "3. LOWER-TIER SUBK RATES" WORKSHEET.

STEP 4: COMPLETE THE "4. FPIF CLINs 0001-0003, 0005" WORKSHEET.

STEP 5: COMPLETE THE "5. CPIF CLIN 0006- ProdEngSvc" WORKSHEET.

STEP 6: COMPLETE THE "6. CPIF CLIN 0008- LogRelSuppt" WORKSHEET.

STEP 7: COMPLETE THE "7. CNF CLIN 0009- Travel" WORKSHEET.

STEP 8: COMPLETE THE "8. CNF CLIN 0010- Material" WORKSHEET.

STEP 7: COMPLETE THE "7. COST ELEMENT SUMMARY" WORKSHEET.

STEP 8: COMPLETE THE "8. DO 0001 CLIN SUMMARY" WORKSHEET.

An example of the labor rate build-up has been completed on worksheets in red text.

The offeror is responsible for ensuring that all calculations in this attachment are accurate. The offeror shall ensure that the red text amounts are not included in the offeror's proposed price.

1. DIRECT LABOR RATES

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 2 OF 11
DIRECT LABOR RATES
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:

STEP 1: COMPLETE THE "DIRECT LABOR RATES" WORKSHEET.

CFY: Month/Day To Month/Day

Annual Escalation: 3.00%

LABOR RATE TABLE (OFFEROR)
Contractor Fiscal Year (CFY)
Contract Labor CategoryOfferor's Contractor/ Corporate Labor CategoryCFY XCFY XCFY XCFY XCFY XCFY XCFY XCFY XDO 0001 Rates
EXAMPLE LABOR CATEGORYCat 1$10.00$10.30$10.61$10.93$11.26$11.59$11.94$12.30$10.23
Cat 2$11.00$11.33$11.67$12.02$12.38$12.75$13.13$13.53$11.25
Cat 3$11.50$11.85$12.20$12.57$12.94$13.33$13.73$14.14$11.76

"DIRECT LABOR RATES" worksheet

In this worksheet, the offeror shall propose IDIQ CPIF labor categories from the IDIQ Pricing Template and Skill Classification Crosswalk and provide the conversion of proposed base labor rates by Contractor Fiscal Year (CFY) to Delivery Order (DO) 0001. The crosswalk of contract labor categories to the offeror's corporate/contractor labor categories and offeror's proposed labor rates by CFY shall match that proposed in the IBCS LRIP/FRP IDIQ Pricing Template.

Enter the requested data in the yellow shaded cells. The offeror shall provide the following in this worksheet:

(1) Identify the CFY period, providing the From and To dates for the CFY period. Then, identify any escalation factors used in the calculation of the proposed labor rates. The labor rates by CFY shall match those proposed in the 1. DIRECT LABOR RATES worksheet of the IBCS LRIP/FRP IDIQ Pricing Template.

(2) In the LABOR RATE TABLE (OFFEROR) below, the offeror shall show the crosswalk of the contract categories to the offeror's internal Contractor/Corporate Labor Category(ies). Provide the offeror's proposed base labor rates (before indirect rates/burdens and fee) by CFY for each Contractor/Corporate Labor Category, identifying the CFY (change the "X" in "CFY X" to the actual CFY year) in the LABOR RATE TABLE. The offeror's proposed base labor rates by CFY shall match that proposed in the 1. DIRECT LABOR RATES worksheet of the IBCS LRIP/FRP IDIQ Pricing Template; input/edit formulas to show the application of the offeror's proposed escalation factor to labor rates.

(4) In the LABOR RATE TABLE (OFFEROR), input formulas into Column K to show the conversion of CFY rates to the DO 0001 Rates. The resulting DO 0001 rates are the rates that shall be used to populate the the "CPIF CLIN 0006- ProdEngSvcs" and "CPIF CLIN 0008- LogRelSuppt" worksheets.

Red text is shown as an example of how formulas are used to show the application of escalation to labor rates and to convert CFY rates to DO 0001 rates. The offeror shall calculate labor rates using its own proposed escalation factor.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's total proposed price. The offeror shall ensure that the red text amounts are not included in the offeror's proposed price.

2. INDIRECT RATES

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 3 OF 11
INDIRECT RATES
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:

STEP 2: COMPLETE THE "2. INDIRECT RATES" WORKSHEET.

INDIRECT RATE TABLE (OFFEROR)
Contractor Fiscal Year (CFY)
Indirect BurdenCFY XCFY XCFY XCFY XCFY XCFY XCFY XCFY XCFY XCFY XDO 0001 Rates
Example- Burden110.00%9.00%8.00%7.00%6.00%5.00%4.00%4.00%4.00%4.00%9.25%
Example- Burden28.50%8.00%7.50%7.00%6.50%6.00%5.50%5.50%5.50%5.50%8.13%
Example- Burden33.00%3.20%3.20%3.00%3.00%3.00%3.50%3.50%3.50%3.50%3.15%

"INDIRECT RATES" worksheet Enter the requested data in the yellow shaded cells. The offeror shall provide the following in this worksheet

(1) Provide the offeror's proposed indirect rates by CFY, identifying the CFY (change the "X" in "CFY X" to the actual CFY year) in the INDIRECT RATE TABLE (OFFEROR). The CFYs identified in Columns C through L shall match those identified in "2. DIRECT LABOR RATES." The rates by CFY shall match those proposed as part of the IDIQ in the IBCS LRIP FRIP IDIQ Pricing Template.

(2) Input formulas to show the conversion of CFY rates to the Delivery Order (DO) 0001 Rates (same as computing the direct labor rates conversion) into Column M. The resulting DO 0001 Rates are the rates that shall be used to populate the "CPIF CLIN 0006- ProdEngSvc", "CPIF CLIN 0008- LogRelSuppt", "CNF CLIN 0009-Travel", and the CNF CLIN 00010- Material" worksheets.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's total proposed price. The offeror shall ensure that the red text amounts are not included in the offeror's proposed price.

3. LOWER-TIER SUBK RATES

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 4 OF 11
LOWER-TIER SUBK RATES
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:
STEP 3: COMPLETE THE "3. LOWER-TIER SUBK RATES" WORKSHEET.
Lower-Tier Subcontractor 1 Name:Lower-Tier Subcontractor 2 Name:
Lower-Tier Subcontractor 1 CAGE:Lower-Tier Subcontractor 2 CAGE:
LABOR RATE TABLE (LOWER-TIER SUBCONTRACTOR 1)LABOR RATE TABLE (LOWER-TIER SUBCONTRACTOR 2)
Contract Labor Category (Subcontractor1)DO 0001 RatesContract Labor Category (Subcontractor2)DO 0001 Rates
Example Lower-Tier Subcontractor1 Labor Category$ 12.00Example Lower-Tier Subcontractor2 Labor Category$ 15.00

"LOWER-TIER SUBK RATES" worksheet

Enter the requested data in the yellow shaded cells. The offeror shall provide the following in this worksheet:

(1) Input the name and CAGE of any proposed lower-tier subcontractors proposed to perform on the effort.

(2) The offeror shall provide a listing of any DO 0001 lower-tier subcontract labor rates by labor category. The subcontract labor rates are the offeror's lower-tier subcontractors' fully burdened labor rates before the offeror pass-through indirect rate(s)/burden(s) and fee. The offeror shall provide a seperate LABOR RATE TABLE (SUBCONTRACTORX) for every lower-tier subcontractor proposed. Additional tables may need to be added to accomodate the offeror's proposed contracting team structure. These rates shall be used to populate the "CPIF CLIN 0006- ProdEngSvcs" and "CPIF CLIN 0008- LogRelSuppt"worksheets.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's total proposed price. The offeror shall ensure that the red text amounts are not included in the offeror's proposed price.

4.FPIF CLINs 0001-0003, 0005

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 5 OF 11
FPIF CLINs 0001- 0003, 0005
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:

STEP 4: COMPLETE THE "4. FPIF CLINs 0001- 0003, 0005" WORKSHEET.

IDIQ Overrun Share Ratio (Gov/Contractor):35/65*
IDIQ Underrun Share Ratio (Gov/Contractor):35/65*
IDIQ FPIF Ceiling:120%*
*The IDIQ overrun share ratio, underrun share ratio, and ceiling % shall be used for proposing on this delivery order.
Engagement Operations Center (EOC) Hardware/ Engagement Center Trailer (ECT)
CLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1
Order QuantityTotal Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Proposed FPIF Ceiling Price (120%)
12
IFMC Collaborative Environment (ICE)
CLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1
Order QuantityTotal Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Proposed FPIF Ceiling Price (120%)
12
Integrated Fire Control Network (IFCN) Relay
CLIN 0003AACLIN 0003AACLIN 0003AACLIN 0003AACLIN 0003AACLIN 1003AACLIN 1003AACLIN 1003AACLIN 1003AACLIN 1003AACLIN 1003AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2
Order QuantityTotal Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Proposed FPIF Ceiling Price (120%)
24
First Article Inspectionn UNIT PRICES
SLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1
Order QuantityTotal Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Proposed FPIF Ceiling Price (120%)
1
SLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005AB
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1
Order QuantityTotal Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Proposed FPIF Ceiling Price (120%)
1
SLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005AC
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1
Order QuantityTotal Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Proposed FPIF Ceiling Price (120%)
1

"FPIF CLINs 0001- 0003, 0005" worksheet

Enter the requested data in the yellow shaded cells. The offeror shall propose a FPIF price on each DO 0001 CLIN/SLIN utilizing the proposed Ordering Period 1 FPIF target unit costs/prices from the "IDIQ FPIF Price Lists" in the IBCS LRIP/FRP IDIQ Pricing Template at Attachment 18. The offeror shall apply the target unit costs/prices from Attachment 18 to the order quantiities identified below to determine the proposed FPIF Total Cost Before FCCOM, Total FCCOM (when applicable based on the offeror's normal accounting practices), Total Target Cost, Total Target Profit, Total Target Price, and Total FPIF Ceiling.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's total proposed price.

5. CPIF CLIN 0006- ProdEngSvc

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 6 OF 11
CPIF CLIN 0006- Product Engineering Services
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:
STEP 6: COMPLETE THE "CPIF CLIN 0006- PRODUCT ENGINEERING SERVICES" WORKSHEET.
*The min fee %, target fee %, max fee%, overrun share ratio, and underrun share ratio proposed for this delivery order shall match that proposed in the "IDIQ CPIF Labor Rate Table" in the IBCS LRIP/FRP IDIQ Pricing Template.
**This rate shall not exceed the IDIQ CPIF Target Blended (Prime/Subk) FBLRs from the "IDIQ CPIF Labor Rate Table" in the IBCS LRIP/FRP IDIQ Pricing Template.
BASE YEAR
OFFEROR BUILD-UPLOWER-TIER SUBCONTRACTOR #1 BUILD-UPLOWER-TIER SUBCONTRACTOR #2 BUILD-UPIDIQ Overrun Share Ratio (Gov/Contractor)70/30^
(Note 3)(Note 3)(Note 3)(Note 6)(Note 6)(Note 6)(Note 3)(Note 5)(Note 5)(Note 6)(Note 6)(Note 6)(Note 5)(Note 5)(Note 5)(Note 6)(Note 6)(Note 6)(Note 5)IDIQ Underrun Share Ratio (Gov/Contractor)70/30^
Name of Indirect Rate:Example- Burden1Example- Burden2IDIQ Min Fee%*IDIQ Target Fee%*IDIQ Max Fee%*Name of Indirect Rate:Example- Burden3Example- Burden2IDIQ Min Fee%*IDIQ Target Fee%*IDIQ Max Fee%*Name of Indirect Rate:Example- Burden3Example- Burden2IDIQ Min Fee%*IDIQ Target Fee%*IDIQ Max Fee%*
CLIN 0006Indirect Rate %:9.25%8.13%0.00%6.00%9.00%(Note 7)Indirect Rate %:3.15%8.13%0.00%6.00%9.00%(Note 7)Indirect Rate %:3.15%8.13%0.00%6.00%9.00%(Note 7)(Note 7)0006AACLIN 0006 CPIF Target Cost Element Summary (Note 10)
Contract Labor Category (Note 1)Contractor/ Corporate Labor Category (Note 1)% Weighting for Composite Rate Calculation (Note 1)Hourly Base Labor Rate ($/hr) (Note 2)Composite Hourly Base Labor Rate ($/hr) (Note 2)Burden Rate ($/hr) (Note 3)Burden Rate ($/hr) (Note 3)Burden Rate ($/hr) (Note 3)Total Hourly Target Cost Before FCCOM ($/hr)Hourly Min Fee ($/hr)Hourly Target Fee ($/hr)Hourly Max Fee ($/hr)Total Hourly Target FCCOM ($/Hr)Total Hourly Target Cost ($/hr)
Total Hourly Target Price- Offeror's FBLR ($/hr)% of Work Performed by Offeror
(For Blended Rate Calculation)Lower-Tier SubK #1 FBLR before Pass-Through
(Note 4)Offeror Burden Rate ($/hr)
(Note 5)Offeror Burden Rate ($/hr)
(Note 5)Total Hourly Target Cost Before FCCOM ($/hr)Hourly Min Fee ($/hr)Hourly Target Fee ($/hr)Hourly Max Fee ($/hr)Total Hourly Target FCCOM ($/Hr)Total Hourly Target Cost ($/hr)
Total Hourly Target Price- Offeror's FBLR ($/hr)% of Work Performed by Subk #1
(For Blended Rate Calculation)Lower-Tier SubK #2 FBLR before Pass-Through
(Note 4)Offeror Burden Rate ($/hr)
(Note 5)Offeror Burden Rate ($/hr)
(Note 5)Total Hourly Target Cost Before FCCOM ($/hr)Hourly Min Fee ($/hr)Hourly Target Fee ($/hr)Hourly Max Fee ($/hr)Total Target Hourly FCCOM ($/Hr)Total Hourly Target Cost ($/hr)Lower-Tier Subk #2 Hourly Target Price ($/hr)% of Work Performed by Subk #2
(For Blended Rate Calculation)DO 0001 CPIF Blended (Prime/Subk) FBLRs
($/Hr)**Total Proposed Labor Hours (Note 8)Total Proposed PriceTarget Direct Labor ($)Target Example Burden 1 ($)Target Subcontractor 1 ($)Target Subcontractor 2 ($)Target Example Burden 3 ($)Total Example Burden 2 ($)Total Target Cost Before FCCOM ($)Target FCCOM Cost ($)Total Target Cost ($)Target Fee ($)Total CPIF Target Price ($)
EXAMPLE LABOR CATEGORYCat 150%$10.23$10.86$1.00$0.96$12.83$0.00$0.77$1.16$0.00$12.83$13.6060%$12.00$0.38$1.01$13.38$0.00$0.80$1.20$0.00$13.38$14.1920%$15.00$0.47$1.26$16.73$0.00$1.00$1.51$0.00$16.73$17.7320%$14.553,00043,638$ 19,555$ 1,809$ 7,200$ 9,000$ 510$ 3,094$ 41,168$ 41,168
Cat 225%$11.25
Cat 325%$11.76

CLIN 0006 TOTAL PROPOSED $: $ 19,555 $ 1,809 $ 7,200 $ 9,000 $ 510 $ 3,094 $ 41,168 $ - 0 $ 41,168 $ 2,470 $ 43,638

"CPIF CLIN 0006- Product Engineering Services" worksheet The offeror shall propose IDIQ CPIF labor categories from the Attachment 18 IDIQ Pricing Template and Attachment 15 Skill Classification Crosswalk and provide the build-up of the offeror’s Delivery Order (DO) 0001 proposed CPIF Blended (prime/subcontract) Fully Burdened Labor Rates (FBLRs) by proposed labor category. The offeror shall use the pricing template to provide the details of the offeror's DO 0001 CPIF Blended FBLRs to include the base labor rates and any applicable indirect rate(s)/burden(s) (pulled from the applicable support tabs that are blue highlighted) and fee proposed in accordance with the offeror’s normal accounting practice. The offeror shall then apply the DO 0001 CPIF Blended FBLRs to the proposed labor hours to calculate the total CPIF Target price for the CPIF Logistics/ Reliability CLIN on DO 0001. Additional columns may need to be added to this worksheet to accommodate the offeror's normal accounting practices. The offeror shall ensure that the DO 0001 proposed CPIF Blended FBLRs by labor category do not exceed Ordering Period 1’s IDIQ CPIF Blended FBLRs from the IDIQ CPIF Labor Rate Table in Attachment 18.

(Note 1): The offeror shall show the crosswalk of the contract labor categories to the Offeror's proposed Contractor/Corporate Labor Category and assign weightings to each Contractor/Corporate Labor Category (if applicable) to show the calculation of the weighted hourly composite rate in Column E for each Labor Category. The crosswalk of contract labor categories to Contractor/Corporate Labor Categories provided in Column A and Column B and the proposed DO 0001 base labor rates in Column D shall match that shown in the "1. Direct Labor Rates" worksheet. The crosswalk of contract labor categories to Contractor/Corporate Labor Categories in Column A and Column B with the percent weightings in Column C shall match that provided in the offeror's Skill Classification. Input/update formulas to map the crosswalk from the "1. Direct Labor Rates" worksheet to the tables below.

(Note 2): The offeror shall input the offeror's base labor rate for each labor category. The base labor rate is the actual hourly base rate paid to the employee EXCLUSIVE of indirect burdens/rates and fee. The rates in this column shall match the DO 0001 labor rates taken from the "1. Direct Labor Rates" worksheet. Input/update formulas to show how the DO 0001 year labor rates from the "1. Direct Labor Rates" worksheet are used to calculate the labor rates in this worksheet.

(Note 3): Apply any applicable indirect burdens and applicable Facilities Capital Cost of Money (FCCOM) to the proposed labor rates. Identify the name of the indirect burden and FCCOM and the indirect rate percentage and FCCOM rate being applied to proposed costs. These rates shall match the DO 0001 Indirect rates in the "2. INDIRECT RATES" worksheet. Input/update formulas to show how the DO 0001 indirect burdens from the "2. INDIRECT RATES" worksheet are used to calculate the labor rates in this worksheet.

(Note 4): The rate in this column is the lower-tier subcontractor's fully burdened labor rate EXCLUSIVE of the offeror's pass-through indirect rates/burdens and fee. These rates shall match the DO 0001 subcontract rates proposed in the "3. LOWER-TIER SUBK RATES" worksheet.

(Note 5): Apply any applicable offeror pass through indirect burdens and applicable FCCOM to the proposed subcontractor labor rates. Identify the name of the indirect burden and the indirect rate percentage being applied to proposed costs. These rates shall match the DO 0001 Indirect rates in the "2. INDIRECT RATES" worksheet.

(Note 6): Propose a CPIF minimum fee, target fee, and maximum fee and apply to each proposed labor rate. The proposed minimum fee percentage, target fee percentage, and minimum fee percentage shall match that proposed in the IDIQ CPIF Labor Rate Table of the IBCS LRIP/FRP Pricing Template.

(Note 7) Identify the percent of work to be performed by the offeror and each lower-tier subcontractor and use formulas to show the calculation of the DO 0001 CPIF Blended FBLR by labor category from the Total Hourly Target Price for the offeror and each proposed lower-tier subcontractor.

(Note 8) Propose labor hours by labor category, for the offeror and each lower-tier subcontractor (if applicable).

(Note 9): Input formulas to calculate the total proposed CPIF $ by cost element for each labor category at the proposed labor hours.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's total proposed price. The offeror shall ensure that the red text amounts are not included in the offeror's proposed price.

6. CPIF CLIN 0008- LogRelSuppt

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 7 OF 11
CPIF CLIN 0008- Logistic/Reliability Support
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:
STEP 6: COMPLETE THE "CPIF CLIN 0008- Logistic/Reliability Support" WORKSHEET.
*The min fee %, target fee %, max fee%, overrun share ratio, and underrun share ratio proposed for this delivery order shall match that proposed in the "IDIQ CPIF Labor Rate Table" in the IBCS LRIP/FRP IDIQ Pricing Template.
**This rate shall not exceed the IDIQ CPIF Target Blended (Prime/Subk) FBLRs from the "IDIQ CPIF Labor Rate Table" in the IBCS LRIP/FRP IDIQ Pricing Template.
BASE YEAR
OFFEROR BUILD-UPLOWER-TIER SUBCONTRACTOR #1 BUILD-UPLOWER-TIER SUBCONTRACTOR #2 BUILD-UPIDIQ Overrun Share Ratio (Gov/Contractor)70/30^
(Note 3)(Note 3)(Note 3)(Note 6)(Note 6)(Note 6)(Note 3)(Note 5)(Note 5)(Note 6)(Note 6)(Note 6)(Note 5)(Note 5)(Note 5)(Note 6)(Note 6)(Note 6)(Note 5)IDIQ Underrun Share Ratio (Gov/Contractor)70/30^
Name of Indirect Rate:Example- Burden1Example- Burden2IDIQ Min Fee%*IDIQ Target Fee%*IDIQ Max Fee%*Name of Indirect Rate:Example- Burden3Example- Burden2IDIQ Min Fee%*IDIQ Target Fee%*IDIQ Max Fee%*Name of Indirect Rate:Example- Burden3Example- Burden2IDIQ Min Fee%*IDIQ Target Fee%*IDIQ Max Fee%*
CLIN 0008Indirect Rate %:9.25%8.13%0.00%6.00%9.00%(Note 7)Indirect Rate %:3.15%8.13%0.00%6.00%9.00%(Note 7)Indirect Rate %:3.15%8.13%0.00%6.00%9.00%(Note 7)(Note 7)0008AACLIN 0008 CPIF Target Cost Element Summary (Note 10)
Contract Labor Category (Note 1)Contractor/ Corporate Labor Category (Note 1)% Weighting for Composite Rate Calculation (Note 1)Hourly Base Labor Rate ($/hr) (Note 2)Composite Hourly Base Labor Rate ($/hr) (Note 2)Burden Rate ($/hr) (Note 3)Burden Rate ($/hr) (Note 3)Burden Rate ($/hr) (Note 3)Total Hourly Target Cost Before FCCOM ($/hr)Hourly Min Fee ($/hr)Hourly Target Fee ($/hr)Hourly Max Fee ($/hr)Total Hourly Target FCCOM ($/Hr)Total Hourly Target Cost ($/hr)
Total Hourly Target Price- Offeror's FBLR ($/hr)% of Work Performed by Offeror
(For Blended Rate Calculation)Lower-Tier SubK #1 FBLR before Pass-Through
(Note 4)Offeror Burden Rate ($/hr)
(Note 5)Offeror Burden Rate ($/hr)
(Note 5)Total Hourly Target Cost Before FCCOM ($/hr)Hourly Min Fee ($/hr)Hourly Target Fee ($/hr)Hourly Max Fee ($/hr)Total Hourly Target FCCOM ($/Hr)Total Hourly Target Cost ($/hr)
Total Hourly Target Price- Offeror's FBLR ($/hr)% of Work Performed by Subk #1
(For Blended Rate Calculation)Lower-Tier SubK #2 FBLR before Pass-Through
(Note 4)Offeror Burden Rate ($/hr)
(Note 5)Offeror Burden Rate ($/hr)
(Note 5)Total Hourly Target Cost Before FCCOM ($/hr)Hourly Min Fee ($/hr)Hourly Target Fee ($/hr)Hourly Max Fee ($/hr)Total Target Hourly FCCOM ($/Hr)Total Hourly Target Cost ($/hr)Lower-Tier Subk #2 Hourly Target Price ($/hr)% of Work Performed by Subk #2
(For Blended Rate Calculation)DO 0001 CPIF Blended (Prime/Subk) FBLRs
($/Hr)**Total Proposed Labor Hours (Note 8)Total Proposed PriceTarget Direct Labor ($)Target Example Burden 1 ($)Target Subcontractor 1 ($)Target Subcontractor 2 ($)Target Example Burden 3 ($)Total Example Burden 2 ($)Total Target Cost Before FCCOM ($)Target FCCOM Cost ($)Total Target Cost ($)Target Fee ($)Total CPIF Target Price ($)
EXAMPLE LABOR CATEGORYCat 150%$10.23$10.86$1.00$0.96$12.83$0.00$0.77$1.16$0.00$12.83$13.6060%$12.00$0.38$1.01$13.38$0.00$0.80$1.20$0.00$13.38$14.1920%$15.00$0.47$1.26$16.73$0.00$1.00$1.51$0.00$16.73$17.7320%$14.553,00043,638$ 19,555$ 1,809$ 7,200$ 9,000$ 510$ 3,094$ 41,168$ 41,168
Cat 225%$11.25
Cat 325%$11.76

CLIN 0008 TOTAL PROPOSED $: $ 19,555 $ 1,809 $ 7,200 $ 9,000 $ 510 $ 3,094 $ 41,168 $ - 0 $ 41,168 $ 2,470 $ 43,638

"CPIF CLIN 0008- Logistic/Reliability Support" worksheet The offeror shall propose IDIQ CPIF labor categories from the Attachment 18 IDIQ Pricing Template and Attachment 15 Skill Classification Crosswalk and provide the build-up of the offeror’s Delivery Order (DO) 0001 proposed CPIF Blended (prime/subcontract) Fully Burdened Labor Rates (FBLRs) by proposed labor category. The offeror shall use the pricing template to provide the details of the offeror's DO 0001 CPIF Blended FBLRs to include the base labor rates and any applicable indirect rate(s)/burden(s) (pulled from the applicable support tabs that are blue highlighted) and fee proposed in accordance with the offeror’s normal accounting practice. The offeror shall then apply the DO 0001 CPIF Blended FBLRs to the proposed labor hours to calculate the total CPIF Target price for the CPIF Logistics/ Reliability CLIN on DO 0001. Additional columns may need to be added to this worksheet to accommodate the offeror's normal accounting practices. The offeror shall ensure that the DO 0001 proposed CPIF Blended FBLRs by labor category do not exceed Ordering Period 1’s IDIQ CPIF Blended FBLRs from the IDIQ CPIF Labor Rate Table in Attachment 18.

(Note 1): The offeror shall show the crosswalk of the contract labor categories to the Offeror's proposed Contractor/Corporate Labor Category and assign weightings to each Contractor/Corporate Labor Category (if applicable) to show the calculation of the weighted hourly composite rate in Column E for each Labor Category. The crosswalk of contract labor categories to Contractor/Corporate Labor Categories provided in Column A and Column B and the proposed DO 0001 base labor rates in Column D shall match that shown in the "1. Direct Labor Rates" worksheet. The crosswalk of contract labor categories to Contractor/Corporate Labor Categories in Column A and Column B with the percent weightings in Column C shall match that provided in the offeror's Skill Classification. Input/update formulas to map the crosswalk from the "1. Direct Labor Rates" worksheet to the tables below.

(Note 2): The offeror shall input the offeror's base labor rate for each labor category. The base labor rate is the actual hourly base rate paid to the employee EXCLUSIVE of indirect burdens/rates and fee. The rates in this column shall match the DO 0001 labor rates taken from the "1. Direct Labor Rates" worksheet. Input/update formulas to show how the DO 0001 year labor rates from the "1. Direct Labor Rates" worksheet are used to calculate the labor rates in this worksheet.

(Note 3): Apply any applicable indirect burdens and applicable Facilities Capital Cost of Money (FCCOM) to the proposed labor rates. Identify the name of the indirect burden and FCCOM and the indirect rate percentage and FCCOM rate being applied to proposed costs. These rates shall match the DO 0001 Indirect rates in the "2. INDIRECT RATES" worksheet. Input/update formulas to show how the DO 0001 indirect burdens from the "2. INDIRECT RATES" worksheet are used to calculate the labor rates in this worksheet.

(Note 4): The rate in this column is the lower-tier subcontractor's fully burdened labor rate EXCLUSIVE of the offeror's pass-through indirect rates/burdens and fee. These rates shall match the DO 0001 subcontract rates proposed in the "3. LOWER-TIER SUBK RATES" worksheet.

(Note 5): Apply any applicable offeror pass through indirect burdens and applicable FCCOM to the proposed subcontractor labor rates. Identify the name of the indirect burden and the indirect rate percentage being applied to proposed costs. These rates shall match the DO 0001 Indirect rates in the "2. INDIRECT RATES" worksheet.

(Note 6): Propose a CPIF minimum fee, target fee, and maximum fee and apply to each proposed labor rate. The proposed minimum fee percentage, target fee percentage, and minimum fee percentage shall match that proposed in the IDIQ CPIF Labor Rate Table of the IBCS LRIP/FRP Pricing Template.

(Note 7) Identify the percent of work to be performed by the offeror and each lower-tier subcontractor and use formulas to show the calculation of the DO 0001 CPIF Blended FBLR by labor category from the Total Hourly Target Price for the offeror and each proposed lower-tier subcontractor.

(Note 8) Propose labor hours by labor category, for the offeror and each lower-tier subcontractor (if applicable).

(Note 9): Input formulas to calculate the total proposed CPIF $ by cost element for each labor category at the proposed labor hours.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's total proposed price. The offeror shall ensure that the red text amounts are not included in the offeror's proposed price.

7. CNF CLIN 0009- Travel

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 8 OF 11
CNF CLIN 0009- Travel
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:
(Note 1)(Note 1)(Note 1)
Name of Indirect Rate:
Indirect Rate %:
Purpose of TripTrip OriginTrip DestinationNumber of TravelersNumber of DaysProposed Hotel Cost per Day Per TravelerTotal Proposed Hotel CostsM&IE Cost per Day per TravelerTotal Proposed M&IE CostsRental Car Cost Per Day per TravelerTotal Proposed Rental Car CostsOther Costs (Describe these in the Notes Column)NotesTotal Proposed Travel Cost Before Indirect Burdens/CostsIndirect Burden/ Costs (Note 3)Indirect Burden/ Costs (Note 3)Indirect Burden/ Costs (Note 3)Total Proposed Travel (with Indirect Costs)

CLIN 0009 TOTAL PROPOSED $: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

"CNF CLIN 0009- Travel" worksheet

In support of proposed travel, enter the requested data in the yellow shaded cells.

(Note 1): Apply any applicable indirect burdens and applicable Facilities Capital Cost of Money (FCCOM) to the proposed labor rates. Identify the name of the indirect burden and FCCOM and the indirect rate percentage and FCCOM rate being applied to proposed costs. These rates shall match the DO 0001 Indirect rates in the "2. INDIRECT RATES" worksheet. Input formulas to show how the DO 0001 indirect burdens from the "2. INDIRECT RATES" worksheet are used to calculate the propoed indirect costs in this worksheet.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's total proposed price.

8. CNF CLIN 0010 - Material

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 9 OF 11
CNF CLIN 0010- Material
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:
(Note 1)(Note 1)(Note 1)
Name of Indirect Rate/Burden/Factor:
Indirect Rate %:
National Stock Number (as applicable)Part NumberItem Name/ DescriptionVendorProposed Unit Cost (Purchase Price to Vendor)Proposed QuantityExtended Cost (Unit Cost Multiplied by Quantity)Description of Basis of Cost (engineering estimate, vendor quote, purchase history, etc.Total Proposed Material Cost Before Indirect Burdens/ CostsIndirect Burden/ Costs (Note 3)Indirect Burden/ Costs (Note 3)Indirect Burden/ Costs (Note 3)Total Proposed Material (with Indirect Costs)

CLIN 0010 TOTAL PROPOSED $: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

"CNF CLIN 0010- Material" worksheet

In support of proposed material, enter the requested data in the yellow shaded cells.

(Note 1): Apply any applicable indirect burdens/rates/factors and applicable Facilities Capital Cost of Money (FCCOM) to the proposed material costs. Identify the name of the indirect burden/rate/factor and FCCOM and the indirect burden/rate/factor rate percentage and FCCOM rate being applied to proposed costs. These rates shall match the DO 0001 Indirect rates in the "2. INDIRECT RATES" worksheet. Input formulas to show how the DO 0001 indirect burdens from the "2. INDIRECT RATES" worksheet are used to calculate the propoed indirect costs in this worksheet.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's total proposed price.

7. COST ELEMENT SUMMARY

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 10 OF 11
DO 0001 COST-REIMBURSEMENT COST ELEMENT SUMMARY
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:
STEP 7: COMPLETE THE "COST ELEMENT SUMMARY" WORKSHEET.
DO 0001 CPIF Target and CNF Cost Element Summary
Cost ElementDO 0001 Total Proposed
Direct Labor$39,111
Example- Burden1$3,618
Subcontractor 1$14,400
Subcontractor 2$18,000
Example- Burden3$1,021
Travel$0
Direct Material$0
Example- Burden2$6,187
Total Cost Before FCCOM$82,336
FCCOM$0
Total Cost$82,336
Fee$4,940
Total$87,276

"DO 0001 CPIF Target and CNF Cost Element" worksheet: Enter the requested data in the yellow highlighted cells. Provide in this worksheet the offeror's cost element summary of the total proposed CPIF and CNF price for DO 0001. The offeror shall input/edit formulas to show how the cost element summary is calculated from the "CPIF CLIN 0006- ProdEngSvc", "CPIF CLIN 0008- LogRelSuppt", "CNF CLIN 0009-Travel", and the CNF CLIN 00010- Material" worksheets in the Pricing Template.

The offeror is responsible for ensuring that all calculations in this attachment are accurate and reflective of the offeror's total proposed price. The offeror shall ensure that the red text amounts are not included in the offeror's proposed price.

8.DO 0001 CLIN SUMMARY

W31P4Q-20-R-0015
ATTACHMENT 0023
TAB 11 OF 11
DO 0001 CLIN SUMMARY
IBCS LRIP/FRP DO 0001
Offeror Name:
Offeror CAGE Code:
STEP 8: COMPLETE THE "DO 0001 CLIN SUMMARY" WORKSHEET.
CLIN/SLINCLIN DESCRIPTIONCLIN TYPEDO 0001 Proposed Price
0001AAEngagement Operations Center (EOC) Hardware/ Engagement Center Trailer (ECT)FPIF
0002AAIFMC Collaborative Environment (ICE)FPIF
0003AAIntegrated Fire Control Network (IFCN) RelayFPIF
0005First Article InspectionFPIF
0005AAFAI- EOC/ECTFPIF
0005ABFAI- IFMC ICEFPIF
0005ACFAI- IFCN RelayFPIF
0006AAProduct Engineering ServicesCPIF
0008AALogistic/Reliability SupportCPIF
0009AATravelCost No Fee
0010AAMaterialCost No Fee
TOTAL DO 0001 PROPOSED:$0

"DO 0001 CLIN SUMMARY" worksheet:

The offeror shall input/edit formulas to show how the total proposed price for DO 0001 are calculated from the "IDIQ FPIF Price Lists", "IDIQ CPIF Labor Rate Table", and "IDIQ CPFF Labor Rate Table".

The "CLIN SUMMARY" should be modified accordingly to reflect the offeror's total proposed price.

The offeror shall ensure that all calculations in this worksheet are accurate and reflective of the offeror's total proposed price. The offeror shall ensure that the red text amounts are not included in the offeror's proposed price.

This is the start of the file's text. The full file is on GovTribe.

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