Attachment 0007 Pricing Template.xlsx
XLSX spreadsheet 717 KB Posted
- Solicitation number
- W519TC-26-Q-SURE
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 Description | Contract Type | Period of Performance | Phase 1 CLIN Numbers | Phase 1 Price | Phase 2 CLIN Numbers | Phase 2 Price | Phase 3 CLIN Numbers | Phase 3 Price | Phase 4 CLIN Numbers | Phase 4 Price | Total |
| Labor | FFP | 01 December 2025 - End of Phase 4 | 0001 | $ - 0 | 1001 | $ - 0 | 2001 | $ - 0 | 3001 | $ - 0 | $ - 0 |
| Travel | COST NO-FEE | 01 December 2025 - End of Phase 4 | 0002 | $ - 0 | 1002 | $ - 0 | 2002 | $ - 0 | 3002 | $ - 0 | $ - 0 |
| ODC/Material | FFP | 01 December 2025 - End of Phase 4 | 0003 | $ - 0 | 1003 | $ - 0 | 2003 | $ - 0 | 3003 | $ - 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 Period | Phase 2 Period | Phase 3 Period | Phase 4 Period | Total | |||||||||||
| Enter POP Dates Here | Enter POP Dates Here | Enter POP Dates Here | Enter POP Dates Here | ||||||||||||
| Prime/ Subcontractor | Company Name | PO Rate | Hours | Dollars | PO Rate | Hours | Dollars | PO Rate | Hours | Dollars | PO Rate | Hours | Dollars | Hours | Dollars |
| $ - 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 Period | Phase 2 Period | Phase 3 Period | Phase 4 Period | Total | |||||||||||
| Enter POP Dates Here | Enter POP Dates Here | Enter POP Dates Here | Enter POP Dates Here | ||||||||||||
| Prime/ Subcontractor | Company Name | PO Rate | Hours | Dollars | PO Rate | Hours | Dollars | PO Rate | Hours | Dollars | PO Rate | Hours | Dollars | Hours | Dollars |
| $ - 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 Period | Phase 2 Period | Phase 3 Period | Phase 4 Period | Total | |||||||||||
| Enter POP Dates Here | Enter POP Dates Here | Enter POP Dates Here | Enter POP Dates Here | ||||||||||||
| Prime/ Subcontractor | Company Name | PO Rate | Hours | Dollars | PO Rate | Hours | Dollars | PO Rate | Hours | Dollars | PO Rate | Hours | Dollars | Hours | Dollars |
| $ - 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 .