Attachment 0018 - IBCS LRIP FRP IDIQ Pricing Template_29Oct2020 v.3.xlsx

155 KB Posted

Attached to
RFP for Integrated Battle Command System (IBCS) LRIP/FRP
Solicitation number
W31P4Q-20-R-0015
Issued by

About this file

Written by GovTribe AI ·

This is a request for proposal for a hardware production effort to produce Integrated Battle Command System hardware end items in accordance with supplied technical data packages and specifications. Engineering changes may be required for obsolescence, new capabilities, and export considerations. Questions regarding this solicitation are due by December 10, 2020 at 4pm Central Standard Time. This final RFP is only for contractors who met entrance criteria on SAM.gov and were approved by the Integrated Fires Mission Command Project Office within the Department of the Army Materiel Command Contracting Command at Redstone Arsenal. The effort includes maintaining approved software and firmware updates, cybersecurity, authority to operate, and any engineering changes during the performance period.

View the file

Other files

File Type Posted
Attachment 0019 - Section L - Instructions Conditions and Notices to Offerors - 7DEC2020.docx DOCX document
Attachment 0010a.13 – R031 Black Router--FMECA.xlsx XLSX spreadsheet
Attachment 0010a.5 – R005 SCIM-FMECA.xlsx XLSX spreadsheet
Attachment 0013i - D-IBCS-0473_Adv_NetMgr.pdf PDF
Attachment 0010e.4 – E102d thru E111 Vid Extender-FMECA.xlsx XLSX spreadsheet
Attachment 0022a.1.j - PL-ALH-215333 00 S-280 CASS INSTA.pdf PDF
Attachment 0010d.10 – E157 KVM Switch 2 Shelter-FMECA.xlsx XLSX spreadsheet
Attachment 0004a - EOC Acceptance Test Procedures_FINAL.docx DOCX document
Attachment 0010h - SWFMEA Results.xlsx XLSX spreadsheet
Attachment 0010d.1 – E123 TMSS – ECU-FMECA.xlsx XLSX spreadsheet
Attachment 0005 - Software Installation Instructions.docx DOCX document
Attachment 0026 - Use of Existing Government-Furnished Property.xlsx XLSX spreadsheet
Attachment 0010a.6 – R006 TIMING UNIT-FMECA.xlsx XLSX spreadsheet
Attachment 0010a.1 – R001 HRFU-FMECA.xlsx XLSX spreadsheet
Exhibit C- IBCS DSL - 24NOV2020.docx DOCX document
Attachment 0004d - Operator Procedures For IFMC GSIL.docx DOCX document
Attachment 0010c.11 – E061 Isolation Router Red-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.6 – E051 IGRM-FMECA.xlsx XLSX spreadsheet
Attachment 0010a.10 – R016 thru R025 Media Converter Module-FMECA.xlsx XLSX spreadsheet
Attachment 0013c - IBCS-A301-003 Vol II Instructor Guide_redacted.pdf PDF
Attachment 0010e.9 – E147 – Table 3 Assembly-FMECA.xlsx XLSX spreadsheet
Attachment 0010a.9 – R015 PDU Assembly-FMECA.xlsx XLSX spreadsheet
Attachment 0016 - Example Cage Code and Cognizant DCMA DCAA Information.xlsx XLSX spreadsheet
Attachment 0022a.1.e - ALH-215333 00 S-280 CASS INSTALLA.pdf PDF
Attachment 0010c.15 – E068 Media Converter 02 – FMECA.xlsx XLSX spreadsheet
Attachment 0010b.4 – E013 ADSI Shelter – Misc Equip-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.10 – E060 Shelter Switch – 02-FMECA.xlsx XLSX spreadsheet
Attachment 0010e.11 – E149 – Table 5 Assembly-FMECA.xlsx XLSX spreadsheet
Attachment 0010c.13 – E063 Isolation Router Black-FMECA.xlsx XLSX spreadsheet
Attachment 0010a.15 – R033 Media Converter Module 12-FMECA.xlsx XLSX spreadsheet
Attachment 0010b.5 – E029 KVM Switch 1 Shelter Stack-FMECA.xlsx XLSX spreadsheet
Attachment 0004c - ECT Acceptance Test Procedures_FINAL.DOCX DOCX document
Attachment 0010e.6 – E143 – ICE UPS-FMECA.xlsx XLSX spreadsheet
Attachment 0010b.6 – E030 KVM Console-FMECA.xlsx XLSX spreadsheet
Attachment 0012 - Risk Management Plan.pdf PDF
Attachment 0013a -A293-004 ETM 60 Percent Draft_redacted.pdf PDF
Attachment 0022a.2 - PDRS Support information for integration task.pptx PPTX presentation
Attachment 0010c.16 – E069 Media Converter 03 - FMECA.xlsx XLSX spreadsheet
Attachment 0022a.1.f - EOC Shelter views.pptx PPTX presentation
Attachment 0001 - IBCS LRIP FRP Statement of Work - 24NOV2020.docx DOCX document
Attachment 0010a.2 – R002 BPU-FMECA.xlsx XLSX spreadsheet
Attachment 0010a.4 – R004 IGRM-FMECA.xlsx XLSX spreadsheet
Attachment 0022a.1.g - PL-ALH-209032 00 CABLE ASSEMBLY C.pdf PDF
Attachment 0010b.7 – E031 R112 Shelter – Server Stack – 01-FEMCA.xlsx XLSX spreadsheet
Attachment 0004 - Acceptance Test Plan.docx DOCX document
Attachment 0006 - Obsolete Parts List.pdf PDF
Attachment 0010a.11 – R029 PFPU SSHD-1—FMECA.xlsx XLSX spreadsheet
Attachment 0011- Cost Report and Plan.pdf PDF
Attachment 0010d.3 – E150 S-280 PEV-FMECA.xlsx XLSX spreadsheet
Attachment 0013h - D-IBCS-0472_Adv_IDD_redacted.pdf PDF
Show 40 more

Latest 50 of 128 listed here. See the rest on GovTribe.

On GovTribe

Work with this file

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

Text version

The file's text, extracted by GovTribe without its formatting.

INSTRUCTIONS

W31P4Q-20-R-0015
ATTACHMENT 0018
TAB 1 of 11

IBCS LRIP/FRP IDIQ 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 IDIQ 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 IDIQ PRICE LISTS" WORKSHEET.

STEP 4a: COMPLETE THE "4a. IDIQ FPIF EXTENDED PRICES" WORKSHEET.

STEP 5: COMPLETE THE "5. IDIQ CPIF LABOR RATE TABLE" WORKSHEET.

STEP 6: COMPLETE THE "6. IDIQ CPFF LABOR RATE TABLE" WORKSHEET.

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

STEP 8: COMPLETE THE "8. 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 0018
TAB 2 of 11
DIRECT LABOR RATES
IBCS LRIP/FRP
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)Ordering Period Labor Rates
Contract Labor CategoryOfferor's Contractor/ Corporate Labor CategoryCFY XCFY XCFY XCFY XCFY XCFY XCFY XCFY XOrdering Period 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5
EXAMPLE LABOR CATEGORYCat 1$10.00$10.30$10.61$10.93$11.26$11.59$11.94$12.30$10.23$10.53$10.85$11.17$11.51
Cat 2$11.00$11.33$11.67$12.02$12.38$12.75$13.13$13.53$11.25$11.58$11.93$12.29$12.66
Cat 3$11.50$11.85$12.20$12.57$12.94$13.33$13.73$14.14$11.76$12.11$12.47$12.85$13.23

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

(1) Identify the contractor fiscal year (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.

(2) In the LABOR RATE TABLE (OFFEROR), the offeror shall show the crosswalk of the contract categories to the offeror's internal Contractor/Corporate Labor Category(ies). The crosswalk of contract labor categories to Contractor/Corproate Labor Categories in Column A and Column B shall match that provided in the offeror's Skill Classification Crosswalk. 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 ; 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 Columns K through O to show the conversion of CFY rates to the ordering period. The resulting ordering period rates are the rates that shall be used to populate the "IDIQ CPIF Labor Rate Table", "IDIQ CPFF Labor Rate Table" and the supporting worksheets that show the calculation of the prices proposed in the "IDIQ FPIF Price Lists" (when applicable).

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 ordering period rates. The offeror shall calculate labor rates using its own proposed escalation factor and shall calculate ordering period rates in accordance with its own CFY period and the effort's period of performance by ordering period.

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 0018
TAB 3 of 11
INDIRECT RATES
IBCS LRIP/FRP
Offeror Name:
Offeror CAGE Code:

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

INDIRECT RATE TABLE (Offeror)
Contractor Fiscal Year (CFY)Ordering Period Indirect Rates
Indirect BurdenCFY XCFY XCFY XCFY XCFY XCFY XCFY XCFY XCFY XCFY XOrdering Period 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5
Example- Burden110.00%9.00%8.00%7.00%6.00%5.00%4.00%4.00%4.00%4.00%9.25%8.25%7.25%6.25%5.25%
Example- Burden28.50%8.00%7.50%7.00%6.50%6.00%5.50%5.50%5.50%5.50%8.13%7.63%7.13%6.63%6.13%
Example- Burden33.00%3.20%3.20%3.00%3.00%3.00%3.50%3.50%3.50%3.50%3.15%3.20%3.05%3.00%3.00%

"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 "1. DIRECT LABOR RATES."

(2) Input formulas to show the conversion of CFY rates to the ordering period rates (same as computing the direct labor rates conversion) into Columns M through Q. The resulting ordering period rates are the rates that shall be used to populate the "IDIQ CPIF Labor Rate Table", "IDIQ CPFF Labor Rate Table" and the supporting worksheets that show the calculation of the prices proposed in the "IDIQ FPIF Price Lists" (when applicable).

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 0018
TAB 4 of 11
LOWER-TIER SUBK RATES
IBCS LRIP/FRP
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)
Ordering Period Labor RatesOrdering Period Labor Rates
Contract Labor Category (Subcontractor1)Ordering Period 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5Contract Labor Category (Subcontractor2)Ordering Period 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5
Example Lower-Tier Subcontractor1 Labor Category$ 12.00$ 13.00$ 14.00$ 15.00$ 16.00Example Lower-Tier Subcontractor2 Labor Category$ 15.00$ 16.00$ 17.00$ 18.00$ 19.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 lower-tier subcontract labor rates by labor category and by ordering period. 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 "IDIQ CPIF Labor Rate Table", "IDIQ CPFF Labor Rate Table" and the supporting worksheets that show the calculation of the prices proposed in the "IDIQ FPIF Price Lists" (when applicable).

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. IDIQ FPIF Price Lists

W31P4Q-20-R-0015
ATTACHMENT 0018
TAB 5 of 11
IDIQ FPIF Price Lists
IBCS LRIP/FRP
Offeror Name:
Offeror CAGE Code:

STEP 4: COMPLETE THE "4. IDIQ FPIF PRICE LISTS" WORKSHEET.

*The overrun share ratio, underrun share ratio, and ceiling identified shall be used for proposing on future orders issued under the IDIQ effort and for proposing on DO 0001.
**The Target Unit Cost before Facilities Capital Cost of Money (FCCOM), Total Unit FCCOM, Total Target Unit Cost , Total Target Unit Profit, and Total Target Unit Price from this worksheet shall be applied to the actual order quantity for determining the price of DO 0001 and any future FPIF orders issued under the IDIQ effort.
IDIQ Overrun Share Ratio (Gov/Contractor):35/65*
IDIQ Underrun Share Ratio (Gov/Contractor):35/65*
IDIQ FPIF Ceiling:120%
FMS=====================================================================================================================================================>
Engagement Operations Center (EOC) Hardware/ Engagement Center Trailer (ECT) UNIT PRICES ($/Unit)**FMS Engagement Operations Center (EOC) Hardware/ Engagement Center Trailer (ECT) UNIT PRICES ($/unit)**
CLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 1001AACLIN 1001AACLIN 1001AACLIN 1001AACLIN 1001AACLIN 2001AACLIN 2001AACLIN 2001AACLIN 2001AACLIN 2001AACLIN 3001AACLIN 3001AACLIN 3001AACLIN 3001AACLIN 3001AACLIN 0013AACLIN 0013AACLIN 0013AACLIN 0013AACLIN 0013AACLIN 1012AACLIN 1012AACLIN 1012AACLIN 1012AACLIN 1012AACLIN 2012AACLIN 2012AACLIN 2012AACLIN 2012AACLIN 2012AACLIN 3012AACLIN 3012AACLIN 3012AACLIN 3012AACLIN 3012AACLIN 4012AACLIN 4012AACLIN 4012AACLIN 4012AACLIN 4012AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5
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 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 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 Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)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 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 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 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 Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)
11
22
33
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
FMS=====================================================================================================================================================>
IFMC Collaborative Environment (ICE) UNIT PRICES ($/unit)**FMS IFMC Collaborative Environment (ICE) Unit Price ($/unit)**
CLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 1002AACLIN 1002AACLIN 1002AACLIN 1002AACLIN 1002AACLIN 2002AACLIN 2002AACLIN 2002AACLIN 2002AACLIN 2002AACLIN 3002AACLIN 3002AACLIN 3002AACLIN 3002AACLIN 3002AACLIN 0014AACLIN 0014AACLIN 0014AACLIN 0014AACLIN 0014AACLIN 1013AACLIN 1013AACLIN 1013AACLIN 1013AACLIN 1013AACLIN 2013AACLIN 2013AACLIN 2013AACLIN 2013AACLIN 2013AACLIN 3013AACLIN 3013AACLIN 3013AACLIN 3013AACLIN 3013AACLIN 4013AACLIN 4013AACLIN 4013AACLIN 4013AACLIN 4013AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5
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 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 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 Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)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 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 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 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 Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)
11
22
33
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
FMS=====================================================================================================================================================>
Integrated Fire Control Network (IFCN) Relay UNIT PRICES ($/unit)**FMS Integrated Fire Control Network (IFCN) Relay UNIT PRICES ($/unit)**
CLIN 0003AACLIN 0003AACLIN 0003AACLIN 0003AACLIN 0003AACLIN 1003AACLIN 1003AACLIN 1003AACLIN 1003AACLIN 1003AACLIN 2003AACLIN 2003AACLIN 2003AACLIN 2003AACLIN 2003AACLIN 3003AACLIN 3003AACLIN 3003AACLIN 3003AACLIN 3003AACLIN 0015AACLIN 0015AACLIN 0015AACLIN 0015AACLIN 0015AACLIN 1014AACLIN 1014AACLIN 1014AACLIN 1014AACLIN 1014AACLIN 2014AACLIN 2014AACLIN 2014AACLIN 2014AACLIN 2014AACLIN 3014AACLIN 3014AACLIN 3014AACLIN 3014AACLIN 3014AACLIN 4014AACLIN 4014AACLIN 4014AACLIN 4014AACLIN 4014AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5
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 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 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 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 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 Target Unit Price ($/unit)Total 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 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 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 Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)
11
22
33
44
55
66
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
B-Kit UNIT PRICES ($/unit)**
CLIN 0004AACLIN 0004AACLIN 0004AACLIN 0004AACLIN 0004AACLIN 1004AACLIN 1004AACLIN 1004AACLIN 1004AACLIN 1004AACLIN 2004AACLIN 2004AACLIN 2004AACLIN 2004AACLIN 2004AACLIN 3004AACLIN 3004AACLIN 3004AACLIN 3004AACLIN 3004AA
QuantityOrdering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4
Total 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 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 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 Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
First Article Inspectionn UNIT PRICES ($/Hr)**
SLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ADSLIN 0005ADSLIN 0005ADSLIN 0005ADSLIN 0005AD
QuantityOrdering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1
Total 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 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 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 Unit Cost Before FCCOM ($/unit)Total Unit FCCOM ($/unit)Total Target Unit Cost ($/unit)Total Target Unit Profit ($/unit)Total Target Unit Price ($/unit)
1

"IDIQ FPIF PRICE LISTS" worksheet

Enter the requested data in the yellow shaded cells for every FPIF CLIN/SLIN and at the quantities identified in this worksheet to propose a Target Unit Cost before Facilities Capital Cost of Money (FCCOM) , Total Unit FCCOM, (when applciable based on the offeror's established accounting practices for accumulating, allocating and recording costs to final cost objectives), Total Target Unit Cost , Total Target Unit Profit, and Total Target Unit Price.

The offeror shall provide additional worksheets within the IBCS LRIP/FRP IDIQ Pricing Template workbook to show the calculation of the Target Unit Cost before FCCOM, Total Unit FCCOM, (when applicable), Total Target Unit Cost , Total Target Unit Profit, and Total Target Unit Price. The offeror’s calculations shall identify the offeror and any lower-tier subcontractor labor categories, labor hours, and labor rates; direct material types, quantities, and unit prices; ODC types, quantities, and unit prices; travel types, quantities, and unit prices; indirect rates/factors; proposed profit; etc. used to calculate the proposed FPIF unit prices by CLIN/SLIN. Provide formulas in the FPIF prices lists to show how the direct labor costs, indirect costs, subcontract costs, material, ODC, travel, and profit costs are calculated from the additional supporting worksheets inside the IBCS LRIP/FRP IDIQ Pricing Template workbook.

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.

4a. IDIQ FPIF Extended Prices

W31P4Q-20-R-0015
ATTACHMENT 0018
TAB 5a of 11
IDIQ FPIF Extended Prices
IBCS LRIP/FRP
Offeror Name:
Offeror CAGE Code:
STEP 4a: COMPLETE THE "4a. IDIQ FPIF EXTENDED PRICES" WORKSHEET.
*The overrun share ratio, underrun share ratio, and ceiling identified shall be used for proposing on future orders issued under the IDIQ effort and for proposing on DO 0001.
**The amounts shown in this table represents the extended FPIF amounts and are the result of applying the FPIF target unit amounts from tab 4. IDIQ FPIF Price Lists to each quantity identified.
FPIF Overrun Share Ratio (Gov/Contractor):35/65*
FPIF Underrun Share Ratio (Gov/Contractor):35/65*
FPIF Ceiling:120%
FMS=====================================================================================================================================================>
Engagement Operations Center (EOC) Hardware/ Engagement Center Trailer (ECT) EXTENDED PRICES ($)**FMS Engagement Operations Center (EOC) Hardware/ Engagement Center Trailer (ECT) EXTENDED PRICE ($)**
CLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 0001AACLIN 1001AACLIN 1001AACLIN 1001AACLIN 1001AACLIN 1001AACLIN 2001AACLIN 2001AACLIN 2001AACLIN 2001AACLIN 2001AACLIN 3001AACLIN 3001AACLIN 3001AACLIN 3001AACLIN 3001AACLIN 0013AACLIN 0013AACLIN 0013AACLIN 0013AACLIN 0013AACLIN 1012AACLIN 1012AACLIN 1012AACLIN 1012AACLIN 1012AACLIN 2012AACLIN 2012AACLIN 2012AACLIN 2012AACLIN 2012AACLIN 3012AACLIN 3012AACLIN 3012AACLIN 3012AACLIN 3012AACLIN 4012AACLIN 4012AACLIN 4012AACLIN 4012AACLIN 4012AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5
QuantityTotal Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)QuantityTotal Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)
11
22
33
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
FMS=====================================================================================================================================================>
IFMC Collaborative Environment (ICE) EXTENDED PRICE ($)**FMS IFMC Collaborative Environment (ICE) EXTENDED PRICE ($)**
CLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 0002AACLIN 1002AACLIN 1002AACLIN 1002AACLIN 1002AACLIN 1002AACLIN 2002AACLIN 2002AACLIN 2002AACLIN 2002AACLIN 2002AACLIN 3002AACLIN 3002AACLIN 3002AACLIN 3002AACLIN 3002AACLIN 0014AACLIN 0014AACLIN 0014AACLIN 0014AACLIN 0014AACLIN 1013AACLIN 1013AACLIN 1013AACLIN 1013AACLIN 1013AACLIN 2013AACLIN 2013AACLIN 2013AACLIN 2013AACLIN 2013AACLIN 3013AACLIN 3013AACLIN 3013AACLIN 3013AACLIN 3013AACLIN 4013AACLIN 4013AACLIN 4013AACLIN 4013AACLIN 4013AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5
QuantityTotal Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)QuantityTotal Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)
11
22
33
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
FMS=====================================================================================================================================================>
Integrated Fire Control Network (IFCN) Relay EXTENDED PRICE ($)**FMS Integrated Fire Control Network (IFCN) Relay EXTENDED PRICE ($)**
CLIN 0003AACLIN 0003AACLIN 0003AACLIN 0003AACLIN 0003AACLIN 1003AACLIN 1003AACLIN 1003AACLIN 1003AACLIN 1003AACLIN 2003AACLIN 2003AACLIN 2003AACLIN 2003AACLIN 2003AACLIN 3003AACLIN 3003AACLIN 3003AACLIN 3003AACLIN 3003AACLIN 0015AACLIN 0015AACLIN 0015AACLIN 0015AACLIN 0015AACLIN 1014AACLIN 1014AACLIN 1014AACLIN 1014AACLIN 1014AACLIN 2014AACLIN 2014AACLIN 2014AACLIN 2014AACLIN 2014AACLIN 3014AACLIN 3014AACLIN 3014AACLIN 3014AACLIN 3014AACLIN 4014AACLIN 4014AACLIN 4014AACLIN 4014AACLIN 4014AA
Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5Ordering Period 5
QuantityTotal Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Unit Cost Before FCCOM ($/unit)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)
11
22
33
44
55
66
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
B-Kit EXTENDED PRICE ($)**
CLIN 0004AACLIN 0004AACLIN 0004AACLIN 0004AACLIN 0004AACLIN 1004AACLIN 1004AACLIN 1004AACLIN 1004AACLIN 1004AACLIN 2004AACLIN 2004AACLIN 2004AACLIN 2004AACLIN 2004AACLIN 3004AACLIN 3004AACLIN 3004AACLIN 3004AACLIN 3004AA
QuantityOrdering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 2Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 3Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4Ordering Period 4
Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
First Article Inspectionn EXTENDED PRICE ($)**
SLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005AASLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ABSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ACSLIN 0005ADSLIN 0005ADSLIN 0005ADSLIN 0005ADSLIN 0005AD
QuantityOrdering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1Ordering Period 1
Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)Total Cost Before FCCOM ($)Total FCCOM ($)Total Target Cost ($)Total Target Profit ($)Total Target Price ($)
1

"IDIQ FPIF EXTENDED PRICES" worksheet

Enter the requested data in the yellow shaded cells for every FPIF CLIN/SLIN. The offeror shall apply the FPIF unit prices from tab 4. IDIQ FPIF Price Lists to the quantities identified to calculate the Target Cost before Facilities Capital Cost of Money (FCCOM) , Total FCCOM (when applciable based on the offeror's established accounting practices for accumulating, allocating and recording costs to final cost objectives), Total Target Cost , Total Target Profit, and Total Target Price for each quantity. The maximum quantity extended amounts shall be input into Section B.

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.

5. IDIQ CPIF Labor Rate Table

W31P4Q-20-R-0015
ATTACHMENT 0018
TAB 6 of 11
IDIQ CPIF Labor Rate Table
IBCS LRIP/FRP
Offeror Name:
Offeror CAGE Code:
STEP 6: COMPLETE THE "IDIQ CPIF LABOR RATE TABLE" WORKSHEET.
CPIF Overrun Share Ratio (Gov/Contractor):70/30
CPIF Underrun Share Ratio (Gov/Contractor):70/30
Target Fee (%)
Mininimum Fee (%)0%
Maximum Fee (%)
*The min fee %, target fee %, max fee%, overrun share ratio, and underrun share ratio identified shall be used for proposing on future orders and for proposing on DO 0001.
**The contractor shall not exceed the IDIQ CPIF Blended FBLRs by labor category proposed when pricing future CPIF orders issued under the IDIQ effort.
ORDERING PERIOD 1
OFFEROR BUILD-UPLOWER-TIER SUBCONTRACTOR #1 BUILD-UPLOWER-TIER SUBCONTRACTOR #2 BUILD-UP

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 .