Attachment 1_Pricing Spreadsheet_12.27.2024.xlsx
XLSX spreadsheet 18 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 main sections: Tab A with labor categories and rates, and Tab B with a sample project pricing calculation. Tab A lists 42 labor categories including roles such as aerospace engineers, computer programmers, cybersecurity specialists, and various technicians, requiring offerors to provide fully burdened labor rates across a base period and four ordering periods.
Tab B provides a sample task order for evaluation purposes, featuring nine key labor categories with specified hours: Computer Programmer (5,520 hrs), Cybersecurity Specialist (1,440 hrs), Hardware Engineers (Entry/Journeyman), Program Manager (1,090 hrs), Project Manager (3,120 hrs), Software Developers, and Systems Engineer (12,960 hrs). The template includes Other Direct Costs ($1.6M per period) and Travel costs ($300K per period), with a six-month extension option under 52.217-8. The total evaluated price calculation structure spans the base period and four option periods, plus the extension period, leading to a total evaluated price of $10,450,000 for the sample project.
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) |
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 .