Attachment_3_Pricing_Worksheet_CB-LRI III_RFP.xlsx
XLSX spreadsheet 38 KB Posted
- Solicitation number
- 70Z02322R93250001
About this file
This document contains a pricing worksheet and evaluation worksheet for a federal solicitation. The United States Coast Guard is seeking to award an indefinite-delivery/indefinite-quantity contract for up to 17 Long Range Interceptor Cutters (LRI III) over five one-year ordering periods. The solicitation includes line items for the cutter boats, trailers, shipping, familiarization services, technical data, insurance stock, models, and ballistic panels. Pricing is provided for the base year and four option years. The evaluation worksheet calculates total prices based on unit prices and estimated ordering quantities to determine a maximum contract value of $475,000 over the five-year period.
View the file
Other files
Show all 26
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
Instructions The Pricing Worksheet shall be completed with unit prices, rates, and the Offeror's name. The Offeror is to only input prices in the "Pricing Worksheet" tab of the Excel file. All other calculations are embedded as formulas in the Evaluation worksheet for purposes of calculating the total evaluated price. The information inserted into Attachment 3 will be used by the Government for evaluation purposes and for purposes of inserting price information into the Schedule SF-1449.
| Pricing Worksheet Tab Instructions |
| Pricing Worksheet Tab: The pricing worksheet tab is for an Offeror’s input of unit prices for each Contract Line Item Number (CLIN) for each ordering period. The unit prices entered will be utilized to evaluate prices in the evaluation worksheet tab and the overall contract value and will be incorporated into the SF-1449 upon award by the Government. |
| Evaluation Worksheet Tab Instructions |
| Evaluation Worksheet Tab: The evaluation worksheet tab utilizes unit prices inserted by Offerors in the pricing worksheet tab. The evaluation worksheet displays the estimated ordering quantity for each ordering period. It also provides a unit price based on the inputs from the pricing worksheet tab. The evaluation worksheet calculates the total amount per CLIN and then a total evaluated price. This allows the USCG to evaluate pricing based on what the USCG anticipates ordering. This value will establish maximum contract value and this information will be inserted, by the USCG, into the SF-1449 upon award. |
| For the CLIN X014 series, a USCG provided ceiling amount is utilized for anticipated materials and subcontracts cost associated with logistic support needs. This amount is used for evaluation purposes only and will be applied to the overall contracting value. Loading rate percentages will be added to the USCG provided ceiling amount. CLIN X014 series also has labor rates, which will be evaluated and applied to the overall CLIN value and the total contract value. Please note: The loading rate percentages will be added to the USCG provided ceiling amounts for anticipated materials and subcontract costs. |
| RFP No. 70Z02322R93250001 | CB-LRI III Pricing Worksheet |
| Instructions | Attachment 3 |
Pricing Worksheet
| {Enter Offeror Name} | Contract Year Ordered | |||||||
| CLIN No. | Activity/Action | Unit | Base | 1 | 2 | 3 | 4 | |
| X001 | CB-LRI III. | |||||||
| [IAW SPEC less items priced separately below] | EA | |||||||
| X002 | Trailer and Trailer Equipment. | |||||||
| [SPEC: 910-1] | EA | |||||||
| X003 | Boat Shipping-Includes boat, trailer and all associated outfit/parts. |
[SPEC: 084-3]
| X003AA | CONUS | JB |
| X003AB | Hawaii | JB |
| X004 | Trailer Shipping-Independent shipment of trailer without boat. |
[SPEC: 084-3]
| X004AA | CONUS | JB | |
| X004AB | Hawaii | JB | |
| X005 | Boat Familiarization CONUS. | ||
| [SPEC: 089-1] | JB | ||
| X006 | Boat Familiarization Hawaii. | ||
| [SPEC: 089-1] | JB | ||
| X007 | System Insurance Stock. FOB CONUS. |
[SPEC: 083-6]
| X007AA | Engine | EA | |
| X007AB | Jet Drive | EA | |
| X007AC | Fendering | EA | |
| X008 | Logistics Conference. | ||
| [SPEC: 080-1, 083, 085, 086] | EA | ||
| X009 | Tech Data before Open Hull Inspection (TDP 1). | ||
| [SPEC: 068-1.3, 073-1.3, 083-3, 085-7, 096-3, 660-1.2] | EA | ||
| X010 | Tech Data with First Delivery Order (TDP 2). | ||
| [SPEC: 083-4, 085-3, 086-3, 092-3, 097] | EA | ||
| X011 | Tech Data with Second Delivery Order (TDP 3). |
[SPEC: 041-2, 041-4.8, 083-4, 085-2, 085-3, 085-7, 086-3, 086-6, 096-3]
| X011AA | Initial | EA | |
| X011AB | Final | EA | |
| X012 | Replica Model. | ||
| [SPEC: 098] | EA | ||
| X013 | Ballistic Panels. [SPEC: 164] | EA | |
| X014 | Materials and Subcontracts. Loading Rate (%) : All inclusive loading rate to be added to materials and subcontracts. Materials and Subcontracts will be negotiated at time of order/modification. | ||
| [SPEC: 080-2] | % | ||
| Composite Labor Rate Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | |||
| [SPEC: 080-2] | HR | ||
| Composite Labor Rate Non-Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | |||
| [SPEC: 080-2] | HR | ||
| Travel for Item X014 - Reimbursable at Cost IAW FAR 31.205-46. | |||
| [SPEC: 080-2] | Total Specified by the Government |
RFP No. 70Z02322R93250001 LRI III Pricing Worksheet Attachment X
Evaluation Worksheet
| {Enter Offeror Name} | ||||||
| Five (5) One-Year Ordering Periods | ||||||
| Base Year IDIQ Pricing | ||||||
| CLIN | Description | Unit | Qty | Unit Price | Total | |
| 0001 | CB-LRI III [IAW SPEC less items priced separately below] | EA | 2 | $0.00 | $0.00 | |
| 0002 | Trailer & Trailer Equipment [SPEC: 910-1] | EA | 2 | $0.00 | $0.00 | |
| 0003AA | Boat Shipping (CONUS) [SPEC: 084-3] | JB | 2 | $0.00 | $0.00 | |
| 0005 | Boat Familiarization CONUS [SPEC: 089-1] | JB | 2 | $0.00 | $0.00 | |
| 0008 | Logistics Conference [SPEC: 080-1, 083, 085, 086] | EA | 1 | $0.00 | $0.00 | |
| 0009 | Tech Data before Open Hull Inspection (TDP 1) [SPEC: 068-1.3, 073-1.3, 083-3, 085-7, 096-3, 660-1.2] | EA | 1 | $0.00 | $0.00 | |
| 0010 | Tech Data with First Delivery Order (TDP 2) [SPEC: 083-4, 085-3, 086-3, 092-3, 097] | EA | 1 | $0.00 | $0.00 | |
| 0014 | Rates for Orders Requiring a Proposal | $105,000.00 | ||||
| Materials and Subcontracts. Loading Rate (%) : All inclusive loading rate to be added to materials and subcontracts. Materials and Subcontracts will be negotiated at time of order/modification. | ||||||
| [SPEC: 080-2] | $ | $100,000.00 | 100% | |||
| Composite Labor Rate Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 120 | $0.00 | |||
| Composite Labor Rate Non-Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 120 | $0.00 | |||
| Travel for Item X014 - Reimbursable at Cost IAW FAR 31.205-46. | ||||||
| [SPEC: 080-2] | $ | $5,000.00 | ||||
| Year 1 IDIQ Pricing | ||||||
| CLIN | Description | Unit | Qty | Unit Price | Total | |
| 1001 | CB-LRI III [IAW SPEC less items priced separately below] | EA | 5 | $0.00 | $0.00 | |
| 1002 | Trailer & Trailer Equipment [SPEC: 910-1] | EA | 5 | $0.00 | $0.00 | |
| 1003AA | Boat Shipping (CONUS) [SPEC: 084-3] | JB | 5 | $0.00 | $0.00 | |
| 1003AB | Boat Shipping Hawaii | |||||
| [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | ||
| 1004AA | Trailer Shipping (CONUS) [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | |
| 1004AB | Trailer Shipping Hawaii | |||||
| [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | ||
| 1005 | Boat Familiarization CONUS [SPEC: 089-1] | JB | 5 | $0.00 | $0.00 | |
| 1006 | Boat Familiarization Hawaii | |||||
| [SPEC: 089-1] | JB | 1 | $0.00 | $0.00 | ||
| 1007AA | System Insurance Stock - Engine [SPEC: 083-6] | EA | 2 | $0.00 | $0.00 | |
| 1007AB | System Insurance Stock - Jet Drive [SPEC: 083-6] | EA | 2 | $0.00 | $0.00 | |
| 1007AC | System Insurance Stock - Fendering [SPEC: 083-6] | EA | 1 | $0.00 | $0.00 | |
| 1011AA | Tech Data with Second Delivery Order (TDP 3) Initial [SPEC: 041-2, 041-4.8, 083-4, 085-2, 085-3, 085-7, 086-3, 086-6, 096-3] | EA | 1 | $0.00 | $0.00 | |
| 1011AB | Tech Data with Second Delivery Order (TDP 3) Final [SPEC: 041-2, 041-4.8, 083-4, 085-2, 085-3, 085-7, 086-3, 086-6, 096-3] | EA | 1 | $0.00 | $0.00 | |
| 1012 | Replica Model [SPEC: 098] | EA | 2 | $0.00 | $0.00 | |
| 1013 | Ballistic Panels [SPEC: 164] | EA | 1 | $0.00 | $0.00 | |
| 1014 | Rates for Orders Requiring a Proposal | $205,000.00 | ||||
| Materials and Subcontracts. Loading Rate (%) : All inclusive loading rate to be added to materials and subcontracts. Materials and Subcontracts will be negotiated at time of order/modification. | ||||||
| [SPEC: 080-2] | $ | $200,000.00 | 100% | |||
| Composite Labor Rate Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 120 | $0.00 | |||
| Composite Labor Rate Non-Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 120 | $0.00 | |||
| Travel for Item X014 - Reimbursable at Cost IAW FAR 31.205-46. | ||||||
| [SPEC: 080-2] | $ | $5,000.00 | ||||
| Year 2 IDIQ Pricing | ||||||
| CLIN | Description | Unit | Qty | Unit Price | Total | |
| 2001 | CB-LRI III [IAW SPEC less items priced separately below] | EA | 5 | $0.00 | $0.00 | |
| 2002 | Trailer & Trailer Equipment [SPEC: 910-1] | EA | 5 | $0.00 | $0.00 | |
| 2003AA | Boat Shipping (CONUS) [SPEC: 084-3] | JB | 5 | $0.00 | $0.00 | |
| 2003AB | Boat Shipping Hawaii | |||||
| [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | ||
| 2004AA | Trailer Shipping (CONUS) [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | |
| 2004AB | Trailer Shipping Hawaii | |||||
| [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | ||
| 2005 | Boat Familiarization CONUS [SPEC: 089-1] | JB | 5 | $0.00 | $0.00 | |
| 2006 | Boat Familiarization Hawaii | |||||
| [SPEC: 089-1] | JB | 1 | $0.00 | $0.00 | ||
| 2007AA | System Insurance Stock - Engine [SPEC: 083-6] | EA | 4 | $0.00 | $0.00 | |
| 2007AB | System Insurance Stock - Jet Drive [SPEC: 083-6] | EA | 4 | $0.00 | $0.00 | |
| 2007AC | System Insurance Stock - Fendering [SPEC: 083-6] | EA | 2 | $0.00 | $0.00 | |
| 2012 | Replica Model [SPEC: 098] | EA | 1 | $0.00 | $0.00 | |
| 2013 | Ballistic Panels [SPEC: 164] | EA | 1 | $0.00 | $0.00 | |
| 2014 | Rates for Orders Requiring a Proposal | $55,000.00 | ||||
| Materials and Subcontracts. Loading Rate (%) : All inclusive loading rate to be added to materials and subcontracts. Materials and Subcontracts will be negotiated at time of order/modification. | ||||||
| [SPEC: 080-2] | $ | $50,000.00 | 100% | |||
| Composite Labor Rate Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 40 | $0.00 | |||
| Composite Labor Rate Non-Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 40 | $0.00 | |||
| Travel for Item X014 - Reimbursable at Cost IAW FAR 31.205-46. | ||||||
| [SPEC: 080-2] | $ | $5,000.00 | ||||
| Year 3 IDIQ Pricing | ||||||
| CLIN | Description | Unit | Qty | Unit Price | Total | |
| 3001 | CB-LRI III [IAW SPEC less items priced separately below] | EA | 4 | $0.00 | $0.00 | |
| 3002 | Trailer & Trailer Equipment [SPEC: 910-1] | EA | 4 | $0.00 | $0.00 | |
| 3003AA | Boat Shipping (CONUS) [SPEC: 084-3] | JB | 2 | $0.00 | $0.00 | |
| 3003AB | Boat Shipping Hawaii | |||||
| [SPEC: 084-3] | JB | 2 | $0.00 | $0.00 | ||
| 3004AA | Trailer Shipping (CONUS) [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | |
| 3004AB | Trailer Shipping Hawaii | |||||
| [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | ||
| 3005 | Boat Familiarization CONUS [SPEC: 089-1] | JB | 2 | $0.00 | $0.00 | |
| 3006 | Boat Familiarization Hawaii | |||||
| [SPEC: 089-1] | JB | 2 | $0.00 | $0.00 | ||
| 3007AA | System Insurance Stock - Engine [SPEC: 083-6] | EA | 1 | $0.00 | $0.00 | |
| 3007AB | System Insurance Stock - Jet Drive [SPEC: 083-6] | EA | 1 | $0.00 | $0.00 | |
| 3007AC | System Insurance Stock - Fendering [SPEC: 083-6] | EA | 1 | $0.00 | $0.00 | |
| 3012 | Replica Model [SPEC: 098] | EA | 1 | $0.00 | $0.00 | |
| 3013 | Ballistic Panels [SPEC: 164] | EA | 1 | $0.00 | $0.00 | |
| 3014 | Rates for Orders Requiring a Proposal | $55,000.00 | ||||
| Materials and Subcontracts. Loading Rate (%) : All inclusive loading rate to be added to materials and subcontracts. Materials and Subcontracts will be negotiated at time of order/modification. | ||||||
| [SPEC: 080-2] | $ | $50,000.00 | 100% | |||
| Composite Labor Rate Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 40 | $0.00 | |||
| Composite Labor Rate Non-Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 40 | $0.00 | |||
| Travel for Item X014 - Reimbursable at Cost IAW FAR 31.205-46. | ||||||
| [SPEC: 080-2] | $ | $5,000.00 | ||||
| Year 4 IDIQ Pricing | ||||||
| CLIN | Description | Unit | Qty | Unit Price | Total | |
| 4001 | CB-LRI III [IAW SPEC less items priced separately below] | EA | 1 | $0.00 | $0.00 | |
| 4002 | Trailer & Trailer Equipment [SPEC: 910-1] | EA | 1 | $0.00 | $0.00 | |
| 4003AA | Boat Shipping (CONUS) [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | |
| 4003AB | Boat Shipping Hawaii | |||||
| [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | ||
| 4004AA | Trailer Shipping (CONUS) [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | |
| 4004AB | Trailer Shipping Hawaii | |||||
| [SPEC: 084-3] | JB | 1 | $0.00 | $0.00 | ||
| 4005 | Boat Familiarization CONUS [SPEC: 089-1] | JB | 1 | $0.00 | $0.00 | |
| 4006 | Boat Familiarization Hawaii | |||||
| [SPEC: 089-1] | JB | 1 | $0.00 | $0.00 | ||
| 4007AA | System Insurance Stock - Engine [SPEC: 083-6] | EA | 2 | $0.00 | $0.00 | |
| 4007AB | System Insurance Stock - Jet Drive [SPEC: 083-6] | EA | 2 | $0.00 | $0.00 | |
| 4007AC | System Insurance Stock - Fendering [SPEC: 083-6] | EA | 2 | $0.00 | $0.00 | |
| 4012 | Replica Model [SPEC: 098] | EA | 1 | $0.00 | $0.00 | |
| 4013 | Ballistic Panels [SPEC: 164] | EA | 1 | $0.00 | $0.00 | |
| 4014 | Rates for Orders Requiring a Proposal | $55,000.00 | ||||
| Materials and Subcontracts. Loading Rate (%) : All inclusive loading rate to be added to materials and subcontracts. Materials and Subcontracts will be negotiated at time of order/modification. | ||||||
| [SPEC: 080-2] | $ | $50,000.00 | 100% | |||
| Composite Labor Rate Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 40 | $0.00 | |||
| Composite Labor Rate Non-Engineering: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. | ||||||
| [SPEC: 080-2] | Hr | 40 | $0.00 | |||
| Travel for Item X014 - Reimbursable at Cost IAW FAR 31.205-46. | ||||||
| [SPEC: 080-2] | $ | $5,000.00 |
Total Evaluated Price - Five (5) One-Year Ordering Periods $475,000.00
RFP No. 70Z02322R93250001 LRI III Pricing Worksheet Attachment X
File details come from the government source that posted it. Updated .