Attachment 4_Pricing Worksheet.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- Request for Quotation: Special Purpose Craft – Ice Rescue Transport Second Generation (SPC-IRT II)
- Solicitation number
- 70Z02326Q93250001
About this file
This is a Pricing Worksheet template for the Special Purpose Craft – Ice Rescue Transport Second Generation (SPC-IRT II) Request for Quotation (RFQ) No. 70Z02326Q93250001 issued by the U.S. Coast Guard. The worksheet is designed for offerors to submit unit prices and rates across three contract years for evaluation purposes. Offerors must complete the blue-highlighted cells in the "Pricing Worksheet" tab with proposed pricing, while the locked "Evaluation Worksheet" tab automatically calculates the Total Evaluated Price for government evaluation.
The pricing template requires offerors to provide: (1) Boat prices per unit at $0 estimate (estimated quantity: 8, 1, 1 across years); (2) Heavy-duty tilting trailer prices per unit (estimated quantity: 8, 1, 1); (3) Shipping costs per boat and trailer to Great Lakes locations (estimated quantity: 8, 1, 1); (4) Training costs per two-day familiarization and operations training event for six personnel (estimated quantity: 8, 1, 1); (5) Drawings and Technical Data as a one-time cost; (6) ICLS and Non-Warranty Support composite labor rates expressed as hourly rates (estimated 2,000 hours per contract year); and (7) Materials and Subcontracts markup rates expressed as a percentage (estimated $10,000 per contract year). All values must be submitted in $1 increments except for the Materials and Subcontracts percentage rate. The pricing information will be transferred to the Standard Form 1449 (SF-1449) upon contract award for the anticipated three-year Period of Performance from September 2026 through September 2029 under a firm-fixed price Indefinite Delivery Indefinite Quantity (IDIQ) contract, which is designated as a total small business set aside.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 5_Q and A Form_Government Response_08312026.xlsx | XLSX spreadsheet | |
| SPC_IRT_II_RFQ.pdf | ||
| Attachment 1_Statement of Work.pdf | ||
| Attachment 2_Specification.pdf | ||
| Attachment 5_Q and A Form.xlsx | XLSX spreadsheet | |
| Attachment 3_List of Deliverables.pdf |
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
SPECIAL PURPOSE CRAFT- ICE RESCUE TRANSPORT SECOND GENERATION (SPC-IRT II)
ATTACHMENT 4 – PRICING WORKSHEET
RFQ No.: 70Z02326Q93250001 Instructions: The Pricing Worksheet should be completed with the Offer's name, unit prices,and rates. The Offeror must input prices exclusively in the “Pricing Worksheet” tab of the Excel file. The "Evaluation Worksheet" tab will autopopulate to indicate the 'Total Evaluated Price'.
The Pricing Worksheet will not be included in the resultant contract. The information in this attachment will be used by the Government for evaluation purposes and the pricing information will be transferred into the SF-1449 for award.
| Pricing Worksheet Tab Instructions |
| The blue highlighted cells on the Pricing Worksheet should be filled in with your proposed pricing, other cells in the worksheet are locked. All values must be in $1 increments with the exception of X006B which will be a percentage: |
* Offeror Name
* Boat Price (per boat - may vary by year)
* Trailer Price (per trailer - may vary by year)
* Shipping Cost (per boat+trailer - may vary by year)
* Training (per training event - may vary by year)
* Drawings and Technical Data (One time cost to deliver all technical information, including original and revised submissions)
* ICLS and Non-Warranty Support
- Composite labor rate (hourly labor rate for non-warranty or other technical support. The hourly rate may vary by year)
- Materials and Subcontracts (percentage markup applied to purchased material or subcontracted work, may vary by year)
Estimated quantities are provided for item X006A (hours) and X006B ($s) for evaluation purposes. The actual amount of X006A and X006B ordered may vary from these estimates. If /when ICLS or Non-Warranty Support is ordered, the proposed rates will be used to establish the cost of the support.
| Evaluation Worksheet Tab Instructions |
| You can view the evaluated price on the "Evaluation Worksheet" tab. This figure will be used in evaluating offers for potential award. This tab is locked for changes, but should auto populate as you enter data into the "Pricing Worksheet" tab. |
&"Times New Roman,Regular"RFP No. 70Z02326R9325000# &"Times New Roman,Regular"&12Attachment 4: Pricing Worksheet &"Times New Roman,Regular"Instructions
&"Times New Roman,Regular"RFP No. 70Z02326R9325000# &"Times New Roman,Regular"&12Attachment 4: Pricing Worksheet &"Times New Roman,Regular"Instructions
Pricing Worksheet
| Offeror: | Contract Year Ordered | ||||
| Item # | Description | Unit | 1 | 2 | 3 |
| X001 | Boat–25 ft Composite Ice Rescue Airboat with spares [SOW 083-2.4] and BIB [SOW 086-3] | EA | $ - 0 | $ - 0 | $ - 0 |
| Estimated Qty | 8 | 1 | 1 | ||
| X002 | Heavy-duty tilting trailer w/ electric winch [SPEC: 910] | EA | $ - 0 | $ - 0 | $ - 0 |
| Estimated Qty | 8 | 1 | 1 | ||
| X003 | Boat shipping - includes boat, trailer and all associated outfit /parts to Great Lakes locations. [SOW 084] | EA | $ - 0 | $ - 0 | $ - 0 |
| Estimated Qty | 8 | 1 | 1 | ||
| X004 | Training - Two Days FAM and Operations Training (Est. for 6 personnel) [SOW 089] | JB | $ - 0 | $ - 0 | $ - 0 |
| Estimated Qty | 8 | 1 | 1 | ||
| X005 | Drawings and Technical Data [SOW 085-086] | EA | $ - 0 | ||
| Estimated Qty | 1 | ||||
| X006 | ICLS and Non-Warranty Support | ||||
| X006A | Composite Labor Rate: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 11. [SOW: 080-1] | $/HR | $ - 0 | $ - 0 | $ - 0 |
| Estimated Qty | HR | 2000 | 2000 | 2000 | |
| X006B | 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. [SOW 080] | % | 0.00% | 0.00% | 0.00% |
| Estimated Qty | $ | $ 10,000 | $ 10,000 | $ 10,000 |
Evaluation Worksheet
| Offeror: | 0 | Contract Year | |||
| Item # | Description | Unit | 1 | 2 | 3 |
| X001 | Boat–25 ft Composite Ice Rescue boat with spares [SOW 083-2.4] and BIB [SOW 086-3] | $ | $0 | $0 | $0 |
| X002 | Heavy-duty tilting trailer w/ electric winch [SPEC: 910] | $ | $0 | $0 | $0 |
| X003 | Shipping - boat, trailer and all associated outfit /parts to Great Lakes locations. [SOW 084] | $ | $0 | $0 | $0 |
| X004 | Training - Two Days FAM and Operations Training (Est. for 6 personnel) [SOW 089] | $ | $0 | $0 | $0 |
| X005 | Drawings and Technical Data [SOW 085-086] | $ | $0 | ||
| X006 | ICLS and Non-Warranty Support | ||||
| X006A | Composite Labor Rate: In accordance with "Composite Labor Rate" in FAR 52.212-4, amended, Terms and Conditions 8. [SOW: 080-1] Estimate based on proposed labor rate and estimate of 2000 hours of support in each contract year | $ | $0 | $0 | $0 |
| X006B | 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. [SOW 080] Estimate based on proposed overhead rate and estimate of $10,000 of Materials or Subcontracts in each contract year | $ | $10,000 | $10,000 | $10,000 |
Total Evaluated Price: $ 30,000
File details come from the government source that posted it. Updated .