Section L Attachment L-2 Price Worksheets A00002.xlsx
XLSX spreadsheet 80 KB Posted
- Attached to
- US Coast Guard Waterways Commerce Cutter Program
- Solicitation number
- 70Z02321RPRT00300
About this file
This document includes a pricing workbook template for a solicitation from the U.S. Coast Guard seeking the design and production of up to twenty-seven Waterways Commerce Cutters through an Indefinite Delivery Indefinite Quantity contract. The workbook templates include pricing sheets for multiple contract line item numbers covering areas such as production support, long lead time materials, deep insurance spares, training, transportation and special studies over ten ordering periods from fiscal year 2022 through 2031. Offerors are instructed to populate labor rates, material costs, overhead rates and profit percentages within the templates to calculate total proposed prices by line item and ordering period. Submission of proposals in response to the solicitation are due by July 30, 2021 following the question deadline of June 1, 2021. Award is planned for one contract resulting from a full and open competition set aside for small business concerns.
View the file
Other files
Show 40 more
Latest 50 of 62 listed here. See the rest on GovTribe.
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
| Section L, Attachment L-2: Price Worksheets |
| Instructions to Offeror for Solicitation 70Z02321RPRT00300 |
| This workbook will be used to calculate the Offerors total evaluated price. |
Planned quantities per ordering period have been included.
| Offerors shall edit only and all worksheets and cells highlighted in green. |
| 1. Worksheets "Prod_Class", "LLTM", "Deep_Ins_Spares", "LCATS", and "Other_Rates" shall be populated first. These worksheets feed data to the Ordering Period worksheets, "P1"-"P10", as appropriate, with the exceptions of "LCATS" and "Other_Rates", which are standalone. |
2. Worksheets "P1"-"P10" shall be populated, in green cells. These are linked to the "Total Price" worksheet.
| The Offeror shall propose a price for every field highlighted in green. |
| For cells highlighted in green and with an estimated quantity of "0", the Government is seeking to establish unit pricing should the Government choose to issue a task order for the corresponding CLIN in that Ordering Period. |
| Stepladder Pricing has been added as a tab. |
Offeror shall input proposed unit costs for each of the specified quantities across the requested ordering periods.
Offeror shall input proposed discount percentages for the specified quantities across the requested ordering periods, if any.
| Fields highlighted in grey either pull data from an alternate tab or feed to an alternate tab. They are not to be edited by the Offeror. |
| Fields highlighted in black shall not be edited by the Offeror. |
| The "Total Price" worksheet automatically draws data from the individual ordering period worksheets. |
| Fields not highlighted shall not be edited by the Offeror. |
| This workbook has been developed to automatically calculate totals, including multiplying by quantities. The Offeror shall only add unit pricing where requested and highlighted. |
Unit pricing shall be in whole dollars.
Total_Price
| WCC Total Price Sheet | Ordering Period | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | ||
| CLIN | Task | CLIN Type | FY22 | FY23 | FY24 | FY25 | FY26 | FY27 | FY28 | FY29 | FY30 | FY31 | Total Price |
| -01 | Design and Engineering | FFP | - 0 | - 0 | |||||||||
| -01 | Production and Support (WLR) | NSP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -01AA | Production/Classing (WLR) | FP EPA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -01AB | Technical Data (WLR) | NSP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -01AC | Warranty (WLR) | FFP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -01AD | Factory Training (WLR) | NTE | 350,000 | 700,000 | 700,000 | 700,000 | 700,000 | 700,000 | 1,050,000 | 700,000 | - 0 | 5,600,000 | |
| -02 | Production and Support (WLIC) | NSP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -02AA | Production/Classing (WLIC) | FP EPA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -02AB | Technical Data (WLIC) | NSP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -02AC | Warranty (WLIC) | FFP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -02AD | Factory Training (WLIC) | NTE | 350,000 | 350,000 | 700,000 | 700,000 | 700,000 | 700,000 | 350,000 | - 0 | - 0 | 3,850,000 | |
| -03 | Long Lead Time Materials | NSP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| -03AA | Long Lead Time Materials (WLR) | FFP EPA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| -03AB | Long Lead Time Materials (WLIC) | FFP EPA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| -04 | Deep Insurance Spares | FP EPA | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -05 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 3,000,000 | 4,500,000 | 6,000,000 | 6,000,000 | 6,000,000 | 6,000,000 | 6,000,000 | 3,000,000 | - 0 | 40,500,000 | |
| -06 | Training Support | NSP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -06AA | SME Access | FFP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||
| -06AB | Training Aids | FFP | - 0 | - 0 | |||||||||
| -07 | Cutter Transport to Delivery Location | NSP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -07AA | Cutter Transport (New Orleans, LA) | FFP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -07AB | Cutter Transport (St. Louis, MO) | FFP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| -08 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 4,500,000 | |
| -09 | Capital Expenditures | NTE | 1,000,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 1,000,000 |
| -10 | Optional Data Rights | NTE | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Total Price | 1,000,000 | 4,200,000 | 6,050,000 | 7,900,000 | 7,900,000 | 7,900,000 | 7,900,000 | 7,900,000 | 4,200,000 | 500,000 | 55,450,000 |
Prod_Class
| Production/Classing WLR | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | ||||||||||||||||||
| Labor Costs | ||||||||||||||||||||||||||||
| Labor Category Pools | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | |
| Program Management | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Engineering | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Production | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| Indirect Rate (%)- Labor | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| WLR Labor Total | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||
| Material Costs | ||||||||||||||||||||||||||||
| Raw Material | ||||||||||||||||||||||||||||
| Equipment | ||||||||||||||||||||||||||||
| Subcontractor Costs | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| Indirect Rate (%)- Material | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| WLR Material Total | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Profit Percentage (Applied to Labor and Material) | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Total WLR Unit Cost | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Note: The costs associated with Long Lead Time Materials shall be included within the separate worksheet "LLTM". |
| Production/Classing WLIC | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | ||||||||||||||||||
| Labor Costs | ||||||||||||||||||||||||||||
| Labor Category Pools | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | Hours | Rate | Total | |
| Program Management | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Engineering | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Production | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| {Insert Labor Category Pool Type} | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| Indirect Rate - Labor | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| WLIC Labor Total | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||
| Material Costs | ||||||||||||||||||||||||||||
| Raw Material | ||||||||||||||||||||||||||||
| Equipment | ||||||||||||||||||||||||||||
| Subcontractor Costs | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| {Insert Material Type} | ||||||||||||||||||||||||||||
| Indirect Rate - Material | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| WLIC Material Total | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Profit Percentage (Applied to Labor and Material) | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Total WLIC Unit Cost | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||
| Note: The costs associated with Long Lead Time Materials shall be included within the separate worksheet "LLTM". |
LLTM
| Long Lead Time Materials (WLR) | P1 | Est. QTY | Total | P2 | Est. QTY | Total | P3 | Est. QTY | Total | P4 | Est. QTY | Total | P5 | Est. QTY | Total | P6 | Est. QTY | Total | P7 | Est. QTY | Total | P8 | Est. QTY | Total | P9 | Est. QTY | Total | P10 | Offeror Estimated Lead Time | In-Yard Need Date | Manufacturer Name | Manufacturer CAGE Code |
| Z-Drive Propulsors | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | ||||||||||||||
| Machinery Control System | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | ||||||||||||||
| Propulsion Diesel Engines | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | ||||||||||||||
| Ship Service Switchboards | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | ||||||||||||||
| Emergency Switchboard | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | ||||||||||||||
| Step Down Transformer | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | ||||||||||||||
| Ship Service Generators | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | ||||||||||||||
| Emergency Generator | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | ||||||||||||||
| Hydraulic Power Unit | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | ||||||||||||||
| Buoy Crane | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | ||||||||||||||
| Total | - | - | - | - | - | - | - | - | - | - | - 0 |
| Long Lead Time Materials (WLIC) | P1 | Est. QTY | Total | P2 | Est. QTY | Total | P3 | Est. QTY | Total | P4 | Est. QTY | Total | P5 | Est. QTY | Total | P6 | Est. QTY | Total | P7 | Est. QTY | Total | P8 | Est. QTY | Total | P9 | Est. QTY | Total | P10 | Offeror Estimated Lead Time | In-Yard Need Date | Manufacturer Name | Manufacturer CAGE Code |
| Z-Drive Propulsors | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | - | - | ||||||||||||||
| Machinery Control System | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | - | - | ||||||||||||||
| Propulsion Diesel Engines | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | - | - | ||||||||||||||
| Ship Service Switchboards | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | - | - | ||||||||||||||
| Emergency Switchboard | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | - | - | ||||||||||||||
| Step Down Transformer | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | - | - | ||||||||||||||
| Ship Service Generators | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | 2 | - | - | - | - | - | ||||||||||||||
| Emergency Generator | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | - | - | ||||||||||||||
| Hydraulic Power Unit | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | - | - | ||||||||||||||
| Construction Crane | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | 1 | - | - | - | - | - | ||||||||||||||
| Total | - | - | - | - | - | - | - | - | - | - | - 0 |
| Enter Price |
| Feeds to Ordering Period Automatically |
| Leave untouched |
Deep_Ins_Spares
| Deep Insurance Spares | P1 | P2 | Est. QTY | Total | P3 | Est. QTY | Total | P4 | Est. QTY | Total | P5 | Est. QTY | Total | P6 | Est. QTY | Total | P7 | Est. QTY | Total | P8 | Est. QTY | Total | P9 | Est. QTY | Total | P10 | Est. QTY | Total |
| Z-Drive Propulsor | - | - 0 | 2 | - 0 | - | - 0 | 2 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Propulsion Diesel Engine | - | - 0 | 2 | - 0 | - | - 0 | 2 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Ship Service Switchboard | - | - 0 | 1 | - 0 | - | - 0 | 1 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Emergency Switchboard | - | - 0 | 1 | - 0 | - | - 0 | 1 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Step Down Transformer | - | - 0 | 1 | - 0 | - | - 0 | 1 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Ship Service Generator | - | - 0 | 2 | - 0 | - | - 0 | 2 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Emergency Generator | - | - 0 | 1 | - 0 | - | - 0 | 1 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| HVAC Unit | - | - 0 | 2 | - 0 | - | - 0 | 2 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Construction Crane | - | - 0 | 1 | - 0 | - | - 0 | 1 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Buoy Crane | - | - 0 | 1 | - 0 | - | - 0 | 1 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Bow Winch | - | - 0 | 1 | - 0 | - | - 0 | 1 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Deck Winch | - | - 0 | 2 | - 0 | - | - 0 | 2 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Spud Winch | - | - 0 | 2 | - 0 | - | - 0 | 2 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Propulsion Coupling | - | - 0 | 1 | - 0 | - | - 0 | 1 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Hydraulic Power Unit | - | - 0 | 1 | - 0 | - | - 0 | 1 | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | - | - 0 | ||||||||||
| Total | - | - 0 | - 0 | - 0 | - 0 | - | - 0 | - 0 | - 0 | - 0 |
| Enter Price |
| Feeds to Ordering Period Automatically |
| Leave untouched |
LCATS
| Fully Burdened Labor Rates | ||||||||||
| Labor Category | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 |
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} | ||||||||||
| {Insert Labor Category Name} |
The above shall include all applicable labor categories and corresponding fully burdened rates, covering positions in fields such as program management, engineering, analysis, production quality and manufacturing, etc…
Other_Rates Proposed Indirect and Profit Rates for NTE CLINs
| Factory Training |
| Indirect Rate |
| Proposed Profit Rate |
| System Stock, Spare and Consumable Parts, and Outfitting |
| Indirect Rate |
| Proposed Profit Rate |
| Special Studies, Analyses, and Engineering Services |
| Indirect Rate |
| Proposed Profit Rate |
P1
| WCC Pricing Sheets | Enter Price | |||||
| FY22 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 0001 | Design and Engineering | FFP | 1 | - 0 | ||
| 0003 | Long Lead Time Materials | NSP | - 0 | |||
| 0003AA | Long Lead Time Materials (WLR) | FFP | - | 1 | - 0 | |
| 0003AB | Long Lead Time Materials (WLIC) | FFP | - | 1 | - 0 | |
| 0009 | Capital Expenditures | NTE | 1,000,000 | 1 | 1,000,000.00 | |
| 0010 | Optional Data Rights | NTE | 1 | - 0 |
P2
| WCC Pricing Sheets | Enter Price | |||||
| FY23 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 1001 | Production and Support (WLR) | NSP | - 0 | |||
| 1001AA | Production/Classing (WLR) | FP EPA | - | 1 | - 0 | |
| 1001AB | Technical Data (WLR) | NSP | - 0 | |||
| 1001AC | Warranty (WLR) | FFP | 1 | - 0 | ||
| 1001AD | Factory Training (WLR) | NTE | 350,000 | 1 | 350,000.00 | |
| 1002 | Production and Support (WLIC) | NSP | - 0 | |||
| 1002AA | Production/Classing (WLIC) | FP EPA | - | 1 | - 0 | |
| 1002AB | Technical Data (WLIC) | NSP | - 0 | |||
| 1002AC | Warranty (WLIC) | FFP | 1 | - 0 | ||
| 1002AD | Factory Training (WLIC) | NTE | 350,000 | 1 | 350,000.00 | |
| 1003 | Long Lead Time Materials | NSP | - 0 | |||
| 1003AA | Long Lead Time Materials (WLR) | FFP EPA | - | 2 | - 0 | |
| 1003AB | Long Lead Time Materials (WLIC) | FFP EPA | - | 1 | - 0 | |
| 1004 | Deep Insurance Spares | FP EPA | - | 0 | - 0 | |
| 1005 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 1,500,000 | 2 | 3,000,000.00 | |
| 1006 | Training Support | NSP | - 0 | |||
| 1006AA | SME Access | FFP | 1 | - 0 | ||
| 1007 | Cutter Transport to Delivery Location | NSP | - 0 | |||
| 1007AA | Cutter Transport (New Orleans, LA) | FFP | 0 | - 0 | ||
| 1007AB | Cutter Transport (St. Louis, MO) | FFP | 0 | - 0 | ||
| 1008 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 1 | 500,000.00 | |
| 1009 | Capital Expenditures | NTE | - | 1 | - 0 | |
| 1010 | Optional Data Rights | NTE | 1 | - 0 |
P3
| WCC Pricing Sheets | Enter Price | |||||
| FY24 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 2001 | Production and Support (WLR) | NSP | - 0 | |||
| 2001AA | Production/Classing (WLR) | FP EPA | - | 2 | - 0 | |
| 2001AB | Technical Data (WLR) | NSP | - 0 | |||
| 2001AC | Warranty (WLR) | FFP | 2 | - 0 | ||
| 2001AD | Factory Training (WLR) | NTE | 350,000 | 2 | 700,000.00 | |
| 2002 | Production and Support (WLIC) | NSP | - 0 | |||
| 2002AA | Production/Classing (WLIC) | FP EPA | - | 1 | - 0 | |
| 2002AB | Technical Data (WLIC) | NSP | - 0 | |||
| 2002AC | Warranty (WLIC) | FFP | 1 | - 0 | ||
| 2002AD | Factory Training (WLIC) | NTE | 350,000 | 1 | 350,000.00 | |
| 2003 | Long Lead Time Materials | NSP | - 0 | |||
| 2003AA | Long Lead Time Materials (WLR) | FFP EPA | - | 2 | - 0 | |
| 2003AB | Long Lead Time Materials (WLIC) | FFP EPA | - | 2 | - 0 | |
| 2004 | Deep Insurance Spares | FP EPA | - | 1 | - 0 | |
| 2005 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 1,500,000 | 3 | 4,500,000.00 | |
| 2006 | Training Support | NSP | - 0 | |||
| 2006AA | SME Access | FFP | 1 | - 0 | ||
| 2007 | Cutter Transport to Delivery Location | NSP | - 0 | |||
| 2007AA | Cutter Transport (New Orleans, LA) | FFP | 1 | - 0 | ||
| 2007AB | Cutter Transport (St. Louis, MO) | FFP | 1 | - 0 | ||
| 2008 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 1 | 500,000.00 | |
| 2009 | Capital Expenditures | NTE | 1 | - 0 | ||
| 2010 | Optional Data Rights | NTE | 1 | - 0 |
P4
| WCC Pricing Sheets | Enter Price | |||||
| FY25 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 3001 | Production and Support (WLR) | NSP | - 0 | |||
| 3001AA | Production/Classing (WLR) | FP EPA | - | 2 | - 0 | |
| 3001AB | Technical Data (WLR) | NSP | - 0 | |||
| 3001AC | Warranty (WLR) | FFP | 2 | - 0 | ||
| 3001AD | Factory Training (WLR) | NTE | 350,000 | 2 | 700,000.00 | |
| 3002 | Production and Support (WLIC) | NSP | - 0 | |||
| 3002AA | Production/Classing (WLIC) | FP EPA | - | 2 | - 0 | |
| 3002AB | Technical Data (WLIC) | NSP | - 0 | |||
| 3002AC | Warranty (WLIC) | FFP | 2 | - 0 | ||
| 3002AD | Factory Training (WLIC) | NTE | 350,000 | 2 | 700,000.00 | |
| 3003 | Long Lead Time Materials | NSP | - 0 | |||
| 3003AA | Long Lead Time Materials (WLR) | FFP EPA | - | 2 | - 0 | |
| 3003AB | Long Lead Time Materials (WLIC) | FFP EPA | - | 2 | - 0 | |
| 3004 | Deep Insurance Spares | FP EPA | - | 0 | - 0 | |
| 3005 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 1,500,000 | 4 | 6,000,000.00 | |
| 3006 | Training Support | NSP | - 0 | |||
| 3006AA | SME Access | FFP | 1 | - 0 | ||
| 3007 | Cutter Transport to Delivery Location | NSP | 0 | - 0 | ||
| 3007AA | Cutter Transport (New Orleans, LA) | FFP | 1 | - 0 | ||
| 3007AB | Cutter Transport (St. Louis, MO) | FFP | 2 | - 0 | ||
| 3008 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 1 | 500,000.00 | |
| 3009 | Capital Expenditures | NTE | 0 | - 0 | ||
| 3010 | Optional Data Rights | NTE | 1 | - 0 |
P5
| WCC Pricing Sheets | Enter Price | |||||
| FY26 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 4001 | Production and Support (WLR) | NSP | - 0 | |||
| 4001AA | Production/Classing (WLR) | FP EPA | - | 2 | - 0 | |
| 4001AB | Technical Data (WLR) | NSP | - 0 | |||
| 4001AC | Warranty (WLR) | FFP | 2 | - 0 | ||
| 4001AD | Factory Training (WLR) | NTE | 350,000 | 2 | 700,000.00 | |
| 4002 | Production and Support (WLIC) | NSP | - 0 | |||
| 4002AA | Production/Classing (WLIC) | FP EPA | - | 2 | - 0 | |
| 4002AB | Technical Data (WLIC) | NSP | - 0 | |||
| 4002AC | Warranty (WLIC) | FFP | 2 | - 0 | ||
| 4002AD | Factory Training (WLIC) | NTE | 350,000 | 2 | 700,000.00 | |
| 4003 | Long Lead Time Materials | NSP | - 0 | |||
| 4003AA | Long Lead Time Materials (WLR) | FFP EPA | - | 2 | - 0 | |
| 4003AB | Long Lead Time Materials (WLIC) | FFP EPA | - | 2 | - 0 | |
| 4004 | Deep Insurance Spares | FP EPA | - | 1 | - 0 | |
| 4005 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 1,500,000 | 4 | 6,000,000.00 | |
| 4006 | Training Support | NSP | - 0 | |||
| 4006AA | SME Access | FFP | 1 | - 0 | ||
| 4007 | Cutter Transport to Delivery Location | NSP | - 0 | |||
| 4007AA | Cutter Transport (New Orleans, LA) | FFP | 2 | - 0 | ||
| 4007AB | Cutter Transport (St. Louis, MO) | FFP | 2 | - 0 | ||
| 4008 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 1 | 500,000.00 | |
| 4009 | Capital Expenditures | NTE | 0 | - 0 | ||
| 4010 | Optional Data Rights | NTE | 1 | - 0 |
P6
| WCC Pricing Sheets | Enter Price | |||||
| FY27 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 5001 | Production and Support (WLR) | NSP | - 0 | |||
| 5001AA | Production/Classing (WLR) | FP EPA | - | 2 | - 0 | |
| 5001AB | Technical Data (WLR) | NSP | - 0 | |||
| 5001AC | Warranty (WLR) | FFP | 2 | - 0 | ||
| 5001AD | Factory Training (WLR) | NTE | 350,000 | 2 | 700,000.00 | |
| 5002 | Production and Support (WLIC) | NSP | - 0 | |||
| 5002AA | Production/Classing (WLIC) | FP EPA | - | 2 | - 0 | |
| 5002AB | Technical Data (WLIC) | NSP | - 0 | |||
| 5002AC | Warranty (WLIC) | FFP | 2 | - 0 | ||
| 5002AD | Factory Training (WLIC) | NTE | 350,000 | 2 | 700,000.00 | |
| 5003 | Long Lead Time Materials | NSP | - 0 | |||
| 5003AA | Long Lead Time Materials (WLR) | FFP EPA | - | 2 | - 0 | |
| 5003AB | Long Lead Time Materials (WLIC) | FFP EPA | - | 2 | - 0 | |
| 5004 | Deep Insurance Spares | FP EPA | - | 0 | - 0 | |
| 5005 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 1,500,000 | 4 | 6,000,000.00 | |
| 5006 | Training Support | NSP | - 0 | |||
| 5006AA | SME Access | FFP | 1 | - 0 | ||
| 5006AB | Training Aids | FFP | 1 | - 0 | ||
| 5007 | Cutter Transport to Delivery Location | NSP | - 0 | |||
| 5007AA | Cutter Transport (New Orleans, LA) | FFP | 2 | - 0 | ||
| 5007AB | Cutter Transport (St. Louis, MO) | FFP | 2 | - 0 | ||
| 5008 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 1 | 500,000.00 | |
| 5009 | Capital Expenditures | NTE | 0 | - 0 | ||
| 5010 | Optional Data Rights | NTE | 1 | - 0 |
P7
| WCC Pricing Sheets | Enter Price | |||||
| FY28 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 6001 | Production and Support (WLR) | NSP | - 0 | |||
| 6001AA | Production/Classing (WLR) | FP EPA | - | 2 | - 0 | |
| 6001AB | Technical Data (WLR) | NSP | - 0 | |||
| 6001AC | Warranty (WLR) | FFP | 2 | - 0 | ||
| 6001AD | Factory Training (WLR) | NTE | 350,000 | 2 | 700,000.00 | |
| 6002 | Production and Support (WLIC) | NSP | - 0 | |||
| 6002AA | Production/Classing (WLIC) | FP EPA | - | 2 | - 0 | |
| 6002AB | Technical Data (WLIC) | NSP | - 0 | |||
| 6002AC | Warranty (WLIC) | FFP | 2 | - 0 | ||
| 6002AD | Factory Training (WLIC) | NTE | 350,000 | 2 | 700,000.00 | |
| 6003 | Long Lead Time Materials | NSP | - 0 | |||
| 6003AA | Long Lead Time Materials (WLR) | FFP EPA | - | 3 | - 0 | |
| 6003AB | Long Lead Time Materials (WLIC) | FFP EPA | - | 1 | - 0 | |
| 6004 | Deep Insurance Spares | FP EPA | - | 0 | - 0 | |
| 6005 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 1,500,000 | 4 | 6,000,000.00 | |
| 6006 | Training Support | NSP | - 0 | |||
| 6007 | Cutter Transport to Delivery Location | NSP | - 0 | |||
| 6007AA | Cutter Transport (New Orleans, LA) | FFP | 2 | - 0 | ||
| 6007AB | Cutter Transport (St. Louis, MO) | FFP | 2 | - 0 | ||
| 6008 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 1 | 500,000.00 | |
| 6009 | Capital Expenditures | NTE | 0 | - 0 | ||
| 6010 | Optional Data Rights | NTE | 1 | - 0 |
P8
| WCC Pricing Sheets | Enter Price | |||||
| FY29 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 7001 | Production and Support (WLR) | NSP | - 0 | |||
| 7001AA | Production/Classing (WLR) | FP EPA | - | 3 | - 0 | |
| 7001AB | Technical Data (WLR) | NSP | - 0 | |||
| 7001AC | Warranty (WLR) | FFP | 3 | - 0 | ||
| 7001AD | Factory Training (WLR) | NTE | 350,000 | 3 | 1,050,000.00 | |
| 7002 | Production and Support (WLIC) | NSP | - 0 | |||
| 7002AA | Production/Classing (WLIC) | FP EPA | - | 1 | - 0 | |
| 7002AB | Technical Data (WLIC) | NSP | - 0 | |||
| 7002AC | Warranty (WLIC) | FFP | 1 | - 0 | ||
| 7002AD | Factory Training (WLIC) | NTE | 350,000 | 1 | 350,000.00 | |
| 7003 | Long Lead Time Materials | NSP | - 0 | |||
| 7003AA | Long Lead Time Materials (WLR) | FFP EPA | - | 2 | - 0 | |
| 7003AB | Long Lead Time Materials (WLIC) | FFP EPA | - | 0 | - 0 | |
| 7004 | Deep Insurance Spares | FP EPA | - | 0 | - 0 | |
| 7005 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 1,500,000 | 4 | 6,000,000.00 | |
| 7006 | Training Support | NSP | - 0 | |||
| 7007 | Cutter Transport to Delivery Location | NSP | - 0 | |||
| 7007AA | Cutter Transport (New Orleans, LA) | FFP | 2 | - 0 | ||
| 7007AB | Cutter Transport (St. Louis, MO) | FFP | 2 | - 0 | ||
| 7008 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 1 | 500,000.00 | |
| 7009 | Capital Expenditures | NTE | 0 | - 0 | ||
| 7010 | Optional Data Rights | NTE | 1 | - 0 |
P9
| WCC Pricing Sheets | Enter Price | |||||
| FY30 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 8001 | Production and Support (WLR) | NSP | - 0 | |||
| 8001AA | Production/Classing (WLR) | FP EPA | - | 2 | - 0 | |
| 8001AB | Technical Data (WLR) | NSP | - 0 | |||
| 8001AC | Warranty (WLR) | FFP | 2 | - 0 | ||
| 8001AD | Factory Training (WLR) | NTE | 350,000 | 2 | 700,000.00 | |
| 8002 | Production and Support (WLIC) | NSP | - 0 | |||
| 8002AA | Production/Classing (WLIC) | FP EPA | - | 0 | - 0 | |
| 8002AB | Technical Data (WLIC) | NSP | - 0 | |||
| 8002AC | Warranty (WLIC) | FFP | 0 | - 0 | ||
| 8002AD | Factory Training (WLIC) | NTE | 0 | - 0 | ||
| 8003 | Long Lead Time Materials | NSP | - 0 | |||
| 8003AA | Long Lead Time Materials (WLR) | FFP EPA | - | 0 | - 0 | |
| 8003AB | Long Lead Time Materials (WLIC) | FFP EPA | - | 0 | - 0 | |
| 8004 | Deep Insurance Spares | FP EPA | - | 0 | - 0 | |
| 8005 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 1,500,000 | 2 | 3,000,000.00 | |
| 8006 | Training Support | NSP | - 0 | |||
| 8007 | Cutter Transport to Delivery Location | NSP | - 0 | |||
| 8007AA | Cutter Transport (New Orleans, LA) | FFP | 2 | - 0 | ||
| 8007AB | Cutter Transport (St. Louis, MO) | FFP | 2 | - 0 | ||
| 8008 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 1 | 500,000.00 | |
| 8009 | Capital Expenditures | NTE | 0 | - 0 | ||
| 8010 | Optional Data Rights | NTE | 1 | - 0 |
P10
| WCC Pricing Sheets | Enter Price | |||||
| FY31 | Pricing Pulled From Alternate Tab | |||||
| CLIN | Task | CLIN Type | Unit Price | Est. QTY | Total | Leave untouched |
| 9001 | Production and Support (WLR) | NSP | - 0 | |||
| 9001AA | Production/Classing (WLR) | FP EPA | 0 | - 0 | ||
| 9001AB | Technical Data (WLR) | NSP | - 0 | |||
| 9001AC | Warranty (WLR) | FFP | 0 | - 0 | ||
| 9001AD | Factory Training (WLR) | NTE | 0 | - 0 | ||
| 9002 | Production and Support (WLIC) | NSP | - 0 | |||
| 9002AA | Production/Classing (WLIC) | FP EPA | - 0 | 0 | - 0 | |
| 9002AB | Technical Data (WLIC) | NSP | - 0 | |||
| 9002AC | Warranty (WLIC) | FFP | 0 | - 0 | ||
| 9002AD | Factory Training (WLIC) | NTE | 0 | - 0 | ||
| 9003 | Long Lead Time Materials | NSP | - 0 | |||
| 9003AA | Long Lead Time Materials (WLR) | FFP EPA | 0 | - 0 | ||
| 9003AB | Long Lead Time Materials (WLIC) | FFP EPA | 0 | - 0 | ||
| 9004 | Deep Insurance Spares | FP EPA | 0 | - 0 | ||
| 9005 | System Stock, Spare & Consumable Parts, and Outfitting | NTE | 0 | - 0 | ||
| 9006 | Training Support | NSP | - 0 | |||
| 9007 | Cutter Transport to Delivery Location | NSP | - 0 | |||
| 9007AA | Cutter Transport (New Orleans, LA) | FFP | 1 | - 0 | ||
| 9007AB | Cutter Transport (St. Louis, MO) | FFP | 1 | - 0 | ||
| 9008 | Special Studies, Analyses, and Engineering Services | NTE | 500,000 | 1 | 500,000.00 | |
| 9009 | Capital Expenditures | NTE | 0 | - 0 | ||
| 9010 | Optional Data Rights | NTE | 1 | - 0 |
Stepladder_Pricing
| Stepladder Pricing Sheet | |||||||||
| Stepladder Pricing Unit Costs | QTY | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 |
| Production/Classing (WLR) | 1-2 | ||||||||
| Production/Classing (WLR) | 3-4 | ||||||||
| Production/Classing (WLR) | 5+ | ||||||||
| Production/Classing (WLIC) | 1-2 | ||||||||
| Production/Classing (WLIC) | 3-4 | ||||||||
| Production/Classing (WLIC) | 5+ |
| Stepladder Pricing Multiple Quantity Discount Percentage | |
| Long Lead Time Materials (WLR) | 1-2 |
| Long Lead Time Materials (WLR) | 3-4 |
| Long Lead Time Materials (WLR) | 5+ |
| Long Lead Time Materials (WLIC) | 1-2 |
| Long Lead Time Materials (WLIC) | 3-4 |
| Long Lead Time Materials (WLIC) | 5+ |
| Deep Insurance Spares | 1-2 |
| Deep Insurance Spares | 3-4 |
| Deep Insurance Spares | 5+ |
File details come from the government source that posted it. Updated .