Attachment 1_Pricing Spreadsheet_01.06.2025.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- Trainer Developer III (TDIII) Federal contract opportunity
- Solicitation number
- 47QFWA24R0017
About this file
This is a pricing spreadsheet template with two tabs for a Trainer Developer III (TDIII) IDIQ contract. Tab A lists 45 labor categories including roles like Computer Programmer, Cybersecurity Specialist, Engineers, and Program Managers, with columns for base period and four ordering period labor rates. Tab B contains a sample project worksheet for evaluation purposes with estimated hours for 9 specific labor categories across base and option periods, including a 6-month extension under FAR 52.217-8.
The sample project includes fixed Other Direct Costs (ODCs) of $1.6M per period ($800K for extension) and Travel costs of $300K per period ($150K for extension). The total evaluated price calculation template shows $1.9M per full period and $950K for the extension, summing to a total evaluated price of $10.45M. The spreadsheet is dated January 6, 2025 and appears to be part of solicitation 47QFWA24R0017 for GSA Federal Acquisition Services supporting the 502 Trainer Development Squadron.
View the file
Other files for this federal contract opportunity
Show all 22
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Tab A – Labor Rates
| Labor Categories | Fully Burdened Labor Rates | ||||
| Base Period | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | |
| Administration/Clerical (Journeyman) | |||||
| Aerospace Engineer | |||||
| Business Systems Analyst | |||||
| CNC Machinist/Programmer (Machinist, Maintenance) | |||||
| Computer and Network System Support | |||||
| Computer Operator I | |||||
| Computer Programmer | |||||
| Computer System Analyst | |||||
| Configuration Management Specialist (Journeyman) | |||||
| Cybersecurity Specialist | |||||
| Database Specialist (Journeyman) | |||||
| Data Management Specialist | |||||
| Electrical Engineer (Journeyman) | |||||
| Electrical Engineering Technologist | |||||
| Electrician/Electrical Engineering Support | |||||
| Electrician, Maintenance | |||||
| Electronics Technician Maintenance I | |||||
| Electronics Technician Maintenance III | |||||
| Hardware Engineer (Entry Level) | |||||
| Hardware Engineer (Journeyman) | |||||
| Information Assurance/Security Specialist (Entry Level) | |||||
| Logistician | |||||
| Mechanical Engineer (Journeyman) | |||||
| Mechanical Engineering Support | |||||
| Mechanical Engineering Technologist | |||||
| Modeling and Simulation Specialist | |||||
| Network Specialist (Entry Level) | |||||
| Network Specialist (Journeyman) | |||||
| Production Control | |||||
| Program Manager | |||||
| Project Manager | |||||
| Quality Assurance Specialist (Entry Level) | |||||
| Quality Assurance Specialist (Journeyman) | |||||
| Research Analyst | |||||
| Sheet Metal Structural Mechanic (Sheet-Metal Worker, Maintenance)/Aerospace Structural Welder with paint experience | |||||
| Software Developer, Applications (Journeyman or Comparable) | |||||
| Software Developer, Systems Software (Journeyman or Comparable) | |||||
| Subject Matter Expert (Journeyman) | |||||
| Systems Engineer | |||||
| Technical Writer | |||||
| Test Engineer (Entry Level) | |||||
| Test Engineer (Journeyman) | |||||
| Trainer Maintenance Technician | |||||
| Training Specialist (Entry Level) | |||||
| Training Specialist (Journeyman) |
Updated 01/06/2025
Tab B – Sample Project
| This is a Sample Task Order that would be placed under the TDIII IDIQ Contract - This is not an actual order! |
| The Government is utilizing a Sample Project to provide Estimated Hourly Quantities to reach a total evaluated price FOR EVALUATION PURPOSES ONLY. The Estimated Hourly Quantities are located in Attachment 1 – Tab B Sample Project. Offerors may not deviate from the identified labor categories and hourly rates proposed located in Attachment 1 – Tab A Labor Rates when completing the mandatory Attachment 1 – Tab B Sample Project pricing spreadsheet. Offerors shall not assume these hours to be representative hours, but for EVALUATION PURPOSES ONLY. |
| Offerors shall fill in the Fully Buredoned Rates for the: Base, Option 1, Option 2, Option 3 and Option 4 Periods below to complete the spreadsheet. | |||||||||||||||||
| The Totals will calculate accordingly - Please do not change the formulas. | |||||||||||||||||
| Labor Categories | Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | 52.217-8 Option to Extend Services | |||||||||||
| Hours | Fully Buredoned Rate | Total | Hours | Fully Buredoned Rate | Total | Hours | Fully Buredoned Rate | Total | Hours | Fully Buredoned Rate | Total | Hours | Fully Buredoned Rate | Total | Hours | Fully Buredoned Rate |
RichardPHill: IAW 52.217-8 Option to Extend Services - Rates for this Extension must match the rates for Option Period 4
| Total | |||||||||||||
| Computer Programmer | 5520 | $0.00 | 5520 | $0.00 | 5520 | $0.00 | 5520 | $0.00 | 5520 | $0.00 | 2760 | $0.00 | $0.00 |
| Cyber Security Specialist | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 720 | $0.00 | $0.00 |
| Hardware Engineer (Entry Level) | 2880 | $0.00 | 2880 | $0.00 | 2880 | $0.00 | 2880 | $0.00 | 2880 | $0.00 | 1440 | $0.00 | $0.00 |
| Hardware Engineer (Journeyman) | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 720 | $0.00 | $0.00 |
| Program Manager | 1090 | $0.00 | 1090 | $0.00 | 1090 | $0.00 | 1090 | $0.00 | 1090 | $0.00 | 545 | $0.00 | $0.00 |
| Project Manager | 3120 | $0.00 | 3120 | $0.00 | 3120 | $0.00 | 3120 | $0.00 | 3120 | $0.00 | 1560 | $0.00 | $0.00 |
| Software Developer Applications (Journeyman) | 8160 | $0.00 | 8160 | $0.00 | 8160 | $0.00 | 8160 | $0.00 | 8160 | $0.00 | 4080 | $0.00 | $0.00 |
| Software Developer, Systems Software (Journeyman) | 5760 | $0.00 | 5760 | $0.00 | 5760 | $0.00 | 5760 | $0.00 | 5760 | $0.00 | 2880 | $0.00 | $0.00 |
| Systems Engineer | 12960 | $0.00 | 12960 | $0.00 | 12960 | $0.00 | 12960 | $0.00 | 12960 | $0.00 | 6480 | $0.00 | $0.00 |
| Sample Other Direct Costs (ODCs) | Base ODC Amount | $1,600,000.00 | Option 1 ODC Amount | $1,600,000.00 | Option 2 ODC Amount | $1,600,000.00 | Option 3 ODC Amount | $1,600,000.00 | Option 4 ODC Amount | $1,600,000.00 | Extension ODC Amount | $800,000.00 | |
| Sample Travel | Base Travel Amount | $300,000.00 | Option 1 Travel Amount | $300,000.00 | Option 2 Travel Amount | $300,000.00 | Option 3 Travel Amount | $300,000.00 | Option 4 Travel Amount | $300,000.00 | Extension Travel Amount | $150,000.00 | |
| Totals | Total Cost Base Period | $1,900,000.00 | Total Cost Option Period 1 | $1,900,000.00 | Total Cost Option Period 2 | $1,900,000.00 | Total Cost Option Period 3 | $1,900,000.00 | Total Cost Option Period 4 | $1,900,000.00 | 6mo Extension of Services | $950,000.00 | |
| TOTAL EVALUATED PRICE (TEP) | |||||||||||||
| Base Period | $1,900,000.00 | ||||||||||||
| Option Period 1 | $1,900,000.00 | ||||||||||||
| Option Period 2 | $1,900,000.00 | ||||||||||||
| Option Period 3 | $1,900,000.00 | ||||||||||||
| Option Period 4 | $1,900,000.00 | ||||||||||||
| 52.217-8 6mo Extension | $950,000.00 | ||||||||||||
| TEP | $10,450,000.00 |
File details come from the government source that posted it. Updated .