Attachment-3_SPC-HWX-II_PriceSchedule_A00001.xlsx
XLSX spreadsheet 39 KB Posted
- Solicitation number
- 70Z02325R93250001
About this file
This is a price schedule template (Attachment 3) for the Special Purpose Craft - Heavy Weather 2nd Generation (SPC-HWX II) procurement by the U.S. Coast Guard. The template covers a 7-year period consisting of a 3-year base ordering period and a 4-year optional ordering period, with CLINs structured for boat design, development, production, training, spare parts, and logistics support.
The price schedule includes specific line items for design and development, technical data submissions, boat production (up to 6 units), crew familiarization training, system insurance stock and spare parts, operational test support, interim contractor logistics support, special tools, and display models. Notable requirements include propulsion diesel engine sets, reduction gears, propeller shafts, generator sets, and maintenance kits. The evaluation worksheet shows a total evaluated price of $1,660,000, with $660,000 allocated for the base period and $1,000,000 for the optional period. CLIN X007 series includes pre-established ceiling amounts for materials and labor costs, with specified engineering and non-engineering labor hours for evaluation purposes.
View the file
Other files
Show all 25
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
| Price Schedule, shall be completed with unit prices, rates, and the Offeror’s name. The Offeror is to only input prices in the “Price Schedule” tab of Attachment 3. All other calculations are embedded as formulas in the Evaluation worksheet for purposes of calculating the total evaluated price and contract prices. These formulae shall not be altered. Attachment 3 will not be a part of the resultant contract. 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. |
| Price Schedule Tab Instructions |
| Price Schedule Tab: The Price Schedule tab is for an Offeror’s input of unit prices for each Contract Line Item Number (CLIN) for each ordering period and including options. The inserted unit prices are automatically put into the evaluation worksheet. At award, the unit prices, inserted into the Price Schedule tab, will be entered into the SF-1449, establishing the contract’s maximum value. |
With the exception of CLIN X007, all values should be entered in $100 increments.
| Evaluation Worksheet Tab Instructions |
| Evaluation Worksheet Tab: The evaluation worksheet tab uses unit prices inserted by Offerors in the price schedule tab. The evaluation worksheet displays the estimated ordering quantity for each ordering period and including options. It also provides a unit price based on the inputs from the price schedule 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 the maximum contract value and this information will be inserted, by the USCG, into the SF-1449 upon award. |
| For the CLIN X007 series, a USCG provided ceiling amount is used for anticipated materials and labor cost associated with logistic support needs. This amount is used for evaluation and will be applied to the overall contracting value. For proposal evaluation purposes material costs have been established as indicated in the Price Schedule to provide a uniform basis for comparison. These estimated material costs will be added to the USCG-provided ceiling amount. The CLIN X007 series also has labor hours established as indicated in the Price Schedule to provide a uniform basis for comparison. These labor hours will be multiplied by the proposed labor rates and will be applied to the overall CLIN value and the total contract value. |
| RFP No. &K00000070Z02325R93250001 | SPC-HWX II Price Schedule |
| Instructions | Attachment 3 |
Price Schedule
| {Enter Offeror Name} | ||||||||
| Base Ordering Period | Optional Ordering Period | |||||||
| Item # | Activity/Action | Base Year | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
| X001 | Design and Development [SPEC 068-3] | |||||||
| X001 | Unit Price (EA) | $ - 0 | ||||||
| X002 | Technical Data Submissions (TDS) [SOW 085 and 086] | |||||||
| X002AA | TDS-1 (DCB, 3D TDP of DCB, MECL, COTS Manuals, MRL, Firmware Support Manual, Calculations) | |||||||
| Unit Price (EA) | $ - 0 | |||||||
| X002AB | TDS-2 (p-PCB, 3D TDP of p-PCB) | |||||||
| Unit Price (EA) | $ - 0 | |||||||
| X002AC | TDS-3 and PCA (SOW 41-3.6, 3D TDP, 2D Product Drawings in CG format) | |||||||
| Unit Price (EA) | $ - 0 | |||||||
| X003 | Recurring Production - Boat Production (up to 6) | |||||||
| X003AA | Boat (up to 6) [IAW SPEC less LLTM] | |||||||
| Unit Price (EA) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X003AB | Long Lead-Time Materials (LLTM) [SOW 083-8] | |||||||
| Unit Price (EA) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X004 | Crew Familiarization Training [SOW 089] | |||||||
| X004 | Unit Price (EA) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X005 | System Insurance Stock and Spare Parts [SOW 083-6] | |||||||
| X005AA | Propulsion Diesel Engine Set (Port and Stbd) | |||||||
| Unit Price (Set P&S) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X005AB | Reduction Gear (P&S) | |||||||
| Unit Price (Set P&S) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X005AC | Propeller Shaft (EA) | |||||||
| Unit Price (EA) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X005AD | Propeller Set (P&S) | |||||||
| Unit Price (Set P&S) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X005AE | Generator Boat Set (engine(s) + generator(s)) | |||||||
| Unit Price (Boat Set) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X005AF | Fender Kit (Set) | |||||||
| Unit Price (Boat Set) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X005AG | 600 Hour Maintenance Kit | |||||||
| Unit Price (Kit) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X006 | Operational Test Support OT On-site Support [SOW 080-2] | |||||||
| X006 | Unit Price (Month) | $ - 0 | $ - 0 | |||||
| X007 | Orders Requiring a Proposal / Interim Contractor Logistics Support (ICLS) [SOW 080] | |||||||
| X007AA | Materials and Subcontracts | |||||||
| Loading Rate (%) | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Unit Price | $ 1.00 | $ 1.00 | $ 1.00 | $ 1.00 | $ 1.00 | $ 1.00 | $ 1.00 | |
| X007AB | Composite Labor Rate - Engineering | |||||||
| Unit Price ($) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X007AC | Composite Labor Rate - Non-Engineering | |||||||
| Unit Price ($) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X007AD | Travel | |||||||
| Unit Price ($) | Total Specifed by the Government | |||||||
| X008 | Special Tools | |||||||
| X008AA | Boat Storage Cradle and Shipping of Cradle [SOW 084-4] | |||||||
| Unit Price (EA) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X008AB | Other Special Tools [SOW 083-5] | |||||||
| Unit Price (Boat Set) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X009 | Display Model (up to 10) [SPEC 099] | |||||||
| X009 | Unit Price (EA) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Evaluation Worksheet
| Base Ordering Period (3 years) | |||||||
| Base Year IDIQ Pricing | |||||||
| CLIN | SUB-CLIN | Description | Unit | Qty | Unit Price | Total | Notes |
| X001 | X001 | Design and Development [SPEC 068-3] | EA | 1 | $ - 0 | $ - 0 | |
| X002 | X002AA | TDS-1 (DCB, 3D TDP of DCB, MECL, COTS Manuals, MRL, Firmware Support Manual, Calculations) | EA | 1 | $ - 0 | $ - 0 | |
| X002AB | TDS-2 (p-PCB, 3D TDP of p-PCB) | EA | 1 | $ - 0 | $ - 0 | ||
| X003 | X003AA | Boat (up to 6) [IAW SPEC less LLTM] | EA | 1 | $ - 0 | $ - 0 | |
| X003AB | Long Lead-Time Materials (LLTM) [SOW 083-8] | EA | 1 | $ - 0 | $ - 0 | ||
| Total Base Year | $ - 0 |
| Year 1 IDIQ Pricing | |||||||
| CLIN | SUB-CLIN | Description | Unit | Qty | Unit Price | Total | Notes |
| X004 | X004 | Crew Familiarization Training [SOW 089] | EA | 1 | $ - 0 | $ - 0 | |
| X005 | X005AD | Propeller Set (P&S) | ST | 1 | $ - 0 | $ - 0 | |
| X006 | X006 | Operational Test Support OT On-site Support [SOW 080-2] | MO | 6 | $ - 0 | $ - 0 | |
| X008 | X008AB | Other Special Tools [SOW 083-5] | ST | 1 | $ - 0 | $ - 0 | |
| Total Year 1 | $ - 0 |
| Year 2 IDIQ Pricing | |||||||
| CLIN | SUB-CLIN | Description | Unit | Qty | Unit Price | Total | Notes |
| X003 | X003AB | Long Lead-Time Materials (LLTM) [SOW 083-8] | EA | 2 | $ - 0 | $ - 0 | |
| X005 | X005AG | 600 Hour Maintenance Kit | KT | 1 | $ - 0 | $ - 0 | |
| X007 | X007AA | Materials and Subcontracts | JB | 610000 | $ 1 | $ 610,000 | |
| X007AB | Composite Labor Rate - Engineering | HR | 2100 | $ - 0 | $ - 0 | ||
| X007AC | Composite Labor Rate - Non-Engineering | HR | 1000 | $ - 0 | $ - 0 | ||
| X007AD | Travel | JB | 50000 | $ 1 | $ 50,000 | ||
| X009 | X009 | Display Model (up to 10) [SPEC 099] | EA | 1 | $ - 0 | $ - 0 | |
| Total Year 2 | $ 660,000 | ||||||
| Base Ordering Period Total | $ 660,000 |
| Optional Ordering Period (4 years) | |||||||
| Year 3 IDIQ Pricing | |||||||
| CLIN | SUB-CLIN | Description | Unit | Qty | Unit Price | Total | Notes |
| X002 | X002AC | TDS-3 and PCA (SOW 41-3.6, 3D TDP, 2D Product Drawings in CG format) | EA | 1 | $ - 0 | $ - 0 | |
| X003 | X003AA | Boat (up to 6) [IAW SPEC less LLTM] | EA | 2 | $ - 0 | $ - 0 | |
| X003AB | Long Lead-Time Materials (LLTM) [SOW 083-8] | EA | 1 | $ - 0 | $ - 0 | ||
| X004 | X004 | Crew Familiarization Training [SOW 089] | EA | 2 | $ - 0 | $ - 0 | |
| X005 | X005AD | Propeller Set (P&S) | EA | 2 | $ - 0 | $ - 0 | |
| X005AG | 600 Hour Maintenance Kit | KT | 1 | $ - 0 | $ - 0 | ||
| X007 | X007AA | Materials and Subcontracts | JB | 100000 | $ 1 | $ 100,000 | |
| X007AB | Composite Labor Rate - Engineering | HR | 100 | $ - 0 | $ - 0 | ||
| X008 | X008AB | Other Special Tools [SOW 083-5] | ST | 2 | $ - 0 | $ - 0 | |
| X009 | X009 | Display Model (up to 10) [SPEC 099] | EA | 3 | $ - 0 | $ - 0 | |
| Total Year 3 | $ 100,000 |
| Year 4 IDIQ Pricing | |||||||
| CLIN | SUB-CLIN | Description | Unit | Qty | Unit Price | Total | Notes |
| X003 | X003AA | Boat (up to 6) [IAW SPEC less LLTM] | EA | 3 | $ - 0 | $ - 0 | |
| X003AB | Long Lead-Time Materials (LLTM) [SOW 083-8] | EA | 2 | $ - 0 | $ - 0 | ||
| X004 | X004 | Crew Familiarization Training [SOW 089] | EA | 1 | $ - 0 | $ - 0 | |
| X005 | X005AA | Propulsion Diesel Engine Set (Port and Stbd) | ST | 2 | $ - 0 | $ - 0 | |
| X005AB | Reduction Gear (P&S) | EA | 2 | $ - 0 | $ - 0 | ||
| X005AC | Propeller Shaft (EA) | EA | 4 | $ - 0 | $ - 0 | ||
| X005AD | Propeller Set (P&S) | ST | 3 | $ - 0 | $ - 0 | ||
| X005AE | Generator Boat Set (engine(s) + generator(s)) | ST | 2 | $ - 0 | $ - 0 | ||
| X005AF | Fender Kit (Set) | ST | 2 | $ - 0 | $ - 0 | ||
| X005AG | 600 Hour Maintenance Kit | KT | 3 | $ - 0 | $ - 0 | ||
| X007 | X007AA | Materials and Subcontracts | JB | 300000 | $ 1 | $ 300,000 | |
| X007AB | Composite Labor Rate - Engineering | HR | 300 | $ - 0 | $ - 0 | ||
| X008 | X008AA | Boat Storage Cradle and Shipping of Cradle [SOW 084-4] | EA | 2 | $ - 0 | $ - 0 | |
| X008AB | Other Special Tools [SOW 083-5] | ST | 1 | $ - 0 | $ - 0 | ||
| X009 | X009 | Display Model (up to 10) [SPEC 099] | EA | 6 | $ - 0 | $ - 0 | |
| Total Year 4 | $ 300,000 |
| Year 5 IDIQ Pricing | |||||||
| CLIN | SUB-CLIN | Description | Unit | Qty | Unit Price | Total | Notes |
| X005 | X005AG | 600 Hour Maintenance Kit | KT | 6 | $ - 0 | $ - 0 | |
| X007 | X007AA | Materials and Subcontracts | JB | 600000 | $ 1 | $ 600,000 | |
| X007AB | Composite Labor Rate - Engineering | HR | 600 | $ - 0 | $ - 0 | ||
| X008 | X008AB | Other Special Tools [SOW 083-5] | ST | 2 | $ - 0 | $ - 0 | |
| Total Year 5 | $ 600,000 |
| Year 6 IDIQ Pricing | |||||||
| CLIN | SUB-CLIN | Description | Unit | Qty | Unit Price | Total | Notes |
| X005 | X005AG | 600 Hour Maintenance Kit | KT | 6 | $ - 0 | $ - 0 | |
| Total Year 6 | $ - 0 | ||||||
| Optional Ordering Period Total | $ 1,000,000 |
Total Evaluated Price (7 years) $ 1,660,000
File details come from the government source that posted it. Updated .