J-1 Pricing Schedule.xlsx
XLSX spreadsheet 37 KB Posted
- Solicitation number
- 70Z02326R93250001
- Issued by
- Not on record
About this file
This is a pricing schedule template (J-1 Pricing Schedule) for the USCG Response Boat Small Third Generation (RB-S III) solicitation. The pricing schedule is designed to capture costs associated with the design, production, testing, delivery, and logistics support for RB-S III boats and purpose-built trailers under a two-phase competitive acquisition process. Offerors are required to submit detailed pricing for the demonstrator boat and trailer that will be delivered to Phase I awardees, as well as pricing for anticipated production quantities across the ten-year IDIQ ordering period (consisting of a two-year base ordering period and an eight-year option period). The schedule establishes the cost framework for evaluating proposals under Phase I Factor III (Price) and enables the Government to conduct best-value tradeoffs against non-price factors including Mission Effectiveness and Production and Management capabilities.
The pricing template supports the Government's plan to award up to four IDIQ contracts to qualified offerors who successfully complete Phase II in-water demonstrations. Pricing submissions must account for all labor, materials, overhead, and related costs necessary to deliver boats, trailers, technical documentation, configuration management, and supply support services. The competitive down-select process uses this pricing schedule to ensure cost reasonableness while maintaining quality standards for recapitalizing the USCG's aging 29-foot RB-S II fleet. As a template document, the specific line items, quantity breakdowns, and pricing units within the J-1 schedule are established to standardize cost proposals across all competing offerors.
View the file
Other files
Show all 14
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
| Pricing Worksheet Instructions |
| The pricing schedule serves multiple functions. |
During proposal evaluation, the pricing you enter will be used to calculate your Total Evaluated Price for comparison to other offerors.
Prior to award the pricing will be used to establish the contract ceiling (this represents the cost to the Government if all possible items are ordered).
The contract ceiling calculation is not included as part of this Excel document.
At award, the pricing schedule will be used to establish pricing on the contract Schedule.
Fill in your name.
Fill all orange highlighted cells. As you fill this worksheet – the TEP tab will auto calculate your Total Evaluated Price.
The Estimated quantities (Est Qty) on this tab are provided solely for price evaluation and do not obligate the Government to order these quantities.
CLIN X001: the darker orange cells indicate the pricing used to calculate TEP for that Ordering Period (OP). This is solely to establish TEP and does not obligate the government to order in the indicated quantities.
All tier pricing should be filled in for each order year, though only the darker cells are used in establishing TEP. The other tiered prices in the Ordering Period (OP) will be reviewed for cost reasonableness and balanced pricing. Tier pricing should reflect realistic economies of scale and production efficiencies.
CLIN X001 pricing is tiered based on the order quantity. If 45 boats are ordered, all 45 boats are at the Tier 4 pricing.
CLINs X002 through X006, X011 through X014, and X016, enter the proposed price for all available Ordering Periods (OPs).
CLIN X007 should be entered as a percentage. This represents your loading rate for any materials or subcontracts ordered as part of CLIN X007. The Loading Rate (%) must incorporate all indirects (e.g., material handling, subcontract administration, G&A) and profit/fee. The TEP worksheet has a pre-established dollar amount for each Ordering Period (OP) that this loading rate is applied to in establishing your TEP. The pre-established amount on the TEP tab is solely for price evaluation and does not obligate the Government to order these quantities.
CLIN X008 and X009 represent your fully burdened firm-fixed Composite Labor Rates for Non-Engineering and Engineering Labor ordered as part of CLIN X008/009. The TEP worksheet has a pre-established number of hours for each Ordering Period (OP) that these labor rates are applied to in establishing your TEP. The pre-established amounts on the TEP tab are solely for price evaluation and do not obligate the Government to order these quantities.
CLIN X010 travel pre-populated by the Government and will be included in your TEP. The pre-population established amounts on the TEP tab are solely for price evaluation and do not obligate the Government to order these quantities.
CLIN X015 Retrofit is pre-priced at $1 and any retrofit costs will be negotiated. Retrofit is not part of establishing the TEP.
CLIN X017 Non-Recurring Engineering for OGA variant is pre-priced at $1 and any costs to establish an OGA variant will be negotiated. The cost of establishing an OGA variant is not part of establishing the TEP.
All proposed prices shall be stated in U.S. Dollars (USD) and rounded to the nearest whole dollar.
Total Evaluated Price Worksheet:
There are no offeror inputs on the TEP worksheet. This worksheet is locked.
Pricing information entered on the Pricing Worksheet tab is used to calculate TEP on this worksheet. The offeror can use this worksheet to view TEP for awareness of the price that will be used in the price evaluation.
The TEP worksheet multiplies the Qty indicated by the Pricing from the Pricing Worksheet for each CLIN, each year, to establish the extended price, which is summed in the CLIN Total column.
For CLIN X001 the TEP pulls pricing from the darker orange highlighted cells on the Pricing Worksheet.
The quantities on this worksheet are estimates and used solely for price evaluation and do not obligate the Government to order these quantities.
| Total Evaluated Price (TEP) Calculation |
| The TEP for CLIN X001 will be calculated by multiplying the proposed Tier unit price (matching the estimated ordering quantity tier) by the estimated quantity for each respective Ordering Period (OP). Examples: |
• OP1: The TEP is calculated by multiplying the proposed Tier 1 unit price by 1 (the estimated quantity for OP1).
• OP2: The TEP is calculated by multiplying the proposed Tier 2 unit price by 6 (the estimated quantity for OP2).
• OP3: The TEP is calculated by multiplying the proposed Tier 4 unit price by 60 (the estimated quantity for OP3).
• OP8: The TEP is calculated by multiplying the proposed Tier 5 unit price by 65 (the estimated quantity for OP8).
The TEP for CLINs X002 through X006, X008, X009, X011 through X014, and X016 will be calculated by multiplying the Offeror's Proposed Unit Price (or Labor Rate) by the Government's Estimated Quantity on the TEP worksheet for each respective Ordering Period (OP).
For CLIN X007, the Government has pre-populated an estimated material dollar amount for each Ordering Period (OP) (e.g., $300,000.00 in Year 1). The TEP is calculated by multiplying this pre-populated estimated dollar amount by the sum of 1 plus the proposed loading rate. Example, if the proposed loading rate for OP1 is 12% (0.12), the TEP calculation is: $300,000.00 × (1+0.12) = $336,000.00.
CLIN X010 travel pre-populated by the Government and will be included in your TEP. The pre-population established amounts on the TEP tab are solely for price evaluation and do not obligate the Government to order these quantities.
The estimated quantities on the Pricing Worksheet tab and on the TEP tab are for proposals purposes only. They do not obligate the government to placing orders in the indicated quantities.
RFP No. 70Z02326R93250001 USCG RB-S III Pricing Schedule Section J Attachment 1
&P of &N
Pricing Schedule
| Fill by Offeror: Offeror's Name | |||||||||||||
| Pricing Worksheet | |||||||||||||
| Fill By | CLINS | Description | UOM | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | Ordering Period 6 | Ordering Period 7 | Ordering Period 8 | Ordering Period 9 | Ordering Period 10 |
| Offeror | X001 | RB-S III (the Boat and Trailer) SOW / SPEC unless items priced separately below | |||||||||||
| Tier 1 (1 to 5 boats): | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Tier 2 (6 to 15 boats): | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Tier 3 (16 to 40 boats): | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Tier 4 (41 to 60 boats): | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Tier 5 (61+ boats): | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| USCG | Estimated # of RB-S III / OP | EA | 1 | 6 | 60 | 60 | 60 | 60 | 60 | 65 | 68 | 60 | |
| X001 TEP Unit Price | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Offeror | X002 | Boat and Trailer Shipping - CONUS [SOW/SPEC 084-3] | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Offeror | X003 | Boat and Trailer Shipping - OCONUS [SOW/SPEC 084-3] | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Offeror | X004 | Crew FAM - CONUS [SOW/SPEC 089] | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Offeror | X005 | Crew FAM - OCONUS [SOW/SPEC 089] | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Offeror | X006 | List of Deliverables [SOW/SPEC/Section C Attachment 4] | $ | $0.00 | $0.00 | ||||||||
| Offeror | X007 | 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/SPEC 80] | % | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% |
| Offeror | X008 | Services - Labor (Composite Labor Rate Non-Engineering) [SOW/SPEC 80-1] | $/Hr. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Offeror | X009 | Services - Engineering (Composite Labor Rate Engineering) [SOW/SPEC 80-1] | $/Hr. | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| USCG | X010 | Travel - Reimbursable at Cost IAW FAR 31.205-46 | $ | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 |
| Offeror | X011 | MRL Kit (Additional) [SOW/SPEC 083-2.5] | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Offeror | X012 | Insurance Spares - Outboard Engine (Port) [SOW/SPEC 083-5.3.1] | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Offeror | X013 | Insurance Spares - Outboard Engine (STBD) [SOW/SPEC 083-5.3.2] | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Offeror | X014 | Insurance Spares - Fendering System [SOW/SPEC 083-5.3.3] | $ | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| USCG | X015 | Retrofit [SOW/SPEC 041-5.1.4] | $ | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 |
| Offeror | X016 | Display Model [SOW/SPEC 098] | $ | $0.00 | $0.00 | ||||||||
| USCG | X017 | Non-Recurring Engineering for OGA Variant | $ | $1.00 |
&28RFP No. 70Z02326R93250001 &28USCG RB-S III Pricing Schedule &28Section J Attachment 1
&36&P of &N
TEP
| Fill by Offeror: Offeror's Name | 0 | 0 | ||||||||||||
| TEP | $7,840,000.00 | |||||||||||||
| Fill By | CLINS | Description | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | Ordering Period 6 | Ordering Period 7 | Ordering Period 8 | Ordering Period 9 | Ordering Period 10 | CLIN Total | |
| USCG | X001 | RB-S III (the Boat and Trailer) SOW / SPEC unless items priced separately below | Qty | 1 | 6 | 60 | 60 | 60 | 60 | 60 | 65 | 68 | 60 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X002 | Boat and Trailer Shipping - CONUS [SOW/SPEC 084-3] | Qty | 1 | 6 | 54 | 54 | 54 | 54 | 54 | 60 | 68 | 60 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X003 | Boat and Trailer Shipping - OCONUS [SOW/SPEC 084-3] | Qty | 0 | 0 | 6 | 6 | 6 | 6 | 6 | 5 | 0 | 0 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X004 | Crew FAM - CONUS [SOW/SPEC 089] | Qty | 1 | 6 | 54 | 54 | 54 | 54 | 54 | 60 | 68 | 60 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X005 | Crew FAM - OCONUS [SOW/SPEC 089] | Qty | 0 | 0 | 6 | 6 | 6 | 6 | 6 | 5 | 0 | 0 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X006 | List of Deliverables [SOW/SPEC/Section C Attachment 4] | Qty | 1 | 1 | $0.00 | ||||||||
| Unit Price | $0.00 | $0.00 | ||||||||||||
| Ext Price | $0.00 | $0.00 | ||||||||||||
| USCG | X007 | Materials and Subcontracts. [SOW/SPEC 80] | Qty | $300,000.00 | $600,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $250,000.00 | $250,000.00 | $7,400,000.00 |
| Rate | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | ||||
| Ext Price | $300,000.00 | $600,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $250,000.00 | $250,000.00 | ||||
| USCG | X008 | Services - Labor (Composite Labor Rate Non-Engineering) [SOW/SPEC 80-1] | Qty | 200 | 1,000 | 1,000 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | $0.00 |
| Unit Price | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X009 | Services - Engineering (Composite Labor Rate Engineering) [SOW/SPEC 80-1] | Qty | 200 | 1,000 | 1,000 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X010 | Travel - Reimbursable at Cost IAW FAR 31.205-46 | Qty | 10,000 | 30,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 20,000 | 20,000 | $440,000.00 |
| Unit Price | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | ||||
| Ext Price | $10,000.00 | $30,000.00 | $60,000.00 | $60,000.00 | $60,000.00 | $60,000.00 | $60,000.00 | $60,000.00 | $20,000.00 | $20,000.00 | ||||
| USCG | X011 | MRL Kit (Additional) [SOW/SPEC 083-2.5] | Qty | 0 | 0 | 6 | 36 | 60 | 66 | 96 | 0 | 0 | 0 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X012 | Insurance Spares - Outboard Engine (Port) [SOW/SPEC 083-5.3.1] | Qty | 0 | 3 | 18 | 18 | 18 | 18 | 18 | 18 | 0 | 0 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X013 | Insurance Spares - Outboard Engine (STBD) [SOW/SPEC 083-5.3.2] | Qty | 0 | 3 | 18 | 18 | 18 | 18 | 18 | 18 | 0 | 0 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X014 | Insurance Spares - Fendering System [SOW/SPEC 083-5.3.3] | Qty | 0 | 3 | 6 | 6 | 6 | 6 | 6 | 6 | 0 | 0 | $0.00 |
| Unit Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| Ext Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| USCG | X015 | Retrofit [SOW/SPEC 041-5.1.4] | Qty | 0 | 60,000 | 360,000 | 600,000 | 600,000 | 600,000 | 600,000 | 600,000 | 580,000 | 200,000 | |
| Unit Price | ||||||||||||||
| Ext Price | ||||||||||||||
| USCG | X016 | Display Model [SOW/SPEC 098] | Qty | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | $0.00 |
| Unit Price | $0.00 | $0.00 | ||||||||||||
| Ext Price | $0.00 | $0.00 | ||||||||||||
| USCG | X018 | Non-Recurring Engineering for OGA Variant | Qty | 1000000 | ||||||||||
| Unit Price | ||||||||||||||
| Ext Price |
&28RFP No. 70Z02326R93250001 &28USCG RB-S III Pricing Schedule &28Section J Attachment 1
&36&P of &N
File details come from the government source that posted it. Updated .