Attachment 0007 Pricing Template.xlsx

XLSX spreadsheet 717 KB Posted

Attached to
COUNTERMEASURES PRODUCTION PROCESS EQUIPMENT DESIGN
Solicitation number
W519TC-26-Q-SURE
Issued by

About this file

This is a Pricing Template Excel file for a federal contract opportunity (RFQ Number: W519TC25QSURE) for Countermeasures Production Process Equipment Design. The solicitation is a sole-source award to Franklin Engineering Group Inc. by the US Army Contracting Command - Rock Island, with performance at Crane Army Ammunition Activity. The contract has a hybrid pricing structure (Firm Fixed Price and Cost/No-Fee) with a planned period of performance from 01 December 2025, divided into four phases: Phase One (4 months), Phase Two (12 months), Phase Three (12 months), and Phase Four (12 months).

The pricing template provides detailed worksheets for Labor, Travel, and Other Direct Costs/Materials, with sections for Prime and Subcontractor pricing across the four project phases. Quotation submissions are due by 14 November 2025 at 12:30 PM CT. The government intends to award one contract, with the place of performance located in Crane, Indiana. The template requires vendors to enter pricing data in yellow highlighted cells, with instructions to maintain the general format for evaluation and contract administration purposes, and to ensure accurate calculations within each tab.

View the file

Other files

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

CLIN Pricing

RFQ Number and Title: W519TC25QSURE Countermeasures Production Process Equipment Design

Quoter Instructions:Enter the requested data in the yellow highlighted cells.
The quoter may edit the worksheet, but the general format shall remain intact for evaluation and contract administration purposes.
TABs have been pre-populated with some formulas to aid the quoter in calculating the proposed price. The quoter is responsible for ensuring that all calculations within each TAB are accurate and reflective of the proposed price.
The inclusion of FAR 52.217-8, Option to Extend Services. IAW AFARS 5117.206, is optional and is up to the discretion of the Contracting Officer responsible for the requirement. If the determination is made that the option clause is required, the evaluation of the Option to Extend Services clause FAR 52.217-8 should include rates and hours based on the last option. Since the Option to Extend the Services could be exercised at the end of any of those periods, if the Government decides to fully or partly exercise the option at FAR 52.217-8, the labor rates in effect at the time the Options to Extend the Services shall be used unless such rates shall be adjusted as a result of revisions to prevailing labor rates provided by the Secretary of Labor.
CLIN DescriptionContract TypePeriod of PerformancePhase 1 CLIN NumbersPhase 1 PricePhase 2 CLIN NumbersPhase 2 PricePhase 3 CLIN NumbersPhase 3 PricePhase 4 CLIN NumbersPhase 4 PriceTotal
LaborFFP01 December 2025 - End of Phase 40001$ - 01001$ - 02001$ - 03001$ - 0$ - 0
TravelCOST NO-FEE01 December 2025 - End of Phase 40002$ - 01002$ - 02002$ - 03002$ - 0$ - 0
ODC/MaterialFFP01 December 2025 - End of Phase 40003$ - 01003$ - 02003$ - 03003$ - 0$ - 0
Total Price$ - 0$ - 0$ - 0$ - 0$ - 0

Labor

RFQ Number and Title: W519TC25QSURE Countermeasures Production Process Equipment Design

Quoter Instructions:Enter the requested data in the yellow highlighted cells.
The quoter may edit the worksheet, but the general format shall remain intact for evaluation and contract administration purposes.
TABs have been pre-populated with some formulas to aid the quoter in calculating the proposed price. The quoter is responsible for ensuring that all calculations within each TAB are accurate and reflective of the proposed price.
All labor hours shall be entered as whole numbers and labor rates entered to the closest whole cent.
The last set of rates should include the rates for the last Phase and the Extension of Services Option as they should be the same. The hours should equal to 6-months worth of effort.
FIRM FIXED PRICE
Phase 1 PeriodPhase 2 PeriodPhase 3 PeriodPhase 4 PeriodTotal
Enter POP Dates HereEnter POP Dates HereEnter POP Dates HereEnter POP Dates Here
Prime/ SubcontractorCompany NamePO RateHoursDollarsPO RateHoursDollarsPO RateHoursDollarsPO RateHoursDollarsHoursDollars
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0

Travel

RFQ Number and Title: W519TC25QSURE Countermeasures Production Process Equipment Design

Quoter Instructions:Enter the requested data in the yellow highlighted cells.
The quoter may edit the worksheet, but the general format shall remain intact for evaluation and contract administration purposes.
TABs have been pre-populated with some formulas to aid the quoter in calculating the proposed price. The quoter is responsible for ensuring that all calculations within each TAB are accurate and reflective of the proposed price.
All labor hours shall be entered as whole numbers and labor rates entered to the closest whole cent.
The last set of rates should include the rates for the last Phase and the Extension of Services Option as they should be the same. The hours should equal to 6-months worth of effort.
FIRM FIXED PRICE
Phase 1 PeriodPhase 2 PeriodPhase 3 PeriodPhase 4 PeriodTotal
Enter POP Dates HereEnter POP Dates HereEnter POP Dates HereEnter POP Dates Here
Prime/ SubcontractorCompany NamePO RateHoursDollarsPO RateHoursDollarsPO RateHoursDollarsPO RateHoursDollarsHoursDollars
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0

ODC & Material

RFQ Number and Title: W519TC25QSURE Countermeasures Production Process Equipment Design

Quoter Instructions:Enter the requested data in the yellow highlighted cells.
The quoter may edit the worksheet, but the general format shall remain intact for evaluation and contract administration purposes.
TABs have been pre-populated with some formulas to aid the quoter in calculating the proposed price. The quoter is responsible for ensuring that all calculations within each TAB are accurate and reflective of the proposed price.
All labor hours shall be entered as whole numbers and labor rates entered to the closest whole cent.
The last set of rates should include the rates for the last Phase and the Extension of Services Option as they should be the same. The hours should equal to 6-months worth of effort.
FIRM FIXED PRICE
Phase 1 PeriodPhase 2 PeriodPhase 3 PeriodPhase 4 PeriodTotal
Enter POP Dates HereEnter POP Dates HereEnter POP Dates HereEnter POP Dates Here
Prime/ SubcontractorCompany NamePO RateHoursDollarsPO RateHoursDollarsPO RateHoursDollarsPO RateHoursDollarsHoursDollars
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
$ - 0$ - 0$ - 0$ - 0- 0$ - 0
- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0

Assumptions Assumption Number Phase (1, 2, 3, or 4) Description of Assumption

Betterments

Note: This tab has been created for contractor convenience. Please provide pricing for betterments within this tab. There is no set format.

File details come from the government source that posted it. Updated .