Attachment 1_Pricing Spreadsheet (1).xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- Trainer Developer III (TDIII) Federal contract opportunity
- Solicitation number
- 47QFWA24R0017
About this file
This is a pricing spreadsheet template for the Trainer Developer III (TDIII) IDIQ contract that contains two tabs: Tab A for labor rates across base and four ordering periods, and Tab B for a sample project pricing calculation. Tab A lists 41 labor categories including roles such as aerospace engineer, cybersecurity specialist, software developers, and various technicians, while Tab B provides a sample task order with specific labor hour estimates for 9 key positions including computer programmer (5,520 hours), software developers (13,920 hours combined), and systems engineer (12,960 hours) per period.
The spreadsheet includes fixed Other Direct Costs (ODCs) of $1.6M and Travel costs of $300K per full period, with half those amounts for a 6-month extension period. The sample project calculations show identical total costs of $1.9M for each full period and $950K for the extension, resulting in a Total Evaluated Price (TEP) of $10.45M. This is noted as being for evaluation purposes only and not representative of actual task order quantities. The spreadsheet corresponds to solicitation 47QFWA24R0017 for GSA Federal Acquisition Services with a total IDIQ ceiling of $100M.
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 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, 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 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) |
| Other Direct Costs (ODCs) | |
| ODCs NTE * Do not adjust | ODC Value - 5 Year Ordering Period |
| XXXXXXX | |
| Travel | |
| Travel NTE * Do not adjust | Travel Value - 5 Year Ordering Period |
| XXXXXXX |
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 | |
| Cyber Security Specialist | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 720 | |
| Hardware Engineer (Entry Level) | 2880 | $0.00 | 2880 | $0.00 | 2880 | $0.00 | 2880 | $0.00 | 2880 | $0.00 | 1440 | |
| Hardware Engineer (Journeyman) | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 1440 | $0.00 | 720 | |
| Program Manager | 1090 | $0.00 | 1090 | $0.00 | 1090 | $0.00 | 1090 | $0.00 | 1090 | $0.00 | 545 | |
| Project Manager | 3120 | $0.00 | 3120 | $0.00 | 3120 | $0.00 | 3120 | $0.00 | 3120 | $0.00 | 1560 | |
| Software Developer Applications (Journeyman) | 8160 | $0.00 | 8160 | $0.00 | 8160 | $0.00 | 8160 | $0.00 | 8160 | $0.00 | 4080 | |
| Software Developer, Systems Software (Journeyman) | 5760 | $0.00 | 5760 | $0.00 | 5760 | $0.00 | 5760 | $0.00 | 5760 | $0.00 | 2880 | |
| Systems Engineer | 12960 | $0.00 | 12960 | $0.00 | 12960 | $0.00 | 12960 | $0.00 | 12960 | $0.00 | 6480 | |
| 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 .