Attachment 7 - PTR Sample Pricing Table - 12 Jun 2025.xlsx
XLSX spreadsheet 34 KB Posted
- Solicitation number
- FA489025R0006
About this file
The file is a Sample Pricing Table (PTR) Excel workbook for a federal contract opportunity for Operations, Maintenance, and Support (OM&S) of Air Combat Command Primary Training Ranges. The pricing template includes a Manning Matrix with nine labor categories across eight different bombing, gunnery, electronic combat, and electronic warfare ranges located in states including North Carolina, Idaho, Georgia, Florida, South Carolina, New Mexico, Wyoming, and Texas. The document provides escalation rates ranging from 0% to 3.1% across base and six option years.
The pricing structure includes multiple Contract Line Item Numbers (CLINs) for transition, program management, and specific range support, with a total evaluated price structure. The contract is a small business set-aside with a 60-day transition period, nine-month base contract, and four one-year option periods. The total contract value includes a fixed lot price of $1,000,000 per year for fuel, travel, supplies, parts, and extended maintenance, with a 6-month extension option. The solicitation (FA489025R0006) is issued by the Air Force Air Combat Command, with a proposal closing date of September 1, 2025, and anticipated award date of January 12, 2026.
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
| Workbook Information/Instructions: |
| 1. All information in this workbook is notional and is for demostration purposes only. |
| 2. Offerors may alter this workbook. It is the Offeror's responisiblity to ensure all data is accurate and free of errors. |
| 3. Read all instructions, notes, and references contained within individual worksheets and Section B of solicitation. |
Manning Matrix Instructions: Fill in all Green shaded cells. Additional Labor Categories may be added.
Manning matrix shall be same as developed and provided in the technical proposal
| PTR Manning Matrix | |||||||||||||
| Labor Category | SCA Labor Category Title | SCA/CBA Position | Shift | Special Certifications (SOW 1.9.3.2, 2.1.10, 2.5.1 & 3.6) | Dare County Bombing & Gunnery | Mountain Home Bombing & Gunnery | Grand Bay Bombing & Gunnery | Avon Park Bombing & Gunnery | Poinsett Electronic Combat | Poinsett Bombing & Gunnery | Holloman Ranges | Belle Fourche Bombing & Gunnery | Snyder Electronic Warfare |
| Labor Category 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||||
| Labor Category 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||
| Labor Category 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||
| Labor Category 4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||
| Labor Category 5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||
| Labor Category 6 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Total 6 7 8 9 10 11 12 13 14
Escalation Instructions: Provide an escalation percentage for each year in the Green shaded cells.
Escalation rates listed below are for demonstration purposes only.
| Indirect Rate | Base Year | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | Option 6 | Extension Option |
| Escalation | 0.00% | 2.60% | 2.70% | 2.80% | 2.90% | 3.00% | 3.10% | 0.00% |
Schedule B
| Unit and extended pricing rounded per RFP Section L, paragraph L-11.1.2. |
| Prices from the CLIN Summary tab will be used to populate the contract Schedule B CLINs upon award and this spreadsheet will be incorporated into contract terms and conditions at award. |
| Base | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | 52.217-8 | |||||||
| CLIN | Title | Unit | Extended | Unit | Extended | Unit | Extended | Unit | Extended | Unit | Extended | 6 Month Ext. |
| X098 | FFP - Transition | $ - 0 | $ - 0 | |||||||||
| X001 | FFP - Program Management | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X002 | FFP - Dare County B&G, NC | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X003 | FFP - Mt Home B&G, ID | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X004 | FFP - Grand Bay B&G, GA | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X005 | FFP - Avon Park B&G, FL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X006 | FFP - Poinsett ECR, SC | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X007 | FFP - Poinsett B&G, SC | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X008 | FFP - Holloman Ranges, NM | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X009 | FFP - Belle Fourche EWS, WY | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X010 | FFP - Snyder EWS, TX | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X011 * | CR - Fuel/Travel/Supplies_Parts/ Ext'd Maint | Lot | $ 1,000,000.00 | Lot | $ 1,000,000.00 | Lot | $ 1,000,000.00 | Lot | $ 1,000,000.00 | Lot | $ 1,000,000.00 | $ 500,000.00 |
| Total | $ 1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $1,000,000.00 | $5,000,000.00 | $ 500,000.00 | |
| Total Overall Evaluated Price | Total Overall Evaluated Price with -8 | |||||||
| * Government provided estimate - no contractor estimates required or desired for CLIN X011 |
File details come from the government source that posted it. Updated .