HSCG23-11-R-ADB013 Attach 2.xlsx

XLSX spreadsheet 26 KB Posted

Attached to
U. S. Coast Guard Cutter Boat-Over The Horizon-IV (CB-OTH-IV)
Solicitation number
HSCG23-11-R-ADB013
Issued by

About this file

Attachment 2 (Pricing Worksheets) to HSCG23-11-R-ADB013

View the file

Other files

Show all 23

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

Worksheet_Pricing

Ordering Period 1 (12 month ordering period)
Quantity - Min / MaxUnit PriceTotal25
15$ - 020%5
615$ - 040%10
1620$ - 020%5
2125$ - 020%5
Enter the mid-point weighted average here and multiply that amount by the maximum annualized quantity (25) for CLIN 10001 and enter this in the table above.$ - 0
Ordering Period 2 (12 month ordering period)
Quantity - Min / MaxUnit PriceTotal25
15$ - 020%5
615$ - 040%10
1620$ - 020%5
2125$ - 020%5
Enter the mid-point weighted average here and multiply that amount by the maximum annualized quantity (25) for CLIN 20001 and enter this in the table above.$ - 0
Ordering Period 3 (12 month ordering period)
Quantity - Min / MaxUnit PriceTotal25
15$ - 020%5
615$ - 040%10
1620$ - 020%5
2125$ - 020%5
Enter the mid-point weighted average here and multiply that amount by the maximum annualized quantity (25) for CLIN 30001 and enter this in the table above.$ - 0
Ordering Period 4 (12 month ordering period)
Quantity - Min / MaxUnit PriceTotal25
15$ - 020%5
615$ - 040%10
1620$ - 020%5
2125$ - 020%5
Enter the mid-point weighted average here and multiply that amount by the maximum annualized quantity (25) for CLIN 40001 and enter this in the table above.$ - 0
Ordering Period 5 (12 month ordering period)
Quantity - Min / MaxUnit PriceTotal25
15$ - 020%5
615$ - 040%10
1620$ - 020%5
2125$ - 020%5
Enter the mid-point weighted average here and multiply that amount by the maximum annualized quantity (25) for CLIN 50001 and enter this in the table above.$ - 0
Ordering Period 6 (12 month ordering period)
Quantity - Min / MaxUnit PriceTotal25
15$ - 020%5
615$ - 040%10
1620$ - 020%5
2125$ - 020%5
Enter the mid-point weighted average here and multiply that amount by the maximum annualized quantity (25) for CLIN 60001 and enter this in the table above.$ - 0
Ordering Period 7 (12 month ordering period)
Quantity - Min / MaxUnit PriceTotal25
15$ - 020%5
615$ - 040%10
1620$ - 020%5
2125$ - 020%5
Enter the mid-point weighted average here and multiply that amount by the maximum annualized quantity (25) for CLIN 70001 and enter this in the table above.$ - 0

HSCG23-11-R-ADB013

Pricing Worksheet Enter Offeror Name: Attachment 2 &D

&P

Instructions: Offerors shall develop their stepladder pricing for each of the ordering periods based upon a maximum order quantity of 101 units. The USCG may order any quantity up to the 25 maximum during any ordering period, however once the maximum quantity of 101 boats is reached, no further orders will be forthcoming. The evaluated contract price for the total number of boats will be determined using the Government's optimal ordering quantity anticipated for that period multiplied by the mid-point weighted average. The quantity breaks are set by the Government and shall not be changed. Offeror's are not required to provide differentiated pricing should they elect to provide only one price irrespective of the quantities ordered.

Other CLINs

Offeror Total Price
Ordering Period 1$ 50,000.00
Ordering Period 2$ 50,000.00
Ordering Period 3$ 50,000.00
Ordering Period 4$ 50,000.00
Ordering Period 5$ 50,000.00
Ordering Period 6$ 50,000.00
Ordering Period 7$ 50,000.00
$ 350,000.00
Ordering Period 1 IDIQ Pricing
CLINDescriptionQtyUnit PriceTotal
10001Complete Boat$ - 0$ - 0
10001aBallistic Protection10$ - 0
10002Performance Support / Training
10002aOperator Familiarization Trng10$ - 0
10002bMaintainer Familiarization Trng10$ - 0
10003Logistics / Sustainment Support
10003aConference / TDP / MECL / Etc.1$ - 0
10003bDrawings / Calculations1$ - 0
10003cDeep Insurance Spares
10003caEngine5$ - 0
10003cbPropulsor Assembly5$ - 0
10003ccCollar / Fendering System5$ - 0
10003dAdditional TMs and Publications10$ - 0
10004Trailer25$ - 0
10005Travel - Reimbursed at CostLot$ 50,000.00$ 50,000.00
$ 50,000.00
Ordering Period 2 IDIQ Pricing
CLINDescriptionQtyUnit PriceTotal
20001Complete Boat$ - 0$ - 0
20001aBallistic Protection10$ - 0
20002Performance Support / Training
20002aOperator Familiarization Trng25$ - 0
20002bMaintainer Familiarization Trng25$ - 0
20003Logistics / Sustainment Support
20003aConference / TDP / MECL / Etc.0$ - 0
20003bDrawings / Calculations Updates2$ - 0
20003cDeep Insurance Spares Kit
20003caEngine5$ - 0
20003cbPropulsor Assembly5$ - 0
20003ccCollar / Fendering System5$ - 0
20003dAdditional TMs and Publications10$ - 0
20004Trailer25$ - 0
20005Travel - Reimbursed at CostLot$ 50,000.00$ 50,000.00
$ 50,000.00
Ordering Period 3 IDIQ Pricing
CLINDescriptionQtyUnit PriceTotal
30001Complete Boat$ - 0$ - 0
30001aBallistic Protection25$ - 0
30002Performance Support / Training
30002aOperator Familiarization Trng25$ - 0
30002bMaintainer Familiarization Trng25$ - 0
30003Logistics / Sustainment Support
30003aConference / TDP / MECL / Etc.0$ - 0
30003bDrawings / Calculations Updates2$ - 0
30003cDeep Insurance Spares Kit
30003caEngine5$ - 0
30003cbPropulsor Assembly5$ - 0
30003ccCollar / Fendering System5$ - 0
30003dAdditional TMs and Publications10$ - 0
30004Trailer25$ - 0
30005Travel - Reimbursed at CostLot$ 50,000.00$ 50,000.00
$ 50,000.00
Ordering Period 4 IDIQ Pricing
CLINDescriptionQtyUnit PriceTotal
40001Complete Boat$ - 0$ - 0
40001aBallistic Protection20$ - 0
40002Performance Support / Training
40002aOperator Familiarization Trng20$ - 0
40002bMaintainer Familiarization Trng20$ - 0
40003Logistics / Sustainment Support
40003aConference / TDP / MECL / Etc.0$ - 0
40003bDrawings / Calculations Updates2$ - 0
40003cDeep Insurance Spares Kit
40003caEngine5$ - 0
40003cbPropulsor Assembly5$ - 0
40003ccCollar / Fendering System5$ - 0
40003dAdditional TMs and Publications10$ - 0
40004Trailer25$ - 0
40005Travel - Reimbursed at CostLot$ 50,000.00$ 50,000.00
$ 50,000.00
Ordering Period 5 IDIQ Pricing
CLINDescriptionQtyUnit PriceTotal
50001Complete Boat$ - 0$ - 0
50001aBallistic Protection20$ - 0
50002Performance Support / Training
50002aOperator Familiarization Trng20$ - 0
50002bMaintainer Familiarization Trng20$ - 0
50003Logistics / Sustainment Support
50003aConference / TDP / MECL / Etc.0$ - 0
50003bDrawings / Calculations Updates2$ - 0
50003cDeep Insurance Spares Kit
50003caEngine5$ - 0
50003cbPropulsor Assembly5$ - 0
50003ccCollar / Fendering System5$ - 0
50003dAdditional TMs and Publications10$ - 0
50004Trailer25$ - 0
50005Travel - Reimbursed at CostLot$ 50,000.00$ 50,000.00
$ 50,000.00
Ordering Period 6 IDIQ Pricing
CLINDescriptionQtyUnit PriceTotal
60001Complete Boat$ - 0$ - 0
60001aBallistic Protection10$ - 0
60002Performance Support / Training
60002aOperator Familiarization Trng10$ - 0
60002bMaintainer Familiarization Trng10$ - 0
60003Logistics / Sustainment Support
60003aConference / TDP / MECL / Etc.0$ - 0
60003bDrawings / Calculations Updates2$ - 0
60003cDeep Insurance Spares Kit
60003caEngine5$ - 0
60003cbPropulsor Assembly5$ - 0
60003ccCollar / Fendering System5$ - 0
60003dAdditional TMs and Publications10$ - 0
60004Trailer25$ - 0
60005Travel - Reimbursed at CostLot$ 50,000.00$ 50,000.00
$ 50,000.00
Ordering Period 7 IDIQ Pricing
CLINDescriptionQtyUnit PriceTotal
70001Complete Boat$ - 0$ - 0
70001aBallistic Protection10$ - 0
70002Performance Support / Training
70002aOperator Familiarization Trng10$ - 0
70002bMaintainer Familiarization Trng10$ - 0
70003Logistics / Sustainment Support
70003aConference / TDP / MECL / Etc.0$ - 0
70003bDrawings / Calculations Updates2$ - 0
70003cDeep Insurance Spares Kit
70003caEngine5$ - 0
70003cbPropulsor Assembly5$ - 0
70003ccCollar / Fendering System5$ - 0
70003dAdditional TMs and Publications10$ - 0
70004Trailer25$ - 0
70005Travel - Reimbursed at CostLot$ 50,000.00$ 50,000.00
$ 50,000.00

HSCG23-11-R-ADB013

CLIN Pricing Enter Offeror Name: Attachment 2 &D

&P

Instructions: Offerors shall provide unit prices for the items in column B without changing the quantities. The quantities represent the maxmum order amount for the period under the IDIQ arrangement. For each x0001 CLIN, the government will use the mid-point weighted average from the worksheet and input its optimal quantity for each ordering period. The total for each period should be left blank for those CLINs. The government will use a fixed amount of $50K for estimated travel for each ordering period. Actual travel will be reimbursed at cost in accordance with the Schedule.

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